Connection
class Connection
Database connection.
Properties
protected string | $name | Connection name. | |
protected string. | $queryCompiler | Query compiler. | |
protected string | $queryBuilderHelper | Query builder helper. | |
protected string | $dsn | Connection DSN. | |
protected string | $username | Database username. | |
protected string | $password | Database password. | |
protected bool | $enableLog | Enable the query log? | |
protected bool | $reconnect | Should we reconnect? | |
protected bool | $usePersistentConnection | Should we use a persistent connection? | |
protected array | $options | PDO options. | |
protected array | $onConnectQueries | Queries that should be executed upon connecting. | |
protected PDO | $pdo | PDO object. | |
protected int | $transactionNestingLevel | Transaction nesting level. | |
protected array | $log | Query log. | |
protected bool | $supportsTransactionalDDL | Does the connection support transactional DDL? |
Methods
Constructor.
Closes the database connection.
Does the connection support transactional DDL?
Returns the connection name.
Returns a query builder helper instance.
Enables the query log.
Disables the query log.
Returns the connection options.
Creates a new PDO instance.
Checks if the connection is alive.
Prepares query for logging.
Adds a query to the query log.
Clears the query log.
Returns the query log for the connection.
Prepare query and params.
Should we try to reestablish the connection?
Binds parameter to the prepared statement.
Prepares and executes a query.
Executes the query and returns TRUE on success or FALSE on failure.
Executes the query and return number of affected rows.
Returns the first row of the result set.
Returns an array containing all of the result set rows.
Returns the value of the first column of the first row of the result set.
Returns an array containing the values of the indicated 0-indexed column.
Returns an array where the first column is used as keys and the second as values.
Returns a generator that lets you iterate over the results.
Creates a new savepoint.
Rolls back to the previously created savepoint.
Begin a transaction.
Commits a transaction.
Roll back a transaction.
Returns the transaction nesting level.
Returns TRUE if we're in a transaction and FALSE if not.
Details
at line 160
__construct(string $name, string $queryCompiler, string $queryBuilderHelper, array $config)
Constructor.
at line 196
close()
Closes the database connection.
at line 206
bool
supportsTransactionalDDL()
Does the connection support transactional DDL?
at line 216
string
getName()
Returns the connection name.
at line 226
HelperInterface
getQueryBuilderHelper()
Returns a query builder helper instance.
at line 251
PDO
getPDO()
Returns the PDO instance.
at line 259
enableLog()
Enables the query log.
at line 267
disableLog()
Disables the query log.
at line 277
protected array
getConnectionOptions()
Returns the connection options.
at line 294
protected PDO
connect()
Creates a PDO instance.
at line 322
reconnect()
Creates a new PDO instance.
at line 332
bool
isAlive()
Checks if the connection is alive.
at line 353
protected string
prepareQueryForLog(string $query, array $params)
Prepares query for logging.
at line 389
protected
log(string $query, array $params, float $start)
Adds a query to the query log.
at line 401
clearLog()
Clears the query log.
at line 411
array
getLog()
Returns the query log for the connection.
at line 423
protected array
prepareQueryAndParams(string $query, array $params)
Prepare query and params.
at line 454
protected bool
isConnectionLostAndShouldItBeReestablished()
Should we try to reestablish the connection?
at line 466
protected
bindParameter(PDOStatement $statement, int $key, mixed $value)
Binds parameter to the prepared statement.
at line 506
protected PDOStatement
prepareAndExecute(string $query, array $params, bool $success = null)
Prepares and executes a query.
at line 563
bool
query(string $query, array $params = [])
Executes the query and returns TRUE on success or FALSE on failure.
at line 577
int
queryAndCount(string $query, array $params = [])
Executes the query and return number of affected rows.
at line 590
mixed|bool
first(string $query, array $params = [], mixed ...$fetchMode)
Returns the first row of the result set.
at line 610
array
all(string $query, array $params = [], mixed ...$fetchMode)
Returns an array containing all of the result set rows.
at line 622
mixed|bool
column(string $query, array $params = [])
Returns the value of the first column of the first row of the result set.
at line 634
array
columns(string $query, array $params = [])
Returns an array containing the values of the indicated 0-indexed column.
at line 646
array
pairs(string $query, array $params = [])
Returns an array where the first column is used as keys and the second as values.
at line 659
Generator
yield(string $query, array $params = [], mixed ...$fetchMode)
Returns a generator that lets you iterate over the results.
at line 686
Query
builder()
Returns a query builder instance.
at line 697
Query
table(string|array|Closure|Subquery|Raw|null $table)
Returns a query builder instance where we have already chosen the table we want to query.
at line 707
protected bool
createSavepoint()
Creates a new savepoint.
at line 717
protected bool
rollBackSavepoint()
Rolls back to the previously created savepoint.
at line 727
bool
beginTransaction()
Begin a transaction.
at line 742
bool
commitTransaction()
Commits a transaction.
at line 757
bool
rollBackTransaction()
Roll back a transaction.
at line 783
int
getTransactionNestingLevel()
Returns the transaction nesting level.
at line 793
bool
inTransaction()
Returns TRUE if we're in a transaction and FALSE if not.
at line 804
mixed
transaction(Closure $queries)
Executes queries and rolls back the transaction if any of them fail.