Struct Sql 

pub struct Sql { /* private fields */ }

A statement built by sql().

Implementations

impl Sql

pub fn bind(self, value: impl ToDbValue) -> Self

Binds the next ?.

pub fn bind_all(self, values: impl IntoIterator<Item = DbValue>) -> Self

Binds several values in order.

pub async fn fetch_all<'c>( self, db: impl Executor<'c>, ) -> Result<Vec<Row>, DbError>

Runs the statement and returns every row.

pub async fn fetch_optional<'c>( self, db: impl Executor<'c>, ) -> Result<Option<Row>, DbError>

Runs the statement and returns the first row, if any.

pub async fn fetch_one<'c>(self, db: impl Executor<'c>) -> Result<Row, DbError>

The first row; an error if there is none.

pub async fn execute<'c>(self, db: impl Executor<'c>) -> Result<u64, DbError>

Runs the statement and returns the number of rows it changed.

pub async fn fetch_as<'c, T: FromRow>( self, db: impl Executor<'c>, ) -> Result<Vec<T>, DbError>

Every row, read into T: a model, a #[derive(FromRow)] struct or a tuple; see super::FromRow.

pub async fn fetch_optional_as<'c, T: FromRow>( self, db: impl Executor<'c>, ) -> Result<Option<T>, DbError>

The first row read into T, or None if there is no row.

pub async fn fetch_one_as<'c, T: FromRow>( self, db: impl Executor<'c>, ) -> Result<T, DbError>

The first row read into T; an error if there is none.

pub async fn scalar<'c, T: FromDb>( self, db: impl Executor<'c>, ) -> Result<T, DbError>

The first column of the first row; an error if there is no row.

pub async fn scalar_optional<'c, T: FromDb>( self, db: impl Executor<'c>, ) -> Result<Option<T>, DbError>

The first column of the first row, or None if there is no row.

pub async fn scalars<'c, T: FromDb>( self, db: impl Executor<'c>, ) -> Result<Vec<T>, DbError>

The first column of every row.

Trait Implementations

impl Clone for Sql

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Sql

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

Formats the value using the given formatter.