File "MultiTableUpdateExecutor.php"

Full Path: /home/warrior1/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Query/Exec/MultiTableUpdateExecutor.php
File size: 5.05 KB
MIME-type: text/x-php
Charset: utf-8

<?php
declare (strict_types=1);
namespace MailPoetVendor\Doctrine\ORM\Query\Exec;
if (!defined('ABSPATH')) exit;
use MailPoetVendor\Doctrine\DBAL\Connection;
use MailPoetVendor\Doctrine\DBAL\Connections\PrimaryReadReplicaConnection;
use MailPoetVendor\Doctrine\DBAL\Types\Type;
use MailPoetVendor\Doctrine\ORM\Query\AST;
use MailPoetVendor\Doctrine\ORM\Query\AST\UpdateStatement;
use MailPoetVendor\Doctrine\ORM\Query\ParameterTypeInferer;
use MailPoetVendor\Doctrine\ORM\Query\SqlWalker;
use MailPoetVendor\Doctrine\ORM\Utility\PersisterHelper;
use function array_merge;
use function array_reverse;
use function array_slice;
use function implode;
class MultiTableUpdateExecutor extends AbstractSqlExecutor
{
 private $_createTempTableSql;
 private $_dropTempTableSql;
 private $_insertSql;
 private $_sqlParameters = [];
 private $_numParametersInUpdateClause = 0;
 public function __construct(AST\Node $AST, $sqlWalker)
 {
 $em = $sqlWalker->getEntityManager();
 $conn = $em->getConnection();
 $platform = $conn->getDatabasePlatform();
 $quoteStrategy = $em->getConfiguration()->getQuoteStrategy();
 if ($conn instanceof PrimaryReadReplicaConnection) {
 $conn->ensureConnectedToPrimary();
 }
 $updateClause = $AST->updateClause;
 $primaryClass = $sqlWalker->getEntityManager()->getClassMetadata($updateClause->abstractSchemaName);
 $rootClass = $em->getClassMetadata($primaryClass->rootEntityName);
 $updateItems = $updateClause->updateItems;
 $tempTable = $platform->getTemporaryTableName($rootClass->getTemporaryIdTableName());
 $idColumnNames = $rootClass->getIdentifierColumnNames();
 $idColumnList = implode(', ', $idColumnNames);
 // 1. Create an INSERT INTO temptable ... SELECT identifiers WHERE $AST->getWhereClause()
 $sqlWalker->setSQLTableAlias($primaryClass->getTableName(), 't0', $updateClause->aliasIdentificationVariable);
 $this->_insertSql = 'INSERT INTO ' . $tempTable . ' (' . $idColumnList . ')' . ' SELECT t0.' . implode(', t0.', $idColumnNames);
 $rangeDecl = new AST\RangeVariableDeclaration($primaryClass->name, $updateClause->aliasIdentificationVariable);
 $fromClause = new AST\FromClause([new AST\IdentificationVariableDeclaration($rangeDecl, null, [])]);
 $this->_insertSql .= $sqlWalker->walkFromClause($fromClause);
 // 2. Create ID subselect statement used in UPDATE ... WHERE ... IN (subselect)
 $idSubselect = 'SELECT ' . $idColumnList . ' FROM ' . $tempTable;
 // 3. Create and store UPDATE statements
 $classNames = array_merge($primaryClass->parentClasses, [$primaryClass->name], $primaryClass->subClasses);
 $i = -1;
 foreach (array_reverse($classNames) as $className) {
 $affected = \false;
 $class = $em->getClassMetadata($className);
 $updateSql = 'UPDATE ' . $quoteStrategy->getTableName($class, $platform) . ' SET ';
 foreach ($updateItems as $updateItem) {
 $field = $updateItem->pathExpression->field;
 if (isset($class->fieldMappings[$field]) && !isset($class->fieldMappings[$field]['inherited']) || isset($class->associationMappings[$field]) && !isset($class->associationMappings[$field]['inherited'])) {
 $newValue = $updateItem->newValue;
 if (!$affected) {
 $affected = \true;
 ++$i;
 } else {
 $updateSql .= ', ';
 }
 $updateSql .= $sqlWalker->walkUpdateItem($updateItem);
 if ($newValue instanceof AST\InputParameter) {
 $this->_sqlParameters[$i][] = $newValue->name;
 ++$this->_numParametersInUpdateClause;
 }
 }
 }
 if ($affected) {
 $this->_sqlStatements[$i] = $updateSql . ' WHERE (' . $idColumnList . ') IN (' . $idSubselect . ')';
 }
 }
 // Append WHERE clause to insertSql, if there is one.
 if ($AST->whereClause) {
 $this->_insertSql .= $sqlWalker->walkWhereClause($AST->whereClause);
 }
 // 4. Store DDL for temporary identifier table.
 $columnDefinitions = [];
 foreach ($idColumnNames as $idColumnName) {
 $columnDefinitions[$idColumnName] = ['notnull' => \true, 'type' => Type::getType(PersisterHelper::getTypeOfColumn($idColumnName, $rootClass, $em))];
 }
 $this->_createTempTableSql = $platform->getCreateTemporaryTableSnippetSQL() . ' ' . $tempTable . ' (' . $platform->getColumnDeclarationListSQL($columnDefinitions) . ')';
 $this->_dropTempTableSql = $platform->getDropTemporaryTableSQL($tempTable);
 }
 public function execute(Connection $conn, array $params, array $types)
 {
 // Create temporary id table
 $conn->executeStatement($this->_createTempTableSql);
 try {
 // Insert identifiers. Parameters from the update clause are cut off.
 $numUpdated = $conn->executeStatement($this->_insertSql, array_slice($params, $this->_numParametersInUpdateClause), array_slice($types, $this->_numParametersInUpdateClause));
 // Execute UPDATE statements
 foreach ($this->_sqlStatements as $key => $statement) {
 $paramValues = [];
 $paramTypes = [];
 if (isset($this->_sqlParameters[$key])) {
 foreach ($this->_sqlParameters[$key] as $parameterKey => $parameterName) {
 $paramValues[] = $params[$parameterKey];
 $paramTypes[] = $types[$parameterKey] ?? ParameterTypeInferer::inferType($params[$parameterKey]);
 }
 }
 $conn->executeStatement($statement, $paramValues, $paramTypes);
 }
 } finally {
 // Drop temporary table
 $conn->executeStatement($this->_dropTempTableSql);
 }
 return $numUpdated;
 }
}