/**
* @param string $key
*/
public function clearExpiredLock($key = null)
{
$currDate = date($this->options->getDbDateTimeFormat());
$delete = $this->gateway->getSql()->delete();
$pred = $delete->where->lessThanOrEqualTo('end_datetime', $currDate);
if ($key) {
$pred = $pred->and->equalTo('key', $key);
}
$this->gateway->deleteWith($delete);
}
public function index09Action()
{
$table = "user";
$adapter = $this->getServiceLocator()->get("db_books");
$tableGateway = new TableGateway($table, $adapter);
$deleteObj = new Delete("user");
$deleteObj->where->equalTo("id", "6");
echo $tableGateway->deleteWith($deleteObj);
return false;
}
