AbstractSqlExecutor.php
9 months ago
FinalizedSelectExecutor.php
9 months ago
MultiTableDeleteExecutor.php
9 months ago
MultiTableUpdateExecutor.php
9 months ago
PreparedExecutorFinalizer.php
9 months ago
SingleSelectExecutor.php
9 months ago
SingleSelectSqlFinalizer.php
9 months ago
SingleTableDeleteUpdateExecutor.php
9 months ago
SqlFinalizer.php
9 months ago
index.php
9 months ago
MultiTableUpdateExecutor.php
115 lines
| 1 | <?php |
| 2 | declare (strict_types=1); |
| 3 | namespace MailPoetVendor\Doctrine\ORM\Query\Exec; |
| 4 | if (!defined('ABSPATH')) exit; |
| 5 | use MailPoetVendor\Doctrine\DBAL\Connection; |
| 6 | use MailPoetVendor\Doctrine\DBAL\Connections\PrimaryReadReplicaConnection; |
| 7 | use MailPoetVendor\Doctrine\DBAL\Types\Type; |
| 8 | use MailPoetVendor\Doctrine\ORM\Query\AST; |
| 9 | use MailPoetVendor\Doctrine\ORM\Query\AST\UpdateStatement; |
| 10 | use MailPoetVendor\Doctrine\ORM\Query\ParameterTypeInferer; |
| 11 | use MailPoetVendor\Doctrine\ORM\Query\SqlWalker; |
| 12 | use MailPoetVendor\Doctrine\ORM\Utility\PersisterHelper; |
| 13 | use function array_merge; |
| 14 | use function array_reverse; |
| 15 | use function array_slice; |
| 16 | use function implode; |
| 17 | class MultiTableUpdateExecutor extends AbstractSqlExecutor |
| 18 | { |
| 19 | private $createTempTableSql; |
| 20 | private $dropTempTableSql; |
| 21 | private $insertSql; |
| 22 | private $sqlParameters = []; |
| 23 | private $numParametersInUpdateClause = 0; |
| 24 | public function __construct(AST\Node $AST, $sqlWalker) |
| 25 | { |
| 26 | parent::__construct(); |
| 27 | $em = $sqlWalker->getEntityManager(); |
| 28 | $conn = $em->getConnection(); |
| 29 | $platform = $conn->getDatabasePlatform(); |
| 30 | $quoteStrategy = $em->getConfiguration()->getQuoteStrategy(); |
| 31 | if ($conn instanceof PrimaryReadReplicaConnection) { |
| 32 | $conn->ensureConnectedToPrimary(); |
| 33 | } |
| 34 | $updateClause = $AST->updateClause; |
| 35 | $primaryClass = $sqlWalker->getEntityManager()->getClassMetadata($updateClause->abstractSchemaName); |
| 36 | $rootClass = $em->getClassMetadata($primaryClass->rootEntityName); |
| 37 | $updateItems = $updateClause->updateItems; |
| 38 | $tempTable = $platform->getTemporaryTableName($rootClass->getTemporaryIdTableName()); |
| 39 | $idColumnNames = $rootClass->getIdentifierColumnNames(); |
| 40 | $idColumnList = implode(', ', $idColumnNames); |
| 41 | // 1. Create an INSERT INTO temptable ... SELECT identifiers WHERE $AST->getWhereClause() |
| 42 | $sqlWalker->setSQLTableAlias($primaryClass->getTableName(), 't0', $updateClause->aliasIdentificationVariable); |
| 43 | $this->insertSql = 'INSERT INTO ' . $tempTable . ' (' . $idColumnList . ')' . ' SELECT t0.' . implode(', t0.', $idColumnNames); |
| 44 | $rangeDecl = new AST\RangeVariableDeclaration($primaryClass->name, $updateClause->aliasIdentificationVariable); |
| 45 | $fromClause = new AST\FromClause([new AST\IdentificationVariableDeclaration($rangeDecl, null, [])]); |
| 46 | $this->insertSql .= $sqlWalker->walkFromClause($fromClause); |
| 47 | // 2. Create ID subselect statement used in UPDATE ... WHERE ... IN (subselect) |
| 48 | $idSubselect = 'SELECT ' . $idColumnList . ' FROM ' . $tempTable; |
| 49 | // 3. Create and store UPDATE statements |
| 50 | $classNames = array_merge($primaryClass->parentClasses, [$primaryClass->name], $primaryClass->subClasses); |
| 51 | foreach (array_reverse($classNames) as $className) { |
| 52 | $affected = \false; |
| 53 | $class = $em->getClassMetadata($className); |
| 54 | $updateSql = 'UPDATE ' . $quoteStrategy->getTableName($class, $platform) . ' SET '; |
| 55 | $sqlParameters = []; |
| 56 | foreach ($updateItems as $updateItem) { |
| 57 | $field = $updateItem->pathExpression->field; |
| 58 | if (isset($class->fieldMappings[$field]) && !isset($class->fieldMappings[$field]['inherited']) || isset($class->associationMappings[$field]) && !isset($class->associationMappings[$field]['inherited'])) { |
| 59 | $newValue = $updateItem->newValue; |
| 60 | if (!$affected) { |
| 61 | $affected = \true; |
| 62 | } else { |
| 63 | $updateSql .= ', '; |
| 64 | } |
| 65 | $updateSql .= $sqlWalker->walkUpdateItem($updateItem); |
| 66 | if ($newValue instanceof AST\InputParameter) { |
| 67 | $sqlParameters[] = $newValue->name; |
| 68 | ++$this->numParametersInUpdateClause; |
| 69 | } |
| 70 | } |
| 71 | } |
| 72 | if ($affected) { |
| 73 | $this->sqlParameters[] = $sqlParameters; |
| 74 | $this->sqlStatements[] = $updateSql . ' WHERE (' . $idColumnList . ') IN (' . $idSubselect . ')'; |
| 75 | } |
| 76 | } |
| 77 | // Append WHERE clause to insertSql, if there is one. |
| 78 | if ($AST->whereClause) { |
| 79 | $this->insertSql .= $sqlWalker->walkWhereClause($AST->whereClause); |
| 80 | } |
| 81 | // 4. Store DDL for temporary identifier table. |
| 82 | $columnDefinitions = []; |
| 83 | foreach ($idColumnNames as $idColumnName) { |
| 84 | $columnDefinitions[$idColumnName] = ['notnull' => \true, 'type' => Type::getType(PersisterHelper::getTypeOfColumn($idColumnName, $rootClass, $em))]; |
| 85 | } |
| 86 | $this->createTempTableSql = $platform->getCreateTemporaryTableSnippetSQL() . ' ' . $tempTable . ' (' . $platform->getColumnDeclarationListSQL($columnDefinitions) . ', PRIMARY KEY(' . implode(',', $idColumnNames) . '))'; |
| 87 | $this->dropTempTableSql = $platform->getDropTemporaryTableSQL($tempTable); |
| 88 | } |
| 89 | public function execute(Connection $conn, array $params, array $types) |
| 90 | { |
| 91 | // Create temporary id table |
| 92 | $conn->executeStatement($this->createTempTableSql); |
| 93 | try { |
| 94 | // Insert identifiers. Parameters from the update clause are cut off. |
| 95 | $numUpdated = $conn->executeStatement($this->insertSql, array_slice($params, $this->numParametersInUpdateClause), array_slice($types, $this->numParametersInUpdateClause)); |
| 96 | // Execute UPDATE statements |
| 97 | foreach ($this->sqlStatements as $key => $statement) { |
| 98 | $paramValues = []; |
| 99 | $paramTypes = []; |
| 100 | if (isset($this->sqlParameters[$key])) { |
| 101 | foreach ($this->sqlParameters[$key] as $parameterKey => $parameterName) { |
| 102 | $paramValues[] = $params[$parameterKey]; |
| 103 | $paramTypes[] = $types[$parameterKey] ?? ParameterTypeInferer::inferType($params[$parameterKey]); |
| 104 | } |
| 105 | } |
| 106 | $conn->executeStatement($statement, $paramValues, $paramTypes); |
| 107 | } |
| 108 | } finally { |
| 109 | // Drop temporary table |
| 110 | $conn->executeStatement($this->dropTempTableSql); |
| 111 | } |
| 112 | return $numUpdated; |
| 113 | } |
| 114 | } |
| 115 |