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, logattributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, optionsCTX_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, getRowSet, isAggregateabs, 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, getSourceColumn, 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, prepend, 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, yearcheckParamNullpublic 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()
DBAbstractFuncExprgetFunctionName in class DBAbstractFuncExprpublic DBColumn getUpdateColumn()
DBAbstractFuncExprgetUpdateColumn in interface ColumnExprgetUpdateColumn in class DBAbstractFuncExprpublic Class<Enum<?>> getEnumType()
DBAbstractFuncExprgetEnumType in interface ColumnExprgetEnumType in class DBAbstractFuncExprpublic void addReferencedColumns(Set<DBColumn> list)
DBExpraddReferencedColumns in class DBAbstractFuncExprlist - list to which all used column expressions must be addedDBExpr.addReferencedColumns(Set)public void addSQL(DBSQLBuilder sql, long context)
DBExprpublic void addDecodeParts(DBSQLBuilder sql)
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.