stefano/stefano-lock-table

Build lock table sql query

0.0.2 2014-01-23 17:35 UTC

README

Test Status Code Coverage Dependencies 68747470733a2f2f7365637572652e7472617669 Coverage Status Dependency Status

Instalation using Composer

  1. Add following line to composer.json "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();