stefano/stefano-lock-table

Build lock table sql query

0.1.1 2022-09-30 18:39 UTC

Requires

• php: >=7.1.0

Requires (Dev)

• mockery/mockery: ^1.0.0
• php-coveralls/php-coveralls: ^2.0
• phpunit/phpunit: >=7 <10

BSD-3-Clause

• Štefan Bartko

• Lock-Table

README

Instalation using Composer

1. Run command composer require stefano/stefano-lock-table

Features

• build lock table sql string
• build unlock table sql string
• supported vendors mysql, postgresql

Usage

$factory = new \StefanoLockTable\Factory();

$vendor = 'Mysql'; //or any supported database
$adapter = $factory->createAdapter($vendor);

//build lock table sql string (exclusive lock)
$adapter->getLockSqlString('tableName');
$adapter->getLockSqlString(array('tableName', 'anotherTable'));

//build unlock table sql string
$adapter->getUnlockSqlString();