Struct diesel::prelude::SqliteConnection

pub struct SqliteConnection { /* fields omitted */ }

Connections for the SQLite backend. Unlike other backends, "connection URLs" for SQLite are file paths, URIs, or special identifiers like :memory:.

Methods

impl SqliteConnection

pub fn immediate_transaction<T, E, F>(&self, f: F) -> Result<T, E> where     F: FnOnce() -> Result<T, E>,     E: From<Error>,

Run a transaction with BEGIN IMMEDIATE

This method will return an error if a transaction is already open.

Example

conn.immediate_transaction(|| {
    // Do stuff in a transaction
    Ok(())
})

pub fn exclusive_transaction<T, E, F>(&self, f: F) -> Result<T, E> where     F: FnOnce() -> Result<T, E>,     E: From<Error>,

Run a transaction with BEGIN EXCLUSIVE

This method will return an error if a transaction is already open.

Example

conn.exclusive_transaction(|| {
    // Do stuff in a transaction
    Ok(())
})

Trait Implementations

impl SimpleConnection for SqliteConnection

fn batch_execute(&self, query: &str) -> QueryResult<()>

Execute multiple SQL statements within the same string.

impl Connection for SqliteConnection

type Backend = Sqlite

The backend this type connects to

type TransactionManager = AnsiTransactionManager

fn establish(database_url: &str) -> ConnectionResult<Self>

Establishes a new connection to the database

fn transaction<T, E, F>(&self, f: F) -> Result<T, E> where     F: FnOnce() -> Result<T, E>,     E: From<Error>,

Executes the given function inside of a database transaction

fn begin_test_transaction(&self) -> QueryResult<()>

Creates a transaction that will never be committed. This is useful for tests. Panics if called while inside of a transaction.

fn test_transaction<T, E, F>(&self, f: F) -> T where     F: FnOnce() -> Result<T, E>,     E: Debug,

Executes the given function inside a transaction, but does not commit it. Panics if the given function returns an error.

impl<'a, T, U, Op> ExecuteDsl<SqliteConnection, <SqliteConnection as Connection>::Backend> for InsertStatement<T, &'a [U], Op> where     &'a U: Insertable<T>,     InsertStatement<T, <&'a U as Insertable<T>>::Values, Op>: QueryFragment<Sqlite>,     T: Copy,     Op: Copy,

fn execute(query: Self, conn: &SqliteConnection) -> QueryResult<usize>

Execute this command

impl<'a, T, U, Op> ExecuteDsl<SqliteConnection, <SqliteConnection as Connection>::Backend> for InsertStatement<T, BatchInsert<'a, U, T>, Op> where     InsertStatement<T, &'a [U], Op>: ExecuteDsl<SqliteConnection>,

fn execute(query: Self, conn: &SqliteConnection) -> QueryResult<usize>

Execute this command

impl<T, U, Op> ExecuteDsl<SqliteConnection, <SqliteConnection as Connection>::Backend> for InsertStatement<T, OwnedBatchInsert<ValuesClause<U, T>, T>, Op> where     InsertStatement<T, ValuesClause<U, T>, Op>: QueryFragment<Sqlite>,     T: Copy,     Op: Copy,

fn execute(query: Self, conn: &SqliteConnection) -> QueryResult<usize>

Execute this command

impl<Changes, Output> UpdateAndFetchResults<Changes, Output> for SqliteConnection where     Changes: Copy + Identifiable,     Changes: AsChangeset<Target = <Changes as HasTable>::Table> + IntoUpdateTarget,     Changes::Table: FindDsl<Changes::Id>,     Update<Changes, Changes>: ExecuteDsl<SqliteConnection>,     Find<Changes::Table, Changes::Id>: LoadQuery<SqliteConnection, Output>,

fn update_and_fetch(&self, changeset: Changes) -> QueryResult<Output>

See the traits documentation.

impl Send for SqliteConnection