Class SubStringExpression
- java.lang.Object
-
- org.apache.openjpa.persistence.query.SubStringExpression
-
- All Implemented Interfaces:
Serializable,Aggregate,Expression,OrderByItem,PredicateOperand,SelectItem,Visitable
public class SubStringExpression extends Object
Denotes SUBSTR(a,i1,i2) Expression.- Author:
- Pinaki Poddar
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description protected Expression_eprotected UnaryFunctionalOperator_opstatic StringCLOSE_BRACEstatic StringCOMMAstatic StringEMPTYstatic StringOPEN_BRACEstatic StringSPACE
-
Constructor Summary
Constructors Constructor Description SubStringExpression(Expression op, int start)SubStringExpression(Expression op, int start, int len)SubStringExpression(Expression op, Expression start)SubStringExpression(Expression op, Expression start, Expression l)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description Expressionabs()Absolute value.OrderByItemasc()Return an OrderByItem referencing the SelectItem and specifying ascending ordering.StringasExpression(org.apache.openjpa.persistence.query.AliasContext ctx)Get a JPQL fragment as used in WHERE clause.StringasJoinable(org.apache.openjpa.persistence.query.AliasContext ctx)Gets the string representation in FROM clause.StringasProjection(org.apache.openjpa.persistence.query.AliasContext ctx)Gets the string representation in SELECT projection.Predicatebetween(Number arg1, Number arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(Number arg1, PredicateOperand arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(String arg1, String arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(String arg1, PredicateOperand arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(Calendar arg1, Calendar arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(Calendar arg1, PredicateOperand arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(Date arg1, Date arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(Date arg1, PredicateOperand arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(PredicateOperand arg1, Number arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(PredicateOperand arg1, String arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(PredicateOperand arg1, Calendar arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(PredicateOperand arg1, Date arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Predicatebetween(PredicateOperand arg1, PredicateOperand arg2)Create a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.Expressionconcat(String... str)Concatenate a string with other string(s).Expressionconcat(Expression... exprs)Concatenate a string with other string(s).OrderByItemdesc()Return an OrderByItem referencing the SelectItem and specifying descending ordering.Expressiondistinct()Specify that duplicates are to be removed before the aggregate operation is invoked.ExpressiondividedBy(Number num)Division.ExpressiondividedBy(Expression expr)Division.Predicateequal(boolean arg)Create a predicate for testing equality with the specified argument.Predicateequal(Class cls)Create a predicate for testing equality with the specified argument.Predicateequal(Enum<?> e)Create a predicate for testing equality with the specified argument.Predicateequal(Number arg)Create a predicate for testing equality with the specified argument.Predicateequal(String arg)Create a predicate for testing equality with the specified argument.Predicateequal(Calendar arg)Create a predicate for testing equality with the specified argument.Predicateequal(Date arg)Create a predicate for testing equality with the specified argument.Predicateequal(PredicateOperand arg)Create a predicate for testing equality with the specified argument.StringgetAliasHint(org.apache.openjpa.persistence.query.AliasContext ctx)Gets the hint to be used while creating alias.ExpressiongetOperand()UnaryFunctionalOperatorgetOperator()PredicategreaterEqual(Number arg)Create a predicate for testing whether the PredicateOperand is greater than or equal to the argument.PredicategreaterEqual(String arg)Create a predicate for testing whether the PredicateOperand is greater than or equal to the argument.PredicategreaterEqual(Calendar arg)Create a predicate for testing whether the PredicateOperand is greater than or equal to the argument.PredicategreaterEqual(Date arg)Create a predicate for testing whether the PredicateOperand is greater than or equal to the argument.PredicategreaterEqual(PredicateOperand arg)Create a predicate for testing whether the PredicateOperand is greater than or equal to the argument.PredicategreaterThan(Number arg)Create a predicate for testing whether the PredicateOperand is greater than the argument.PredicategreaterThan(String arg)Create a predicate for testing whether the PredicateOperand is greater than the argument.PredicategreaterThan(Calendar arg)Create a predicate for testing whether the PredicateOperand is greater than the argument.PredicategreaterThan(Date arg)Create a predicate for testing whether the PredicateOperand is greater than the argument.PredicategreaterThan(PredicateOperand arg)Create a predicate for testing whether the PredicateOperand is greater than the argument.Predicatein(Class... classes)Create a predicate for testing whether the expression value is a member of the argument list.Predicatein(Enum<?>... enums)Create a predicate for testing whether the expression value is a member of the argument list.Predicatein(Number... nums)Create a predicate for testing whether the expression value is a member of the argument list.Predicatein(String... strings)Create a predicate for testing whether the expression value is a member of the argument list.Predicatein(Expression... params)Create a predicate for testing whether the expression value is a member of the argument list.Predicatein(Subquery subquery)Create a predicate for testing whether the expression value is a member of a subquery result.PredicateisNull()Create a predicate for testing whether the value of the expression is null.Expressionlength()String length This method must be invoked on an expression corresponding to a string.PredicatelessEqual(Number arg)Create a predicate for testing whether the PredicateOperand is less than or equal to the argument.PredicatelessEqual(String arg)Create a predicate for testing whether the PredicateOperand is less than or equal to the argument.PredicatelessEqual(Calendar arg)Create a predicate for testing whether the PredicateOperand is less than or equal to the argument.PredicatelessEqual(Date arg)Create a predicate for testing whether the PredicateOperand is less than or equal to the argument.PredicatelessEqual(PredicateOperand arg)Create a predicate for testing whether the PredicateOperand is less than or equal to the argument.PredicatelessThan(Number arg)Create a predicate for testing whether the PredicateOperand is less than the argument.PredicatelessThan(String arg)Create a predicate for testing whether the PredicateOperand is less than the argument.PredicatelessThan(Calendar arg)Create a predicate for testing whether the PredicateOperand is less than the argument.PredicatelessThan(Date arg)Create a predicate for testing whether the PredicateOperand is less than the argument.PredicatelessThan(PredicateOperand arg)Create a predicate for testing whether the PredicateOperand is less than the argument.Predicatelike(String pattern)Create a predicate for testing whether the PredicateOperand satisfies the given pattern.Predicatelike(String pattern, char escChar)Create a predicate for testing whether the PredicateOperand satisfies the given pattern.Predicatelike(String pattern, PredicateOperand escapeChar)Create a predicate for testing whether the PredicateOperand satisfies the given pattern.Predicatelike(PredicateOperand pattern)Create a predicate for testing whether the PredicateOperand satisfies the given pattern.Predicatelike(PredicateOperand pattern, char escapeChar)Create a predicate for testing whether the PredicateOperand satisfies the given pattern.Predicatelike(PredicateOperand pattern, PredicateOperand escChar)Create a predicate for testing whether the PredicateOperand satisfies the given pattern.Expressionlocate(String str)Locate a string contained within the string corresponding to the expression on which the method was invoked.Expressionlocate(String str, int position)Locate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position.Expressionlocate(String str, Expression position)Locate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position.Expressionlocate(Expression expr)Locate a string contained within the string corresponding to the expression on which the method was invoked.Expressionlocate(Expression str, int position)Locate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position.Expressionlocate(Expression str, Expression position)Locate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position.Expressionlower()Convert string to lowercase.Predicatemember(PathExpression arg)Create a predicate for testing whether the expression is a member of the association or element collection denoted by the path expression.Expressionminus()Unary minus.Expressionminus(Number num)Subtraction.Expressionminus(Expression expr)Subtraction.Expressionmod(int num)Modulo operation.Expressionmod(Expression expr)Modulo operation.PredicatenotEqual(boolean arg)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(Class cls)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(Enum<?> e)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(Number arg)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(String arg)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(Calendar arg)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(Date arg)Create a predicate for testing inequality with the specified argument.PredicatenotEqual(PredicateOperand arg)Create a predicate for testing inequality with the specified argument.Expressionplus(Number num)Addition.Expressionplus(Expression expr)Addition.Expressionsqrt()Square root.Expressionsubstring(int start)Extract a substring starting at specified position through to the end of the string.Expressionsubstring(int start, int len)Extract a substring.Expressionsubstring(int start, Expression len)Extract a substring.Expressionsubstring(Expression start)Extract a substring starting at specified position through to the end of the string.Expressionsubstring(Expression start, int len)Extract a substring.Expressionsubstring(Expression start, Expression len)Extract a substring.Expressiontimes(Number num)Multiplication.Expressiontimes(Expression expr)Multiplication.Expressiontrim()Trim leading and trailing blanks.Expressiontrim(char c)Trim leading and trailing occurrences of character from the string.Expressiontrim(char c, TrimSpec spec)Trim occurrences of the character from leading or trailing (or both) positions of the string, as specified by trim spec.Expressiontrim(Expression expr)Trim leading and trailing occurrences of character specified by the expression argument from the string.Expressiontrim(Expression expr, TrimSpec spec)Trim occurrences of the character specified by the expression argument from leading or trailing (or both) positions of the string, as specified by trim spec.Expressiontrim(TrimSpec spec)Trim leading, trailing blanks (or both) as specified by trim spec.Expressionupper()Convert string to uppercase.-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface org.apache.openjpa.persistence.query.Expression
abs, concat, concat, dividedBy, dividedBy, in, in, in, in, in, in, isNull, length, locate, locate, locate, locate, locate, locate, lower, member, minus, minus, minus, mod, mod, plus, plus, sqrt, substring, substring, substring, substring, substring, substring, times, times, trim, trim, trim, trim, trim, trim, upper
-
Methods inherited from interface org.apache.openjpa.persistence.query.PredicateOperand
between, between, between, between, between, between, between, between, between, between, between, between, between, equal, equal, equal, equal, equal, equal, equal, equal, greaterEqual, greaterEqual, greaterEqual, greaterEqual, greaterEqual, greaterThan, greaterThan, greaterThan, greaterThan, greaterThan, lessEqual, lessEqual, lessEqual, lessEqual, lessEqual, lessThan, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, like, notEqual, notEqual, notEqual, notEqual, notEqual, notEqual, notEqual, notEqual
-
Methods inherited from interface org.apache.openjpa.persistence.query.SelectItem
asc, desc
-
Methods inherited from interface org.apache.openjpa.persistence.query.Visitable
asJoinable
-
-
-
-
Field Detail
-
_e
protected final Expression _e
-
_op
protected final UnaryFunctionalOperator _op
-
SPACE
public static final String SPACE
- See Also:
- Constant Field Values
-
OPEN_BRACE
public static final String OPEN_BRACE
- See Also:
- Constant Field Values
-
CLOSE_BRACE
public static final String CLOSE_BRACE
- See Also:
- Constant Field Values
-
COMMA
public static final String COMMA
- See Also:
- Constant Field Values
-
EMPTY
public static final String EMPTY
- See Also:
- Constant Field Values
-
-
Constructor Detail
-
SubStringExpression
public SubStringExpression(Expression op, Expression start)
-
SubStringExpression
public SubStringExpression(Expression op, int start)
-
SubStringExpression
public SubStringExpression(Expression op, int start, int len)
-
SubStringExpression
public SubStringExpression(Expression op, Expression start, Expression l)
-
-
Method Detail
-
asExpression
public String asExpression(org.apache.openjpa.persistence.query.AliasContext ctx)
Description copied from interface:VisitableGet a JPQL fragment as used in WHERE clause.- Specified by:
asExpressionin interfaceVisitable
-
getOperand
public Expression getOperand()
-
getOperator
public UnaryFunctionalOperator getOperator()
-
distinct
public Expression distinct()
Description copied from interface:AggregateSpecify that duplicates are to be removed before the aggregate operation is invoked.
-
asProjection
public String asProjection(org.apache.openjpa.persistence.query.AliasContext ctx)
Description copied from interface:VisitableGets the string representation in SELECT projection.- Specified by:
asProjectionin interfaceVisitable
-
abs
public Expression abs()
Description copied from interface:ExpressionAbsolute value. This method must be invoked on an expression corresponding to a number.- Specified by:
absin interfaceExpression- Returns:
- expression corresponding to the absolute value
-
concat
public Expression concat(String... str)
Description copied from interface:ExpressionConcatenate a string with other string(s). This method must be invoked on an expression corresponding to a string.- Specified by:
concatin interfaceExpression- Parameters:
str- - string(s)- Returns:
- expression denoting the concatenation of the strings, starting with the string corresponding to the expression on which the method was invoked.
-
concat
public Expression concat(Expression... exprs)
Description copied from interface:ExpressionConcatenate a string with other string(s). This method must be invoked on an expression corresponding to a string.- Specified by:
concatin interfaceExpression- Parameters:
exprs- - expression(s) corresponding to string(s)- Returns:
- expression denoting the concatenation of the strings, starting with the string corresponding to the expression on which the method was invoked.
-
dividedBy
public Expression dividedBy(Number num)
Description copied from interface:ExpressionDivision. This method must be invoked on an expression corresponding to a number.- Specified by:
dividedByin interfaceExpression- Parameters:
num- - divisor- Returns:
- expression denoting the result of dividing the number corresponding to the expression on which the method was invoked by the argument
-
dividedBy
public Expression dividedBy(Expression expr)
Description copied from interface:ExpressionDivision. This method must be invoked on an expression corresponding to a number.- Specified by:
dividedByin interfaceExpression- Parameters:
expr- - expression corresponding to the divisor- Returns:
- expression denoting the result of dividing the number corresponding to the expression on which the method was invoked by the number denoted by the argument
-
in
public Predicate in(String... strings)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression value is a member of the argument list.- Specified by:
inin interfaceExpression- Returns:
- conditional predicate
-
in
public Predicate in(Number... nums)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression value is a member of the argument list.- Specified by:
inin interfaceExpression- Returns:
- conditional predicate
-
in
public Predicate in(Enum<?>... enums)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression value is a member of the argument list.- Specified by:
inin interfaceExpression- Returns:
- conditional predicate
-
in
public Predicate in(Class... classes)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression value is a member of the argument list.- Specified by:
inin interfaceExpression- Returns:
- conditional predicate
-
in
public Predicate in(Expression... params)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression value is a member of the argument list.- Specified by:
inin interfaceExpression- Returns:
- conditional predicate
-
in
public Predicate in(Subquery subquery)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression value is a member of a subquery result.- Specified by:
inin interfaceExpression- Returns:
- conditional predicate
-
isNull
public Predicate isNull()
Description copied from interface:ExpressionCreate a predicate for testing whether the value of the expression is null.- Specified by:
isNullin interfaceExpression- Returns:
- conditional predicate
-
length
public Expression length()
Description copied from interface:ExpressionString length This method must be invoked on an expression corresponding to a string.- Specified by:
lengthin interfaceExpression- Returns:
- expression denoting the length of the string.
-
locate
public Expression locate(String str)
Description copied from interface:ExpressionLocate a string contained within the string corresponding to the expression on which the method was invoked. The search is started at position 1 (first string position). This method must be invoked on an expression corresponding to a string.- Specified by:
locatein interfaceExpression- Parameters:
str- - string to be located- Returns:
- expression denoting the first position at which the string was found or expression denoting 0 if the string was not found
-
locate
public Expression locate(Expression expr)
Description copied from interface:ExpressionLocate a string contained within the string corresponding to the expression on which the method was invoked. The search is started at position 1 (first string position). This method must be invoked on an expression corresponding to a string.- Specified by:
locatein interfaceExpression- Parameters:
expr- - expression corresponding to the string to be located- Returns:
- expression denoting the first position at which the string was found or expression denoting 0 if the string was not found
-
locate
public Expression locate(String str, int position)
Description copied from interface:ExpressionLocate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position. This method must be invoked on an expression corresponding to a string.- Specified by:
locatein interfaceExpression- Parameters:
str- - string to be locatedposition- - position at which to start the search- Returns:
- expression denoting the first position at which the string was found or expression denoting 0 if the string was not found
-
locate
public Expression locate(String str, Expression position)
Description copied from interface:ExpressionLocate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position. This method must be invoked on an expression corresponding to a string.- Specified by:
locatein interfaceExpression- Parameters:
str- - string to be locatedposition- - expression corresponding to position at which to start the search- Returns:
- expression denoting the first position at which the string was found or expression denoting 0 if the string was not found
-
locate
public Expression locate(Expression str, int position)
Description copied from interface:ExpressionLocate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position. This method must be invoked on an expression corresponding to a string.- Specified by:
locatein interfaceExpression- Parameters:
str- - expression corresponding to the string to be locatedposition- - position at which to start the search- Returns:
- expression denoting the first position at which the string was found or expression denoting 0 if the string was not found
-
locate
public Expression locate(Expression str, Expression position)
Description copied from interface:ExpressionLocate a string contained within the string corresponding to the expression on which the method was invoked, starting at a specified search position. This method must be invoked on an expression corresponding to a string.- Specified by:
locatein interfaceExpression- Parameters:
str- - expression corresponding to the string to be locatedposition- - expression corresponding to position at which to start the search- Returns:
- expression denoting the first position at which the string was found or expression denoting 0 if the string was not found
-
lower
public Expression lower()
Description copied from interface:ExpressionConvert string to lowercase. This method must be invoked on an expression corresponding to a string.- Specified by:
lowerin interfaceExpression- Returns:
- expression denoting the string in lowercase
-
member
public Predicate member(PathExpression arg)
Description copied from interface:ExpressionCreate a predicate for testing whether the expression is a member of the association or element collection denoted by the path expression. The argument must correspond to a collection-valued association or element collection of like type.- Specified by:
memberin interfaceExpression- Parameters:
arg- - a path expression that specifies a collection-valued association or an element collection- Returns:
- conditional predicate
-
minus
public Expression minus()
Description copied from interface:ExpressionUnary minus. This method must be invoked on an expression corresponding to a number.- Specified by:
minusin interfaceExpression- Returns:
- expression denoting the unary minus of the expression
-
minus
public Expression minus(Number num)
Description copied from interface:ExpressionSubtraction. This method must be invoked on an expression corresponding to a number.- Specified by:
minusin interfaceExpression- Parameters:
num- - subtrahend- Returns:
- expression denoting the result of subtracting the argument from the number corresponding to the expression on which the method was invoked.
-
minus
public Expression minus(Expression expr)
Description copied from interface:ExpressionSubtraction. This method must be invoked on an expression corresponding to a number.- Specified by:
minusin interfaceExpression- Parameters:
expr- - expression corresponding to subtrahend- Returns:
- expression denoting the result of subtracting the number denoted by the argument from the number corresponding to the expression on which the method was invoked.
-
mod
public Expression mod(int num)
Description copied from interface:ExpressionModulo operation. This must be invoked on an expression corresponding to an integer value- Specified by:
modin interfaceExpression- Parameters:
num- - integer divisor- Returns:
- expression corresponding to the integer remainder of the division of the integer corresponding to the expression on which the method was invoked by the argument.
-
mod
public Expression mod(Expression expr)
Description copied from interface:ExpressionModulo operation. This must be invoked on an expression corresponding to an integer value- Specified by:
modin interfaceExpression- Parameters:
expr- - expression corresponding to integer divisor- Returns:
- expression corresponding to the integer remainder of the division of the integer corresponding to the expression on which the method was invoked by the argument.
-
plus
public Expression plus(Number num)
Description copied from interface:ExpressionAddition. This method must be invoked on an expression corresponding to a number.- Specified by:
plusin interfaceExpression- Parameters:
num- - number to be added- Returns:
- expression denoting the sum
-
plus
public Expression plus(Expression expr)
Description copied from interface:ExpressionAddition. This method must be invoked on an expression corresponding to a number.- Specified by:
plusin interfaceExpression- Parameters:
expr- - expression corresponding to number to be added- Returns:
- expression denoting the sum
-
sqrt
public Expression sqrt()
Description copied from interface:ExpressionSquare root. This method must be invoked on an expression corresponding to a number.- Specified by:
sqrtin interfaceExpression- Returns:
- expression corresponding to the square root
-
substring
public Expression substring(int start)
Description copied from interface:ExpressionExtract a substring starting at specified position through to the end of the string. This method must be invoked on an expression corresponding to a string.- Specified by:
substringin interfaceExpression- Parameters:
start- - start position (1 indicates first position)- Returns:
- expression denoting the extracted substring
-
substring
public Expression substring(Expression start)
Description copied from interface:ExpressionExtract a substring starting at specified position through to the end of the string. This method must be invoked on an expression corresponding to a string.- Specified by:
substringin interfaceExpression- Parameters:
start- - expression denoting start position (1 indicates first position)- Returns:
- expression denoting the extracted substring
-
substring
public Expression substring(int start, int len)
Description copied from interface:ExpressionExtract a substring. This method must be invoked on an expression corresponding to a string.- Specified by:
substringin interfaceExpression- Parameters:
start- - start position (1 indicates first position)len- - length of the substring to be returned- Returns:
- expression denoting the extracted substring
-
substring
public Expression substring(int start, Expression len)
Description copied from interface:ExpressionExtract a substring. This method must be invoked on an expression corresponding to a string.- Specified by:
substringin interfaceExpression- Parameters:
start- - start position (1 indicates first position)len- - expression denoting length of the substring to return- Returns:
- expression denoting the extracted substring
-
substring
public Expression substring(Expression start, int len)
Description copied from interface:ExpressionExtract a substring. This method must be invoked on an expression corresponding to a string.- Specified by:
substringin interfaceExpression- Parameters:
start- - expression denoting start position (1 indicates first position)len- - length of the substring to return- Returns:
- expression denoting the extracted substring
-
substring
public Expression substring(Expression start, Expression len)
Description copied from interface:ExpressionExtract a substring. This method must be invoked on an expression corresponding to a string.- Specified by:
substringin interfaceExpression- Parameters:
start- - expression denoting start position (1 indicates first position)len- - expression denoting length of the substring to return- Returns:
- expression denoting the extracted substring
-
times
public Expression times(Number num)
Description copied from interface:ExpressionMultiplication. This method must be invoked on an expression corresponding to a number.- Specified by:
timesin interfaceExpression- Parameters:
num- - multiplier- Returns:
- expression denoting the result of multiplying the argument with the number corresponding to the expression on which the method was invoked.
-
times
public Expression times(Expression expr)
Description copied from interface:ExpressionMultiplication. This method must be invoked on an expression corresponding to a number.- Specified by:
timesin interfaceExpression- Parameters:
expr- - expression corresponding to the multiplier- Returns:
- expression denoting the result of multiplying the number denoted by the argument with the number corresponding to the expression on which the method was invoked.
-
trim
public Expression trim()
Description copied from interface:ExpressionTrim leading and trailing blanks. This method must be invoked on an expression corresponding to a string.- Specified by:
trimin interfaceExpression- Returns:
- expression denoting trimmed string
-
trim
public Expression trim(TrimSpec spec)
Description copied from interface:ExpressionTrim leading, trailing blanks (or both) as specified by trim spec. This method must be invoked on an expression corresponding to a string.- Specified by:
trimin interfaceExpression- Parameters:
spec- - trim specification- Returns:
- expression denoting trimmed string
-
trim
public Expression trim(char c)
Description copied from interface:ExpressionTrim leading and trailing occurrences of character from the string. This method must be invoked on an expression corresponding to a string.- Specified by:
trimin interfaceExpression- Parameters:
c- - character to be trimmed- Returns:
- expression denoting trimmed string
-
trim
public Expression trim(char c, TrimSpec spec)
Description copied from interface:ExpressionTrim occurrences of the character from leading or trailing (or both) positions of the string, as specified by trim spec. This method must be invoked on an expression corresponding to a string.- Specified by:
trimin interfaceExpression- Parameters:
c- - character to be trimmedspec- - trim specification- Returns:
- expression denoting trimmed string
-
trim
public Expression trim(Expression expr)
Description copied from interface:ExpressionTrim leading and trailing occurrences of character specified by the expression argument from the string. This method must be invoked on an expression corresponding to a string.- Specified by:
trimin interfaceExpression- Parameters:
expr- - expression corresponding to the character to be trimmed- Returns:
- expression denoting trimmed string
-
trim
public Expression trim(Expression expr, TrimSpec spec)
Description copied from interface:ExpressionTrim occurrences of the character specified by the expression argument from leading or trailing (or both) positions of the string, as specified by trim spec. This method must be invoked on an expression corresponding to a string.- Specified by:
trimin interfaceExpression- Parameters:
expr- - expression corresponding to the character to be trimmedspec- - trim specification- Returns:
- expression denoting trimmed string
-
upper
public Expression upper()
Description copied from interface:ExpressionConvert string to uppercase. This method must be invoked on an expression corresponding to a string.- Specified by:
upperin interfaceExpression- Returns:
- expression denoting the string in uppercase
-
asc
public OrderByItem asc()
Description copied from interface:SelectItemReturn an OrderByItem referencing the SelectItem and specifying ascending ordering. The SelectItem must correspond to an orderable value.- Specified by:
ascin interfaceSelectItem- Returns:
- order-by item
-
desc
public OrderByItem desc()
Description copied from interface:SelectItemReturn an OrderByItem referencing the SelectItem and specifying descending ordering. The SelectItem must correspond to an orderable value.- Specified by:
descin interfaceSelectItem- Returns:
- order-by item
-
between
public Predicate between(PredicateOperand arg1, PredicateOperand arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - PredicateOperand instance or parameterarg2- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
between
public Predicate between(PredicateOperand arg1, Number arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - PredicateOperand instance or parameterarg2- - numeric- Returns:
- conditional predicate
-
between
public Predicate between(Number arg1, PredicateOperand arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - numericarg2- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
between
public Predicate between(Number arg1, Number arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - numericarg2- - numeric- Returns:
- conditional predicate
-
between
public Predicate between(PredicateOperand arg1, String arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - PredicateOperand instance or parameterarg2- - string- Returns:
- conditional predicate
-
between
public Predicate between(String arg1, PredicateOperand arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - stringarg2- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
between
public Predicate between(String arg1, String arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - stringarg2- - string- Returns:
- conditional predicate
-
between
public Predicate between(PredicateOperand arg1, Date arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - PredicateOperand instance or parameterarg2- - date- Returns:
- conditional predicate
-
between
public Predicate between(Date arg1, PredicateOperand arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - datearg2- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
between
public Predicate between(Date arg1, Date arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - datearg2- - date- Returns:
- conditional predicate
-
between
public Predicate between(PredicateOperand arg1, Calendar arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - PredicateOperand instance or parameterarg2- - calendar- Returns:
- conditional predicate
-
between
public Predicate between(Calendar arg1, PredicateOperand arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - calendararg2- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
between
public Predicate between(Calendar arg1, Calendar arg2)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand lies between (inclusive) the two arguments.- Specified by:
betweenin interfacePredicateOperand- Parameters:
arg1- - calendararg2- - calendar- Returns:
- conditional predicate
-
equal
public Predicate equal(PredicateOperand arg)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
arg- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
equal
public Predicate equal(Class cls)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
cls- - entity class- Returns:
- conditional predicate
-
equal
public Predicate equal(Number arg)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
arg- - numeric- Returns:
- conditional predicate
-
equal
public Predicate equal(String arg)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
arg- - string value- Returns:
- conditional predicate
-
equal
public Predicate equal(boolean arg)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
arg- - boolean value- Returns:
- conditional predicate
-
equal
public Predicate equal(Date arg)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
arg- - date- Returns:
- conditional predicate
-
equal
public Predicate equal(Calendar arg)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
arg- - calendar- Returns:
- conditional predicate
-
equal
public Predicate equal(Enum<?> e)
Description copied from interface:PredicateOperandCreate a predicate for testing equality with the specified argument.- Specified by:
equalin interfacePredicateOperand- Parameters:
e- - enum- Returns:
- conditional predicate
-
greaterEqual
public Predicate greaterEqual(PredicateOperand arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than or equal to the argument.- Specified by:
greaterEqualin interfacePredicateOperand- Parameters:
arg- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
greaterEqual
public Predicate greaterEqual(Number arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than or equal to the argument.- Specified by:
greaterEqualin interfacePredicateOperand- Parameters:
arg- - numeric- Returns:
- conditional predicate
-
greaterEqual
public Predicate greaterEqual(String arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than or equal to the argument.- Specified by:
greaterEqualin interfacePredicateOperand- Parameters:
arg- - string- Returns:
- conditional predicate
-
greaterEqual
public Predicate greaterEqual(Date arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than or equal to the argument.- Specified by:
greaterEqualin interfacePredicateOperand- Parameters:
arg- - date- Returns:
- conditional predicate
-
greaterEqual
public Predicate greaterEqual(Calendar arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than or equal to the argument.- Specified by:
greaterEqualin interfacePredicateOperand- Parameters:
arg- - calendar- Returns:
- conditional predicate
-
greaterThan
public Predicate greaterThan(PredicateOperand arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than the argument.- Specified by:
greaterThanin interfacePredicateOperand- Parameters:
arg- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
greaterThan
public Predicate greaterThan(Number arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than the argument.- Specified by:
greaterThanin interfacePredicateOperand- Parameters:
arg- - numeric- Returns:
- conditional predicate
-
greaterThan
public Predicate greaterThan(String arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than the argument.- Specified by:
greaterThanin interfacePredicateOperand- Parameters:
arg- - string- Returns:
- conditional predicate
-
greaterThan
public Predicate greaterThan(Date arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than the argument.- Specified by:
greaterThanin interfacePredicateOperand- Parameters:
arg- - date- Returns:
- conditional predicate
-
greaterThan
public Predicate greaterThan(Calendar arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is greater than the argument.- Specified by:
greaterThanin interfacePredicateOperand- Parameters:
arg- - calendar- Returns:
- conditional predicate
-
lessEqual
public Predicate lessEqual(PredicateOperand arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than or equal to the argument.- Specified by:
lessEqualin interfacePredicateOperand- Parameters:
arg- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
lessEqual
public Predicate lessEqual(Number arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than or equal to the argument.- Specified by:
lessEqualin interfacePredicateOperand- Parameters:
arg- - numeric- Returns:
- conditional predicate
-
lessEqual
public Predicate lessEqual(String arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than or equal to the argument.- Specified by:
lessEqualin interfacePredicateOperand- Parameters:
arg- - string- Returns:
- conditional predicate
-
lessEqual
public Predicate lessEqual(Date arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than or equal to the argument.- Specified by:
lessEqualin interfacePredicateOperand- Parameters:
arg- - date- Returns:
- conditional predicate
-
lessEqual
public Predicate lessEqual(Calendar arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than or equal to the argument.- Specified by:
lessEqualin interfacePredicateOperand- Parameters:
arg- - calendar- Returns:
- conditional predicate
-
lessThan
public Predicate lessThan(PredicateOperand arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than the argument.- Specified by:
lessThanin interfacePredicateOperand- Parameters:
arg- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
lessThan
public Predicate lessThan(Number arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than the argument.- Specified by:
lessThanin interfacePredicateOperand- Parameters:
arg- - numeric- Returns:
- conditional predicate
-
lessThan
public Predicate lessThan(String arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than the argument.- Specified by:
lessThanin interfacePredicateOperand- Parameters:
arg- - string- Returns:
- conditional predicate
-
lessThan
public Predicate lessThan(Date arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than the argument.- Specified by:
lessThanin interfacePredicateOperand- Parameters:
arg- - date- Returns:
- conditional predicate
-
lessThan
public Predicate lessThan(Calendar arg)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand is less than the argument.- Specified by:
lessThanin interfacePredicateOperand- Parameters:
arg- - calendar- Returns:
- conditional predicate
-
like
public Predicate like(PredicateOperand pattern)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand satisfies the given pattern.- Specified by:
likein interfacePredicateOperand- Returns:
- conditional predicate
-
like
public Predicate like(PredicateOperand pattern, PredicateOperand escChar)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand satisfies the given pattern.- Specified by:
likein interfacePredicateOperand- Returns:
- conditional predicate
-
like
public Predicate like(PredicateOperand pattern, char escapeChar)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand satisfies the given pattern.- Specified by:
likein interfacePredicateOperand- Returns:
- conditional predicate
-
like
public Predicate like(String pattern)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand satisfies the given pattern.- Specified by:
likein interfacePredicateOperand- Returns:
- conditional predicate
-
like
public Predicate like(String pattern, PredicateOperand escapeChar)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand satisfies the given pattern.- Specified by:
likein interfacePredicateOperand- Returns:
- conditional predicate
-
like
public Predicate like(String pattern, char escChar)
Description copied from interface:PredicateOperandCreate a predicate for testing whether the PredicateOperand satisfies the given pattern.- Specified by:
likein interfacePredicateOperand- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(PredicateOperand arg)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
arg- - PredicateOperand instance or parameter- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(Class cls)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
cls- - entity class- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(Number arg)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
arg- - numberic value- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(String arg)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
arg- - string value- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(boolean arg)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
arg- - boolean value- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(Date arg)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
arg- - date- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(Calendar arg)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
arg- - calendar- Returns:
- conditional predicate
-
notEqual
public Predicate notEqual(Enum<?> e)
Description copied from interface:PredicateOperandCreate a predicate for testing inequality with the specified argument.- Specified by:
notEqualin interfacePredicateOperand- Parameters:
e- - enum- Returns:
- conditional predicate
-
getAliasHint
public String getAliasHint(org.apache.openjpa.persistence.query.AliasContext ctx)
Description copied from interface:VisitableGets the hint to be used while creating alias.- Specified by:
getAliasHintin interfaceVisitable
-
asJoinable
public String asJoinable(org.apache.openjpa.persistence.query.AliasContext ctx)
Description copied from interface:VisitableGets the string representation in FROM clause.- Specified by:
asJoinablein interfaceVisitable
-
-