Struct diesel::prelude::SqliteConnection

pub struct SqliteConnection { /* fields omitted */ }

Connections for the SQLite backend. Unlike other backends, "connection URLs" for SQLite are file paths 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<'a, T, U, Op> ExecuteDsl<SqliteConnection> 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> 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 Send for SqliteConnection

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.