Package org.apache.empire.dbms.postgresql

Class PostgresIntervalExpr

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBColumnExpr

org.apache.empire.dbms.postgresql.PostgresIntervalExpr

All Implemented Interfaces:

ColumnExpr

public class PostgresIntervalExpr
extends DBColumnExpr

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	PostgresIntervalExpr.PostgresIntervalUnitField

Field Summary

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
PostgresIntervalExpr(DBDatabase db, int quantity, PostgresIntervalExpr.PostgresIntervalUnitField unit)

Method Summary

Modifier and Type	Method	Description
PostgresIntervalExpr	add(int quantity, PostgresIntervalExpr.PostgresIntervalUnitField unit)
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.
Element	addXml(Element parent, long flags)	Add a description of this column with relevant metadata to the supplied parent XML Element.
final DBDatabase	getDatabase()	Returns the database object to which this object belongs to.
DataType	getDataType()	Returns the data type of this column expression.
Class<Enum<?>>	getEnumType()	Returns the enum type for this column
String	getName()	Returns the column name for this column expression.
DBRowSet	getRowSet()	Returns the underlying rowset containing this column For functions involving none or more than one physical column this function return the first one
DBColumn	getUpdateColumn()	Returns the underlying physical column.
boolean	isAggregate()	Indicates whether this function is an aggregate (sum, min, max, avg, ...) or not

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, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

PostgresIntervalExpr

public PostgresIntervalExpr(DBDatabase db,
 int quantity,
 PostgresIntervalExpr.PostgresIntervalUnitField unit)

Method Details

getDatabase

public final DBDatabase getDatabase()

Description copied from class: DBObject

Returns the database object to which this object belongs to. For the database object itself this function will return the this pointer.

Specified by:

getDatabase in class DBObject

Returns:

the database object

getDataType

public DataType getDataType()

Description copied from class: DBColumnExpr

Returns the data type of this column expression.

Specified by:

getDataType in interface ColumnExpr

Specified by:

getDataType in class DBColumnExpr

Returns:

the expressions data type

See Also:

• DataType

getEnumType

public Class<Enum<?>> getEnumType()

Description copied from interface: ColumnExpr

Returns the enum type for this column

Returns:

the enum type

getName

public String getName()

Description copied from class: DBColumnExpr

Returns the column name for this column expression. The name must contain only alphanumeric characters and the underscore. For SQL functions this name may be generated. However subsequent calls to this function for the same object instance must return the same string.

Specified by:

getName in interface ColumnExpr

Specified by:

getName in class DBColumnExpr

Returns:

the column name

getRowSet

public DBRowSet getRowSet()

Description copied from class: DBColumnExpr

Returns the underlying rowset containing this column For functions involving none or more than one physical column this function return the first one

Specified by:

getRowSet in class DBColumnExpr

Returns:

a column used for this expression

getUpdateColumn

public DBColumn getUpdateColumn()

Description copied from class: DBColumnExpr

Returns the underlying physical column. For functions involving none or more than one physical column this function returns null.

Specified by:

getUpdateColumn in interface ColumnExpr

Specified by:

getUpdateColumn in class DBColumnExpr

Returns:

the underlying column

isAggregate

public boolean isAggregate()

Description copied from class: DBColumnExpr

Indicates whether this function is an aggregate (sum, min, max, avg, ...) or not

Specified by:

isAggregate in class DBColumnExpr

Returns:

true if the column expression represents an aggregate

addXml

public Element addXml(Element parent,
 long flags)

Description copied from class: DBColumnExpr

Add a description of this column with relevant metadata to the supplied parent XML Element.

Specified by:

addXml in class DBColumnExpr

Parameters:

parent - the parent element to which to append the column description

flags - currently not used

Returns:

the newly created child element

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).

add

public PostgresIntervalExpr add(int quantity,
 PostgresIntervalExpr.PostgresIntervalUnitField unit)

addReferencedColumns

public void addReferencedColumns(Set<DBColumn> list)

Description copied from class: DBExpr

Internal function to obtain all DBColumnExpr-objects used by this expression.

Specified by:

addReferencedColumns in class DBExpr

Parameters:

list - list to which all used column expressions must be added