Update.php
Same filename in this branch
- 11.x update.php
- 11.x core/modules/sqlite/src/Driver/Database/sqlite/Update.php
- 11.x core/modules/mysql/src/Driver/Database/mysql/Update.php
- 11.x core/tests/Drupal/Tests/Composer/Plugin/Scaffold/fixtures/drupal-assets-fixture/assets/update.php
- 11.x core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/Update.php
- 11.x core/assets/scaffold/files/update.php
- 11.x core/lib/Drupal/Core/Database/Query/Update.php
Same filename in other branches
- 7.x update.php
- 9 update.php
- 9 core/modules/sqlite/src/Driver/Database/sqlite/Update.php
- 9 core/modules/mysql/src/Driver/Database/mysql/Update.php
- 9 core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/Update.php
- 9 core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysqlDeprecatedVersion/Update.php
- 9 core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestPgsql/Update.php
- 9 core/modules/pgsql/src/Driver/Database/pgsql/Update.php
- 9 core/tests/Drupal/Tests/Composer/Plugin/Scaffold/fixtures/drupal-assets-fixture/assets/update.php
- 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Update.php
- 9 core/assets/scaffold/files/update.php
- 9 core/lib/Drupal/Core/Database/Driver/pgsql/Update.php
- 9 core/lib/Drupal/Core/Database/Query/Update.php
- 8.9.x update.php
- 8.9.x core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/Update.php
- 8.9.x core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestPgsql/Update.php
- 8.9.x core/tests/Drupal/Tests/Composer/Plugin/Scaffold/fixtures/drupal-assets-fixture/assets/update.php
- 8.9.x core/assets/scaffold/files/update.php
- 8.9.x core/lib/Drupal/Core/Database/Driver/sqlite/Update.php
- 8.9.x core/lib/Drupal/Core/Database/Driver/mysql/Update.php
- 8.9.x core/lib/Drupal/Core/Database/Driver/pgsql/Update.php
- 8.9.x core/lib/Drupal/Core/Database/Query/Update.php
- 10 update.php
- 10 core/modules/sqlite/src/Driver/Database/sqlite/Update.php
- 10 core/modules/mysql/src/Driver/Database/mysql/Update.php
- 10 core/modules/pgsql/src/Driver/Database/pgsql/Update.php
- 10 core/tests/Drupal/Tests/Composer/Plugin/Scaffold/fixtures/drupal-assets-fixture/assets/update.php
- 10 core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/Update.php
- 10 core/assets/scaffold/files/update.php
- 10 core/lib/Drupal/Core/Database/Driver/pgsql/Update.php
- 10 core/lib/Drupal/Core/Database/Query/Update.php
Namespace
Drupal\pgsql\Driver\Database\pgsqlFile
-
core/
modules/ pgsql/ src/ Driver/ Database/ pgsql/ Update.php
View source
<?php
namespace Drupal\pgsql\Driver\Database\pgsql;
use Drupal\Core\Database\Query\Update as QueryUpdate;
use Drupal\Core\Database\Query\SelectInterface;
/**
* PostgreSQL implementation of \Drupal\Core\Database\Query\Update.
*/
class Update extends QueryUpdate {
public function execute() {
$max_placeholder = 0;
$blobs = [];
$blob_count = 0;
// Because we filter $fields the same way here and in __toString(), the
// placeholders will all match up properly.
$stmt = $this->connection
->prepareStatement((string) $this, $this->queryOptions, TRUE);
// 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;
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->getClientStatement()
->bindParam($placeholder, $data['arguments'][$placeholder]);
}
}
if ($data['expression'] instanceof SelectInterface) {
$data['expression']->compile($this->connection, $this);
$select_query_arguments = $data['expression']->arguments();
foreach ($select_query_arguments as $placeholder => $argument) {
$stmt->getClientStatement()
->bindParam($placeholder, $select_query_arguments[$placeholder]);
}
}
unset($fields[$field]);
}
foreach ($fields as $field => $value) {
$placeholder = ':db_update_placeholder_' . $max_placeholder++;
if (isset($table_information->blob_fields[$field]) && $value !== NULL) {
$blobs[$blob_count] = fopen('php://memory', 'a');
fwrite($blobs[$blob_count], $value);
rewind($blobs[$blob_count]);
$stmt->getClientStatement()
->bindParam($placeholder, $blobs[$blob_count], \PDO::PARAM_LOB);
++$blob_count;
}
else {
$stmt->getClientStatement()
->bindParam($placeholder, $fields[$field]);
}
}
if (count($this->condition)) {
$this->condition
->compile($this->connection, $this);
$arguments = $this->condition
->arguments();
foreach ($arguments as $placeholder => $value) {
$stmt->getClientStatement()
->bindParam($placeholder, $arguments[$placeholder]);
}
}
$this->connection
->addSavepoint();
try {
$stmt->execute(NULL, $this->queryOptions);
$this->connection
->releaseSavepoint();
return $stmt->rowCount();
} catch (\Exception $e) {
$this->connection
->rollbackSavepoint();
$this->connection
->exceptionHandler()
->handleExecutionException($e, $stmt, [], $this->queryOptions);
}
}
}
Classes
Title | Deprecated | Summary |
---|---|---|
Update | PostgreSQL implementation of \Drupal\Core\Database\Query\Update. |
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.