[][src]Struct diesel::pg::TransactionBuilder

#[must_use = "Transaction builder does nothing unless you call `run` on it"]
pub struct TransactionBuilder<'a> { /* fields omitted */ }

Used to build a transaction, specifying additional details.

This struct is returned by .build_transaction. See the documentation for methods on this struct for usage examples. See the PostgreSQL documentation for SET TRANSACTION for details on the behavior of each option.

Methods

impl<'a> TransactionBuilder<'a>[src]

pub fn read_only(self) -> Self[src]

Makes the transaction READ ONLY

Example

conn.build_transaction()
    .read_only()
    .run::<_, diesel::result::Error, _>(|| {
        let read_attempt = users.select(name).load::<String>(&conn);
        assert!(read_attempt.is_ok());

        let write_attempt = diesel::insert_into(users)
            .values(name.eq("Ruby"))
            .execute(&conn);
        assert!(write_attempt.is_err());

        Ok(())
    })?;

pub fn read_write(self) -> Self[src]

Makes the transaction READ WRITE

This is the default, unless you've changed the default_transaction_read_only configuration parameter.

Example

conn.build_transaction()
    .read_write()
    .run(|| {
        let read_attempt = users.select(name).load::<String>(&conn);
        assert!(read_attempt.is_ok());

        let write_attempt = diesel::insert_into(users)
            .values(name.eq("Ruby"))
            .execute(&conn);
        assert!(write_attempt.is_ok());

        Ok(())
    })

pub fn deferrable(self) -> Self[src]

Makes the transaction DEFERRABLE

Example

conn.build_transaction()
    .deferrable()
    .run(|| Ok(()))

pub fn not_deferrable(self) -> Self[src]

Makes the transaction NOT DEFERRABLE

This is the default, unless you've changed the default_transaction_deferrable configuration parameter.

Example

conn.build_transaction()
    .not_deferrable()
    .run(|| Ok(()))

pub fn read_committed(self) -> Self[src]

Makes the transaction ISOLATION LEVEL READ COMMITTED

This is the default, unless you've changed the default_transaction_isolation_level configuration parameter.

Example

conn.build_transaction()
    .read_committed()
    .run(|| Ok(()))

pub fn repeatable_read(self) -> Self[src]

Makes the transaction ISOLATION LEVEL REPEATABLE READ

Example

conn.build_transaction()
    .repeatable_read()
    .run(|| Ok(()))

pub fn serializable(self) -> Self[src]

Makes the transaction ISOLATION LEVEL SERIALIZABLE

Example

conn.build_transaction()
    .serializable()
    .run(|| Ok(()))

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

Runs the given function inside of the transaction with the parameters given to this builder.

Returns an error if the connection is already inside a transaction.

Trait Implementations

impl<'a> QueryFragment<Pg> for TransactionBuilder<'a>[src]

fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>[src]

Converts this QueryFragment to its SQL representation. Read more

fn collect_binds(
    &self,
    out: &mut DB::BindCollector,
    metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>
[src]

Serializes all bind parameters in this query. Read more

fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>[src]

Is this query safe to store in the prepared statement cache? Read more

impl<'a> Clone for TransactionBuilder<'a>[src]

fn clone_from(&mut self, source: &Self)1.0.0[src]

Performs copy-assignment from source. Read more

impl<'a> Copy for TransactionBuilder<'a>[src]

Auto Trait Implementations

impl<'a> Unpin for TransactionBuilder<'a>

impl<'a> !Sync for TransactionBuilder<'a>

impl<'a> !Send for TransactionBuilder<'a>

impl<'a> !UnwindSafe for TransactionBuilder<'a>

impl<'a> !RefUnwindSafe for TransactionBuilder<'a>

Blanket Implementations

impl<T> IntoSql for T[src]

fn into_sql<T>(self) -> AsExprOf<Self, T> where
    Self: AsExpression<T> + Sized
[src]

Convert self to an expression for Diesel's query builder. Read more

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where
    &'a Self: AsExpression<T>, 
[src]

Convert &self to an expression for Diesel's query builder. Read more

impl<T> From<T> for T[src]

impl<T> ToOwned for T where
    T: Clone
[src]

type Owned = T

The resulting type after obtaining ownership.

impl<T, U> Into<U> for T where
    U: From<T>, 
[src]

impl<T, U> TryFrom<U> for T where
    U: Into<T>, 
[src]

type Error = Infallible

The type returned in the event of a conversion error.

impl<T, U> TryInto<U> for T where
    U: TryFrom<T>, 
[src]

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.

impl<T> BorrowMut<T> for T where
    T: ?Sized
[src]

impl<T> Borrow<T> for T where
    T: ?Sized
[src]

impl<T> Any for T where
    T: 'static + ?Sized
[src]