Examples of org.modeshape.jcr.query.parse.BasicSqlQueryParser

org.modeshape.jcr.query.parse.BasicSqlQueryParser

oinType is omitted INNER is assumed. left ::= Source right ::= Source JoinType ::= Inner | LeftOuter | RightOuter | FullOuter | Cross Inner ::= 'INNER' ['JOIN'] LeftOuter ::= 'LEFT JOIN' | 'OUTER JOIN' | 'LEFT OUTER JOIN' RightOuter ::= 'RIGHT OUTER' ['JOIN'] RightOuter ::= 'FULL OUTER' ['JOIN'] RightOuter ::= 'CROSS' ['JOIN'] JoinCondition ::= EquiJoinCondition | SameNodeJoinCondition | ChildNodeJoinCondition | DescendantNodeJoinCondition

Equi-join conditions

 EquiJoinCondition ::= selector1Name'.'property1Name '=' selector2Name'.'property2Name selector1Name ::= selectorName selector2Name ::= selectorName property1Name ::= propertyName property2Name ::= propertyName

Same-node join condition

 SameNodeJoinCondition ::= 'ISSAMENODE(' selector1Name ',' selector2Name [',' selector2Path] ')' selector2Path ::= Path

Child-node join condition

 ChildNodeJoinCondition ::= 'ISCHILDNODE(' childSelectorName ',' parentSelectorName ')' childSelectorName ::= selectorName parentSelectorName ::= selectorName

Descendant-node join condition

 DescendantNodeJoinCondition ::= 'ISDESCENDANTNODE(' descendantSelectorName ',' ancestorSelectorName ')' descendantSelectorName ::= selectorName ancestorSelectorName ::= selectorName

Constraints

 Constraint ::= ConstraintItem | '(' ConstraintItem ')' ConstraintItem ::= And | Or | Not | Comparison | Between | PropertyExistence | SetConstraint | FullTextSearch |  SameNode | ChildNode | DescendantNode

And constraint

 And ::= constraint1 'AND' constraint2 constraint1 ::= Constraint constraint2 ::= Constraint

Or constraint

 Or ::= constraint1 'OR' constraint2

Not constraint

 Not ::= 'NOT' Constraint

Comparison constraint

 Comparison ::= DynamicOperand Operator StaticOperand Operator ::= '=' | '!=' | '<' | '<=' | '>' | '>=' | 'LIKE' | 'NOT LIKE'

Between constraint

 Between ::= DynamicOperand ['NOT'] 'BETWEEN' lowerBound ['EXCLUSIVE'] 'AND' upperBound ['EXCLUSIVE'] lowerBound ::= StaticOperand upperBound ::= StaticOperand

Property existence constraint

 PropertyExistence ::= selectorName'.'propertyName 'IS' ['NOT'] 'NULL' |  propertyName 'IS' ['NOT'] 'NULL' /* If only one selector exists in this query */

Set constraint

 SetConstraint ::= selectorName'.'propertyName ['NOT'] 'IN' |  propertyName ['NOT'] 'IN' /* If only one selector exists in this query */ '(' firstStaticOperand {',' additionalStaticOperand } ')' firstStaticOperand ::= StaticOperand additionalStaticOperand ::= StaticOperand

Full-text search constraint

 FullTextSearch ::= 'CONTAINS(' ([selectorName'.']propertyName | selectorName'.*')  ',' ''' fullTextSearchExpression''' ')' /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional */ fullTextSearchExpression ::= /* a full-text search expression, see  {@link FullTextSearchParser} */

Same-node constraint

 SameNode ::= 'ISSAMENODE(' [selectorName ','] Path ')'  /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional */

Child-node constraint

 ChildNode ::= 'ISCHILDNODE(' [selectorName ','] Path ')'  /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional */

Descendant-node constraint

 DescendantNode ::= 'ISDESCENDANTNODE(' [selectorName ','] Path ')'  /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional */

Paths and names

 Name ::= '[' quotedName ']' | '[' simpleName ']' | simpleName quotedName ::= /* A JCR Name (see the JCR specification) */ simpleName ::= /* A JCR Name that contains only SQL-legal characters (namely letters, digits, and underscore) */ Path ::= '[' quotedPath ']' | '[' simplePath ']' | simplePath quotedPath ::= /* A JCR Path that contains non-SQL-legal characters */ simplePath ::= /* A JCR Path (rather Name) that contains only SQL-legal characters (namely letters, digits, and underscore) */

Static operands

 StaticOperand ::= Literal | BindVariableValue

Literal

 Literal ::= CastLiteral | UncastLiteral CastLiteral ::= 'CAST(' UncastLiteral ' AS ' PropertyType ')' PropertyType ::= 'STRING' | 'BINARY' | 'DATE' | 'LONG' | 'DOUBLE' | 'DECIMAL' | 'BOOLEAN' | 'NAME' | 'PATH' |  'REFERENCE' | 'WEAKREFERENCE' | 'URI' UncastLiteral ::= UnquotedLiteral | ''' UnquotedLiteral ''' | '"' UnquotedLiteral '"' UnquotedLiteral ::= /* String form of a JCR Value, as defined in the JCR specification */

