Package org.gvsig.expressionevaluator

Interface ExpressionBuilder

All Superinterfaces:

org.gvsig.tools.util.PropertiesSupport

All Known Implementing Classes:

DelegatedExpressionBuilder

public interface ExpressionBuilder
extends org.gvsig.tools.util.PropertiesSupport

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static class	ExpressionBuilder.AbstractValue
static interface	ExpressionBuilder.BinaryOperator
static class	ExpressionBuilder.ClassVisitorFilter
static interface	ExpressionBuilder.Constant
static interface	ExpressionBuilder.Custom
static interface	ExpressionBuilder.Function
static interface	ExpressionBuilder.Group
static interface	ExpressionBuilder.Method
static interface	ExpressionBuilder.Parameter
static interface	ExpressionBuilder.Value
static interface	ExpressionBuilder.Variable
static interface	ExpressionBuilder.Visitable
static interface	ExpressionBuilder.Visitor
static interface	ExpressionBuilder.VisitorFilter

Field Summary

Fields

Modifier and Type	Field	Description
static final Formatter<ExpressionBuilder.Value>	EMPTY_FORMATTER
static final String	FUNCTION_$CONSTANT	Deprecated.
static final String	FUNCTION_$HOSTEXPRESSION
static final String	FUNCTION_$IDENTIFIER	Deprecated.
static final String	FUNCTION_ABS
static final String	FUNCTION_ACOS
static final String	FUNCTION_ASCII
static final String	FUNCTION_ASIN
static final String	FUNCTION_ATAN
static final String	FUNCTION_AVG
static final String	FUNCTION_BITAND
static final String	FUNCTION_BITOR
static final String	FUNCTION_BITXOR
static final String	FUNCTION_CASE
static final String	FUNCTION_CAST
static final String	FUNCTION_CEIL
static final String	FUNCTION_CHR
static final String	FUNCTION_COLOR
static final String	FUNCTION_CONCAT
static final String	FUNCTION_COS
static final String	FUNCTION_COSH
static final String	FUNCTION_COT
static final String	FUNCTION_COUNT
static final String	FUNCTION_CRC32
static final String	FUNCTION_CURRENT_DATE
static final String	FUNCTION_CURRENT_TIME
static final String	FUNCTION_CURRENT_TIMESTAMP
static final String	FUNCTION_DATE
static final String	FUNCTION_DATEADD
static final String	FUNCTION_DATEDIFF
static final String	FUNCTION_DECODE
static final String	FUNCTION_DECR
static final String	FUNCTION_DEGREES
static final String	FUNCTION_DESKTOPBROWSE
static final String	FUNCTION_DESKTOPEDIT
static final String	FUNCTION_DESKTOPOPEN
static final String	FUNCTION_DICT
static final String	FUNCTION_ENCODE
static final String	FUNCTION_EVAL
static final String	FUNCTION_EXP
static final String	FUNCTION_EXTRACT
static final String	FUNCTION_FLOOR
static final String	FUNCTION_GETATTR
static final String	FUNCTION_GETITEM
static final String	FUNCTION_IF
static final String	FUNCTION_IFNULL
static final String	FUNCTION_IIF
static final String	FUNCTION_INCR
static final String	FUNCTION_INSTR
static final String	FUNCTION_JSON_VALUE
static final String	FUNCTION_LEFT
static final String	FUNCTION_LENGHT
static final String	FUNCTION_LET
static final String	FUNCTION_LIST
static final String	FUNCTION_LOCATE
static final String	FUNCTION_LOG
static final String	FUNCTION_LOG10
static final String	FUNCTION_LOWER
static final String	FUNCTION_LPAD
static final String	FUNCTION_LTRIM
static final String	FUNCTION_MAP
static final String	FUNCTION_MAX
static final String	FUNCTION_MD5HEX
static final String	FUNCTION_MIN
static final String	FUNCTION_MOD
static final String	FUNCTION_PI
static final String	FUNCTION_POSITION
static final String	FUNCTION_POWER
static final String	FUNCTION_RADIANS
static final String	FUNCTION_RAND
static final String	FUNCTION_RANGE
static final String	FUNCTION_REPEAT
static final String	FUNCTION_REPLACE
static final String	FUNCTION_REVERSEINSTR
static final String	FUNCTION_RIGHT
static final String	FUNCTION_ROUND
static final String	FUNCTION_RPAD
static final String	FUNCTION_RTRIM
static final String	FUNCTION_SETATTR
static final String	FUNCTION_SIGN
static final String	FUNCTION_SIN
static final String	FUNCTION_SINH
static final String	FUNCTION_SPACE
static final String	FUNCTION_SQRT
static final String	FUNCTION_SUBSTRING
static final String	FUNCTION_SUM
static final String	FUNCTION_TAN
static final String	FUNCTION_TANH
static final String	FUNCTION_TIME
static final String	FUNCTION_TIMESTAMP
static final String	FUNCTION_TO_DATE
static final String	FUNCTION_TO_TIMESTAMP
static final String	FUNCTION_TODOUBLE
static final String	FUNCTION_TOFLOAT
static final String	FUNCTION_TOINTEGER
static final String	FUNCTION_TOJSON
static final String	FUNCTION_TOLONG
static final String	FUNCTION_TOSTR
static final String	FUNCTION_TRIM
static final String	FUNCTION_TUPLE
static final String	FUNCTION_UPPER
static final String	FUNCTION_URL
static final String	FUNCTION_URLREAD
static final String	FUNCTION_URLREADBYTES
static final String	FUNCTION_UUID
static final String	FUNCTION_ZERO
static final String	OPERATOR_ADD
static final String	OPERATOR_AND
static final String	OPERATOR_AND2
static final String	OPERATOR_BETWEEN
static final String	OPERATOR_CONCAT
static final String	OPERATOR_DIV
static final String	OPERATOR_EQ
static final String	OPERATOR_GE
static final String	OPERATOR_GT
static final String	OPERATOR_ILIKE
static final String	OPERATOR_IN
static final String	OPERATOR_IS
static final String	OPERATOR_IS_NOT_NULL
static final String	OPERATOR_IS_NULL
static final String	OPERATOR_LE
static final String	OPERATOR_LIKE
static final String	OPERATOR_LT
static final String	OPERATOR_MOD
static final String	OPERATOR_MULT
static final String	OPERATOR_NE
static final String	OPERATOR_NEGATE
static final String	OPERATOR_NOT
static final String	OPERATOR_OR
static final String	OPERATOR_REGEXP
static final String	OPERATOR_SUBST
static final int	PARAMETER_TYPE_CONSTANT
static final int	PARAMETER_TYPE_VARIABLE
static final ExpressionBuilder.Constant	VALUE_NULL

