/** * Do delete action, this method should be override by sub class. * * @param string $table The table name. * @param mixed $conditions Where conditions, you can use array or Compare object. * * @throws \Exception * @return boolean Will be always true. */ public function delete($table, array $conditions = array()) { $query = $this->db->getQuery(true); // Conditions. QueryHelper::buildWheres($query, $conditions); $query->delete($table); return $this->db->setQuery($query)->execute(); }
/** * Destruct. */ public function __destruct() { if (!self::$dbo) { return; } static::$debug or self::$dbo->setQuery('DROP DATABASE IF EXISTS ' . self::$dbo->quoteName(static::$dbname))->execute(); self::$dbo = null; }
/** * gc * * @param string $past * * @return bool */ public function gc($past) { $query = $this->db->getQuery(true); $query->delete($this->db->quoteName($this->options['table']))->where($this->db->quoteName($this->options['time_col']) . ' < ' . $this->db->quote((int) $past)); // Remove expired sessions from the database. $this->db->setQuery($query); return (bool) $this->db->execute(); }
/** * batchQuery * * @param AbstractDatabaseDriver $db * @param array|string $queries * * @return boolean */ public static function batchQuery(AbstractDatabaseDriver $db, $queries) { if (is_string($queries)) { $queries = $db->splitSql($queries); } foreach ((array) $queries as $query) { if (!trim($query)) { continue; } $db->setQuery($query)->execute(); } return true; }
/** * Validate that the primary key has been set. * * @return boolean True if the primary key(s) have been set. * * @since 2.0 */ public function hasPrimaryKey() { if ($this->autoIncrement) { $empty = true; foreach ($this->keys as $key) { $empty = $empty && !$this->{$key}; } } else { $query = $this->db->getQuery(true); $query->select('COUNT(*)')->from($this->table); $this->appendPrimaryKeys($query); $this->db->setQuery($query); $count = $this->db->loadResult(); if ($count == 1) { $empty = false; } else { $empty = true; } } return !$empty; }
/** * Batch update some data. * * @param string $table Table name. * @param array $data Data you want to update. * @param mixed $conditions Where conditions, you can use array or Compare object. * Example: * - `array('id' => 5)` => id = 5 * - `new GteCompare('id', 20)` => 'id >= 20' * - `new Compare('id', '%Flower%', 'LIKE')` => 'id LIKE "%Flower%"' * * @return boolean True if update success. */ public function updateBatch($table, $data, $conditions = array()) { $query = $this->db->getQuery(true); // Build conditions $query = QueryHelper::buildWheres($query, $conditions); // Build update values. $fields = array_keys($this->db->getTable($table)->getColumns()); $hasField = false; foreach ((array) $data as $field => $value) { if (!in_array($field, $fields)) { continue; } $query->set($query->format('%n = %q', $field, $value)); $hasField = true; } if (!$hasField) { return false; } $query->update($table); return $this->db->setQuery($query)->execute(); }
/** * setQuery * * @param Query $query * * @return $this */ public function setQuery($query) { $this->db->setQuery($query); return $this; }