Struct sqlx_core::query_as::QueryAs

[+] Show declaration

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

[−] Expand description

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

Implementations

impl<'q, DB: Database, O> QueryAs<'q, DB, O, <DB as HasArguments<'q>>::Arguments>[−]

pub fn bind<T: 'q + Send + Encode<'q, DB> + Type<DB>>(
    mut self: Self,
    value: T
) -> Self[−]

Bind a value for use with this SQL query.

See Query::bind.

impl<'q, DB, O, A> QueryAs<'q, DB, O, A> where
    DB: Database,
    A: 'q + IntoArguments<'q, DB>,
    O: Send + Unpin + for<'r> FromRow<'r, DB::Row>, [−]

pub fn fetch<'e, 'c: 'e, E>(
    self,
    executor: E
) -> BoxStream<'e, Result<O, Error>> where
    'q: 'e,
    E: 'e + Executor<'c, Database = DB>,
    DB: 'e,
    O: 'e,
    A: 'e, [−]

Execute the query and return the generated results as a stream.

pub fn fetch_many<'e, 'c: 'e, E>(
    self,
    executor: E
) -> BoxStream<'e, Result<Either<DB::QueryResult, O>, Error>> where
    'q: 'e,
    E: 'e + Executor<'c, Database = DB>,
    DB: 'e,
    O: 'e,
    A: 'e, [−]

Execute multiple queries and return the generated results as a stream from each query, in a stream.

pub async fn fetch_all<'e, 'c: 'e, E>(
    self,
    executor: E
) -> Result<Vec<O>, Error> where
    'q: 'e,
    E: 'e + Executor<'c, Database = DB>,
    DB: 'e,
    O: 'e,
    A: 'e, [−]

Execute the query and return all the generated results, collected into a Vec.

pub async fn fetch_one<'e, 'c: 'e, E>(self, executor: E) -> Result<O, Error> where
    'q: 'e,
    E: 'e + Executor<'c, Database = DB>,
    DB: 'e,
    O: 'e,
    A: 'e, [−]

Execute the query and returns exactly one row.

pub async fn fetch_optional<'e, 'c: 'e, E>(
    self,
    executor: E
) -> Result<Option<O>, Error> where
    'q: 'e,
    E: 'e + Executor<'c, Database = DB>,
    DB: 'e,
    O: 'e,
    A: 'e, [−]

Execute the query and returns at most one row.

Trait Implementations

impl<'q, DB, O: Send, A: Send> Execute<'q, DB> for QueryAs<'q, DB, O, A> where
    DB: Database,
    A: 'q + IntoArguments<'q, DB>, [+]

[+] Show hidden undocumented items

fn sql(&self) -> &'q str[−]

Gets the SQL that will be executed.

fn statement(&self) -> Option<&<DB as HasStatement<'q>>::Statement>[−]

Gets the previously cached statement, if available.

fn take_arguments(&mut self) -> Option<<DB as HasArguments<'q>>::Arguments>[−]

Returns the arguments to be bound against the query string.

fn persistent(&self) -> bool[−]

Returns true if the statement should be cached.