Struct sqlx::QueryAs

#[must_use = "query must be executed to affect database"]pub struct QueryAs<'q, DB, O> where
    DB: Database,  { /* fields omitted */ }

Raw SQL query with bind parameters, mapped to a concrete type using FromRow. Returned by query_as.

Methods

impl<'q, DB, O> QueryAs<'q, DB, O> where
    DB: Database, 

pub fn bind<T>(self, value: T) -> QueryAs<'q, DB, O> where
    T: Type<DB> + Encode<DB>, 

Bind a value for use with this SQL query.

Trait Implementations

impl<'q, DB, O> Execute<'q, DB> for QueryAs<'q, DB, O> where
    DB: Database,
    O: Send, 

fn into_parts(self) -> (&'q str, Option<<DB as Database>::Arguments>)

Returns the query to be executed and the arguments to bind against the query, if any.

impl<'q, O> MySqlQueryAs<'q, O> for QueryAs<'q, MySql, O>

fn fetch<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Stream<Item = Result<O, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = MySql>,
    O: 'e + Send + Unpin + for<'c> FromRow<'c, MySqlRow<'c>>, 

fn fetch_optional<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<Option<O>, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = MySql>,
    O: 'e + Send + for<'c> FromRow<'c, MySqlRow<'c>>, 

fn fetch_one<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<O, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = MySql>,
    O: 'e + Send + for<'c> FromRow<'c, MySqlRow<'c>>, 

fn fetch_all<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<Vec<O>, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = MySql>,
    O: 'e + Send + for<'c> FromRow<'c, MySqlRow<'c>>, 

impl<'q, O> PgQueryAs<'q, O> for QueryAs<'q, Postgres, O>

fn fetch<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Stream<Item = Result<O, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Postgres>,
    O: 'e + Send + Unpin + for<'c> FromRow<'c, PgRow<'c>>, 

fn fetch_optional<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<Option<O>, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Postgres>,
    O: 'e + Send + for<'c> FromRow<'c, PgRow<'c>>, 

fn fetch_one<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<O, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Postgres>,
    O: 'e + Send + for<'c> FromRow<'c, PgRow<'c>>, 

fn fetch_all<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<Vec<O>, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Postgres>,
    O: 'e + Send + for<'c> FromRow<'c, PgRow<'c>>, 

impl<'q, O> SqliteQueryAs<'q, O> for QueryAs<'q, Sqlite, O>

fn fetch<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Stream<Item = Result<O, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Sqlite>,
    O: 'e + Send + Unpin + for<'c> FromRow<'c, SqliteRow<'c>>, 

fn fetch_optional<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<Option<O>, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Sqlite>,
    O: 'e + Send + for<'c> FromRow<'c, SqliteRow<'c>>, 

fn fetch_one<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<O, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Sqlite>,
    O: 'e + Send + for<'c> FromRow<'c, SqliteRow<'c>>, 

fn fetch_all<'e, E>(
    self,
    executor: E
) -> Pin<Box<dyn Future<Output = Result<Vec<O>, Error>> + 'e + Send>> where
    'q: 'e,
    E: 'e + Send + RefExecutor<'e, Database = Sqlite>,
    O: 'e + Send + for<'c> FromRow<'c, SqliteRow<'c>>,