|
Class TOracleCommandBuilder
TOracleCommandBuilder provides specifics methods to create limit/offset query
commands for Oracle database.
-
TComponent
-
TDbCommandBuilder
-
TOracleCommandBuilder
Methods summary
public
string
|
#
getSearchExpression( array $fields, string $keywords )
Overrides parent implementation. Only column of type text or character (and
its variants) accepts the LIKE criteria.
Overrides parent implementation. Only column of type text or character (and
its variants) accepts the LIKE criteria.
Parameters
- $fields
array list of column id for potential search condition.
- $keywords
string string of keywords
Returns
string SQL search condition matching on a set of columns.
Overrides
|
protected
boolean
|
#
isSearchableColumn( mixed $column )
Returns
boolean true if column can be used for LIKE searching.
|
public
string
|
#
applyLimitOffset( string $sql, integer $limit = -1, integer $offset = -1 )
Overrides parent implementation to use Oracle way of get paginated RecordSet
instead of using LIMIT sql clause.
Overrides parent implementation to use Oracle way of get paginated RecordSet
instead of using LIMIT sql clause.
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 in Oracle way.
Overrides
|
Methods inherited from TDbCommandBuilder
__construct(),
applyCriterias(),
applyOrdering(),
bindArrayValues(),
bindColumnValues(),
createCommand(),
createCountCommand(),
createDeleteCommand(),
createFindCommand(),
createInsertCommand(),
createUpdateCommand(),
getColumnBindings(),
getDbConnection(),
getInsertFieldBindings(),
getLastInsertID(),
getPdoType(),
getSearchCondition(),
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()
|
|