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