Class Expression
java.lang.Object
com.couchbase.client.java.query.dsl.Expression
public class Expression extends Object
Represents a N1QL Expression.
- Since:
- 2.0.0
- Author:
- Michael Nitschinger
-
Method Summary
Modifier and Type Method Description Expression
add(Expression expression)
Arithmetic addition between current and given expression.Expression
add(Number b)
Arithmetic addition between current expression and a given number.Expression
add(String expression)
Arithmetic addition between current and given expression.Expression
and(boolean right)
AND-combines two expressions.Expression
and(double right)
AND-combines two expressions.Expression
and(float right)
AND-combines two expressions.Expression
and(int right)
AND-combines two expressions.Expression
and(long right)
AND-combines two expressions.Expression
and(JsonArray right)
AND-combines two expressions.Expression
and(JsonObject right)
AND-combines two expressions.Expression
and(Expression right)
AND-combines two expressions.Expression
and(String right)
AND-combines two expressions.Expression
as(Expression alias)
Adds a AS clause between the current and the given expression.Expression
as(String alias)
Adds a AS clause between the current and the given expression.Expression
between(boolean right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(double right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(float right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(int right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(long right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(JsonArray right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(JsonObject right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(Expression right)
Adds a BETWEEN clause between the current and the given expression.Expression
between(String right)
Adds a BETWEEN clause between the current and the given expression.Expression
concat(boolean right)
Combines two expressions with the concatenation operator ("||").Expression
concat(double right)
Combines two expressions with the concatenation operator ("||").Expression
concat(float right)
Combines two expressions with the concatenation operator ("||").Expression
concat(int right)
Combines two expressions with the concatenation operator ("||").Expression
concat(long right)
Combines two expressions with the concatenation operator ("||").Expression
concat(JsonArray right)
Combines two expressions with the concatenation operator ("||").Expression
concat(JsonObject right)
Combines two expressions with the concatenation operator ("||").Expression
concat(Expression right)
Combines two expressions with the concatenation operator ("||").Expression
concat(String right)
Combines two expressions with the concatenation operator ("||").Expression
divide(Expression expression)
Arithmetic division between current and given expression.Expression
divide(Number b)
Arithmetic division between current expression and a given number.Expression
divide(String expression)
Arithmetic division between current and given expression.Expression
eq(boolean right)
Combines two expressions with the equals operator ("=").Expression
eq(double right)
Combines two expressions with the equals operator ("=").Expression
eq(float right)
Combines two expressions with the equals operator ("=").Expression
eq(int right)
Combines two expressions with the equals operator ("=").Expression
eq(long right)
Combines two expressions with the equals operator ("=").Expression
eq(JsonArray right)
Combines two expressions with the equals operator ("=").Expression
eq(JsonObject right)
Combines two expressions with the equals operator ("=").Expression
eq(Expression right)
Combines two expressions with the equals operator ("=").Expression
eq(String right)
Combines two expressions with the equals operator ("=").Expression
exists()
Prefixes the current expression with the EXISTS clause.static Expression
FALSE()
Returns an expression representing boolean FALSE.Expression
get(Expression expression)
Get attribute of an object using the given expression as attribute name.Expression
get(String expression)
Get attribute of an object using the given string as attribute name.Expression
gt(boolean right)
Combines two expressions with the greater than operator (">").Expression
gt(double right)
Combines two expressions with the greater than operator (">").Expression
gt(float right)
Combines two expressions with the greater than operator (">").Expression
gt(int right)
Combines two expressions with the greater than operator (">").Expression
gt(long right)
Combines two expressions with the greater than operator (">").Expression
gt(JsonArray right)
Combines two expressions with the greater than operator (">").Expression
gt(JsonObject right)
Combines two expressions with the greater than operator (">").Expression
gt(Expression right)
Combines two expressions with the greater than operator (">").Expression
gt(String right)
Combines two expressions with the greater than operator (">").Expression
gte(boolean right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(double right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(float right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(int right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(long right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(JsonArray right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(JsonObject right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(Expression right)
Combines two expressions with the greater or equals than operator (">=").Expression
gte(String right)
Combines two expressions with the greater or equals than operator (">=").static Expression
i(String... identifiers)
An identifier or list of identifiers escaped using backquotes `.Expression
in(boolean right)
Adds a IN clause between the current and the given expression.Expression
in(double right)
Adds a IN clause between the current and the given expression.Expression
in(float right)
Adds a IN clause between the current and the given expression.Expression
in(int right)
Adds a IN clause between the current and the given expression.Expression
in(long right)
Adds a IN clause between the current and the given expression.Expression
in(JsonArray right)
Adds a IN clause between the current and the given expression.Expression
in(JsonObject right)
Adds a IN clause between the current and the given expression.Expression
in(Expression right)
Adds a IN clause between the current and the given expression.Expression
in(String right)
Adds a IN clause between the current and the given expression.Expression
isMissing()
Appends a "IS MISSING" to the expression.Expression
isNotMissing()
Appends a "IS NOT MISSING" to the expression.Expression
isNotNull()
Appends a "IS NOT NULL" to the expression.Expression
isNotValued()
Appends a "IS NOT VALUED" to the expression.Expression
isNull()
Appends a "IS NULL" to the expression.Expression
isValued()
Appends a "IS VALUED" to the expression.Expression
like(boolean right)
Adds a LIKE clause between the current and the given expression.Expression
like(double right)
Adds a LIKE clause between the current and the given expression.Expression
like(float right)
Adds a LIKE clause between the current and the given expression.Expression
like(int right)
Adds a LIKE clause between the current and the given expression.Expression
like(long right)
Adds a LIKE clause between the current and the given expression.Expression
like(JsonArray right)
Adds a LIKE clause between the current and the given expression.Expression
like(JsonObject right)
Adds a LIKE clause between the current and the given expression.Expression
like(Expression right)
Adds a LIKE clause between the current and the given expression.Expression
like(String right)
Adds a LIKE clause between the current and the given expression.Expression
lt(boolean right)
Combines two expressions with the less than operator ("<").Expression
lt(double right)
Combines two expressions with the less than operator ("<").Expression
lt(float right)
Combines two expressions with the less than operator ("<").Expression
lt(int right)
Combines two expressions with the less than operator ("<").Expression
lt(long right)
Combines two expressions with the less than operator ("<").Expression
lt(JsonArray right)
Combines two expressions with the less than operator ("<").Expression
lt(JsonObject right)
Combines two expressions with the less than operator ("<").Expression
lt(Expression right)
Combines two expressions with the less than operator ("<").Expression
lt(String right)
Combines two expressions with the less than operator ("<").Expression
lte(boolean right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(double right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(float right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(int right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(long right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(JsonArray right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(JsonObject right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(Expression right)
Combines two expressions with the less or equals than operator ("<=").Expression
lte(String right)
Combines two expressions with the less or equals than operator ("<=").static Expression
MISSING()
Returns an expression representing MISSING.Expression
multiply(Expression expression)
Arithmetic multiplication between current and given expression.Expression
multiply(Number b)
Arithmetic multiplication between current expression and a given number.Expression
multiply(String expression)
Arithmetic multiplication between current and given expression.Expression
ne(double right)
Combines two expressions with the not equals operator ("!=").Expression
ne(float right)
Combines two expressions with the not equals operator ("!=").Expression
ne(int right)
Combines two expressions with the not equals operator ("!=").Expression
ne(long right)
Combines two expressions with the not equals operator ("!=").Expression
ne(JsonArray right)
Combines two expressions with the not equals operator ("!=").Expression
ne(JsonObject right)
Combines two expressions with the not equals operator ("!=").Expression
ne(Expression right)
Combines two expressions with the not equals operator ("!=").Expression
ne(String right)
Combines two expressions with the not equals operator ("!=").Expression
not()
Negates the given expression by prefixing a NOT.Expression
notBetween(boolean right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(double right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(float right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(int right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(long right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(JsonArray right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(JsonObject right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(Expression right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notBetween(String right)
Adds a NOT BETWEEN clause between the current and the given expression.Expression
notIn(boolean right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(double right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(float right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(int right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(long right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(JsonArray right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(JsonObject right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(Expression right)
Adds a NOT IN clause between the current and the given expression.Expression
notIn(String right)
Adds a NOT IN clause between the current and the given expression.Expression
notLike(boolean right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(double right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(float right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(int right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(long right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(JsonArray right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(JsonObject right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(Expression right)
Adds a NOT LIKE clause between the current and the given expression.Expression
notLike(String right)
Adds a NOT LIKE clause between the current and the given expression.static Expression
NULL()
Returns an expression representing NULL.Expression
or(boolean right)
OR-combines two expressions.Expression
or(double right)
OR-combines two expressions.Expression
or(float right)
OR-combines two expressions.Expression
or(int right)
OR-combines two expressions.Expression
or(long right)
OR-combines two expressions.Expression
or(JsonArray right)
OR-combines two expressions.Expression
or(JsonObject right)
OR-combines two expressions.Expression
or(Expression right)
OR-combines two expressions.Expression
or(String right)
OR-combines two expressions.static Expression
par(Expression expression)
Puts anExpression
in parenthesis.static Expression
path(Object... pathComponents)
Construct a path ("a.b.c") from Expressions or values.static Expression
s(String... strings)
An identifier or list of identifiers which will be quoted as strings (with "").static Expression
sub(Statement statement)
Creates an expression from a given sub-Statement
, wrapping it in parenthesis.Expression
subtract(Expression expression)
Arithmetic v between current and given expression.Expression
subtract(Number b)
Arithmetic subtraction between current expression and a given number.Expression
subtract(String expression)
Arithmetic subtraction between current and given expression.String
toString()
static Expression
TRUE()
Returns an expression representing boolean TRUE.static Expression
x(boolean value)
Creates an arbitrary expression from the given boolean value.static Expression
x(double value)
Creates an arbitrary expression from the given double value.static Expression
x(float value)
Creates an arbitrary expression from the given float value.static Expression
x(int value)
Creates an arbitrary expression from the given integer value.static Expression
x(long value)
Creates an arbitrary expression from the given long value.static Expression
x(JsonArray value)
Creates an arbitrary expression from the given json array.static Expression
x(JsonObject value)
Creates an arbitrary expression from the given json object.static Expression
x(Statement statement)
Creates an expression for a givenStatement
, as is.static Expression
x(Number number)
Creates an expression from aNumber
, as is.static Expression
x(String value)
Creates an arbitrary expression from the given string value.
-
Method Details
-
x
Creates an arbitrary expression from the given string value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given integer value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given long value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given boolean value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given double value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given float value. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given json array. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an arbitrary expression from the given json object. No quoting or escaping will be done on the input. In addition, it is not checked if the given value is an actual valid (N1QL syntax wise) expression.- Parameters:
value
- the value to create the expression from.- Returns:
- a new
Expression
representing the value.
-
x
Creates an expression for a givenStatement
, as is.- Parameters:
statement
- the statement to convert to an expression.- Returns:
- the statement, converted as is into an expression.
-
x
Creates an expression from aNumber
, as is.- Parameters:
number
- the number constant to convert to an expression.- Returns:
- the number converted into an expression.
-
sub
Creates an expression from a given sub-Statement
, wrapping it in parenthesis.- Parameters:
statement
- the statement to convert to an expression.- Returns:
- the statement, converted into an expression wrapped in parenthesis.
-
par
Puts anExpression
in parenthesis.- Parameters:
expression
- the expression to wrap in parenthesis.- Returns:
- the expression, wrapped in parenthesis.
-
path
Construct a path ("a.b.c") from Expressions or values. Strings are considered identifiers (so they won't be quoted).- Parameters:
pathComponents
- the elements of the path, joined together by a dot.- Returns:
- the path created from the given components.
-
i
An identifier or list of identifiers escaped using backquotes `. Useful for example for identifiers that contains a dash like "beer-sample". Multiple identifiers are returned as a list of escaped identifiers separated by ", ".- Parameters:
identifiers
- the identifier(s) to escape.- Returns:
- an
Expression
representing the escaped identifier.
-
s
An identifier or list of identifiers which will be quoted as strings (with "").- Parameters:
strings
- the list of strings to quote.- Returns:
- an
Expression
representing the quoted strings.
-
TRUE
Returns an expression representing boolean TRUE.- Returns:
- an expression representing TRUE.
-
FALSE
Returns an expression representing boolean FALSE.- Returns:
- an expression representing FALSE.
-
NULL
Returns an expression representing NULL.- Returns:
- an expression representing NULL.
-
MISSING
Returns an expression representing MISSING.- Returns:
- an expression representing MISSING.
-
not
Negates the given expression by prefixing a NOT.- Returns:
- the negated expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
isValued
Appends a "IS VALUED" to the expression.- Returns:
- the postfixed expression.
-
isNotValued
Appends a "IS NOT VALUED" to the expression.- Returns:
- the postfixed expression.
-
isNull
Appends a "IS NULL" to the expression.- Returns:
- the postfixed expression.
-
isNotNull
Appends a "IS NOT NULL" to the expression.- Returns:
- the postfixed expression.
-
isMissing
Appends a "IS MISSING" to the expression.- Returns:
- the postfixed expression.
-
isNotMissing
Appends a "IS NOT MISSING" to the expression.- Returns:
- the postfixed expression.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
between
Adds a BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notBetween
Adds a NOT BETWEEN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
like
Adds a LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notLike
Adds a NOT LIKE clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
exists
Prefixes the current expression with the EXISTS clause.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
in
Adds a IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
notIn
Adds a NOT IN clause between the current and the given expression.- Parameters:
right
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
as
Adds a AS clause between the current and the given expression. Often used to alias an identifier.- Parameters:
alias
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
as
Adds a AS clause between the current and the given expression. Often used to alias an identifier.- Parameters:
alias
- the right hand side expression.- Returns:
- a new expression with the clause applied.
-
add
Arithmetic addition between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the addition expression.
-
add
Arithmetic addition between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the addition expression.
-
add
Arithmetic addition between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the addition expression.
-
subtract
Arithmetic v between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the subtraction expression.
-
subtract
Arithmetic subtraction between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the subtraction expression.
-
subtract
Arithmetic subtraction between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the subtraction expression.
-
multiply
Arithmetic multiplication between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the multiplication expression.
-
multiply
Arithmetic multiplication between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the multiplication expression.
-
multiply
Arithmetic multiplication between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the multiplication expression.
-
divide
Arithmetic division between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the division expression.
-
divide
Arithmetic division between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the division expression.
-
divide
Arithmetic division between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the division expression.
-
get
Get attribute of an object using the given string as attribute name.- Parameters:
expression
- The attribute name- Returns:
- the getter expression
-
get
Get attribute of an object using the given expression as attribute name.- Parameters:
expression
- The attribute name- Returns:
- the getter expression
-
toString
-