Package com.exasol.sql.expression

Class BooleanTerm

java.lang.Object

com.exasol.sql.expression.AbstractBooleanExpression

com.exasol.sql.expression.BooleanTerm

All Implemented Interfaces:

BooleanExpression, ValueExpression

public abstract class BooleanTerm
extends AbstractBooleanExpression

Method Summary

Modifier and Type	Method	Description
static BooleanExpression	and(boolean... values)
static BooleanExpression	and(boolean value, BooleanExpression expression)
static BooleanExpression	and(BooleanExpression... expressions)
static BooleanExpression	and(BooleanExpression expression, boolean value)
static BooleanExpression	between(ValueExpression expression, ValueExpression start, ValueExpression end)
static BooleanExpression	compare(ValueExpression left, SimpleComparisonOperator operator, ValueExpression right)
static BooleanExpression	compare(ValueExpression left, String operatorSymbol, ValueExpression right)
static BooleanExpression	eq(ValueExpression left, ValueExpression right)
static BooleanExpression	exists(Select select)
static BooleanExpression	ge(ValueExpression left, ValueExpression right)
static BooleanExpression	gt(ValueExpression left, ValueExpression right)
static BooleanExpression	in(ValueExpression operand, Select select)
static BooleanExpression	in(ValueExpression operand, ValueExpression... operands)
static BooleanExpression	isNotNull(ValueExpression operand)
static BooleanExpression	isNull(ValueExpression operand)
static BooleanExpression	le(ValueExpression left, ValueExpression right)
static BooleanExpression	like(ValueExpression left, ValueExpression right)
static BooleanExpression	like(ValueExpression left, ValueExpression right, char escape)
static BooleanExpression	lt(ValueExpression left, ValueExpression right)
static BooleanExpression	ne(ValueExpression left, ValueExpression right)
static BooleanExpression	not(boolean value)
static BooleanExpression	not(BooleanExpression expression)
static BooleanExpression	notBetween(ValueExpression expression, ValueExpression start, ValueExpression end)
static BooleanExpression	notIn(ValueExpression operand, Select select)
static BooleanExpression	notIn(ValueExpression operand, ValueExpression... operands)
static BooleanExpression	notLike(ValueExpression left, ValueExpression right)
static BooleanExpression	notLike(ValueExpression left, ValueExpression right, char escape)
static BooleanExpression	operation(String operator, BooleanExpression... expressions)	Create a logical operation from an operator name and a list of operands
static BooleanExpression	or(boolean... values)
static BooleanExpression	or(boolean value, BooleanExpression expression)
static BooleanExpression	or(BooleanExpression... expressions)
static BooleanExpression	or(BooleanExpression expression, boolean value)

Methods inherited from class com.exasol.sql.expression.AbstractBooleanExpression

accept

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.exasol.sql.expression.BooleanExpression

accept

Method Detail

not

public static BooleanExpression not(boolean value)

not

public static BooleanExpression not(BooleanExpression expression)

and

public static BooleanExpression and(boolean... values)

and

public static BooleanExpression and(BooleanExpression expression,
                                    boolean value)

and

public static BooleanExpression and(boolean value,
                                    BooleanExpression expression)

and

public static BooleanExpression and(BooleanExpression... expressions)

or

public static BooleanExpression or(boolean... values)

or

public static BooleanExpression or(BooleanExpression expression,
                                   boolean value)

or

public static BooleanExpression or(boolean value,
                                   BooleanExpression expression)

or

public static BooleanExpression or(BooleanExpression... expressions)

like

public static BooleanExpression like(ValueExpression left,
                                     ValueExpression right)

like

public static BooleanExpression like(ValueExpression left,
                                     ValueExpression right,
                                     char escape)

notLike

public static BooleanExpression notLike(ValueExpression left,
                                        ValueExpression right)

notLike

public static BooleanExpression notLike(ValueExpression left,
                                        ValueExpression right,
                                        char escape)

compare

public static BooleanExpression compare(ValueExpression left,
                                        String operatorSymbol,
                                        ValueExpression right)

compare

public static BooleanExpression compare(ValueExpression left,
                                        SimpleComparisonOperator operator,
                                        ValueExpression right)

eq

public static BooleanExpression eq(ValueExpression left,
                                   ValueExpression right)

ne

public static BooleanExpression ne(ValueExpression left,
                                   ValueExpression right)

lt

public static BooleanExpression lt(ValueExpression left,
                                   ValueExpression right)

gt

public static BooleanExpression gt(ValueExpression left,
                                   ValueExpression right)

le

public static BooleanExpression le(ValueExpression left,
                                   ValueExpression right)

ge

public static BooleanExpression ge(ValueExpression left,
                                   ValueExpression right)

isNull

public static BooleanExpression isNull(ValueExpression operand)

isNotNull

public static BooleanExpression isNotNull(ValueExpression operand)

in

public static BooleanExpression in(ValueExpression operand,
                                   ValueExpression... operands)

notIn

public static BooleanExpression notIn(ValueExpression operand,
                                      ValueExpression... operands)

in

public static BooleanExpression in(ValueExpression operand,
                                   Select select)

notIn

public static BooleanExpression notIn(ValueExpression operand,
                                      Select select)

exists

public static BooleanExpression exists(Select select)

between

public static BooleanExpression between(ValueExpression expression,
                                        ValueExpression start,
                                        ValueExpression end)

notBetween

public static BooleanExpression notBetween(ValueExpression expression,
                                           ValueExpression start,
                                           ValueExpression end)

operation

public static BooleanExpression operation(String operator,
                                          BooleanExpression... expressions)

Create a logical operation from an operator name and a list of operands

Parameters:

operator - name of the operator

expressions - operands

Returns:

instance of either And, Or or Not

Throws:

IllegalArgumentException - if the operator is unknown or null