DBIx::TransactionManager - Transaction handling for database.
RAII style transaction management:
use DBI; use DBIx::TransactionManager; my $dbh = DBI->connect('dbi:SQLite:'); my $tm = DBIx::TransactionManager->new($dbh); # create transaction object my $txn = $tm->txn_scope; # execute query $dbh->do("insert into foo (id, var) values (1,'baz')"); # And you can do multiple database operations here # and commit it. $txn->commit;
Nested transaction usage:
use DBI; use DBIx::TransactionManager; my $dbh = DBI->connect('dbi:SQLite:'); my $tm = DBIx::TransactionManager->new($dbh); { my $txn = $tm->txn_scope; $dbh->do("insert into foo (id, var) values (1,'baz')"); { my $txn2 = $tm->txn_scope; $dbh->do("insert into foo (id, var) values (2,'bab')"); $txn2->commit; } { my $txn3 = $tm->txn_scope; $dbh->do("insert into foo (id, var) values (3,'bee')"); $txn3->commit; } $txn->commit; }
DBIx::TransactionManager is a simple transaction manager. like DBIx::Class::Storage::TxnScopeGuard.
This module provides two futures.
If you are writing of DBIx::* or O/R Mapper, see DBIx::TransactionManager::Developers.
Creating an instance of this class. $dbh is required.
$dbh
Get DBIx::TransactionManager::ScopeGuard's instance object.
Options for this method is only for module creators, see DBIx::TransactionManager::Developers.
Commit the transaction.
If the $tm is in a nested transaction, TransactionManager doesn't do COMMIT at here. TM just poped transaction stack and do nothing.
$tm
Rollback the transaction.
If the $tm is in a nested transaction, TransactionManager doesn't do ROLLBACK at here. TM just poped transaction stack and do nothing.
You cannot use other transaction manager and DBIx::TransactionManager at once.
If you are using O/R mapper, you should use that's transaction management feature.
Atsushi Kobayashi <nekokak _at_ gmail _dot_ com>
DBIx::Class::Storage::TxnScopeGuard
DBIx::Skinny::Transaction
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
To install DBIx::TransactionManager, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::TransactionManager
CPAN shell
perl -MCPAN -e shell install DBIx::TransactionManager
For more information on module installation, please visit the detailed CPAN module installation guide.