PRADO Component Framework for PHP 5
  • Home
  • About
  • Testimonials
  • Demos
  • Download
  • Documentation
  • Forum
  • Development
  • Tutorials
  • Class Docs
  • API Manual
  • Wiki

Packages

  • None
  • System
    • Caching
    • Collections
    • Data
      • ActiveRecord
        • Relations
        • Scaffold
          • InputBuilder
      • Commom
        • Sqlite
      • Common
        • Mssql
        • Mysql
        • Oracle
        • Pgsql
        • Sqlite
      • DataGateway
      • SqlMap
        • Configuration
        • Statements
    • Exceptions
    • I18N
    • IO
    • Security
    • Util
    • Web
      • Javascripts
      • Services
      • UI
        • ActiveControls
        • WebControls
    • Xml
  • Wsat
    • pages
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo

Class TPgsqlCommandBuilder

TPgsqlCommandBuilder provides specifics methods to create limit/offset query commands for Pgsql database.

TComponent
Extended by TDbCommandBuilder
Extended by TPgsqlCommandBuilder
Package: System\Data\Common
Copyright: Copyright © 2005-2014 PradoSoft
License: http://www.pradosoft.com/license/
Author: Wei Zhuo <weizho[at]gmail[dot]com>
Since: 3.1
Located at Data/Common/Pgsql/TPgsqlCommandBuilder.php
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

TDbCommandBuilder::getSearchExpression()
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

TDbCommandBuilder::getSearchCondition()
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()
Constants inherited from TComponent
GLOBAL_RAISE_EVENT_LISTENER
Terms of Service | Contact Us
PRADO v3.2.4 API Manual API documentation generated by ApiGen 2.8.0
Copyright © 2006-2014 by the PRADO Group.
Powered by PRADO