PHP 클래스 Illuminate\Database\Connection

상속: implements Illuminate\Database\ConnectionInterface, use trait Illuminate\Database\DetectsDeadlocks, use trait Illuminate\Database\DetectsLostConnections
파일 보기 프로젝트 열기: illuminate/database 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
$config array The database connection configuration options.
$database string The name of the connected database.
$doctrineConnection Doctrine\DBAL\Connection The instance of Doctrine connection.
$events Illuminate\Contracts\Events\Dispatcher The event dispatcher instance.
$fetchArgument mixed The argument for the fetch mode.
$fetchConstructorArgument array The constructor arguments for the PDO::FETCH_CLASS fetch mode.
$fetchMode integer The default fetch mode of the connection.
$loggingQueries boolean Indicates whether queries are being logged.
$pdo PDO The active PDO connection.
$postProcessor Illuminate\Database\Query\Processors\Processor The query post processor implementation.
$pretending boolean Indicates if the connection is in a "dry run".
$queryGrammar Illuminate\Database\Query\Grammars\Grammar The query grammar implementation.
$queryLog array All of the queries run against the connection.
$readPdo PDO The active PDO connection used for reads.
$reconnector callable The reconnector instance for the connection.
$schemaGrammar Illuminate\Database\Schema\Grammars\Grammar The schema grammar implementation.
$tablePrefix string The table prefix for the connection.
$transactions integer The number of active transactions.

공개 메소드들

메소드 설명
__construct ( PDO | Closure $pdo, string $database = '', string $tablePrefix = '', array $config = [] ) : void Create a new database connection instance.
affectingStatement ( string $query, array $bindings = [] ) : integer Run an SQL statement and get the number of rows affected.
beginTransaction ( ) : void Start a new database transaction.
bindValues ( PDOStatement $statement, array $bindings ) : void Bind values to their parameters in the given statement.
commit ( ) : void Commit the active database transaction.
cursor ( string $query, array $bindings = [], boolean $useReadPdo = true ) : Generator Run a select statement against the database and returns a generator.
delete ( string $query, array $bindings = [] ) : integer Run a delete statement against the database.
disableQueryLog ( ) : void Disable the query log on the connection.
disconnect ( ) : void Disconnect from the underlying PDO connection.
enableQueryLog ( ) : void Enable the query log on the connection.
flushQueryLog ( ) : void Clear the query log.
getConfig ( string $option ) : mixed Get an option from the configuration options.
getDatabaseName ( ) : string Get the name of the connected database.
getDoctrineColumn ( string $table, string $column ) : Doctrine\DBAL\Schema\Column Get a Doctrine Schema Column instance.
getDoctrineConnection ( ) : Doctrine\DBAL\Connection Get the Doctrine DBAL database connection instance.
getDoctrineSchemaManager ( ) : Doctrine\DBAL\Schema\AbstractSchemaManager Get the Doctrine DBAL schema manager for the connection.
getDriverName ( ) : string Get the PDO driver name.
getEventDispatcher ( ) : Illuminate\Contracts\Events\Dispatcher Get the event dispatcher used by the connection.
getFetchArgument ( ) : mixed Get the fetch argument to be applied when selecting.
getFetchConstructorArgument ( ) : array Get custom constructor arguments for the PDO::FETCH_CLASS fetch mode.
getFetchMode ( ) : integer Get the default fetch mode for the connection.
getName ( ) : string | null Get the database connection name.
getPdo ( ) : PDO Get the current PDO connection.
getPostProcessor ( ) : Illuminate\Database\Query\Processors\Processor Get the query post processor used by the connection.
getQueryGrammar ( ) : Illuminate\Database\Query\Grammars\Grammar Get the query grammar used by the connection.
getQueryLog ( ) : array Get the connection query log.
getReadPdo ( ) : PDO Get the current PDO connection used for reading.
getSchemaBuilder ( ) : Illuminate\Database\Schema\Builder Get a schema builder instance for the connection.
getSchemaGrammar ( ) : Illuminate\Database\Schema\Grammars\Grammar Get the schema grammar used by the connection.
getTablePrefix ( ) : string Get the table prefix for the connection.
insert ( string $query, array $bindings = [] ) : boolean Run an insert statement against the database.
isDoctrineAvailable ( ) : boolean Is Doctrine available?
listen ( Closure $callback ) : void Register a database query listener with the connection.
logQuery ( string $query, array $bindings, float | null $time = null ) : void Log a query in the connection's query log.
logging ( ) : boolean Determine whether we're logging queries.
prepareBindings ( array $bindings ) : array Prepare the query bindings for execution.
pretend ( Closure $callback ) : array Execute the given callback in "dry run" mode.
pretending ( ) : boolean Determine if the connection in a "dry run".
query ( ) : Builder Get a new query builder instance.
raw ( mixed $value ) : Illuminate\Database\Query\Expression Get a new raw query expression.
reconnect ( ) : void Reconnect to the database.
rollBack ( integer | null $toLevel = null ) : void Rollback the active database transaction.
select ( string $query, array $bindings = [], boolean $useReadPdo = true ) : array Run a select statement against the database.
selectFromWriteConnection ( string $query, array $bindings = [] ) : array Run a select statement against the database.
selectOne ( string $query, array $bindings = [] ) : mixed | null Run a select statement and return a single result.
setDatabaseName ( string $database ) : string Set the name of the connected database.
setEventDispatcher ( Illuminate\Contracts\Events\Dispatcher $events ) : void Set the event dispatcher instance on the connection.
setFetchMode ( integer $fetchMode, mixed $fetchArgument = null, array $fetchConstructorArgument = [] ) : integer Set the default fetch mode for the connection, and optional arguments for the given fetch mode.
setPdo ( PDO | null $pdo ) Set the PDO connection.
setPostProcessor ( Illuminate\Database\Query\Processors\Processor $processor ) : void Set the query post processor used by the connection.
setQueryGrammar ( Illuminate\Database\Query\Grammars\Grammar $grammar ) : void Set the query grammar used by the connection.
setReadPdo ( PDO | null $pdo ) Set the PDO connection used for reading.
setReconnector ( callable $reconnector ) Set the reconnect instance on the connection.
setSchemaGrammar ( Illuminate\Database\Schema\Grammars\Grammar $grammar ) : void Set the schema grammar used by the connection.
setTablePrefix ( string $prefix ) : void Set the table prefix in use by the connection.
statement ( string $query, array $bindings = [] ) : boolean Execute an SQL statement and return the boolean result.
table ( string $table ) : Builder Begin a fluent query against a database table.
transaction ( Closure $callback, integer $attempts = 1 ) : mixed Execute a Closure within a transaction.
transactionLevel ( ) : integer Get the number of active transactions.
unprepared ( string $query ) : boolean Run a raw, unprepared query against the PDO connection.
update ( string $query, array $bindings = [] ) : integer Run an update statement against the database.
useDefaultPostProcessor ( ) : void Set the query post processor to the default implementation.
useDefaultQueryGrammar ( ) : void Set the query grammar to the default implementation.
useDefaultSchemaGrammar ( ) : void Set the schema grammar to the default implementation.
withTablePrefix ( Illuminate\Database\Grammar $grammar ) : Illuminate\Database\Grammar Set the table prefix and return the grammar.

