## 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