|
Class TPgsqlCommandBuilder
TPgsqlCommandBuilder provides specifics methods to create limit/offset query
commands for Pgsql database.
-
TComponent
-
TDbCommandBuilder
-
TPgsqlCommandBuilder
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.
|
protected
string
|
#
getSearchCondition( string $column, array $words )
Overrides parent implementation to use PostgreSQL's ILIKE instead of LIKE
(case-sensitive).
Overrides parent implementation to use PostgreSQL's ILIKE instead of LIKE
(case-sensitive).
Parameters
- $column
string column name.
- $words
array keywords
Returns
string search condition for all words in one column.
Overrides
|
Methods inherited from TDbCommandBuilder
__construct(),
applyCriterias(),
applyLimitOffset(),
applyOrdering(),
bindArrayValues(),
bindColumnValues(),
createCommand(),
createCountCommand(),
createDeleteCommand(),
createFindCommand(),
createInsertCommand(),
createUpdateCommand(),
getColumnBindings(),
getDbConnection(),
getInsertFieldBindings(),
getLastInsertID(),
getPdoType(),
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()
|
|