PHP Class Dibi\Drivers\OracleDriver

Driver options: - database => the name of the local Oracle instance or the name of the entry in tnsnames.ora - username (or user) - password (or pass) - charset => character encoding to set - schema => alters session schema - formatDate => how to format date in SQL (@see date) - formatDateTime => how to format datetime in SQL (@see date) - resource (resource) => existing connection resource - persistent => Creates persistent connections with oci_pconnect instead of oci_new_connect - lazy, profiler, result, substitutes, ... => see Dibi\Connection options
Inheritance: implements Dibi\Driver, implements Dibi\ResultDriver, implements Dibi\Reflector, use trait Dibi\Strict
Show file Open project: dg/dibi Class Usage Examples

Public Methods

Method Description
__construct ( )
__destruct ( ) : void Automatically frees the resources allocated for this result set.
applyLimit ( &$sql, $limit, $offset ) : void Injects LIMIT/OFFSET to the SQL query.
begin ( $savepoint = NULL ) : void Begins a transaction (if supported).
commit ( $savepoint = NULL ) : void Commits statements in a transaction.
connect ( array &$config ) : void Connects to a database.
createException ( $message, $code, $sql ) : Dibi\DriverException
createResultDriver ( $resource ) : Dibi\ResultDriver Result set driver factory.
disconnect ( ) : void Disconnects from a database.
escape ( $value, $type )
escapeBinary ( $value )
escapeBool ( $value )
escapeDate ( $value )
escapeDateTime ( $value )
escapeIdentifier ( $value )
escapeLike ( $value, $pos ) : string Encodes string for use in a LIKE statement.
escapeText ( $value ) : string Encodes data for use in a SQL statement.
fetch ( $assoc ) : array Fetches the row at current position and moves the internal cursor to the next position.
free ( ) : void Frees the resources allocated for this result set.
getAffectedRows ( ) : integer | FALSE Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
getColumns ( $table ) : array Returns metadata for all columns in a table.
getForeignKeys ( $table ) : array Returns metadata for all foreign keys in a table.
getIndexes ( $table ) : array Returns metadata for all indexes in a table.
getInsertId ( $sequence ) : integer | FALSE Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
getReflector ( ) : Dibi\Reflector Returns the connection reflector.
getResource ( ) : mixed Returns the connection resource.
getResultColumns ( ) : array Returns metadata for all columns in a result set.
getResultResource ( ) : mixed Returns the result set resource.
getRowCount ( ) : integer Returns the number of rows in a result set.
getTables ( ) : array Returns list of tables.
query ( $sql ) : Dibi\ResultDriver | null Executes the SQL query.
rollback ( $savepoint = NULL ) : void Rollback changes in a transaction.
seek ( $row ) : boolean Moves cursor position without fetching row.
unescapeBinary ( $value ) : string Decodes data from result set.

Method Details

__construct() public method

public __construct ( )

__destruct() public method

Automatically frees the resources allocated for this result set.
public __destruct ( ) : void
return void

applyLimit() public method

Injects LIMIT/OFFSET to the SQL query.
public applyLimit ( &$sql, $limit, $offset ) : void
return void

begin() public method

Begins a transaction (if supported).
public begin ( $savepoint = NULL ) : void
return void

commit() public method

Commits statements in a transaction.
public commit ( $savepoint = NULL ) : void
return void

connect() public method

Connects to a database.
public connect ( array &$config ) : void
$config array
return void

createException() public static method

public static createException ( $message, $code, $sql ) : Dibi\DriverException
return Dibi\DriverException

createResultDriver() public method

Result set driver factory.
public createResultDriver ( $resource ) : Dibi\ResultDriver
return Dibi\ResultDriver

disconnect() public method

Disconnects from a database.
public disconnect ( ) : void
return void

escape() public method

Deprecation:
public escape ( $value, $type )

escapeBinary() public method

public escapeBinary ( $value )

escapeBool() public method

public escapeBool ( $value )

escapeDate() public method

public escapeDate ( $value )

escapeDateTime() public method

public escapeDateTime ( $value )

escapeIdentifier() public method

public escapeIdentifier ( $value )

escapeLike() public method

Encodes string for use in a LIKE statement.
public escapeLike ( $value, $pos ) : string
return string

escapeText() public method

Encodes data for use in a SQL statement.
public escapeText ( $value ) : string
return string encoded value

fetch() public method

Fetches the row at current position and moves the internal cursor to the next position.
public fetch ( $assoc ) : array
return array array on success, nonarray if no next record

free() public method

Frees the resources allocated for this result set.
public free ( ) : void
return void

getAffectedRows() public method

Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
public getAffectedRows ( ) : integer | FALSE
return integer | FALSE number of rows or FALSE on error

getColumns() public method

Returns metadata for all columns in a table.
public getColumns ( $table ) : array
return array

getForeignKeys() public method

Returns metadata for all foreign keys in a table.
public getForeignKeys ( $table ) : array
return array

getIndexes() public method

Returns metadata for all indexes in a table.
public getIndexes ( $table ) : array
return array

getInsertId() public method

Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
public getInsertId ( $sequence ) : integer | FALSE
return integer | FALSE int on success or FALSE on failure

getReflector() public method

Returns the connection reflector.
public getReflector ( ) : Dibi\Reflector
return Dibi\Reflector

getResource() public method

Returns the connection resource.
public getResource ( ) : mixed
return mixed

getResultColumns() public method

Returns metadata for all columns in a result set.
public getResultColumns ( ) : array
return array

getResultResource() public method

Returns the result set resource.
public getResultResource ( ) : mixed
return mixed

getRowCount() public method

Returns the number of rows in a result set.
public getRowCount ( ) : integer
return integer

getTables() public method

Returns list of tables.
public getTables ( ) : array
return array

query() public method

Executes the SQL query.
public query ( $sql ) : Dibi\ResultDriver | null
return Dibi\ResultDriver | null

rollback() public method

Rollback changes in a transaction.
public rollback ( $savepoint = NULL ) : void
return void

seek() public method

Moves cursor position without fetching row.
public seek ( $row ) : boolean
return boolean TRUE on success, FALSE if unable to seek to specified record

unescapeBinary() public method

Decodes data from result set.
public unescapeBinary ( $value ) : string
return string