Package org.apache.empire.dbms.sqlite

Class DBMSHandlerSQLite.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.dbms.sqlite.DBMSHandlerSQLite.DBCommandSQLite

All Implemented Interfaces:

Cloneable

Enclosing class:

DBMSHandlerSQLite

public static class DBMSHandlerSQLite.DBCommandSQLite
extends DBCommand

Defines the SQLite command type.

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

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

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

cmdQuery, orderBy, SF_DEFAULT, SF_SKIP_FROM, SF_SKIP_GROUP, SF_SKIP_LIMIT, SF_SKIP_ORDER, SF_SKIP_SELECT, SF_SKIP_WHERE

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
DBCommandSQLite(DBMSHandlerSQLite dmbs, boolean autoPrepareStmt)

Method Summary

Modifier and Type	Method	Description
void	addJoins(List<DBJoinExpr> joinExprList)	Adds a list of join expressions to the command.
DBMSHandlerSQLite.DBCommandSQLite	join(DBJoinExpr join)	Adds a join to the list of join expressions.

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

addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addKeyConstraints, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addUpdateForTable, addUpdateWithJoins, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, createSQLBuilder, findConstraintOn, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getParams, getParamValues, getRowSetList, getSelect, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, joinLeft, joinLeft, joinRight, joinRight, limitRows, orderBy, orderBy, orderBy, orderByUpper, orderByUpper, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, selectSetExpressions, selectSetExpressions, set, set, setConstraint, setParentTables, skipRows, useCmdParam, where, where

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

addListExpr, addSQL, clearLimit, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, getSelect, hasOrderBy, intersect, not, notEmpty, result, union, unionAll

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

checkParamNull

Methods inherited from class java.lang.Object

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

Constructor Details

DBCommandSQLite

public DBCommandSQLite(DBMSHandlerSQLite dmbs,
 boolean autoPrepareStmt)

Parameters:

dmbs - the SQLLite database handler

autoPrepareStmt - flag whether to automatically prepare statements

See Also:

• DBCommand

Method Details

join

public DBMSHandlerSQLite.DBCommandSQLite join(DBJoinExpr join)

Description copied from class: DBCommand

Adds a join to the list of join expressions.

Overrides:

join in class DBCommand

Parameters:

join - the join expression

Returns:

itself (this)

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