X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F81transactions.t;h=c1300de1a8e54e04eea06c73ac50d9b2d5982547;hb=8b7789c969e4088e62dfeea2dc87851f74a8c496;hp=7d30b5c95cfb8f0f0d5b69fdb40b992ccc2b9e9d;hpb=a211cb63c765b996706779e04685f982c4c5eb81;p=dbsrgits%2FDBIx-Class.git diff --git a/t/81transactions.t b/t/81transactions.t index 7d30b5c..c1300de 100644 --- a/t/81transactions.t +++ b/t/81transactions.t @@ -1,23 +1,22 @@ use strict; -use warnings; +use warnings; use Test::More; +use Test::Warn; use Test::Exception; use lib qw(t/lib); use DBICTest; my $schema = DBICTest->init_schema(); -plan tests => 63; - my $code = sub { my ($artist, @cd_titles) = @_; - + $artist->create_related('cds', { title => $_, year => 2006, }) foreach (@cd_titles); - + return $artist->cds->all; }; @@ -235,7 +234,11 @@ my $fail_code = sub { $schema2->txn_begin(); }; my $err = $@; - ok(($err eq ''), 'Pre-connection nested transactions.'); + ok(! $err, 'Pre-connection nested transactions.'); + + # although not connected DBI would still warn about rolling back at disconnect + $schema2->txn_rollback; + $schema2->txn_rollback; $schema2->storage->disconnect; } $schema->storage->disconnect; @@ -254,13 +257,13 @@ $schema->storage->disconnect; name => 'Death Cab for Cutie', made_up_column => 1, }); - + $guard->commit; - } qr/No such column made_up_column .*? at .*?81transactions.t line \d+/, "Error propogated okay"; + } qr/No such column made_up_column .*? at .*?81transactions.t line \d+/s, "Error propogated okay"; ok(!$artist_rs->find({name => 'Death Cab for Cutie'}), "Artist not created"); - my $inner_exception; + my $inner_exception; # set in inner() below eval { outer($schema, 1); }; @@ -268,36 +271,33 @@ $schema->storage->disconnect; ok(!$artist_rs->find({name => 'Death Cab for Cutie'}), "Artist not created"); - - eval { - # The 0 arg says done die, just let the scope guard go out of scope - # forcing a txn_rollback to happen - outer($schema, 0); - }; - local $TODO = "Work out how this should work"; - is($@, "Not sure what we want here, but something", "Rollback okay"); - - ok(!$artist_rs->find({name => 'Death Cab for Cutie'}), "Artist not created"); + lives_ok (sub { + warnings_exist ( sub { + # The 0 arg says don't die, just let the scope guard go out of scope + # forcing a txn_rollback to happen + outer($schema, 0); + }, qr/A DBIx::Class::Storage::TxnScopeGuard went out of scope without explicit commit or error. Rolling back./, 'Out of scope warning detected'); + ok(!$artist_rs->find({name => 'Death Cab for Cutie'}), "Artist not created"); + }, 'rollback successful withot exception'); sub outer { my ($schema) = @_; - + my $guard = $schema->txn_scope_guard; $schema->resultset('Artist')->create({ name => 'Death Cab for Cutie', }); inner(@_); - $guard->commit; } sub inner { my ($schema, $fatal) = @_; - my $guard = $schema->txn_scope_guard; + + my $inner_guard = $schema->txn_scope_guard; + is($schema->storage->transaction_depth, 2, "Correct transaction depth"); my $artist = $artist_rs->find({ name => 'Death Cab for Cutie' }); - is($schema->storage->transaction_depth, 2, "Correct transaction depth"); - undef $@; eval { $artist->cds->create({ title => 'Plans', @@ -311,6 +311,67 @@ $schema->storage->disconnect; die $@; } - # See what happens if we dont $guard->commit; + # inner guard should commit without consequences + $inner_guard->commit; + } +} + +# make sure the guard does not eat exceptions +{ + my $schema = DBICTest->init_schema(); + throws_ok (sub { + my $guard = $schema->txn_scope_guard; + $schema->resultset ('Artist')->create ({ name => 'bohhoo'}); + + $schema->storage->disconnect; # this should freak out the guard rollback + + die 'Deliberate exception'; + }, qr/Deliberate exception.+Rollback failed/s); +} + +# make sure it warns *big* on failed rollbacks +{ + my $schema = DBICTest->init_schema(); + + # something is really confusing Test::Warn here, no time to debug +=begin + warnings_exist ( + sub { + my $guard = $schema->txn_scope_guard; + $schema->resultset ('Artist')->create ({ name => 'bohhoo'}); + + $schema->storage->disconnect; # this should freak out the guard rollback + }, + [ + qr/A DBIx::Class::Storage::TxnScopeGuard went out of scope without explicit commit or error. Rolling back./, + qr/\*+ ROLLBACK FAILED\!\!\! \*+/, + ], + 'proper warnings generated on out-of-scope+rollback failure' + ); +=cut + + my @want = ( + qr/A DBIx::Class::Storage::TxnScopeGuard went out of scope without explicit commit or error. Rolling back./, + qr/\*+ ROLLBACK FAILED\!\!\! \*+/, + ); + + my @w; + local $SIG{__WARN__} = sub { + if (grep {$_[0] =~ $_} (@want)) { + push @w, $_[0]; + } + else { + warn $_[0]; + } + }; + { + my $guard = $schema->txn_scope_guard; + $schema->resultset ('Artist')->create ({ name => 'bohhoo'}); + + $schema->storage->disconnect; # this should freak out the guard rollback } + + is (@w, 2, 'Both expected warnings found'); } + +done_testing;