Transaction Support

[kelunik]

There should be examples for transactions and probably a dedicated API.

[shtse8]

Any updates?

[kelunik]

Not yet, feel free to make an API suggestion.

[shtse8]

$connection = $mysqlPool->getConnection();

• Get a free connection from the pool. the marking the connection is busy.

$connection->query();

• query using the connection.

$connection->release();

• Release back the connection to the connection pool.

$connection->beginTransaction();

• query START TRANSACTION

$connection->commit();

• query COMMIT

$connection->rollback();

• query ROLLBACK

$connection = $mysqlPool->beginTransaction();

• auto calling $mysqlPool->getConnection(), then $connection->beginTransaction(), return a ready-to-use connection for transaction.

Example Usage:

$connection = $mysqlPool->beginTransaction();
$connection->query("SELECT 1");
$connection->commit();
$connection->release();

or

$connection = $mysqlPool->getConnection();
$connection->beginTransaction();
$connection->query("SELECT 1");
$connection->commit();
$connection->release();

[kelunik]

@trowski This has been implemented, no?

[bwoebi]

@kelunik Yes, it was. See e.g. https://github.com/amphp/mysql/blob/master/examples/6-transaction.php