public Upsert::__toString()
Implements PHP magic __toString method to convert the query to a string.
The toString operation is how we compile a query object to a prepared statement.
Return value
string A prepared statement query string for this object.
Overrides Query::__toString
File
- core/lib/Drupal/Core/Database/Driver/mysql/Upsert.php, line 15
Class
- Upsert
- MySQL implementation of \Drupal\Core\Database\Query\Upsert.
Namespace
Drupal\Core\Database\Driver\mysql
Code
public function __toString() { // Create a sanitized comment string to prepend to the query. $comments = $this->connection->makeComment($this->comments); // Default fields are always placed first for consistency. $insert_fields = array_merge($this->defaultFields, $this->insertFields); $query = $comments . 'INSERT INTO {' . $this->table . '} (' . implode(', ', $insert_fields) . ') VALUES '; $values = $this->getInsertPlaceholderFragment($this->insertValues, $this->defaultFields); $query .= implode(', ', $values); // Updating the unique / primary key is not necessary. unset($insert_fields[$this->key]); $update = []; foreach ($insert_fields as $field) { $update[] = "$field = VALUES($field)"; } $query .= ' ON DUPLICATE KEY UPDATE ' . implode(', ', $update); return $query; }
Please login to continue.