class UpdateQuery_pgsql
Hierarchy
- class \Query implements QueryPlaceholderInterface
- class \UpdateQuery implements QueryConditionInterface
- class \UpdateQuery_pgsql
- class \UpdateQuery implements QueryConditionInterface
Expanded class hierarchy of UpdateQuery_pgsql
Related topics
File
- drupal-7.x/
includes/ database/ pgsql/ query.inc, line 151 - Query code for PostgreSQL embedded database engine.
View source
class UpdateQuery_pgsql extends UpdateQuery {
public function execute() {
$max_placeholder = 0;
$blobs = array();
$blob_count = 0;
// Because we filter $fields the same way here and in __toString(), the
// placeholders will all match up properly.
$stmt = $this->connection->prepareQuery((string) $this);
// Fetch the list of blobs and sequences used on that table.
$table_information = $this->connection->schema()->queryTableInformation($this->table);
// Expressions take priority over literal fields, so we process those first
// and remove any literal fields that conflict.
$fields = $this->fields;
$expression_fields = array();
foreach ($this->expressionFields as $field => $data) {
if (!empty($data['arguments'])) {
foreach ($data['arguments'] as $placeholder => $argument) {
// We assume that an expression will never happen on a BLOB field,
// which is a fairly safe assumption to make since in most cases
// it would be an invalid query anyway.
$stmt->bindParam($placeholder, $data['arguments'][$placeholder]);
}
}
unset($fields[$field]);
}
foreach ($fields as $field => $value) {
$placeholder = ':db_update_placeholder_' . ($max_placeholder++);
if (isset($table_information->blob_fields[$field])) {
$blobs[$blob_count] = fopen('php://memory', 'a');
fwrite($blobs[$blob_count], $value);
rewind($blobs[$blob_count]);
$stmt->bindParam($placeholder, $blobs[$blob_count], PDO::PARAM_LOB);
++$blob_count;
}
else {
$stmt->bindParam($placeholder, $fields[$field]);
}
}
if (count($this->condition)) {
$this->condition->compile($this->connection, $this);
$arguments = $this->condition->arguments();
foreach ($arguments as $placeholder => $value) {
$stmt->bindParam($placeholder, $arguments[$placeholder]);
}
}
$options = $this->queryOptions;
$options['already_prepared'] = TRUE;
$this->connection->query($stmt, $options);
return $stmt->rowCount();
}
}
Members
Name | Modifiers | Type | Description |
---|---|---|---|
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 QueryPlaceholderInterface:: |
Query:: |
public | function |
Returns a unique identifier for this object. Overrides QueryPlaceholderInterface:: |
Query:: |
public | function | Implements the magic __clone function. |
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. |
UpdateQuery:: |
protected | property | An array of values to update to. |
UpdateQuery:: |
protected | property | The condition object for this query. |
UpdateQuery:: |
protected | property | Array of fields to update to an expression in case of a duplicate record. |
UpdateQuery:: |
protected | property | An array of fields that will be updated. |
UpdateQuery:: |
protected | property | The table to update. |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::arguments(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::compile(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::compiled(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::condition(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::conditions(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::exists(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function | Specifies fields to be updated as an expression. |
UpdateQuery:: |
public | function | Adds a set of field->value pairs to be updated. |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::isNotNull(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::isNull(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::notExists(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Implements QueryConditionInterface::where(). Overrides QueryConditionInterface:: |
UpdateQuery:: |
public | function |
Constructs an UpdateQuery object. Overrides Query:: |
UpdateQuery:: |
public | function |
Implements PHP magic __toString method to convert the query to a string. Overrides Query:: |
UpdateQuery_pgsql:: |
public | function |
Executes the UPDATE query. Overrides UpdateQuery:: |