|
From: <man...@us...> - 2011-08-02 00:04:59
|
Revision: 6337
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6337&view=rev
Author: manningr
Date: 2011-08-02 00:04:52 +0000 (Tue, 02 Aug 2011)
Log Message:
-----------
relocated test.xml and fixed time type table.
Modified Paths:
--------------
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/all_types.sql
Added Paths:
-----------
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/test.xml
Removed Paths:
-------------
trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/dbmonster.properties
trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/test.xml
Deleted: trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/dbmonster.properties
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/dbmonster.properties 2011-08-02 00:03:01 UTC (rev 6336)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/dbmonster.properties 2011-08-02 00:04:52 UTC (rev 6337)
@@ -1,38 +0,0 @@
-#dbmonster.jdbc.driver=org.postgresql.Driver
-#dbmonster.jdbc.url=jdbc:postgresql://localhost:5432/dbcopytest
-#dbmonster.jdbc.username=dbcopy
-#dbmonster.jdbc.password=dbcopy
-
-#dbmonster.jdbc.driver=oracle.jdbc.OracleDriver
-#dbmonster.jdbc.url=jdbc:oracle:thin:@10.0.1.61:1521:orcl
-#dbmonster.jdbc.username=dbcopysrc
-#dbmonster.jdbc.password=password
-
-#dbmonster.jdbc.driver=com.ibm.db2.jcc.DB2Driver
-#dbmonster.jdbc.url=jdbc:db2://10.0.1.47:50000/DBCPSRC
-#dbmonster.jdbc.username=dbcopy
-#dbmonster.jdbc.password=password
-
-# No access to the dbcopysrc catalog for user dbcopy
-#dbmonster.jdbc.driver=com.mysql.jdbc.Driver
-#dbmonster.jdbc.url=jdbc:mysql://10.0.1.47:3306/dbcopysrc
-#dbmonster.jdbc.username=dbcopy
-#dbmonster.jdbc.password=password
-
-dbmonster.jdbc.driver=org.h2.Driver
-dbmonster.jdbc.url=jdbc:h2:tcp://10.0.1.30:9094/dbcopysrc
-dbmonster.jdbc.username=dbcopy
-dbmonster.jdbc.password=password
-
-# for Oracle and other schema enabled databases
-#dbmonster.jdbc.schema=public
-
-# maximal number of (re)tries
-dbmonster.max-tries=10
-
-# default rows number for SchemaGrabber
-dbmonster.rows=10
-
-# progres monitor class
-dbmonster.progress.monitor=pl.kernelpanic.dbmonster.ProgressMonitorAdapter
-
Deleted: trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/test.xml
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/test.xml 2011-08-02 00:03:01 UTC (rev 6336)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/test.xml 2011-08-02 00:04:52 UTC (rev 6337)
@@ -1,211 +0,0 @@
-<?xml version="1.0"?>
-<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
-<dbmonster-schema>
- <name>DBCOPYSRC</name>
- <table name="bigint_type_table" rows="2">
- <column name="bigint_column" databaseDefault="false">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="maxValue" value="9999999999999999"/>
- <property name="minValue" value="1111111111111111"/>
- <property name="nulls" value="1"/>
- <property name="returnedType" value="numeric"/>
- <property name="scale" value="0"/>
- </generator>
- </column>
- </table>
- <table name="binary_type_table" rows="2">
- <column name="binary_column" databaseDefault="false">
- <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
- <property name="file" value="src/test/resources/log4j.properties"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="blob_type_table" rows="2">
- <column name="blob_column" databaseDefault="false">
- <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
- <property name="file" value="src/test/resources/log4j.properties"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
-
- <table name="boolean_type_table" rows="2">
- <column name="boolean_column">
- <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="char_type_table" rows="2">
- <column name="char_column">
- <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
- <property name="minLength" value="100"/>
- <property name="maxLength" value="4000"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="clob_type_table" rows="2">
- <column name="clob_column">
- <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
- <property name="minLength" value="100"/>
- <property name="maxLength" value="2000"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="date_type_table" rows="2">
- <column name="date_column">
- <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
- <property name="nulls" value="1"/>
- <property name="returnedType" value="date"/>
- <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
- <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
- </generator>
- </column>
- </table>
- <table name="decimal_type_table" rows="2">
- <column name="decimal_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="1000000.99"/>
- <property name="returnedType" value="numeric"/>
- <property name="scale" value="2"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="double_type_table" rows="2">
- <column name="double_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="1000000"/>
- <property name="returnedType" value="double"/>
- <property name="scale" value="5"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="float_type_table" rows="2">
- <column name="float_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="1000000"/>
- <property name="returnedType" value="float"/>
- <property name="scale" value="5"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="integer_type_table" rows="2">
- <column name="integer_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="1000000"/>
- <property name="returnedType" value="integer"/>
- <property name="scale" value="0"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="longvarbinary_type_table" rows="2">
- <column name="longvarbinary_column" databaseDefault="false">
- <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
- <property name="file" value="src/test/resources/log4j.properties"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="longvarchar_type_table" rows="2">
- <column name="longvarchar_column">
- <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
- <property name="minLength" value="100"/>
- <property name="maxLength" value="2000"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="numeric_type_table" rows="2">
- <column name="numeric_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="1000000"/>
- <property name="returnedType" value="numeric"/>
- <property name="scale" value="0"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="real_type_table" rows="2">
- <column name="real_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="1000000"/>
- <property name="returnedType" value="float"/>
- <property name="scale" value="5"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="smallint_type_table" rows="2">
- <column name="smallint_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="32767"/>
- <property name="returnedType" value="integer"/>
- <property name="scale" value="0"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="time_type_table" rows="2">
- <column name="time_column">
- <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
- <property name="nulls" value="1"/>
- <property name="returnedType" value="timestamp"/>
- <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
- <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
- </generator>
- </column>
- </table>
-
- <table name="timestamp_type_table" rows="2">
- <column name="timestamp_column">
- <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
- <property name="nulls" value="1"/>
- <property name="returnedType" value="timestamp"/>
- <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
- <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
- </generator>
- </column>
- </table>
- <table name="tinyint_type_table" rows="2">
- <column name="tinyint_column">
- <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
- <property name="minValue" value="0"/>
- <property name="maxValue" value="255"/>
- <property name="returnedType" value="integer"/>
- <property name="scale" value="0"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="varbinary_type_table" rows="2">
- <column name="varbinary_column" databaseDefault="false">
- <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
- <property name="file" value="src/test/resources/log4j.properties"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
- <table name="varchar_type_table" rows="2">
- <column name="varchar_column">
- <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
- <property name="minLength" value="100"/>
- <property name="maxLength" value="2000"/>
- <property name="nulls" value="1"/>
- </generator>
- </column>
- </table>
-</dbmonster-schema>
Modified: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/all_types.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/all_types.sql 2011-08-02 00:03:01 UTC (rev 6336)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/all_types.sql 2011-08-02 00:04:52 UTC (rev 6337)
@@ -92,7 +92,7 @@
);
CREATE TABLE TIME_TYPE_TABLE
(
- TIME_COLUMN DATE
+ TIME_COLUMN TIMESTAMP(6)
);
CREATE TABLE TIMESTAMP_TYPE_TABLE
(
Copied: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/test.xml (from rev 6336, trunk/sql12/squirrelsql-integration-environment/src/test/resources/dbmonster/test.xml)
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/test.xml (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Oracle/test.xml 2011-08-02 00:04:52 UTC (rev 6337)
@@ -0,0 +1,211 @@
+<?xml version="1.0"?>
+<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
+<dbmonster-schema>
+ <name>DBCOPYSRC</name>
+ <table name="bigint_type_table" rows="2">
+ <column name="bigint_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="maxValue" value="9999999999999999"/>
+ <property name="minValue" value="1111111111111111"/>
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ </generator>
+ </column>
+ </table>
+ <table name="binary_type_table" rows="2">
+ <column name="binary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="blob_type_table" rows="2">
+ <column name="blob_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="boolean_type_table" rows="2">
+ <column name="boolean_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="char_type_table" rows="2">
+ <column name="char_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="4000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="clob_type_table" rows="2">
+ <column name="clob_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="date_type_table" rows="2">
+ <column name="date_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="date"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="decimal_type_table" rows="2">
+ <column name="decimal_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000.99"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="2"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="double_type_table" rows="2">
+ <column name="double_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="double"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="float_type_table" rows="2">
+ <column name="float_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="integer_type_table" rows="2">
+ <column name="integer_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarbinary_type_table" rows="2">
+ <column name="longvarbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarchar_type_table" rows="2">
+ <column name="longvarchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="numeric_type_table" rows="2">
+ <column name="numeric_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="real_type_table" rows="2">
+ <column name="real_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="smallint_type_table" rows="2">
+ <column name="smallint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="32767"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="time_type_table" rows="2">
+ <column name="time_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="timestamp_type_table" rows="2">
+ <column name="timestamp_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="tinyint_type_table" rows="2">
+ <column name="tinyint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="255"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varbinary_type_table" rows="2">
+ <column name="varbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varchar_type_table" rows="2">
+ <column name="varchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+</dbmonster-schema>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <man...@us...> - 2011-09-05 13:29:55
|
Revision: 6390
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6390&view=rev
Author: manningr
Date: 2011-09-05 13:29:44 +0000 (Mon, 05 Sep 2011)
Log Message:
-----------
New/updated test resources for DBCopy CLI external integration test.
Modified Paths:
--------------
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/all_types.sql
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/all_types.sql
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/all_types.sql
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/all_types.sql
Added Paths:
-----------
trunk/sql12/squirrelsql-integration-environment/src/test/resources/log4j.properties
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/DB2/drop.sql
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/test.xml
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/test.xml
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/test.xml
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/test.xml
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/generic/
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/generic/drop.sql
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/all_types.sql
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/test.xml
Removed Paths:
-------------
trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Hypersonic/
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/log4j.properties
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/log4j.properties (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/log4j.properties 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,15 @@
+log4j.rootLogger=DEBUG, CONSOLE
+
+log4j.appender.NULL=org.apache.log4j.varia.NullAppender
+log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
+
+log4j.logger.pl.kernelpanic.dbmonster.DBMonster=INFO, CONSOLE
+log4j.logger.pl.kernelpanic.dbmonster.SchemaGrabber=DEBUG, CONSOLE
+log4j.logger.pl.kernelpanic.dbmonster.test=INFO, CONSOLE
+log4j.logger.pl.kernelpanic.dbmonster.schema.Table=DEBUG, CONSOLE
+
+log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
+log4j.appender.CONSOLE.layout.ConversionPattern=%d %-5p %C{1} - %m%n
+
+log4j.appender.GUI.layout=org.apache.log4j.PatternLayout
+log4j.appender.GUI.layout.ConversionPattern=%d %-5p %C{1} - %m%n
\ No newline at end of file
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/DB2/drop.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/DB2/drop.sql (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/DB2/drop.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,22 @@
+DROP TABLE DBCPDST.DBCPDST.BIGINT_TYPE_TABLE;
+DROP TABLE DBCPDST.BINARY_TYPE_TABLE;
+DROP TABLE DBCPDST.BIT_TYPE_TABLE;
+DROP TABLE DBCPDST.BLOB_TYPE_TABLE;
+DROP TABLE DBCPDST.BOOLEAN_TYPE_TABLE;
+DROP TABLE DBCPDST.CHAR_TYPE_TABLE;
+DROP TABLE DBCPDST.CLOB_TYPE_TABLE;
+DROP TABLE DBCPDST.DATE_TYPE_TABLE;
+DROP TABLE DBCPDST.DECIMAL_TYPE_TABLE;
+DROP TABLE DBCPDST.DOUBLE_TYPE_TABLE;
+DROP TABLE DBCPDST.FLOAT_TYPE_TABLE;
+DROP TABLE DBCPDST.INTEGER_TYPE_TABLE;
+DROP TABLE DBCPDST.LONGVARBINARY_TYPE_TABLE;
+DROP TABLE DBCPDST.LONGVARCHAR_TYPE_TABLE;
+DROP TABLE DBCPDST.NUMERIC_TYPE_TABLE;
+DROP TABLE DBCPDST.REAL_TYPE_TABLE;
+DROP TABLE DBCPDST.SMALLINT_TYPE_TABLE;
+DROP TABLE DBCPDST.TIME_TYPE_TABLE;
+DROP TABLE DBCPDST.TIMESTAMP_TYPE_TABLE;
+DROP TABLE DBCPDST.TINYINT_TYPE_TABLE;
+DROP TABLE DBCPDST.VARBINARY_TYPE_TABLE;
+DROP TABLE DBCPDST.VARCHAR_TYPE_TABLE;
Modified: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/all_types.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/all_types.sql 2011-09-04 21:21:25 UTC (rev 6389)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/all_types.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -1,26 +1,132 @@
-drop table all_types;
-
-create table all_types (
-bigint_column bigint,
-binary_column char for bit data,
-bit_column smallint,
-blob_column blob,
-boolean_column smallint,
-char_column char(10),
-clob_column clob,
-date_column date,
-decimal_column decimal(31),
-double_column float(48),
-float_column float(48),
-integer_column int,
-longvarbinary_column long varchar for bit data,
-longvarchar_column long varchar,
-numeric_column bigint,
-real_column real,
-smallint_column smallint,
-time_column time,
-timestamp_column timestamp,
-tinyint_column smallint,
-varbinary_column long varchar for bit data,
-varchar_column varchar(4000)
-)
\ No newline at end of file
+DROP TABLE BIGINT_TYPE_TABLE;
+DROP TABLE BINARY_TYPE_TABLE;
+DROP TABLE BIT_TYPE_TABLE;
+DROP TABLE BLOB_TYPE_TABLE;
+DROP TABLE BOOLEAN_TYPE_TABLE;
+DROP TABLE CHAR_TYPE_TABLE;
+DROP TABLE CLOB_TYPE_TABLE;
+DROP TABLE DATE_TYPE_TABLE;
+DROP TABLE DECIMAL_TYPE_TABLE;
+DROP TABLE DOUBLE_TYPE_TABLE;
+DROP TABLE FLOAT_TYPE_TABLE;
+DROP TABLE INTEGER_TYPE_TABLE;
+DROP TABLE LONGVARBINARY_TYPE_TABLE;
+DROP TABLE LONGVARCHAR_TYPE_TABLE;
+DROP TABLE NUMERIC_TYPE_TABLE;
+DROP TABLE REAL_TYPE_TABLE;
+DROP TABLE SMALLINT_TYPE_TABLE;
+DROP TABLE TIME_TYPE_TABLE;
+DROP TABLE TIMESTAMP_TYPE_TABLE;
+DROP TABLE TINYINT_TYPE_TABLE;
+DROP TABLE VARBINARY_TYPE_TABLE;
+DROP TABLE VARCHAR_TYPE_TABLE;
+
+CREATE TABLE BIGINT_TYPE_TABLE
+(
+ BIGINT_COLUMN BIGINT
+);
+
+CREATE TABLE BINARY_TYPE_TABLE
+(
+ BINARY_COLUMN BLOB
+);
+
+CREATE TABLE BIT_TYPE_TABLE
+(
+ BIT_COLUMN SMALLINT
+);
+
+CREATE TABLE BLOB_TYPE_TABLE
+(
+ BLOB_COLUMN BLOB
+);
+
+CREATE TABLE BOOLEAN_TYPE_TABLE
+(
+ BOOLEAN_COLUMN SMALLINT
+);
+
+CREATE TABLE CHAR_TYPE_TABLE
+(
+ CHAR_COLUMN VARCHAR(4000)
+);
+
+CREATE TABLE CLOB_TYPE_TABLE
+(
+ CLOB_COLUMN clob(1073741823)
+);
+
+CREATE TABLE DATE_TYPE_TABLE
+(
+ DATE_COLUMN DATE
+);
+
+CREATE TABLE DECIMAL_TYPE_TABLE
+(
+ DECIMAL_COLUMN DECIMAL(31,10)
+);
+
+CREATE TABLE DOUBLE_TYPE_TABLE
+(
+ DOUBLE_COLUMN FLOAT(52)
+);
+
+CREATE TABLE FLOAT_TYPE_TABLE
+(
+ FLOAT_COLUMN FLOAT(52)
+);
+
+CREATE TABLE INTEGER_TYPE_TABLE
+(
+ INTEGER_COLUMN INT
+);
+
+CREATE TABLE LONGVARBINARY_TYPE_TABLE
+(
+ LONGVARBINARY_COLUMN BLOB(1073741823)
+);
+
+CREATE TABLE LONGVARCHAR_TYPE_TABLE
+(
+ LONGVARCHAR_COLUMN LONG VARCHAR
+);
+
+CREATE TABLE NUMERIC_TYPE_TABLE
+(
+ NUMERIC_COLUMN BIGINT
+);
+
+CREATE TABLE REAL_TYPE_TABLE
+(
+ REAL_COLUMN REAL
+);
+
+CREATE TABLE SMALLINT_TYPE_TABLE
+(
+ SMALLINT_COLUMN SMALLINT
+);
+
+CREATE TABLE TIME_TYPE_TABLE
+(
+ TIME_COLUMN TIME
+);
+
+CREATE TABLE TIMESTAMP_TYPE_TABLE
+(
+ TIMESTAMP_COLUMN TIMESTAMP
+);
+
+CREATE TABLE TINYINT_TYPE_TABLE
+(
+ TINYINT_COLUMN SMALLINT
+);
+
+CREATE TABLE VARBINARY_TYPE_TABLE
+(
+ VARBINARY_COLUMN BLOB
+);
+
+CREATE TABLE VARCHAR_TYPE_TABLE
+(
+ VARCHAR_COLUMN clob(1073741823)
+);
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/test.xml
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/test.xml (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Derby/test.xml 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,211 @@
+<?xml version="1.0"?>
+<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
+<dbmonster-schema>
+ <name>APP</name>
+ <table name="bigint_type_table" rows="2">
+ <column name="bigint_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="maxValue" value="9999999999999999"/>
+ <property name="minValue" value="1111111111111111"/>
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ </generator>
+ </column>
+ </table>
+ <table name="binary_type_table" rows="2">
+ <column name="binary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="blob_type_table" rows="2">
+ <column name="blob_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="boolean_type_table" rows="2">
+ <column name="boolean_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="char_type_table" rows="2">
+ <column name="char_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="4000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="clob_type_table" rows="2">
+ <column name="clob_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="date_type_table" rows="2">
+ <column name="date_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="date"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="decimal_type_table" rows="2">
+ <column name="decimal_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000.99"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="2"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="double_type_table" rows="2">
+ <column name="double_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="double"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="float_type_table" rows="2">
+ <column name="float_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="integer_type_table" rows="2">
+ <column name="integer_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarbinary_type_table" rows="2">
+ <column name="longvarbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarchar_type_table" rows="2">
+ <column name="longvarchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="numeric_type_table" rows="2">
+ <column name="numeric_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="real_type_table" rows="2">
+ <column name="real_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="smallint_type_table" rows="2">
+ <column name="smallint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="32767"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="time_type_table" rows="2">
+ <column name="time_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="time"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="timestamp_type_table" rows="2">
+ <column name="timestamp_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="tinyint_type_table" rows="2">
+ <column name="tinyint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="255"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varbinary_type_table" rows="2">
+ <column name="varbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varchar_type_table" rows="2">
+ <column name="varchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+</dbmonster-schema>
Modified: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/all_types.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/all_types.sql 2011-09-04 21:21:25 UTC (rev 6389)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/all_types.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -1,26 +1,3 @@
-DROP TABLE BIGINT_TYPE_TABLE;
-DROP TABLE BINARY_TYPE_TABLE;
-DROP TABLE BIT_TYPE_TABLE;
-DROP TABLE BLOB_TYPE_TABLE;
-DROP TABLE BOOLEAN_TYPE_TABLE;
-DROP TABLE CHAR_TYPE_TABLE;
-DROP TABLE CLOB_TYPE_TABLE;
-DROP TABLE DATE_TYPE_TABLE;
-DROP TABLE DECIMAL_TYPE_TABLE;
-DROP TABLE DOUBLE_TYPE_TABLE;
-DROP TABLE FLOAT_TYPE_TABLE;
-DROP TABLE INTEGER_TYPE_TABLE;
-DROP TABLE LONGVARBINARY_TYPE_TABLE;
-DROP TABLE LONGVARCHAR_TYPE_TABLE;
-DROP TABLE NUMERIC_TYPE_TABLE;
-DROP TABLE REAL_TYPE_TABLE;
-DROP TABLE SMALLINT_TYPE_TABLE;
-DROP TABLE TIME_TYPE_TABLE;
-DROP TABLE TIMESTAMP_TYPE_TABLE;
-DROP TABLE TINYINT_TYPE_TABLE;
-DROP TABLE VARBINARY_TYPE_TABLE;
-DROP TABLE VARCHAR_TYPE_TABLE;
-
CREATE TABLE BIGINT_TYPE_TABLE
(
BIGINT_COLUMN BIGINT
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/test.xml
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/test.xml (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/H2/test.xml 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,211 @@
+<?xml version="1.0"?>
+<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
+<dbmonster-schema>
+ <name>DBCOPYSRC</name>
+ <table name="bigint_type_table" rows="2">
+ <column name="bigint_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="maxValue" value="9999999999999999"/>
+ <property name="minValue" value="1111111111111111"/>
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ </generator>
+ </column>
+ </table>
+ <table name="binary_type_table" rows="2">
+ <column name="binary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="blob_type_table" rows="2">
+ <column name="blob_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="boolean_type_table" rows="2">
+ <column name="boolean_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="char_type_table" rows="2">
+ <column name="char_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="4000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="clob_type_table" rows="2">
+ <column name="clob_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="date_type_table" rows="2">
+ <column name="date_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="date"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="decimal_type_table" rows="2">
+ <column name="decimal_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000.99"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="2"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="double_type_table" rows="2">
+ <column name="double_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="double"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="float_type_table" rows="2">
+ <column name="float_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="integer_type_table" rows="2">
+ <column name="integer_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarbinary_type_table" rows="2">
+ <column name="longvarbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarchar_type_table" rows="2">
+ <column name="longvarchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="numeric_type_table" rows="2">
+ <column name="numeric_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="real_type_table" rows="2">
+ <column name="real_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="smallint_type_table" rows="2">
+ <column name="smallint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="32767"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="time_type_table" rows="2">
+ <column name="time_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="timestamp_type_table" rows="2">
+ <column name="timestamp_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="tinyint_type_table" rows="2">
+ <column name="tinyint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="255"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varbinary_type_table" rows="2">
+ <column name="varbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varchar_type_table" rows="2">
+ <column name="varchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+</dbmonster-schema>
Modified: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/all_types.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/all_types.sql 2011-09-04 21:21:25 UTC (rev 6389)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/all_types.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -1,113 +1,90 @@
-drop table dbcopysrc.bigint_type_table;
-drop table dbcopysrc.binary_type_table;
-drop table dbcopysrc.bit_type_table;
-drop table dbcopysrc.blob_type_table;
-drop table dbcopysrc.boolean_type_table;
-drop table dbcopysrc.char_type_table;
-drop table dbcopysrc.clob_type_table;
-drop table dbcopysrc.date_type_table;
-drop table dbcopysrc.decimal_type_table;
-drop table dbcopysrc.double_type_table;
-drop table dbcopysrc.float_type_table;
-drop table dbcopysrc.integer_type_table;
-drop table dbcopysrc.longvarbinary_type_table;
-drop table dbcopysrc.longvarchar_type_table;
-drop table dbcopysrc.numeric_type_table;
-drop table dbcopysrc.real_type_table;
-drop table dbcopysrc.smallint_type_table;
-drop table dbcopysrc.time_type_table;
-drop table dbcopysrc.timestamp_type_table;
-drop table dbcopysrc.tinyint_type_table;
-drop table dbcopysrc.varbinary_type_table;
-drop table dbcopysrc.varchar_type_table;
-
-
-CREATE TABLE dbcopysrc.bigint_type_table
-(
- bigint_column bigint
-);
-CREATE TABLE dbcopysrc.binary_type_table
-(
- binary_column blob
-);
-CREATE TABLE dbcopysrc.bit_type_table
-(
- bit_column bit
-);
-CREATE TABLE dbcopysrc.blob_type_table
-(
- blob_column blob
-);
-CREATE TABLE dbcopysrc.boolean_type_table
-(
- boolean_column bool
-);
-CREATE TABLE dbcopysrc.char_type_table
-(
- char_column char(255)
-);
-CREATE TABLE dbcopysrc.clob_type_table
-(
- clob_column longtext
-);
-CREATE TABLE dbcopysrc.date_type_table
-(
- date_column date
-);
-CREATE TABLE dbcopysrc.decimal_type_table
-(
- decimal_column decimal(38)
-);
-CREATE TABLE dbcopysrc.double_type_table
-(
- double_column float(53)
-);
-CREATE TABLE dbcopysrc.float_type_table
-(
- float_column float(53)
-);
-CREATE TABLE dbcopysrc.integer_type_table
-(
- integer_column int
-);
-CREATE TABLE dbcopysrc.longvarbinary_type_table
-(
- longvarbinary_column blob
-);
-CREATE TABLE dbcopysrc.longvarchar_type_table
-(
- longvarchar_column text
-);
-CREATE TABLE dbcopysrc.numeric_type_table
-(
- numeric_column numeric(38)
-);
-CREATE TABLE dbcopysrc.real_type_table
-(
- real_column real
-);
-CREATE TABLE dbcopysrc.smallint_type_table
-(
- smallint_column smallint
-);
-CREATE TABLE dbcopysrc.time_type_table
-(
- time_column time
-);
-CREATE TABLE dbcopysrc.timestamp_type_table
-(
- timestamp_column timestamp
-);
-CREATE TABLE dbcopysrc.tinyint_type_table
-(
- tinyint_column int
-);
-CREATE TABLE dbcopysrc.varbinary_type_table
-(
- varbinary_column blob
-);
-CREATE TABLE dbcopysrc.varchar_type_table
-(
- varchar_column text
-);
-
+
+CREATE TABLE dbcopysrc.bigint_type_table
+(
+ bigint_column bigint
+);
+CREATE TABLE dbcopysrc.binary_type_table
+(
+ binary_column blob
+);
+CREATE TABLE dbcopysrc.bit_type_table
+(
+ bit_column bit
+);
+CREATE TABLE dbcopysrc.blob_type_table
+(
+ blob_column blob
+);
+CREATE TABLE dbcopysrc.boolean_type_table
+(
+ boolean_column bool
+);
+CREATE TABLE dbcopysrc.char_type_table
+(
+ char_column char(255)
+);
+CREATE TABLE dbcopysrc.clob_type_table
+(
+ clob_column longtext
+);
+CREATE TABLE dbcopysrc.date_type_table
+(
+ date_column date
+);
+CREATE TABLE dbcopysrc.decimal_type_table
+(
+ decimal_column decimal(38)
+);
+CREATE TABLE dbcopysrc.double_type_table
+(
+ double_column float(53)
+);
+CREATE TABLE dbcopysrc.float_type_table
+(
+ float_column float(53)
+);
+CREATE TABLE dbcopysrc.integer_type_table
+(
+ integer_column int
+);
+CREATE TABLE dbcopysrc.longvarbinary_type_table
+(
+ longvarbinary_column blob
+);
+CREATE TABLE dbcopysrc.longvarchar_type_table
+(
+ longvarchar_column text
+);
+CREATE TABLE dbcopysrc.numeric_type_table
+(
+ numeric_column numeric(38)
+);
+CREATE TABLE dbcopysrc.real_type_table
+(
+ real_column real
+);
+CREATE TABLE dbcopysrc.smallint_type_table
+(
+ smallint_column smallint
+);
+CREATE TABLE dbcopysrc.time_type_table
+(
+ time_column time
+);
+CREATE TABLE dbcopysrc.timestamp_type_table
+(
+ timestamp_column timestamp
+);
+CREATE TABLE dbcopysrc.tinyint_type_table
+(
+ tinyint_column int
+);
+CREATE TABLE dbcopysrc.varbinary_type_table
+(
+ varbinary_column blob
+);
+CREATE TABLE dbcopysrc.varchar_type_table
+(
+ varchar_column text
+);
+
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/test.xml
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/test.xml (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/MySQL/test.xml 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,211 @@
+<?xml version="1.0"?>
+<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
+<dbmonster-schema>
+ <name>DBCOPYSRC</name>
+ <table name="bigint_type_table" rows="2">
+ <column name="bigint_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="maxValue" value="9999999999999999"/>
+ <property name="minValue" value="1111111111111111"/>
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ </generator>
+ </column>
+ </table>
+ <table name="binary_type_table" rows="2">
+ <column name="binary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="blob_type_table" rows="2">
+ <column name="blob_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="boolean_type_table" rows="2">
+ <column name="boolean_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="char_type_table" rows="2">
+ <column name="char_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="4000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="clob_type_table" rows="2">
+ <column name="clob_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="date_type_table" rows="2">
+ <column name="date_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="date"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="decimal_type_table" rows="2">
+ <column name="decimal_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000.99"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="2"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="double_type_table" rows="2">
+ <column name="double_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="double"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="float_type_table" rows="2">
+ <column name="float_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="integer_type_table" rows="2">
+ <column name="integer_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarbinary_type_table" rows="2">
+ <column name="longvarbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarchar_type_table" rows="2">
+ <column name="longvarchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="numeric_type_table" rows="2">
+ <column name="numeric_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="real_type_table" rows="2">
+ <column name="real_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="smallint_type_table" rows="2">
+ <column name="smallint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="32767"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="time_type_table" rows="2">
+ <column name="time_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="timestamp_type_table" rows="2">
+ <column name="timestamp_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="tinyint_type_table" rows="2">
+ <column name="tinyint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="255"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varbinary_type_table" rows="2">
+ <column name="varbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varchar_type_table" rows="2">
+ <column name="varchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+</dbmonster-schema>
Modified: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/all_types.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/all_types.sql 2011-09-04 21:21:25 UTC (rev 6389)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/all_types.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -1,27 +1,3 @@
-DROP TABLE BIGINT_TYPE_TABLE;
-DROP TABLE BINARY_TYPE_TABLE;
-DROP TABLE BIT_TYPE_TABLE;
-DROP TABLE BLOB_TYPE_TABLE;
-DROP TABLE BOOLEAN_TYPE_TABLE;
-DROP TABLE CHAR_TYPE_TABLE;
-DROP TABLE CLOB_TYPE_TABLE;
-DROP TABLE DATE_TYPE_TABLE;
-DROP TABLE DECIMAL_TYPE_TABLE;
-DROP TABLE DOUBLE_TYPE_TABLE;
-DROP TABLE FLOAT_TYPE_TABLE;
-DROP TABLE INTEGER_TYPE_TABLE;
-DROP TABLE LONGVARBINARY_TYPE_TABLE;
-DROP TABLE LONGVARCHAR_TYPE_TABLE;
-DROP TABLE NUMERIC_TYPE_TABLE;
-DROP TABLE REAL_TYPE_TABLE;
-DROP TABLE SMALLINT_TYPE_TABLE;
-DROP TABLE TIME_TYPE_TABLE;
-DROP TABLE TIMESTAMP_TYPE_TABLE;
-DROP TABLE TINYINT_TYPE_TABLE;
-DROP TABLE VARBINARY_TYPE_TABLE;
-DROP TABLE VARCHAR_TYPE_TABLE;
-
-
CREATE TABLE BIGINT_TYPE_TABLE
(
BIGINT_COLUMN BIGINT
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/test.xml
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/test.xml (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/Pointbase/test.xml 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,211 @@
+<?xml version="1.0"?>
+<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
+<dbmonster-schema>
+ <name>DBCOPYSRC</name>
+ <table name="bigint_type_table" rows="2">
+ <column name="bigint_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="maxValue" value="9999999999999999"/>
+ <property name="minValue" value="1111111111111111"/>
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ </generator>
+ </column>
+ </table>
+ <table name="binary_type_table" rows="2">
+ <column name="binary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="blob_type_table" rows="2">
+ <column name="blob_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="boolean_type_table" rows="2">
+ <column name="boolean_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="char_type_table" rows="2">
+ <column name="char_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="4000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="clob_type_table" rows="2">
+ <column name="clob_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="date_type_table" rows="2">
+ <column name="date_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="date"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="decimal_type_table" rows="2">
+ <column name="decimal_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000.99"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="2"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="double_type_table" rows="2">
+ <column name="double_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="double"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="float_type_table" rows="2">
+ <column name="float_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="integer_type_table" rows="2">
+ <column name="integer_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarbinary_type_table" rows="2">
+ <column name="longvarbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarchar_type_table" rows="2">
+ <column name="longvarchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="numeric_type_table" rows="2">
+ <column name="numeric_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="real_type_table" rows="2">
+ <column name="real_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="smallint_type_table" rows="2">
+ <column name="smallint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="32767"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="time_type_table" rows="2">
+ <column name="time_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="timestamp_type_table" rows="2">
+ <column name="timestamp_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="timestamp"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="tinyint_type_table" rows="2">
+ <column name="tinyint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="255"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varbinary_type_table" rows="2">
+ <column name="varbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="varchar_type_table" rows="2">
+ <column name="varchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+</dbmonster-schema>
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/generic/drop.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/generic/drop.sql (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/generic/drop.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,22 @@
+DROP TABLE BIGINT_TYPE_TABLE;
+DROP TABLE BINARY_TYPE_TABLE;
+DROP TABLE BIT_TYPE_TABLE;
+DROP TABLE BLOB_TYPE_TABLE;
+DROP TABLE BOOLEAN_TYPE_TABLE;
+DROP TABLE CHAR_TYPE_TABLE;
+DROP TABLE CLOB_TYPE_TABLE;
+DROP TABLE DATE_TYPE_TABLE;
+DROP TABLE DECIMAL_TYPE_TABLE;
+DROP TABLE DOUBLE_TYPE_TABLE;
+DROP TABLE FLOAT_TYPE_TABLE;
+DROP TABLE INTEGER_TYPE_TABLE;
+DROP TABLE LONGVARBINARY_TYPE_TABLE;
+DROP TABLE LONGVARCHAR_TYPE_TABLE;
+DROP TABLE NUMERIC_TYPE_TABLE;
+DROP TABLE REAL_TYPE_TABLE;
+DROP TABLE SMALLINT_TYPE_TABLE;
+DROP TABLE TIME_TYPE_TABLE;
+DROP TABLE TIMESTAMP_TYPE_TABLE;
+DROP TABLE TINYINT_TYPE_TABLE;
+DROP TABLE VARBINARY_TYPE_TABLE;
+DROP TABLE VARCHAR_TYPE_TABLE;
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/all_types.sql
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/all_types.sql (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/all_types.sql 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,91 @@
+
+CREATE TABLE BIGINT_TYPE_TABLE
+(
+ BIGINT_COLUMN BIGINT
+);
+CREATE TABLE BINARY_TYPE_TABLE
+(
+ BINARY_COLUMN VARBINARY(2147483647)
+);
+CREATE TABLE BIT_TYPE_TABLE
+(
+ BIT_COLUMN TINYINT
+);
+CREATE TABLE BLOB_TYPE_TABLE
+(
+ BLOB_COLUMN BLOB
+);
+CREATE TABLE BOOLEAN_TYPE_TABLE
+(
+ BOOLEAN_COLUMN TINYINT
+);
+CREATE TABLE CHAR_TYPE_TABLE
+(
+ CHAR_COLUMN CHAR(2000)
+);
+CREATE TABLE CLOB_TYPE_TABLE
+(
+ MYID integer primary key not null,
+ CLOB_COLUMN clob
+);
+CREATE TABLE DATE_TYPE_TABLE
+(
+ DATE_COLUMN DATE
+);
+CREATE TABLE DECIMAL_TYPE_TABLE
+(
+ DECIMAL_COLUMN DECIMAL(38,10)
+);
+CREATE TABLE DOUBLE_TYPE_TABLE
+(
+ DOUBLE_COLUMN DOUBLE
+);
+CREATE TABLE FLOAT_TYPE_TABLE
+(
+ FLOAT_COLUMN FLOAT
+);
+CREATE TABLE INTEGER_TYPE_TABLE
+(
+ INTEGER_COLUMN INTEGER
+);
+CREATE TABLE LONGVARBINARY_TYPE_TABLE
+(
+ LONGVARBINARY_COLUMN LONGVARBINARY
+);
+CREATE TABLE LONGVARCHAR_TYPE_TABLE
+(
+ LONGVARCHAR_COLUMN LONGVARCHAR
+);
+CREATE TABLE NUMERIC_TYPE_TABLE
+(
+ NUMERIC_COLUMN NUMERIC(38,10)
+);
+CREATE TABLE REAL_TYPE_TABLE
+(
+ REAL_COLUMN REAL
+);
+CREATE TABLE SMALLINT_TYPE_TABLE
+(
+ SMALLINT_COLUMN SMALLINT
+);
+CREATE TABLE TIME_TYPE_TABLE
+(
+ TIME_COLUMN TIME
+);
+CREATE TABLE TIMESTAMP_TYPE_TABLE
+(
+ TIMESTAMP_COLUMN TIMESTAMP
+);
+CREATE TABLE TINYINT_TYPE_TABLE
+(
+ TINYINT_COLUMN INTEGER
+);
+CREATE TABLE VARBINARY_TYPE_TABLE
+(
+ VARBINARY_COLUMN binary(8192)
+);
+CREATE TABLE VARCHAR_TYPE_TABLE
+(
+ VARCHAR_COLUMN VARCHAR(2147483647)
+);
+
Added: trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/test.xml
===================================================================
--- trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/test.xml (rev 0)
+++ trunk/sql12/squirrelsql-integration-environment/src/test/resources/sql/hsql/test.xml 2011-09-05 13:29:44 UTC (rev 6390)
@@ -0,0 +1,216 @@
+<?xml version="1.0"?>
+<!DOCTYPE dbmonster-schema PUBLIC "-//kernelpanic.pl//DBMonster Database Schema DTD 1.1//EN" "http://dbmonster.svn.sourceforge.net/viewvc/dbmonster/dbmonster-core/trunk/src/dtd/dbmonster-schema-1.1.dtd">
+<dbmonster-schema>
+ <name>DBCOPYSRC</name>
+ <table name="bigint_type_table" rows="2">
+ <column name="bigint_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="maxValue" value="9999999999999999"/>
+ <property name="minValue" value="1111111111111111"/>
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ </generator>
+ </column>
+ </table>
+ <table name="binary_type_table" rows="2">
+ <column name="binary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="blob_type_table" rows="2">
+ <column name="blob_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+
+ <table name="boolean_type_table" rows="2">
+ <column name="boolean_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.BooleanGenerator">
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="char_type_table" rows="2">
+ <column name="char_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="clob_type_table" rows="2">
+ <key databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.MaxKeyGenerator">
+ <property name="columnName" value="myid"/>
+ </generator>
+ </key>
+ <column name="clob_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="date_type_table" rows="2">
+ <column name="date_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.DateTimeGenerator">
+ <property name="nulls" value="1"/>
+ <property name="returnedType" value="date"/>
+ <property name="startDate" value="1970-02-01 03:30:59.0 GMT"/>
+ <property name="endDate" value="2005-02-01 03:30:59.0 GMT"/>
+ </generator>
+ </column>
+ </table>
+ <table name="decimal_type_table" rows="2">
+ <column name="decimal_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000.99"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="2"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="double_type_table" rows="2">
+ <column name="double_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="double"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="float_type_table" rows="2">
+ <column name="float_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="integer_type_table" rows="2">
+ <column name="integer_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarbinary_type_table" rows="2">
+ <column name="longvarbinary_column" databaseDefault="false">
+ <generator type="pl.kernelpanic.dbmonster.generator.BinaryGenerator">
+ <property name="file" value="src/test/resources/log4j.properties"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="longvarchar_type_table" rows="2">
+ <column name="longvarchar_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.StringGenerator">
+ <property name="minLength" value="100"/>
+ <property name="maxLength" value="2000"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="numeric_type_table" rows="2">
+ <column name="numeric_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="numeric"/>
+ <property name="scale" value="0"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="real_type_table" rows="2">
+ <column name="real_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="1000000"/>
+ <property name="returnedType" value="float"/>
+ <property name="scale" value="5"/>
+ <property name="nulls" value="1"/>
+ </generator>
+ </column>
+ </table>
+ <table name="smallint_type_table" rows="2">
+ <column name="smallint_column">
+ <generator type="pl.kernelpanic.dbmonster.generator.NumberGenerator">
+ <property name="minValue" value="0"/>
+ <property name="maxValue" value="32767"/>
+ <property name="returnedType" value="integer"/>
+ <property name="scale" value="0"/>
+ ...
[truncated message content] |
