Class TOracleCommandBuilder

Description

TOracleCommandBuilder provides specifics methods to create limit/offset query commands for Oracle database.

  • since: 3.1
  • version: $Id: TOracleCommandBuilder.php 2428 2008-04-17 22:50:24Z xue $
  • author: Marcos Nobre <marconobre[at]gmail[dot]com>

Located in /Data/Common/Oracle/TOracleCommandBuilder.php (line 25)

TComponent
   |
   --TDbCommandBuilder
      |
      --TOracleCommandBuilder
Method Summary
string applyLimitOffset (string $sql, [integer $limit = -1], [integer $offset = -1])
string getSearchExpression (array $fields, string $keywords)
boolean isSearchableColumn (mixed $column)
Methods
applyLimitOffset (line 77)

Overrides parent implementation to use Oracle way of get paginated RecordSet instead of using LIMIT sql clause.

  • return: SQL with limit and offset in Oracle way.
  • access: public
string applyLimitOffset (string $sql, [integer $limit = -1], [integer $offset = -1])
  • string $sql: SQL query string.
  • integer $limit: maximum number of rows, -1 to ignore limit.
  • integer $offset: row offset, -1 to ignore offset.

Redefinition of:
TDbCommandBuilder::applyLimitOffset()
Alters the sql to apply $limit and $offset. Default implementation is applicable for PostgreSQL, MySQL and SQLite.
getSearchExpression (line 34)

Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.

  • return: SQL search condition matching on a set of columns.
  • access: public
string getSearchExpression (array $fields, string $keywords)
  • array $fields: list of column id for potential search condition.
  • string $keywords: string of keywords

Redefinition of:
TDbCommandBuilder::getSearchExpression()
Computes the SQL condition for search a set of column using regular expression (or LIKE, depending on database implementation) to match a string of keywords (default matches all keywords).
isSearchableColumn (line 46)
  • return: true if column can be used for LIKE searching.
  • access: protected
boolean isSearchableColumn (mixed $column)

Inherited Methods

Inherited From TDbCommandBuilder

TDbCommandBuilder::__construct()
TDbCommandBuilder::applyCriterias()
TDbCommandBuilder::applyLimitOffset()
TDbCommandBuilder::applyOrdering()
TDbCommandBuilder::bindArrayValues()
TDbCommandBuilder::bindColumnValues()
TDbCommandBuilder::createCommand()
TDbCommandBuilder::createCountCommand()
TDbCommandBuilder::createDeleteCommand()
TDbCommandBuilder::createFindCommand()
TDbCommandBuilder::createInsertCommand()
TDbCommandBuilder::createUpdateCommand()
TDbCommandBuilder::getColumnBindings()
TDbCommandBuilder::getDbConnection()
TDbCommandBuilder::getInsertFieldBindings()
TDbCommandBuilder::getLastInsertID()
TDbCommandBuilder::getPdoType()
TDbCommandBuilder::getSearchCondition()
TDbCommandBuilder::getSearchExpression()
TDbCommandBuilder::getTableInfo()
TDbCommandBuilder::hasIntegerKey()
TDbCommandBuilder::setDbConnection()
TDbCommandBuilder::setTableInfo()

Inherited From TComponent

TComponent::addParsedObject()
TComponent::attachEventHandler()
TComponent::canGetProperty()
TComponent::canSetProperty()
TComponent::createdOnTemplate()
TComponent::detachEventHandler()
TComponent::evaluateExpression()
TComponent::evaluateStatements()
TComponent::getEventHandlers()
TComponent::getSubProperty()
TComponent::hasEvent()
TComponent::hasEventHandler()
TComponent::hasProperty()
TComponent::raiseEvent()
TComponent::setSubProperty()
TComponent::__get()
TComponent::__set()

Documentation generated on Mon, 21 Apr 2008 11:35:42 -0400 by phpDocumentor 1.3.0RC4