Author: vhalbert(a)redhat.com
Date: 2009-09-18 13:36:47 -0400 (Fri, 18 Sep 2009)
New Revision: 1372
Added:
trunk/test-integration/db/src/main/resources/ddl/sqlserver/
trunk/test-integration/db/src/main/resources/ddl/sqlserver/create_tables.sql
trunk/test-integration/db/src/main/resources/ddl/sqlserver/drop_tables.sql
trunk/test-integration/db/src/main/resources/ddl/sqlserver/exec_parms.properties
Log:
Teiid 773 - organize integration test
Added: trunk/test-integration/db/src/main/resources/ddl/sqlserver/create_tables.sql
===================================================================
--- trunk/test-integration/db/src/main/resources/ddl/sqlserver/create_tables.sql
(rev 0)
+++
trunk/test-integration/db/src/main/resources/ddl/sqlserver/create_tables.sql 2009-09-18
17:36:47 UTC (rev 1372)
@@ -0,0 +1,13 @@
+
+-- these tables are used by custom junit test for testing transactions
+
+create Table g1 (
+ e1 NUMERIC(5),
+ e2 VARCHAR(50),
+ PRIMARY KEY (e1)
+);
+create Table g2 (
+ e1 NUMERIC(5) REFERENCES g1 (e1),
+ e2 VARCHAR(50)
+);
+
\ No newline at end of file
Added: trunk/test-integration/db/src/main/resources/ddl/sqlserver/drop_tables.sql
===================================================================
--- trunk/test-integration/db/src/main/resources/ddl/sqlserver/drop_tables.sql
(rev 0)
+++ trunk/test-integration/db/src/main/resources/ddl/sqlserver/drop_tables.sql 2009-09-18
17:36:47 UTC (rev 1372)
@@ -0,0 +1,6 @@
+
+-- drop the tables
+
+drop Table g2;
+drop Table g1;
+
\ No newline at end of file
Added: trunk/test-integration/db/src/main/resources/ddl/sqlserver/exec_parms.properties
===================================================================
--- trunk/test-integration/db/src/main/resources/ddl/sqlserver/exec_parms.properties
(rev 0)
+++
trunk/test-integration/db/src/main/resources/ddl/sqlserver/exec_parms.properties 2009-09-18
17:36:47 UTC (rev 1372)
@@ -0,0 +1,3 @@
+delim=GO
+delimtype=normal
+rdbms.type=mircrosoft
Property changes on:
trunk/test-integration/db/src/main/resources/ddl/sqlserver/exec_parms.properties
___________________________________________________________________
Name: svn:mime-type
+ text/plain
Show replies by date