Struct CachedStatement 

pub struct CachedStatement { /* private fields */ }

Cached Statement from PoolConnection

Can be used for the same purpose without the ability to cancel actively It’s lifetime is managed by PoolConnection

Methods from Deref<Target = Statement>

pub fn bind<P>(&self, params: P) -> StatementPreparedQuery<'_, P>

where P: AsParams,

bind self to typed value parameters where they are encoded into a valid sql query in binary format

Examples

// prepare a statement with typed parameters.
let stmt = Statement::named("SELECT * FROM users WHERE id = $1 AND age = $2", &[Type::INT4, Type::INT4])
    .execute(&cli).await?;
// bind statement to typed value parameters and start query
let row_stream = stmt.bind([9527_i32, 18]).query(&cli).await?;

pub fn bind_dyn<'p, 't>( &self, params: &'p [&'t (dyn ToSql + Sync)], ) -> StatementPreparedQuery<'_, impl ExactSizeIterator<Item = &'t (dyn ToSql + Sync)> + Clone + 'p>

Statement::bind for dynamic typed parameters

Examples

// bind to a dynamic typed slice where items have it's own concrete type.
let bind = statement.bind_dyn(&[&9527i32, &"nobody"]);

pub fn bind_none(&self) -> StatementPreparedQuery<'_, [bool; 0]>

specialized binding api for zero sized parameters. function the same as Statement::bind([])

pub fn params(&self) -> &[Type]

Returns the expected types of the statement’s parameters.

pub fn columns(&self) -> &[Column]

Returns information about the columns returned when the statement is queried.

Trait Implementations

impl Clone for CachedStatement

fn clone(&self) -> Self

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Deref for CachedStatement

type Target = Statement

The resulting type after dereferencing.

fn deref(&self) -> &Self::Target

Dereferences the value.