Bind variables

 BindVariableValue ::= '$'bindVariableName bindVariableName ::= /* A string that conforms to the JCR Name syntax, though the prefix does not need to be a registered namespace prefix. */

Dynamic operands

 DynamicOperand ::= PropertyValue | ReferenceValue | Length | NodeName | NodeLocalName | NodePath | NodeDepth | NodeId | FullTextSearchScore | LowerCase | UpperCase | Arithmetic | '(' DynamicOperand ')'

Property value

 PropertyValue ::= [selectorName'.'] propertyName /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional */

Reference value

 ReferenceValue ::= 'REFERENCE(' selectorName '.' propertyName ')' | 'REFERENCE(' selectorName ')' | 'REFERENCE()' | /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional. Also, the property name may be excluded  if the constraint should apply to any reference property. */

Property length

 Length ::= 'LENGTH(' PropertyValue ')'

Node name

 NodeName ::= 'NAME(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Node local name

 NodeLocalName ::= 'LOCALNAME(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Node path

 NodePath ::= 'PATH(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Node depth

 NodeDepth ::= 'DEPTH(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Node identifier

 NodeId ::= 'ID(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Child count

 ChildCount ::= 'CHILDCOUNT(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Full-text search score

 FullTextSearchScore ::= 'SCORE(' [selectorName] ')' /* If only one selector exists in this query, explicit specification of the selectorName is optional */

Lowercase

 LowerCase ::= 'LOWER(' DynamicOperand ')'

Uppercase

 UpperCase ::= 'UPPER(' DynamicOperand ')'

Arithmetic

 Arithmetic ::= DynamicOperand ('+'|'-'|'*'|'/') DynamicOperand

Ordering

 orderings ::= Ordering {',' Ordering} Ordering ::= DynamicOperand [Order] Order ::= 'ASC' | 'DESC'

Columns

 columns ::= (Column ',' {Column}) | '*' Column ::= ([selectorName'.']propertyName ['AS' columnName]) | (selectorName'.*') /* If only one selector exists in this query, explicit specification of the selectorName preceding the propertyName is optional */ selectorName ::= Name propertyName ::= Name columnName ::= Name

Limit

 Limit ::= 'LIMIT' count [ 'OFFSET' offset ] count ::= /* Positive integer value */ offset ::= /* Non-negative integer value */

        this.nodeTypesPath = pathFactory.createAbsolutePath(JcrLexicon.SYSTEM, JcrLexicon.NODE_TYPES);
        this.nodeTypesCache = new NodeTypes(this.context);


        this.includeColumnsForInheritedProperties = includeColumnsForInheritedProperties;
        this.includePseudoColumnsInSelectStar = includePseudoColumnsInSelectStar;
        queryParser = new BasicSqlQueryParser();
    }

View Full Code Here

        XPathToQueryTranslator translator = new XPathToQueryTranslator(typeSystem, xpath);
        return translator.createQuery(component);
    }


    protected QueryCommand sql( String sql ) {
        return new BasicSqlQueryParser().parseQuery(sql, typeSystem);
    }

View Full Code Here

         */
        public Builder addView( String name,
                                String definition ) {
            CheckArg.isNotEmpty(name, "name");
            CheckArg.isNotEmpty(definition, "definition");
            BasicSqlQueryParser parser = new BasicSqlQueryParser();
            QueryCommand command = parser.parseQuery(definition, typeSystem);
            this.viewDefinitions.put(new SelectorName(name), command);
            return this;
        }

View Full Code Here

                             String alias ) {
        return new Column(new SelectorName(table), columnName, alias);
    }


    protected PlanNode optimize( String sql ) {
        QueryCommand query = new BasicSqlQueryParser().parseQuery(sql, context.getTypeSystem());
        Problems problems = context.getProblems();
        assertThat("Problems parsing query: " + sql + "\n" + problems, problems.hasErrors(), is(false));
        PlanNode plan = new CanonicalPlanner().createPlan(context, query);
        assertThat("Problems planning query: " + sql + "\n" + problems, problems.hasErrors(), is(false));
        PlanNode optimized = new RuleBasedOptimizer().optimize(context, plan);

View Full Code Here

TOP

Related Classes of org.modeshape.jcr.query.parse.BasicSqlQueryParser

org.modeshape.common.text.Position

org.modeshape.common.text.TokenStream

org.modeshape.common.text.TokenStream.Tokenizer

org.modeshape.jcr.api.query.qom.Operator

org.modeshape.jcr.query.model.And

org.modeshape.jcr.query.model.ArithmeticOperand

org.modeshape.jcr.query.model.ArithmeticOperator

org.modeshape.jcr.query.model.Between

org.modeshape.jcr.query.model.BindVariableName

org.modeshape.jcr.query.model.ChildCount

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.