/** * Walks down a WhereClause AST node, thereby generating the appropriate SQL. * * @param $whereClause * @return string The SQL. */ public function walkWhereClause($whereClause) { $sql = parent::walkWhereClause($whereClause); if ($this->getQuery()->getHint('librinfoWalker.noIlike') === false) { $sql = str_replace('LIKE', 'ILIKE', $sql); } return $sql; }
/** * @param \Doctrine\ORM\Query\AST\WhereClause $whereClause * * @return string */ public function walkWhereClause($whereClause) { $sql = parent::walkWhereClause($whereClause); $aclWhereClause = $this->getQuery()->getHint('acl_where_clause'); $orX = $this->getQuery()->getHint('acl_filter_or_x'); $sql .= empty($sql) ? ' WHERE (' : ' AND ('; if (!empty($orX)) { foreach ($orX as $key => $or) { preg_match_all("/\\w+\\.{1}\\w+/", $or, $orReferences); foreach ($orReferences as $orReference) { $orX[$key] = str_replace($orReference[0], $this->DQLToSQLReference($orReference[0]), $or); } } $sql .= '(' . new Orx($orX) . ') OR '; } $sql .= '(' . $aclWhereClause . '))'; return $sql; }
/** {@inheritdoc} */ public function walkWhereClause($whereClause) { $sql = parent::walkWhereClause($whereClause); if (null !== ($config = $this->getQuery()->getHint('config')) && $config->get('multitenant.enabled')) { $fromClause = $this->getQuery()->getAST()->fromClause; $from = $fromClause->identificationVariableDeclarations; if (1 === count($from)) { /** @var \Doctrine\ORM\Mapping\ClassMetadata $metadata */ $metadata = $this->getQueryComponent($from[0]->rangeVariableDeclaration->aliasIdentificationVariable)['metadata']; $keymap = $config->get('multitenant.keymap'); if (isset($metadata->fieldMappings[$keymap])) { $parts = explode(' ', $fromClause->dispatch($this)); return ($sql ? $sql . ' AND ' : ' WHERE ') . strtr(":table.:column = ':value'", [':table' => end($parts), ':column' => $metadata->fieldMappings[$keymap]['columnName'], ':value' => $config->get('app.key')]); } } } return $sql; }
/** * {@inheritdoc} */ public function walkWhereClause($whereClause) { $sql = parent::walkWhereClause($whereClause); $sql .= empty($sql) ? ' WHERE (' : ' AND ('; $orX = $this->getQuery()->getHint('acl_or_x'); foreach ($orX as $key => $or) { preg_match_all("/\\w+\\.{1}\\w+/", $or, $orReferences); foreach ($orReferences as $orReference) { $explode = explode('.', $orReference[0]); $orX[$key] = str_replace($orReference[0], $this->dqlToSqlReference($explode[0], $explode[1]), $or); } } $mask = (int) $this->getQuery()->getHint('acl_mask'); $identifiers = array_map(function ($value) { return $value; }, $this->getQuery()->getHint('acl_requester_identifiers')); $expr = $this->getEntityManager()->getExpressionBuilder(); $orX[] = $expr->andX($expr->in('acl_p.requester', $identifiers), $expr->eq($mask, 'acl_p.mask & ' . $mask)); $sql .= '(' . new Orx($orX) . '))'; return $sql; }
/** * Initializes a new <tt>MultiTableDeleteExecutor</tt>. * * @param \Doctrine\ORM\Query\AST\Node $AST The root AST node of the DQL query. * @param \Doctrine\ORM\Query\SqlWalker $sqlWalker The walker used for SQL generation from the AST. * * @internal Any SQL construction and preparation takes place in the constructor for * best performance. With a query cache the executor will be cached. */ public function __construct(AST\Node $AST, $sqlWalker) { $em = $sqlWalker->getEntityManager(); $conn = $em->getConnection(); $platform = $conn->getDatabasePlatform(); $quoteStrategy = $em->getConfiguration()->getQuoteStrategy(); $primaryClass = $em->getClassMetadata($AST->deleteClause->abstractSchemaName); $primaryDqlAlias = $AST->deleteClause->aliasIdentificationVariable; $rootClass = $em->getClassMetadata($primaryClass->rootEntityName); $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', $primaryDqlAlias); $this->_insertSql = 'INSERT INTO ' . $tempTable . ' (' . $idColumnList . ')' . ' SELECT t0.' . implode(', t0.', $idColumnNames); $rangeDecl = new AST\RangeVariableDeclaration($primaryClass->name, $primaryDqlAlias); $fromClause = new AST\FromClause(array(new AST\IdentificationVariableDeclaration($rangeDecl, null, array()))); $this->_insertSql .= $sqlWalker->walkFromClause($fromClause); // Append WHERE clause, if there is one. if ($AST->whereClause) { $this->_insertSql .= $sqlWalker->walkWhereClause($AST->whereClause); } // 2. Create ID subselect statement used in DELETE ... WHERE ... IN (subselect) $idSubselect = 'SELECT ' . $idColumnList . ' FROM ' . $tempTable; // 3. Create and store DELETE statements $classNames = array_merge($primaryClass->parentClasses, array($primaryClass->name), $primaryClass->subClasses); foreach (array_reverse($classNames) as $className) { $tableName = $quoteStrategy->getTableName($em->getClassMetadata($className), $platform); $this->_sqlStatements[] = 'DELETE FROM ' . $tableName . ' WHERE (' . $idColumnList . ') IN (' . $idSubselect . ')'; } // 4. Store DDL for temporary identifier table. $columnDefinitions = array(); foreach ($idColumnNames as $idColumnName) { $columnDefinitions[$idColumnName] = array('notnull' => true, 'type' => \Doctrine\DBAL\Types\Type::getType($rootClass->getTypeOfColumn($idColumnName))); } $this->_createTempTableSql = $platform->getCreateTemporaryTableSnippetSQL() . ' ' . $tempTable . ' (' . $platform->getColumnDeclarationListSQL($columnDefinitions) . ')'; $this->_dropTempTableSql = $platform->getDropTemporaryTableSQL($tempTable); }
/** * Initializes a new <tt>MultiTableUpdateExecutor</tt>. * * Internal note: Any SQL construction and preparation takes place in the constructor for * best performance. With a query cache the executor will be cached. * * @param \Doctrine\ORM\Query\AST\Node $AST The root AST node of the DQL query. * @param \Doctrine\ORM\Query\SqlWalker $sqlWalker The walker used for SQL generation from the AST. */ public function __construct(AST\Node $AST, $sqlWalker) { $em = $sqlWalker->getEntityManager(); $conn = $em->getConnection(); $platform = $conn->getDatabasePlatform(); $quoteStrategy = $em->getConfiguration()->getQuoteStrategy(); $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); }
/** * {@inheritDoc} */ public function walkWhereClause($whereClause) { $result = parent::walkWhereClause($whereClause); return $this->replace($this->replacements, $result); }
/** * {@inheritDoc} */ public function walkWhereClause($whereClause) { $result = parent::walkWhereClause($whereClause); return str_replace(array_keys($this->replacements), array_values($this->replacements), $result); }