library ntdb

minetro/ntdb

Nette Database Nested Transaction

, _(*1)

, _(*2)

Website 🚀 contributte.org | Contact 👨🏻‍💻 f3l1x.io | Twitter 🐦 @contributte , _(*3)

Disclaimer

Composer	minetro/ntdb
Version
PHP
License

Resources

Inspired by these articles:, _(*4)

• http://www.yiiframework.com/wiki/38/how-to-use-nested-db-transactions-mysql-5-postgresql/
• http://www.kennynet.co.uk/2008/12/02/php-pdo-nested-transactions/
• https://gist.github.com/neoascetic/5269127

Usage

Provide nested transaction via savepoints., _(*5)

Support, _(*6)

• MySQL / MySQLi
• PostgreSQL
• SQLite

API, _(*7)

• $t->begin
• $t->commit
• $t->rollback
• $t->transaction or $t->t
• $t->promise

Begin

Starts transaction., _(*8)

$t = new Transaction(new Connection(...));
$t->begin();

Commit

Commit changes in transaction., _(*9)

$t = new Transaction(new Connection(...));
$t->begin();
// some changes..
$t->commit();

Rollback

Revert changes in transaction., _(*10)

$t = new Transaction(new Connection(...));

$t->begin();
try {
    // some changes..
    $t->commit();
} catch (Exception $e) {
    $t->rollback();
}

Transaction

Combine begin, commit and rollback to one method., _(*11)

On success it commits changes, if exceptions is thrown it rollbacks changes., _(*12)

$t = new Transaction(new Connection(...));

$t->transaction(function() {
    // some changes..
});

// or alias

$t->t(function() {
    // some changes..
});

Promise

Another attitude to transaction., _(*13)

$t = new Transaction(new Connection(...));

$t->promise()->then(
    function() {
        // Logic.. (save/update/remove some data)
    }, 
    function () {
        // Success.. (after commit)
    },
    function() {
        // Failed.. (after rollback)
    }
);

UnresolvedTransactionException

Log unresolved transaction., _(*14)

Idea by Ondrej Mirtes (https://ondrej.mirtes.cz/detekce-neuzavrenych-transakci)., _(*15)

$t = new Transaction(new Connection(...));
$t->onUnresolved[] = function($exception) {
    Tracy\Debugger::log($exception);
};

Nette

EXTENSION

extensions:
    ntdb: Minetro\Database\Transaction\DI\Transaction

That's all. You can let nette\di autowired it to your services/presenters., _(*16)

NEON

Register as service in your config file., _(*17)

services:
    - Minetro\Database\Transaction\Transaction

On multiple connections you have to specific one., _(*18)

services:
    - Minetro\Database\Transaction\Transaction(@nette.database.one.connection)
    # or
    - Minetro\Database\Transaction\Transaction(@nette.database.two.connection)

Repository | Presenter

use Minetro\Database\Transaction\Transaction;

class MyRepository {

    function __construct(Connection $connection) {
        $this->transaction = new Transaction($connection);
    }

    // OR

    function __construct(Context $context) {
        $this->transaction = new Transaction($context->getConnection());
    }
}

class MyPresenter {

    public function processSomething() {
        $transaction->transaction(function() {
            // Save one..

            // Make other..

            // Delete from this..

            // Update everything..
        });
    }
}

Development

This package was maintain by these authors., _(*19)

, _(*20)

Consider to support contributte development team. Also thank you for being used this package., _(*21)