ConnectionInterface
interface ConnectionInterface (View source)
Methods
Get a new raw query expression.
Run a select statement and return a single result.
Run a select statement and return the first column of the first row.
Run a select statement against the database.
Run a select statement against the database and returns a generator.
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.
Start a new database transaction.
Commit the active database transaction.
Rollback the active database transaction.
Get the number of active transactions.
Get the name of the connected database.
Details
Builder
table(Closure|Builder|string $table, string|null $as = null)
Begin a fluent query against a database table.
Expression
raw(mixed $value)
Get a new raw query expression.
mixed
selectOne(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement and return a single result.
mixed
scalar(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement and return the first column of the first row.
array
select(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement against the database.
Generator
cursor(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement against the database and returns a generator.
bool
insert(string $query, array $bindings = [])
Run an insert statement against the database.
int
update(string $query, array $bindings = [])
Run an update statement against the database.
int
delete(string $query, array $bindings = [])
Run a delete statement against the database.
bool
statement(string $query, array $bindings = [])
Execute an SQL statement and return the boolean result.
int
affectingStatement(string $query, array $bindings = [])
Run an SQL statement and get the number of rows affected.
bool
unprepared(string $query)
Run a raw, unprepared query against the PDO connection.
array
prepareBindings(array $bindings)
Prepare the query bindings for execution.
mixed
transaction(Closure $callback, int $attempts = 1)
Execute a Closure within a transaction.
void
beginTransaction()
Start a new database transaction.
void
commit()
Commit the active database transaction.
void
rollBack()
Rollback the active database transaction.
int
transactionLevel()
Get the number of active transactions.
array
pretend(Closure $callback)
Execute the given callback in "dry run" mode.
string
getDatabaseName()
Get the name of the connected database.