Struct Tx 

pub struct Tx<'a> { /* private fields */ }

Lightweight transaction wrapper for Postgres.

Implementations

impl<'conn> Tx<'conn>

pub async fn prepare(&self, sql: &str) -> Result<Prepared, SqlMiddlewareDbError>

Prepare a SQL statement tied to this transaction.

Errors

Returns an error if the prepare call fails.

pub fn select<'tx, 'prepared>( &'tx self, prepared: &'prepared Prepared, ) -> PreparedSelect<'tx, 'prepared, 'static, 'conn>

Start configuring a prepared SELECT execution.

pub fn execute<'tx, 'prepared>( &'tx self, prepared: &'prepared Prepared, ) -> PreparedExecute<'tx, 'prepared, 'static, 'conn>

Start configuring a prepared DML execution.

pub async fn execute_dml( &self, query: &str, params: &[RowValues], ) -> Result<usize, SqlMiddlewareDbError>

Execute a parameterized DML statement without preparing and return affected rows.

Errors

Returns an error if parameter conversion, execution, or row-count conversion fails.

pub async fn query( &self, query: &str, params: &[RowValues], ) -> Result<ResultSet, SqlMiddlewareDbError>

Execute a parameterized SELECT without preparing and return a ResultSet.

Errors

Returns an error if parameter conversion or query execution fails.

pub async fn execute_batch(&self, sql: &str) -> Result<(), SqlMiddlewareDbError>

Execute a batch of SQL statements inside the transaction.

Errors

Returns an error if execution fails.

pub async fn commit(self) -> Result<TxOutcome, SqlMiddlewareDbError>

Commit the transaction.

Errors

Returns an error if commit fails.

pub async fn rollback(self) -> Result<TxOutcome, SqlMiddlewareDbError>

Roll back the transaction.

Errors

Returns an error if rollback fails.

Trait Implementations

impl<'a> From<&'a Tx<'a>> for BatchTarget<'a>

Available on crate feature postgres only.

fn from(tx: &'a Tx<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Tx<'a>> for QueryTarget<'a>

Available on crate feature postgres only.

fn from(tx: &'a Tx<'a>) -> Self

Converts to this type from the input type.