class Update in Drupal driver for SQL Server and SQL Azure 8
Same name and namespace in other branches
- 8.2 drivers/lib/Drupal/Driver/Database/sqlsrv/Update.php \Drupal\Driver\Database\sqlsrv\Update
- 3.0.x drivers/lib/Drupal/Driver/Database/sqlsrv/Update.php \Drupal\Driver\Database\sqlsrv\Update
Hierarchy
- class \Drupal\Core\Database\Query\Query implements PlaceholderInterface
- class \Drupal\Core\Database\Query\Update implements ConditionInterface uses QueryConditionTrait
- class \Drupal\Driver\Database\sqlsrv\Update
- class \Drupal\Core\Database\Query\Update implements ConditionInterface uses QueryConditionTrait
Expanded class hierarchy of Update
File
- drivers/
lib/ Drupal/ Driver/ Database/ sqlsrv/ Update.php, line 24 - Definition of Drupal\Driver\Database\sqlsrv\Update
Namespace
Drupal\Driver\Database\sqlsrvView source
class Update extends QueryUpdate {
public function execute() {
// Retrieve query options.
$options = $this->queryOptions;
// Fetch the list of blobs and sequences used on that table.
$columnInformation = $this->connection
->schema()
->queryColumnInformation($this->table);
// Because we filter $fields the same way here and in __toString(), the
// placeholders will all match up properly.
$stmt = $this->connection
->prepareQuery((string) $this);
// Expressions take priority over literal fields, so we process those first
// and remove any literal fields that conflict.
$fields = $this->fields;
DatabaseUtils::BindExpressions($stmt, $this->expressionFields, $fields);
// We use this array to store references to the blob handles.
// This is necessary because the PDO will otherwise messes up with references.
$blobs = array();
DatabaseUtils::BindValues($stmt, $fields, $blobs, ':db_update_placeholder_', $columnInformation);
// Add conditions.
if (count($this->condition)) {
$this->condition
->compile($this->connection, $this);
$arguments = $this->condition
->arguments();
DatabaseUtils::BindArguments($stmt, $arguments);
}
$options = $this->queryOptions;
$options['already_prepared'] = TRUE;
$this->connection
->query($stmt, array(), $options);
return $stmt
->rowCount();
}
public function __toString() {
// Create a sanitized comment string to prepend to the query.
$prefix = $this->connection
->makeComment($this->comments);
// Expressions take priority over literal fields, so we process those first
// and remove any literal fields that conflict.
$fields = $this->fields;
$update_fields = array();
foreach ($this->expressionFields as $field => $data) {
$update_fields[] = $this->connection
->quoteIdentifier($field) . '=' . $data['expression'];
unset($fields[$field]);
}
$max_placeholder = 0;
foreach ($fields as $field => $value) {
$update_fields[] = $this->connection
->quoteIdentifier($field) . '=:db_update_placeholder_' . $max_placeholder++;
}
$query = $prefix . 'UPDATE {' . $this->connection
->escapeTable($this->table) . '} SET ' . implode(', ', $update_fields);
if (count($this->condition)) {
$this->condition
->compile($this->connection, $this);
// There is an implicit string cast on $this->condition.
$query .= "\nWHERE " . $this->condition;
}
return $query;
}
}
Members
Name | Modifiers | Type | Description | Overrides |
---|---|---|---|---|
Query:: |
protected | property | An array of comments that can be prepended to a query. | |
Query:: |
protected | property | The connection object on which to run this query. | |
Query:: |
protected | property | The key of the connection object. | |
Query:: |
protected | property | The target of the connection object. | |
Query:: |
protected | property | The placeholder counter. | |
Query:: |
protected | property | The query options to pass on to the connection object. | |
Query:: |
protected | property | A unique identifier for this query object. | |
Query:: |
public | function | Adds a comment to the query. | |
Query:: |
public | function | Returns a reference to the comments array for the query. | |
Query:: |
public | function |
Gets the next placeholder value for this query object. Overrides PlaceholderInterface:: |
|
Query:: |
public | function |
Returns a unique identifier for this object. Overrides PlaceholderInterface:: |
|
Query:: |
public | function | Implements the magic __clone function. | 1 |
Query:: |
public | function | Implements the magic __sleep function to disconnect from the database. | |
Query:: |
public | function | Implements the magic __wakeup function to reconnect to the database. | |
QueryConditionTrait:: |
protected | property | The condition object for this query. | |
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | 1 | |
QueryConditionTrait:: |
public | function | 1 | |
QueryConditionTrait:: |
public | function | 1 | |
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
QueryConditionTrait:: |
public | function | ||
Update:: |
protected | property | An array of values to update to. | |
Update:: |
protected | property | Array of fields to update to an expression in case of a duplicate record. | |
Update:: |
protected | property | An array of fields that will be updated. | |
Update:: |
protected | property | The table to update. | |
Update:: |
public | function |
Executes the UPDATE query. Overrides Update:: |
|
Update:: |
public | function | Specifies fields to be updated as an expression. | |
Update:: |
public | function | Adds a set of field->value pairs to be updated. | |
Update:: |
public | function |
Constructs an Update query object. Overrides Query:: |
|
Update:: |
public | function |
Implements PHP magic __toString method to convert the query to a string. Overrides Update:: |