Struct diesel::sqlite::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:.

Implementations

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 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 Send for SqliteConnection

impl SimpleConnection for SqliteConnection

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

Execute multiple SQL statements within the same string.

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.