/** * Parses the query and returns the SQL statement parts. * * @param QueryInterface $query The query * @return array The SQL statement parts */ public function parseQuery(QueryInterface $query) { $sql = array(); $sql['keywords'] = array(); $sql['tables'] = array(); $sql['unions'] = array(); $sql['fields'] = array(); $sql['where'] = array(); $sql['additionalWhereClause'] = array(); $sql['orderings'] = array(); $sql['limit'] = (int) $query->getLimit() ?: NULL; $sql['offset'] = (int) $query->getOffset() ?: NULL; $source = $query->getSource(); $this->parseSource($source, $sql); $this->parseConstraint($query->getConstraint(), $source, $sql); $this->parseOrderings($query->getOrderings(), $source, $sql); $tableNames = array_unique(array_keys($sql['tables'] + $sql['unions'])); foreach ($tableNames as $tableName) { if (is_string($tableName) && !empty($tableName)) { $this->addAdditionalWhereClause($query->getQuerySettings(), $tableName, $sql); } } return $sql; }
/** * Parses the query and returns the SQL statement parts. * * @param QueryInterface $query The query * @param array &$parameters * @return array The SQL statement parts */ public function parseQuery(QueryInterface $query, array &$parameters) { $statementParts = array(); $statementParts['keywords'] = array(); $statementParts['tables'] = array(); $statementParts['unions'] = array(); $statementParts['fields'] = array(); $statementParts['where'] = array(); $statementParts['additionalWhereClause'] = array(); $statementParts['orderings'] = array(); $statementParts['limit'] = array(); $source = $query->getSource(); $this->parseSource($source, $statementParts); $this->parseConstraint($query->getConstraint(), $source, $statementParts, $parameters); $this->parseOrderings($query->getOrderings(), $source, $statementParts); $this->parseLimitAndOffset($query->getLimit(), $query->getOffset(), $statementParts); $tableNames = array_unique(array_keys($statementParts['tables'] + $statementParts['unions'])); foreach ($tableNames as $tableNameOrAlias) { if (is_string($tableNameOrAlias) && strlen($tableNameOrAlias) > 0) { $this->addAdditionalWhereClause($query->getQuerySettings(), $tableNameOrAlias, $statementParts); } } return $statementParts; }
/** * Returns a ready to be executed QueryBuilder object, based on the query * * @param QueryInterface $query * @return QueryBuilder */ public function convertQueryToDoctrineQueryBuilder(QueryInterface $query) { // Reset all properties $this->tablePropertyMap = []; $this->tableAliasMap = []; $this->unionTableAliasCache = []; $this->tableName = ''; // Find the right table name $source = $query->getSource(); $this->initializeQueryBuilder($source); $constraint = $query->getConstraint(); if ($constraint instanceof Qom\ConstraintInterface) { $wherePredicates = $this->parseConstraint($constraint, $source); if (!empty($wherePredicates)) { $this->queryBuilder->andWhere($wherePredicates); } } $this->parseOrderings($query->getOrderings(), $source); $this->addTypo3Constraints($query); return $this->queryBuilder; }
/** * @param \TYPO3\CMS\Extbase\Persistence\QueryInterface $query * @return int * @throws \TYPO3\CMS\Extbase\Persistence\Generic\Storage\Exception\BadConstraintException */ protected function getObjectCountByQueryTYPO361(\TYPO3\CMS\Extbase\Persistence\QueryInterface $query) { $statement = $query->getStatement(); if ($statement instanceof \TYPO3\CMS\Extbase\Persistence\Generic\Qom\Statement) { /* * Overriding default extbase logic for manually passed SQL */ $sql = $statement->getStatement(); $parameters = $statement->getBoundVariables(); $this->replacePlaceholders($sql, $parameters); $sqlParser = \EssentialDots\ExtbaseHijax\Persistence\Parser\SQL::ParseString($sql); $countQuery = $sqlParser->getCountQuery(); $result = $this->databaseHandle->sql_query($countQuery); $this->checkSqlErrors($countQuery); if (version_compare(TYPO3_version, '6.1.0', '<')) { $rows = $this->getRowsFromResult($query->getSource(), $result); } else { $rows = $this->getRowsFromResult($result); } $count = current(current($rows)); $this->databaseHandle->sql_free_result($result); } else { /* * Default Extbase logic */ $count = parent::getObjectCountByQuery($query); } return (int) $count; }
/** * Parses the query and returns the SQL statement parts. * * @param QueryInterface $query The query * @return array The SQL statement parts */ public function parseQuery(QueryInterface $query) { $this->tablePropertyMap = array(); $sql = array(); $sql['keywords'] = array(); $sql['tables'] = array(); $sql['unions'] = array(); $sql['fields'] = array(); $sql['where'] = array(); $sql['additionalWhereClause'] = array(); $sql['orderings'] = array(); $sql['limit'] = (int) $query->getLimit() ?: null; $sql['offset'] = (int) $query->getOffset() ?: null; $sql['tableAliasMap'] = array(); $source = $query->getSource(); $this->parseSource($source, $sql); $this->parseConstraint($query->getConstraint(), $source, $sql); $this->parseOrderings($query->getOrderings(), $source, $sql); foreach ($sql['tableAliasMap'] as $tableAlias => $tableName) { $additionalWhereClause = $this->getAdditionalWhereClause($query->getQuerySettings(), $tableName, $tableAlias); if ($additionalWhereClause !== '') { $additionalWhereClause = $this->addNullConditionToStatementIfRequired($sql, $additionalWhereClause, $tableAlias); $sql['additionalWhereClause'][] = $additionalWhereClause; } } return $sql; }