Examples of SqlQueryParser

org.jboss.dna.graph.query.parse.SqlQueryParser

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'

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' /* 'WEAKREFERENCE' is not currently supported in JCR 1.0 */ 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 | Length | NodeName | NodeLocalName | NodePath | NodeDepth |  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 */

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 */

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 */

uk.org.ogsadai.parser.sql92query.SQLQueryParser
An SQL 92 Query parser. @author The OGSA-DAI Project Team

Examples of org.jboss.dna.graph.query.parse.SqlQueryParser

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

View Full Code Here

Examples of org.jboss.dna.graph.query.parse.SqlQueryParser

                                    .addTable("__ALLNODES__", "maker", "model", "year", "msrp", "mpgHighway", "mpgCity")
                                    .makeSearchable("__ALLNODES__", "maker")
                                    .build();


        // And create the SQL parser ...
        sql = new SqlQueryParser();


        variables = new HashMap<String, Object>();
    }

View Full Code Here

Examples of org.jboss.dna.graph.query.parse.SqlQueryParser

            transientSystemSource.setDefaultWorkspaceName(systemWorkspaceName);
            connectionFactoryWithSystem = new DelegatingConnectionFactory(connectionFactory, transientSystemSource);
        }


        // Set up the query parsers, which we have to have even though queries might be disabled ...
        this.queryParsers = new QueryParsers(new SqlQueryParser(), new XPathQueryParser(), new FullTextSearchParser());
        assert this.queryParsers.getParserFor(Query.XPATH) != null;


        this.systemWorkspaceName = systemWorkspaceName;
        this.systemSourceName = systemSourceName;
        this.connectionFactory = connectionFactoryWithSystem;

View Full Code Here

Examples of org.jboss.dna.graph.query.parse.SqlQueryParser

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


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

View Full Code Here

Examples of org.jboss.dna.graph.query.parse.SqlQueryParser

        this.pathFactory = context.getValueFactories().getPathFactory();


        propertyDefinitions = new HashMap<PropertyDefinitionId, JcrPropertyDefinition>();
        childNodeDefinitions = new HashMap<NodeDefinitionId, JcrNodeDefinition>();
        nodeTypes = new HashMap<Name, JcrNodeType>(50);
        queryParser = new SqlQueryParser();


    }

View Full Code Here

Examples of org.jboss.dna.graph.query.parse.SqlQueryParser

                                    .addTable("__ALLNODES__", "maker", "model", "year", "msrp", "mpgHighway", "mpgCity")
                                    .makeSearchable("__ALLNODES__", "maker")
                                    .build();


        // And create the SQL parser ...
        sql = new SqlQueryParser();


        variables = new HashMap<String, Object>();
    }

View Full Code Here

Examples of uk.org.ogsadai.parser.sql92query.SQLQueryParser

        throws SQLParserException,
               ExpressionException, 
               ColumnNotFoundException, 
               UnsupportedOperandTypeException
    {
        SQLQueryParser parser = SQLQueryParser.getInstance();
        CommonTree ast = parser.parseSQLForCondition(condition);
        
        mExpression = ExpressionFactory.buildExpression(ast);
        mExpression.configure(tupleMetadata);
    }

View Full Code Here

TOP

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.