/*
* ModeShape (http://www.modeshape.org)
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.modeshape.jcr.query.parse;
import static org.hamcrest.core.Is.is;
import static org.hamcrest.core.IsInstanceOf.instanceOf;
import static org.hamcrest.core.IsNull.nullValue;
import static org.junit.Assert.assertThat;
import org.junit.Before;
import org.junit.Test;
import org.modeshape.common.text.ParsingException;
import org.modeshape.common.text.TokenStream;
import org.modeshape.jcr.ExecutionContext;
import org.modeshape.jcr.query.model.And;
import org.modeshape.jcr.query.model.Comparison;
import org.modeshape.jcr.query.model.Constraint;
import org.modeshape.jcr.query.model.DynamicOperand;
import org.modeshape.jcr.query.model.Join;
import org.modeshape.jcr.query.model.JoinCondition;
import org.modeshape.jcr.query.model.JoinType;
import org.modeshape.jcr.query.model.Literal;
import org.modeshape.jcr.query.model.NamedSelector;
import org.modeshape.jcr.query.model.NodePath;
import org.modeshape.jcr.query.model.Not;
import org.modeshape.jcr.query.model.Or;
import org.modeshape.jcr.query.model.Order;
import org.modeshape.jcr.query.model.Ordering;
import org.modeshape.jcr.query.model.PropertyExistence;
import org.modeshape.jcr.query.model.PropertyValue;
import org.modeshape.jcr.query.model.Query;
import org.modeshape.jcr.query.model.QueryCommand;
import org.modeshape.jcr.query.model.Relike;
import org.modeshape.jcr.query.model.SameNodeJoinCondition;
import org.modeshape.jcr.query.model.SelectorName;
import org.modeshape.jcr.query.model.Source;
import org.modeshape.jcr.query.model.StaticOperand;
import org.modeshape.jcr.query.model.TypeSystem;
import org.modeshape.jcr.value.Name;
import org.modeshape.jcr.value.Path;
import org.modeshape.jcr.value.PropertyType;
/**
*
*/
public class JcrSqlQueryParserTest {
private TypeSystem typeSystem;
private JcrSqlQueryParser parser;
private Query query;
@Before
public void beforeEach() {
typeSystem = new ExecutionContext().getValueFactories().getTypeSystem();
parser = new JcrSqlQueryParser();
}
// ----------------------------------------------------------------------------------------------------------------
// parseQuery
// ----------------------------------------------------------------------------------------------------------------
@Test
public void shouldParseNominalQueries() {
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived%' AND jcr:path LIKE '/drools:repository/drools:package_area/%'");
parse("select * from drools:assetNodeType where relike('test-title', drools:title)");
parse("select * from drools:assetNodeType where relike('test-title', drools:title) and drools:archive = 'false'");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestPost/assets[%]/%' and ( drools:format='drl' OR drools:format='xls' ) AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestDelete/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestDelete/assets[%]/%' and drools:archive = 'true' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestDelete/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testPackageSnapshot/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testPackageSnapshot/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:packagesnapshot_area/testPackageSnapshot/PROD 2.0/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/searchByFormat/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/searchByFormat/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/searchByFormat/assets[%]/%' and ( drools:format='xyz' OR drools:format='ABC' ) AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/globalArea/assets[%]/%' and drools:format='testSearchSharedAssetByFormat' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/org.drools.archivedtest/assets[%]/%' and drools:archive = 'true' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/org.drools.archivedtest/assets[%]/%' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testExcludeAssetTypes/assets[%]/%' and not drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testExcludeAssetTypes/assets[%]/%' and not ( drools:format='drl' OR drools:format='wang' ) AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testExcludeAssetTypes/assets[%]/%' and not ( drools:format='drl' OR drools:format='xls' ) AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex1' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:subject LIKE 'testQueryXXX42' AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:subject LIKE 'testQueryXXX42' AND drools:source LIKE 'database'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '1974-07-10T00:00:00.000-05:00' AND jcr:created < TIMESTAMP '3074-07-10T00:00:00.000-05:00'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '1974-07-10T00:00:00.000-05:00'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created < TIMESTAMP '3074-07-10T00:00:00.000-05:00'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '3074-07-10T00:00:00.000-05:00'");
parse("SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created < TIMESTAMP '1974-07-10T00:00:00.000-05:00'");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/globalArea/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title");
parse("SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/globalArea/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title");
parse("select * from mgnl:content where jcr:path like '/modules/%/templates'");
}
@Test
public void shouldParseQueriesUsedInJcrTckTests() {
parse("SELECT * FROM nt:unstructured, mix:referenceable WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path AND jcr:path LIKE '/testroot/%'");
parse("SELECT * FROM nt:unstructured, nt:base WHERE nt:unstructured.jcr:path = nt:base.jcr:path AND jcr:path LIKE '/testroot/%'");
parse("SELECT * FROM nt:base, mix:referenceable WHERE nt:base.jcr:path = mix:referenceable.jcr:path AND jcr:path LIKE '/testroot/%'");
parse("SELECT * FROM nt:unstructured, mix:referenceable WHERE nt:unstructured.jcr:path = mix:referenceable.jcr:path AND jcr:path LIKE '/testroot/%'");
parse("SELECT prop1 FROM nt:unstructured WHERE 'two' IN prop2 AND 'existence' IN prop1 AND jcr:path LIKE '/testroot/%'");
}
@Test
public void shouldParseSelectStarFromSingleSourceWithWhereContainingPathLikeConstraint() {
query = parse("SELECT * FROM mgnl:content WHERE jcr:path LIKE '/modules/%/templates'");
assertThat(query.source(), is(instanceOf(NamedSelector.class)));
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
NamedSelector selector = (NamedSelector)query.source();
assertThat(selector.name(), is(selectorName("mgnl:content")));
assertThat(selector.aliasOrName(), is(selectorName("mgnl:content")));
assertThat(selector.alias(), is(nullValue()));
// WHERE ...
Comparison comparison = isComparison(query.constraint());
assertThat(comparison.getOperand1(), is((DynamicOperand)nodePath(selectorName("mgnl:content"))));
assertThat(comparison.getOperand2(), is((StaticOperand)literal("/modules/%/templates")));
}
@Test
public void shouldParseSelectStarFromSingleSourceWithWhereContainingTwoPathLikeConstraints() {
query = parse("SELECT * FROM mgnl:content WHERE jcr:path LIKE '/modules/%/templates' or jcr:path like '/modules/%/other'");
assertThat(query.source(), is(instanceOf(NamedSelector.class)));
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
NamedSelector selector = (NamedSelector)query.source();
assertThat(selector.name(), is(selectorName("mgnl:content")));
assertThat(selector.aliasOrName(), is(selectorName("mgnl:content")));
assertThat(selector.alias(), is(nullValue()));
// WHERE ...
Or and = isOr(query.constraint());
Comparison comparison1 = isComparison(and.left());
assertThat(comparison1.getOperand1(), is((DynamicOperand)nodePath(selectorName("mgnl:content"))));
assertThat(comparison1.getOperand2(), is((StaticOperand)literal("/modules/%/templates")));
Comparison comparison2 = isComparison(and.right());
assertThat(comparison2.getOperand1(), is((DynamicOperand)nodePath(selectorName("mgnl:content"))));
assertThat(comparison2.getOperand2(), is((StaticOperand)literal("/modules/%/other")));
}
@Test
public void shouldParseSelectStarFromTwoJoinedSourcesWithWhereContainingJoinCriteria() {
query = parse("SELECT * FROM mgnl:content, acme:stuff WHERE mgnl:content.jcr:path = acme:stuff.jcr:path");
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
Join join = isJoin(query.source());
assertThat(join.getLeft(), is((Source)namedSelector(selectorName("mgnl:content"))));
assertThat(join.getRight(), is((Source)namedSelector(selectorName("acme:stuff"))));
assertThat(join.type(), is(JoinType.INNER));
SameNodeJoinCondition joinCondition = isSameNodeJoinCondition(join.getJoinCondition());
assertThat(joinCondition.selector1Name(), is(selectorName("mgnl:content")));
assertThat(joinCondition.selector2Name(), is(selectorName("acme:stuff")));
assertThat(joinCondition.getSelector2Path(), is(nullValue()));
// WHERE ...
assertThat(query.constraint(), is(nullValue()));
}
@Test
public void shouldParseSelectStarFromThreeJoinedSourcesWithWhereContainingJoinCriteria() {
query = parse("SELECT * FROM mgnl:content, acme:stuff, foo:bar WHERE mgnl:content.jcr:path = acme:stuff.jcr:path AND mgnl:content.jcr:path = foo:bar.jcr:path");
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
Join join = isJoin(query.source());
Join join2 = isJoin(join.getLeft());
assertThat(join2.getLeft(), is((Source)namedSelector(selectorName("mgnl:content"))));
assertThat(join2.getRight(), is((Source)namedSelector(selectorName("acme:stuff"))));
assertThat(join2.type(), is(JoinType.INNER));
SameNodeJoinCondition joinCondition2 = isSameNodeJoinCondition(join2.getJoinCondition());
assertThat(joinCondition2.selector1Name(), is(selectorName("mgnl:content")));
assertThat(joinCondition2.selector2Name(), is(selectorName("acme:stuff")));
assertThat(joinCondition2.getSelector2Path(), is(nullValue()));
assertThat(join.getRight(), is((Source)namedSelector(selectorName("foo:bar"))));
assertThat(join.type(), is(JoinType.INNER));
SameNodeJoinCondition joinCondition = isSameNodeJoinCondition(join.getJoinCondition());
assertThat(joinCondition.selector1Name(), is(selectorName("mgnl:content")));
assertThat(joinCondition.selector2Name(), is(selectorName("foo:bar")));
assertThat(joinCondition.getSelector2Path(), is(nullValue()));
// WHERE ...
assertThat(query.constraint(), is(nullValue()));
}
@Test
public void shouldParseSelectStarFromEquijoinAndAdditionalCriteria() {
query = parse("SELECT * FROM modetest:queryable, mix:referenceable WHERE modetest:queryable.jcr:path = mix:referenceable.jcr:path AND jcr:path LIKE '/testroot/someQueryableNodeD/%'");
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
Join join = isJoin(query.source());
assertThat(join.getLeft(), is((Source)namedSelector(selectorName("modetest:queryable"))));
assertThat(join.getRight(), is((Source)namedSelector(selectorName("mix:referenceable"))));
assertThat(join.type(), is(JoinType.INNER));
SameNodeJoinCondition joinCondition = isSameNodeJoinCondition(join.getJoinCondition());
assertThat(joinCondition.selector1Name(), is(selectorName("modetest:queryable")));
assertThat(joinCondition.selector2Name(), is(selectorName("mix:referenceable")));
assertThat(joinCondition.getSelector2Path(), is(nullValue()));
// WHERE ...
Comparison comparison = isComparison(query.constraint());
assertThat(comparison.getOperand1(), is((DynamicOperand)nodePath(selectorName("modetest:queryable"))));
assertThat(comparison.getOperand2(), is((StaticOperand)literal("/testroot/someQueryableNodeD/%")));
}
@Test
public void shouldParseSelectWithOrderByClause() {
query = parse("SELECT car:model FROM car:Car WHERE car:model IS NOT NULL ORDER BY car:model ASC");
// SELECT car:model ...
assertThat(query.columns().size(), is(1));
assertThat(query.columns().get(0).selectorName(), is(selectorName("car:Car")));
assertThat(query.columns().get(0).getColumnName(), is("car:model"));
assertThat(query.columns().get(0).getPropertyName(), is("car:model"));
// FROM ...
NamedSelector selector = (NamedSelector)query.source();
assertThat(selector.name(), is(selectorName("car:Car")));
assertThat(selector.aliasOrName(), is(selectorName("car:Car")));
assertThat(selector.alias(), is(nullValue()));
// WHERE ...
PropertyExistence constraint = isPropertyExistence(query.constraint());
assertThat(constraint.getPropertyName(), is("car:model"));
assertThat(constraint.selectorName(), is(selectorName("car:Car")));
// ORDER BY ...
assertThat(query.orderings().size(), is(1));
Ordering ordering = query.orderings().get(0);
assertThat(ordering.order(), is(Order.ASCENDING));
assertThat(ordering.getOperand(), is((DynamicOperand)propertyValue(selectorName("car:Car"), "car:model")));
}
/**
* Tests that the child nodes (but no grandchild nodes) are returned.
*/
@Test
public void shouldParseSelectWithChildAxisCriteria() {
query = parse("SELECT * FROM nt:base WHERE jcr:path LIKE '/a/b/%' AND NOT jcr:path LIKE '/a/b/%/%'");
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
NamedSelector selector = (NamedSelector)query.source();
assertThat(selector.name(), is(selectorName("nt:base")));
assertThat(selector.aliasOrName(), is(selectorName("nt:base")));
assertThat(selector.alias(), is(nullValue()));
// WHERE ...
And and = isAnd(query.constraint());
Comparison comparison1 = isComparison(and.left());
assertThat(comparison1.getOperand1(), is((DynamicOperand)nodePath(selectorName("nt:base"))));
assertThat(comparison1.getOperand2(), is((StaticOperand)literal("/a/b/%")));
Not not = isNot(and.right());
Comparison comparison2a = isComparison(not.getConstraint());
assertThat(comparison2a.getOperand1(), is((DynamicOperand)nodePath(selectorName("nt:base"))));
assertThat(comparison2a.getOperand2(), is((StaticOperand)literal("/a/b/%/%")));
}
@Test
public void shouldParseSelectStarFromSingleSourceWithWhereRelikeConstraint() {
query = parse("SELECT * FROM car:Car WHERE relike('test-model', car:model)");
assertThat(query.source(), is(instanceOf(NamedSelector.class)));
// SELECT * ...
assertThat(query.columns().isEmpty(), is(true));
// FROM ...
NamedSelector selector = (NamedSelector)query.source();
assertThat(selector.name(), is(selectorName("car:Car")));
assertThat(selector.aliasOrName(), is(selectorName("car:Car")));
assertThat(selector.alias(), is(nullValue()));
// WHERE ...
Relike relike = isRelike(query.constraint());
assertThat(relike.getOperand1(), is((StaticOperand)literal("test-model")));
assertThat(relike.getOperand2(), is((DynamicOperand)propertyValue(selectorName("car:Car"), "car:model")));
}
protected Join isJoin( Source source ) {
assertThat(source, is(instanceOf(Join.class)));
return (Join)source;
}
protected PropertyExistence isPropertyExistence( Constraint constraint ) {
assertThat(constraint, is(instanceOf(PropertyExistence.class)));
return (PropertyExistence)constraint;
}
protected Not isNot( Constraint constraint ) {
assertThat(constraint, is(instanceOf(Not.class)));
return (Not)constraint;
}
protected Comparison isComparison( Constraint constraint ) {
assertThat(constraint, is(instanceOf(Comparison.class)));
return (Comparison)constraint;
}
protected Relike isRelike( Constraint constraint ) {
assertThat(constraint, is(instanceOf(Relike.class)));
return (Relike)constraint;
}
protected SameNodeJoinCondition isSameNodeJoinCondition( JoinCondition condition ) {
assertThat(condition, is(instanceOf(SameNodeJoinCondition.class)));
return (SameNodeJoinCondition)condition;
}
protected And isAnd( Constraint constraint ) {
assertThat(constraint, is(instanceOf(And.class)));
return (And)constraint;
}
protected Or isOr( Constraint constraint ) {
assertThat(constraint, is(instanceOf(Or.class)));
return (Or)constraint;
}
protected NodePath nodePath( SelectorName name ) {
return new NodePath(name);
}
protected PropertyValue propertyValue( SelectorName selectorName,
String propertyName ) {
return new PropertyValue(selectorName, propertyName);
}
protected Literal literal( Object value ) {
return new Literal(value);
}
protected NamedSelector namedSelector( SelectorName selectorName ) {
return new NamedSelector(selectorName);
}
protected NamedSelector namedSelector( SelectorName selectorName,
SelectorName alias ) {
return new NamedSelector(selectorName, alias);
}
// ----------------------------------------------------------------------------------------------------------------
// parseName
// ----------------------------------------------------------------------------------------------------------------
@Test
public void shouldParseNonPrefixedNameFromUnquotedString() {
assertThat(parser.parseName(tokens("name"), typeSystem), is("name"));
}
@Test
public void shouldParsePrefixedNameFromUnquotedString() {
assertThat(parser.parseName(tokens("jcr:name"), typeSystem), is("jcr:name"));
}
@Test
public void shouldParseNameFromSingleQuotedString() {
assertThat(parser.parseName(tokens("'jcr:name'"), typeSystem), is("jcr:name"));
}
@Test
public void shouldParseNameFromUnquotedStringWithoutPrefix() {
assertThat(parser.parseName(tokens("name"), typeSystem), is("name"));
}
@Test
public void shouldParseNameFromSingleQuotedStringWithoutPrefix() {
assertThat(parser.parseName(tokens("'name'"), typeSystem), is("name"));
}
@Test( expected = ParsingException.class )
public void shouldFailToParseNameIfNoMoreTokens() {
parser.parseName(tokens(" "), typeSystem);
}
// ----------------------------------------------------------------------------------------------------------------
// removeBracketsAndQuotes
// ----------------------------------------------------------------------------------------------------------------
@Test
public void shouldRemoveBracketsAndQuotes() {
assertThat(parser.removeBracketsAndQuotes("string", null), is("string"));
assertThat(parser.removeBracketsAndQuotes("'string'", null), is("string"));
assertThat(parser.removeBracketsAndQuotes("word one and two", null), is("word one and two"));
assertThat(parser.removeBracketsAndQuotes("'word one and two'", null), is("word one and two"));
}
@Test
public void shouldFailToRemoveDoubleQuotesAroundOneWord() {
assertThat(parser.removeBracketsAndQuotes("\"string\"", null), is("\"string\""));
assertThat(parser.removeBracketsAndQuotes("\"string\"", null), is("\"string\""));
assertThat(parser.removeBracketsAndQuotes("\"word one and two\"", null), is("\"word one and two\""));
assertThat(parser.removeBracketsAndQuotes("[word one and two]", null), is("[word one and two]"));
}
/*
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived1' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNameArchived%' AND jcr:path LIKE '/drools:repository/drools:package_area/%'
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestPost/assets[%]/%' and ( drools:format='drl' OR drools:format='xls' ) AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestDelete/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestDelete/assets[%]/%' and drools:archive = 'true' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testRestDelete/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testPackageSnapshot/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testPackageSnapshot/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:packagesnapshot_area/testPackageSnapshot/PROD 2.0/assets[%]/%' and drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/searchByFormat/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/searchByFormat/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/searchByFormat/assets[%]/%' and ( drools:format='xyz' OR drools:format='ABC' ) AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/globalArea/assets[%]/%' and drools:format='testSearchSharedAssetByFormat' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/org.drools.archivedtest/assets[%]/%' and drools:archive = 'true' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/org.drools.archivedtest/assets[%]/%' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testExcludeAssetTypes/assets[%]/%' and not drools:format='drl' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testExcludeAssetTypes/assets[%]/%' and not ( drools:format='drl' OR drools:format='wang' ) AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/testExcludeAssetTypes/assets[%]/%' and not ( drools:format='drl' OR drools:format='xls' ) AND drools:archive = 'false' ORDER BY drools:title
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex1' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex2' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE drools:title LIKE 'findRulesByNamex%' AND jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:subject LIKE 'testQueryXXX42' AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND drools:subject LIKE 'testQueryXXX42' AND drools:source LIKE 'database'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '1974-07-10T00:00:00.000-05:00' AND jcr:created < TIMESTAMP '3074-07-10T00:00:00.000-05:00'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '1974-07-10T00:00:00.000-05:00'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created < TIMESTAMP '3074-07-10T00:00:00.000-05:00'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '3074-07-10T00:00:00.000-05:00'
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created < TIMESTAMP '1974-07-10T00:00:00.000-05:00'
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/globalArea/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title
SELECT * FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/globalArea/assets[%]/%' and drools:format='xyz' AND drools:archive = 'false' ORDER BY drools:title
select * from mgnl:content where jcr:path like '/modules/%/templates'
*/
// ----------------------------------------------------------------------------------------------------------------
// Utility methods
// ----------------------------------------------------------------------------------------------------------------
protected Query parse( String query ) {
QueryCommand command = parseCommand(query);
assertThat(command, is(instanceOf(Query.class)));
return (Query)command;
}
protected QueryCommand parseCommand( String query ) {
return parser.parseQuery(query, typeSystem);
}
protected SelectorName selectorName( String name ) {
return new SelectorName(name);
}
protected Name name( String name ) {
return (Name)typeSystem.getTypeFactory(PropertyType.NAME.getName()).create(name);
}
protected Path path( String path ) {
return (Path)typeSystem.getTypeFactory(PropertyType.PATH.getName()).create(path);
}
protected TokenStream tokens( String content ) {
return new TokenStream(content, new BasicSqlQueryParser.SqlTokenizer(false), false).start();
}
}