public function update(UpdateStatement $update) { $joins = $this->handleJoins($update->getJoinClauses()); $tables = $update->getTables(); if ($joins !== '') { $joins = ' FROM ' . $this->handleTables($tables) . ' ' . $joins; $tables = array_values($tables); } $sql = 'UPDATE '; $sql .= $this->handleTables($tables); $sql .= $this->handleSetColumns($update->getColumns()); $sql .= $joins; $sql .= $this->handleWheres($update->getWhereConditions()); return $sql; }
/** * @param array $columns * * @return int */ public function set(array $columns) { parent::set($columns); $compiler = $this->connection->getCompiler(); return $this->connection->count($compiler->update($this->sql), $compiler->getParams()); }
/** * Returns the SQL for a update statement * * @param \Opis\Database\SQL\UpdateStatement $update * * @return string */ public function update(UpdateStatement $update) { $sql = 'UPDATE '; $sql .= $this->handleTables($update->getTables()); $sql .= $this->handleJoins($update->getJoinClauses()); $sql .= $this->handleSetColumns($update->getColumns()); $sql .= $this->handleWheres($update->getWhereConditions()); return $sql; }
/** * @param array $columns * * @return int */ public function set(array $columns) { parent::set($columns); return $this->connection->count((string) $this, $this->compiler->getParams()); }