보호된 메소드들

메소드 설명
fireConnectionEvent ( string $event ) : void Fire an event for this connection.
getDefaultPostProcessor ( ) : Illuminate\Database\Query\Processors\Processor Get the default post processor instance.
getDefaultQueryGrammar ( ) : Illuminate\Database\Query\Grammars\Grammar Get the default query grammar instance.
getDefaultSchemaGrammar ( ) : Illuminate\Database\Schema\Grammars\Grammar Get the default schema grammar instance.
getElapsedTime ( integer $start ) : float Get the elapsed time since a given starting point.
getPdoForSelect ( boolean $useReadPdo = true ) : PDO Get the PDO connection to use for a select query.
reconnectIfMissingConnection ( ) : void Reconnect to the database if a PDO connection is missing.
run ( string $query, array $bindings, Closure $callback ) : mixed Run a SQL statement and log its execution context.
runQueryCallback ( string $query, array $bindings, Closure $callback ) : mixed Run a SQL statement.
tryAgainIfCausedByLostConnection ( Illuminate\Database\QueryException $e, string $query, array $bindings, Closure $callback ) : mixed Handle a query exception that occurred during query execution.

메소드 상세

__construct() 공개 메소드

Create a new database connection instance.
public __construct ( PDO | Closure $pdo, string $database = '', string $tablePrefix = '', array $config = [] ) : void
$pdo PDO | Closure
$database string
$tablePrefix string
$config array
리턴 void

affectingStatement() 공개 메소드

Run an SQL statement and get the number of rows affected.
public affectingStatement ( string $query, array $bindings = [] ) : integer
$query string
$bindings array
리턴 integer

beginTransaction() 공개 메소드

Start a new database transaction.
public beginTransaction ( ) : void
리턴 void

bindValues() 공개 메소드

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

commit() 공개 메소드

Commit the active database transaction.
public commit ( ) : void
리턴 void

cursor() 공개 메소드

Run a select statement against the database and returns a generator.
public cursor ( string $query, array $bindings = [], boolean $useReadPdo = true ) : Generator
$query string
$bindings array
$useReadPdo boolean
리턴 Generator

delete() 공개 메소드

Run a delete statement against the database.
public delete ( string $query, array $bindings = [] ) : integer
$query string
$bindings array
리턴 integer

disableQueryLog() 공개 메소드

Disable the query log on the connection.
public disableQueryLog ( ) : void
리턴 void

disconnect() 공개 메소드

Disconnect from the underlying PDO connection.
public disconnect ( ) : void
리턴 void

enableQueryLog() 공개 메소드

Enable the query log on the connection.
public enableQueryLog ( ) : void
리턴 void

fireConnectionEvent() 보호된 메소드

Fire an event for this connection.
protected fireConnectionEvent ( string $event ) : void
$event string
리턴 void

flushQueryLog() 공개 메소드

Clear the query log.
public flushQueryLog ( ) : void
리턴 void

getConfig() 공개 메소드

Get an option from the configuration options.
public getConfig ( string $option ) : mixed
$option string
리턴 mixed

getDatabaseName() 공개 메소드

Get the name of the connected database.
public getDatabaseName ( ) : string
리턴 string

getDefaultPostProcessor() 보호된 메소드

Get the default post processor instance.
protected getDefaultPostProcessor ( ) : Illuminate\Database\Query\Processors\Processor
리턴 Illuminate\Database\Query\Processors\Processor

getDefaultQueryGrammar() 보호된 메소드

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

getDefaultSchemaGrammar() 보호된 메소드

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

getDoctrineColumn() 공개 메소드

Get a Doctrine Schema Column instance.
public getDoctrineColumn ( string $table, string $column ) : Doctrine\DBAL\Schema\Column
$table string
$column string
리턴 Doctrine\DBAL\Schema\Column

getDoctrineConnection() 공개 메소드

Get the Doctrine DBAL database connection instance.
public getDoctrineConnection ( ) : Doctrine\DBAL\Connection
리턴 Doctrine\DBAL\Connection

getDoctrineSchemaManager() 공개 메소드

Get the Doctrine DBAL schema manager for the connection.
public getDoctrineSchemaManager ( ) : Doctrine\DBAL\Schema\AbstractSchemaManager
리턴 Doctrine\DBAL\Schema\AbstractSchemaManager

getDriverName() 공개 메소드

Get the PDO driver name.
public getDriverName ( ) : string
리턴 string

getElapsedTime() 보호된 메소드

Get the elapsed time since a given starting point.
protected getElapsedTime ( integer $start ) : float
$start integer
리턴 float

getEventDispatcher() 공개 메소드

Get the event dispatcher used by the connection.
public getEventDispatcher ( ) : Illuminate\Contracts\Events\Dispatcher
리턴 Illuminate\Contracts\Events\Dispatcher

getFetchArgument() 공개 메소드

Get the fetch argument to be applied when selecting.
public getFetchArgument ( ) : mixed
리턴 mixed

getFetchConstructorArgument() 공개 메소드

Get custom constructor arguments for the PDO::FETCH_CLASS fetch mode.

getFetchMode() 공개 메소드

Get the default fetch mode for the connection.
public getFetchMode ( ) : integer
리턴 integer

getName() 공개 메소드

Get the database connection name.
public getName ( ) : string | null
리턴 string | null

getPdo() 공개 메소드

Get the current PDO connection.
public getPdo ( ) : PDO
리턴 PDO

getPdoForSelect() 보호된 메소드

Get the PDO connection to use for a select query.
protected getPdoForSelect ( boolean $useReadPdo = true ) : PDO
$useReadPdo boolean
리턴 PDO

getPostProcessor() 공개 메소드

Get the query post processor used by the connection.
public getPostProcessor ( ) : Illuminate\Database\Query\Processors\Processor
리턴 Illuminate\Database\Query\Processors\Processor

getQueryGrammar() 공개 메소드

Get the query grammar used by the connection.
public getQueryGrammar ( ) : Illuminate\Database\Query\Grammars\Grammar
리턴 Illuminate\Database\Query\Grammars\Grammar

getQueryLog() 공개 메소드

Get the connection query log.
public getQueryLog ( ) : array
리턴 array

getReadPdo() 공개 메소드

Get the current PDO connection used for reading.
public getReadPdo ( ) : PDO
리턴 PDO

getSchemaBuilder() 공개 메소드

Get a schema builder instance for the connection.
public getSchemaBuilder ( ) : Illuminate\Database\Schema\Builder
리턴 Illuminate\Database\Schema\Builder

getSchemaGrammar() 공개 메소드

Get the schema grammar used by the connection.
public getSchemaGrammar ( ) : Illuminate\Database\Schema\Grammars\Grammar
리턴 Illuminate\Database\Schema\Grammars\Grammar

getTablePrefix() 공개 메소드

Get the table prefix for the connection.
public getTablePrefix ( ) : string
리턴 string

insert() 공개 메소드

Run an insert statement against the database.
public insert ( string $query, array $bindings = [] ) : boolean
$query string
$bindings array
리턴 boolean

isDoctrineAvailable() 공개 메소드

Is Doctrine available?
public isDoctrineAvailable ( ) : boolean
리턴 boolean

listen() 공개 메소드

Register a database query listener with the connection.
public listen ( Closure $callback ) : void
$callback Closure
리턴 void

logQuery() 공개 메소드

Log a query in the connection's query log.
public logQuery ( string $query, array $bindings, float | null $time = null ) : void
$query string
$bindings array
$time float | null
리턴 void

logging() 공개 메소드

Determine whether we're logging queries.
public logging ( ) : boolean
리턴 boolean

prepareBindings() 공개 메소드

Prepare the query bindings for execution.
public prepareBindings ( array $bindings ) : array
$bindings array
리턴 array

pretend() 공개 메소드

Execute the given callback in "dry run" mode.
public pretend ( Closure $callback ) : array
$callback Closure
리턴 array

pretending() 공개 메소드

Determine if the connection in a "dry run".
public pretending ( ) : boolean
리턴 boolean

query() 공개 메소드

Get a new query builder instance.
public query ( ) : Builder
리턴 Illuminate\Database\Query\Builder

raw() 공개 메소드

Get a new raw query expression.
public raw ( mixed $value ) : Illuminate\Database\Query\Expression
$value mixed
리턴 Illuminate\Database\Query\Expression

reconnect() 공개 메소드

Reconnect to the database.
public reconnect ( ) : void
리턴 void

reconnectIfMissingConnection() 보호된 메소드

Reconnect to the database if a PDO connection is missing.
protected reconnectIfMissingConnection ( ) : void
리턴 void

rollBack() 공개 메소드

Rollback the active database transaction.
public rollBack ( integer | null $toLevel = null ) : void
$toLevel integer | null
리턴 void

run() 보호된 메소드

Run a SQL statement and log its execution context.
protected run ( string $query, array $bindings, Closure $callback ) : mixed
$query string
$bindings array
$callback Closure
리턴 mixed

runQueryCallback() 보호된 메소드

Run a SQL statement.
protected runQueryCallback ( string $query, array $bindings, Closure $callback ) : mixed
$query string
$bindings array
$callback Closure
리턴 mixed

select() 공개 메소드

Run a select statement against the database.
public select ( string $query, array $bindings = [], boolean $useReadPdo = true ) : array
$query string
$bindings array
$useReadPdo boolean
리턴 array

selectFromWriteConnection() 공개 메소드

Run a select statement against the database.
public selectFromWriteConnection ( string $query, array $bindings = [] ) : array
$query string
$bindings array
리턴 array

selectOne() 공개 메소드

Run a select statement and return a single result.
public selectOne ( string $query, array $bindings = [] ) : mixed | null
$query string
$bindings array
리턴 mixed | null

setDatabaseName() 공개 메소드

Set the name of the connected database.
public setDatabaseName ( string $database ) : string
$database string
리턴 string

setEventDispatcher() 공개 메소드

Set the event dispatcher instance on the connection.
public setEventDispatcher ( Illuminate\Contracts\Events\Dispatcher $events ) : void
$events Illuminate\Contracts\Events\Dispatcher
리턴 void

setFetchMode() 공개 메소드

Set the default fetch mode for the connection, and optional arguments for the given fetch mode.
public setFetchMode ( integer $fetchMode, mixed $fetchArgument = null, array $fetchConstructorArgument = [] ) : integer
$fetchMode integer
$fetchArgument mixed
$fetchConstructorArgument array
리턴 integer

setPdo() 공개 메소드

Set the PDO connection.
public setPdo ( PDO | null $pdo )
$pdo PDO | null

setPostProcessor() 공개 메소드

Set the query post processor used by the connection.
public setPostProcessor ( Illuminate\Database\Query\Processors\Processor $processor ) : void
$processor Illuminate\Database\Query\Processors\Processor
리턴 void

setQueryGrammar() 공개 메소드

