inlm/dibi-transactions

Nested transactions for Dibi.

Inlm\DibiTransactions

, _(*1)

Nested transactions for Dibi., _(*2)

, _(*3)

Installation

Download a latest package or use Composer:, _(*4)

composer require inlm/dibi-transactions

Inlm\Dibi-transactions requires PHP 8.0 or later and Dibi., _(*5)

Usage

``` php $connection = new Dibi\Connection(); $transactions = new Inlm\DibiTransactions\Transactions($connection);, <sub>(*6)</sub>

### `transactional()`

``` php
$value = $transactions->transactional(function () use ($connection) {
    $connection->query('...');
    $connection->query('...');
    return $value;
});

Transaction

``` php $transaction = $transactions->createTransaction();, <sub>(*7)</sub>

try { $connection->query('...'); $connection->query('...'); $transaction->commit();, <sub>(*8)</sub>

} catch (Exception $e) { $transaction->rollback(); throw $e; }, <sub>(*9)</sub>

Object `Transaction` throws error if you forget to call `commit()` or `rollback()`. It can be connected with [Tracy](https://tracy.nette.org/):

``` php
$transactions->onUnresolved[] = array(Inlm\DibiTransactions\Bridges\Tracy::class, 'logUnresolved');

begin / commit / rollback

``` php try { $transactions->begin(); $connection->query('...'); $connection->query('...'); $transactions->commit();, <sub>(*10)</sub>

} catch (Exception $e) { $transactions->rollback(); } ```, <sub>(*11)</sub>

License: New BSD License
Author: Jan Pecha, https://www.janpecha.cz/, <sub>(*12)</sub>