PHP 클래스 yajra\Oci8\Oci8Connection

상속: extends Illuminate\Database\Connection
파일 보기 프로젝트 열기: yajra/laravel-oci8 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
$schema string
$sequence Yajra\Oci8\Schema\Sequence
$trigger Yajra\Oci8\Schema\Trigger

공개 메소드들

메소드 설명
__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.

보호된 메소드들

메소드 설명
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.

메소드 상세

__construct() 공개 메소드

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

bindValues() 공개 메소드

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

executeFunction() 공개 메소드

Usage: DB::executeFunction('function_name(:binding_1,:binding_n)', [':binding_1' => 'hi', ':binding_n' => 'bye'], PDO::PARAM_LOB).
저자: 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_*)
리턴 mixed $returnType

executeProcedure() 공개 메소드

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
리턴 array

getConfigSchemaPrefix() 보호된 메소드

Get config schema prefix.
protected getConfigSchemaPrefix ( ) : string
리턴 string

getDefaultPostProcessor() 보호된 메소드

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

getDefaultQueryGrammar() 보호된 메소드

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

getDefaultSchemaGrammar() 보호된 메소드

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

getDoctrineConnection() 공개 메소드

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

getDoctrineDriver() 보호된 메소드

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

getSchema() 공개 메소드

Get current schema.
public getSchema ( ) : string
리턴 string

getSchemaBuilder() 공개 메소드

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

getSequence() 공개 메소드

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

getTrigger() 공개 메소드

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

setDateFormat() 공개 메소드

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

setSchema() 공개 메소드

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

setSequence() 공개 메소드

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

setSessionVars() 공개 메소드

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

setTrigger() 공개 메소드

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

table() 공개 메소드

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

withSchemaPrefix() 공개 메소드

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

withTablePrefix() 공개 메소드

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

프로퍼티 상세

$schema 보호되어 있는 프로퍼티

protected string $schema
리턴 string

$sequence 보호되어 있는 프로퍼티

protected Sequence,Yajra\Oci8\Schema $sequence
리턴 Yajra\Oci8\Schema\Sequence

$trigger 보호되어 있는 프로퍼티

protected Trigger,Yajra\Oci8\Schema $trigger
리턴 Yajra\Oci8\Schema\Trigger