PHP Class yajra\Oci8\Oci8Connection

Inheritance: extends Illuminate\Database\Connection
Show file Open project: yajra/laravel-oci8 Class Usage Examples

Protected Properties

Property Type Description
$schema string
$sequence Yajra\Oci8\Schema\Sequence
$trigger Yajra\Oci8\Schema\Trigger

Public Methods

Method Description
__construct ( PD\PDO | Closure $pdo, string $database = '', string $tablePrefix = '', array $config = [] )
bindValues ( PDOStatement $statement, array $bindings ) Bind values to their parameters in the given statement.
executeFunction ( string $sql, array $bindings = [], integer $returnType = PDO::PARAM_STR ) : mixed Execute a PL/SQL Function and return its value.
executeProcedure ( string $procedureName, array $bindings, mixed $returnType = PDO::PARAM_STMT ) : array Execute a PL/SQL Procedure and return its result.
getDoctrineConnection ( ) : Doctrine\DBAL\Connection Get doctrine connection.
getSchema ( ) : string Get current schema.
getSchemaBuilder ( ) : OracleBuilder Get a schema builder instance for the connection.
getSequence ( ) : Sequence Get sequence class.
getTrigger ( ) : Trigger Get oracle trigger class.
setDateFormat ( string $format = 'YYYY-MM-DD HH24:MI:SS' ) Set oracle session date format.
setSchema ( string $schema ) Set current schema.
setSequence ( Sequence $sequence ) : Sequence Set sequence class.
setSessionVars ( array $sessionVars ) Update oracle session variables.
setTrigger ( Trigger $trigger ) : Trigger Set oracle trigger class.
table ( string $table ) : OracleBuilder Begin a fluent query against a database table.
withSchemaPrefix ( Illuminate\Database\Grammar $grammar ) : Illuminate\Database\Grammar Set the schema prefix and return the grammar.
withTablePrefix ( Illuminate\Database\Grammar $grammar ) : Illuminate\Database\Grammar Set the table prefix and return the grammar.

Protected Methods

Method Description
getConfigSchemaPrefix ( ) : string Get config schema prefix.
getDefaultPostProcessor ( ) : OracleProcessor Get the default post processor instance.
getDefaultQueryGrammar ( ) : Illuminate\Database\Grammar | OracleGrammar Get the default query grammar instance.
getDefaultSchemaGrammar ( ) : Illuminate\Database\Grammar | OracleGrammar Get the default schema grammar instance.
getDoctrineDriver ( ) : Doctrine\DBAL\Driver\OCI8\Driver Get doctrine driver.

Method Details

__construct() public method

public __construct ( PD\PDO | Closure $pdo, string $database = '', string $tablePrefix = '', array $config = [] )
$pdo PD\PDO | Closure
$database string
$tablePrefix string
$config array

bindValues() public method

Bind values to their parameters in the given statement.
public bindValues ( PDOStatement $statement, array $bindings )
$statement PDOStatement
$bindings array

executeFunction() public method

Usage: DB::executeFunction('function_name(:binding_1,:binding_n)', [':binding_1' => 'hi', ':binding_n' => 'bye'], PDO::PARAM_LOB).
Author: Tylerian - [email protected]
public executeFunction ( string $sql, array $bindings = [], integer $returnType = PDO::PARAM_STR ) : mixed
$sql string (mixed)
$bindings array (kvp array)
$returnType integer (PDO::PARAM_*)
return mixed $returnType

executeProcedure() public method

Usage: DB::executeProcedure($procedureName, $bindings). $bindings looks like: $bindings = [ 'p_userid' => $id ];
public executeProcedure ( string $procedureName, array $bindings, mixed $returnType = PDO::PARAM_STMT ) : array
$procedureName string
$bindings array
$returnType mixed
return array

getConfigSchemaPrefix() protected method

Get config schema prefix.
protected getConfigSchemaPrefix ( ) : string
return string

getDefaultPostProcessor() protected method

Get the default post processor instance.
protected getDefaultPostProcessor ( ) : OracleProcessor
return yajra\Oci8\Query\Processors\OracleProcessor

getDefaultQueryGrammar() protected method

Get the default query grammar instance.
protected getDefaultQueryGrammar ( ) : Illuminate\Database\Grammar | OracleGrammar
return Illuminate\Database\Grammar | yajra\Oci8\Query\Grammars\OracleGrammar

getDefaultSchemaGrammar() protected method

Get the default schema grammar instance.
protected getDefaultSchemaGrammar ( ) : Illuminate\Database\Grammar | OracleGrammar
return Illuminate\Database\Grammar | Yajra\Oci8\Schema\Grammars\OracleGrammar

getDoctrineConnection() public method

Get doctrine connection.
public getDoctrineConnection ( ) : Doctrine\DBAL\Connection
return Doctrine\DBAL\Connection

getDoctrineDriver() protected method

Get doctrine driver.
protected getDoctrineDriver ( ) : Doctrine\DBAL\Driver\OCI8\Driver
return Doctrine\DBAL\Driver\OCI8\Driver

getSchema() public method

Get current schema.
public getSchema ( ) : string
return string

getSchemaBuilder() public method

Get a schema builder instance for the connection.
public getSchemaBuilder ( ) : OracleBuilder
return Yajra\Oci8\Schema\OracleBuilder

getSequence() public method

Get sequence class.
public getSequence ( ) : Sequence
return Yajra\Oci8\Schema\Sequence

getTrigger() public method

Get oracle trigger class.
public getTrigger ( ) : Trigger
return Yajra\Oci8\Schema\Trigger

setDateFormat() public method

Set oracle session date format.
public setDateFormat ( string $format = 'YYYY-MM-DD HH24:MI:SS' )
$format string

setSchema() public method

Set current schema.
public setSchema ( string $schema )
$schema string

setSequence() public method

Set sequence class.
public setSequence ( Sequence $sequence ) : Sequence
$sequence Yajra\Oci8\Schema\Sequence
return Yajra\Oci8\Schema\Sequence

setSessionVars() public method

Update oracle session variables.
public setSessionVars ( array $sessionVars )
$sessionVars array

setTrigger() public method

Set oracle trigger class.
public setTrigger ( Trigger $trigger ) : Trigger
$trigger Yajra\Oci8\Schema\Trigger
return Yajra\Oci8\Schema\Trigger

table() public method

Begin a fluent query against a database table.
public table ( string $table ) : OracleBuilder
$table string
return yajra\Oci8\Query\OracleBuilder

withSchemaPrefix() public method

Set the schema prefix and return the grammar.
public withSchemaPrefix ( Illuminate\Database\Grammar $grammar ) : Illuminate\Database\Grammar
$grammar Illuminate\Database\Grammar
return Illuminate\Database\Grammar

withTablePrefix() public method

Set the table prefix and return the grammar.
public withTablePrefix ( Illuminate\Database\Grammar $grammar ) : Illuminate\Database\Grammar
$grammar Illuminate\Database\Grammar
return Illuminate\Database\Grammar

Property Details

$schema protected property

protected string $schema
return string

$sequence protected property

protected Sequence,Yajra\Oci8\Schema $sequence
return Yajra\Oci8\Schema\Sequence

$trigger protected property

protected Trigger,Yajra\Oci8\Schema $trigger
return Yajra\Oci8\Schema\Trigger