Package org.apache.empire.db.expr.column

Class DBConvertExpr

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBColumnExpr

org.apache.empire.db.expr.column.DBAbstractFuncExpr

org.apache.empire.db.expr.column.DBConvertExpr

All Implemented Interfaces:

ColumnExpr, DBPreparable

public class DBConvertExpr
extends DBAbstractFuncExpr

This class is used to convert a value to a different data type. This function uses the DBMSHandler.getConvertPhrase function to obtain a conversion template.

There is no need to explicitly create instances of this class.
Instead use DBColumnExpr.convertTo(DataType)

Author:

doebele

Field Summary

Fields inherited from class org.apache.empire.db.expr.column.DBAbstractFuncExpr

dataType, expr, isAggregate, log

Fields inherited from class org.apache.empire.db.DBColumnExpr

attributes, beanPropertyName, options

Fields inherited from class org.apache.empire.db.DBExpr

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE

Constructor Summary

Constructors

Constructor	Description
DBConvertExpr(DBColumnExpr expr, DataType dataType, Object format)	Constructs a DBDecodeExpr

Method Summary

Modifier and Type	Method	Description
void	addSQL(DBSQLBuilder sql, long context)	Used to build the SQL command.
protected String	getFunctionName()	returns the name of the function

Methods inherited from class org.apache.empire.db.expr.column.DBAbstractFuncExpr

addReferencedColumns, addSQL, addXml, equals, getDatabase, getDataType, getDbms, getEnumType, getName, getRowSet, getUpdateColumn, isAggregate, prepareParams

Methods inherited from class org.apache.empire.db.DBColumnExpr

abs, aggregate, append, as, as, asc, avg, ceiling, cmp, coalesce, concat, concat, contains, convertTo, convertTo, count, countDistinct, day, decode, decode, decode, decode, decode, decode, decodeEnum, decodeSort, desc, divideBy, floor, format, function, getAttribute, getAttribute, getBeanPropertyName, getControlType, getDefaultSortOrder, getExprFromPhrase, getExprFromPhrase, getIgnoreCaseExpr, getJavaType, getNumberType, getOptions, getSourceColumn, getTitle, in, in, in, indexOf, indexOf, indexOf, is, isBetween, isCaseSensitive, isGreaterThan, isLessOrEqual, isLiteralValue, isMoreOrEqual, isNot, isNotBetween, isSmallerThan, length, like, like, likeLower, likeUpper, lower, max, min, minus, minus, modulo, month, multiplyWith, notContains, notIn, notIn, notIn, notLike, nvl, on, parenthesis, plus, plus, prepend, qualified, replace, reverse, round, setAttribute, setBeanPropertyName, setControlType, setDefaultSortOrder, setOptions, setTitle, stringAgg, stringAgg, substring, substring, substring, substring, substring, substring, sum, toChar, toChar, toString, trim, trimLeft, trimRight, trunc, upper, when, year

Methods inherited from class org.apache.empire.db.DBObject

checkParamNull

Methods inherited from class java.lang.Object

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

Constructor Details

DBConvertExpr

public DBConvertExpr(DBColumnExpr expr,
 DataType dataType,
 Object format)

Constructs a DBDecodeExpr

Parameters:

expr - the expression to be converted

dataType - the target data type

format - optional formatting information

Method Details

getFunctionName

protected String getFunctionName()

Description copied from class: DBAbstractFuncExpr

returns the name of the function

Specified by:

getFunctionName in class DBAbstractFuncExpr

Returns:

the function name

addSQL

public void addSQL(DBSQLBuilder sql,
 long context)

Description copied from class: DBExpr

Used to build the SQL command. SQL for this expression must be appended to StringBuilder.

Specified by:

addSQL in class DBExpr

Parameters:

sql - the string buffer used to build the sql command

context - context flag for this SQL-Command (see CTX_??? constants).