6 use DBIx::Class::Optional::Dependencies ();
11 for my $type (qw/PG MYSQL SQLite/) {
14 my @dsn = $type eq 'SQLite'
15 ? DBICTest->_database(sqlite_use_file => 1)
17 skip "Skipping $type tests without DBICTEST_${type}_DSN", 1
18 unless $ENV{"DBICTEST_${type}_DSN"};
19 @ENV{map { "DBICTEST_${type}_${_}" } qw/DSN USER PASS/}
24 skip "skipping Pg tests without dependencies installed", 1
25 unless DBIx::Class::Optional::Dependencies->req_ok_for('test_rdbms_pg');
27 elsif ($type eq 'MYSQL') {
28 skip "skipping MySQL tests without dependencies installed", 1
29 unless DBIx::Class::Optional::Dependencies->req_ok_for('test_rdbms_mysql');
32 my $schema = DBICTest::Schema->connect (@dsn);
34 # emulate a singleton-factory, just cache the object *somewhere in a different package*
35 # to induce out-of-order destruction
36 $DBICTest::FakeSchemaFactory::schema = $schema;
38 # so we can see the retry exceptions (if any)
39 $ENV{DBIC_DBIRETRY_DEBUG} = 1;
41 ok (!$schema->storage->connected, "$type: start disconnected");
43 $schema->txn_do (sub {
45 ok ($schema->storage->connected, "$type: transaction starts connected");
49 skip "Fork failed: $!", 1 if (! defined $pid);
52 note "Parent $$ sleeping...";
54 note "Parent $$ woken up after child $pid exit";
57 note "Child $$ terminating";
58 undef $DBICTest::FakeSchemaFactory::schema;
62 ok ($schema->storage->connected, "$type: parent still connected (in txn_do)");
66 ok ($schema->storage->connected, "$type: parent still connected (outside of txn_do)");
68 undef $DBICTest::FakeSchemaFactory::schema;