public function createUpdateOne($table, $primaryColumn, $primaryValue, array $values) { $type = is_object($primaryValue) ? get_class($primaryValue) : gettype($primaryValue); $query = new Query($this->connection->update($table, $values)); $query->fluent->where("%n = " . $query->getModificators()[$type], $primaryColumn, $primaryValue); $query->resultCallback = function (Query $query) { $query->fluent->execute(); return $this->connection->getAffectedRows() === 0 ? false : true; }; return $query; }
/** * Generates and executes SQL query. * @param mixed what to return? * @return DibiResult|int result set object (if any) * @throws DibiException */ public function execute($return = NULL) { $res = $this->query($this->_export()); switch ($return) { case dibi::IDENTIFIER: return $this->connection->getInsertId(); case dibi::AFFECTED_ROWS: return $this->connection->getAffectedRows(); default: return $res; } }
public function deleteBetweenField($field, $left, $right) { $sql = 'DELETE FROM %n WHERE %n BETWEEN %i AND %i'; $this->dibi->query($sql, $this->table_name, $field, $left, $right); return $this->dibi->getAffectedRows(); }
/** * @param int $id * @return bool */ public function delete($id) { $this->database->delete(self::TABLE)->where(self::TABLE . '.id = %i', $id)->execute(); return $this->database->getAffectedRows() == 1; }
/** * @inheritDoc */ function invalidateToken($token) { $this->dbConnection->query('DELETE FROM %n', $this->tableName, 'WHERE [token] = %s', $token); return $this->dbConnection->getAffectedRows() > 0; }