/** * Updates all rows in result set. * @param array ($column => $value) * @return int number of affected rows or FALSE in case of an error */ public function update(array $data) { if (!$data) { return 0; } // joins in UPDATE are supported only in MySQL return $this->connection->queryArgs('UPDATE' . $this->topString() . " {$this->delimitedName} SET ?" . $this->whereString(), array_merge(array($data), $this->parameters))->rowCount(); }
/** * Updates all rows in result set. * Joins in UPDATE are supported only in MySQL * @param array|\Traversable ($column => $value) * @return int number of affected rows or FALSE in case of an error */ public function update($data) { if ($data instanceof \Traversable) { $data = iterator_to_array($data); } elseif (!is_array($data)) { throw new Nette\InvalidArgumentException(); } if (!$data) { return 0; } return $this->connection->queryArgs($this->sqlBuilder->buildUpdateQuery(), array_merge(array($data), $this->sqlBuilder->getParameters()))->getRowCount(); }
/** * Updates all rows in result set. * @param array ($column => $value) * @return int number of affected rows or FALSE in case of an error */ public function update($data) { if ($data instanceof \Traversable) { $data = iterator_to_array($data); } elseif (!is_array($data)) { throw new Nette\InvalidArgumentException(); } if (!$data) { return 0; } // joins in UPDATE are supported only in MySQL return $this->connection->queryArgs('UPDATE' . $this->topString() . " {$this->delimitedName} SET ?" . $this->whereString(), array_merge(array($data), $this->parameters))->rowCount(); }
/** * @param string statement * @param array * @return ResultSet */ public function queryArgs($statement, array $params) { return $this->connection->queryArgs($statement, $params); }