[dbsrgits/DBIx-Class-Schema-Loader.git] / t / 10_04db2_common.t

use strict;
use warnings;
use Test::More;
use Test::Exception;
use Try::Tiny;
use File::Path 'rmtree';
use DBIx::Class::Schema::Loader 'make_schema_at';

use lib qw(t/lib);

use dbixcsl_common_tests ();
use dbixcsl_test_dir '$tdir';

use constant EXTRA_DUMP_DIR => "$tdir/db2_extra_dump";

my $dsn      = $ENV{DBICTEST_DB2_DSN} || '';
my $user     = $ENV{DBICTEST_DB2_USER} || '';
my $password = $ENV{DBICTEST_DB2_PASS} || '';

plan skip_all => 'You need to set the DBICTEST_DB2_DSN, _USER, and _PASS environment variables'
    unless ($dsn && $user);

my ($schema, $schemas_created); # for cleanup in END for extra tests

my $srv_ver = do {
    require DBI;
    my $dbh = DBI->connect ($dsn, $user, $password, { RaiseError => 1, PrintError => 0} );
    eval { $dbh->get_info(18) } || 0;
};
my ($maj_srv_ver) = $srv_ver =~ /^(\d+)/;

my $extra_graphics_data_types = {
    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' },
};

my $tester = dbixcsl_common_tests->new(
    vendor         => 'DB2',
    auto_inc_pk    => 'INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY',
    dsn            => $dsn,
    user           => $user,
    password       => $password,
    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)
        ($maj_srv_ver >= 9) ? (%$extra_graphics_data_types) : (),

        # 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' },
    },
    extra => {
        count => 28 * 2,
        run => sub {
            SKIP: {
                $schema = shift;

                my $dbh = $schema->storage->dbh;

                try {
                    $dbh->do('CREATE SCHEMA "dbicsl-test"');
                }
                catch {
                    $schemas_created = 0;
                    skip "no CREATE SCHEMA privileges", 28 * 2;
                };

                $dbh->do(<<"EOF");
                    CREATE TABLE "dbicsl-test".db2_loader_test4 (
                        id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
                        value VARCHAR(100)
                    )
EOF
                $dbh->do(<<"EOF");
                    CREATE TABLE "dbicsl-test".db2_loader_test5 (
                        id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
                        value VARCHAR(100),
                        four_id INTEGER NOT NULL UNIQUE,
                        FOREIGN KEY (four_id) REFERENCES "dbicsl-test".db2_loader_test4 (id)
                    )
EOF
                $dbh->do('CREATE SCHEMA "dbicsl.test"');
                $dbh->do(<<"EOF");
                    CREATE TABLE "dbicsl.test".db2_loader_test6 (
                        id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
                        value VARCHAR(100),
                        db2_loader_test4_id INTEGER,
                        FOREIGN KEY (db2_loader_test4_id) REFERENCES "dbicsl-test".db2_loader_test4 (id)
                    )
EOF
                $dbh->do(<<"EOF");
                    CREATE TABLE "dbicsl.test".db2_loader_test7 (
                        id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
                        value VARCHAR(100),
                        six_id INTEGER NOT NULL UNIQUE,
                        FOREIGN KEY (six_id) REFERENCES "dbicsl.test".db2_loader_test6 (id)
                    )
EOF
                $dbh->do(<<"EOF");
                    CREATE TABLE "dbicsl-test".db2_loader_test8 (
                        id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
                        value VARCHAR(100),
                        db2_loader_test7_id INTEGER,
                        FOREIGN KEY (db2_loader_test7_id) REFERENCES "dbicsl.test".db2_loader_test7 (id)
                    )
EOF

                $schemas_created = 1;

                foreach my $db_schema (['dbicsl-test', 'dbicsl.test'], '%') {
                    lives_and {
                        rmtree EXTRA_DUMP_DIR;

                        my @warns;
                        local $SIG{__WARN__} = sub {
                            push @warns, $_[0] unless $_[0] =~ /\bcollides\b/;
                        };

                        make_schema_at(
                            'DB2MultiSchema',
                            {
                                naming => 'current',
                                db_schema => $db_schema,
                                dump_directory => EXTRA_DUMP_DIR,
                                quiet => 1,
                            },
                            [ $dsn, $user, $password ],
                        );

                        diag join "\n", @warns if @warns;

                        is @warns, 0;
                    } 'dumped schema for "dbicsl-test" and "dbicsl.test" schemas with no warnings';

                    my ($test_schema, $rsrc, $rs, $row, %uniqs, $rel_info);

                    lives_and {
                        ok $test_schema = DB2MultiSchema->connect($dsn, $user, $password);
                    } 'connected test schema';

                    lives_and {
                        ok $rsrc = $test_schema->source('Db2LoaderTest4');
                    } 'got source for table in schema name with dash';

                    is try { $rsrc->column_info('id')->{is_auto_increment} }, 1,
                        'column in schema name with dash';

                    is try { $rsrc->column_info('value')->{data_type} }, 'varchar',
                        'column in schema name with dash';

                    is try { $rsrc->column_info('value')->{size} }, 100,
                        'column in schema name with dash';

                    lives_and {
                        ok $rs = $test_schema->resultset('Db2LoaderTest4');
                    } 'got resultset for table in schema name with dash';

                    lives_and {
                        ok $row = $rs->create({ value => 'foo' });
                    } 'executed SQL on table in schema name with dash';

                    $rel_info = try { $rsrc->relationship_info('db2_loader_test5') };

                    is_deeply $rel_info->{cond}, {
                        'foreign.four_id' => 'self.id'
                    }, 'relationship in schema name with dash';

                    is $rel_info->{attrs}{accessor}, 'single',
                        'relationship in schema name with dash';

                    is $rel_info->{attrs}{join_type}, 'LEFT',
                        'relationship in schema name with dash';

                    lives_and {
                        ok $rsrc = $test_schema->source('Db2LoaderTest5');
                    } 'got source for table in schema name with dash';

                    %uniqs = try { $rsrc->unique_constraints };

                    is keys %uniqs, 2,
                        'got unique and primary constraint in schema name with dash';

                    lives_and {
                        ok $rsrc = $test_schema->source('Db2LoaderTest6');
                    } 'got source for table in schema name with dot';

                    is try { $rsrc->column_info('id')->{is_auto_increment} }, 1,
                        'column in schema name with dot introspected correctly';

                    is try { $rsrc->column_info('value')->{data_type} }, 'varchar',
                        'column in schema name with dot introspected correctly';

                    is try { $rsrc->column_info('value')->{size} }, 100,
                        'column in schema name with dot introspected correctly';

                    lives_and {
                        ok $rs = $test_schema->resultset('Db2LoaderTest6');
                    } 'got resultset for table in schema name with dot';

                    lives_and {
                        ok $row = $rs->create({ value => 'foo' });
                    } 'executed SQL on table in schema name with dot';

                    $rel_info = try { $rsrc->relationship_info('db2_loader_test7') };

                    is_deeply $rel_info->{cond}, {
                        'foreign.six_id' => 'self.id'
                    }, 'relationship in schema name with dot';

                    is $rel_info->{attrs}{accessor}, 'single',
                        'relationship in schema name with dot';

                    is $rel_info->{attrs}{join_type}, 'LEFT',
                        'relationship in schema name with dot';

                    lives_and {
                        ok $rsrc = $test_schema->source('Db2LoaderTest7');
                    } 'got source for table in schema name with dot';

                    %uniqs = try { $rsrc->unique_constraints };

                    is keys %uniqs, 2,
                        'got unique and primary constraint in schema name with dot';

                    lives_and {
                        ok $test_schema->source('Db2LoaderTest6')
                            ->has_relationship('db2_loader_test4');
                    } 'cross-schema relationship in multi-db_schema';

                    lives_and {
                        ok $test_schema->source('Db2LoaderTest4')
                            ->has_relationship('db2_loader_test6s');
                    } 'cross-schema relationship in multi-db_schema';

                    lives_and {
                        ok $test_schema->source('Db2LoaderTest8')
                            ->has_relationship('db2_loader_test7');
                    } 'cross-schema relationship in multi-db_schema';

                    lives_and {
                        ok $test_schema->source('Db2LoaderTest7')
                            ->has_relationship('db2_loader_test8s');
                    } 'cross-schema relationship in multi-db_schema';
                }
            }

        },
    },
);

