public function deleteCategory($id)
{
try {
return $this->tableGateway->delete(array('id_category' => $id));
} catch (InvalidQueryException $e) {
return 0;
}
}
/**
* Delete a resource
*
* @param mixed $id
* @return ApiProblem|mixed
*/
public function delete($id)
{
$result = $this->fetch($id);
if (!$result) {
return new ApiProblem(404, 'Registro não encontrado');
}
$this->tableGateway->delete(array('id' => $id));
return true;
}
/**
* Save Role
*
* @return integer
*/
public function save()
{
$this->events()->trigger(__CLASS__, 'before.save', $this);
$arraySave = array('name' => $this->getName(), 'description' => $this->getDescription());
try {
$roleId = $this->getId();
if (empty($roleId)) {
$this->insert($arraySave);
$this->setId($this->getLastInsertId());
} else {
$this->update($arraySave, array('id' => $this->getId()));
}
$permissions = $this->getPermissions();
if (!empty($permissions)) {
$aclTable = new TableGateway('user_acl', $this->getAdapter());
$aclTable->delete(array('user_acl_role_id' => $this->getId()));
foreach ($permissions as $permissionId => $value) {
if (!empty($value)) {
$aclTable->insert(array('user_acl_role_id' => $this->getId(), 'user_acl_permission_id' => $permissionId));
}
}
}
$this->events()->trigger(__CLASS__, 'after.save', $this);
return $this->getId();
} catch (\Exception $e) {
$this->events()->trigger(__CLASS__, 'after.save.failed', $this);
throw new \Gc\Exception($e->getMessage(), $e->getCode(), $e);
}
}
/**
* Destroy session
*
* @param string $id
* @return boolean
*/
public function destroy($id)
{
return (bool) $this->tableGateway->delete(array(
$this->options->getIdColumn() => $id,
$this->options->getNameColumn() => $this->sessionName,
));
}
public function deleteanywhere($mytable, $where)
{
$db = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
$table = new TableGateway($mytable, $db);
$table->delete($where);
return 1;
}
/**
* @covers Zend\Db\TableGateway\TableGateway::delete
*/
public function testDelete()
{
$mockDelete = $this->mockSql->delete();
// assert select::from() is called
$mockDelete->expects($this->once())->method('where')->with($this->equalTo('foo'));
$this->table->delete('foo');
}
/**
* Удаляет объект
*
* @param mixed $id
* @return \App\Storage\Mysql\Simple
*/
public function delete($id)
{
if ($id instanceof EntityInterface) {
$id = $id->getKeyValue();
}
$this->tableGateway->delete(array($this->getItemSetProto()->getFactory()->getEntityProto()->getKeyName() => $id));
return $this;
}
/**
* @covers Zend\Db\TableGateway\TableGateway::delete
*/
public function testDelete()
{
$delete = $this->getMock('Zend\\Db\\Sql\\Delete');
// assert select::from() is called
$delete->expects($this->once())->method('where')->with($this->equalTo('foo'));
$this->table->setSqlDelete($delete);
$this->table->delete('foo');
}
/**
* @param Lock\Handle $handle
*/
public function clearLock(Lock\Handle $handle)
{
if (!isset($this->locks[$handle->getToken()])) {
return;
}
$key = $this->locks[$handle->getToken()];
$this->gateway->delete(['key' => $key]);
unset($this->locks[$handle->getToken()]);
}
/**
* @param Request $request
* @param Response $response
* @param $args
*
* @return ResponseInterface
*/
public function remove(Request $request, Response $response, $args)
{
try {
$result = $this->gateway->delete($this->getIdArray($args));
return $response->withJson(["result" => $result]);
} catch (\Exception $e) {
return $response->withStatus(400);
}
}
/**
* Deletes the account with the given id
* @param int|string $id
*/
public function deleteAccount($id)
{
$account = $this->getAccount($id);
$dir = getcwd() . '/public/users/' . $account->getName();
if (file_exists($dir)) {
$this->rrmdir($dir);
}
$this->tableGateway->delete(['id' => $id]);
}
/**
* delete by id of the table or array condition
*
* @param int/array $id
*/
public function delete($id)
{
try {
if (is_array($id)) {
$effectedRows = $this->tableGateway->delete($id);
} else {
$effectedRows = $this->tableGateway->delete(array('id' => (int) $id));
}
} catch (\Exception $e) {
return \Model\Custom\Error::trigger($e, $params);
}
return $effectedRows;
}
/**
* Delete node
*
* @param integer $leftKey
* @param integer $rightKey
* @param array $filter
* @param boolean $useTransaction
* @return boolean|string
*/
public function deleteNode($leftKey, $rightKey, array $filter = [], $useTransaction = true)
{
try {
if ($useTransaction) {
$this->tableGateway->getAdapter()->getDriver()->getConnection()->beginTransaction();
}
$predicate = new Predicate();
$this->tableGateway->delete([$predicate->greaterThanOrEqualTo($this->left, $leftKey), $predicate->lessThanOrEqualTo($this->right, $rightKey)] + $filter);
$predicate = new Predicate();
$this->tableGateway->update([$this->left => new Expression('IF(' . $this->left . ' > ?, ' . $this->left . ' - (? - ? + 1), ' . $this->left . ')', [$leftKey, $rightKey, $leftKey]), $this->right => new Expression($this->right . ' - (? - ? + 1)', [$rightKey, $leftKey])], [$predicate->greaterThan($this->right, $rightKey)] + $filter);
if ($useTransaction) {
$this->tableGateway->getAdapter()->getDriver()->getConnection()->commit();
}
} catch (Exception $e) {
if ($useTransaction) {
$this->tableGateway->getAdapter()->getDriver()->getConnection()->rollback();
}
ApplicationErrorLogger::log($e);
return $e->getMessage();
}
return true;
}
/**
* @param int $id
*/
public function deleteUser($id)
{
$this->tableGateway->delete(array('user_id' => (int) $id));
}
public function delete($version, $mdir_md5)
{
$this->tableGateway->delete(array('version' => $version, 'mdir_md5' => $mdir_md5));
}
/**
* {@inheritdoc}
*
* {@inheritdoc}
*/
public function deleteAll()
{
$where = '1=1';
$deletedItemsCount = $this->dbTable->delete($where);
return $deletedItemsCount;
}
public function dropColumn($columnName, $tableName = null)
{
if ($tableName == null) {
$tableName = $this->table;
}
if (!TableSchema::hasTableColumn($tableName, $columnName, true)) {
return false;
}
if (!$this->acl->hasTablePrivilege($tableName, 'alter')) {
$aclErrorPrefix = $this->acl->getErrorMessagePrefix();
throw new UnauthorizedTableAddException($aclErrorPrefix . 'Table alter access forbidden on table ' . $tableName);
}
// Drop table column if is a non-alias column
if (!array_key_exists($columnName, array_flip(TableSchema::getAllAliasTableColumns($tableName, true)))) {
$sql = new Sql($this->adapter);
$alterTable = new Ddl\AlterTable($tableName);
$dropColumn = $alterTable->dropColumn($columnName);
$query = $sql->getSqlStringForSqlObject($dropColumn);
$this->adapter->query($query)->execute();
}
// Remove column from directus_columns
$columnsTableGateway = new TableGateway('directus_columns', $this->adapter);
$columnsTableGateway->delete(['table_name' => $tableName, 'column_name' => $columnName]);
// Remove column from directus_ui
$uisTableGateway = new TableGateway('directus_ui', $this->adapter);
$uisTableGateway->delete(['table_name' => $tableName, 'column_name' => $columnName]);
return true;
}
/**
* Deletes the news with the corresponding id.
*
* @param int|string $id
*/
public function deleteNews($id)
{
$this->tableGateway->delete(['id' => (int) $id]);
}
/**
* Delete
*
* @param string $where
* @return type
*/
public function delete($where)
{
$this->adapter = $this->masterAdapter;
return parent::delete($where);
}
public function deleteForm($id)
{
$id = (int) $id;
$this->tableGateway->delete(array('id' => $id));
}
<?php
namespace My;
use Zend\Db\TableGateway\TableGateway;
function doSomething()
{
}
$table = new TableGateway('album', $adapter);
// select
$rowset = $table->select(array('id' => 2));
$row = $rowset->current();
// update
$result = $table->update(array('name' => 'Adele'), array('id' => 2));
// delete
$table->delete(array('id' => 2));
/**
* Deletes all comments maked as spam from the database.
*
* @return int - number of rows affected.
*/
public function deleteSpam()
{
return $this->tableGateway->delete(array('spam' => 1));
}
/**
* Delete
*
* @param string $where
* @return type
*/
public function delete($where)
{
$this->initialize();
return parent::delete($where);
}
/**
* Delete property
*
* @return boolean
*/
public function delete()
{
$this->events()->trigger(__CLASS__, 'before.delete', $this);
$id = $this->getId();
if (!empty($id)) {
try {
parent::delete(array('id' => (int) $id));
$table = new TableGateway('property_value', $this->getAdapter());
$table->delete(array('property_id' => (int) $id));
} catch (\Exception $e) {
throw new \Gc\Exception($e->getMessage());
}
$this->events()->trigger(__CLASS__, 'after.delete', $this);
return true;
}
$this->events()->trigger(__CLASS__, 'after.delete.failed', $this);
return false;
}
public function dropColumn($columnName, $tableName = null)
{
if ($tableName == null) {
$tableName = $this->table;
}
if (!TableSchema::hasTableColumn($tableName, $columnName, true)) {
return false;
}
// Drop table column if is a non-alias column
if (!array_key_exists($columnName, array_flip(TableSchema::getAllAliasTableColumns($tableName, true)))) {
$sql = new Sql($this->adapter);
$alterTable = new Ddl\AlterTable($tableName);
$dropColumn = $alterTable->dropColumn($columnName);
$query = $sql->getSqlStringForSqlObject($dropColumn);
$this->adapter->query($query)->execute();
}
// Remove column from directus_columns
$columnsTableGateway = new TableGateway('directus_columns', $this->adapter);
$columnsTableGateway->delete(['table_name' => $tableName, 'column_name' => $columnName]);
// Remove column from directus_ui
$uisTableGateway = new TableGateway('directus_ui', $this->adapter);
$uisTableGateway->delete(['table_name' => $tableName, 'column_name' => $columnName]);
return true;
}
/**
* Delete document
*
* @return boolean
*/
public function delete()
{
$this->events()->trigger(__CLASS__, 'before.delete', $this);
$documentId = $this->getId();
if (!empty($documentId)) {
try {
$propertiesTable = new TableGateway('property_value', $this->getAdapter());
$propertiesTable->delete(array('document_id' => $this->getId()));
parent::delete(array('id' => $documentId));
} catch (\Exception $e) {
throw new \Gc\Exception($e->getMessage(), $e->getCode(), $e);
}
$this->events()->trigger(__CLASS__, 'after.delete', $this);
unset($this);
return true;
}
$this->events()->trigger(__CLASS__, 'after.delete.failed', $this);
return false;
}
public function delete($version)
{
$this->tableGateway->delete(['version' => $version]);
}
/**
* Deletes data
*/
public function delete()
{
if (array_key_exists($this->primary, $this->data)) {
$this->table->delete(array($this->primary => $this->data[$this->primary]));
}
}
/**
* Garbage Collection
*
* @param int $maxlifetime
* @return true
*/
public function gc($maxlifetime)
{
$platform = $this->tableGateway->getAdapter()->getPlatform();
return (bool) $this->tableGateway->delete(sprintf('%s + %s < %d', $platform->quoteIdentifier($this->options->getModifiedColumn()), $platform->quoteIdentifier($this->options->getLifetimeColumn()), time()));
}
/**
* {@inheritDoc}
*/
protected function doDeleteModel($model)
{
$this->tableGateway->delete(array("{$this->idField} = ?" => $this->getModelId($model)));
}
