Zeta Components - high quality PHP components

Zeta Components Manual :: Docs For Class ezcDbHandlerOracle

Database::ezcDbHandlerOracle

Class ezcDbHandlerOracle

Oracle driver implementation

Source for this file: /Database/src/handlers/oracle.php

PDO
   |
   --ezcDbHandler
      |
      --ezcDbHandlerOracle

Version:

//autogentag//

Inherited Member Variables

From ezcDbHandler
protected	`ezcDbHandler::$identifierQuoteChars`
protected	`ezcDbHandler::$transactionErrorFlag`
protected	`ezcDbHandler::$transactionNestingLevel`

Method Summary

public static string	`getName( )` Returns 'oracle'.
public ezcDbHandlerOracle	`__construct( $dbParams )` Constructs a handler object from the parameters $dbParams.
public ezcQueryExpressionPgsql	`createExpression( )` Returns a new ezcQueryExpression derived object with Oracle implementation specifics.
public ezcQuerySelectOracle	`createSelectQuery( )` Returns a new ezcQuerySelect derived object with Oracle implementation specifics.
public ezcUtilitiesOracle	`createUtilities( )` Returns a new ezcUtilities derived object with Oracle implementation specifics.
protected string	`processLimitOffset( $queryString , $limit , $offset )` Returns an SQL query with LIMIT/OFFSET functionality appended.
public string	`quote( $str , [ $paramStr = PDO::PARAM_STR] )` Returns $str quoted for the Oracle database.

Inherited Methods

From ezcDbHandler
public ezcDbHandler	`ezcDbHandler::__construct()` Constructs a handler object.
public bool	`ezcDbHandler::beginTransaction()` Begins a transaction.
public bool	`ezcDbHandler::commit()` Commits a transaction.
public ezcQueryDelete	`ezcDbHandler::createDeleteQuery()` Returns a new ezcQueryDelete derived object for the correct database type.
public ezcQueryExpression	`ezcDbHandler::createExpression()` Returns a new ezcQueryExpression derived object for the correct database type.
public ezcQueryInsert	`ezcDbHandler::createInsertQuery()` Returns a new ezcQueryInsert derived object for the correct database type.
public ezcQuerySelect	`ezcDbHandler::createSelectQuery()` Returns a new ezcQuerySelect derived object for the correct database type.
public ezcQueryUpdate	`ezcDbHandler::createUpdateQuery()` Returns a new ezcQueryUpdate derived object for the correct database type.
public ezcDbUtilities	`ezcDbHandler::createUtilities()` Returns a new ezcUtilities derived object for the correct database type.
public string	`ezcDbHandler::quoteIdentifier()` Returns the quoted version of an identifier to be used in an SQL query.
public bool	`ezcDbHandler::rollback()` Rollback a transaction.

Methods

getName

static string getName( )

Returns 'oracle'.

__construct

ezcDbHandlerOracle __construct( array $dbParams )

Constructs a handler object from the parameters $dbParams.

Supported database parameters are:

dbname|database: Database name
user|username: Database user name
pass|password: Database user password
charset: Client character set

Parameters:

Name	Type	Description
`$dbParams`	array	Database connection parameters (key=>value pairs).

Exceptions:

Type	Description
`ezcDbMissingParameterException`	if the database name was not specified.

Redefinition of:

Method	Description
`ezcDbHandler::__construct()`	Constructs a handler object.

createExpression

ezcQueryExpressionPgsql createExpression( )

Returns a new ezcQueryExpression derived object with Oracle implementation specifics.

Redefinition of:

Method	Description
`ezcDbHandler::createExpression()`	Returns a new ezcQueryExpression derived object for the correct database type.

createSelectQuery

ezcQuerySelectOracle createSelectQuery( )

Returns a new ezcQuerySelect derived object with Oracle implementation specifics.

Redefinition of:

Method	Description
`ezcDbHandler::createSelectQuery()`	Returns a new ezcQuerySelect derived object for the correct database type.

createUtilities

ezcUtilitiesOracle createUtilities( )

Returns a new ezcUtilities derived object with Oracle implementation specifics.

Redefinition of:

Method	Description
`ezcDbHandler::createUtilities()`	Returns a new ezcUtilities derived object for the correct database type.

processLimitOffset

string processLimitOffset( string $queryString , int $limit , int $offset )

Returns an SQL query with LIMIT/OFFSET functionality appended.

The LIMIT/OFFSET is added to $queryString. $limit controls the maximum number of entries in the resultset. $offset controls where in the resultset results should be returned from.

Parameters:

Name	Type	Description
`$queryString`	string
`$limit`	int
`$offset`	int

quote

string quote( string $str , [int $paramStr = PDO::PARAM_STR] )

Returns $str quoted for the Oracle database.

Reimplemented from PDO since PDO is broken using Oracle8.

Parameters:

Name	Type	Description
`$str`	string
`$paramStr`	int

Documentation generated by phpDocumentor 1.4.3