$tester->run_tests();

END {
    if (not $ENV{SCHEMA_LOADER_TESTS_NOCLEANUP}) {
        if ($schemas_created && (my $dbh = try { $schema->storage->dbh })) {
            foreach my $table ('"dbicsl-test".db2_loader_test8',
                               '"dbicsl.test".db2_loader_test7',
                               '"dbicsl.test".db2_loader_test6',
                               '"dbicsl-test".db2_loader_test5',
                               '"dbicsl-test".db2_loader_test4') {
                try {
                    $dbh->do("DROP TABLE $table");
                }
                catch {
                    diag "Error dropping table: $_";
                };
            }

            foreach my $db_schema (qw/dbicsl-test dbicsl.test/) {
                try {
                    $dbh->do(qq{DROP SCHEMA "$db_schema" RESTRICT});
                }
                catch {
                    diag "Error dropping test schema $db_schema: $_";
                };
            }
        }
        rmtree EXTRA_DUMP_DIR;
    }
}
# vim:et sts=4 sw=4 tw=0:
Commit	Line	Data
a78e3fed	1	use strict;
c4a69b87	2	use warnings;
ebed3e6e	3	use Test::More;
c4a69b87	4	use Test::Exception;
	5	use Try::Tiny;
	6	use File::Path 'rmtree';
	7	use DBIx::Class::Schema::Loader 'make_schema_at';
	8
	9	use lib qw(t/lib);
	10
	11	use dbixcsl_common_tests ();
	12	use dbixcsl_test_dir '$tdir';
	13
	14	use constant EXTRA_DUMP_DIR => "$tdir/db2_extra_dump";
