monetdb-java: src/main/java/nl/cwi/monetdb/client/JdbcClient.java annotate

annotate src/main/java/nl/cwi/monetdb/client/JdbcClient.java @ 354:b1f8750e6cde

Switch to Java 8 compilation and distribution as Java 7 is no longer supported.

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Wed, 12 Feb 2020 18:23:58 +0100 (2020-02-12)
parents	54137aeb1f92
children	34ce6e1b1be8

rev	line source
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1 /*
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	2 * This Source Code Form is subject to the terms of the Mozilla Public
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	3 * License, v. 2.0. If a copy of the MPL was not distributed with this
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	4 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	5 *
350 54137aeb1f92 Update Copyright year. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 342 diff changeset	6 * Copyright 1997 - July 2008 CWI, August 2008 - 2020 MonetDB B.V.
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	7 */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	8
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	9 package nl.cwi.monetdb.client;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	10
70 17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	11 import nl.cwi.monetdb.util.CmdLineOpts;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	12 import nl.cwi.monetdb.util.Exporter;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	13 import nl.cwi.monetdb.util.OptionsException;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	14 import nl.cwi.monetdb.util.SQLExporter;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	15 import nl.cwi.monetdb.util.XMLExporter;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	16
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	17 import java.io.BufferedReader;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	18 import java.io.BufferedWriter;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	19 import java.io.IOException;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	20 import java.io.InputStreamReader;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	21 import java.io.File;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	22 import java.io.PrintWriter;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	23 import java.net.HttpURLConnection;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	24 import java.net.URL;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	25 import java.sql.Connection;
317 b80d92601b4b Restore initial loading of the MonetDriver class by the java.sql.DriverManager Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 316 diff changeset	26 import java.sql.DriverManager; // required as it will load the nl.cwi.monetdb.jdbc.MonetDriver class
70 17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	27 import java.sql.DatabaseMetaData;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	28 import java.sql.ResultSet;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	29 import java.sql.Statement;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	30 import java.sql.SQLException;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	31 import java.sql.SQLWarning;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	32 import java.util.ArrayList;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	33 import java.util.LinkedList;
17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	34 import java.util.List;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	35
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	36 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	37 * This program acts like an extended client program for MonetDB. Its
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	38 * look and feel is very much like PostgreSQL's interactive terminal
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	39 * program. Although it looks like this client is designed for MonetDB,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	40 * it demonstrates the power of the JDBC interface since it built on top
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	41 * of JDBC only.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	42 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	43 * @author Fabian Groffen, Martin van Dinther
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	44 * @version 1.4
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	45 */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	46
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	47 public final class JdbcClient {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	48
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	49 private static Connection con;
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	50 private static DatabaseMetaData dbmd;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	51 private static Statement stmt;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	52 private static BufferedReader in;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	53 private static PrintWriter out;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	54 private static Exporter exporter;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	55
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	56 /**
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	57 * JdbcClient is a command line query tool for MonetDB, similar to mclient.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	58 * It uses the JDBC API and the MonetDB JDBC driver to communicate with a
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	59 * MonetDB server. The MonetDB JDBC driver is included in the jdbcclient.jre8.jar
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	60 * for ease of use, so only 1 jar file is needed to use it.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	61 *
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	62 * <pre>Usage java -jar jdbcclient.jre8.jar
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	63 * [-h host[:port]] [-p port] [-f file] [-u user]
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	64 * [-l language] [-d database] [-e] [-D [table]] [-X<opt>]
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	65 * \| [--help] \| [--version]
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	66 * or using long option equivalents --host --port --file --user --language
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	67 * --dump --echo --database.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	68 * Arguments may be written directly after the option like -p50000.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	69 *
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	70 * If no host and port are given, localhost and 50000 are assumed.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	71 * An .monetdb file may exist in the user's home directory. This file can contain
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	72 * preferences to use each time JdbcClient is started. Options given on the
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	73 * command line override the preferences file. The .monetdb file syntax is
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	74 * <option>=<value> where option is one of the options host, port, file, mode
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	75 * debug, or password. Note that the last one is perilous and therefore not
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	76 * available as command line option.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	77 * If no input file is given using the -f flag, an interactive session is
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	78 * started on the terminal.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	79 *
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	80 * OPTIONS
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	81 * -h --host The hostname of the host that runs the MonetDB database. A port
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	82 * number can be supplied by use of a colon, i.e. -h somehost:12345.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	83 * -p --port The port number to connect to.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	84 * -f --file A file name to use either for reading or writing. The file will
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	85 * be used for writing when dump mode is used (-D --dump). In read
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	86 * mode, the file can also be an URL pointing to a plain text file
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	87 * that is optionally gzip compressed.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	88 * -u --user The username to use when connecting to the database.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	89 * -d --database Try to connect to the given database (only makes sense if
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	90 * connecting to monetdbd).
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	91 * -l --language Use the given language, defaults to 'sql'.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	92 * --help This help screen.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	93 * --version Display driver version and exit.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	94 * -e --echo Also outputs the contents of the input file, if any.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	95 * -q --quiet Suppress printing the welcome header.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	96 * -D --dump Dumps the given table(s), or the complete database if none given.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	97 * -Xoutput The output mode when dumping. Default is sql, xml may be used for
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	98 * an experimental XML output.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	99 * -Xhash Use the given hash algorithm during challenge response. Supported
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	100 * algorithm names: SHA1, MD5, plain.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	101 * -Xdebug Writes a transmission log to disk for debugging purposes. If a
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	102 * file name is given, it is used, otherwise a file called
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	103 * monet<timestamp>.log is created. A given file never be
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	104 * overwritten; instead a unique variation of the file is used.
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	105 * -Xbatching Indicates that a batch should be used instead of direct
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	106 * communication with the server for each statement. If a number is
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	107 * given, it is used as batch size. i.e. 8000 would execute the
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	108 * contents on the batch after each 8000 statements read. Batching
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	109 * can greatly speedup the process of restoring a database dump.</pre>
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	110 *
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	111 * @param args optional list of startup arguments
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	112 * @throws Exception if uncaught exception is thrown
83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	113 */
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	114 public final static void main(String[] args) throws Exception {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	115 final CmdLineOpts copts = new CmdLineOpts();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	116
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	117 // arguments which take exactly one argument
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	118 copts.addOption("h", "host", CmdLineOpts.CAR_ONE, "localhost",
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	119 "The hostname of the host that runs the MonetDB database. " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	120 "A port number can be supplied by use of a colon, i.e. " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	121 "-h somehost:12345.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	122 copts.addOption("p", "port", CmdLineOpts.CAR_ONE, "50000",
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	123 "The port number to connect to.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	124 // todo make it CAR_ONE_MANY
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	125 copts.addOption("f", "file", CmdLineOpts.CAR_ONE, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	126 "A file name to use either for reading or writing. The " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	127 "file will be used for writing when dump mode is used " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	128 "(-D --dump). In read mode, the file can also be an URL " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	129 "pointing to a plain text file that is optionally gzip " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	130 "compressed.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	131 copts.addOption("u", "user", CmdLineOpts.CAR_ONE, System.getProperty("user.name"),
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	132 "The username to use when connecting to the database.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	133 // this one is only here for the .monetdb file parsing, it is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	134 // removed before the command line arguments are parsed
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	135 copts.addOption(null, "password", CmdLineOpts.CAR_ONE, null, null);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	136 copts.addOption("d", "database", CmdLineOpts.CAR_ONE, "",
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	137 "Try to connect to the given database (only makes sense " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	138 "if connecting to monetdbd).");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	139 copts.addOption("l", "language", CmdLineOpts.CAR_ONE, "sql",
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	140 "Use the given language, defaults to 'sql'.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	141
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	142 // arguments which have no argument(s)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	143 copts.addOption(null, "help", CmdLineOpts.CAR_ZERO, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	144 "This help screen.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	145 copts.addOption(null, "version", CmdLineOpts.CAR_ZERO, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	146 "Display driver version and exit.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	147 copts.addOption("e", "echo", CmdLineOpts.CAR_ZERO, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	148 "Also outputs the contents of the input file, if any.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	149 copts.addOption("q", "quiet", CmdLineOpts.CAR_ZERO, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	150 "Suppress printing the welcome header.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	151
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	152 // arguments which have zero to many arguments
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	153 copts.addOption("D", "dump", CmdLineOpts.CAR_ZERO_MANY, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	154 "Dumps the given table(s), or the complete database if " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	155 "none given.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	156
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	157 // extended options
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	158 copts.addOption(null, "Xoutput", CmdLineOpts.CAR_ONE, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	159 "The output mode when dumping. Default is sql, xml may " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	160 "be used for an experimental XML output.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	161 copts.addOption(null, "Xhash", CmdLineOpts.CAR_ONE, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	162 "Use the given hash algorithm during challenge response. " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	163 "Supported algorithm names: SHA1, MD5, plain.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	164 // arguments which can have zero or one argument(s)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	165 copts.addOption(null, "Xdebug", CmdLineOpts.CAR_ZERO_ONE, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	166 "Writes a transmission log to disk for debugging purposes. " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	167 "If a file name is given, it is used, otherwise a file " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	168 "called monet<timestamp>.log is created. A given file " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	169 "never be overwritten; instead a unique variation of the " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	170 "file is used.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	171 copts.addOption(null, "Xbatching", CmdLineOpts.CAR_ZERO_ONE, null,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	172 "Indicates that a batch should be used instead of direct " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	173 "communication with the server for each statement. If a " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	174 "number is given, it is used as batch size. i.e. 8000 " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	175 "would execute the contents on the batch after each 8000 " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	176 "statements read. Batching can greatly speedup the " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	177 "process of restoring a database dump.");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	178
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	179 // we store user and password in separate variables in order to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	180 // be able to properly act on them like forgetting the password
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	181 // from the user's file if the user supplies a username on the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	182 // command line arguments
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	183 String pass = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	184 String user = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	185
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	186 // look for a file called .monetdb in the current dir or in the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	187 // user's homedir and read its preferences
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	188 File pref = new File(".monetdb");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	189 if (!pref.exists())
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	190 pref = new File(System.getProperty("user.home"), ".monetdb");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	191 if (pref.exists()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	192 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	193 copts.processFile(pref);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	194 } catch (OptionsException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	195 System.err.println("Error in " + pref.getAbsolutePath() + ": " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	196 System.exit(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	197 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	198 user = copts.getOption("user").getArgument();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	199 pass = copts.getOption("password").getArgument();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	200 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	201
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	202 // process the command line arguments, remove password option
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	203 // first, and save the user we had at this point
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	204 copts.removeOption("password");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	205 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	206 copts.processArgs(args);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	207 } catch (OptionsException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	208 System.err.println("Error: " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	209 System.exit(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	210 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	211 // we can actually compare pointers (objects) here
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	212 if (user != copts.getOption("user").getArgument())
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	213 pass = null;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	214
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	215 if (copts.getOption("help").isPresent()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	216 System.out.print(
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	217 "Usage java -jar jdbcclient.jre8.jar\n" +
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	218 "\t\t[-h host[:port]] [-p port] [-f file] [-u user]\n" +
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	219 "\t\t[-l language] [-d database] [-e] [-D [table]] [-X<opt>]\n" +
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	220 "\t\t\| [--help] \| [--version]\n" +
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	221 "or using long option equivalents --host --port --file --user --language\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	222 "--dump --echo --database.\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	223 "Arguments may be written directly after the option like -p50000.\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	224 "\n" +
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	225 "If no host and port are given, localhost and 50000 are assumed.\n" +
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	226 "An .monetdb file may exist in the user's home directory. This file can contain\n" +
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	227 "preferences to use each time JdbcClient is started. Options given on the\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	228 "command line override the preferences file. The .monetdb file syntax is\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	229 "<option>=<value> where option is one of the options host, port, file, mode\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	230 "debug, or password. Note that the last one is perilous and therefore not\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	231 "available as command line option.\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	232 "If no input file is given using the -f flag, an interactive session is\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	233 "started on the terminal.\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	234 "\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	235 "OPTIONS\n" +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	236 copts.produceHelpMessage()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	237 );
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	238 System.exit(0);
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	239 }
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	240
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	241 if (copts.getOption("version").isPresent()) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	242 // We cannot use the DatabaseMetaData here, because we
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	243 // cannot get a Connection. So instead, we just get the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	244 // values we want out of the Driver directly.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	245 System.out.println("JDBC Driver: v" + nl.cwi.monetdb.jdbc.MonetDriver.getDriverVersion());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	246 System.exit(0);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	247 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	248
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	249 // whether the semi-colon at the end of a String terminates the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	250 // query or not (default = yes => SQL)
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	251 final boolean scolonterm = true;
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	252 final boolean xmlMode = "xml".equals(copts.getOption("Xoutput").getArgument());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	253
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	254 // we need the password from the user, fetch it with a pseudo
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	255 // password protector
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	256 if (pass == null) {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	257 final char[] tmp = System.console().readPassword("password: ");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	258 if (tmp == null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	259 System.err.println("Invalid password!");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	260 System.exit(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	261 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	262 pass = String.valueOf(tmp);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	263 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	264
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	265 user = copts.getOption("user").getArgument();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	266
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	267 // build the hostname
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	268 String host = copts.getOption("host").getArgument();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	269 if (host.indexOf(":") == -1) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	270 host = host + ":" + copts.getOption("port").getArgument();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	271 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	272
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	273 // make sure the driver is loaded
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	274 // Class.forName("nl.cwi.monetdb.jdbc.MonetDriver"); // not needed anymore for self registering JDBC drivers
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	275
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	276 // build the extra arguments of the JDBC connect string
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	277 String attr = "?";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	278 CmdLineOpts.OptionContainer oc = copts.getOption("language");
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	279 final String lang = oc.getArgument();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	280 if (oc.isPresent())
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	281 attr += "language=" + lang + "&";
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	282
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	283 /* Xquery is no longer functional or supported
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	284 // set some behaviour based on the language XQuery
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	285 if (lang.equals("xquery")) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	286 scolonterm = false; // no ; to end a statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	287 if (!copts.getOption("Xoutput").isPresent())
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	288 xmlMode = true; // the user will like xml results, most probably
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	289 }
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	290 */
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	291 oc = copts.getOption("Xdebug");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	292 if (oc.isPresent()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	293 attr += "debug=true&";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	294 if (oc.getArgumentCount() == 1)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	295 attr += "logfile=" + oc.getArgument() + "&";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	296 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	297 oc = copts.getOption("Xhash");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	298 if (oc.isPresent())
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	299 attr += "hash=" + oc.getArgument() + "&";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	300
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	301 // request a connection suitable for MonetDB from the driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	302 // manager note that the database specifier is only used when
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	303 // connecting to a proxy-like service, since MonetDB itself
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	304 // can't access multiple databases.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	305 con = null;
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	306 final String database = copts.getOption("database").getArgument();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	307 try {
317 b80d92601b4b Restore initial loading of the MonetDriver class by the java.sql.DriverManager Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 316 diff changeset	308 con = DriverManager.getConnection(
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	309 "jdbc:monetdb://" + host + "/" + database + attr,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	310 user,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	311 pass
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	312 );
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	313 SQLWarning warn = con.getWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	314 while (warn != null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	315 System.err.println("Connection warning: " + warn.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	316 warn = warn.getNextWarning();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	317 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	318 con.clearWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	319 } catch (SQLException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	320 System.err.println("Database connect failed: " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	321 System.exit(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	322 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	323
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	324 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	325 dbmd = con.getMetaData();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	326 } catch (SQLException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	327 // we ignore this because it's probably because we don't use
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	328 // SQL language
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	329 dbmd = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	330 }
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	331
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	332 in = new BufferedReader(new InputStreamReader(System.in));
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	333 out = new PrintWriter(new BufferedWriter(new java.io.OutputStreamWriter(System.out)));
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	334
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	335 stmt = con.createStatement(); // is used by doDump
70 17fbaf2635bb Expand import java.. statements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	336
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	337 // see if we will have to perform a database dump (only in SQL mode)
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	338 if ("sql".equals(lang) && copts.getOption("dump").isPresent() && dbmd != null) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	339 // use the given file for writing
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	340 oc = copts.getOption("file");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	341 if (oc.isPresent())
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	342 out = new PrintWriter(new BufferedWriter(new java.io.FileWriter(oc.getArgument())));
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	343
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	344 // we only want user tables and views to be dumped, unless a specific table is requested
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	345 final String[] types = {"TABLE","VIEW","MERGE TABLE","REMOTE TABLE","REPLICA TABLE","STREAM TABLE"};
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	346 // Future: fetch all type names using dbmd.getTableTypes() and construct String[] with all
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	347 // table type names excluding the SYSTEM ... ones and LOCAL TEMPORARY TABLE ones.
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	348
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	349 // request the list of tables available in the current schema in the database
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	350 ResultSet tbl = dbmd.getTables(null, con.getSchema(), null,
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	351 (copts.getOption("dump").getArgumentCount() == 0) ? types : null);
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	352 // fetch all tables and store them in a LinkedList of Table objects
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	353 final LinkedList<Table> tables = new LinkedList<Table>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	354 while (tbl.next()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	355 tables.add(new Table(
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	356 tbl.getString(2), // 2 = "TABLE_SCHEM"
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	357 tbl.getString(3), // 3 = "TABLE_NAME"
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	358 tbl.getString(4))); // 4 = "TABLE_TYPE"
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	359 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	360 tbl.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	361 tbl = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	362
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	363 if (xmlMode) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	364 exporter = new XMLExporter(out);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	365 exporter.setProperty(XMLExporter.TYPE_NIL, XMLExporter.VALUE_XSI);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	366 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	367 exporter = new SQLExporter(out);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	368 // stick with SQL INSERT INTO commands for now
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	369 // in the future we might do COPY INTO's here using VALUE_COPY
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	370 exporter.setProperty(SQLExporter.TYPE_OUTPUT, SQLExporter.VALUE_INSERT);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	371 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	372 exporter.useSchemas(true);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	373
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	374 // start SQL output
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	375 if (!xmlMode)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	376 out.println("START TRANSACTION;\n");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	377
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	378 // dump specific table(s) or not?
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	379 if (copts.getOption("dump").getArgumentCount() > 0) { // yes we do
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	380 final String[] dumpers = copts.getOption("dump").getArguments();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	381 for (int i = 0; i < tables.size(); i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	382 Table ttmp = tables.get(i);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	383 for (int j = 0; j < dumpers.length; j++) {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	384 String dumptblnm = dumpers[j].toString();
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	385 if (ttmp.getName().equalsIgnoreCase(dumptblnm) \|\|
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	386 ttmp.getFqname().equalsIgnoreCase(dumptblnm))
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	387 {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	388 // dump the table
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	389 doDump(out, ttmp);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	390 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	391 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	392 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	393 } else {
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	394 /* this returns everything, so including SYSTEM TABLE constraints */
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	395 tbl = dbmd.getImportedKeys(null, null, null);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	396 while (tbl.next()) {
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	397 // find FK table object 6 = "FKTABLE_SCHEM", 7 = "FKTABLE_NAME"
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	398 Table fk = Table.findTable(tbl.getString(6), tbl.getString(7), tables);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	399
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	400 // find PK table object 2 = "PKTABLE_SCHEM", 3 = "PKTABLE_NAME"
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	401 Table pk = Table.findTable(tbl.getString(2), tbl.getString(3), tables);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	402
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	403 // this happens when a system table has referential constraints
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	404 if (fk == null \|\| pk == null)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	405 continue;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	406
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	407 // add PK table dependency to FK table
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	408 fk.addDependency(pk);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	409 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	410 tbl.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	411 tbl = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	412
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	413 // search for cycles of type a -> (x ->)+ b probably not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	414 // the most optimal way, but it works by just scanning
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	415 // every table for loops in a recursive manor
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	416 for (Table t : tables) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	417 Table.checkForLoop(t, new ArrayList<Table>());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	418 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	419
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	420 // find the graph, at this point we know there are no
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	421 // cycles, thus a solution exists
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	422 for (int i = 0; i < tables.size(); i++) {
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	423 final List<Table> needs = tables.get(i).requires(tables.subList(0, i + 1));
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	424 if (needs.size() > 0) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	425 tables.removeAll(needs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	426 tables.addAll(i, needs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	427
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	428 // re-evaluate this position, for there is a new
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	429 // table now
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	430 i--;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	431 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	432 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	433
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	434 // we now have the right order to dump tables
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	435 for (Table t : tables) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	436 // dump the table
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	437 doDump(out, t);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	438 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	439 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	440
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	441 if (!xmlMode)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	442 out.println("COMMIT;");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	443 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	444
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	445 // free resources, close the statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	446 stmt.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	447 // close the connection with the database
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	448 con.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	449 // completed database dump
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	450 System.exit(0);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	451 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	452
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	453 if (xmlMode) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	454 exporter = new XMLExporter(out);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	455 exporter.setProperty(XMLExporter.TYPE_NIL, XMLExporter.VALUE_XSI);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	456 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	457 exporter = new SQLExporter(out);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	458 // we want nice table formatted output
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	459 exporter.setProperty(SQLExporter.TYPE_OUTPUT, SQLExporter.VALUE_TABLE);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	460 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	461 exporter.useSchemas(false);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	462
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	463 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	464 // use the given file for reading
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	465 final boolean hasFile = copts.getOption("file").isPresent();
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	466 final boolean doEcho = hasFile && copts.getOption("echo").isPresent();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	467 if (hasFile) {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	468 final String tmp = copts.getOption("file").getArgument();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	469 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	470 in = getReader(tmp);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	471 } catch (Exception e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	472 System.err.println("Error: " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	473 System.exit(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	474 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	475
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	476 // check for batch mode
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	477 int batchSize = 0;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	478 oc = copts.getOption("Xbatching");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	479 if (oc.isPresent()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	480 if (oc.getArgumentCount() == 1) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	481 // parse the number
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	482 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	483 batchSize = Integer.parseInt(oc.getArgument());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	484 } catch (NumberFormatException ex) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	485 // complain to the user
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	486 throw new IllegalArgumentException("Illegal argument for Xbatching: " + oc.getArgument() + " is not a parseable number!");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	487 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	488 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	489 processBatch(batchSize);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	490 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	491 processInteractive(true, doEcho, scolonterm, user);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	492 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	493 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	494 if (!copts.getOption("quiet").isPresent()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	495 // print welcome message
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	496 out.println("Welcome to the MonetDB interactive JDBC terminal!");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	497 if (dbmd != null) {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	498 out.println("JDBC Driver: " + dbmd.getDriverName() +
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	499 " v" + dbmd.getDriverVersion());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	500 out.println("Database Server: " + dbmd.getDatabaseProductName() +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	501 " v" + dbmd.getDatabaseProductVersion());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	502 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	503 out.println("Current Schema: " + con.getSchema());
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	504 out.println("Type \\q to quit (you can also use: quit or exit), \\? or \\h for a list of available commands");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	505 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	506 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	507 processInteractive(false, doEcho, scolonterm, user);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	508 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	509
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	510 // free resources, close the statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	511 stmt.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	512 // close the connection with the database
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	513 con.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	514 // close the file (if we used a file)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	515 in.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	516 } catch (Exception e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	517 System.err.println("A fatal exception occurred: " + e.toString());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	518 e.printStackTrace(System.err);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	519 // at least try to close the connection properly, since it will
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	520 // close all statements associated with it
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	521 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	522 con.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	523 } catch (SQLException ex) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	524 // ok... nice try
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	525 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	526 System.exit(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	527 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	528 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	529
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	530 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	531 * Tries to interpret the given String as URL or file. Returns the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	532 * assigned BufferedReader, or throws an Exception if the given
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	533 * string couldn't be identified as a valid URL or file.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	534 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	535 * @param uri URL or filename as String
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	536 * @return a BufferedReader for the uri
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	537 * @throws Exception if uri cannot be identified as a valid URL or file
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	538 */
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	539 static BufferedReader getReader(final String uri) throws Exception {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	540 BufferedReader ret = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	541 URL u = null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	542
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	543 // Try and parse as URL first
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	544 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	545 u = new URL(uri);
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	546 } catch (java.net.MalformedURLException e) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	547 // no URL, try as file
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	548 try {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	549 ret = new BufferedReader(new java.io.FileReader(uri));
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	550 } catch (java.io.FileNotFoundException fnfe) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	551 // the message is descriptive enough, adds "(No such file
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	552 // or directory)" itself.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	553 throw new Exception(fnfe.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	554 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	555 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	556
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	557 if (ret == null) {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	558 try {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	559 HttpURLConnection.setFollowRedirects(true);
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	560 final HttpURLConnection con = (HttpURLConnection)u.openConnection();
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	561 con.setRequestMethod("GET");
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	562 final String ct = con.getContentType();
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	563 if ("application/x-gzip".equals(ct)) {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	564 // open gzip stream
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	565 ret = new BufferedReader(new InputStreamReader(
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	566 new java.util.zip.GZIPInputStream(con.getInputStream())));
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	567 } else {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	568 // text/plain otherwise just attempt to read as is
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	569 ret = new BufferedReader(new InputStreamReader(con.getInputStream()));
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	570 }
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	571 } catch (IOException e) {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	572 // failed to open the url
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	573 throw new Exception("No such host/file: " + e.getMessage());
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	574 } catch (Exception e) {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	575 // this is an exception that comes from deep ...
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	576 throw new Exception("Invalid URL: " + e.getMessage());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	577 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	578 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	579
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	580 return ret;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	581 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	582
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	583 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	584 * Starts an interactive processing loop, where output is adjusted to an
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	585 * user session. This processing loop is not suitable for bulk processing
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	586 * as in executing the contents of a file, since processing on the given
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	587 * input is done after each row that has been entered.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	588 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	589 * @param hasFile a boolean indicating whether a file is used as input
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	590 * @param doEcho a boolean indicating whether to echo the given input
194 1296dbcc4958 Resolved javadoc many errors and warnings, such as: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 169 diff changeset	591 * @param scolonterm whether a ';' makes this query part complete
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	592 * @param user a String representing the username of the current user
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	593 * @throws IOException if an IO exception occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	594 * @throws SQLException if a database related error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	595 */
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	596 private static void processInteractive(
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	597 final boolean hasFile,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	598 final boolean doEcho,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	599 final boolean scolonterm,
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	600 final String user)
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	601 throws IOException, SQLException
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	602 {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	603 // an SQL stack keeps track of ( " and '
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	604 final SQLStack stack = new SQLStack();
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	605 boolean lastac = false;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	606
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	607 if (!hasFile) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	608 lastac = con.getAutoCommit();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	609 out.println("auto commit mode: " + (lastac ? "on" : "off"));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	610 out.print(getPrompt(stack, true));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	611 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	612 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	613
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	614 String curLine;
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	615 String query = "";
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	616 boolean doProcess;
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	617 boolean wasComplete = true;
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	618
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	619 // the main (interactive) process loop
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	620 for (long i = 1; true; i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	621 // Manually read a line, because we want to detect an EOF
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	622 // (ctrl-D). Doing so allows to have a terminator for query
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	623 // which is not based on a special character, as is the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	624 // problem for XQuery
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	625 curLine = in.readLine();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	626 if (curLine == null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	627 out.println("");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	628 if (!query.isEmpty()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	629 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	630 executeQuery(query, stmt, out, !hasFile);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	631 } catch (SQLException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	632 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	633 do {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	634 if (hasFile) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	635 System.err.println("Error on line " + i + ": [" + e.getSQLState() + "] " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	636 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	637 System.err.println("Error [" + e.getSQLState() + "]: " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	638 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	639 // print all error messages in the chain (if any)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	640 } while ((e = e.getNextException()) != null);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	641 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	642 query = "";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	643 wasComplete = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	644 if (!hasFile) {
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	645 final boolean ac = con.getAutoCommit();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	646 if (ac != lastac) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	647 out.println("auto commit mode: " + (ac ? "on" : "off"));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	648 lastac = ac;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	649 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	650 out.print(getPrompt(stack, wasComplete));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	651 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	652 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	653 // try to read again
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	654 continue;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	655 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	656 // user did ctrl-D without something in the buffer,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	657 // so terminate
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	658 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	659 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	660 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	661
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	662 if (doEcho) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	663 out.println(curLine);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	664 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	665 }
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	666
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	667 // a query part is a line of an SQL query
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	668 QueryPart qp = scanQuery(curLine, stack, scolonterm);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	669 if (!qp.isEmpty()) {
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	670 final String command = qp.getQuery();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	671 doProcess = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	672 if (wasComplete) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	673 doProcess = false;
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	674 // check for commands only when the previous row was complete
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	675 if (command.equals("\\q") \|\| command.equals("quit") \|\| command.equals("exit")) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	676 // quit
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	677 break;
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	678 } else if (command.equals("\\?") \|\| command.equals("\\h")) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	679 out.println("Available commands:");
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	680 out.println("\\q quits this program (you can also use: quit or exit)");
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	681 if (dbmd != null) {
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	682 out.println("\\d list available user tables and views in current schema");
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	683 out.println("\\dS list available system tables and views in sys schema");
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	684 out.println("\\d <obj> describes the given table or view");
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	685 }
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	686 out.println("\\l<uri> executes the contents of the given file or URL");
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	687 out.println("\\i<uri> batch executes the inserts from the given file or URL");
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	688 out.println("\\? or \\h this help screen");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	689 } else if (dbmd != null && command.startsWith("\\d")) {
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	690 ResultSet tbl = null;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	691 try {
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	692 if (command.equals("\\dS")) {
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	693 // list available system tables and views in sys schema
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	694 tbl = dbmd.getTables(null, "sys", null, null);
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	695
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	696 // give us a list of all non-system tables and views (including temp ones)
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	697 while (tbl.next()) {
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	698 final String tableType = tbl.getString(4); // 4 = "TABLE_TYPE"
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	699 if (tableType != null && tableType.startsWith("SYSTEM ")) {
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	700 String tableNm = tbl.getString(3); // 3 = "TABLE_NAME"
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	701 if (tableNm.contains(" ") \|\| tableNm.contains("\t"))
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	702 tableNm = dq(tableNm);
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	703 out.println(tableType + "\t" +
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	704 tbl.getString(2) + "." + // 2 = "TABLE_SCHEM"
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	705 tableNm);
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	706 }
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	707 }
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	708 } else {
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	709 String object = command.substring(2).trim();
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	710 if (scolonterm && object.endsWith(";"))
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	711 object = object.substring(0, object.length() - 1);
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	712 if (object.isEmpty()) {
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	713 // list available user tables and views in current schema
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	714 tbl = dbmd.getTables(null, con.getSchema(), null, null);
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	715
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	716 // give us a list of all non-system tables and views (including temp ones)
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	717 while (tbl.next()) {
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	718 final String tableType = tbl.getString(4); // 4 = "TABLE_TYPE"
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	719 if (tableType != null && !tableType.startsWith("SYSTEM ")) {
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	720 String tableNm = tbl.getString(3); // 3 = "TABLE_NAME"
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	721 if (tableNm.contains(" ") \|\| tableNm.contains("\t"))
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	722 tableNm = dq(tableNm);
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	723 out.println(tableType + "\t" +
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	724 tbl.getString(2) + "." + // 2 = "TABLE_SCHEM"
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	725 tableNm);
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	726 }
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	727 }
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	728 } else {
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	729 // describes the given table or view
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	730 String schema;
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	731 String obj_nm = object;
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	732 int len;
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	733 boolean found = false;
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	734 final int dot = object.indexOf(".");
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	735 if (dot > 0) {
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	736 // use specified schema
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	737 schema = object.substring(0, dot);
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	738 obj_nm = object.substring(dot + 1);
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	739 // remove potential surrounding double quotes around schema name
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	740 len = schema.length();
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	741 if (len > 2 && schema.charAt(0) == '"' && schema.charAt(len -1) == '"')
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	742 schema = schema.substring(1, len -1);
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	743 } else {
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	744 // use current schema
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	745 schema = con.getSchema();
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	746 }
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	747 // remove potential surrounding double quotes around table or view name
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	748 len = obj_nm.length();
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	749 if (len > 2 && obj_nm.charAt(0) == '"' && obj_nm.charAt(len -1) == '"')
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	750 obj_nm = obj_nm.substring(1, len -1);
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	751
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	752 // System.err.println("calling dbmd.getTables(" + schema + ", " + obj_nm + ")");
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	753 tbl = dbmd.getTables(null, schema, obj_nm, null);
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	754 while (tbl.next() && !found) {
309 8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	755 final String schemaName = tbl.getString(2); // 2 = "TABLE_SCHEM"
8a96a4a13528 Add additional "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 308 diff changeset	756 final String tableName = tbl.getString(3); // 3 = "TABLE_NAME"
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	757 if (obj_nm.equals(tableName) && schema.equals(schemaName)) {
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	758 // we found it, describe it
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	759 exporter.dumpSchema(dbmd,
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	760 tbl.getString(4), // 4 = "TABLE_TYPE"
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	761 schemaName,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	762 tableName);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	763
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	764 found = true;
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	765 break;
928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	766 }
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	767 }
272 928df7febec4 Extend JdbcClient with support for some commands which also exist in mclient: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	768 if (!found)
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	769 System.err.println("No match found for table or view: " + object);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	770 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	771 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	772 } catch (SQLException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	773 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	774 do {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	775 System.err.println("Error [" + e.getSQLState() + "]: " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	776 // print all error messages in the chain (if any)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	777 } while ((e = e.getNextException()) != null);
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	778 } finally {
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	779 if (tbl != null)
296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	780 tbl.close();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	781 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	782 } else if (command.startsWith("\\l") \|\| command.startsWith("\\i")) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	783 String object = command.substring(2).trim();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	784 if (scolonterm && object.endsWith(";"))
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	785 object = object.substring(0, object.length() - 1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	786 if (object.isEmpty()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	787 System.err.println("Usage: '" + command.substring(0, 2) + "<uri>' where <uri> is a file or URL");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	788 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	789 // temporarily redirect input from in
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	790 final BufferedReader console = in;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	791 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	792 in = getReader(object);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	793 if (command.startsWith("\\l")) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	794 processInteractive(true, doEcho, scolonterm, user);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	795 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	796 processBatch(0);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	797 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	798 } catch (Exception e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	799 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	800 System.err.println("Error: " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	801 } finally {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	802 // put back in redirection
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	803 in = console;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	804 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	805 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	806 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	807 doProcess = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	808 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	809 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	810
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	811 if (doProcess) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	812 query += command + (qp.hasOpenQuote() ? "\\n" : " ");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	813 if (qp.isComplete()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	814 // strip off trailing ';'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	815 query = query.substring(0, query.length() - 2);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	816 // execute query
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	817 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	818 executeQuery(query, stmt, out, !hasFile);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	819 } catch (SQLException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	820 out.flush();
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	821 final String startmsg = (hasFile ? ("Error on line " + i + ": [") : "Error [");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	822 do {
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	823 System.err.println(startmsg + e.getSQLState() + "] " + e.getMessage());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	824 // print all error messages in the chain (if any)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	825 } while ((e = e.getNextException()) != null);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	826 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	827 query = "";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	828 wasComplete = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	829 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	830 wasComplete = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	831 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	832 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	833 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	834
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	835 if (!hasFile) {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	836 final boolean ac = con.getAutoCommit();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	837 if (ac != lastac) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	838 out.println("auto commit mode: " + (ac ? "on" : "off"));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	839 lastac = ac;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	840 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	841 out.print(getPrompt(stack, wasComplete));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	842 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	843 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	844 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	845 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	846
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	847 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	848 * Executes the given query and prints the result tabularised to the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	849 * given PrintWriter stream. The result of this method is the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	850 * default output of a query: tabular data.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	851 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	852 * @param query the query to execute
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	853 * @param stmt the Statement to execute the query on
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	854 * @param out the PrintWriter to write to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	855 * @param showTiming flag to specify if timing information nees to be printed
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	856 * @throws SQLException if a database related error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	857 */
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	858 private static void executeQuery(final String query,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	859 final Statement stmt,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	860 final PrintWriter out,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	861 final boolean showTiming)
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	862 throws SQLException
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	863 {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	864 // warnings generated during querying
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	865 SQLWarning warn;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	866 long startTime = (showTiming ? System.currentTimeMillis() : 0);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	867 long finishTime = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	868
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	869 // execute the query, let the driver decide what type it is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	870 int aff = -1;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	871 boolean nextRslt = stmt.execute(query, Statement.RETURN_GENERATED_KEYS);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	872 if (!nextRslt)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	873 aff = stmt.getUpdateCount();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	874 do {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	875 if (nextRslt) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	876 // we have a ResultSet, print it
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	877 final ResultSet rs = stmt.getResultSet();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	878
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	879 exporter.dumpResultSet(rs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	880 if (showTiming) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	881 finishTime = System.currentTimeMillis();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	882 out.println("Elapsed Time: " + (finishTime - startTime) + " ms");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	883 startTime = finishTime;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	884 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	885
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	886 // if there were warnings for this result,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	887 // show them!
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	888 warn = rs.getWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	889 if (warn != null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	890 // force stdout to be written so the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	891 // warning appears below it
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	892 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	893 do {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	894 System.err.println("ResultSet warning: " +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	895 warn.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	896 warn = warn.getNextWarning();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	897 } while (warn != null);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	898 rs.clearWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	899 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	900 rs.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	901 } else if (aff != -1) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	902 String timingoutput = "";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	903 if (showTiming) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	904 finishTime = System.currentTimeMillis();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	905 timingoutput = ". Elapsed Time: " + (finishTime - startTime) + " ms";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	906 startTime = finishTime;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	907 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	908
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	909 if (aff == Statement.SUCCESS_NO_INFO) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	910 out.println("Operation successful" + timingoutput);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	911 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	912 // we have an update count
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	913 // see if a key was generated
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	914 final ResultSet rs = stmt.getGeneratedKeys();
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	915 final boolean hasGeneratedKeyData = rs.next();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	916 out.println(aff + " affected row" + (aff != 1 ? "s" : "") +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	917 (hasGeneratedKeyData ? ", last generated key: " + rs.getString(1) : "") +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	918 timingoutput);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	919 rs.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	920 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	921 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	922
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	923 out.flush();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	924 } while ((nextRslt = stmt.getMoreResults()) \|\|
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	925 (aff = stmt.getUpdateCount()) != -1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	926
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	927 // if there were warnings for this statement,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	928 // and/or connection show them!
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	929 warn = stmt.getWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	930 while (warn != null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	931 System.err.println("Statement warning: " + warn.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	932 warn = warn.getNextWarning();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	933 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	934 stmt.clearWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	935
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	936 warn = con.getWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	937 while (warn != null) {
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	938 // suppress warning when issueing a "set schema xyz;" command
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	939 // if ( !(warn.getMessage()).equals("Server enabled auto commit mode while local state already was auto commit.") )
321 dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 317 diff changeset	940 System.err.println("Connection warning: " + warn.getMessage());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	941 warn = warn.getNextWarning();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	942 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	943 con.clearWarnings();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	944 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	945
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	946 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	947 * Starts a processing loop optimized for processing (large) chunks of
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	948 * continuous data, such as input from a file. Unlike in the interactive
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	949 * loop above, queries are sent only to the database if a certain batch
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	950 * amount is reached. No client side query checks are made, but everything
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	951 * is sent to the server as-is.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	952 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	953 * @param batchSize the number of items to store in the batch before
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	954 * sending them to the database for execution.
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	955 * @throws IOException if an IO exception occurs.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	956 */
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	957 private static void processBatch(final int batchSize) throws IOException {
316 d479475888e3 Replace StringBuilder methods sb.delete(0, sb.length()) with faster sb.setLength(0). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 315 diff changeset	958 final StringBuilder query = new StringBuilder(2048);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	959 int i = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	960 try {
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	961 String curLine;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	962 // the main loop
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	963 for (i = 1; (curLine = in.readLine()) != null; i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	964 query.append(curLine);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	965 if (curLine.endsWith(";")) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	966 // lousy check for end of statement, but in batch mode it
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	967 // is not very important to catch all end of statements...
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	968 stmt.addBatch(query.toString());
316 d479475888e3 Replace StringBuilder methods sb.delete(0, sb.length()) with faster sb.setLength(0). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 315 diff changeset	969 query.setLength(0); // clear the buffer
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	970 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	971 query.append('\n');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	972 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	973 if (batchSize > 0 && i % batchSize == 0) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	974 stmt.executeBatch();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	975 stmt.clearBatch();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	976 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	977 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	978 stmt.addBatch(query.toString());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	979 stmt.executeBatch();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	980 stmt.clearBatch();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	981 } catch (SQLException e) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	982 do {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	983 System.err.println("Error at line " + i + ": [" + e.getSQLState() + "] " + e.getMessage());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	984 // print all error messages in the chain (if any)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	985 } while ((e = e.getNextException()) != null);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	986 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	987 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	988
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	989 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	990 * Wrapper method that decides to dump SQL or XML. In the latter case,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	991 * this method does the XML data generation.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	992 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	993 * @param out a Writer to write the data to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	994 * @param table the table to dump
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	995 * @throws SQLException if a database related error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	996 */
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	997 private static void doDump(final PrintWriter out, final Table table) throws SQLException {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	998 final String tableType = table.getType();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	999
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1000 // dump CREATE definition of this table/view
315 4793f9b80bb3 Removed the catalog parameter from the Exporter.dumpSchema method as it is always null for MonetDB. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 310 diff changeset	1001 exporter.dumpSchema(dbmd, tableType, table.getSchem(), table.getName());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1002 out.println();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1003
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1004 // only dump data from real tables, not from views / MERGE / REMOTE / REPLICA tables
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1005 if (tableType.contains("TABLE")
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1006 && !tableType.equals("MERGE TABLE")
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1007 && !tableType.equals("REMOTE TABLE")
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1008 && !tableType.equals("REPLICA TABLE")) {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1009 final ResultSet rs = stmt.executeQuery("SELECT * FROM " + table.getFqnameQ());
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1010 if (rs != null) {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1011 exporter.dumpResultSet(rs);
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1012 rs.close();
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1013 out.println();
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1014 }
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1015 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1016 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1017
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1018 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1019 * Simple helper method that generates a prompt.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1020 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1021 * @param stack the current SQLStack
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1022 * @param compl whether the statement is complete
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1023 * @return a prompt which consist of "sql" plus the top of the stack
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1024 */
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1025 private static String getPrompt(final SQLStack stack, final boolean compl) {
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1026 return (compl ? "sql" : "more") + (stack.empty() ? ">" : stack.peek()) + " ";
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1027 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1028
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1029 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1030 * Scans the given string and tries to discover if it is a complete query
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1031 * or that there needs something to be added. If a string doesn't end with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1032 * a ; it is considered not to be complete. SQL string quotation using ' and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1033 * SQL identifier quotation using " is taken into account when scanning a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1034 * string this way.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1035 * Additionally, this method removes comments from the SQL statements,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1036 * identified by -- and removes white space where appropriate.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1037 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1038 * @param query the query to parse
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1039 * @param stack query stack to work with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1040 * @param scolonterm whether a ';' makes this query part complete
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1041 * @return a QueryPart object containing the results of this parse
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1042 */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1043 private static QueryPart scanQuery(
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1044 final String query,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1045 final SQLStack stack,
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1046 final boolean scolonterm)
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1047 {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1048 // examine string, char for char
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1049 boolean wasInString = (stack.peek() == '\'');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1050 boolean wasInIdentifier = (stack.peek() == '"');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1051 boolean escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1052 int len = query.length();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1053 for (int i = 0; i < len; i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1054 switch(query.charAt(i)) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1055 case '\\':
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1056 escaped = !escaped;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1057 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1058 default:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1059 escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1060 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1061 case '\'':
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1062 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1063 * We can not be in a string if we are in an identifier. So
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1064 * If we find a ' and are not in an identifier, and not in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1065 * a string we can safely assume we will be now in a string.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1066 * If we are in a string already, we should stop being in a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1067 * string if we find a quote which is not prefixed by a \,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1068 * for that would be an escaped quote. However, a nasty
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1069 * situation can occur where the string is like 'test \\'.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1070 * As obvious, a test for a \ in front of a ' doesn't hold
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1071 * here. Because 'test \\\'' can exist as well, we need to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1072 * know if a quote is prefixed by an escaping slash or not.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1073 */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1074 if (!escaped && stack.peek() != '"') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1075 if (stack.peek() != '\'') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1076 // although it makes no sense to escape a quote
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1077 // outside a string, it is escaped, thus not meant
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1078 // as quote for us, apparently
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1079 stack.push('\'');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1080 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1081 stack.pop();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1082 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1083 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1084 // reset escaped flag
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1085 escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1086 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1087 case '"':
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1088 if (!escaped && stack.peek() != '\'') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1089 if (stack.peek() != '"') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1090 stack.push('"');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1091 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1092 stack.pop();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1093 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1094 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1095 // reset escaped flag
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1096 escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1097 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1098 case '-':
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1099 if (!escaped && stack.peek() != '\'' && stack.peek() != '"' && i + 1 < len && query.charAt(i + 1) == '-') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1100 len = i;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1101 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1102 escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1103 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1104 case '(':
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1105 if (!escaped && stack.peek() != '\'' && stack.peek() != '"') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1106 stack.push('(');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1107 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1108 escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1109 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1110 case ')':
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1111 if (!escaped && stack.peek() == '(') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1112 stack.pop();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1113 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1114 escaped = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1115 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1116 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1117 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1118
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1119 int start = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1120 if (!wasInString && !wasInIdentifier && len > 0) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1121 // trim spaces at the start of the string
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1122 for (; start < len && Character.isWhitespace(query.charAt(start)); start++);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1123 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1124 int stop = len - 1;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1125 if (stack.peek() != '\'' && !wasInIdentifier && stop > start) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1126 // trim spaces at the end of the string
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1127 for (; stop >= start && Character.isWhitespace(query.charAt(stop)); stop--);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1128 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1129 stop++;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1130
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1131 if (start == stop) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1132 // we have an empty string
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1133 return new QueryPart(false, null, stack.peek() == '\'' \|\| stack.peek() == '"');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1134 } else if (stack.peek() == '\'' \|\| stack.peek() == '"') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1135 // we have an open quote
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1136 return new QueryPart(false, query.substring(start, stop), true);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1137 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1138 // see if the string is complete
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1139 if (scolonterm && query.charAt(stop - 1) == ';') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1140 return new QueryPart(true, query.substring(start, stop), false);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1141 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1142 return new QueryPart(false, query.substring(start, stop), false);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1143 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1144 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1145 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1146
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1147 static final String dq(final String in) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1148 return "\"" + in.replaceAll("\\\\", "\\\\\\\\").replaceAll("\"", "\\\\\"") + "\"";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1149 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1150 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1151
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1152 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1153 * A QueryPart is (a part of) a SQL query. In the QueryPart object information
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1154 * like the actual SQL query string, whether it has an open quote and the like
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1155 * is stored.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1156 */
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1157 final class QueryPart {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1158 private final boolean complete;
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1159 private final String query;
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1160 private final boolean open;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1161
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1162 QueryPart(final boolean complete, final String query, final boolean open) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1163 this.complete = complete;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1164 this.query = query;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1165 this.open = open;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1166 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1167
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1168 boolean isEmpty() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1169 return query == null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1170 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1171
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1172 boolean isComplete() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1173 return complete;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1174 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1175
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1176 String getQuery() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1177 return query;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1178 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1179
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1180 boolean hasOpenQuote() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1181 return open;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1182 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1183 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1184
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1185 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1186 * An SQLStack is a simple stack that keeps track of open brackets and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1187 * (single and double) quotes in an SQL query.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1188 */
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1189 final class SQLStack {
1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1190 final StringBuilder stack = new StringBuilder();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1191
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1192 char peek() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1193 if (empty()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1194 return '\0';
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1195 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1196 return stack.charAt(stack.length() - 1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1197 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1198 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1199
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1200 char pop() {
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1201 final char tmp = peek();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1202 if (tmp != '\0') {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1203 stack.setLength(stack.length() - 1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1204 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1205 return tmp;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1206 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1207
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1208 char push(char item) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1209 stack.append(item);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1210 return item;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1211 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1212
342 83c93be405b6 Add documentation for main method as it is used by javadoc. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 321 diff changeset	1213 boolean empty() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1214 return stack.length() == 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1215 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1216 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1217
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1218 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1219 * A Table represents an SQL table. All data required to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1220 * generate a fully qualified name is stored, as well as dependency
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1221 * data.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1222 */
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1223 final class Table {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1224 final String schem;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1225 final String name;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1226 final String type;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1227 final String fqname;
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1228 final ArrayList<Table> needs = new ArrayList<Table>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1229
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1230 Table(final String schem, final String name, final String type) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1231 this.schem = schem;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1232 this.name = name;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1233 this.type = type;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1234 this.fqname = schem + "." + name;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1235 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1236
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1237 void addDependency(final Table dependsOn) throws Exception {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1238 if (this.fqname.equals(dependsOn.fqname))
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	1239 throw new Exception("Cyclic dependency graphs are not supported (foreign key relation references self)");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1240
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1241 if (dependsOn.needs.contains(this))
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	1242 throw new Exception("Cyclic dependency graphs are not supported (foreign key relation a->b and b->a)");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1243
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1244 if (!needs.contains(dependsOn))
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1245 needs.add(dependsOn);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1246 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1247
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1248 List<Table> requires(final List<Table> existingTables) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1249 if (existingTables == null \|\| existingTables.isEmpty())
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1250 return new ArrayList<Table>(needs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1251
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1252 final ArrayList<Table> req = new ArrayList<Table>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1253 for (Table n : needs) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1254 if (!existingTables.contains(n))
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1255 req.add(n);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1256 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1257
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1258 return req;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1259 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1260
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1261 final String getSchem() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1262 return schem;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1263 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1264
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1265 final String getName() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1266 return name;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1267 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1268
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1269 final String getType() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1270 return type;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1271 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1272
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1273 final String getFqname() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1274 return fqname;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1275 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1276
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1277 final String getFqnameQ() {
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	1278 return JdbcClient.dq(schem) + "." + JdbcClient.dq(name);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1279 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1280
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1281 public final String toString() {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1282 return fqname;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1283 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1284
310 5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1285 static final Table findTable(final String schname, final String tblname, final List<Table> list) {
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1286 for (Table t : list) {
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1287 if (t.schem.equals(schname) && t.name.equals(tblname))
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 309 diff changeset	1288 return t;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1289 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1290 // not found
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1291 return null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1292 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1293
308 1948dbcd9991 Add "final" keyword to classes, method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 272 diff changeset	1294 static final void checkForLoop(final Table table, final List<Table> parents) throws Exception {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1295 parents.add(table);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1296 for (int i = 0; i < table.needs.size(); i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1297 Table child = table.needs.get(i);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1298 if (parents.contains(child))
169 296c4a16ef9f Updated JdbcClient with a number of small improvements, such corrected typo dependancy into dependency. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	1299 throw new Exception("Cyclic dependency graphs are not supported (cycle detected for " + child.fqname + ")");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1300 checkForLoop(child, parents);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1301 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1302 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1303 }

Mercurial > hg > monetdb-java

annotate src/main/java/nl/cwi/monetdb/client/JdbcClient.java @ 354:b1f8750e6cde