fix default_value for all other backends, fix bug with quoted Pg tables from $dbh...

[dbsrgits/DBIx-Class-Schema-Loader.git] / t / 13db2_common.t

diff --git a/t/13db2_common.t b/t/13db2_common.t
index 1214300..2eefb47 100644 (file)
--- a/t/13db2_common.t
+++ b/t/13db2_common.t
@@ -1,21 +1,23 @@
 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 => 'SERIAL NOT NULL PRIMARY KEY',
-    dsn         => "dbi:DB2:$database",
-    user        => $user,
-    password    => $password,
+    vendor         => 'DB2',
+    auto_inc_pk    => 'INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY',
+    default_function => 'CURRENT TIMESTAMP',
+    dsn            => $dsn,
+    user           => $user,
+    password       => $password,
+    null           => '',
 );
 
-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();