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