public function deleteSession($username)
{
$delete = new Delete();
$adapter = $this->table_gateway->getAdapter();
$delete->from('sessions')->where(array('username' => $username, 'session_id' => session_id()));
$adapter->query($this->sql->buildSqlString($delete), $adapter::QUERY_MODE_EXECUTE);
return true;
}
/**
* @covers Zend\Db\Sql\Delete::getSqlString
*/
public function testGetSqlString()
{
$this->delete->from('foo')->where('x = y');
$this->assertEquals('DELETE FROM "foo" WHERE x = y', $this->delete->getSqlString());
// with TableIdentifier
$this->delete = new Delete();
$this->delete->from(new TableIdentifier('foo', 'sch'))->where('x = y');
$this->assertEquals('DELETE FROM "sch"."foo" WHERE x = y', $this->delete->getSqlString());
}
public function unlink($userId, $addressId)
{
$adapter = $this->getDbAdapter();
$statement = $adapter->createStatement();
$where = new Where();
$where->equalTo('user_id', $userId)->equalTo('address_id', $addressId);
$delete = new Delete();
$delete->from('user_addresses')->where($where);
$delete->prepareStatement($adapter, $statement);
$result = $statement->execute();
return $result;
}
/**
* Uninstall from module name
*
* @param AbstractModule $module Module
* @param Model $model Module model
*
* @return boolean
*/
public static function uninstall($module, $model)
{
if (empty($model) or !$module->uninstall()) {
return false;
}
$select = new Sql\Select();
$select->from('user_acl_permission')->columns(array('id'))->where->equalTo('permission', $model->getName());
$userAclPermissionId = $model->fetchOne($select);
$delete = new Sql\Delete();
$delete->from('user_acl');
$delete->where->equalTo('user_acl_permission_id', $userAclPermissionId);
$model->execute($delete);
$delete = new Sql\Delete();
$delete->from('user_acl_permission');
$delete->where->equalTo('id', $userAclPermissionId);
$model->execute($delete);
$model->delete();
return true;
}
/**
* Save document type model
*
* @return integer
*/
public function save()
{
$this->events()->trigger(__CLASS__, 'before.save', $this);
$arraySave = array('name' => $this->getName(), 'updated_at' => new Expression('NOW()'), 'description' => $this->getDescription(), 'icon_id' => $this->getIconId(), 'default_view_id' => $this->getDefaultViewId(), 'user_id' => $this->getUserId());
try {
$id = $this->getId();
if (empty($id)) {
$arraySave['created_at'] = new Expression('NOW()');
$this->insert($arraySave);
$this->setId($this->getLastInsertId());
} else {
$this->update($arraySave, array('id' => (int) $this->getId()));
}
$delete = new Sql\Delete();
$delete->from('document_type_view');
$delete->where(array('document_type_id' => (int) $this->getId()));
$this->execute($delete);
foreach ($this->views as $viewId) {
if (empty($viewId)) {
continue;
}
$insert = new Sql\Insert();
$insert->into('document_type_view')->values(array('document_type_id' => $this->getId(), 'view_id' => $viewId));
$this->execute($insert);
}
$delete = new Sql\Delete();
$delete->from('document_type_dependency');
$delete->where->equalTo('parent_id', (int) $this->getId());
$this->execute($delete);
$dependencies = $this->getDependencies();
if (!empty($dependencies)) {
foreach ($dependencies as $childrenId) {
$insert = new Sql\Insert();
$insert->into('document_type_dependency')->values(array('parent_id' => $this->getId(), 'children_id' => $childrenId));
$this->execute($insert);
}
}
$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 deleteData($table, $where)
{
$sql = new Sql($this->dbAdapter);
$action = new Delete();
$action->from($table);
$action->where($where);
$stmt = $sql->prepareStatementForSqlObject($action);
$result = $stmt->execute();
return $result;
}
