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|null | $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.
Reset the log and transaction nesting level and create a new PDO instance when cloning the connection.
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 or NULL if nothing is found.
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 or NULL if nothing is found.
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 158
__construct(string $name, string $queryCompiler, string $queryBuilderHelper, array $config)
Constructor.
at line 194
__clone()
Reset the log and transaction nesting level and create a new PDO instance when cloning the connection.
at line 208
close()
Closes the database connection.
at line 218
bool
supportsTransactionalDDL()
Does the connection support transactional DDL?
at line 228
string
getName()
Returns the connection name.
at line 238
HelperInterface
getQueryBuilderHelper()
Returns a query builder helper instance.
at line 263
PDO
getPDO()
Returns the PDO instance.
at line 271
enableLog()
Enables the query log.
at line 279
disableLog()
Disables the query log.
at line 289
protected array
getConnectionOptions()
Returns the connection options.
at line 306
protected PDO
connect()
Creates a PDO instance.
at line 334
reconnect()
Creates a new PDO instance.
at line 344
bool
isAlive()
Checks if the connection is alive.
at line 365
protected string
prepareQueryForLog(string $query, array $params)
Prepares query for logging.
at line 401
protected
log(string $query, array $params, float $start)
Adds a query to the query log.
at line 413
clearLog()
Clears the query log.
at line 423
array
getLog()
Returns the query log for the connection.
at line 435
protected array
prepareQueryAndParams(string $query, array $params)
Prepare query and params.
at line 466
protected bool
isConnectionLostAndShouldItBeReestablished()
Should we try to reestablish the connection?
at line 478
protected
bindParameter(PDOStatement $statement, int $key, mixed $value)
Binds parameter to the prepared statement.
at line 518
protected PDOStatement
prepareAndExecute(string $query, array $params, bool|null $success = null)
Prepares and executes a query.
at line 575
bool
query(string $query, array $params = [])
Executes the query and returns TRUE on success or FALSE on failure.
at line 589
int
queryAndCount(string $query, array $params = [])
Executes the query and return number of affected rows.
at line 602
mixed
first(string $query, array $params = [], mixed ...$fetchMode)
Returns the first row of the result set or NULL if nothing is found.
at line 622
array
all(string $query, array $params = [], mixed ...$fetchMode)
Returns an array containing all of the result set rows.
at line 634
mixed
column(string $query, array $params = [])
Returns the value of the first column of the first row of the result set or NULL if nothing is found.
at line 646
array
columns(string $query, array $params = [])
Returns an array containing the values of the indicated 0-indexed column.
at line 658
array
pairs(string $query, array $params = [])
Returns an array where the first column is used as keys and the second as values.
at line 671
Generator
yield(string $query, array $params = [], mixed ...$fetchMode)
Returns a generator that lets you iterate over the results.
at line 698
Query
builder()
Returns a query builder instance.
at line 709
Query
table(array|Closure|Raw|Subquery|string|null $table)
Returns a query builder instance where we have already chosen the table we want to query.
at line 719
protected bool
createSavepoint()
Creates a new savepoint.
at line 729
protected bool
rollBackSavepoint()
Rolls back to the previously created savepoint.
at line 739
bool
beginTransaction()
Begin a transaction.
at line 754
bool
commitTransaction()
Commits a transaction.
at line 769
bool
rollBackTransaction()
Roll back a transaction.
at line 795
int
getTransactionNestingLevel()
Returns the transaction nesting level.
at line 805
bool
inTransaction()
Returns TRUE if we're in a transaction and FALSE if not.
at line 816
mixed
transaction(Closure $queries)
Executes queries and rolls back the transaction if any of them fail.