X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F13db2_common.t;h=4823d7e02c934a4b26bc1dc1b2a8d7dd51e5054e;hb=f3cfe4e62286cc876440aec02e5c0b69e40d6ece;hp=862f2fd7ecd1ab615ee8536822bfc9d8124da8d7;hpb=af96f52e62b7fd03380a5f53a1b4263a71bd3589;p=dbsrgits%2FDBIx-Class-Schema-Loader.git

diff --git a/t/13db2_common.t b/t/13db2_common.t
index 862f2fd..4823d7e 100644
--- a/t/13db2_common.t
+++ b/t/13db2_common.t
@@ -1,24 +1,87 @@
 use strict;
-use lib qw( . ./t );
+use lib qw(t/lib);
 use dbixcsl_common_tests;
 
-my $database = $ENV{DB2_NAME} || '';
-my $user     = $ENV{DB2_USER} || '';
-my $password = $ENV{DB2_PASS} || '';
+my $dsn      = $ENV{DBICTEST_DB2_DSN} || '';
+my $user     = $ENV{DBICTEST_DB2_USER} || '';
+my $password = $ENV{DBICTEST_DB2_PASS} || '';
 
 my $tester = dbixcsl_common_tests->new(
     vendor         => 'DB2',
     auto_inc_pk    => 'INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY',
-    dsn            => "dbi:DB2:$database",
+    dsn            => $dsn,
     user           => $user,
     password       => $password,
-    db_schema      => $user,
-    drop_db_schema => 1,
+    null           => '',
+    preserve_case_mode_is_exclusive => 1,
+    quote_char                      => '"',
+    data_types => {
+        # http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0008483.htm
+        #
+        # Numeric Types
+        smallint           => { data_type => 'smallint' },
+        integer            => { data_type => 'integer' },
+        'int'              => { data_type => 'integer' },
+        real               => { data_type => 'real' },
+        'double precision' => { data_type => 'double precision' },
+        double             => { data_type => 'double precision' },
+        float              => { data_type => 'double precision' },
+        'float(24)'        => { data_type => 'real' },
+        'float(25)'        => { data_type => 'double precision' },
+        'float(53)'        => { data_type => 'double precision' },
+        numeric            => { data_type => 'numeric' },
+        decimal            => { data_type => 'numeric' },
+	'numeric(6,3)'     => { data_type => 'numeric', size => [6,3] },
+	'decimal(6,3)'     => { data_type => 'numeric', size => [6,3] },
+
+        # Character String Types
+        char               => { data_type => 'char', size => 1 },
+        'char(3)'          => { data_type => 'char', size => 3 },
+        'varchar(3)'       => { data_type => 'varchar', size => 3 },
+        'long varchar'     => { data_type => 'long varchar' },
+        'clob'             => { data_type => 'clob' },
+
+        # Graphic String Types (double-byte strings)
+        graphic            => { data_type => 'graphic', size => 1 },
+        'graphic(3)'       => { data_type => 'graphic', size => 3 },
+        'vargraphic(3)'    => { data_type => 'vargraphic', size => 3 },
+        'long vargraphic'  => { data_type => 'long vargraphic' },
+        'dbclob'           => { data_type => 'dbclob' },
+
+        # Binary String Types
+        'char for bit data'=> { data_type => 'binary', size => 1, original => { data_type => 'char for bit data' } },
+        'char(3) for bit data'
+                           => { data_type => 'binary', size => 3, original => { data_type => 'char for bit data' } },
+        'varchar(3) for bit data'
+                           => { data_type => 'varbinary', size => 3, original => { data_type => 'varchar for bit data' } },
+        'long varchar for bit data'
+                           => { data_type => 'blob', original => { data_type => 'long varchar for bit data' } },
+        blob               => { data_type => 'blob' },
+
+        # DateTime Types
+        'date'             => { data_type => 'date' },
+        'date default current date'
+                           => { data_type => 'date', default_value => \'current_timestamp',
+                                original => { default_value => \'current date' } },
+        'time'             => { data_type => 'time' },
+        'time default current time'
+                           => { data_type => 'time', default_value => \'current_timestamp',
+                                original => { default_value => \'current time' } },
+        timestamp          => { data_type => 'timestamp' },
+        'timestamp default current timestamp'
+                           => { data_type => 'timestamp', default_value => \'current_timestamp',
+                                original => { default_value => \'current timestamp' } },
+
+        # DATALINK Type
+        # XXX I don't know how to make these
+#        datalink           => { data_type => 'datalink' },
+    },
 );
 
-if( !$database || !$user ) {
-    $tester->skip_tests('You need to set the DB2_NAME, DB2_USER and DB2_PASS environment variables');
+if( !$dsn || !$user ) {
+    $tester->skip_tests('You need to set the DBICTEST_DB2_DSN, _USER, and _PASS environment variables');
 }
 else {
     $tester->run_tests();
 }
+# vim:et sts=4 sw=4 tw=0: