Struct butane_core::db::Transaction

pub struct Transaction<'c> { /* fields omitted */ }

Database transaction.

Begin a transaction using the BackendConnection transaction method.

Implementations

impl<'c> Transaction<'c>

pub fn commit(mut self: Self) -> Result<()>

Commit the transaction

pub fn rollback(mut self: Self) -> Result<()>

Roll back the transaction. Equivalent to dropping it.

Trait Implementations

impl ConnectionMethods for Transaction<'_>

pub fn execute(&self, sql: &str) -> Result<()>

pub fn query(
    &self,
    table: &'static str,
    columns: &[Column],
    expr: Option<BoolExpr>,
    limit: Option<i32>
) -> Result<RawQueryResult>

pub fn insert_returning_pk(
    &self,
    table: &'static str,
    columns: &[Column],
    pkcol: &Column,
    values: &[SqlVal]
) -> Result<SqlVal>

pub fn insert_only(
    &self,
    table: &'static str,
    columns: &[Column],
    values: &[SqlVal]
) -> Result<()>

Like insert_returning_pk but with no return value

pub fn insert_or_replace(
    &self,
    table: &'static str,
    columns: &[Column],
    pkcol: &Column,
    values: &[SqlVal]
) -> Result<()>

Insert unless there's a conflict on the primary key column, in which case update

pub fn update(
    &self,
    table: &'static str,
    pkcol: Column,
    pk: SqlVal,
    columns: &[Column],
    values: &[SqlVal]
) -> Result<()>

pub fn delete_where(&self, table: &'static str, expr: BoolExpr) -> Result<usize>

pub fn has_table(&self, table: &'static str) -> Result<bool>

Tests if a table exists in the database.

pub fn delete(
    &self,
    table: &'static str,
    pkcol: &'static str,
    pk: SqlVal
) -> Result<()>