NAME

DBIx::TransactionManager - Transaction handling for database.

SYNOPSIS

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;
}

DESCRIPTION

DBIx::TransactionManager is a simple transaction manager. like DBIx::Class::Storage::TxnScopeGuard.

This module provides two futures.

RAII based transaction management

Nested transaction management

If you are writing of DBIx::* or O/R Mapper, see DBIx::TransactionManager::Developers.

METHODS

my $tm = DBIx::TransactionManager->new($dbh)

Creating an instance of this class. $dbh is required.

my $txn = $tm->txn_scope(%args)

Get DBIx::TransactionManager::ScopeGuard's instance object.

Options for this method is only for module creators, see DBIx::TransactionManager::Developers.

DBIx::TransactionManager::ScopeGuard's METHODS

$txn->commit()

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.

$txn->rollback()

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.

DBIx::TransactionManager and other transaction managers

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.

AUTHOR

Atsushi Kobayashi <nekokak _at_ gmail _dot_ com>

SEE ALSO

DBIx::Class::Storage::TxnScopeGuard

DBIx::Skinny::Transaction

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.