Class OrderByItem
java.lang.Object
org.eclipse.persistence.jpa.jpql.parser.AbstractExpression
org.eclipse.persistence.jpa.jpql.parser.OrderByItem
- All Implemented Interfaces:
Expression
An orderby_item must be one of the following:
The keyword ASC specifies that ascending ordering be used for the associated orderby_item; the keyword DESC specifies that descending ordering be used. Ascending ordering is the default.
The keyword NULLS FIRST specifies that nulls first ordering be used for the associated orderby_item; the keyword NULLS LAST specifies that nulls last ordering be used. Ascending ordering is the default.
JPA 1.0:
JPA 2.0
EclipseLink 2.4:
- A
state_field_path_expression
that evaluates to an orderable state field of an entity or embeddable class abstract schema type designated in the SELECT clause by one of the following:- A general_identification_variable
- A single_valued_object_path_expression
- A
state_field_path_expression
that evaluates to the same state field of the same entity or embeddable abstract schema type as astate_field_path_expression
in the SELECT clause - A
result_variable
that refers to an orderable item in the SELECT clause for which the sameresult_variable
has been specified. This may be the result of an aggregate_expression, ascalar_expression
, or astate_field_path_expression
in the SELECT clause.
The keyword ASC specifies that ascending ordering be used for the associated orderby_item; the keyword DESC specifies that descending ordering be used. Ascending ordering is the default.
The keyword NULLS FIRST specifies that nulls first ordering be used for the associated orderby_item; the keyword NULLS LAST specifies that nulls last ordering be used. Ascending ordering is the default.
JPA 1.0:
BNF:
orderby_item ::= state_field_path_expression [ ASC | DESC ]
JPA 2.0
BNF:
orderby_item ::= state_field_path_expression | result_variable [ ASC | DESC ]
EclipseLink 2.4:
BNF:
orderby_item ::= state_field_path_expression | result_variable [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]
- Since:
- 2.3
- Version:
- 2.5
-
Nested Class Summary
Modifier and TypeClassDescriptionstatic enum
This enumeration lists all the possible choices for ordering nulls in an item.static enum
This enumeration lists all the possible choices for ordering an item. -
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.findQueryBNF
(Expression expression) Retrieves theJPQLQueryBNF
that represents the fragment of thisExpression
that was used when parsing the givenExpression
.Returns the actualnull
ordering identifier found in the string representation of the JPQL query, which has the actual case that was used.Returns the actual ordering identifier found in the string representation of the JPQL query, which has the actual case that was used.Returns theExpression
that represents the order by expression.Returns the enum constant representing the null ordering type.Returns the enum constant representing the ordering type.Returns the BNF of thisExpression
.boolean
Determines whether the order by expression was parsed.boolean
hasNulls()
Determines whether theNULLS
identifier was parsed.boolean
Determines whetherASC
orDESC
was parsed.boolean
Determines whether a whitespace was parsed after the order by expression.boolean
Determines whether a whitespace was parsed after theNULLS
identifier.boolean
Determines whether a whitespace was parsed after the ordering.boolean
Determines whether the ordering was specified as being ascendant.boolean
Determines whether the ordering was not specified.boolean
Determines whether the ordering was specified as being descendant.boolean
Determines whether the ordering was specified as being nulls first.boolean
Determines whether the ordering was specified as being nulls first.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.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
-
OrderByItem
Creates a newOrderByItem
.- 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.- 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 classAbstractExpression
- 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 classAbstractExpression
- Parameters:
children
- The list used to store the string representation of thisAbstractExpression
-
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 classAbstractExpression
- Parameters:
expression
- TheExpression
that is a descendant of this one- Returns:
- The
JPQLQueryBNF
that was used to parse the given expression
-
getActualNullOrdering
Returns the actualnull
ordering identifier found in the string representation of the JPQL query, which has the actual case that was used.- Returns:
- The
null
ordering identifier that was actually parsed, if one was present, otherwise an empty string is returned
-
getActualOrdering
Returns the actual ordering identifier found in the string representation of the JPQL query, which has the actual case that was used.- Returns:
- The ordering identifier that was actually parsed, if one was present, otherwise an empty string is returned
-
getExpression
Returns theExpression
that represents the order by expression.- Returns:
- The expression that was parsed representing the order by expression
-
getNullOrdering
Returns the enum constant representing the null ordering type.- Returns:
- The constant representing the null ordering, in the case the ordering was not parsed,
then
OrderByItem.NullOrdering.DEFAULT
is returned
-
getOrdering
Returns the enum constant representing the ordering type.- Returns:
- The constant representing the ordering, in the case the ordering was not parsed, then
OrderByItem.Ordering.DEFAULT
is returned
-
getQueryBNF
Description copied from interface:Expression
Returns the BNF of thisExpression
.- Returns:
- The
JPQLQueryBNF
, which represents the grammar of thisExpression
-
hasExpression
public boolean hasExpression()Determines whether the order by expression was parsed.- Returns:
true
if the order by expression was parsed;false
otherwise
-
hasNulls
public boolean hasNulls()Determines whether theNULLS
identifier was parsed.- Returns:
true
if theNULLS
identifier was parsed;false
otherwise
-
hasOrdering
public boolean hasOrdering()Determines whetherASC
orDESC
was parsed.- Returns:
true
if the ordering status was parsed;false
otherwise- Since:
- 2.5
-
hasSpaceAfterExpression
public boolean hasSpaceAfterExpression()Determines whether a whitespace was parsed after the order by expression.- Returns:
true
if there was a whitespace after the order by expression;false
otherwise
-
hasSpaceAfterNulls
public boolean hasSpaceAfterNulls()Determines whether a whitespace was parsed after theNULLS
identifier. If the composite identifier was fully parsed -NULLS FIRST
orNULLS LAST
- then this is alwaystrue
, but if onlyNULLS
was parsed, then this can be useful to determine if there was a space after.- Returns:
true
if there was a whitespace after theNULLS
identifier;false
otherwise
-
hasSpaceAfterOrdering
public boolean hasSpaceAfterOrdering()Determines whether a whitespace was parsed after the ordering.- Returns:
true
if there was a whitespace after the ordering;false
otherwise
-
isAscending
public boolean isAscending()Determines whether the ordering was specified as being ascendant.- Returns:
true
if ASC was parsed;false
otherwise
-
isDefault
public boolean isDefault()Determines whether the ordering was not specified.- Returns:
true
if no ordering was parsed;false
otherwise
-
isDescending
public boolean isDescending()Determines whether the ordering was specified as being descendant.- Returns:
true
if DESC was parsed;false
otherwise
-
isNullsFirst
public boolean isNullsFirst()Determines whether the ordering was specified as being nulls first.- Returns:
true
if NULLS FIRST was parsed;false
otherwise
-
isNullsLast
public boolean isNullsLast()Determines whether the ordering was specified as being nulls first.- Returns:
true
if NULLS LAST was parsed;false
otherwise
-
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
.- Specified by:
parse
in classAbstractExpression
- 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.- Specified by:
toParsedText
in classAbstractExpression
- 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
-