a78e3fed	15
9e978a19	16	my $dsn = $ENV{DBICTEST_DB2_DSN} \|\| '';
	17	my $user = $ENV{DBICTEST_DB2_USER} \|\| '';
	18	my $password = $ENV{DBICTEST_DB2_PASS} \|\| '';
a78e3fed	19
ebed3e6e	20	plan skip_all => 'You need to set the DBICTEST_DB2_DSN, _USER, and _PASS environment variables'
	21	unless ($dsn && $user);
	22
c4a69b87	23	my ($schema, $schemas_created); # for cleanup in END for extra tests
c4a69b87	24
ebed3e6e	25	my $srv_ver = do {
	26	require DBI;
	27	my $dbh = DBI->connect ($dsn, $user, $password, { RaiseError => 1, PrintError => 0} );
	28	eval { $dbh->get_info(18) } \|\| 0;
	29	};
	30	my ($maj_srv_ver) = $srv_ver =~ /^(\d+)/;
	31
ebed3e6e	32	my $extra_graphics_data_types = {
	33	graphic => { data_type => 'graphic', size => 1 },
	34	'graphic(3)' => { data_type => 'graphic', size => 3 },
	35	'vargraphic(3)' => { data_type => 'vargraphic', size => 3 },
	36	'long vargraphic' => { data_type => 'long vargraphic' },
	37	'dbclob' => { data_type => 'dbclob' },
	38	};
	39
