X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F750firebird.t;h=26927bfdfb47e8ecf6abcf81b4afd4a32a31a8e4;hb=e02b39b48c5cca4812acb88d0bb71443cd8c8ff9;hp=3618edf97422d94622e8a1210e9e387ebc5b829a;hpb=07cda1c5a7df6656772dfd65c488c19c15126168;p=dbsrgits%2FDBIx-Class.git diff --git a/t/750firebird.t b/t/750firebird.t index 3618edf..26927bf 100644 --- a/t/750firebird.t +++ b/t/750firebird.t @@ -100,6 +100,17 @@ EOF my $st = $schema->resultset('SequenceTest')->create({ name => 'foo', pkid1 => 55 }); is($st->pkid1, 55, "Firebird Auto-PK without trigger: First primary key set manually"); +# test transaction commit + $schema->txn_do(sub { + $ars->create({ name => 'in_transaction' }); + }); + ok (($ars->search({ name => 'in_transaction' })->first), + 'transaction committed'); + is $schema->storage->_dbh->{AutoCommit}, 1, + '$dbh->{AutoCommit} is correct after transaction commit'; + + $ars->search({ name => 'in_transaction' })->delete; + # test savepoints throws_ok { $schema->txn_do(sub { @@ -117,6 +128,9 @@ EOF } qr/rolling back outer txn/, 'correct exception for rollback'; + is $schema->storage->_dbh->{AutoCommit}, 1, + '$dbh->{AutoCommit} is correct after transaction rollback'; + ok ((not $ars->search({ name => 'in_outer_txn' })->first), 'outer txn rolled back'); @@ -218,7 +232,8 @@ EOF "id" INT PRIMARY KEY, "bytea" INT, "blob" BLOB, - "clob" BLOB SUB_TYPE TEXT + "clob" BLOB SUB_TYPE TEXT, + "a_memo" INT ) ]);