Nette\Database\Table\SqlBuilder::buildUpdateQuery PHP Метод

buildUpdateQuery() публичный Метод

public buildUpdateQuery ( )
    public function buildUpdateQuery()
    {
        $query = "UPDATE {$this->delimitedTable} SET ?set" . $this->tryDelimite($this->buildConditions());
        if ($this->limit !== NULL || $this->offset) {
            $this->driver->applyLimit($query, $this->limit, $this->offset);
        }
        return $query;
    }

Usage Example

Пример #1
0
 /**
  * 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
  */
 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->context->queryArgs($this->sqlBuilder->buildUpdateQuery(), array_merge(array($data), $this->sqlBuilder->getParameters()))->getRowCount();
 }