fbd83464	40	my $tester = dbixcsl_common_tests->new(
af96f52e	41	vendor => 'DB2',
af96f52e	42	auto_inc_pk => 'INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY',
9e978a19	43	dsn => $dsn,
af96f52e	44	user => $user,
af96f52e	45	password => $password,
0906d55b	46	null => '',
b511f36e	47	preserve_case_mode_is_exclusive => 1,
b511f36e	48	quote_char => '"',
8a64178e	49	data_types => {
7640ef4b	50	# http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0008483.htm
	51	#
	52	# Numeric Types
	53	smallint => { data_type => 'smallint' },
	54	integer => { data_type => 'integer' },
	55	'int' => { data_type => 'integer' },
	56	real => { data_type => 'real' },
	57	'double precision' => { data_type => 'double precision' },
	58	double => { data_type => 'double precision' },
	59	float => { data_type => 'double precision' },
	60	'float(24)' => { data_type => 'real' },
	61	'float(25)' => { data_type => 'double precision' },
	62	'float(53)' => { data_type => 'double precision' },
	63	numeric => { data_type => 'numeric' },
	64	decimal => { data_type => 'numeric' },
ebed3e6e	65	'numeric(6,3)' => { data_type => 'numeric', size => [6,3] },
ebed3e6e	66	'decimal(6,3)' => { data_type => 'numeric', size => [6,3] },
7640ef4b	67
	68	# Character String Types
	69	char => { data_type => 'char', size => 1 },
	70	'char(3)' => { data_type => 'char', size => 3 },
	71	'varchar(3)' => { data_type => 'varchar', size => 3 },
	72	'long varchar' => { data_type => 'long varchar' },
	73	'clob' => { data_type => 'clob' },
	74
	75	# Graphic String Types (double-byte strings)
ebed3e6e	76	($maj_srv_ver >= 9) ? (%$extra_graphics_data_types) : (),
7640ef4b	77
	78	# Binary String Types
	79	'char for bit data'=> { data_type => 'binary', size => 1, original => { data_type => 'char for bit data' } },
	80	'char(3) for bit data'
	81	=> { data_type => 'binary', size => 3, original => { data_type => 'char for bit data' } },
	82	'varchar(3) for bit data'
	83	=> { data_type => 'varbinary', size => 3, original => { data_type => 'varchar for bit data' } },
	84	'long varchar for bit data'
	85	=> { data_type => 'blob', original => { data_type => 'long varchar for bit data' } },
	86	blob => { data_type => 'blob' },
	87
	88	# DateTime Types
	89	'date' => { data_type => 'date' },
	90	'date default current date'
	91	=> { data_type => 'date', default_value => \'current_timestamp',
	92	original => { default_value => \'current date' } },
	93	'time' => { data_type => 'time' },
	94	'time default current time'
	95	=> { data_type => 'time', default_value => \'current_timestamp',
	96	original => { default_value => \'current time' } },
	97	timestamp => { data_type => 'timestamp' },
	98	'timestamp default current timestamp'
	99	=> { data_type => 'timestamp', default_value => \'current_timestamp',
	100	original => { default_value => \'current timestamp' } },
	101
	102	# DATALINK Type
	103	# XXX I don't know how to make these
	104	# datalink => { data_type => 'datalink' },
8a64178e	105	},
c4a69b87	106	extra => {
	107	count => 28 * 2,
	108	run => sub {
	109	SKIP: {
	110	$schema = shift;
	111
	112	my $dbh = $schema->storage->dbh;
	113
	114	try {
	115	$dbh->do('CREATE SCHEMA "dbicsl-test"');
	116	}
	117	catch {
	118	$schemas_created = 0;
	119	skip "no CREATE SCHEMA privileges", 28 * 2;
	120	};
	121
	122	$dbh->do(<<"EOF");
	123	CREATE TABLE "dbicsl-test".db2_loader_test4 (
	124	id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
	125	value VARCHAR(100)
	126	)
	127	EOF
	128	$dbh->do(<<"EOF");
	129	CREATE TABLE "dbicsl-test".db2_loader_test5 (
	130	id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
	131	value VARCHAR(100),
	132	four_id INTEGER NOT NULL UNIQUE,
	133	FOREIGN KEY (four_id) REFERENCES "dbicsl-test".db2_loader_test4 (id)
	134	)
	135	EOF
	136	$dbh->do('CREATE SCHEMA "dbicsl.test"');
	137	$dbh->do(<<"EOF");
	138	CREATE TABLE "dbicsl.test".db2_loader_test6 (
	139	id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
	140	value VARCHAR(100),
	141	db2_loader_test4_id INTEGER,
	142	FOREIGN KEY (db2_loader_test4_id) REFERENCES "dbicsl-test".db2_loader_test4 (id)
	143	)
	144	EOF
	145	$dbh->do(<<"EOF");
	146	CREATE TABLE "dbicsl.test".db2_loader_test7 (
	147	id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
	148	value VARCHAR(100),
	149	six_id INTEGER NOT NULL UNIQUE,
	150	FOREIGN KEY (six_id) REFERENCES "dbicsl.test".db2_loader_test6 (id)
	151	)
	152	EOF
	153	$dbh->do(<<"EOF");
	154	CREATE TABLE "dbicsl-test".db2_loader_test8 (
	155	id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
	156	value VARCHAR(100),
	157	db2_loader_test7_id INTEGER,
	158	FOREIGN KEY (db2_loader_test7_id) REFERENCES "dbicsl.test".db2_loader_test7 (id)
	159	)
	160	EOF
	161
	162	$schemas_created = 1;
	163
	164	foreach my $db_schema (['dbicsl-test', 'dbicsl.test'], '%') {
	165	lives_and {
	166	rmtree EXTRA_DUMP_DIR;
	167
	168	my @warns;
	169	local $SIG{__WARN__} = sub {
170	push @warns, $_[0] unless $_[0] =~ /\bcollides\b/;
171	};
172
173	make_schema_at(
174	'DB2MultiSchema',
175	{
176	naming => 'current',
177	db_schema => $db_schema,
178	dump_directory => EXTRA_DUMP_DIR,
179	quiet => 1,
180	},
181	[ $dsn, $user, $password ],
182	);
183
184	diag join "\n", @warns if @warns;
185
186	is @warns, 0;
187	} 'dumped schema for "dbicsl-test" and "dbicsl.test" schemas with no warnings';
188
189	my ($test_schema, $rsrc, $rs, $row, %uniqs, $rel_info);
190
191	lives_and {
192	ok $test_schema = DB2MultiSchema->connect($dsn, $user, $password);
193	} 'connected test schema';
194
195	lives_and {
196	ok $rsrc = $test_schema->source('Db2LoaderTest4');
197	} 'got source for table in schema name with dash';
198
199	is try { $rsrc->column_info('id')->{is_auto_increment} }, 1,
200	'column in schema name with dash';
201
202	is try { $rsrc->column_info('value')->{data_type} }, 'varchar',
203	'column in schema name with dash';
204
205	is try { $rsrc->column_info('value')->{size} }, 100,
206	'column in schema name with dash';
207
208	lives_and {
209	ok $rs = $test_schema->resultset('Db2LoaderTest4');
210	} 'got resultset for table in schema name with dash';
211
212	lives_and {
213	ok $row = $rs->create({ value => 'foo' });
214	} 'executed SQL on table in schema name with dash';
215
216	$rel_info = try { $rsrc->relationship_info('db2_loader_test5') };
217
218	is_deeply $rel_info->{cond}, {
219	'foreign.four_id' => 'self.id'
220	}, 'relationship in schema name with dash';
221
222	is $rel_info->{attrs}{accessor}, 'single',
223	'relationship in schema name with dash';
224
225	is $rel_info->{attrs}{join_type}, 'LEFT',
226	'relationship in schema name with dash';
227
228	lives_and {
229	ok $rsrc = $test_schema->source('Db2LoaderTest5');
230	} 'got source for table in schema name with dash';
231
232	%uniqs = try { $rsrc->unique_constraints };
233
234	is keys %uniqs, 2,
235	'got unique and primary constraint in schema name with dash';
236
237	lives_and {
238	ok $rsrc = $test_schema->source('Db2LoaderTest6');
239	} 'got source for table in schema name with dot';
240
241	is try { $rsrc->column_info('id')->{is_auto_increment} }, 1,
242	'column in schema name with dot introspected correctly';
243
244	is try { $rsrc->column_info('value')->{data_type} }, 'varchar',
245	'column in schema name with dot introspected correctly';
246
247	is try { $rsrc->column_info('value')->{size} }, 100,
248	'column in schema name with dot introspected correctly';
249
250	lives_and {
251	ok $rs = $test_schema->resultset('Db2LoaderTest6');
252	} 'got resultset for table in schema name with dot';
253
254	lives_and {
255	ok $row = $rs->create({ value => 'foo' });
256	} 'executed SQL on table in schema name with dot';
257
258	$rel_info = try { $rsrc->relationship_info('db2_loader_test7') };
259
260	is_deeply $rel_info->{cond}, {
261	'foreign.six_id' => 'self.id'
262	}, 'relationship in schema name with dot';
263
264	is $rel_info->{attrs}{accessor}, 'single',
265	'relationship in schema name with dot';
266
267	is $rel_info->{attrs}{join_type}, 'LEFT',
268	'relationship in schema name with dot';
269
270	lives_and {
271	ok $rsrc = $test_schema->source('Db2LoaderTest7');
272	} 'got source for table in schema name with dot';
273
274	%uniqs = try { $rsrc->unique_constraints };
275
276	is keys %uniqs, 2,
277	'got unique and primary constraint in schema name with dot';
278
279	lives_and {
280	ok $test_schema->source('Db2LoaderTest6')
281	->has_relationship('db2_loader_test4');
282	} 'cross-schema relationship in multi-db_schema';
283
284	lives_and {
285	ok $test_schema->source('Db2LoaderTest4')
286	->has_relationship('db2_loader_test6s');
287	} 'cross-schema relationship in multi-db_schema';
288
289	lives_and {
290	ok $test_schema->source('Db2LoaderTest8')
291	->has_relationship('db2_loader_test7');
292	} 'cross-schema relationship in multi-db_schema';
293
294	lives_and {
295	ok $test_schema->source('Db2LoaderTest7')
296	->has_relationship('db2_loader_test8s');
297	} 'cross-schema relationship in multi-db_schema';
298	}
299	}
300
301	},
302	},
a78e3fed	303	);
a78e3fed	304
ebed3e6e	305	$tester->run_tests();
ebed3e6e	306
c4a69b87	307	END {
	308	if (not $ENV{SCHEMA_LOADER_TESTS_NOCLEANUP}) {
	309	if ($schemas_created && (my $dbh = try { $schema->storage->dbh })) {
	310	foreach my $table ('"dbicsl-test".db2_loader_test8',
	311	'"dbicsl.test".db2_loader_test7',
	312	'"dbicsl.test".db2_loader_test6',
	313	'"dbicsl-test".db2_loader_test5',
	314	'"dbicsl-test".db2_loader_test4') {
	315	try {
	316	$dbh->do("DROP TABLE $table");
	317	}
	318	catch {
	319	diag "Error dropping table: $_";
	320	};
	321	}
	322
	323	foreach my $db_schema (qw/dbicsl-test dbicsl.test/) {
	324	try {
	325	$dbh->do(qq{DROP SCHEMA "$db_schema" RESTRICT});
	326	}
	327	catch {
	328	diag "Error dropping test schema $db_schema: $_";
	329	};
	330	}
	331	}
	332	rmtree EXTRA_DUMP_DIR;
	333	}
	334	}
8a64178e	335	# vim:et sts=4 sw=4 tw=0: