Executes the SQL statement in the context of this connection.
/**
* Sets a script running on the backend.
*
* @param array $script The filter script information. Passed elements:
* - 'name': (string) the script name.
* - 'recipes': (array) the filter recipe objects.
* - 'script': (string) the filter script.
*
* @throws Ingo_Exception
*/
public function setScriptActive($script)
{
$this->_connect();
try {
foreach ($script['recipes'] as $recipe) {
$this->_db->execute($recipe['object']->generate());
}
} catch (Horde_Db_Exception $e) {
throw new Ingo_Exception($e);
}
}
/**
* Executes the SQL statement in the context of this connection.
*
* @param string $sql SQL statement.
* @param mixed $arg1 Either an array of bound parameters or a query
* name.
* @param string $arg2 If $arg1 contains bound parameters, the query
* name.
*
* @return PDOStatement
* @throws Horde_Db_Exception
*/
public function execute($sql, $arg1 = null, $arg2 = null)
{
// Can't assume this will always be a read action, use _write.
$result = $this->_write->execute($sql, $arg1, $arg2);
$this->_lastQuery = $this->_write->getLastQuery();
// Once doing writes, keep using the write backend even for reads
// at least during the same request, to help against stale data.
$this->_read = $this->_write;
return $result;
}
/**
* Implementation of the rewind() method for iterator.
*/
public function rewind()
{
if ($this->_result) {
unset($this->_result);
}
$this->_current = null;
$this->_index = null;
$this->_eof = true;
$this->_result = $this->_adapter->execute($this->_sql, $this->_arg1, $this->_arg2);
$this->next();
}
public function getMany($num = 50)
{
$tasks = array();
$values = array();
$query = 'SELECT * FROM horde_queue_tasks where task_queue = ? ORDER BY task_id LIMIT ?';
$values[] = $this->_queue;
$values[] = $num;
try {
$rows = $this->_db->selectAll($query, $values);
} catch (Horde_Db_Exception $e) {
throw new Horde_Queue_Exception($e);
}
$query = 'DELETE FROM horde_queue_tasks WHERE task_id = ?';
foreach ($rows as $row) {
$tasks[] = unserialize($row['task_fields']);
// TODO: Evaluate if a single call for all IDs is faster for various scenarios
try {
$rows = $this->_db->execute($query, array($row['task_id']));
} catch (Horde_Db_Exception $e) {
throw new Horde_Queue_Exception($e);
}
}
return $tasks;
}
/**
* Create table for submiting data.
*
* @return boolean True on success.
* @throws Ulaform_Exception
*/
protected function _createDataTable($form_params, $fields)
{
/* Generate SQL query. */
$columns = array();
foreach ($fields as $field) {
switch ($field['field_type']) {
case 'file':
case 'image':
// TODO: Use Horde_SQL
switch (Horde_String::lower($this->_db->adapterName())) {
case 'pgsql':
$columns[] = $field['field_name'] . ' TEXT';
break;
case 'mysql':
case 'mysqli':
$columns[] = $field['field_name'] . ' MEDIUMBLOB';
break;
default:
$columns[] = $field['field_name'] . ' BLOB';
break;
}
break;
case 'address':
case 'countedtext':
case 'description':
case 'html':
case 'longtext':
case 'set':
$columns[] = $field['field_name'] . ' TEXT';
break;
default:
$columns[] = $field['field_name'] . ' VARCHAR(255)';
break;
}
}
$sql = sprintf('CREATE TABLE %s (%s)', $form_params['table'], implode(', ', $columns));
/* Create table. */
try {
$this->_db->execute($sql);
} catch (Horde_Db_Exception $e) {
throw new Ulaform_Exception($e);
}
return true;
}
/**
* Saves a forum, either creating one if no forum ID is given or updating
* an existing one.
*
* @param array $info The forum information to save consisting of:
* forum_id
* forum_author
* forum_parent_id
* forum_name
* forum_moderated
* forum_description
* forum_attachments
*
* @return integer The forum ID on success.
* @throws Agora_Exception
*/
public function saveForum($info)
{
if (empty($info['forum_id'])) {
if (empty($info['author'])) {
$info['author'] = $GLOBALS['registry']->getAuth();
}
$info['forum_id'] = $this->newForum($info['forum_name'], $info['author']);
}
$sql = 'UPDATE ' . $this->_forums_table . ' SET forum_name = ?, forum_parent_id = ?, ' . 'forum_description = ?, forum_moderated = ?, ' . 'forum_attachments = ?, forum_distribution_address = ? ' . 'WHERE forum_id = ?';
$values = array($this->convertToDriver($info['forum_name']), (int) $info['forum_parent_id'], $this->convertToDriver($info['forum_description']), (int) $info['forum_moderated'], isset($info['forum_attachments']) ? (int) $info['forum_attachments'] : abs($GLOBALS['conf']['forums']['enable_attachments']), isset($info['forum_distribution_address']) ? $info['forum_distribution_address'] : '', $info['forum_id']);
try {
$this->_db->execute($sql, $values);
} catch (Horde_Db_Exception $e) {
throw new Agora_Exception($e->getMessage());
}
$this->_updateCacheState(0);
$this->_cache->expire('agora_forum_' . $info['forum_id'], $GLOBALS['conf']['cache']['default_lifetime']);
return $info['forum_id'];
}
