org.apache.empire.db.sqlite

Class DBDatabaseDriverSQLite.DBCommandSQLite

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.sqlite.DBDatabaseDriverSQLite.DBCommandSQLite

All Implemented Interfaces:

Serializable, Cloneable

Enclosing class:

DBDatabaseDriverSQLite

public static class DBDatabaseDriverSQLite.DBCommandSQLite
extends DBCommand

Defines the SQLite 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 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
DBDatabaseDriverSQLite.DBCommandSQLite(DBDatabase db)

Method Summary

Methods

Modifier and Type	Method and Description
void	addJoins(List<DBJoinExpr> joinExprList) Adds a list of join expressions to the command.
DBJoinExpr	join(DBColumnExpr left, DBColumnExpr right, DBJoinType joinType) Adds a join based on two columns to the list of join expressions.

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

addFrom, addGrouping, 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, getSelect, getSelectExprList, getUpdate, getWhereConstraints, groupBy, hasConstraintOn, hasJoinOn, hasJoinOn, hasSelectExpr, hasSetExprOn, hasWhereConstraints, having, isPreparedStatementsEnabled, isSelectDistinct, isValid, isValidQuery, isValidUpdate, 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, clearLimit, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getSelect, intersect, limitRows, orderBy, orderBy, orderBy, skipRows, 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

Constructor Detail

DBDatabaseDriverSQLite.DBCommandSQLite

public DBDatabaseDriverSQLite.DBCommandSQLite(DBDatabase db)

Parameters:

db - the database

See Also:

DBCommand

Method Detail

join

public DBJoinExpr join(DBColumnExpr left,
              DBColumnExpr right,
              DBJoinType joinType)

Description copied from class: DBCommand

Adds a join based on two columns to the list of join expressions.

Overrides:

join in class DBCommand

Parameters:

left - the left join value

right - the right join

joinType - type of join (DBJoinType.INNER, DBJoinType.LEFT, DBJoinType.RIGHT)

Returns:

the join expression

addJoins

public void addJoins(List<DBJoinExpr> joinExprList)

Description copied from class: DBCommand

Adds a list of join expressions to the command.

Overrides:

addJoins in class DBCommand

Parameters:

joinExprList - list of join expressions