Class SelectStatement
java.lang.Object
org.eclipse.persistence.jpa.jpql.parser.AbstractExpression
org.eclipse.persistence.jpa.jpql.parser.AbstractSelectStatement
org.eclipse.persistence.jpa.jpql.parser.SelectStatement
- All Implemented Interfaces:
Expression
A
JPA:
EclipseLink 2.4:
HQL query (EclipseLink 2.5):
SELECT
query is an operation that retrieves data from one or more tables or
views.
JPA:
BNF:
select_statement ::= select_clause
from_clause
[where_clause]
[groupby_clause]
[having_clause]
[orderby_clause]
EclipseLink 2.4:
BNF:
select_statement ::= select_clause
from_clause
[where_clause]
[groupby_clause]
[having_clause]
[orderby_clause]
{union_clause}*
HQL query (EclipseLink 2.5):
BNF:
select_statement ::= [select_clause]
from_clause
[where_clause]
[groupby_clause]
[having_clause]
[orderby_clause]
{union_clause}*
- Since:
- 2.3
- Version:
- 2.5
- See Also:
-
Field Summary
Fields inherited from class org.eclipse.persistence.jpa.jpql.parser.AbstractExpression
COMMA, DOT, DOUBLE_QUOTE, LEFT_CURLY_BRACKET, LEFT_PARENTHESIS, NOT_DEFINED, RIGHT_CURLY_BRACKET, RIGHT_PARENTHESIS, SINGLE_QUOTE, SPACE, UNDERSCORE
Fields inherited from interface org.eclipse.persistence.jpa.jpql.parser.Expression
ABS, ALL, AND, ANY, AS, AS_OF, ASC, AVG, BETWEEN, BIT_LENGTH, BOTH, CASE, CAST, CEILING, CHAR_LENGTH, CHARACTER_LENGTH, CLASS, COALESCE, COLUMN, CONCAT, CONNECT_BY, COUNT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DATE, DATETIME, DELETE, DELETE_FROM, DESC, DIFFERENT, DISTINCT, DIVISION, ELSE, EMPTY, END, ENTRY, EQUAL, ESCAPE, EXCEPT, EXISTS, EXP, EXTRACT, FALSE, FETCH, FIRST, FLOOR, FROM, FUNC, FUNCTION, GREATER_THAN, GREATER_THAN_OR_EQUAL, GROUP_BY, HAVING, IN, INDEX, INNER, INNER_JOIN, INNER_JOIN_FETCH, INTERSECT, IS, IS_EMPTY, IS_NOT_EMPTY, IS_NOT_NULL, IS_NULL, JOIN, JOIN_FETCH, KEY, LAST, LEADING, LEFT, LEFT_JOIN, LEFT_JOIN_FETCH, LEFT_OUTER_JOIN, LEFT_OUTER_JOIN_FETCH, LENGTH, LIKE, LN, LOCAL, LOCATE, LOWER, LOWER_THAN, LOWER_THAN_OR_EQUAL, MAX, MEMBER, MEMBER_OF, MIN, MINUS, MOD, MULTIPLICATION, NAMED_PARAMETER, NEW, NOT, NOT_BETWEEN, NOT_EQUAL, NOT_EXISTS, NOT_IN, NOT_LIKE, NOT_MEMBER, NOT_MEMBER_OF, NULL, NULLIF, NULLS, NULLS_FIRST, NULLS_LAST, OBJECT, OF, ON, OPERATOR, OR, ORDER_BY, ORDER_SIBLINGS_BY, OUTER, PLUS, POSITION, POSITIONAL_PARAMETER, POWER, QUOTE, REGEXP, ROUND, SCN, SELECT, SET, SIGN, SIZE, SOME, SQL, SQRT, START_WITH, SUBSTRING, SUM, TABLE, THEN, TIME, TIMESTAMP, TRAILING, TREAT, TRIM, TRUE, TYPE, UNION, UNKNOWN, UPDATE, UPPER, VALUE, WHEN, WHERE
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionvoid
accept
(ExpressionVisitor visitor) Visits thisExpression
by the givenvisitor
.void
acceptChildren
(ExpressionVisitor visitor) Visits the children of thisExpression
.protected void
addChildrenTo
(Collection<Expression> children) Adds the children of thisAbstractExpression
to the given collection.protected void
addOrderedChildrenTo
(List<Expression> children) Adds the children of thisAbstractExpression
to the given list.protected FromClause
Creates the expression representing the from clause of this select statement.protected SelectClause
Creates the expression representing the select clause of this select statement.findQueryBNF
(Expression expression) Retrieves theJPQLQueryBNF
that represents the fragment of thisExpression
that was used when parsing the givenExpression
.Returns theExpression
representing the ORDER BY clause.Returns the BNF of thisExpression
.Returns theExpression
representing the UNION clauses.boolean
Determines whether the ORDER BY clause is defined or not.boolean
Determines whether a whitespace was parsed before the ORDER BY clause.boolean
Determines whether a whitespace was parsed before the UNION clause.boolean
Determines whether at least one UNION clause was defined.protected boolean
isParsingComplete
(WordParser wordParser, String word, Expression expression) Determines whether the parsing is complete based on what is left in the given text.protected void
parse
(WordParser wordParser, boolean tolerant) Parses the query by starting at the current position, which is part of the givenWordParser
.protected void
toParsedText
(StringBuilder writer, boolean actual) Generates a string representation of thisExpression
, including its children, if it has any.Methods inherited from class org.eclipse.persistence.jpa.jpql.parser.AbstractSelectStatement
getFromClause, getGroupByClause, getHavingClause, getSelectClause, getWhereClause, hasFromClause, hasGroupByClause, hasHavingClause, hasSelectClause, hasSpaceAfterFrom, hasSpaceAfterGroupBy, hasSpaceAfterSelect, hasSpaceAfterWhere, hasWhereClause, shouldManageSpaceAfterClause
Methods inherited from class org.eclipse.persistence.jpa.jpql.parser.AbstractExpression
acceptUnknownVisitor, acceptUnknownVisitor, buildExpressionFromFallingBack, buildNullExpression, buildStringExpression, buildStringExpression, buildUnknownExpression, calculatePosition, children, findFallBackExpressionFactory, getExpressionFactory, getExpressionRegistry, getGrammar, getIdentifierVersion, getJPAVersion, getLength, getOffset, getParent, getQueryBNF, getRoot, getText, handleAggregate, handleCollection, isAncestor, isIdentifier, isNull, isTolerant, isUnknown, isVirtual, orderedChildren, parse, parseUsingExpressionFactory, populatePosition, rebuildActualText, rebuildParsedText, setParent, setText, shouldParseWithFactoryFirst, shouldSkipLiteral, toActualText, toParsedText, toString
-
Constructor Details
-
SelectStatement
Creates a newSelectStatement
.- Parameters:
parent
- The parent of this expression
-
-
Method Details
-
accept
Description copied from interface:Expression
Visits thisExpression
by the givenvisitor
.- Parameters:
visitor
- TheExpressionVisitor
to visit this object
-
acceptChildren
Description copied from interface:Expression
Visits the children of thisExpression
. This method can be used to optimize traversing the children since a new list is not created every timeExpression.children()
is called.This does not traverse the
Expression
sub-hierarchy, use a subclass ofAbstractTraverseChildrenVisitor
in order to traverse the entire sub-hierarchy.- Specified by:
acceptChildren
in interfaceExpression
- Overrides:
acceptChildren
in classAbstractSelectStatement
- Parameters:
visitor
- Thevisitor
to visit the children of this object.
-
addChildrenTo
Description copied from class:AbstractExpression
Adds the children of thisAbstractExpression
to the given collection.- Overrides:
addChildrenTo
in classAbstractSelectStatement
- Parameters:
children
- The collection used to store the children
-
addOrderedChildrenTo
Description copied from class:AbstractExpression
Adds the children of thisAbstractExpression
to the given list.- Overrides:
addOrderedChildrenTo
in classAbstractSelectStatement
- Parameters:
children
- The list used to store the string representation of thisAbstractExpression
-
buildFromClause
Description copied from class:AbstractSelectStatement
Creates the expression representing the from clause of this select statement.- Specified by:
buildFromClause
in classAbstractSelectStatement
- Returns:
- A new from clause,
null
can't be returned
-
buildSelectClause
Description copied from class:AbstractSelectStatement
Creates the expression representing the select clause of this select statement.- Specified by:
buildSelectClause
in classAbstractSelectStatement
- Returns:
- A new from clause,
null
can't be returned
-
findQueryBNF
Description copied from interface:Expression
Retrieves theJPQLQueryBNF
that represents the fragment of thisExpression
that was used when parsing the givenExpression
.- Specified by:
findQueryBNF
in interfaceExpression
- Overrides:
findQueryBNF
in classAbstractSelectStatement
- Parameters:
expression
- TheExpression
that is a descendant of this one- Returns:
- The
JPQLQueryBNF
that was used to parse the given expression
-
getOrderByClause
Returns theExpression
representing the ORDER BY clause.- Returns:
- The expression representing the ORDER BY clause
-
getQueryBNF
Description copied from interface:Expression
Returns the BNF of thisExpression
.- Returns:
- The
JPQLQueryBNF
, which represents the grammar of thisExpression
-
getUnionClauses
Returns theExpression
representing the UNION clauses.- Returns:
- The
Expression
representing the UNION clauses
-
hasOrderByClause
public boolean hasOrderByClause()Determines whether the ORDER BY clause is defined or not.- Returns:
true
if the query that got parsed had the ORDER BY clause
-
hasSpaceBeforeOrderBy
public boolean hasSpaceBeforeOrderBy()Determines whether a whitespace was parsed before the ORDER BY clause. In some cases, the space could be owned by a child of the previous clause.- Returns:
true
if there was a whitespace before the ORDER BY;false
otherwise
-
hasSpaceBeforeUnion
public boolean hasSpaceBeforeUnion()Determines whether a whitespace was parsed before the UNION clause. In some cases, the space could be owned by a child of the previous clause.- Returns:
true
if there was a whitespace before the UNION;false
otherwise
-
hasUnionClauses
public boolean hasUnionClauses()Determines whether at least one UNION clause was defined.- Returns:
true
if the query that got parsed had the UNION clauses
-
isParsingComplete
Description copied from class:AbstractExpression
Determines whether the parsing is complete based on what is left in the given text. The text is never empty.- Overrides:
isParsingComplete
in classAbstractExpression
- Parameters:
wordParser
- The text to parse based on the current position of the cursorword
- The word that was retrieved from the given text, which is the first word in the textexpression
- TheExpression
that has already been parsed- Returns:
true
if the text no longer can't be parsed by the current expression;false
if more can be parsed
-
parse
Description copied from class:AbstractExpression
Parses the query by starting at the current position, which is part of the givenWordParser
.- Overrides:
parse
in classAbstractSelectStatement
- Parameters:
wordParser
- The text to parse based on the current position of the cursortolerant
- Determines whether the parsing system should be tolerant, meaning if it should try to parse invalid or incomplete queries
-
toParsedText
Description copied from class:AbstractExpression
Generates a string representation of thisExpression
, including its children, if it has any.- Overrides:
toParsedText
in classAbstractSelectStatement
- Parameters:
writer
- The buffer used to append thisExpression
's string representationactual
- Determines whether the string representation should represent what was parsed, i.e. include any "virtual" whitespace (such as ending whitespace) and the actual case of the JPQL identifiers
-