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 | $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.
Should we try to reestablish the connection?
Binds parameter to the prepared statement.
Executes the prepared query and returns TRUE on success or FALSE on failure.
Executes the query and returns TRUE on success or FALSE on failure.
Executes the query and return number of affected rows.
Returns the value of the first column of the first row of the result set.
Executes a SELECT query and returns an array containing the values of the indicated 0-indexed column.
Executes a SELECT query and returns an array where the first column is used as keys and the second as values.
Returns the first row of the result set.
Returns an array containing all of the result set rows.
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 161
__construct(string $name, string $queryCompiler, string $queryBuilderHelper, array $config)
Constructor.
in Connection at line 197
close()
Closes the database connection.
in Connection at line 207
bool
supportsTransactionalDDL()
Does the connection support transactional DDL?
in Connection at line 217
string
getName()
Returns the connection name.
in Connection at line 227
HelperInterface
getQueryBuilderHelper()
Returns a query builder helper instance.
in Connection at line 240
Compiler
getQueryCompiler(Query $query)
Returns a query compiler instance.
in Connection at line 252
PDO
getPDO()
Returns the PDO instance.
in Connection at line 260
enableLog()
Enables the query log.
in Connection at line 268
disableLog()
Disables the query log.
in Connection at line 278
protected array
getConnectionOptions()
Returns the connection options.
in Connection at line 295
protected PDO
connect()
Creates a PDO instance.
in Connection at line 323
reconnect()
Creates a new PDO instance.
in Connection at line 333
bool
isAlive()
Checks if the connection is alive.
in Connection at line 354
protected string
prepareQueryForLog(string $query, array $params)
Prepares query for logging.
in Connection at line 394
protected
log(string $query, array $params, float $start)
Adds a query to the query log.
in Connection at line 406
clearLog()
Clears the query log.
in Connection at line 416
array
getLog()
Returns the query log for the connection.
in Connection at line 428
protected array
prepareQueryAndParams(string $query, array $params)
Prepare query and params.
in Connection at line 459
protected bool
isConnectionLostAndShouldItBeReestablished()
Should we try to reestablish the connection?
in Connection at line 471
protected
bindParameter(PDOStatement $statement, int $key, mixed $value)
Binds parameter to the prepared statement.
in Connection at line 514
protected array
prepare(string $query, array $params)
Prepares a query.
in Connection at line 558
protected bool
execute(array $prepared)
Executes the prepared query and returns TRUE on success or FALSE on failure.
in Connection at line 582
bool
query(string $query, array $params = [])
Executes the query and returns TRUE on success or FALSE on failure.
in Connection at line 594
int
queryAndCount(string $query, array $params = [])
Executes the query and return number of affected rows.
in Connection at line 610
mixed
column(string $query, array $params = [])
Returns the value of the first column of the first row of the result set.
in Connection at line 626
array
columns(string $query, array $params = [])
Executes a SELECT query and returns an array containing the values of the indicated 0-indexed column.
in Connection at line 638
array
pairs(string $query, array $params = [])
Executes a SELECT query and returns an array where the first column is used as keys and the second as values.
in Connection at line 651
mixed
first(string $query, array $params = [], mixed ...$fetchMode)
Returns the first row of the result set.
in Connection at line 673
array
all(string $query, array $params = [], mixed ...$fetchMode)
Returns an array containing all of the result set rows.
in Connection at line 690
Generator
yield(string $query, array $params = [], mixed ...$fetchMode)
Returns a generator that lets you iterate over the results.
in Connection at line 719
Query
builder()
Returns a query builder instance.
in Connection at line 730
Query
table(string|Closure|Subquery|Raw $table)
Returns a query builder instance where we have already chosen the table we want to query.
in Connection at line 740
protected bool
createSavepoint()
Creates a new savepoint.
in Connection at line 750
protected bool
rollBackSavepoint()
Rolls back to the previously created savepoint.
in Connection at line 760
bool
beginTransaction()
Begin a transaction.
in Connection at line 775
bool
commitTransaction()
Commits a transaction.
in Connection at line 790
bool
rollBackTransaction()
Roll back a transaction.
in Connection at line 816
int
getTransactionNestingLevel()
Returns the transaction nesting level.
in Connection at line 826
bool
inTransaction()
Returns TRUE if we're in a transaction and FALSE if not.
in Connection at line 837
mixed
transaction(Closure $queries)
Executes queries and rolls back the transaction if any of them fail.