class SQLiteConnection extends Connection (View source)
DetectsLostConnections |
void | __construct(PDO $pdo, string $database = '', string $tablePrefix = '', array $config = array()) Create a new database connection instance. | from Connection |
void | useDefaultQueryGrammar() Set the query grammar to the default implementation. | from Connection |
void | useDefaultSchemaGrammar() Set the schema grammar to the default implementation. | from Connection |
void | useDefaultPostProcessor() Set the query post processor to the default implementation. | from Connection |
Builder | getSchemaBuilder() Get a schema builder instance for the connection. | from Connection |
Builder | table(string $table) Begin a fluent query against a database table. | from Connection |
Builder | query() Get a new query builder instance. | from Connection |
Expression | raw(mixed $value) Get a new raw query expression. | from Connection |
mixed | selectOne(string $query, array $bindings = array()) Run a select statement and return a single result. | from Connection |
array | selectFromWriteConnection(string $query, array $bindings = array()) Run a select statement against the database. | from Connection |
array | select(string $query, array $bindings = array(), bool $useReadPdo = true) Run a select statement against the database. | from Connection |
bool | insert(string $query, array $bindings = array()) Run an insert statement against the database. | from Connection |
int | update(string $query, array $bindings = array()) Run an update statement against the database. | from Connection |
int | delete(string $query, array $bindings = array()) Run a delete statement against the database. | from Connection |
bool | statement(string $query, array $bindings = array()) Execute an SQL statement and return the boolean result. | from Connection |
int | affectingStatement(string $query, array $bindings = array()) Run an SQL statement and get the number of rows affected. | from Connection |
bool | unprepared(string $query) Run a raw, unprepared query against the PDO connection. | from Connection |
array | prepareBindings(array $bindings) Prepare the query bindings for execution. | from Connection |
mixed | transaction(Closure $callback) Execute a Closure within a transaction. | from Connection |
void | beginTransaction() Start a new database transaction. | from Connection |
void | commit() Commit the active database transaction. | from Connection |
void | rollBack() Rollback the active database transaction. | from Connection |
int | transactionLevel() Get the number of active transactions. | from Connection |
array | pretend(Closure $callback) Execute the given callback in "dry run" mode. | from Connection |
void | disconnect() Disconnect from the underlying PDO connection. | from Connection |
void | reconnect() Reconnect to the database. | from Connection |
void | logQuery(string $query, array $bindings, float|null $time = null) Log a query in the connection's query log. | from Connection |
void | listen(Closure $callback) Register a database query listener with the connection. | from Connection |
bool | isDoctrineAvailable() Is Doctrine available? | from Connection |
Column | getDoctrineColumn(string $table, string $column) Get a Doctrine Schema Column instance. | from Connection |
AbstractSchemaManager | getDoctrineSchemaManager() Get the Doctrine DBAL schema manager for the connection. | from Connection |
Connection | getDoctrineConnection() Get the Doctrine DBAL database connection instance. | from Connection |
PDO | getPdo() Get the current PDO connection. | from Connection |
PDO | getReadPdo() Get the current PDO connection used for reading. | from Connection |
$this | setPdo(PDO|null $pdo) Set the PDO connection. | from Connection |
$this | setReadPdo(PDO|null $pdo) Set the PDO connection used for reading. | from Connection |
$this | setReconnector(callable $reconnector) Set the reconnect instance on the connection. | from Connection |
string|null | getName() Get the database connection name. | from Connection |
mixed | getConfig(string $option) Get an option from the configuration options. | from Connection |
string | getDriverName() Get the PDO driver name. | from Connection |
Grammar | getQueryGrammar() Get the query grammar used by the connection. | from Connection |
void | setQueryGrammar(Grammar $grammar) Set the query grammar used by the connection. | from Connection |
Grammar | getSchemaGrammar() Get the schema grammar used by the connection. | from Connection |
void | setSchemaGrammar(Grammar $grammar) Set the schema grammar used by the connection. | from Connection |
Processor | getPostProcessor() Get the query post processor used by the connection. | from Connection |
void | setPostProcessor(Processor $processor) Set the query post processor used by the connection. | from Connection |
Dispatcher | getEventDispatcher() Get the event dispatcher used by the connection. | from Connection |
void | setEventDispatcher(Dispatcher $events) Set the event dispatcher instance on the connection. | from Connection |
bool | pretending() Determine if the connection in a "dry run". | from Connection |
int | getFetchMode() Get the default fetch mode for the connection. | from Connection |
int | setFetchMode(int $fetchMode) Set the default fetch mode for the connection. | from Connection |
array | getQueryLog() Get the connection query log. | from Connection |
void | flushQueryLog() Clear the query log. | from Connection |
void | enableQueryLog() Enable the query log on the connection. | from Connection |
void | disableQueryLog() Disable the query log on the connection. | from Connection |
bool | logging() Determine whether we're logging queries. | from Connection |
string | getDatabaseName() Get the name of the connected database. | from Connection |
string | setDatabaseName(string $database) Set the name of the connected database. | from Connection |
string | getTablePrefix() Get the table prefix for the connection. | from Connection |
void | setTablePrefix(string $prefix) Set the table prefix in use by the connection. | from Connection |
Grammar | withTablePrefix(Grammar $grammar) Set the table prefix and return the grammar. | from Connection |
Create a new database connection instance.
Set the query grammar to the default implementation.
Set the schema grammar to the default implementation.
Set the query post processor to the default implementation.
Get a schema builder instance for the connection.
Begin a fluent query against a database table.
Get a new query builder instance.
Get a new raw query expression.
Run a select statement and return a single result.
Run a select statement against the database.
Run a select statement against the database.
Run an insert statement against the database.
Run an update statement against the database.
Run a delete statement against the database.
Execute an SQL statement and return the boolean result.
Run an SQL statement and get the number of rows affected.
Run a raw, unprepared query against the PDO connection.
Prepare the query bindings for execution.
Execute a Closure within a transaction.
Start a new database transaction.
Commit the active database transaction.
Rollback the active database transaction.
Get the number of active transactions.
Execute the given callback in "dry run" mode.
Disconnect from the underlying PDO connection.
Reconnect to the database.
Log a query in the connection's query log.
Register a database query listener with the connection.
Is Doctrine available?
Get a Doctrine Schema Column instance.
Get the Doctrine DBAL schema manager for the connection.
Get the Doctrine DBAL database connection instance.
Get the current PDO connection.
Get the current PDO connection used for reading.
Set the PDO connection.
Set the PDO connection used for reading.
Set the reconnect instance on the connection.
Get the database connection name.
Get an option from the configuration options.
Get the PDO driver name.
Get the query grammar used by the connection.
Set the query grammar used by the connection.
Get the schema grammar used by the connection.
Set the schema grammar used by the connection.
Get the query post processor used by the connection.
Set the query post processor used by the connection.
Get the event dispatcher used by the connection.
Set the event dispatcher instance on the connection.
Determine if the connection in a "dry run".
Get the default fetch mode for the connection.
Set the default fetch mode for the connection.
Get the connection query log.
Clear the query log.
Enable the query log on the connection.
Disable the query log on the connection.
Determine whether we're logging queries.
Get the name of the connected database.
Set the name of the connected database.
Get the table prefix for the connection.
Set the table prefix in use by the connection.
© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.3/Illuminate/Database/SQLiteConnection.html