|
Class TSqliteCommandBuilder
TSqliteCommandBuilder provides specifics methods to create limit/offset query
commands for Sqlite database.
-
TComponent
-
TDbCommandBuilder
-
TSqliteCommandBuilder
Methods summary
public
string
|
#
applyLimitOffset( string $sql, integer $limit = -1, integer $offset = -1 )
Alters the sql to apply $limit and $offset.
Alters the sql to apply $limit and $offset.
Parameters
- $sql
string SQL query string.
- $limit
integer maximum number of rows, -1 to ignore limit.
- $offset
integer row offset, -1 to ignore offset.
Returns
string SQL with limit and offset.
Overrides
|
Methods inherited from TDbCommandBuilder
__construct(),
applyCriterias(),
applyOrdering(),
bindArrayValues(),
bindColumnValues(),
createCommand(),
createCountCommand(),
createDeleteCommand(),
createFindCommand(),
createInsertCommand(),
createUpdateCommand(),
getColumnBindings(),
getDbConnection(),
getInsertFieldBindings(),
getLastInsertID(),
getPdoType(),
getSearchCondition(),
getSearchExpression(),
getSelectFieldList(),
getTableInfo(),
hasIntegerKey(),
setDbConnection(),
setTableInfo()
|
Methods inherited from TComponent
__call(),
__destruct(),
__get(),
__isset(),
__set(),
__sleep(),
__unset(),
__wakeup(),
addParsedObject(),
asa(),
attachBehavior(),
attachBehaviors(),
attachClassBehavior(),
attachEventHandler(),
canGetProperty(),
canSetProperty(),
clearBehaviors(),
createdOnTemplate(),
detachBehavior(),
detachBehaviors(),
detachClassBehavior(),
detachEventHandler(),
disableBehavior(),
disableBehaviors(),
enableBehavior(),
enableBehaviors(),
evaluateExpression(),
evaluateStatements(),
fxAttachClassBehavior(),
fxDetachClassBehavior(),
getAutoGlobalListen(),
getBehaviorsEnabled(),
getClassHierarchy(),
getEventHandlers(),
getListeningToGlobalEvents(),
getSubProperty(),
hasEvent(),
hasEventHandler(),
hasProperty(),
isa(),
listen(),
raiseEvent(),
setSubProperty(),
unlisten()
|
|