PHP Class yajra\Oci8\Oci8Connection

Inheritance: extends Illuminate\Database\Connection
Afficher le fichier Open project: yajra/laravel-oci8 Class Usage Examples

Protected Properties

Свойство Type Description
$schema string
$sequence Yajra\Oci8\Schema\Sequence
$trigger Yajra\Oci8\Schema\Trigger

Méthodes publiques

Méthode 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.

Méthodes protégées

Méthode 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 méthode

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

bindValues() public méthode

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

executeFunction() public méthode

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_*)
Résultat mixed $returnType

executeProcedure() public méthode

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
Résultat array

getConfigSchemaPrefix() protected méthode

Get config schema prefix.
protected getConfigSchemaPrefix ( ) : string
Résultat string

getDefaultPostProcessor() protected méthode

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

getDefaultQueryGrammar() protected méthode

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

getDefaultSchemaGrammar() protected méthode

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

getDoctrineConnection() public méthode

Get doctrine connection.
public getDoctrineConnection ( ) : Doctrine\DBAL\Connection
Résultat Doctrine\DBAL\Connection

getDoctrineDriver() protected méthode

Get doctrine driver.
protected getDoctrineDriver ( ) : Doctrine\DBAL\Driver\OCI8\Driver
Résultat Doctrine\DBAL\Driver\OCI8\Driver

getSchema() public méthode

Get current schema.
public getSchema ( ) : string
Résultat string

getSchemaBuilder() public méthode

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

getSequence() public méthode

Get sequence class.
public getSequence ( ) : Sequence
Résultat Yajra\Oci8\Schema\Sequence

getTrigger() public méthode

Get oracle trigger class.
public getTrigger ( ) : Trigger
Résultat Yajra\Oci8\Schema\Trigger

setDateFormat() public méthode

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

setSchema() public méthode

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

setSequence() public méthode

Set sequence class.
public setSequence ( Sequence $sequence ) : Sequence
$sequence Yajra\Oci8\Schema\Sequence
Résultat Yajra\Oci8\Schema\Sequence

setSessionVars() public méthode

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

setTrigger() public méthode

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

table() public méthode

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

withSchemaPrefix() public méthode

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

withTablePrefix() public méthode

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

Property Details

$schema protected_oe property

protected string $schema
Résultat string

$sequence protected_oe property

protected Sequence,Yajra\Oci8\Schema $sequence
Résultat Yajra\Oci8\Schema\Sequence

$trigger protected_oe property

protected Trigger,Yajra\Oci8\Schema $trigger
Résultat Yajra\Oci8\Schema\Trigger