Struct deadpool_postgres::Transaction

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

A wrapper for tokio_postgres::Transaction which uses the statement cache from the client object it was created by.

Implementations

impl<'a> Transaction<'a>

pub async fn prepare_cached(&self, query: &str) -> Result<Statement, Error>

Like tokio_postgres::Transaction::prepare but uses an existing statement from the cache if possible.

pub async fn prepare_typed_cached(
    &self,
    query: &str,
    types: &[Type]
) -> Result<Statement, Error>

Like tokio_postgres::Transaction::prepare_typed but uses an existing statement from the cache if possible.

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

Like tokio_postgres::Transaction::commit

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

Like tokio_postgres::Transaction::rollback

pub async fn transaction(&mut self) -> Result<Transaction<'_>, Error>

Like tokio_postgres::Transaction::transaction but returns a deadpool-postgres wrapped transaction with statement cache support.

pub async fn savepoint<I>(&mut self, name: I) -> Result<Transaction<'_>, Error> where
    I: Into<String>, 

Like tokio_postgres::Transaction::savepoint but returns a deadpool-postgres wrapped transaction with statement cache support.

Methods from Deref<Target = PgTransaction<'a>>

pub async fn prepare(&'_ self, query: &'_ str) -> Result<Statement, Error>

Like Client::prepare.

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, Global>, 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, 

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, 

Like Client::query_opt.

pub async fn query_raw<T, P, I>(
    &'_ self,
    statement: &'_ T,
    params: I
) -> Result<RowStream, Error> where
    T: ToStatement + ?Sized,
    I: IntoIterator<Item = P>,
    P: BorrowToSql,
    <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, 

Like Client::execute.

pub async fn execute_raw<P, I, T>(
    &'_ self,
    statement: &'_ T,
    params: I
) -> Result<u64, Error> where
    T: ToStatement + ?Sized,
    I: IntoIterator<Item = P>,
    P: BorrowToSql,
    <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, 

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,
    I: IntoIterator<Item = P>,
    P: BorrowToSql,
    <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, Global>, 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>

The maximally flexible version of query_portal.

pub async fn copy_in<T, U>(
    &'_ self,
    statement: &'_ T
) -> Result<CopyInSink<U>, Error> where
    T: ToStatement + ?Sized,
    U: Buf + 'static + Send, 

Like Client::copy_in.

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, Global>, Error>

Like Client::simple_query.

pub async fn batch_execute(&'_ self, query: &'_ str) -> Result<(), Error>

Like Client::batch_execute.

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

Like Client::cancel_query.

pub async fn cancel_query_raw<S, T>(
    &'_ self,
    stream: S,
    tls: T
) -> Result<(), Error> where
    T: TlsConnect<S>,
    S: AsyncRead + AsyncWrite + Unpin, 

👎 Deprecated since 0.6.0:

use Transaction::cancel_token() instead

Like Client::cancel_query_raw.

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> where
    I: Into<String>, 

Like Client::transaction, but creates a nested transaction via a savepoint with the specified name.

pub fn client(&self) -> &Client

Returns a reference to the underlying Client.

Trait Implementations

impl<'a> Deref for Transaction<'a>

type Target = PgTransaction<'a>

The resulting type after dereferencing.

fn deref(&self) -> &PgTransaction<'a>

Dereferences the value.

impl<'a> DerefMut for Transaction<'a>

fn deref_mut(&mut self) -> &mut PgTransaction<'a>

Mutably dereferences the value.