class Update in Drupal 10
Same name in this branch
- 10 core/lib/Drupal/Core/Database/Query/Update.php \Drupal\Core\Database\Query\Update
- 10 core/lib/Drupal/Core/Database/Driver/pgsql/Update.php \Drupal\Core\Database\Driver\pgsql\Update
- 10 core/modules/sqlite/src/Driver/Database/sqlite/Update.php \Drupal\sqlite\Driver\Database\sqlite\Update
- 10 core/modules/pgsql/src/Driver/Database/pgsql/Update.php \Drupal\pgsql\Driver\Database\pgsql\Update
- 10 core/modules/mysql/src/Driver/Database/mysql/Update.php \Drupal\mysql\Driver\Database\mysql\Update
- 10 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Update.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\Update
- 10 core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/Update.php \Drupal\driver_test\Driver\Database\DrivertestMysql\Update
- 10 core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestPgsql/Update.php \Drupal\driver_test\Driver\Database\DrivertestPgsql\Update
- 10 core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysqlDeprecatedVersion/Update.php \Drupal\driver_test\Driver\Database\DrivertestMysqlDeprecatedVersion\Update
PostgreSQL implementation of \Drupal\Core\Database\Query\Update.
Hierarchy
- class \Drupal\Core\Database\Query\Query implements PlaceholderInterface
- class \Drupal\Core\Database\Query\Update implements ConditionInterface uses QueryConditionTrait
- class \Drupal\pgsql\Driver\Database\pgsql\Update
- class \Drupal\Core\Database\Query\Update implements ConditionInterface uses QueryConditionTrait
Expanded class hierarchy of Update
2 files declare their use of Update
- Update.php in core/
lib/ Drupal/ Core/ Database/ Driver/ pgsql/ Update.php - Update.php in core/
modules/ system/ tests/ modules/ driver_test/ src/ Driver/ Database/ DrivertestPgsql/ Update.php
27 string references to 'Update'
- BlockFormMessagesTest::testValidationMessage in core/
modules/ layout_builder/ tests/ src/ FunctionalJavascript/ BlockFormMessagesTest.php - Tests that validation messages are shown on the block form.
- CommentAdminOverview::buildForm in core/
modules/ comment/ src/ Form/ CommentAdminOverview.php - Form constructor for the comment overview administration form.
- CommentAdminTest::testApprovalAdminInterface in core/
modules/ comment/ tests/ src/ Functional/ CommentAdminTest.php - Tests comment approval functionality through admin/content/comment.
- CommentAdminTest::testCommentedTranslationDeletion in core/
modules/ comment/ tests/ src/ Functional/ CommentAdminTest.php - Tests commented translation deletion admin view.
- CommentNonNodeTest::performCommentOperation in core/
modules/ comment/ tests/ src/ Functional/ CommentNonNodeTest.php - Performs the specified operation on the specified comment.
File
- core/
modules/ pgsql/ src/ Driver/ Database/ pgsql/ Update.php, line 11
Namespace
Drupal\pgsql\Driver\Database\pgsqlView source
class Update extends QueryUpdate {
/**
* {@inheritdoc}
*/
public function __construct(Connection $connection, string $table, array $options = []) {
// @todo Remove the __construct in Drupal 11.
// @see https://www.drupal.org/project/drupal/issues/3256524
parent::__construct($connection, $table, $options);
unset($this->queryOptions['return']);
}
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);
}
}
}
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 database connection to be used 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. | |
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 | ||
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 | ||
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 Update:: |
|
Update:: |
public | function |
Implements PHP magic __toString method to convert the query to a string. Overrides Query:: |