Method Summary

Modifier and Type	Method	Description
ExpressionBuilder.Function	abs(ExpressionBuilder.Value num)
void	accept(ExpressionBuilder.Visitor visitor, ExpressionBuilder.VisitorFilter filter)
ExpressionBuilder.Function	acos(ExpressionBuilder.Value num)
ExpressionBuilder.BinaryOperator	add(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder	and(ExpressionBuilder.Value value)
ExpressionBuilder.BinaryOperator	and(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.BinaryOperator	and(Expression op1, Expression op2)
ExpressionBuilder.BinaryOperator	and(Expression op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	ascii(ExpressionBuilder.Value str)
ExpressionBuilder.Function	asin(ExpressionBuilder.Value num)
ExpressionBuilder.Function	atan(ExpressionBuilder.Value num)
ExpressionBuilder.BinaryOperator	binaryOperator(String name, ExpressionBuilder.Value leftOperand, ExpressionBuilder.Value rightOperand)
ExpressionBuilder.Function	bitand(ExpressionBuilder.Value num1, ExpressionBuilder.Value num2)
ExpressionBuilder.Function	bitor(ExpressionBuilder.Value num1, ExpressionBuilder.Value num2)
ExpressionBuilder.Function	bitxor(ExpressionBuilder.Value num1, ExpressionBuilder.Value num2)
String	build()
String	build(Formatter<ExpressionBuilder.Value> formatter)
ExpressionBuilder.Constant	bytearray(byte[] data)
String	bytearray_0x(byte[] data)
String	bytearray_hex(byte[] data)
String	bytearray_x(byte[] data)
ExpressionBuilder.Function	cast(ExpressionBuilder.Value object, int type)
ExpressionBuilder.Function	cast(ExpressionBuilder.Value object, ExpressionBuilder.Value typeName)
ExpressionBuilder.Function	ceil(ExpressionBuilder.Value num)
ExpressionBuilder.Function	chr(ExpressionBuilder.Value num)
ExpressionBuilder.Function	color(Color color)
ExpressionBuilder.Function	color(ExpressionBuilder.Value red, ExpressionBuilder.Value green, ExpressionBuilder.Value blue, ExpressionBuilder.Value alfa)
ExpressionBuilder.Variable	column(String name)
ExpressionBuilder.Value	column(String tableName, String columnName)
ExpressionBuilder.Function	concat(ExpressionBuilder.Value... values)
ExpressionBuilder.Constant	constant(Object value)
ExpressionBuilder.Constant	constant(Object value, int type)
ExpressionBuilder.Constant	constant(Object value, Class theClass)
ExpressionBuilder.Function	cos(ExpressionBuilder.Value num)
ExpressionBuilder.Function	cosh(ExpressionBuilder.Value num)
ExpressionBuilder.Function	cot(ExpressionBuilder.Value num)
ExpressionBuilder	createExpressionBuilder()
ExpressionBuilder.Function	current_date()
ExpressionBuilder.Function	current_time()
ExpressionBuilder.Function	current_timestamp()
ExpressionBuilder.Custom	custom(Object value)
ExpressionBuilder.Function	date(String date)
ExpressionBuilder.Function	date(Date date)
ExpressionBuilder.Function	date(ExpressionBuilder.Value date)
ExpressionBuilder.Function	date_add(ExpressionBuilder.Value datefield, ExpressionBuilder.Value valueToAdd, ExpressionBuilder.Value date)
ExpressionBuilder.Function	date_diff(ExpressionBuilder.Value datefield, ExpressionBuilder.Value valueToSubst, ExpressionBuilder.Value date)
ExpressionBuilder.Function	decode(ExpressionBuilder.Value value, ExpressionBuilder.Value format)
ExpressionBuilder.Function	degrees(ExpressionBuilder.Value num)
ExpressionBuilder.BinaryOperator	div(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.BinaryOperator	eq(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	exp(ExpressionBuilder.Value num)
ExpressionBuilder.Function	extract(ExpressionBuilder.Value datefield, ExpressionBuilder.Value source)
ExpressionBuilder.Function	floor(ExpressionBuilder.Value num)
Formatter<ExpressionBuilder.Value>	formatter()
ExpressionBuilder.Function	function(String name, ExpressionBuilder.Value... values)
ExpressionBuilder.BinaryOperator	ge(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	getattr(String objectId, String attributeId)
ExpressionBuilder.Group	group(ExpressionBuilder.Value group)
ExpressionBuilder.BinaryOperator	gt(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	hostexpression(ExpressionBuilder.Value expression)
String	identifier(String name)
ExpressionBuilder.Function	ifnull(ExpressionBuilder.Value value, ExpressionBuilder.Value iftrue, ExpressionBuilder.Value iffalse)
ExpressionBuilder.Function	iif(ExpressionBuilder.Value condition, ExpressionBuilder.Value iftrue, ExpressionBuilder.Value iffalse)
ExpressionBuilder.BinaryOperator	ilike(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	instr(ExpressionBuilder.Value str, ExpressionBuilder.Value search, ExpressionBuilder.Value start)
ExpressionBuilder.Function	is_null(ExpressionBuilder.Value value)
boolean	isEmpty()
static boolean	isFunction(ExpressionBuilder.Value value, String name)
ExpressionBuilder.BinaryOperator	le(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	left(ExpressionBuilder.Value str, ExpressionBuilder.Value size)
ExpressionBuilder.Function	lenght(ExpressionBuilder.Value str)
ExpressionBuilder.Function	let(String name, ExpressionBuilder.Value value)
ExpressionBuilder.BinaryOperator	like(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	list()
ExpressionBuilder.Function	locate(ExpressionBuilder.Value search, ExpressionBuilder.Value str, ExpressionBuilder.Value start)
ExpressionBuilder.Function	log(ExpressionBuilder.Value num)
ExpressionBuilder.Function	log10(ExpressionBuilder.Value num)
ExpressionBuilder.Function	lower(ExpressionBuilder.Value str)
ExpressionBuilder.Function	lpad(ExpressionBuilder.Value str, ExpressionBuilder.Value len, ExpressionBuilder.Value padstr)
ExpressionBuilder.BinaryOperator	lt(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	ltrim(ExpressionBuilder.Value str)
ExpressionBuilder.Method	method(ExpressionBuilder.Value instance, String name, ExpressionBuilder.Value... values)
ExpressionBuilder.BinaryOperator	mult(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.BinaryOperator	ne(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	not(ExpressionBuilder.Value value)
ExpressionBuilder.Function	not_is_null(ExpressionBuilder.Value value)
ExpressionBuilder	or(ExpressionBuilder.Value value)
ExpressionBuilder.BinaryOperator	or(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Parameter	parameter()
ExpressionBuilder.Parameter	parameter(String name)
List<ExpressionBuilder.Parameter>	parameters()
List<String>	parameters_names()
ExpressionBuilder.Function	pi()
ExpressionBuilder.Function	position(ExpressionBuilder.Value search, ExpressionBuilder.Value str)
ExpressionBuilder.Function	power(ExpressionBuilder.Value num)
String	quote_for_identifiers()
String	quote_for_strings()
ExpressionBuilder.Function	radians(ExpressionBuilder.Value num)
ExpressionBuilder.Function	rand(ExpressionBuilder.Value num)
ExpressionBuilder.Function	repeat(ExpressionBuilder.Value str, ExpressionBuilder.Value size)
ExpressionBuilder.Function	replace(ExpressionBuilder.Value str, ExpressionBuilder.Value search, ExpressionBuilder.Value replstr)
String	repr(Object value)
ExpressionBuilder.Function	right(ExpressionBuilder.Value str, ExpressionBuilder.Value len)
ExpressionBuilder.Function	round(ExpressionBuilder.Value num)
ExpressionBuilder.Function	rpad(ExpressionBuilder.Value str, ExpressionBuilder.Value len, ExpressionBuilder.Value padstr)
ExpressionBuilder.Function	rtrim(ExpressionBuilder.Value str)
ExpressionBuilder	set(ExpressionBuilder.Value value)
void	setProperties(Class filter, Object... values)
ExpressionBuilder.Function	sign(ExpressionBuilder.Value num)
ExpressionBuilder.Function	sin(ExpressionBuilder.Value num)
ExpressionBuilder.Function	sinh(ExpressionBuilder.Value num)
ExpressionBuilder.Function	space(ExpressionBuilder.Value size)
ExpressionBuilder.Function	sqrt(ExpressionBuilder.Value num)
String	string(String s)
ExpressionBuilder.BinaryOperator	subst(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	substring(ExpressionBuilder.Value str, ExpressionBuilder.Value start, ExpressionBuilder.Value len)
ExpressionBuilder.Function	tan(ExpressionBuilder.Value num)
ExpressionBuilder.Function	tanh(ExpressionBuilder.Value num)
ExpressionBuilder.Function	time(String time)
ExpressionBuilder.Function	time(Date time)
ExpressionBuilder.Function	time(ExpressionBuilder.Value date)
ExpressionBuilder.Function	timestamp(String timestamp)
ExpressionBuilder.Function	timestamp(Date timestamp)
ExpressionBuilder.Function	timestamp(ExpressionBuilder.Value date)
ExpressionBuilder.Function	to_date(ExpressionBuilder.Value date, ExpressionBuilder.Value format)
ExpressionBuilder.Function	to_timestamp(ExpressionBuilder.Value timestamp, ExpressionBuilder.Value format)
ExpressionBuilder.Function	toDouble(ExpressionBuilder.Value object)
ExpressionBuilder.Function	toFloat(ExpressionBuilder.Value object)
ExpressionBuilder.Function	toInteger(ExpressionBuilder.Value object)
ExpressionBuilder.Function	toLong(ExpressionBuilder.Value object)
ExpressionBuilder.Function	toStr(ExpressionBuilder.Value object)
String	toString(Formatter<ExpressionBuilder.Value> formatter)
ExpressionBuilder.Value	toValue(String expression)
ExpressionBuilder.Function	trim(ExpressionBuilder.Value str)
ExpressionBuilder.Function	tuple()
ExpressionBuilder.Function	tuple(Object... values)
ExpressionBuilder.Function	upper(ExpressionBuilder.Value str)
ExpressionBuilder.Value	value()
ExpressionBuilder	value(ExpressionBuilder.Value value)
ExpressionBuilder.Variable	variable(String name)
List<ExpressionBuilder.Variable>	variables()
List<String>	variables_names()
ExpressionBuilder.Function	zero()

Methods inherited from interface org.gvsig.tools.util.PropertiesSupport

getProperties, getProperty, setProperty

Field Details

OPERATOR_NOT

static final String OPERATOR_NOT

See Also:

• Constant Field Values

OPERATOR_NEGATE

static final String OPERATOR_NEGATE

See Also:

• Constant Field Values

OPERATOR_IS

static final String OPERATOR_IS

See Also:

• Constant Field Values

OPERATOR_IS_NULL

static final String OPERATOR_IS_NULL

See Also:

• Constant Field Values

OPERATOR_IS_NOT_NULL

static final String OPERATOR_IS_NOT_NULL

See Also:

• Constant Field Values

OPERATOR_AND

static final String OPERATOR_AND

See Also:

• Constant Field Values

OPERATOR_OR

static final String OPERATOR_OR

See Also:

• Constant Field Values

OPERATOR_EQ

static final String OPERATOR_EQ

See Also:

• Constant Field Values

OPERATOR_NE

static final String OPERATOR_NE

See Also:

• Constant Field Values

OPERATOR_GT

static final String OPERATOR_GT

See Also:

• Constant Field Values

OPERATOR_GE

static final String OPERATOR_GE

See Also:

• Constant Field Values

OPERATOR_LT

static final String OPERATOR_LT

See Also:

• Constant Field Values

OPERATOR_LE

static final String OPERATOR_LE

See Also:

• Constant Field Values

OPERATOR_LIKE

static final String OPERATOR_LIKE

See Also:

• Constant Field Values

OPERATOR_ILIKE

static final String OPERATOR_ILIKE

See Also:

• Constant Field Values

OPERATOR_ADD

static final String OPERATOR_ADD

See Also:

• Constant Field Values

OPERATOR_SUBST

static final String OPERATOR_SUBST

See Also:

• Constant Field Values

OPERATOR_MULT

static final String OPERATOR_MULT

See Also:

• Constant Field Values

OPERATOR_DIV

static final String OPERATOR_DIV

See Also:

• Constant Field Values

OPERATOR_MOD

static final String OPERATOR_MOD

See Also:

• Constant Field Values

OPERATOR_CONCAT

static final String OPERATOR_CONCAT

See Also:

• Constant Field Values

OPERATOR_REGEXP

static final String OPERATOR_REGEXP

See Also:

• Constant Field Values

OPERATOR_AND2

static final String OPERATOR_AND2

See Also:

• Constant Field Values

OPERATOR_IN

static final String OPERATOR_IN

See Also:

• Constant Field Values

OPERATOR_BETWEEN

static final String OPERATOR_BETWEEN

See Also:

• Constant Field Values

FUNCTION_CASE

static final String FUNCTION_CASE

See Also:

• Constant Field Values

FUNCTION_IIF

static final String FUNCTION_IIF

See Also:

• Constant Field Values

FUNCTION_IF

static final String FUNCTION_IF

See Also:

• Constant Field Values

FUNCTION_IFNULL

static final String FUNCTION_IFNULL

See Also:

• Constant Field Values

FUNCTION_LEFT

static final String FUNCTION_LEFT

See Also:

• Constant Field Values

FUNCTION_RIGHT

static final String FUNCTION_RIGHT

See Also:

• Constant Field Values

FUNCTION_LOCATE

static final String FUNCTION_LOCATE

See Also:

• Constant Field Values

FUNCTION_POSITION

static final String FUNCTION_POSITION

See Also:

• Constant Field Values

FUNCTION_LPAD

static final String FUNCTION_LPAD

See Also:

• Constant Field Values

FUNCTION_RPAD

static final String FUNCTION_RPAD

See Also:

• Constant Field Values

FUNCTION_LTRIM

static final String FUNCTION_LTRIM

See Also:

• Constant Field Values

FUNCTION_RTRIM

static final String FUNCTION_RTRIM

See Also:

• Constant Field Values

FUNCTION_TRIM

static final String FUNCTION_TRIM

See Also:

• Constant Field Values

FUNCTION_REPEAT

static final String FUNCTION_REPEAT

See Also:

• Constant Field Values

FUNCTION_REPLACE

static final String FUNCTION_REPLACE

See Also:

• Constant Field Values

FUNCTION_ASCII

static final String FUNCTION_ASCII

See Also:

• Constant Field Values

FUNCTION_LENGHT

static final String FUNCTION_LENGHT

See Also:

• Constant Field Values

FUNCTION_INSTR

static final String FUNCTION_INSTR

See Also:

• Constant Field Values

FUNCTION_REVERSEINSTR

static final String FUNCTION_REVERSEINSTR

See Also:

• Constant Field Values

FUNCTION_LOWER

static final String FUNCTION_LOWER

See Also:

• Constant Field Values

FUNCTION_UPPER

static final String FUNCTION_UPPER

See Also:

• Constant Field Values

FUNCTION_SPACE

static final String FUNCTION_SPACE

See Also:

• Constant Field Values

FUNCTION_SUBSTRING

static final String FUNCTION_SUBSTRING

See Also:

• Constant Field Values

FUNCTION_CONCAT

static final String FUNCTION_CONCAT

See Also:

• Constant Field Values

FUNCTION_ABS

static final String FUNCTION_ABS

See Also:

• Constant Field Values

FUNCTION_ACOS

static final String FUNCTION_ACOS

See Also:

• Constant Field Values

FUNCTION_ASIN

static final String FUNCTION_ASIN

See Also:

• Constant Field Values

FUNCTION_ATAN

static final String FUNCTION_ATAN

See Also:

• Constant Field Values

FUNCTION_COS

static final String FUNCTION_COS

See Also:

• Constant Field Values

FUNCTION_COSH

static final String FUNCTION_COSH

See Also:

• Constant Field Values

FUNCTION_COT

static final String FUNCTION_COT

See Also:

• Constant Field Values

FUNCTION_BITAND

static final String FUNCTION_BITAND

See Also:

• Constant Field Values

FUNCTION_BITOR

static final String FUNCTION_BITOR

See Also:

• Constant Field Values

FUNCTION_BITXOR

static final String FUNCTION_BITXOR

See Also:

• Constant Field Values

FUNCTION_CEIL

static final String FUNCTION_CEIL

See Also:

• Constant Field Values

FUNCTION_DEGREES

static final String FUNCTION_DEGREES

See Also:

• Constant Field Values

FUNCTION_EXP

static final String FUNCTION_EXP

See Also:

• Constant Field Values

FUNCTION_FLOOR

static final String FUNCTION_FLOOR

See Also:

• Constant Field Values

FUNCTION_LOG

static final String FUNCTION_LOG

See Also:

• Constant Field Values

FUNCTION_LOG10

static final String FUNCTION_LOG10

See Also:

• Constant Field Values

FUNCTION_PI

static final String FUNCTION_PI

See Also:

• Constant Field Values

FUNCTION_POWER

static final String FUNCTION_POWER

See Also:

• Constant Field Values

FUNCTION_RADIANS

static final String FUNCTION_RADIANS

See Also:

• Constant Field Values

FUNCTION_RAND

static final String FUNCTION_RAND

See Also:

• Constant Field Values

FUNCTION_ROUND

static final String FUNCTION_ROUND

See Also:

• Constant Field Values

FUNCTION_SQRT

static final String FUNCTION_SQRT

See Also:

• Constant Field Values

FUNCTION_SIGN

static final String FUNCTION_SIGN

See Also:

• Constant Field Values

FUNCTION_SIN

static final String FUNCTION_SIN

See Also:

• Constant Field Values

FUNCTION_SINH

static final String FUNCTION_SINH

See Also:

• Constant Field Values

FUNCTION_TAN

static final String FUNCTION_TAN

See Also:

• Constant Field Values

FUNCTION_TANH

static final String FUNCTION_TANH

See Also:

• Constant Field Values

FUNCTION_ZERO

static final String FUNCTION_ZERO

See Also:

• Constant Field Values

FUNCTION_CHR

static final String FUNCTION_CHR

See Also:

• Constant Field Values

FUNCTION_MOD

static final String FUNCTION_MOD

See Also:

• Constant Field Values

FUNCTION_UUID

static final String FUNCTION_UUID

See Also:

• Constant Field Values

FUNCTION_COUNT

static final String FUNCTION_COUNT

See Also:

• Constant Field Values

FUNCTION_MAX

static final String FUNCTION_MAX

See Also:

• Constant Field Values

FUNCTION_MIN

static final String FUNCTION_MIN

See Also:

• Constant Field Values

FUNCTION_SUM

static final String FUNCTION_SUM

See Also:

• Constant Field Values

FUNCTION_AVG

static final String FUNCTION_AVG

See Also:

• Constant Field Values

FUNCTION_DATE

static final String FUNCTION_DATE

See Also:

• Constant Field Values

FUNCTION_TIME

static final String FUNCTION_TIME

See Also:

• Constant Field Values

FUNCTION_TIMESTAMP

static final String FUNCTION_TIMESTAMP

See Also:

• Constant Field Values

FUNCTION_TO_DATE

static final String FUNCTION_TO_DATE

See Also:

• Constant Field Values

FUNCTION_TO_TIMESTAMP

static final String FUNCTION_TO_TIMESTAMP

See Also:

• Constant Field Values

FUNCTION_DATEDIFF

static final String FUNCTION_DATEDIFF

See Also:

• Constant Field Values

FUNCTION_DATEADD

static final String FUNCTION_DATEADD

See Also:

• Constant Field Values

FUNCTION_CURRENT_TIMESTAMP

static final String FUNCTION_CURRENT_TIMESTAMP

See Also:

• Constant Field Values

FUNCTION_CURRENT_TIME

static final String FUNCTION_CURRENT_TIME

See Also:

• Constant Field Values

FUNCTION_CURRENT_DATE

static final String FUNCTION_CURRENT_DATE

See Also:

• Constant Field Values

FUNCTION_EXTRACT

static final String FUNCTION_EXTRACT

See Also:

• Constant Field Values

FUNCTION_CAST

static final String FUNCTION_CAST

See Also:

• Constant Field Values

FUNCTION_DECODE

static final String FUNCTION_DECODE

See Also:

• Constant Field Values

FUNCTION_ENCODE

static final String FUNCTION_ENCODE

See Also:

• Constant Field Values

FUNCTION_TODOUBLE

static final String FUNCTION_TODOUBLE

See Also:

• Constant Field Values

FUNCTION_TOFLOAT

static final String FUNCTION_TOFLOAT

See Also:

• Constant Field Values

FUNCTION_TOINTEGER

static final String FUNCTION_TOINTEGER

See Also:

• Constant Field Values

FUNCTION_TOLONG

static final String FUNCTION_TOLONG

See Also:

• Constant Field Values

FUNCTION_TOSTR

static final String FUNCTION_TOSTR

See Also:

• Constant Field Values

FUNCTION_TOJSON

static final String FUNCTION_TOJSON

See Also:

• Constant Field Values

FUNCTION_MAP

static final String FUNCTION_MAP

See Also:

• Constant Field Values

FUNCTION_LET

static final String FUNCTION_LET

See Also:

• Constant Field Values

FUNCTION_INCR

static final String FUNCTION_INCR

See Also:

• Constant Field Values

FUNCTION_DECR

static final String FUNCTION_DECR

See Also:

• Constant Field Values

FUNCTION_RANGE

static final String FUNCTION_RANGE

See Also:

• Constant Field Values

FUNCTION_EVAL

static final String FUNCTION_EVAL

See Also:

• Constant Field Values

FUNCTION_LIST

static final String FUNCTION_LIST

See Also:

• Constant Field Values

FUNCTION_TUPLE

static final String FUNCTION_TUPLE

See Also:

• Constant Field Values

FUNCTION_DICT

static final String FUNCTION_DICT

See Also:

• Constant Field Values

FUNCTION_$CONSTANT

@Deprecated
static final String FUNCTION_$CONSTANT

Deprecated.

See Also:

• Constant Field Values

FUNCTION_$IDENTIFIER

@Deprecated
static final String FUNCTION_$IDENTIFIER

Deprecated.

See Also:

• Constant Field Values

FUNCTION_$HOSTEXPRESSION

static final String FUNCTION_$HOSTEXPRESSION

See Also:

• Constant Field Values

FUNCTION_GETATTR

static final String FUNCTION_GETATTR

See Also:

• Constant Field Values

FUNCTION_SETATTR

static final String FUNCTION_SETATTR

See Also:

• Constant Field Values

FUNCTION_GETITEM

static final String FUNCTION_GETITEM

See Also:

• Constant Field Values

FUNCTION_URLREAD

static final String FUNCTION_URLREAD

See Also:

• Constant Field Values

FUNCTION_URLREADBYTES

static final String FUNCTION_URLREADBYTES

See Also:

• Constant Field Values

FUNCTION_URL

static final String FUNCTION_URL

See Also:

• Constant Field Values

FUNCTION_DESKTOPBROWSE

static final String FUNCTION_DESKTOPBROWSE

See Also:

• Constant Field Values

FUNCTION_DESKTOPOPEN

static final String FUNCTION_DESKTOPOPEN

See Also:

• Constant Field Values

FUNCTION_DESKTOPEDIT

static final String FUNCTION_DESKTOPEDIT

See Also:

• Constant Field Values

FUNCTION_CRC32

static final String FUNCTION_CRC32

See Also:

• Constant Field Values

FUNCTION_MD5HEX

static final String FUNCTION_MD5HEX

See Also:

• Constant Field Values

FUNCTION_COLOR

static final String FUNCTION_COLOR

See Also:

• Constant Field Values

FUNCTION_JSON_VALUE

static final String FUNCTION_JSON_VALUE

See Also:

• Constant Field Values

PARAMETER_TYPE_CONSTANT

static final int PARAMETER_TYPE_CONSTANT

See Also:

• Constant Field Values

PARAMETER_TYPE_VARIABLE

static final int PARAMETER_TYPE_VARIABLE

See Also:

• Constant Field Values

VALUE_NULL

static final ExpressionBuilder.Constant VALUE_NULL

EMPTY_FORMATTER

static final Formatter<ExpressionBuilder.Value> EMPTY_FORMATTER

Method Details

isFunction

static boolean isFunction(ExpressionBuilder.Value value,
 String name)

formatter

Formatter<ExpressionBuilder.Value> formatter()

quote_for_identifiers

String quote_for_identifiers()

quote_for_strings

String quote_for_strings()

accept

void accept(ExpressionBuilder.Visitor visitor,
 ExpressionBuilder.VisitorFilter filter)

variables

List<ExpressionBuilder.Variable> variables()

variables_names

List<String> variables_names()

parameters

List<ExpressionBuilder.Parameter> parameters()

parameters_names

List<String> parameters_names()

identifier

String identifier(String name)

bytearray_hex

String bytearray_hex(byte[] data)

bytearray_0x

String bytearray_0x(byte[] data)

bytearray_x

String bytearray_x(byte[] data)

string

String string(String s)

value

ExpressionBuilder.Value value()

value

ExpressionBuilder value(ExpressionBuilder.Value value)

group

ExpressionBuilder.Group group(ExpressionBuilder.Value group)

bytearray

ExpressionBuilder.Constant bytearray(byte[] data)

variable

ExpressionBuilder.Variable variable(String name)

column

ExpressionBuilder.Variable column(String name)

column

ExpressionBuilder.Value column(String tableName,
 String columnName)

parameter

ExpressionBuilder.Parameter parameter(String name)

parameter

ExpressionBuilder.Parameter parameter()

constant

ExpressionBuilder.Constant constant(Object value)

constant

ExpressionBuilder.Constant constant(Object value,
 int type)

constant

ExpressionBuilder.Constant constant(Object value,
 Class theClass)

custom

ExpressionBuilder.Custom custom(Object value)

method

ExpressionBuilder.Method method(ExpressionBuilder.Value instance,
 String name,
 ExpressionBuilder.Value... values)

function

ExpressionBuilder.Function function(String name,
 ExpressionBuilder.Value... values)

binaryOperator

ExpressionBuilder.BinaryOperator binaryOperator(String name,
 ExpressionBuilder.Value leftOperand,
 ExpressionBuilder.Value rightOperand)

toValue

ExpressionBuilder.Value toValue(String expression)

repr

String repr(Object value)

toString

String toString(Formatter<ExpressionBuilder.Value> formatter)

not

ExpressionBuilder.Function not(ExpressionBuilder.Value value)

not_is_null

ExpressionBuilder.Function not_is_null(ExpressionBuilder.Value value)

is_null

ExpressionBuilder.Function is_null(ExpressionBuilder.Value value)

and

ExpressionBuilder.BinaryOperator and(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

and

ExpressionBuilder.BinaryOperator and(Expression op1,
 Expression op2)

and

ExpressionBuilder.BinaryOperator and(Expression op1,
 ExpressionBuilder.Value op2)

or

ExpressionBuilder.BinaryOperator or(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

eq

ExpressionBuilder.BinaryOperator eq(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

ne

ExpressionBuilder.BinaryOperator ne(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

gt

ExpressionBuilder.BinaryOperator gt(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

ge

ExpressionBuilder.BinaryOperator ge(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

lt

ExpressionBuilder.BinaryOperator lt(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

le

ExpressionBuilder.BinaryOperator le(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

like

ExpressionBuilder.BinaryOperator like(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

ilike

ExpressionBuilder.BinaryOperator ilike(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

add

ExpressionBuilder.BinaryOperator add(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

subst

ExpressionBuilder.BinaryOperator subst(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

mult

ExpressionBuilder.BinaryOperator mult(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

div

ExpressionBuilder.BinaryOperator div(ExpressionBuilder.Value op1,
 ExpressionBuilder.Value op2)

concat

ExpressionBuilder.Function concat(ExpressionBuilder.Value... values)

set

ExpressionBuilder set(ExpressionBuilder.Value value)

and

ExpressionBuilder and(ExpressionBuilder.Value value)

or

ExpressionBuilder or(ExpressionBuilder.Value value)

iif

ExpressionBuilder.Function iif(ExpressionBuilder.Value condition,
 ExpressionBuilder.Value iftrue,
 ExpressionBuilder.Value iffalse)

ifnull

ExpressionBuilder.Function ifnull(ExpressionBuilder.Value value,
 ExpressionBuilder.Value iftrue,
 ExpressionBuilder.Value iffalse)

createExpressionBuilder

ExpressionBuilder createExpressionBuilder()

left

ExpressionBuilder.Function left(ExpressionBuilder.Value str,
 ExpressionBuilder.Value size)

right

ExpressionBuilder.Function right(ExpressionBuilder.Value str,
 ExpressionBuilder.Value len)

locate

ExpressionBuilder.Function locate(ExpressionBuilder.Value search,
 ExpressionBuilder.Value str,
 ExpressionBuilder.Value start)

position

ExpressionBuilder.Function position(ExpressionBuilder.Value search,
 ExpressionBuilder.Value str)

lpad

ExpressionBuilder.Function lpad(ExpressionBuilder.Value str,
 ExpressionBuilder.Value len,
 ExpressionBuilder.Value padstr)

rpad

ExpressionBuilder.Function rpad(ExpressionBuilder.Value str,
 ExpressionBuilder.Value len,
 ExpressionBuilder.Value padstr)

ltrim

ExpressionBuilder.Function ltrim(ExpressionBuilder.Value str)

rtrim

ExpressionBuilder.Function rtrim(ExpressionBuilder.Value str)

trim

ExpressionBuilder.Function trim(ExpressionBuilder.Value str)

repeat

ExpressionBuilder.Function repeat(ExpressionBuilder.Value str,
 ExpressionBuilder.Value size)

replace

ExpressionBuilder.Function replace(ExpressionBuilder.Value str,
 ExpressionBuilder.Value search,
 ExpressionBuilder.Value replstr)

ascii

ExpressionBuilder.Function ascii(ExpressionBuilder.Value str)

lenght

ExpressionBuilder.Function lenght(ExpressionBuilder.Value str)

instr

ExpressionBuilder.Function instr(ExpressionBuilder.Value str,
 ExpressionBuilder.Value search,
 ExpressionBuilder.Value start)

lower

ExpressionBuilder.Function lower(ExpressionBuilder.Value str)

upper

ExpressionBuilder.Function upper(ExpressionBuilder.Value str)

space

ExpressionBuilder.Function space(ExpressionBuilder.Value size)

substring

ExpressionBuilder.Function substring(ExpressionBuilder.Value str,
 ExpressionBuilder.Value start,
 ExpressionBuilder.Value len)

abs

ExpressionBuilder.Function abs(ExpressionBuilder.Value num)

acos

ExpressionBuilder.Function acos(ExpressionBuilder.Value num)

asin

ExpressionBuilder.Function asin(ExpressionBuilder.Value num)

atan

ExpressionBuilder.Function atan(ExpressionBuilder.Value num)

cos

ExpressionBuilder.Function cos(ExpressionBuilder.Value num)

cosh

ExpressionBuilder.Function cosh(ExpressionBuilder.Value num)

cot

ExpressionBuilder.Function cot(ExpressionBuilder.Value num)

bitand

ExpressionBuilder.Function bitand(ExpressionBuilder.Value num1,
 ExpressionBuilder.Value num2)

bitor

ExpressionBuilder.Function bitor(ExpressionBuilder.Value num1,
 ExpressionBuilder.Value num2)

bitxor

ExpressionBuilder.Function bitxor(ExpressionBuilder.Value num1,
 ExpressionBuilder.Value num2)

ceil

ExpressionBuilder.Function ceil(ExpressionBuilder.Value num)

degrees

ExpressionBuilder.Function degrees(ExpressionBuilder.Value num)

exp

ExpressionBuilder.Function exp(ExpressionBuilder.Value num)

floor

ExpressionBuilder.Function floor(ExpressionBuilder.Value num)

log

ExpressionBuilder.Function log(ExpressionBuilder.Value num)

log10

ExpressionBuilder.Function log10(ExpressionBuilder.Value num)

pi

ExpressionBuilder.Function pi()

power

ExpressionBuilder.Function power(ExpressionBuilder.Value num)

radians

ExpressionBuilder.Function radians(ExpressionBuilder.Value num)

rand

ExpressionBuilder.Function rand(ExpressionBuilder.Value num)

round

ExpressionBuilder.Function round(ExpressionBuilder.Value num)

sqrt

ExpressionBuilder.Function sqrt(ExpressionBuilder.Value num)

sign

ExpressionBuilder.Function sign(ExpressionBuilder.Value num)

sin

ExpressionBuilder.Function sin(ExpressionBuilder.Value num)

sinh

ExpressionBuilder.Function sinh(ExpressionBuilder.Value num)

tan

ExpressionBuilder.Function tan(ExpressionBuilder.Value num)

tanh

ExpressionBuilder.Function tanh(ExpressionBuilder.Value num)

zero

ExpressionBuilder.Function zero()

chr

ExpressionBuilder.Function chr(ExpressionBuilder.Value num)

decode

ExpressionBuilder.Function decode(ExpressionBuilder.Value value,
 ExpressionBuilder.Value format)

cast

ExpressionBuilder.Function cast(ExpressionBuilder.Value object,
 ExpressionBuilder.Value typeName)

cast

ExpressionBuilder.Function cast(ExpressionBuilder.Value object,
 int type)

toDouble

ExpressionBuilder.Function toDouble(ExpressionBuilder.Value object)

toFloat

ExpressionBuilder.Function toFloat(ExpressionBuilder.Value object)

toLong

ExpressionBuilder.Function toLong(ExpressionBuilder.Value object)

toInteger

ExpressionBuilder.Function toInteger(ExpressionBuilder.Value object)

toStr

ExpressionBuilder.Function toStr(ExpressionBuilder.Value object)

list

ExpressionBuilder.Function list()

tuple

ExpressionBuilder.Function tuple()

tuple

ExpressionBuilder.Function tuple(Object... values)

getattr

ExpressionBuilder.Function getattr(String objectId,
 String attributeId)

isEmpty

boolean isEmpty()

color

ExpressionBuilder.Function color(ExpressionBuilder.Value red,
 ExpressionBuilder.Value green,
 ExpressionBuilder.Value blue,
 ExpressionBuilder.Value alfa)

color

ExpressionBuilder.Function color(Color color)

date

ExpressionBuilder.Function date(ExpressionBuilder.Value date)

time

ExpressionBuilder.Function time(ExpressionBuilder.Value date)

timestamp

ExpressionBuilder.Function timestamp(ExpressionBuilder.Value date)

date

ExpressionBuilder.Function date(Date date)

time

ExpressionBuilder.Function time(Date time)

timestamp

ExpressionBuilder.Function timestamp(Date timestamp)

date

ExpressionBuilder.Function date(String date)

time

ExpressionBuilder.Function time(String time)

timestamp

ExpressionBuilder.Function timestamp(String timestamp)

to_date

ExpressionBuilder.Function to_date(ExpressionBuilder.Value date,
 ExpressionBuilder.Value format)

to_timestamp

ExpressionBuilder.Function to_timestamp(ExpressionBuilder.Value timestamp,
 ExpressionBuilder.Value format)

current_date

ExpressionBuilder.Function current_date()

current_time

ExpressionBuilder.Function current_time()

current_timestamp

ExpressionBuilder.Function current_timestamp()

let

ExpressionBuilder.Function let(String name,
 ExpressionBuilder.Value value)

date_add

ExpressionBuilder.Function date_add(ExpressionBuilder.Value datefield,
 ExpressionBuilder.Value valueToAdd,
 ExpressionBuilder.Value date)

date_diff

ExpressionBuilder.Function date_diff(ExpressionBuilder.Value datefield,
 ExpressionBuilder.Value valueToSubst,
 ExpressionBuilder.Value date)

extract

ExpressionBuilder.Function extract(ExpressionBuilder.Value datefield,
 ExpressionBuilder.Value source)

build

String build(Formatter<ExpressionBuilder.Value> formatter)

build

String build()

setProperties

void setProperties(Class filter,
 Object... values)

hostexpression

ExpressionBuilder.Function hostexpression(ExpressionBuilder.Value expression)