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
All Methods Static Methods Instance Methods Concrete Methods 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 Detail
-
x
public static Expression x(String value)
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
public static Expression x(int value)
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
public static Expression x(long value)
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
public static Expression x(boolean value)
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
public static Expression x(double value)
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
public static Expression x(float value)
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
public static Expression x(JsonArray value)
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
public static Expression x(JsonObject value)
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
public static Expression x(Statement statement)
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
public static Expression x(Number number)
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
public static Expression sub(Statement statement)
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
public static Expression par(Expression expression)
Puts anExpression
in parenthesis.- Parameters:
expression
- the expression to wrap in parenthesis.- Returns:
- the expression, wrapped in parenthesis.
-
path
public static Expression path(Object... pathComponents)
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
public static Expression i(String... identifiers)
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
public static Expression s(String... strings)
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
public static Expression TRUE()
Returns an expression representing boolean TRUE.- Returns:
- an expression representing TRUE.
-
FALSE
public static Expression FALSE()
Returns an expression representing boolean FALSE.- Returns:
- an expression representing FALSE.
-
NULL
public static Expression NULL()
Returns an expression representing NULL.- Returns:
- an expression representing NULL.
-
MISSING
public static Expression MISSING()
Returns an expression representing MISSING.- Returns:
- an expression representing MISSING.
-
not
public Expression not()
Negates the given expression by prefixing a NOT.- Returns:
- the negated expression.
-
and
public Expression and(Expression right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(String right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(int right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(long right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(float right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(double right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(boolean right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(JsonObject right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
and
public Expression and(JsonArray right)
AND-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(Expression right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(String right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(int right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(long right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(boolean right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(float right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(double right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(JsonArray right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
or
public Expression or(JsonObject right)
OR-combines two expressions.- Parameters:
right
- the expression to combine with the current one.- Returns:
- a combined expression.
-
eq
public Expression eq(Expression right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(String right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(int right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(long right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(float right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(double right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(boolean right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(JsonArray right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
eq
public Expression eq(JsonObject right)
Combines two expressions with the equals operator ("=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(Expression right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(String right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(int right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(long right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(double right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(float right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(JsonObject right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
ne
public Expression ne(JsonArray right)
Combines two expressions with the not equals operator ("!=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(Expression right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(String right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(int right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(long right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(float right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(double right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(boolean right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(JsonArray right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gt
public Expression gt(JsonObject right)
Combines two expressions with the greater than operator (">").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(Expression right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(String right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(int right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(long right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(double right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(float right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(boolean right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(JsonObject right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lt
public Expression lt(JsonArray right)
Combines two expressions with the less than operator ("<").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(Expression right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(String right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(int right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(long right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(double right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(float right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(boolean right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(JsonObject right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
gte
public Expression gte(JsonArray right)
Combines two expressions with the greater or equals than operator (">=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(Expression right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(String right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(int right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(long right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(boolean right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(float right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(double right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(JsonObject right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
concat
public Expression concat(JsonArray right)
Combines two expressions with the concatenation operator ("||").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(Expression right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(String right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(int right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(long right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(float right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(double right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(boolean right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(JsonObject right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
lte
public Expression lte(JsonArray right)
Combines two expressions with the less or equals than operator ("<=").- Parameters:
right
- the expression to combine.- Returns:
- the combined expressions.
-
isValued
public Expression isValued()
Appends a "IS VALUED" to the expression.- Returns:
- the postfixed expression.
-
isNotValued
public Expression isNotValued()
Appends a "IS NOT VALUED" to the expression.- Returns:
- the postfixed expression.
-
isNull
public Expression isNull()
Appends a "IS NULL" to the expression.- Returns:
- the postfixed expression.
-
isNotNull
public Expression isNotNull()
Appends a "IS NOT NULL" to the expression.- Returns:
- the postfixed expression.
-
isMissing
public Expression isMissing()
Appends a "IS MISSING" to the expression.- Returns:
- the postfixed expression.
-
isNotMissing
public Expression isNotMissing()
Appends a "IS NOT MISSING" to the expression.- Returns:
- the postfixed expression.
-
between
public Expression between(Expression right)
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
public Expression between(String right)
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
public Expression between(int right)
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
public Expression between(long right)
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
public Expression between(double right)
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
public Expression between(float right)
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
public Expression between(boolean right)
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
public Expression between(JsonObject right)
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
public Expression between(JsonArray right)
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
public Expression notBetween(Expression right)
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
public Expression notBetween(String right)
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
public Expression notBetween(int right)
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
public Expression notBetween(long right)
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
public Expression notBetween(double right)
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
public Expression notBetween(float right)
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
public Expression notBetween(boolean right)
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
public Expression notBetween(JsonObject right)
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
public Expression notBetween(JsonArray right)
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
public Expression like(Expression right)
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
public Expression like(String right)
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
public Expression like(int right)
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
public Expression like(long right)
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
public Expression like(boolean right)
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
public Expression like(double right)
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
public Expression like(float right)
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
public Expression like(JsonObject right)
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
public Expression like(JsonArray right)
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
public Expression notLike(Expression right)
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
public Expression notLike(String right)
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
public Expression notLike(int right)
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
public Expression notLike(long right)
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
public Expression notLike(boolean right)
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
public Expression notLike(float right)
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
public Expression notLike(double right)
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
public Expression notLike(JsonObject right)
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
public Expression notLike(JsonArray right)
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
public Expression exists()
Prefixes the current expression with the EXISTS clause.- Returns:
- a new expression with the clause applied.
-
in
public Expression in(Expression right)
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
public Expression in(String right)
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
public Expression in(int right)
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
public Expression in(long right)
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
public Expression in(boolean right)
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
public Expression in(double right)
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
public Expression in(float right)
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
public Expression in(JsonObject right)
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
public Expression in(JsonArray right)
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
public Expression notIn(Expression right)
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
public Expression notIn(String right)
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
public Expression notIn(int right)
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
public Expression notIn(long right)
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
public Expression notIn(boolean right)
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
public Expression notIn(float right)
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
public Expression notIn(double right)
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
public Expression notIn(JsonObject right)
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
public Expression notIn(JsonArray right)
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
public Expression as(String alias)
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
public Expression as(Expression alias)
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
public Expression add(Expression expression)
Arithmetic addition between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the addition expression.
-
add
public Expression add(Number b)
Arithmetic addition between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the addition expression.
-
add
public Expression add(String expression)
Arithmetic addition between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the addition expression.
-
subtract
public Expression subtract(Expression expression)
Arithmetic v between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the subtraction expression.
-
subtract
public Expression subtract(Number b)
Arithmetic subtraction between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the subtraction expression.
-
subtract
public Expression subtract(String expression)
Arithmetic subtraction between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the subtraction expression.
-
multiply
public Expression multiply(Expression expression)
Arithmetic multiplication between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the multiplication expression.
-
multiply
public Expression multiply(Number b)
Arithmetic multiplication between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the multiplication expression.
-
multiply
public Expression multiply(String expression)
Arithmetic multiplication between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the multiplication expression.
-
divide
public Expression divide(Expression expression)
Arithmetic division between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the division expression.
-
divide
public Expression divide(Number b)
Arithmetic division between current expression and a given number.- Parameters:
b
- the right hand side number.- Returns:
- the division expression.
-
divide
public Expression divide(String expression)
Arithmetic division between current and given expression.- Parameters:
expression
- the right hand side expression.- Returns:
- the division expression.
-
get
public Expression get(String expression)
Get attribute of an object using the given string as attribute name.- Parameters:
expression
- The attribute name- Returns:
- the getter expression
-
get
public Expression get(Expression expression)
Get attribute of an object using the given expression as attribute name.- Parameters:
expression
- The attribute name- Returns:
- the getter expression
-
-