Commits the transaction (and turns on auto-committing).
| public commitDbTransaction ( ) |
/**
* Removes a group.
*
* @param mixed $gid A group ID.
*
* @throws Horde_Group_Exception
*/
public function remove($gid)
{
try {
$this->_db->beginDbTransaction();
$this->_db->delete('DELETE FROM horde_groups_members WHERE group_uid = ?', array($gid));
$this->_db->delete('DELETE FROM horde_groups WHERE group_uid = ?', array($gid));
$this->_db->commitDbTransaction();
} catch (Horde_Db_Exception $e) {
throw new Horde_Group_Exception($e);
}
}
/**
*/
public function destroy($id)
{
/* Build the SQL query. */
$query = sprintf('DELETE FROM %s WHERE session_id = ?', $this->_params['table']);
$values = array($id);
/* Execute the query. */
try {
$this->_db->delete($query, $values);
$this->_db->commitDbTransaction();
} catch (Horde_Db_Exception $e) {
return false;
}
return true;
}
/**
*/
public function removeAllVersions($pagename)
{
/* Remove attachments and do other cleanup. */
parent::removeAllVersions($pagename);
$this->_pageNames = null;
try {
$this->_db->beginDbTransaction();
$this->_db->delete('DELETE FROM ' . $this->_params['table'] . ' WHERE page_name = ?', array($this->_convertToDriver($pagename)));
$this->_db->delete('DELETE FROM ' . $this->_params['historytable'] . ' WHERE page_name = ?', array($this->_convertToDriver($pagename)));
$this->_db->commitDbTransaction();
} catch (Horde_Db_Exception $e) {
$this->_db->rollbackDbTransaction();
throw new Wicked_Exception($e);
}
}
/**
*/
public function sort($rules)
{
$old = $this->_filters;
parent::sort($rules);
$query = sprintf('UPDATE %s SET rule_order = ? WHERE rule_id = ?', $this->_params['table_rules']);
$this->_db->beginDbTransaction();
try {
foreach ($this->_filters as $key => $val) {
$this->_db->update($query, array($key, $val['id']));
}
} catch (Horde_Db_Exception $e) {
$this->_db->rollbackDbTransaction();
$this->_filters = $old;
throw new Ingo_Exception($e);
}
$this->_db->commitDbTransaction();
}
/**
* Commits the transaction (and turns on auto-committing).
*/
public function commitDbTransaction()
{
$result = $this->_write->commitDbTransaction();
$this->_lastQuery = $this->_write->getLastQuery();
return $result;
}
