X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fstorage%2Freconnect.t;h=b28734b3c93b4cf245339bb32858af3b6a38b7d5;hb=5e2a9177e84b8328dcb32ba4d2b4c310ee8610cb;hp=8a332848de462a9d48893458df92bf993a46cab9;hpb=65d351219882184861384aedac6f251b6797d0d7;p=dbsrgits%2FDBIx-Class.git diff --git a/t/storage/reconnect.t b/t/storage/reconnect.t index 8a33284..b28734b 100644 --- a/t/storage/reconnect.t +++ b/t/storage/reconnect.t @@ -2,12 +2,13 @@ use strict; use warnings; use FindBin; -use File::Copy; +use File::Copy 'move'; use Test::More; +use Test::Exception; use lib qw(t/lib); use DBICTest; -my $db_orig = "$FindBin::Bin/../var/DBIxClass.db"; +my $db_orig = DBICTest->_sqlite_dbfilename; my $db_tmp = "$db_orig.tmp"; # Set up the "usual" sqlite for DBICTest @@ -37,7 +38,8 @@ cmp_ok(@art_two, '==', 3, "Three artists returned"); ### Now, disconnect the dbh, and move the db file; # create a new one and chmod 000 to prevent SQLite from connecting. $schema->storage->_dbh->disconnect; -move( $db_orig, $db_tmp ); +move( $db_orig, $db_tmp ) + or die "failed to move $db_orig to $db_tmp: $!"; open DBFILE, '>', $db_orig; print DBFILE 'THIS IS NOT A REAL DATABASE'; close DBFILE; @@ -47,28 +49,25 @@ chmod 0000, $db_orig; { # Catch the DBI connection error local $SIG{__WARN__} = sub {}; - eval { + dies_ok { my @art_three = $schema->resultset("Artist")->search( {}, { order_by => 'name DESC' } ); - }; - ok( $@, 'The operation failed' ); + } 'The operation failed'; } +# otherwise can't unlink the fake db file +$schema->storage->_dbh->disconnect if $^O eq 'MSWin32'; + ### Now, move the db file back to the correct name -unlink($db_orig); -move( $db_tmp, $db_orig ); - -SKIP: { - skip "Cannot reconnect if original connection didn't fail", 2 - if ( $@ =~ /encrypted or is not a database/ ); - - ### Try the operation again... this time, it should succeed - my @art_four; - eval { - @art_four = $schema->resultset("Artist")->search( {}, { order_by => 'name DESC' } ); - }; - ok( !$@, 'The operation succeeded' ); - cmp_ok( @art_four, '==', 3, "Three artists returned" ); -} +unlink($db_orig) or die "could not delete $db_orig: $!"; +move( $db_tmp, $db_orig ) + or die "could not move $db_tmp to $db_orig: $!"; + +### Try the operation again... this time, it should succeed +my @art_four; +lives_ok { + @art_four = $schema->resultset("Artist")->search( {}, { order_by => 'name DESC' } ); +} 'The operation succeeded'; +cmp_ok( @art_four, '==', 3, "Three artists returned" ); # check that reconnection contexts are preserved in txn_do / dbh_do