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