Struct Statement 

pub struct Statement {
    pub parts: Vec<SqlPart>,
    pub expected_response: ExpectedSqlResponse,
    /* private fields */
}

Sql message

Fields

parts: Vec<SqlPart>

The SQL statement

expected_response: ExpectedSqlResponse

The expected response type

Implementations

impl Statement

pub fn to_sql(self) -> Result<(String, Vec<Value>), Error>

Convert Statement into a SQL statement and the list of placeholders

By default it converts the statement into placeholder using $1..$n placeholders which seems to be more widely supported, although it can be reimplemented with other formats since part is public

pub fn bind<C, V>(self, name: C, value: V) -> Self

where C: ToString, V: Into<Value>,

Binds a given placeholder to a value.

pub fn bind_vec<C, V>(self, name: C, value: Vec<V>) -> Self

where C: ToString, V: Into<Value>,

Binds a single variable with a vector.

This will rewrite the function from :foo (where value is vec![1, 2, 3]) to :foo0, :foo1, :foo2 and binds each value from the value vector accordingly.

pub async fn pluck<C>(self, conn: &C) -> Result<Option<Value>, Error>

where C: DatabaseExecutor,

Executes a query and returns the affected rows

pub async fn batch<C>(self, conn: &C) -> Result<(), Error>

where C: DatabaseExecutor,

Executes a query and returns the affected rows

pub async fn execute<C>(self, conn: &C) -> Result<usize, Error>

where C: DatabaseExecutor,

Executes a query and returns the affected rows

pub async fn fetch_one<C>(self, conn: &C) -> Result<Option<Vec<Column>>, Error>

where C: DatabaseExecutor,

Runs the query and returns the first row or None

pub async fn fetch_all<C>(self, conn: &C) -> Result<Vec<Vec<Column>>, Error>

where C: DatabaseExecutor,

Runs the query and returns the first row or None

Trait Implementations

impl Debug for Statement

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for Statement

fn default() -> Statement

Returns the “default value” for a type.