/** * 编译update语句 * * @param CatLib\Database\Grammars\Builder $query * @param array $values * @return string */ public function compileUpdate(Builder $query, $values) { $sql = parent::compileUpdate($query, $values); if (isset($query->orders)) { $sql .= ' ' . $this->compileOrders($query, $query->orders); } if (isset($query->limit)) { $sql .= ' ' . $this->compileLimit($query, $query->limit); } return rtrim($sql); }
/** * 执行更新记录 * * @param array $values * @return int */ public function update(array $values) { $bindings = array_values(array_merge($values, $this->getBindings())); $sql = $this->grammar->compileUpdate($this, $values); return $this->connection->update($sql, $this->cleanBindings($bindings)); }