Esempi in PHP per Opis\Database\SQL UpdateStatement::getJoinClauses

Esempio n. 1

File: SQLServer.php Progetto: Textalk/opis-database

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

Esempio n. 2

File: Compiler.php Progetto: cgslivre/database-1

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