Set the query grammar used by the connection.
public setQueryGrammar ( Illuminate\Database\Query\Grammars\Grammar $grammar ) : void
$grammar Illuminate\Database\Query\Grammars\Grammar
리턴 void

setReadPdo() 공개 메소드

Set the PDO connection used for reading.
public setReadPdo ( PDO | null $pdo )
$pdo PDO | null

setReconnector() 공개 메소드

Set the reconnect instance on the connection.
public setReconnector ( callable $reconnector )
$reconnector callable

setSchemaGrammar() 공개 메소드

Set the schema grammar used by the connection.
public setSchemaGrammar ( Illuminate\Database\Schema\Grammars\Grammar $grammar ) : void
$grammar Illuminate\Database\Schema\Grammars\Grammar
리턴 void

setTablePrefix() 공개 메소드

Set the table prefix in use by the connection.
public setTablePrefix ( string $prefix ) : void
$prefix string
리턴 void

statement() 공개 메소드

Execute an SQL statement and return the boolean result.
public statement ( string $query, array $bindings = [] ) : boolean
$query string
$bindings array
리턴 boolean

table() 공개 메소드

Begin a fluent query against a database table.
public table ( string $table ) : Builder
$table string
리턴 Illuminate\Database\Query\Builder

transaction() 공개 메소드

Execute a Closure within a transaction.
public transaction ( Closure $callback, integer $attempts = 1 ) : mixed
$callback Closure
$attempts integer
리턴 mixed

transactionLevel() 공개 메소드

Get the number of active transactions.
public transactionLevel ( ) : integer
리턴 integer

tryAgainIfCausedByLostConnection() 보호된 메소드

Handle a query exception that occurred during query execution.
protected tryAgainIfCausedByLostConnection ( Illuminate\Database\QueryException $e, string $query, array $bindings, Closure $callback ) : mixed
$e Illuminate\Database\QueryException
$query string
$bindings array
$callback Closure
리턴 mixed

unprepared() 공개 메소드

Run a raw, unprepared query against the PDO connection.
public unprepared ( string $query ) : boolean
$query string
리턴 boolean

update() 공개 메소드

Run an update statement against the database.
public update ( string $query, array $bindings = [] ) : integer
$query string
$bindings array
리턴 integer

useDefaultPostProcessor() 공개 메소드

Set the query post processor to the default implementation.
public useDefaultPostProcessor ( ) : void
리턴 void

useDefaultQueryGrammar() 공개 메소드

Set the query grammar to the default implementation.
public useDefaultQueryGrammar ( ) : void
리턴 void

useDefaultSchemaGrammar() 공개 메소드

Set the schema grammar to the default implementation.
public useDefaultSchemaGrammar ( ) : void
리턴 void

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

프로퍼티 상세

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

The database connection configuration options.
protected array $config
리턴 array

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

The name of the connected database.
protected string $database
리턴 string

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

The instance of Doctrine connection.
protected Connection,Doctrine\DBAL $doctrineConnection
리턴 Doctrine\DBAL\Connection

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

The event dispatcher instance.
protected Dispatcher,Illuminate\Contracts\Events $events
리턴 Illuminate\Contracts\Events\Dispatcher

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

The argument for the fetch mode.
protected mixed $fetchArgument
리턴 mixed

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

The constructor arguments for the PDO::FETCH_CLASS fetch mode.
protected array $fetchConstructorArgument
리턴 array

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

The default fetch mode of the connection.
protected int $fetchMode
리턴 integer

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

Indicates whether queries are being logged.
protected bool $loggingQueries
리턴 boolean

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

The active PDO connection.
protected PDO $pdo
리턴 PDO

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

The query post processor implementation.
protected Processor,Illuminate\Database\Query\Processors $postProcessor
리턴 Illuminate\Database\Query\Processors\Processor

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

Indicates if the connection is in a "dry run".
protected bool $pretending
리턴 boolean

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

The query grammar implementation.
protected Grammar,Illuminate\Database\Query\Grammars $queryGrammar
리턴 Illuminate\Database\Query\Grammars\Grammar

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

All of the queries run against the connection.
protected array $queryLog
리턴 array

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

The active PDO connection used for reads.
protected PDO $readPdo
리턴 PDO

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

The reconnector instance for the connection.
protected callable $reconnector
리턴 callable

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

The schema grammar implementation.
protected Grammar,Illuminate\Database\Schema\Grammars $schemaGrammar
리턴 Illuminate\Database\Schema\Grammars\Grammar

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

The table prefix for the connection.
protected string $tablePrefix
리턴 string

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

The number of active transactions.
protected int $transactions
리턴 integer