public class DBDecodeExpr extends DBAbstractFuncExpr
There is no need to explicitly create instances of this class.
Instead use DBColumnExpr.when(org.apache.empire.db.expr.compare.DBCompareExpr, Object)
dataType, expr, isAggregate, log
attributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, options
CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE
Constructor and Description |
---|
DBDecodeExpr(DBColumnExpr expr,
Map<?,?> valueMap,
Object elseExpr,
DataType dataType)
Constructs a DBDecodeExpr
|
Modifier and Type | Method and Description |
---|---|
void |
addDecodeParts(DBSQLBuilder sql) |
void |
addReferencedColumns(Set<DBColumn> list)
Internal function to obtain all DBColumnExpr-objects used by this expression.
|
void |
addSQL(DBSQLBuilder sql,
long context)
Used to build the SQL command.
|
Class<Enum<?>> |
getEnumType()
Maybe an Enum...
|
protected String |
getFunctionName()
returns the name of the function
|
DBColumn |
getUpdateColumn()
Returns the DBColunm object.
|
addSQL, addXml, equals, getDatabase, getDataType, getDbms, getName, getSourceColumn, isAggregate
abs, aggregate, append, as, as, asc, avg, ceiling, cmp, coalesce, concat, concat, convertTo, convertTo, count, countDistinct, day, decode, decode, decode, decode, decode, decode, decodeEnum, decodeSort, desc, divideBy, floor, format, function, getAttribute, getBeanPropertyName, getControlType, getExprFromPhrase, getExprFromPhrase, getJavaType, getOptions, getTitle, in, in, in, indexOf, indexOf, indexOf, is, isBetween, isGreaterThan, isLessOrEqual, isMoreOrEqual, isNot, isNotBetween, isSmallerThan, length, like, like, likeLower, likeUpper, lower, max, min, minus, minus, modulo, month, multiplyWith, notIn, notIn, notIn, notLike, nvl, on, parenthesis, plus, plus, qualified, replace, reverse, round, setAttribute, setBeanPropertyName, setControlType, setOptions, setTitle, stringAgg, stringAgg, substring, substring, substring, substring, substring, substring, sum, toChar, toChar, toString, trim, trimLeft, trimRight, trunc, upper, when, year
checkParamNull
public DBDecodeExpr(DBColumnExpr expr, Map<?,?> valueMap, Object elseExpr, DataType dataType)
expr
- the expression to be decodedvalueMap
- a map of keys and values used for decodingelseExpr
- the expression returned if the condition is false (may be null)dataType
- the target data typeprotected String getFunctionName()
DBAbstractFuncExpr
getFunctionName
in class DBAbstractFuncExpr
public DBColumn getUpdateColumn()
DBAbstractFuncExpr
getUpdateColumn
in class DBAbstractFuncExpr
public Class<Enum<?>> getEnumType()
DBAbstractFuncExpr
getEnumType
in interface ColumnExpr
getEnumType
in class DBAbstractFuncExpr
public void addReferencedColumns(Set<DBColumn> list)
DBExpr
addReferencedColumns
in class DBAbstractFuncExpr
list
- list to which all used column expressions must be addedDBExpr.addReferencedColumns(Set)
public void addSQL(DBSQLBuilder sql, long context)
DBExpr
public void addDecodeParts(DBSQLBuilder sql)
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.