PHP TableGateway::delete方法代码示例

 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);
     }
 }

 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;
 }