Struct buildsrs_database::Transaction
pub struct Transaction<'a> { /* private fields */ }
Expand description
A representation of a PostgreSQL database transaction.
Transactions will implicitly roll back when dropped. Use the commit
method to commit the changes made in the
transaction. Transactions can be nested, with inner transactions implemented via safepoints.
Implementations§
§impl<'a> Transaction<'a>
impl<'a> Transaction<'a>
pub async fn commit(self) -> Result<(), Error>
pub async fn commit(self) -> Result<(), Error>
Consumes the transaction, committing all changes made within it.
pub async fn rollback(self) -> Result<(), Error>
pub async fn rollback(self) -> Result<(), Error>
Rolls the transaction back, discarding all changes made within it.
This is equivalent to Transaction
’s Drop
implementation, but provides any error encountered to the caller.
pub async fn prepare_typed(
&self,
query: &str,
parameter_types: &[Type]
) -> Result<Statement, Error>
pub async fn prepare_typed( &self, query: &str, parameter_types: &[Type] ) -> Result<Statement, Error>
Like Client::prepare_typed
.
pub async fn query<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Vec<Row>, Error>where
T: ToStatement + ?Sized,
pub async fn query<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Vec<Row>, Error>where
T: ToStatement + ?Sized,
Like Client::query
.
pub async fn query_one<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Row, Error>where
T: ToStatement + ?Sized,
pub async fn query_one<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Row, Error>where
T: ToStatement + ?Sized,
Like Client::query_one
.
pub async fn query_opt<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Option<Row>, Error>where
T: ToStatement + ?Sized,
pub async fn query_opt<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Option<Row>, Error>where
T: ToStatement + ?Sized,
Like Client::query_opt
.
pub async fn query_raw<T, P, I>(
&self,
statement: &T,
params: I
) -> Result<RowStream, Error>where
T: ToStatement + ?Sized,
P: BorrowToSql,
I: IntoIterator<Item = P>,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
pub async fn query_raw<T, P, I>(
&self,
statement: &T,
params: I
) -> Result<RowStream, Error>where
T: ToStatement + ?Sized,
P: BorrowToSql,
I: IntoIterator<Item = P>,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
Like Client::query_raw
.
pub async fn execute<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<u64, Error>where
T: ToStatement + ?Sized,
pub async fn execute<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<u64, Error>where
T: ToStatement + ?Sized,
Like Client::execute
.
pub async fn execute_raw<P, I, T>(
&self,
statement: &T,
params: I
) -> Result<u64, Error>where
T: ToStatement + ?Sized,
P: BorrowToSql,
I: IntoIterator<Item = P>,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
pub async fn execute_raw<P, I, T>(
&self,
statement: &T,
params: I
) -> Result<u64, Error>where
T: ToStatement + ?Sized,
P: BorrowToSql,
I: IntoIterator<Item = P>,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
Like Client::execute_iter
.
pub async fn bind<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Portal, Error>where
T: ToStatement + ?Sized,
pub async fn bind<T>(
&self,
statement: &T,
params: &[&(dyn ToSql + Sync)]
) -> Result<Portal, Error>where
T: ToStatement + ?Sized,
Binds a statement to a set of parameters, creating a Portal
which can be incrementally queried.
Portals only last for the duration of the transaction in which they are created, and can only be used on the connection that created them.
Panics
Panics if the number of parameters provided does not match the number expected.
pub async fn bind_raw<P, T, I>(
&self,
statement: &T,
params: I
) -> Result<Portal, Error>where
T: ToStatement + ?Sized,
P: BorrowToSql,
I: IntoIterator<Item = P>,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
pub async fn bind_raw<P, T, I>(
&self,
statement: &T,
params: I
) -> Result<Portal, Error>where
T: ToStatement + ?Sized,
P: BorrowToSql,
I: IntoIterator<Item = P>,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
A maximally flexible version of bind
.
pub async fn query_portal(
&self,
portal: &Portal,
max_rows: i32
) -> Result<Vec<Row>, Error>
pub async fn query_portal( &self, portal: &Portal, max_rows: i32 ) -> Result<Vec<Row>, Error>
Continues execution of a portal, returning a stream of the resulting rows.
Unlike query
, portals can be incrementally evaluated by limiting the number of rows returned in each call to
query_portal
. If the requested number is negative or 0, all rows will be returned.
pub async fn query_portal_raw(
&self,
portal: &Portal,
max_rows: i32
) -> Result<RowStream, Error>
pub async fn query_portal_raw( &self, portal: &Portal, max_rows: i32 ) -> Result<RowStream, Error>
The maximally flexible version of query_portal
.
pub async fn copy_in<T, U>(&self, statement: &T) -> Result<CopyInSink<U>, Error>
pub async fn copy_in<T, U>(&self, statement: &T) -> Result<CopyInSink<U>, Error>
Like Client::copy_in
.
pub async fn copy_out<T>(&self, statement: &T) -> Result<CopyOutStream, Error>where
T: ToStatement + ?Sized,
pub async fn copy_out<T>(&self, statement: &T) -> Result<CopyOutStream, Error>where
T: ToStatement + ?Sized,
Like Client::copy_out
.
pub async fn simple_query(
&self,
query: &str
) -> Result<Vec<SimpleQueryMessage>, Error>
pub async fn simple_query( &self, query: &str ) -> Result<Vec<SimpleQueryMessage>, Error>
Like Client::simple_query
.
pub async fn batch_execute(&self, query: &str) -> Result<(), Error>
pub async fn batch_execute(&self, query: &str) -> Result<(), Error>
Like Client::batch_execute
.
pub fn cancel_token(&self) -> CancelToken
pub fn cancel_token(&self) -> CancelToken
Like Client::cancel_token
.
pub async fn cancel_query<T>(&self, tls: T) -> Result<(), Error>where
T: MakeTlsConnect<Socket>,
👎Deprecated since 0.6.0: use Transaction::cancel_token() instead
pub async fn cancel_query<T>(&self, tls: T) -> Result<(), Error>where
T: MakeTlsConnect<Socket>,
Like Client::cancel_query
.
pub async fn cancel_query_raw<S, T>(
&self,
stream: S,
tls: T
) -> Result<(), Error>where
S: AsyncRead + AsyncWrite + Unpin,
T: TlsConnect<S>,
👎Deprecated since 0.6.0: use Transaction::cancel_token() instead
pub async fn cancel_query_raw<S, T>(
&self,
stream: S,
tls: T
) -> Result<(), Error>where
S: AsyncRead + AsyncWrite + Unpin,
T: TlsConnect<S>,
Like Client::cancel_query_raw
.
pub async fn transaction(&mut self) -> Result<Transaction<'_>, Error>
pub async fn transaction(&mut self) -> Result<Transaction<'_>, Error>
Like Client::transaction
, but creates a nested transaction via a savepoint.
pub async fn savepoint<I>(&mut self, name: I) -> Result<Transaction<'_>, Error>
pub async fn savepoint<I>(&mut self, name: I) -> Result<Transaction<'_>, Error>
Like Client::transaction
, but creates a nested transaction via a savepoint with the specified name.
pub fn client(&self) -> &Client
pub fn client(&self) -> &Client
Returns a reference to the underlying Client
.
Trait Implementations§
§impl<'a> Drop for Transaction<'a>
impl<'a> Drop for Transaction<'a>
§impl GenericClient for Transaction<'_>
impl GenericClient for Transaction<'_>
§fn execute<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
query: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<u64, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
fn execute<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
query: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<u64, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
Client::execute
.§fn execute_raw<'life0, 'life1, 'async_trait, P, I, T>(
&'life0 self,
statement: &'life1 T,
params: I
) -> Pin<Box<dyn Future<Output = Result<u64, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
P: BorrowToSql + 'async_trait,
I: IntoIterator<Item = P> + Sync + Send + 'async_trait,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
Transaction<'_>: 'async_trait,
fn execute_raw<'life0, 'life1, 'async_trait, P, I, T>(
&'life0 self,
statement: &'life1 T,
params: I
) -> Pin<Box<dyn Future<Output = Result<u64, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
P: BorrowToSql + 'async_trait,
I: IntoIterator<Item = P> + Sync + Send + 'async_trait,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
Transaction<'_>: 'async_trait,
Client::execute_raw
.§fn query<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
query: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<Vec<Row>, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
fn query<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
query: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<Vec<Row>, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
Client::query
.§fn query_one<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
statement: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<Row, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
fn query_one<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
statement: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<Row, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
Client::query_one
.§fn query_opt<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
statement: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<Option<Row>, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
fn query_opt<'life0, 'life1, 'life2, 'life3, 'async_trait, T>(
&'life0 self,
statement: &'life1 T,
params: &'life2 [&'life3 (dyn ToSql + Sync)]
) -> Pin<Box<dyn Future<Output = Result<Option<Row>, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
'life3: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
Transaction<'_>: 'async_trait,
Client::query_opt
.§fn query_raw<'life0, 'life1, 'async_trait, T, P, I>(
&'life0 self,
statement: &'life1 T,
params: I
) -> Pin<Box<dyn Future<Output = Result<RowStream, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
P: BorrowToSql + 'async_trait,
I: IntoIterator<Item = P> + Sync + Send + 'async_trait,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
Transaction<'_>: 'async_trait,
fn query_raw<'life0, 'life1, 'async_trait, T, P, I>(
&'life0 self,
statement: &'life1 T,
params: I
) -> Pin<Box<dyn Future<Output = Result<RowStream, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
T: ToStatement + Sync + Send + 'async_trait + ?Sized,
P: BorrowToSql + 'async_trait,
I: IntoIterator<Item = P> + Sync + Send + 'async_trait,
<I as IntoIterator>::IntoIter: ExactSizeIterator,
Transaction<'_>: 'async_trait,
Client::query_raw
.§fn prepare<'life0, 'life1, 'async_trait>(
&'life0 self,
query: &'life1 str
) -> Pin<Box<dyn Future<Output = Result<Statement, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
Transaction<'_>: 'async_trait,
fn prepare<'life0, 'life1, 'async_trait>(
&'life0 self,
query: &'life1 str
) -> Pin<Box<dyn Future<Output = Result<Statement, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
Transaction<'_>: 'async_trait,
Client::prepare
.§fn prepare_typed<'life0, 'life1, 'life2, 'async_trait>(
&'life0 self,
query: &'life1 str,
parameter_types: &'life2 [Type]
) -> Pin<Box<dyn Future<Output = Result<Statement, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
Transaction<'_>: 'async_trait,
fn prepare_typed<'life0, 'life1, 'life2, 'async_trait>(
&'life0 self,
query: &'life1 str,
parameter_types: &'life2 [Type]
) -> Pin<Box<dyn Future<Output = Result<Statement, Error>> + Send + 'async_trait>>where
'life0: 'async_trait,
'life1: 'async_trait,
'life2: 'async_trait,
Transaction<'_>: 'async_trait,
Client::prepare_typed
.§fn transaction<'a, 'async_trait>(
&'a mut self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'a>, Error>> + Send + 'async_trait>>where
'a: 'async_trait,
Transaction<'_>: 'async_trait,
fn transaction<'a, 'async_trait>(
&'a mut self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'a>, Error>> + Send + 'async_trait>>where
'a: 'async_trait,
Transaction<'_>: 'async_trait,
Client::transaction
.