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; }
/** * 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; }