public function testNotConstraint()
{
$this->qb->where($this->qf->notConstraint($this->qf->comparison($this->qf->propertyValue('base', 'bar'), Constants::JCR_OPERATOR_EQUAL_TO, $this->qf->literal('foo'))));
$this->qb->from($this->qf->selector('base', "nt:base"));
$statement = $this->qb->getQuery()->getStatement();
$variations = array("SELECT s FROM nt:base WHERE NOT bar = 'foo'", "SELECT s FROM nt:base WHERE (NOT bar = 'foo')");
$this->assertTrue(in_array($statement, $variations), "The statement '{$statement}' does not match an expected variation");
}
/**
* Parse an SQL2 static operand
* 6.7.35 BindVariable
* 6.7.36 Prefix
*
* @return StaticOperandInterface
*/
protected function parseStaticOperand()
{
$token = $this->scanner->lookupNextToken();
if (substr($token, 0, 1) === '$') {
return $this->factory->bindVariable(substr($this->scanner->fetchNextToken(), 1));
}
return $this->factory->literal($this->parseLiteralValue());
}
/**
* 6.7.33. UpperCase.
*/
public function testUpperCase()
{
$selector = $this->factory->selector('file', 'nt:file');
$operand1 = $this->factory->upperCase($this->factory->nodeName('file'));
$operand2 = $this->factory->literal('literal');
$operator = Constants::JCR_OPERATOR_LIKE;
$constraint = $this->factory->comparison($operand1, $operator, $operand2);
$this->assertQuery($this->queries['6.7.33.UpperCase'], $selector, array(), $constraint, array());
}
/**
* Resolve path for node with given uuid.
*
* @param string $uuid
*
* @return string
*
* @throws ItemNotFoundException
*/
private function resolvePathByUuid($uuid)
{
$queryBuilder = new QueryBuilder($this->qomFactory);
$queryBuilder->select('node', 'jcr:uuid', 'uuid')->from($this->qomFactory->selector('node', 'nt:unstructured'))->where($this->qomFactory->comparison($this->qomFactory->propertyValue('node', 'jcr:uuid'), '=', $this->qomFactory->literal($uuid)));
$rows = $queryBuilder->execute();
if (count(iterator_to_array($rows->getRows())) !== 1) {
throw new ItemNotFoundException();
}
return $rows->getRows()->current()->getPath();
}
/**
* Append mapping selects to given query-builder.
*
* @param QueryBuilder $queryBuilder
* @param MappingInterface $mapping Includes array of property names.
* @param string $locale
* @param string[] $locales
*/
private function appendMapping(QueryBuilder $queryBuilder, MappingInterface $mapping, $locale, $locales)
{
if ($mapping->onlyPublished()) {
$queryBuilder->andWhere($this->qomFactory->comparison($this->qomFactory->propertyValue('node', $this->propertyEncoder->localizedSystemName('state', $locale)), '=', $this->qomFactory->literal(WorkflowStage::PUBLISHED)));
}
$properties = $mapping->getProperties();
foreach ($properties as $propertyName) {
$this->appendSingleMapping($queryBuilder, $propertyName, $locales);
}
if ($mapping->resolveUrl()) {
$this->appendUrlMapping($queryBuilder, $locales);
}
}
/**
* {@inheritDoc}
*/
public function getQuery(QueryBuilder $builder)
{
$this->aliasWithTranslatedFields = array();
$this->locale = $builder->getLocale();
if (null === $this->locale && $this->dm->hasLocaleChooserStrategy()) {
$this->locale = $this->dm->getLocaleChooserStrategy()->getLocale();
}
$from = $builder->getChildrenOfType(QBConstants::NT_FROM);
if (!$from) {
throw new RuntimeException('No From (source) node in query');
}
$dispatches = array(QBConstants::NT_FROM, QBConstants::NT_SELECT, QBConstants::NT_WHERE, QBConstants::NT_ORDER_BY);
foreach ($dispatches as $dispatchType) {
$this->dispatchMany($builder->getChildrenOfType($dispatchType));
}
if (count($this->sourceDocumentNodes) > 1 && null === $builder->getPrimaryAlias()) {
throw new InvalidArgumentException('You must specify a primary alias when selecting from multiple document sources' . 'e.g. $qb->from(\'a\') ...');
}
// for each document source add phpcr:{class,classparents} restrictions
foreach ($this->sourceDocumentNodes as $sourceNode) {
$documentFqn = $this->aliasMetadata[$sourceNode->getAlias()]->getName();
$odmClassConstraints = $this->qomf->orConstraint($this->qomf->comparison($this->qomf->propertyValue($sourceNode->getAlias(), 'phpcr:class'), QOMConstants::JCR_OPERATOR_EQUAL_TO, $this->qomf->literal($documentFqn)), $this->qomf->comparison($this->qomf->propertyValue($sourceNode->getAlias(), 'phpcr:classparents'), QOMConstants::JCR_OPERATOR_EQUAL_TO, $this->qomf->literal($documentFqn)));
if ($this->constraint) {
$this->constraint = $this->qomf->andConstraint($this->constraint, $odmClassConstraints);
} else {
$this->constraint = $odmClassConstraints;
}
}
foreach (array_keys($this->aliasWithTranslatedFields) as $alias) {
$this->translator[$alias]->alterQueryForTranslation($this->qomf, $this->from, $this->constraint, $alias, $this->locale);
}
$phpcrQuery = $this->qomf->createQuery($this->from, $this->constraint, $this->orderings, $this->columns);
$query = new Query($phpcrQuery, $this->dm, $builder->getPrimaryAlias());
if ($firstResult = $builder->getFirstResult()) {
$query->setFirstResult($firstResult);
}
if ($maxResults = $builder->getMaxResults()) {
$query->setMaxResults($maxResults);
}
return $query;
}
public function it_should_provide_a_qom_object_for_selecting(QueryObjectModelFactoryInterface $qomf, ChildNodeJoinConditionInterface $joinCondition, JoinInterface $join, SourceInterface $parentSource, SourceInterface $childSource, PropertyValueInterface $childValue, LiteralInterface $literalValue, ComparisonInterface $comparison, QueryInterface $query)
{
$qomf->selector('parent', 'mgnl:page')->willReturn($parentSource);
$qomf->selector('child', 'mgnl:metaData')->willReturn($childSource);
$qomf->childNodeJoinCondition('child', 'parent')->willReturn($joinCondition);
$qomf->join($parentSource, $childSource, QueryObjectModelConstantsInterface::JCR_JOIN_TYPE_INNER, $joinCondition)->willReturn($join);
$qomf->propertyValue('child', 'mgnl:template')->willReturn($childValue);
$qomf->literal('standard-templating-kit:stkNews')->willReturn($literalValue);
$qomf->comparison($childValue, QueryObjectModelConstantsInterface::JCR_OPERATOR_EQUAL_TO, $literalValue)->willReturn($comparison);
$qomf->createQuery($join, $comparison)->willReturn($query);
$sql = <<<EOT
UPDATE [mgnl:page] AS parent
INNER JOIN [mgnl:metaData] AS child ON ISCHILDNODE(child,parent)
SET
parent.foo = 'PHPCR\\FOO\\Bar',
parent.bar = 'foo'
WHERE
child.[mgnl:template] = 'standard-templating-kit:stkNews'
EOT;
$res = $this->parse($sql);
$res->offsetGet(0)->shouldHaveType('PHPCR\\Query\\QueryInterface');
$res->offsetGet(1)->shouldReturn(array(array('selector' => 'parent', 'name' => 'foo', 'value' => 'PHPCR\\FOO\\Bar'), array('selector' => 'parent', 'name' => 'bar', 'value' => 'foo')));
}
public static function getQueries(QueryObjectModelFactoryInterface $factory)
{
$queries = array();
/*
* 6.7.3. Selector
*/
// SELECT * FROM nt:unstructured as test
$queries['6.7.3.Selector.Named'] = $factory->createQuery($factory->selector('test', 'nt:unstructured'), null, array(), array());
/*
* 6.7.8. EquiJoinCondition
*/
// SELECT * FROM nt:file INNER JOIN nt:folder ON sel1.prop1=sel2.prop2
$queries['6.7.8.EquiJoin.Inner'] = $factory->createQuery($factory->join($factory->selector('file', 'nt:file'), $factory->selector('folder', 'nt:folder'), Constants::JCR_JOIN_TYPE_INNER, $factory->equiJoinCondition('file', 'prop1', 'folder', 'prop2')), null, array(), array());
// SELECT * FROM nt:file LEFT OUTER JOIN nt:folder ON sel1.prop1=sel2.prop2
$queries['6.7.8.EquiJoin.Left'] = $factory->createQuery($factory->join($factory->selector('file', 'nt:file'), $factory->selector('folder', 'nt:folder'), Constants::JCR_JOIN_TYPE_LEFT_OUTER, $factory->equiJoinCondition('file', 'prop1', 'folder', 'prop2')), null, array(), array());
// SELECT * FROM nt:file RIGHT OUTER JOIN nt:folder ON sel1.prop1=sel2.prop2
$queries['6.7.8.EquiJoin.Right'] = $factory->createQuery($factory->join($factory->selector('file', 'nt:file'), $factory->selector('folder', 'nt:folder'), Constants::JCR_JOIN_TYPE_RIGHT_OUTER, $factory->equiJoinCondition('file', 'prop1', 'folder', 'prop2')), null, array(), array());
/*
* 6.7.9. SameNodeJoinCondition
*/
// SELECT * FROM nt:file INNER JOIN nt:folder ON ISSAMENODE(sel1, sel2)
$queries['6.7.9.SameNodeJoinCondition.Simple'] = $factory->createQuery($factory->join($factory->selector('file', 'nt:file'), $factory->selector('folder', 'nt:folder'), Constants::JCR_JOIN_TYPE_INNER, $factory->sameNodeJoinCondition('file', 'folder')), null, array(), array());
// SELECT * FROM nt:file INNER JOIN nt:folder ON ISSAMENODE(sel1, sel2, /home)
$queries['6.7.9.SameNodeJoinCondition.Path'] = $factory->createQuery($factory->join($factory->selector('file', 'nt:file'), $factory->selector('folder', 'nt:folder'), Constants::JCR_JOIN_TYPE_INNER, $factory->sameNodeJoinCondition('file', 'folder', '/home')), null, array(), array());
/*
* 6.7.10 ChildNodeJoinCondition
*/
// SELECT * FROM nt:file INNER JOIN nt:folder ON ISCHILDNODE(child, parent)
$queries['6.7.10.ChildNodeCondition'] = $factory->createQuery($factory->join($factory->selector('child', 'nt:file'), $factory->selector('parent', 'nt:folder'), Constants::JCR_JOIN_TYPE_INNER, $factory->childNodeJoinCondition('child', 'parent')), null, array(), array());
/*
* 6.7.11 DescendantNodeJoinCondition
*/
// SELECT * FROM nt:file INNER JOIN nt:folder ON ISDESCENDANTNODE(descendant, ancestor)
$queries['6.7.11.DescendantNodeJoinCondition'] = $factory->createQuery($factory->join($factory->selector('descendant', 'nt:file'), $factory->selector('ancestor', 'nt:folder'), Constants::JCR_JOIN_TYPE_INNER, $factory->descendantNodeJoinCondition('descendant', 'ancestor')), null, array(), array());
/*
* 6.7.12. Constraint (operator precedence)
*/
$queries['6.7.12.Constraint.Precedence.1'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->orConstraint($factory->comparison($factory->propertyValue('file', 'prop1'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('1')), $factory->andConstraint($factory->comparison($factory->propertyValue('file', 'prop2'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('2')), $factory->comparison($factory->propertyValue('file', 'prop3'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('3')))), array(), array());
$queries['6.7.12.Constraint.Precedence.2'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->orConstraint($factory->andConstraint($factory->comparison($factory->propertyValue('file', 'prop1'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('1')), $factory->comparison($factory->propertyValue('file', 'prop2'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('2'))), $factory->comparison($factory->propertyValue('file', 'prop3'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('3'))), array(), array());
$queries['6.7.12.Constraint.Precedence.3'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->orConstraint($factory->notConstraint($factory->comparison($factory->propertyValue('file', 'prop1'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('1'))), $factory->andConstraint($factory->comparison($factory->propertyValue('file', 'prop2'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('2')), $factory->notConstraint($factory->comparison($factory->propertyValue('file', 'prop3'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('3'))))), array(), array());
$queries['6.7.12.Constraint.Precedence.4'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->orConstraint($factory->andConstraint($factory->andConstraint($factory->propertyExistence('file', 'prop1'), $factory->propertyExistence('file', 'prop2')), $factory->propertyExistence('file', 'prop3')), $factory->andConstraint($factory->andConstraint($factory->andConstraint($factory->propertyExistence('file', 'prop4'), $factory->propertyExistence('file', 'prop5')), $factory->propertyExistence('file', 'prop6')), $factory->propertyExistence('file', 'prop7'))), array(), array());
$queries['6.7.12.Constraint.Precedence.5'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->orConstraint($factory->andConstraint($factory->notConstraint($factory->propertyExistence('file', 'prop1')), $factory->notConstraint($factory->notConstraint($factory->propertyExistence('file', 'prop2')))), $factory->andConstraint($factory->notConstraint($factory->comparison($factory->propertyValue('file', 'prop3'), Constants::JCR_OPERATOR_EQUAL_TO, $factory->literal('hello'))), $factory->comparison($factory->propertyValue('file', 'prop4'), Constants::JCR_OPERATOR_NOT_EQUAL_TO, $factory->literal('hello')))), array(), array());
/*
* 6.7.13. AndConstraint
*/
// SELECT * FROM nt:file WHERE sel1.prop1 IS NOT NULL AND sel2.prop2 IS NOT NULL
$queries['6.7.13.And'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->andConstraint($factory->propertyExistence('file', 'prop1'), $factory->propertyExistence('file', 'prop2')), array(), array());
/*
* 6.7.14. OrConstraint
*/
// SELECT * FROM nt:file WHERE sel1.prop1 IS NOT NULL OR sel2.prop2 IS NOT NULL
$queries['6.7.14.Or'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->orConstraint($factory->propertyExistence('file', 'prop1'), $factory->propertyExistence('file', 'prop2')), array(), array());
/*
* 6.7.15. NotConstraint
*/
// SELECT * FROM nt:file WHERE NOT sel1.prop1 IS NOT NULL
$queries['6.7.15.Not'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->notConstraint($factory->propertyExistence('file', 'prop1')), array(), array());
/*
* 6.7.16. Comparison
*/
// SELECT * FROM nt:file WHERE NAME(test) LIKE 'literal2'
$queries['6.7.16.Comparison'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->nodeName('file'), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal2')), array(), array());
/*
* 6.7.18. PropertyExistence
*/
// SELECT * FROM nt:file WHERE sel1.prop1 IS NOT NULL
$queries['6.7.18.PropertyExistence'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->propertyExistence('file', 'prop1'), array(), array());
/*
* 6.7.19. FullTextSearch
*/
// SELECT * FROM nt:file WHERE CONTAINS(sel.prop, expr)
$queries['6.7.19.FullTextSearch'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->fullTextSearch('file', 'prop', 'expr'), array(), array());
$queries['6.7.19.FullTextSearch_With_Single_Quote'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->fullTextSearch('file', 'prop', "expr'"), array(), array());
/*
* 6.7.20. SameNode
*/
// SELECT * FROM [nt:file] AS file WHERE ISSAMENODE(file, /home)
$queries['6.7.20.SameNode.Selector'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->sameNode('file', '/home'), array(), array());
/* TODO
$queries['6.7.20.SameNode.Selector_Space'] =
$factory->createQuery(
$factory->selector('file', 'nt:file'),
$factory->sameNode('file', '/home node'),
array(),
array());
*/
/*
* 6.7.21. ChildNode
*/
// SELECT * FROM [nt:file] AS file WHERE ISCHILDNODE(file, /home)
$queries['6.7.21.ChildNode.Selector'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->childNode('file', '/home'), array(), array());
/*
* 6.7.22. DescendantNode
*/
// SELECT * FROM [nt:file] AS file WHERE ISDESCENDANTNODE(file, /home)
$queries['6.7.22.DescendantNode.Selector'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->descendantNode('file', '/home'), array(), array());
/*
* 6.7.27. ProperyValue
*/
// SELECT * FROM [nt:file] AS file WHERE file.prop LIKE 'literal'
$queries['6.7.27.PropertyValue'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->propertyValue('file', 'prop'), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
// SELECT * FROM nt:unstructured WHERE sel.prop > '2013-04-15'
$queries['6.7.27.1.PropertyValue'] = $factory->createQuery($factory->selector('sel', 'nt:unstructured'), $factory->comparison($factory->propertyValue('sel', 'prop'), Constants::JCR_OPERATOR_GREATER_THAN, $factory->literal(new \DateTime('2013-04-15 +02:00'))), array(), array());
/*
* 6.7.28. Length
*/
// SELECT * FROM [nt:file] AS file WHERE LENGTH(file.prop) LIKE 'literal'
$queries['6.7.28.Length'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->length($factory->propertyValue('file', 'prop')), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
/*
* 6.7.29. NodeName
*/
// SELECT * FROM [nt:file] AS file WHERE NAME(file) LIKE 'literal'
$queries['6.7.29.NodeName'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->nodeName('file'), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
/*
* 6.7.30. NodeLocalName
*/
// SELECT * FROM [nt:file] AS file WHERE LOCALNAME(file) LIKE 'literal'
$queries['6.7.30.NodeLocalName'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->nodeLocalName('file'), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
/*
* 6.7.31. FullTextSearchScore
*/
// SELECT * FROM [nt:file] AS file WHERE SCORE(file) LIKE 'literal'
$queries['6.7.31.FullTextSearchScore'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->fullTextSearchScore('file'), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
/*
* 6.7.32. LowerCase
*/
// SELECT * FROM [nt:file] AS file WHERE LOWER(NAME(file)) LIKE 'literal'
$queries['6.7.32.LowerCase'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->lowerCase($factory->nodeName('file')), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
/*
* 6.7.33. UpperCase
*/
// SELECT * FROM [nt:file] AS file WHERE UPPER(NAME()) LIKE 'literal'
$queries['6.7.33.UpperCase'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->upperCase($factory->nodeName('file')), Constants::JCR_OPERATOR_LIKE, $factory->literal('literal')), array(), array());
/*
* 6.7.35. BindVariable
*/
// SELECT * FROM [nt:file] AS file WHERE UPPER(NAME(file)) LIKE $var
$queries['6.7.35.BindValue'] = $factory->createQuery($factory->selector('file', 'nt:file'), $factory->comparison($factory->upperCase($factory->nodeName('file')), Constants::JCR_OPERATOR_LIKE, $factory->bindVariable('var')), array(), array());
/*
* 6.7.38 Order
*/
// SELECT * FROM nt:unstructured
$queries['6.7.38.Order.None'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array(), array());
// SELECT * FROM nt:unstructured ORDER BY prop1 ASC
$queries['6.7.38.Order.Asc'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array($factory->ascending($factory->propertyValue('u', 'prop1'))), array());
// SELECT * FROM nt:unstructured ORDER BY prop1 DESC
$queries['6.7.38.Order.Desc'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array($factory->descending($factory->propertyValue('u', 'prop1'))), array());
// SELECT * FROM nt:unstructured ORDER BY prop1 ASC, prop2 DESC
$queries['6.7.38.Order.Mixed'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array($factory->ascending($factory->propertyValue('u', 'prop1')), $factory->descending($factory->propertyValue('u', 'prop2'))), array());
/*
* 6.7.39 Column
*/
// SELECT * FROM nt:unstructured
$queries['6.7.39.Colum.Wildcard'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array(), array());
// SELECT u.prop1 AS prop1 FROM [nt:unstructured] AS u
$queries['6.7.39.Colum.Selector'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array(), array($factory->column('u', 'prop1', 'col1')));
// SELECT u.prop1, u.prop2 AS col2 FROM nt:unstructured
$queries['6.7.39.Colum.Mixed'] = $factory->createQuery($factory->selector('u', 'nt:unstructured'), null, array(), array($factory->column('u', 'prop1', 'col1'), $factory->column('u', 'prop2', 'prop2')));
return $queries;
}
/**
* {@inheritDoc}
*
* Join document with translation children, and filter on the right child
* node.
*/
public function alterQueryForTranslation(QueryObjectModelFactoryInterface $qomf, SelectorInterface &$selector, ConstraintInterface &$constraint = null, $alias, $locale)
{
$childAlias = "_{$locale}_{$alias}";
$selector = $qomf->join($selector, $qomf->selector($childAlias, 'nt:base'), QueryObjectModelConstantsInterface::JCR_JOIN_TYPE_RIGHT_OUTER, $qomf->childNodeJoinCondition($childAlias, $alias));
$languageConstraint = $qomf->comparison($qomf->nodeName($childAlias), QueryObjectModelConstantsInterface::JCR_OPERATOR_EQUAL_TO, $qomf->literal(Translation::LOCALE_NAMESPACE . ":{$locale}"));
if ($constraint) {
$constraint = $qomf->andConstraint($constraint, $languageConstraint);
} else {
$constraint = $languageConstraint;
}
}
protected function walkOperandStaticLiteral(OperandStaticLiteral $node)
{
$op = $this->qomf->literal($node->getValue());
return $op;
}