org.gvsig.expressionevaluator

Interface ExpressionBuilder

All Superinterfaces:

PropertiesSupport

All Known Subinterfaces:

GeometryExpressionBuilder

All Known Implementing Classes:

DefaultExpressionBuilder, DefaultGeometryExpressionBuilder, DelegatedExpressionBuilder, DelegatedGeometryExpressionBuilder

public interface ExpressionBuilder
extends PropertiesSupport

Nested Class Summary

Nested Classes

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

Method Summary

Modifier and Type	Method and 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(java.lang.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)
java.lang.String	build()
java.lang.String	build(Formatter<ExpressionBuilder.Value> formatter)
java.lang.String	bytearray_0x(byte[] data)
java.lang.String	bytearray_hex(byte[] data)
java.lang.String	bytearray_x(byte[] data)
ExpressionBuilder.Constant	bytearray(byte[] data)
ExpressionBuilder.Function	cast(ExpressionBuilder.Value object, ExpressionBuilder.Value typeName)
ExpressionBuilder.Function	cast(ExpressionBuilder.Value object, int type)
ExpressionBuilder.Function	ceil(ExpressionBuilder.Value num)
ExpressionBuilder.Function	chr(ExpressionBuilder.Value num)
ExpressionBuilder.Function	color(java.awt.Color color)
ExpressionBuilder.Function	color(ExpressionBuilder.Value red, ExpressionBuilder.Value green, ExpressionBuilder.Value blue, ExpressionBuilder.Value alfa)
ExpressionBuilder.Variable	column(java.lang.String name)
ExpressionBuilder.Value	column(java.lang.String tableName, java.lang.String columnName)
ExpressionBuilder.Function	concat(ExpressionBuilder.Value... values)
ExpressionBuilder.Constant	constant(java.lang.Object value)
ExpressionBuilder.Constant	constant(java.lang.Object value, java.lang.Class theClass)
ExpressionBuilder.Constant	constant(java.lang.Object value, int type)
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(java.lang.Object value)
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	date(java.util.Date date)
ExpressionBuilder.Function	date(ExpressionBuilder.Value date)
ExpressionBuilder.Function	date(java.lang.String 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(java.lang.String name, ExpressionBuilder.Value... values)
ExpressionBuilder.BinaryOperator	ge(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	getattr(java.lang.String objectId, java.lang.String attributeId)
ExpressionBuilder.Group	group(ExpressionBuilder.Value group)
ExpressionBuilder.BinaryOperator	gt(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Function	hostexpression(ExpressionBuilder.Value expression)
java.lang.String	identifier(java.lang.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, java.lang.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(java.lang.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, java.lang.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_is_null(ExpressionBuilder.Value value)
ExpressionBuilder.Function	not(ExpressionBuilder.Value value)
ExpressionBuilder	or(ExpressionBuilder.Value value)
ExpressionBuilder.BinaryOperator	or(ExpressionBuilder.Value op1, ExpressionBuilder.Value op2)
ExpressionBuilder.Parameter	parameter()
ExpressionBuilder.Parameter	parameter(java.lang.String name)
java.util.List<java.lang.String>	parameters_names()
java.util.List<ExpressionBuilder.Parameter>	parameters()
ExpressionBuilder.Function	pi()
ExpressionBuilder.Function	position(ExpressionBuilder.Value search, ExpressionBuilder.Value str)
ExpressionBuilder.Function	power(ExpressionBuilder.Value num)
java.lang.String	quote_for_identifiers()
java.lang.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)
java.lang.String	repr(java.lang.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(java.lang.Class filter, java.lang.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)
java.lang.String	string(java.lang.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(java.util.Date time)
ExpressionBuilder.Function	time(ExpressionBuilder.Value date)
ExpressionBuilder.Function	time(java.lang.String time)
ExpressionBuilder.Function	timestamp(java.util.Date timestamp)
ExpressionBuilder.Function	timestamp(ExpressionBuilder.Value date)
ExpressionBuilder.Function	timestamp(java.lang.String timestamp)
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)
java.lang.String	toString(Formatter<ExpressionBuilder.Value> formatter)
ExpressionBuilder.Value	toValue(java.lang.String expression)
ExpressionBuilder.Function	trim(ExpressionBuilder.Value str)
ExpressionBuilder.Function	tuple()
ExpressionBuilder.Function	tuple(java.lang.Object... values)
ExpressionBuilder.Function	upper(ExpressionBuilder.Value str)
ExpressionBuilder.Value	value()
ExpressionBuilder	value(ExpressionBuilder.Value value)
ExpressionBuilder.Variable	variable(java.lang.String name)
java.util.List<java.lang.String>	variables_names()
java.util.List<ExpressionBuilder.Variable>	variables()
ExpressionBuilder.Function	zero()

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

getProperties, getProperty, setProperty

Field Detail

OPERATOR_NOT

static final java.lang.String OPERATOR_NOT

See Also:

Constant Field Values

OPERATOR_NEGATE

static final java.lang.String OPERATOR_NEGATE

See Also:

Constant Field Values

OPERATOR_IS

static final java.lang.String OPERATOR_IS

See Also:

Constant Field Values

OPERATOR_IS_NULL

static final java.lang.String OPERATOR_IS_NULL

See Also:

Constant Field Values

OPERATOR_IS_NOT_NULL

static final java.lang.String OPERATOR_IS_NOT_NULL

See Also:

Constant Field Values

OPERATOR_AND

static final java.lang.String OPERATOR_AND

See Also:

Constant Field Values

OPERATOR_OR

static final java.lang.String OPERATOR_OR

See Also:

Constant Field Values

OPERATOR_EQ

static final java.lang.String OPERATOR_EQ

See Also:

Constant Field Values

OPERATOR_NE

static final java.lang.String OPERATOR_NE

See Also:

Constant Field Values

OPERATOR_GT

static final java.lang.String OPERATOR_GT

See Also:

Constant Field Values

OPERATOR_GE

static final java.lang.String OPERATOR_GE

See Also:

Constant Field Values

OPERATOR_LT

static final java.lang.String OPERATOR_LT

See Also:

Constant Field Values

OPERATOR_LE

static final java.lang.String OPERATOR_LE

See Also:

Constant Field Values

OPERATOR_LIKE

static final java.lang.String OPERATOR_LIKE

See Also:

Constant Field Values

OPERATOR_ILIKE

static final java.lang.String OPERATOR_ILIKE

See Also:

Constant Field Values

OPERATOR_ADD

static final java.lang.String OPERATOR_ADD

See Also:

Constant Field Values

OPERATOR_SUBST

static final java.lang.String OPERATOR_SUBST

See Also:

Constant Field Values

OPERATOR_MULT

static final java.lang.String OPERATOR_MULT

See Also:

Constant Field Values

OPERATOR_DIV

static final java.lang.String OPERATOR_DIV

See Also:

Constant Field Values

OPERATOR_MOD

static final java.lang.String OPERATOR_MOD

See Also:

Constant Field Values

OPERATOR_CONCAT

static final java.lang.String OPERATOR_CONCAT

See Also:

Constant Field Values

OPERATOR_REGEXP

static final java.lang.String OPERATOR_REGEXP

See Also:

Constant Field Values

OPERATOR_AND2

static final java.lang.String OPERATOR_AND2

See Also:

Constant Field Values

OPERATOR_IN

static final java.lang.String OPERATOR_IN

See Also:

Constant Field Values

OPERATOR_BETWEEN

static final java.lang.String OPERATOR_BETWEEN

See Also:

Constant Field Values

FUNCTION_CASE

static final java.lang.String FUNCTION_CASE

See Also:

Constant Field Values

FUNCTION_IIF

static final java.lang.String FUNCTION_IIF

See Also:

Constant Field Values

FUNCTION_IF

static final java.lang.String FUNCTION_IF

See Also:

Constant Field Values

FUNCTION_IFNULL

static final java.lang.String FUNCTION_IFNULL

See Also:

Constant Field Values

FUNCTION_LEFT

static final java.lang.String FUNCTION_LEFT

See Also:

Constant Field Values

FUNCTION_RIGHT

static final java.lang.String FUNCTION_RIGHT

See Also:

Constant Field Values

FUNCTION_LOCATE

static final java.lang.String FUNCTION_LOCATE

See Also:

Constant Field Values

FUNCTION_POSITION

static final java.lang.String FUNCTION_POSITION

See Also:

Constant Field Values

FUNCTION_LPAD

static final java.lang.String FUNCTION_LPAD

See Also:

Constant Field Values

FUNCTION_RPAD

static final java.lang.String FUNCTION_RPAD

See Also:

Constant Field Values

FUNCTION_LTRIM

static final java.lang.String FUNCTION_LTRIM

See Also:

Constant Field Values

FUNCTION_RTRIM

static final java.lang.String FUNCTION_RTRIM

See Also:

Constant Field Values

FUNCTION_TRIM

static final java.lang.String FUNCTION_TRIM

See Also:

Constant Field Values

FUNCTION_REPEAT

static final java.lang.String FUNCTION_REPEAT

See Also:

Constant Field Values

FUNCTION_REPLACE

static final java.lang.String FUNCTION_REPLACE

See Also:

Constant Field Values

FUNCTION_ASCII

static final java.lang.String FUNCTION_ASCII

See Also:

Constant Field Values

FUNCTION_LENGHT

static final java.lang.String FUNCTION_LENGHT

See Also:

Constant Field Values

FUNCTION_INSTR

static final java.lang.String FUNCTION_INSTR

See Also:

Constant Field Values

FUNCTION_REVERSEINSTR

static final java.lang.String FUNCTION_REVERSEINSTR

See Also:

Constant Field Values

FUNCTION_LOWER

static final java.lang.String FUNCTION_LOWER

See Also:

Constant Field Values

FUNCTION_UPPER

static final java.lang.String FUNCTION_UPPER

See Also:

Constant Field Values

FUNCTION_SPACE

static final java.lang.String FUNCTION_SPACE

See Also:

Constant Field Values

FUNCTION_SUBSTRING

static final java.lang.String FUNCTION_SUBSTRING

See Also:

Constant Field Values

FUNCTION_CONCAT

static final java.lang.String FUNCTION_CONCAT

See Also:

Constant Field Values

FUNCTION_ABS

static final java.lang.String FUNCTION_ABS

See Also:

Constant Field Values

FUNCTION_ACOS

static final java.lang.String FUNCTION_ACOS

See Also:

Constant Field Values

FUNCTION_ASIN

static final java.lang.String FUNCTION_ASIN

See Also:

Constant Field Values

FUNCTION_ATAN

static final java.lang.String FUNCTION_ATAN

See Also:

Constant Field Values

FUNCTION_COS

static final java.lang.String FUNCTION_COS

See Also:

Constant Field Values

FUNCTION_COSH

static final java.lang.String FUNCTION_COSH

See Also:

Constant Field Values

FUNCTION_COT

static final java.lang.String FUNCTION_COT

See Also:

Constant Field Values

FUNCTION_BITAND

static final java.lang.String FUNCTION_BITAND

See Also:

Constant Field Values

FUNCTION_BITOR

static final java.lang.String FUNCTION_BITOR

See Also:

Constant Field Values

FUNCTION_BITXOR

static final java.lang.String FUNCTION_BITXOR

See Also:

Constant Field Values

FUNCTION_CEIL

static final java.lang.String FUNCTION_CEIL

See Also:

Constant Field Values

FUNCTION_DEGREES

static final java.lang.String FUNCTION_DEGREES

See Also:

Constant Field Values

FUNCTION_EXP

static final java.lang.String FUNCTION_EXP

See Also:

Constant Field Values

FUNCTION_FLOOR

static final java.lang.String FUNCTION_FLOOR

See Also:

Constant Field Values

FUNCTION_LOG

static final java.lang.String FUNCTION_LOG

See Also:

Constant Field Values

FUNCTION_LOG10

static final java.lang.String FUNCTION_LOG10

See Also:

Constant Field Values

FUNCTION_PI

static final java.lang.String FUNCTION_PI

See Also:

Constant Field Values

FUNCTION_POWER

static final java.lang.String FUNCTION_POWER

See Also:

Constant Field Values

FUNCTION_RADIANS

static final java.lang.String FUNCTION_RADIANS

See Also:

Constant Field Values

FUNCTION_RAND

static final java.lang.String FUNCTION_RAND

See Also:

Constant Field Values

FUNCTION_ROUND

static final java.lang.String FUNCTION_ROUND

See Also:

Constant Field Values

FUNCTION_SQRT

static final java.lang.String FUNCTION_SQRT

See Also:

Constant Field Values

FUNCTION_SIGN

static final java.lang.String FUNCTION_SIGN

See Also:

Constant Field Values

FUNCTION_SIN

static final java.lang.String FUNCTION_SIN

See Also:

Constant Field Values

FUNCTION_SINH

static final java.lang.String FUNCTION_SINH

See Also:

Constant Field Values

FUNCTION_TAN

static final java.lang.String FUNCTION_TAN

See Also:

Constant Field Values

FUNCTION_TANH

static final java.lang.String FUNCTION_TANH

See Also:

Constant Field Values

FUNCTION_ZERO

static final java.lang.String FUNCTION_ZERO

See Also:

Constant Field Values

FUNCTION_CHR

static final java.lang.String FUNCTION_CHR

See Also:

Constant Field Values

FUNCTION_MOD

static final java.lang.String FUNCTION_MOD

See Also:

Constant Field Values

FUNCTION_UUID

static final java.lang.String FUNCTION_UUID

See Also:

Constant Field Values

FUNCTION_COUNT

static final java.lang.String FUNCTION_COUNT

See Also:

Constant Field Values

FUNCTION_MAX

static final java.lang.String FUNCTION_MAX

See Also:

Constant Field Values

FUNCTION_MIN

static final java.lang.String FUNCTION_MIN

See Also:

Constant Field Values

FUNCTION_SUM

static final java.lang.String FUNCTION_SUM

See Also:

Constant Field Values

FUNCTION_AVG

static final java.lang.String FUNCTION_AVG

See Also:

Constant Field Values

FUNCTION_DATE

static final java.lang.String FUNCTION_DATE

See Also:

Constant Field Values

FUNCTION_TIME

static final java.lang.String FUNCTION_TIME

See Also:

Constant Field Values

FUNCTION_TIMESTAMP

static final java.lang.String FUNCTION_TIMESTAMP

See Also:

Constant Field Values

FUNCTION_TO_DATE

static final java.lang.String FUNCTION_TO_DATE

See Also:

Constant Field Values

FUNCTION_TO_TIMESTAMP

static final java.lang.String FUNCTION_TO_TIMESTAMP

See Also:

Constant Field Values

FUNCTION_DATEDIFF

static final java.lang.String FUNCTION_DATEDIFF

See Also:

Constant Field Values

FUNCTION_DATEADD

static final java.lang.String FUNCTION_DATEADD

See Also:

Constant Field Values

FUNCTION_CURRENT_TIMESTAMP

static final java.lang.String FUNCTION_CURRENT_TIMESTAMP

See Also:

Constant Field Values

FUNCTION_CURRENT_TIME

static final java.lang.String FUNCTION_CURRENT_TIME

See Also:

Constant Field Values

FUNCTION_CURRENT_DATE

static final java.lang.String FUNCTION_CURRENT_DATE

See Also:

Constant Field Values

FUNCTION_EXTRACT

static final java.lang.String FUNCTION_EXTRACT

See Also:

Constant Field Values

FUNCTION_CAST

static final java.lang.String FUNCTION_CAST

See Also:

Constant Field Values

FUNCTION_DECODE

static final java.lang.String FUNCTION_DECODE

See Also:

Constant Field Values

FUNCTION_ENCODE

static final java.lang.String FUNCTION_ENCODE

See Also:

Constant Field Values

FUNCTION_TODOUBLE

static final java.lang.String FUNCTION_TODOUBLE

See Also:

Constant Field Values

FUNCTION_TOFLOAT

static final java.lang.String FUNCTION_TOFLOAT

See Also:

Constant Field Values

FUNCTION_TOINTEGER

static final java.lang.String FUNCTION_TOINTEGER

See Also:

Constant Field Values

FUNCTION_TOLONG

static final java.lang.String FUNCTION_TOLONG

See Also:

Constant Field Values

FUNCTION_TOSTR

static final java.lang.String FUNCTION_TOSTR

See Also:

Constant Field Values

FUNCTION_TOJSON

static final java.lang.String FUNCTION_TOJSON

See Also:

Constant Field Values

FUNCTION_MAP

static final java.lang.String FUNCTION_MAP

See Also:

Constant Field Values

FUNCTION_LET

static final java.lang.String FUNCTION_LET

See Also:

Constant Field Values

FUNCTION_INCR

static final java.lang.String FUNCTION_INCR

See Also:

Constant Field Values

FUNCTION_DECR

static final java.lang.String FUNCTION_DECR

See Also:

Constant Field Values

FUNCTION_RANGE

static final java.lang.String FUNCTION_RANGE

See Also:

Constant Field Values

FUNCTION_EVAL

static final java.lang.String FUNCTION_EVAL

See Also:

Constant Field Values

FUNCTION_LIST

static final java.lang.String FUNCTION_LIST

See Also:

Constant Field Values

FUNCTION_TUPLE

static final java.lang.String FUNCTION_TUPLE

See Also:

Constant Field Values

FUNCTION_DICT

static final java.lang.String FUNCTION_DICT

See Also:

Constant Field Values

FUNCTION_$CONSTANT

@Deprecated
static final java.lang.String FUNCTION_$CONSTANT

Deprecated.

See Also:

Constant Field Values

FUNCTION_$IDENTIFIER

@Deprecated
static final java.lang.String FUNCTION_$IDENTIFIER

Deprecated.

See Also:

Constant Field Values

FUNCTION_$HOSTEXPRESSION

static final java.lang.String FUNCTION_$HOSTEXPRESSION

See Also:

Constant Field Values

FUNCTION_GETATTR

static final java.lang.String FUNCTION_GETATTR

See Also:

Constant Field Values

FUNCTION_SETATTR

static final java.lang.String FUNCTION_SETATTR

See Also:

Constant Field Values

FUNCTION_GETITEM

static final java.lang.String FUNCTION_GETITEM

See Also:

Constant Field Values

FUNCTION_URLREAD

static final java.lang.String FUNCTION_URLREAD

See Also:

Constant Field Values

FUNCTION_URLREADBYTES

static final java.lang.String FUNCTION_URLREADBYTES

See Also:

Constant Field Values

FUNCTION_URL

static final java.lang.String FUNCTION_URL

See Also:

Constant Field Values

FUNCTION_DESKTOPBROWSE

static final java.lang.String FUNCTION_DESKTOPBROWSE

See Also:

Constant Field Values

FUNCTION_DESKTOPOPEN

static final java.lang.String FUNCTION_DESKTOPOPEN

See Also:

Constant Field Values

FUNCTION_DESKTOPEDIT

static final java.lang.String FUNCTION_DESKTOPEDIT

See Also:

Constant Field Values

FUNCTION_CRC32

static final java.lang.String FUNCTION_CRC32

See Also:

Constant Field Values

FUNCTION_MD5HEX

static final java.lang.String FUNCTION_MD5HEX

See Also:

Constant Field Values

FUNCTION_COLOR

static final java.lang.String FUNCTION_COLOR

See Also:

Constant Field Values

FUNCTION_JSON_VALUE

static final java.lang.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 Detail

isFunction

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

formatter

Formatter<ExpressionBuilder.Value> formatter()

quote_for_identifiers

java.lang.String quote_for_identifiers()

quote_for_strings

java.lang.String quote_for_strings()

accept

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

variables

java.util.List<ExpressionBuilder.Variable> variables()

variables_names

java.util.List<java.lang.String> variables_names()

parameters

java.util.List<ExpressionBuilder.Parameter> parameters()

parameters_names

java.util.List<java.lang.String> parameters_names()

identifier

java.lang.String identifier(java.lang.String name)

bytearray_hex

java.lang.String bytearray_hex(byte[] data)

bytearray_0x

java.lang.String bytearray_0x(byte[] data)

bytearray_x

java.lang.String bytearray_x(byte[] data)

string

java.lang.String string(java.lang.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(java.lang.String name)

column

ExpressionBuilder.Variable column(java.lang.String name)

column

ExpressionBuilder.Value column(java.lang.String tableName,
                               java.lang.String columnName)

parameter

ExpressionBuilder.Parameter parameter(java.lang.String name)

parameter

ExpressionBuilder.Parameter parameter()

constant

ExpressionBuilder.Constant constant(java.lang.Object value)

constant

ExpressionBuilder.Constant constant(java.lang.Object value,
                                    int type)

constant

ExpressionBuilder.Constant constant(java.lang.Object value,
                                    java.lang.Class theClass)

custom

ExpressionBuilder.Custom custom(java.lang.Object value)

method

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

function

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

binaryOperator

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

toValue

ExpressionBuilder.Value toValue(java.lang.String expression)

repr

java.lang.String repr(java.lang.Object value)

toString

java.lang.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(java.lang.Object... values)

getattr

ExpressionBuilder.Function getattr(java.lang.String objectId,
                                   java.lang.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(java.awt.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(java.util.Date date)

time

ExpressionBuilder.Function time(java.util.Date time)

timestamp

ExpressionBuilder.Function timestamp(java.util.Date timestamp)

date

ExpressionBuilder.Function date(java.lang.String date)

time

ExpressionBuilder.Function time(java.lang.String time)

timestamp

ExpressionBuilder.Function timestamp(java.lang.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(java.lang.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

java.lang.String build(Formatter<ExpressionBuilder.Value> formatter)

build

java.lang.String build()

setProperties

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

hostexpression

ExpressionBuilder.Function hostexpression(ExpressionBuilder.Value expression)