org.apache.empire.db.postgresql

Class DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBCommandExpr

org.apache.empire.db.DBCommand

org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

All Implemented Interfaces:

Serializable, Cloneable

Enclosing class:

DBDatabaseDriverPostgreSQL

public static class DBDatabaseDriverPostgreSQL.DBCommandPostreSQL
extends DBCommand

Defines the PostgreSQL command type.

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.empire.db.DBCommandExpr

DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery

Field Summary

Fields

Modifier and Type	Field and Description
protected int	limit
protected int	skip

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

cmdParams, groupBy, having, joins, log, select, selectDistinct, set, where

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

cmdQuery, orderBy

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

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE

Constructor Summary

Constructors

Constructor and Description
DBDatabaseDriverPostgreSQL.DBCommandPostreSQL(DBDatabase db)

Method Summary

Methods

Modifier and Type	Method and Description
void	clearLimit() Clears a limit or offset set by calling limit() or offset()
void	getSelect(StringBuilder buf)
void	limitRows(int numRows) set the maximum number of rows to return when executing a query command A negative value will remove the limit.
void	skipRows(int numRows) sets the offset of the first row to return when executing a query command.

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

addFrom, addGrouping, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addWhere, addWhere, addWhereConstraints, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, getDatabase, getDelete, getInsert, getJoins, getParamValues, getRowSetList, getSelectExprList, getUpdate, getWhereConstraints, groupBy, hasConstraintOn, hasJoinOn, hasJoinOn, hasSelectExpr, hasSetExprOn, hasWhereConstraints, having, isPreparedStatementsEnabled, isSelectDistinct, isValid, isValidQuery, isValidUpdate, join, join, join, join, join, notifyParamUsage, removeConstraintOn, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeWhereConstraintOn, resetParamUsage, select, select, select, selectDistinct, set, setConstraint, useCmdParam, where

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

addListExpr, addSQL, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getSelect, intersect, orderBy, orderBy, orderBy, union

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

getObjectValue, getValueClass

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

limit

protected int limit

skip

protected int skip

Constructor Detail

DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

public DBDatabaseDriverPostgreSQL.DBCommandPostreSQL(DBDatabase db)

Method Detail

limitRows

public void limitRows(int numRows)

Description copied from class: DBCommandExpr

set the maximum number of rows to return when executing a query command A negative value will remove the limit.

Overrides:

limitRows in class DBCommandExpr

skipRows

public void skipRows(int numRows)

Description copied from class: DBCommandExpr

sets the offset of the first row to return when executing a query command. A negative value will remove the offset.

Overrides:

skipRows in class DBCommandExpr

clearLimit

public void clearLimit()

Description copied from class: DBCommandExpr

Clears a limit or offset set by calling limit() or offset()

Overrides:

clearLimit in class DBCommandExpr

getSelect

public void getSelect(StringBuilder buf)

Overrides:

getSelect in class DBCommand