Struct Tx 

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

Lightweight transaction wrapper for Postgres.

Implementations

impl Tx<'_>

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 async fn execute_prepared( &self, prepared: &Prepared, params: &[RowValues], ) -> Result<usize, SqlMiddlewareDbError>

Execute a parameterized DML statement and return the affected row count.

Errors

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

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_prepared( &self, prepared: &Prepared, params: &[RowValues], ) -> Result<ResultSet, SqlMiddlewareDbError>

Execute a parameterized SELECT and return a ResultSet.

Errors

Returns an error if parameter conversion, execution, or result building 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.