monetdb-java: src/main/java/nl/cwi/monetdb/util/SQLExporter.java annotate

author	Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
date	Fri, 13 Jan 2017 18:16:30 +0100 (2017-01-13)
parents	6f74e01c57da b9b35ca2eec2
children	89c285fc0a49

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 *
90 b9b35ca2eec2 Updated copyright year to 2017 in .java files and MonetDriver.java.in and build.xml and version.sh Martin van Dinther <martin.van.dinther@monetdbsolutions.com>* parents: 5 diff changeset	6 * Copyright 1997 - July 2008 CWI, August 2008 - 2017 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.util;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	10
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	11 import java.io.PrintWriter;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	12 import java.sql.DatabaseMetaData;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	13 import java.sql.ResultSet;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	14 import java.sql.ResultSetMetaData;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	15 import java.sql.SQLException;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	16 import java.sql.Types;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	17 import java.util.Iterator;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	18 import java.util.LinkedHashSet;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	19 import java.util.Map;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	20 import java.util.Set;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	21 import java.util.SortedMap;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	22 import java.util.Stack;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	23 import java.util.TreeMap;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	24
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	25 public class SQLExporter extends Exporter {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	26 private int outputMode;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	27 private Stack<String> lastSchema;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	28
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	29 public final static int TYPE_OUTPUT = 1;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	30 public final static int VALUE_INSERT = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	31 public final static int VALUE_COPY = 1;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	32 public final static int VALUE_TABLE = 2;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	33
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	34 public SQLExporter(PrintWriter out) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	35 super(out);
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
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	38 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	39 * A helper method to generate SQL CREATE code for a given table.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	40 * This method performs all required lookups to find all relations and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	41 * column information, as well as additional indices.
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 * @param dbmd a DatabaseMetaData object to query on (not null)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	44 * @param type the type of the object, e.g. VIEW, TABLE (not null)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	45 * @param catalog the catalog the object is in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	46 * @param schema the schema the object is in (not null)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	47 * @param name the table to describe in SQL CREATE format (not null)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	48 * @throws SQLException if a database related error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	49 */
67 87ba760038b6 More cleanup. About to start the tuple conversions. Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 38 diff changeset	50 public void dumpSchema(DatabaseMetaData dbmd, String type, String catalog, String schema, String name)
85 073ee535234b Ok. Now everything compiles back with Ant again. Moved the Embedded stuff to the temporary MonetDBJavaLite repository before moving into the suggested MonetDBLite repository. The soon generated Embedded Connection jar will have a dependency on the regular JDBC driver jar. The JDBC driver jar is independent, however if attempted to create an Embedded Connection with will try to load the respective class from the class loader, failing if the Embedded Connection jar is not present. If anyone in the group has expertise on Java Class dynamic loading, please contact me because there might be issues on this. Removed the pom.xml file because the regular maven compilation fails. Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 67 diff changeset	51 throws SQLException {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	52 assert dbmd != null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	53 assert type != null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	54 assert schema != null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	55 assert name != null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	56
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	57 String fqname = (!useSchema ? dq(schema) + "." : "") + dq(name);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	58
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	59 if (useSchema)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	60 changeSchema(schema);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	61
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	62 // handle views directly
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	63 if (type.contains("VIEW")) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	64 String[] types = new String[1];
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	65 types[0] = type;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	66 ResultSet tbl = dbmd.getTables(catalog, schema, name, types);
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	67 if (!tbl.next())
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	68 throw new SQLException("Whoops no meta data for view " + fqname);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	69
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	70 // This will probably only work for MonetDB
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	71 String remarks = tbl.getString("REMARKS"); // for MonetDB driver this contains the view definition
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	72 if (remarks == null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	73 out.println("-- invalid " + type + " " + fqname + ": no definition found");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	74 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	75 out.print("CREATE " + type + " " + fqname + " AS ");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	76 out.println(remarks.replaceFirst("create view [^ ]+ as", "").trim());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	77 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	78 return;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	79 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	80
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	81 int i;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	82 String s;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	83 out.println("CREATE " + type + " " + fqname + " (");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	84
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	85 // add all columns with their type, nullability and default definition
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	86 ResultSet cols = dbmd.getColumns(catalog, schema, name, null);
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	87 int colNmIndex = cols.findColumn("COLUMN_NAME");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	88 int colTypeNmIndex = cols.findColumn("TYPE_NAME");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	89
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	90 ResultSetMetaData rsmd = cols.getMetaData();
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	91 int colwidth = rsmd.getColumnDisplaySize(colNmIndex);
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	92 int typewidth = rsmd.getColumnDisplaySize(colTypeNmIndex);
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	93 if (typewidth < 13)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	94 typewidth = 13; // use minimal 13 characters for the typename (same as used in mclient)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	95
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	96 StringBuilder sb = new StringBuilder(128);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	97 for (i = 0; cols.next(); i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	98 if (i > 0) out.println(",");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	99
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	100 // print column name (with double quotes)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	101 s = dq(cols.getString(colNmIndex));
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	102 out.print("\t" + s + repeat(' ', (colwidth - s.length() + 3)));
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	103
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	104 int ctype = cols.getInt("DATA_TYPE");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	105 int size = cols.getInt("COLUMN_SIZE");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	106 int digits = cols.getInt("DECIMAL_DIGITS");
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	107 boolean isNotNull = cols.getInt("NULLABLE") == DatabaseMetaData.columnNoNulls;
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	108 String defaultValue = cols.getString("COLUMN_DEF");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	109 boolean hasDefault = (defaultValue != null && !defaultValue.isEmpty());
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	110
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	111 s = cols.getString(colTypeNmIndex).toUpperCase();
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	112 // do some data type substitutions to match SQL standard
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	113 switch (s) {
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	114 case "INT":
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	115 s = "INTEGER";
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	116 break;
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	117 case "SEC_INTERVAL":
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	118 s = "INTERVAL SECOND";
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	119 break;
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	120 case "MONTH_INTERVAL":
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	121 s = "INTERVAL MONTH";
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	122 break;
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	123 case "TIMETZ":
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	124 s = "TIME";
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	125 // small hack to get desired behaviour: set digits when we have
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	126 // a time with time zone and at the same time masking the internal types
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	127 digits = 1;
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	128 break;
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	129 case "TIMESTAMPTZ":
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	130 s = "TIMESTAMP";
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	131 // small hack to get desired behaviour: set digits when we have
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	132 // a timestamp with time zone and at the same time masking the internal types
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	133 digits = 1;
57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	134 break;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	135 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	136
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	137 sb.append(s); // add the data type for this column
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	138
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	139 // do some SQL/MonetDB type length/precision and scale specifics
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	140 switch (ctype) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	141 case Types.CHAR:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	142 case Types.VARCHAR:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	143 case Types.LONGVARCHAR:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	144 case Types.CLOB:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	145 case Types.BLOB:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	146 case Types.FLOAT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	147 if (size > 0)
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	148 sb.append('(').append(size).append(')');
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	149 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	150 case Types.TIME:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	151 case Types.TIMESTAMP:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	152 if (size > 1)
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	153 sb.append('(').append(size -1).append(')');
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	154 if (digits != 0)
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	155 sb.append(" WITH TIME ZONE");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	156 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	157 case Types.DECIMAL:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	158 case Types.NUMERIC:
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	159 sb.append('(').append(size);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	160 if (digits != 0)
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	161 sb.append(',').append(digits);
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	162 sb.append(')');
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	163 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	164 }
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	165 if (isNotNull \|\| hasDefault) {
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	166 int spaces = typewidth - sb.length();
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	167 if (spaces > 0)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	168 sb.append(repeat(' ', spaces));
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	169 if (isNotNull)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	170 sb.append(" NOT NULL");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	171 if (hasDefault)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	172 sb.append(" DEFAULT ").append(defaultValue);
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	173 }
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	174
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	175 // print column type, optional length and scale, optional Not NULL, optional default value
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	176 out.print(sb.toString());
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	177
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	178 sb.delete(0, sb.length()); // clear the stringbuffer for next column
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	179 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	180 cols.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	181
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	182 // add the primary key constraint definition
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	183 // unfortunately some idiot defined that getPrimaryKeys()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	184 // returns the primary key columns sorted by column name, not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	185 // key sequence order. So we have to sort ourself :(
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	186 cols = dbmd.getPrimaryKeys(catalog, schema, name);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	187 // first make an 'index' of the KEY_SEQ column
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	188 SortedMap<Integer, Integer> seqIndex = new TreeMap<>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	189 for (i = 1; cols.next(); i++) {
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	190 seqIndex.put(cols.getInt("KEY_SEQ"), i);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	191 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	192 if (seqIndex.size() > 0) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	193 // terminate the previous line
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	194 out.println(",");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	195 cols.absolute(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	196 out.print("\tCONSTRAINT " + dq(cols.getString("PK_NAME")) +
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	197 " PRIMARY KEY (");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	198 i = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	199 for (Iterator<Map.Entry<Integer, Integer>> it = seqIndex.entrySet().iterator();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	200 it.hasNext(); i++)
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 Map.Entry<Integer, Integer> e = it.next();
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	203 cols.absolute(e.getValue());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	204 if (i > 0)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	205 out.print(", ");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	206 out.print(dq(cols.getString("COLUMN_NAME")));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	207 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	208 out.print(")");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	209 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	210 cols.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	211
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	212 // add unique constraint definitions
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	213 cols = dbmd.getIndexInfo(catalog, schema, name, true, true);
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	214 int colIndexNm = cols.findColumn("INDEX_NAME");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	215 int colIndexColNm = cols.findColumn("COLUMN_NAME");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	216 while (cols.next()) {
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	217 String idxname = cols.getString(colIndexNm);
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	218 if (idxname != null) {
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	219 out.println(",");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	220 out.print("\tCONSTRAINT " + dq(idxname) + " UNIQUE (" +
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	221 dq(cols.getString(colIndexColNm)));
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	222
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	223 boolean next;
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	224 while ((next = cols.next()) &&
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	225 idxname.equals(cols.getString(colIndexNm))) {
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	226 out.print(", " + dq(cols.getString(colIndexColNm)));
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	227 }
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	228 // go back one, we've gone one too far
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	229 if (next)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	230 cols.previous();
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	231
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	232 out.print(")");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	233 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	234 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	235 cols.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	236
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	237 // add foreign keys definitions
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	238 cols = dbmd.getImportedKeys(catalog, schema, name);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	239 while (cols.next()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	240 out.println(",");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	241 out.print("\tCONSTRAINT " + dq(cols.getString("FK_NAME")) + " FOREIGN KEY (");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	242
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	243 boolean next;
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	244 Set<String> fk = new LinkedHashSet<>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	245 fk.add(cols.getString("FKCOLUMN_NAME").intern());
32 57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 5 diff changeset	246 Set<String> pk = new LinkedHashSet<>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	247 pk.add(cols.getString("PKCOLUMN_NAME").intern());
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 while ((next = cols.next()) &&
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	250 cols.getInt("KEY_SEQ") != 1)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	251 {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	252 fk.add(cols.getString("FKCOLUMN_NAME").intern());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	253 pk.add(cols.getString("PKCOLUMN_NAME").intern());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	254 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	255 // go back one
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	256 if (next)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	257 cols.previous();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	258
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	259 Iterator<String> it = fk.iterator();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	260 for (i = 0; it.hasNext(); i++) {
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	261 if (i > 0)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	262 out.print(", ");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	263 out.print(dq(it.next()));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	264 }
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	265 out.print(") REFERENCES " + dq(cols.getString("PKTABLE_SCHEM")) +
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	266 "." + dq(cols.getString("PKTABLE_NAME")) + " (");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	267 it = pk.iterator();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	268 for (i = 0; it.hasNext(); i++) {
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	269 if (i > 0)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	270 out.print(", ");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	271 out.print(dq(it.next()));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	272 }
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	273 out.print(")");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	274 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	275 cols.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	276 out.println();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	277 // end the create table statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	278 out.println(");");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	279
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	280 // create the non unique indexes defined for this table
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	281 cols = dbmd.getIndexInfo(catalog, schema, name, false, true);
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	282 colIndexNm = cols.findColumn("INDEX_NAME");
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	283 colIndexColNm = cols.findColumn("COLUMN_NAME");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	284 while (cols.next()) {
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	285 if (cols.getBoolean("NON_UNIQUE")) {
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	286 // We only process non-unique indexes here.
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	287 // The unique indexes are already covered as UNIQUE constraints in the CREATE TABLE above
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	288 String idxname = cols.getString(colIndexNm);
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	289 if (idxname != null) {
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	290 out.print("CREATE INDEX " + dq(idxname) + " ON " +
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	291 dq(cols.getString("TABLE_NAME")) + " (" +
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	292 dq(cols.getString(colIndexColNm)));
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	293
5 b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	294 boolean next;
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	295 while ((next = cols.next()) &&
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	296 idxname.equals(cols.getString(colIndexNm)))
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	297 {
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	298 out.print(", " + dq(cols.getString(colIndexColNm)));
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	299 }
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	300 // go back one
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	301 if (next)
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	302 cols.previous();
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	303
b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	304 out.println(");");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	305 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	306 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	307 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	308 cols.close();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	309 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	310
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	311 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	312 * Dumps the given ResultSet as specified in the form variable.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	313 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	314 * @param rs the ResultSet to dump
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	315 * @throws SQLException if a database error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	316 */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	317 public void dumpResultSet(ResultSet rs) throws SQLException {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	318 switch (outputMode) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	319 case VALUE_INSERT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	320 resultSetToSQL(rs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	321 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	322 case VALUE_COPY:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	323 resultSetToSQLDump(rs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	324 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	325 case VALUE_TABLE:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	326 resultSetToTable(rs);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	327 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	328 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	329 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	330
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	331 public void setProperty(int type, int value) throws Exception {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	332 switch (type) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	333 case TYPE_OUTPUT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	334 switch (value) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	335 case VALUE_INSERT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	336 case VALUE_COPY:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	337 case VALUE_TABLE:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	338 outputMode = value;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	339 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	340 default:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	341 throw new Exception("Illegal value " + value + " for TYPE_OUTPUT");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	342 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	343 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	344 default:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	345 throw new Exception("Illegal type " + type);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	346 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	347 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	348
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	349 public int getProperty(int type) throws Exception {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	350 switch (type) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	351 case TYPE_OUTPUT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	352 return outputMode;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	353 default:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	354 throw new Exception("Illegal type " + type);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	355 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	356 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	357
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	358 private final static int AS_IS = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	359 private final static int QUOTE = 1;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	360
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	361 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	362 * Helper method to dump the contents of a table in SQL INSERT INTO
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	363 * format.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	364 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	365 * @param rs the ResultSet to convert into INSERT INTO statements
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	366 * @throws SQLException if a database related error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	367 */
67 87ba760038b6 More cleanup. About to start the tuple conversions. Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 38 diff changeset	368 private void resultSetToSQL(ResultSet rs) throws SQLException {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	369 ResultSetMetaData rsmd = rs.getMetaData();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	370 String statement = "INSERT INTO ";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	371 if (!useSchema) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	372 String schema = rsmd.getSchemaName(1);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	373 if (schema != null && schema.length() > 0)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	374 statement += dq(schema) + ".";
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	375 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	376 statement += dq(rsmd.getTableName(1)) + " VALUES (";
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 int cols = rsmd.getColumnCount();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	379 short[] types = new short[cols +1];
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	380 for (int i = 1; i <= cols; i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	381 switch (rsmd.getColumnType(i)) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	382 case Types.CHAR:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	383 case Types.VARCHAR:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	384 case Types.LONGVARCHAR:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	385 case Types.CLOB:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	386 case Types.BLOB:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	387 case Types.DATE:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	388 case Types.TIME:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	389 case Types.TIMESTAMP:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	390 types[i] = QUOTE;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	391 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	392 case Types.NUMERIC:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	393 case Types.DECIMAL:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	394 case Types.BIT: // we don't use type BIT, it's here for completeness
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	395 case Types.BOOLEAN:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	396 case Types.TINYINT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	397 case Types.SMALLINT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	398 case Types.INTEGER:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	399 case Types.BIGINT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	400 case Types.REAL:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	401 case Types.FLOAT:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	402 case Types.DOUBLE:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	403 types[i] = AS_IS;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	404 break;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	405 default:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	406 types[i] = AS_IS;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	407 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	408 }
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 StringBuilder strbuf = new StringBuilder(1024);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	411 strbuf.append(statement);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	412 while (rs.next()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	413 for (int i = 1; i <= cols; i++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	414 String val = rs.getString(i);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	415 if (i > 1)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	416 strbuf.append(", ");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	417 if (val == null \|\| rs.wasNull()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	418 strbuf.append("NULL");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	419 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	420 strbuf.append((types[i] == QUOTE) ? q(val) : val);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	421 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	422 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	423 strbuf.append(");");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	424 out.println(strbuf.toString());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	425 // clear the variable part of the buffer contents for next data row
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	426 strbuf.setLength(statement.length());
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 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	429
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	430 public void resultSetToSQLDump(ResultSet rs) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	431 // TODO: write copy into statement
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 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	435 * Helper method to write a ResultSet in a convenient table format
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	436 * to the output writer.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	437 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	438 * @param rs the ResultSet to write out
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 public void resultSetToTable(ResultSet rs) throws SQLException {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	441 ResultSetMetaData md = rs.getMetaData();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	442 int cols = md.getColumnCount();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	443 // find the optimal display widths of the columns
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	444 int[] width = new int[cols + 1];
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	445 boolean[] isSigned = new boolean[cols + 1]; // used for controlling left or right alignment of data
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	446 for (int j = 1; j < width.length; j++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	447 int coldisplaysize = md.getColumnDisplaySize(j);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	448 int collabellength = md.getColumnLabel(j).length();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	449 int maxwidth = (coldisplaysize > collabellength) ? coldisplaysize : collabellength;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	450 // the minimum width should be 4 to represent: "NULL"
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	451 width[j] = (maxwidth > 4) ? maxwidth : 4;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	452 isSigned[j] = md.isSigned(j);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	453 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	454
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	455 // use a buffer to construct the text lines
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	456 StringBuilder strbuf = new StringBuilder(1024);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	457
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	458 // construct the frame lines and header text
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	459 strbuf.append('+');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	460 for (int j = 1; j < width.length; j++)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	461 strbuf.append(repeat('-', width[j] + 1) + "-+");
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 String outsideLine = strbuf.toString();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	464
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	465 strbuf.setLength(0); // clear the buffer
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	466 strbuf.append('\|');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	467 for (int j = 1; j < width.length; j++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	468 String colLabel = md.getColumnLabel(j);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	469 strbuf.append(' ');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	470 strbuf.append(colLabel);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	471 strbuf.append(repeat(' ', width[j] - colLabel.length()));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	472 strbuf.append(" \|");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	473 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	474 // print the header text
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	475 out.println(outsideLine);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	476 out.println(strbuf.toString());
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	477 out.println(outsideLine.replace('-', '='));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	478
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	479 // print formatted data of each row from resultset
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	480 long count = 0;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	481 for (; rs.next(); count++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	482 strbuf.setLength(0); // clear the buffer
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	483 strbuf.append('\|');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	484 for (int j = 1; j < width.length; j++) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	485 String data = rs.getString(j);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	486 if (data == null \|\| rs.wasNull()) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	487 data = "NULL";
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
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	490 int filler_length = width[j] - data.length();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	491 if (filler_length <= 0) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	492 if (filler_length == 0) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	493 strbuf.append(' ');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	494 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	495 strbuf.append(data);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	496 } else {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	497 strbuf.append(' ');
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	498 if (isSigned[j]) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	499 // we have a numeric type here, right align
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	500 strbuf.append(repeat(' ', filler_length));

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 *

90

b9b35ca2eec2 Updated copyright year to 2017 in *.java files and MonetDriver.java.in and build.xml and version.sh

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 5

diff changeset

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.util;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

10

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

11 import java.io.PrintWriter;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

12 import java.sql.DatabaseMetaData;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

13 import java.sql.ResultSet;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

14 import java.sql.ResultSetMetaData;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

15 import java.sql.SQLException;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

16 import java.sql.Types;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

17 import java.util.Iterator;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

18 import java.util.LinkedHashSet;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

19 import java.util.Map;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

20 import java.util.Set;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

21 import java.util.SortedMap;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

22 import java.util.Stack;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

23 import java.util.TreeMap;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

24

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

25 public class SQLExporter extends Exporter {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

26 private int outputMode;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

27 private Stack<String> lastSchema;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

28

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

29 public final static int TYPE_OUTPUT = 1;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

30 public final static int VALUE_INSERT = 0;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

31 public final static int VALUE_COPY = 1;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

32 public final static int VALUE_TABLE = 2;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

33

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

34 public SQLExporter(PrintWriter out) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

35 super(out);

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

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

38 /**

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

39 * A helper method to generate SQL CREATE code for a given table.

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

40 * This method performs all required lookups to find all relations and

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

41 * column information, as well as additional indices.

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 * @param dbmd a DatabaseMetaData object to query on (not null)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

44 * @param type the type of the object, e.g. VIEW, TABLE (not null)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

45 * @param catalog the catalog the object is in

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

46 * @param schema the schema the object is in (not null)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

47 * @param name the table to describe in SQL CREATE format (not null)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

48 * @throws SQLException if a database related error occurs

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

49 */

67

87ba760038b6 More cleanup. About to start the tuple conversions.

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 38

diff changeset

50 public void dumpSchema(DatabaseMetaData dbmd, String type, String catalog, String schema, String name)

85

073ee535234b Ok. Now everything compiles back with Ant again. Moved the Embedded stuff to the temporary MonetDBJavaLite repository before moving into the suggested MonetDBLite repository. The soon generated Embedded Connection jar will have a dependency on the regular JDBC driver jar. The JDBC driver jar is independent, however if attempted to create an Embedded Connection with will try to load the respective class from the class loader, failing if the Embedded Connection jar is not present. If anyone in the group has expertise on Java Class dynamic loading, please contact me because there might be issues on this. Removed the pom.xml file because the regular maven compilation fails.

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 67

diff changeset

51 throws SQLException {

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

52 assert dbmd != null;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

53 assert type != null;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

54 assert schema != null;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

55 assert name != null;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

56

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

57 String fqname = (!useSchema ? dq(schema) + "." : "") + dq(name);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

58

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

59 if (useSchema)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

60 changeSchema(schema);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

61

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

62 // handle views directly

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

63 if (type.contains("VIEW")) {

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

64 String[] types = new String[1];

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

65 types[0] = type;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

66 ResultSet tbl = dbmd.getTables(catalog, schema, name, types);

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

67 if (!tbl.next())

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

68 throw new SQLException("Whoops no meta data for view " + fqname);

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

69

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

70 // This will probably only work for MonetDB

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

71 String remarks = tbl.getString("REMARKS"); // for MonetDB driver this contains the view definition

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

72 if (remarks == null) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

73 out.println("-- invalid " + type + " " + fqname + ": no definition found");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

74 } else {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

75 out.print("CREATE " + type + " " + fqname + " AS ");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

76 out.println(remarks.replaceFirst("create view [^ ]+ as", "").trim());

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

77 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

78 return;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

79 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

80

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

81 int i;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

82 String s;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

83 out.println("CREATE " + type + " " + fqname + " (");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

84

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

85 // add all columns with their type, nullability and default definition

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

86 ResultSet cols = dbmd.getColumns(catalog, schema, name, null);

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

87 int colNmIndex = cols.findColumn("COLUMN_NAME");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

88 int colTypeNmIndex = cols.findColumn("TYPE_NAME");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

89

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

90 ResultSetMetaData rsmd = cols.getMetaData();

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

91 int colwidth = rsmd.getColumnDisplaySize(colNmIndex);

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

92 int typewidth = rsmd.getColumnDisplaySize(colTypeNmIndex);

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

93 if (typewidth < 13)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

94 typewidth = 13; // use minimal 13 characters for the typename (same as used in mclient)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

95

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

96 StringBuilder sb = new StringBuilder(128);

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

97 for (i = 0; cols.next(); i++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

98 if (i > 0) out.println(",");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

99

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

100 // print column name (with double quotes)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

101 s = dq(cols.getString(colNmIndex));

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

102 out.print("\t" + s + repeat(' ', (colwidth - s.length() + 3)));

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

103

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

104 int ctype = cols.getInt("DATA_TYPE");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

105 int size = cols.getInt("COLUMN_SIZE");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

106 int digits = cols.getInt("DECIMAL_DIGITS");

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

107 boolean isNotNull = cols.getInt("NULLABLE") == DatabaseMetaData.columnNoNulls;

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

108 String defaultValue = cols.getString("COLUMN_DEF");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

109 boolean hasDefault = (defaultValue != null && !defaultValue.isEmpty());

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

110

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

111 s = cols.getString(colTypeNmIndex).toUpperCase();

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

112 // do some data type substitutions to match SQL standard

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

113 switch (s) {

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

114 case "INT":

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

115 s = "INTEGER";

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

116 break;

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

117 case "SEC_INTERVAL":

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

118 s = "INTERVAL SECOND";

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

119 break;

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

120 case "MONTH_INTERVAL":

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

121 s = "INTERVAL MONTH";

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

122 break;

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

123 case "TIMETZ":

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

124 s = "TIME";

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

125 // small hack to get desired behaviour: set digits when we have

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

126 // a time with time zone and at the same time masking the internal types

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

127 digits = 1;

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

128 break;

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

129 case "TIMESTAMPTZ":

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

130 s = "TIMESTAMP";

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

131 // small hack to get desired behaviour: set digits when we have

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

132 // a timestamp with time zone and at the same time masking the internal types

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

133 digits = 1;

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

134 break;

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

135 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

136

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

137 sb.append(s); // add the data type for this column

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

138

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

139 // do some SQL/MonetDB type length/precision and scale specifics

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

140 switch (ctype) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

141 case Types.CHAR:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

142 case Types.VARCHAR:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

143 case Types.LONGVARCHAR:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

144 case Types.CLOB:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

145 case Types.BLOB:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

146 case Types.FLOAT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

147 if (size > 0)

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

148 sb.append('(').append(size).append(')');

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

149 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

150 case Types.TIME:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

151 case Types.TIMESTAMP:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

152 if (size > 1)

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

153 sb.append('(').append(size -1).append(')');

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

154 if (digits != 0)

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

155 sb.append(" WITH TIME ZONE");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

156 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

157 case Types.DECIMAL:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

158 case Types.NUMERIC:

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

159 sb.append('(').append(size);

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

160 if (digits != 0)

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

161 sb.append(',').append(digits);

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

162 sb.append(')');

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

163 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

164 }

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

165 if (isNotNull || hasDefault) {

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

166 int spaces = typewidth - sb.length();

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

167 if (spaces > 0)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

168 sb.append(repeat(' ', spaces));

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

169 if (isNotNull)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

170 sb.append(" NOT NULL");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

171 if (hasDefault)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

172 sb.append(" DEFAULT ").append(defaultValue);

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

173 }

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

174

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

175 // print column type, optional length and scale, optional Not NULL, optional default value

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

176 out.print(sb.toString());

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

177

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

178 sb.delete(0, sb.length()); // clear the stringbuffer for next column

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

179 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

180 cols.close();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

181

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

182 // add the primary key constraint definition

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

183 // unfortunately some idiot defined that getPrimaryKeys()

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

184 // returns the primary key columns sorted by column name, not

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

185 // key sequence order. So we have to sort ourself :(

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

186 cols = dbmd.getPrimaryKeys(catalog, schema, name);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

187 // first make an 'index' of the KEY_SEQ column

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

188 SortedMap<Integer, Integer> seqIndex = new TreeMap<>();

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

189 for (i = 1; cols.next(); i++) {

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

190 seqIndex.put(cols.getInt("KEY_SEQ"), i);

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

191 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

192 if (seqIndex.size() > 0) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

193 // terminate the previous line

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

194 out.println(",");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

195 cols.absolute(1);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

196 out.print("\tCONSTRAINT " + dq(cols.getString("PK_NAME")) +

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

197 " PRIMARY KEY (");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

198 i = 0;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

199 for (Iterator<Map.Entry<Integer, Integer>> it = seqIndex.entrySet().iterator();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

200 it.hasNext(); i++)

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 Map.Entry<Integer, Integer> e = it.next();

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

203 cols.absolute(e.getValue());

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

204 if (i > 0)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

205 out.print(", ");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

206 out.print(dq(cols.getString("COLUMN_NAME")));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

207 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

208 out.print(")");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

209 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

210 cols.close();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

211

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

212 // add unique constraint definitions

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

213 cols = dbmd.getIndexInfo(catalog, schema, name, true, true);

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

214 int colIndexNm = cols.findColumn("INDEX_NAME");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

215 int colIndexColNm = cols.findColumn("COLUMN_NAME");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

216 while (cols.next()) {

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

217 String idxname = cols.getString(colIndexNm);

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

218 if (idxname != null) {

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

219 out.println(",");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

220 out.print("\tCONSTRAINT " + dq(idxname) + " UNIQUE (" +

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

221 dq(cols.getString(colIndexColNm)));

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

222

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

223 boolean next;

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

224 while ((next = cols.next()) &&

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

225 idxname.equals(cols.getString(colIndexNm))) {

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

226 out.print(", " + dq(cols.getString(colIndexColNm)));

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

227 }

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

228 // go back one, we've gone one too far

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

229 if (next)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

230 cols.previous();

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

231

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

232 out.print(")");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

233 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

234 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

235 cols.close();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

236

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

237 // add foreign keys definitions

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

238 cols = dbmd.getImportedKeys(catalog, schema, name);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

239 while (cols.next()) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

240 out.println(",");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

241 out.print("\tCONSTRAINT " + dq(cols.getString("FK_NAME")) + " FOREIGN KEY (");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

242

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

243 boolean next;

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

244 Set<String> fk = new LinkedHashSet<>();

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

245 fk.add(cols.getString("FKCOLUMN_NAME").intern());

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

246 Set<String> pk = new LinkedHashSet<>();

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

247 pk.add(cols.getString("PKCOLUMN_NAME").intern());

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 while ((next = cols.next()) &&

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

250 cols.getInt("KEY_SEQ") != 1)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

251 {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

252 fk.add(cols.getString("FKCOLUMN_NAME").intern());

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

253 pk.add(cols.getString("PKCOLUMN_NAME").intern());

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

254 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

255 // go back one

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

256 if (next)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

257 cols.previous();

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

258

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

259 Iterator<String> it = fk.iterator();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

260 for (i = 0; it.hasNext(); i++) {

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

261 if (i > 0)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

262 out.print(", ");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

263 out.print(dq(it.next()));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

264 }

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

265 out.print(") REFERENCES " + dq(cols.getString("PKTABLE_SCHEM")) +

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

266 "." + dq(cols.getString("PKTABLE_NAME")) + " (");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

267 it = pk.iterator();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

268 for (i = 0; it.hasNext(); i++) {

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

269 if (i > 0)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

270 out.print(", ");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

271 out.print(dq(it.next()));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

272 }

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

273 out.print(")");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

274 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

275 cols.close();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

276 out.println();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

277 // end the create table statement

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

278 out.println(");");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

279

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

280 // create the non unique indexes defined for this table

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

281 cols = dbmd.getIndexInfo(catalog, schema, name, false, true);

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

282 colIndexNm = cols.findColumn("INDEX_NAME");

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

283 colIndexColNm = cols.findColumn("COLUMN_NAME");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

284 while (cols.next()) {

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

285 if (cols.getBoolean("NON_UNIQUE")) {

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

286 // We only process non-unique indexes here.

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

287 // The unique indexes are already covered as UNIQUE constraints in the CREATE TABLE above

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

288 String idxname = cols.getString(colIndexNm);

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

289 if (idxname != null) {

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

290 out.print("CREATE INDEX " + dq(idxname) + " ON " +

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

291 dq(cols.getString("TABLE_NAME")) + " (" +

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

292 dq(cols.getString(colIndexColNm)));

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

293

5

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

294 boolean next;

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

295 while ((next = cols.next()) &&

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

296 idxname.equals(cols.getString(colIndexNm)))

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

297 {

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

298 out.print(", " + dq(cols.getString(colIndexColNm)));

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

299 }

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

300 // go back one

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

301 if (next)

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

302 cols.previous();

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

303

b07b4940c3ed Improve output of table definition dump to match output of mclient table definition dump

Martin van Dinther <martin.van.dinther@monetdbsolutions.com>

parents: 0

diff changeset

304 out.println(");");

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

305 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

306 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

307 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

308 cols.close();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

309 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

310

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

311 /**

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

312 * Dumps the given ResultSet as specified in the form variable.

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

313 *

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

314 * @param rs the ResultSet to dump

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

315 * @throws SQLException if a database error occurs

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

316 */

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

317 public void dumpResultSet(ResultSet rs) throws SQLException {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

318 switch (outputMode) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

319 case VALUE_INSERT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

320 resultSetToSQL(rs);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

321 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

322 case VALUE_COPY:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

323 resultSetToSQLDump(rs);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

324 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

325 case VALUE_TABLE:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

326 resultSetToTable(rs);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

327 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

328 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

329 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

330

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

331 public void setProperty(int type, int value) throws Exception {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

332 switch (type) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

333 case TYPE_OUTPUT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

334 switch (value) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

335 case VALUE_INSERT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

336 case VALUE_COPY:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

337 case VALUE_TABLE:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

338 outputMode = value;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

339 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

340 default:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

341 throw new Exception("Illegal value " + value + " for TYPE_OUTPUT");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

342 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

343 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

344 default:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

345 throw new Exception("Illegal type " + type);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

346 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

347 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

348

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

349 public int getProperty(int type) throws Exception {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

350 switch (type) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

351 case TYPE_OUTPUT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

352 return outputMode;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

353 default:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

354 throw new Exception("Illegal type " + type);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

355 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

356 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

357

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

358 private final static int AS_IS = 0;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

359 private final static int QUOTE = 1;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

360

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

361 /**

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

362 * Helper method to dump the contents of a table in SQL INSERT INTO

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

363 * format.

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

364 *

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

365 * @param rs the ResultSet to convert into INSERT INTO statements

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

366 * @throws SQLException if a database related error occurs

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

367 */

67

87ba760038b6 More cleanup. About to start the tuple conversions.

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 38

diff changeset

368 private void resultSetToSQL(ResultSet rs) throws SQLException {

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

369 ResultSetMetaData rsmd = rs.getMetaData();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

370 String statement = "INSERT INTO ";

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

371 if (!useSchema) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

372 String schema = rsmd.getSchemaName(1);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

373 if (schema != null && schema.length() > 0)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

374 statement += dq(schema) + ".";

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

375 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

376 statement += dq(rsmd.getTableName(1)) + " VALUES (";

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 int cols = rsmd.getColumnCount();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

379 short[] types = new short[cols +1];

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

380 for (int i = 1; i <= cols; i++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

381 switch (rsmd.getColumnType(i)) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

382 case Types.CHAR:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

383 case Types.VARCHAR:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

384 case Types.LONGVARCHAR:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

385 case Types.CLOB:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

386 case Types.BLOB:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

387 case Types.DATE:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

388 case Types.TIME:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

389 case Types.TIMESTAMP:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

390 types[i] = QUOTE;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

391 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

392 case Types.NUMERIC:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

393 case Types.DECIMAL:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

394 case Types.BIT: // we don't use type BIT, it's here for completeness

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

395 case Types.BOOLEAN:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

396 case Types.TINYINT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

397 case Types.SMALLINT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

398 case Types.INTEGER:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

399 case Types.BIGINT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

400 case Types.REAL:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

401 case Types.FLOAT:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

402 case Types.DOUBLE:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

403 types[i] = AS_IS;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

404 break;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

405 default:

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

406 types[i] = AS_IS;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

407 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

408 }

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 StringBuilder strbuf = new StringBuilder(1024);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

411 strbuf.append(statement);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

412 while (rs.next()) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

413 for (int i = 1; i <= cols; i++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

414 String val = rs.getString(i);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

415 if (i > 1)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

416 strbuf.append(", ");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

417 if (val == null || rs.wasNull()) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

418 strbuf.append("NULL");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

419 } else {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

420 strbuf.append((types[i] == QUOTE) ? q(val) : val);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

421 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

422 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

423 strbuf.append(");");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

424 out.println(strbuf.toString());

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

425 // clear the variable part of the buffer contents for next data row

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

426 strbuf.setLength(statement.length());

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 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

429

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

430 public void resultSetToSQLDump(ResultSet rs) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

431 // TODO: write copy into statement

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 /**

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

435 * Helper method to write a ResultSet in a convenient table format

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

436 * to the output writer.

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

437 *

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

438 * @param rs the ResultSet to write out

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 public void resultSetToTable(ResultSet rs) throws SQLException {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

441 ResultSetMetaData md = rs.getMetaData();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

442 int cols = md.getColumnCount();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

443 // find the optimal display widths of the columns

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

444 int[] width = new int[cols + 1];

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

445 boolean[] isSigned = new boolean[cols + 1]; // used for controlling left or right alignment of data

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

446 for (int j = 1; j < width.length; j++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

447 int coldisplaysize = md.getColumnDisplaySize(j);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

448 int collabellength = md.getColumnLabel(j).length();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

449 int maxwidth = (coldisplaysize > collabellength) ? coldisplaysize : collabellength;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

450 // the minimum width should be 4 to represent: "NULL"

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

451 width[j] = (maxwidth > 4) ? maxwidth : 4;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

452 isSigned[j] = md.isSigned(j);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

453 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

454

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

455 // use a buffer to construct the text lines

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

456 StringBuilder strbuf = new StringBuilder(1024);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

457

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

458 // construct the frame lines and header text

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

459 strbuf.append('+');

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

460 for (int j = 1; j < width.length; j++)

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

461 strbuf.append(repeat('-', width[j] + 1) + "-+");

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 String outsideLine = strbuf.toString();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

464

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

465 strbuf.setLength(0); // clear the buffer

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

466 strbuf.append('|');

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

467 for (int j = 1; j < width.length; j++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

468 String colLabel = md.getColumnLabel(j);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

469 strbuf.append(' ');

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

470 strbuf.append(colLabel);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

471 strbuf.append(repeat(' ', width[j] - colLabel.length()));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

472 strbuf.append(" |");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

473 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

474 // print the header text

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

475 out.println(outsideLine);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

476 out.println(strbuf.toString());

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

477 out.println(outsideLine.replace('-', '='));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

478

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

479 // print formatted data of each row from resultset

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

480 long count = 0;

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

481 for (; rs.next(); count++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

482 strbuf.setLength(0); // clear the buffer

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

483 strbuf.append('|');

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

484 for (int j = 1; j < width.length; j++) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

485 String data = rs.getString(j);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

486 if (data == null || rs.wasNull()) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

487 data = "NULL";

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

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

490 int filler_length = width[j] - data.length();

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

491 if (filler_length <= 0) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

492 if (filler_length == 0) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

493 strbuf.append(' ');

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

494 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

495 strbuf.append(data);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

496 } else {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

497 strbuf.append(' ');

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

498 if (isSigned[j]) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

499 // we have a numeric type here, right align

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

500 strbuf.append(repeat(' ', filler_length));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

501 strbuf.append(data);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

502 } else {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

503 // all other left align

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

504 strbuf.append(data);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

505 strbuf.append(repeat(' ', filler_length));

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 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

508 strbuf.append(" |");

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 out.println(strbuf.toString());

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

511 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

512

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

513 // print the footer text

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

514 out.println(outsideLine);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

515 out.println(count + " row" + (count != 1 ? "s" : ""));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

516 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

517

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

518 private void changeSchema(String schema) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

519 if (lastSchema == null) {

32

57978db4ee57 Cleaned old code of the JDBC driver, fixed documentation

Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>

parents: 5

diff changeset

520 lastSchema = new Stack<>();

0

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

521 lastSchema.push(null);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

522 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

523

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

524 if (!schema.equals(lastSchema.peek())) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

525 if (!lastSchema.contains(schema)) {

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

526 // create schema

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

527 out.print("CREATE SCHEMA ");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

528 out.print(dq(schema));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

529 out.println(";\n");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

530 lastSchema.push(schema);

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

531 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

532

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

533 out.print("SET SCHEMA ");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

534 out.print(dq(schema));

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

535 out.println(";\n");

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

536 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

537 }

a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.

Sjoerd Mullender <sjoerd@acm.org>

parents:

diff changeset

538 }

Mercurial > hg > monetdb-java

annotate src/main/java/nl/cwi/monetdb/util/SQLExporter.java @ 102:08bc9009d190 embedded