Struct sqlx::query::Query

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

Raw SQL query with bind parameters. Returned by query.

Methods

impl<'q, DB> Query<'q, DB> where
    DB: Database, 

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

Bind a value for use with this SQL query.

If the number of times this is called does not match the number of bind parameters that appear in the query (? for most SQL flavors, $1 .. $N for Postgres) then an error will be returned when this query is executed.

There is no validation that the value is of the type expected by the query. Most SQL flavors will perform type coercion (Postgres will return a database error).s

impl<'q, DB> Query<'q, DB> where
    DB: Database, 

pub fn map<F, O>(self, mapper: F) -> Map<'q, DB, impl TryMapRow<DB, Output = O>> where
    F: MapRow<DB, Output = O>,
    O: Unpin, 

Map each row in the result to another type.

The returned type has most of the same methods but does not have .execute() or `.bind().

See also: [query_as][crate::query_as::query_as].

pub fn try_map<F>(self, mapper: F) -> Map<'q, DB, F> where
    F: TryMapRow<DB>, 

Map each row in the result to another type.

See also: [query_as][crate::query_as::query_as].

impl<'q, DB> Query<'q, DB> where
    DB: Database,
    Query<'q, DB>: Execute<'q, DB>, 

pub async fn execute<E>(self, __arg1: E) -> Result<u64, Error> where
    E: Executor<Database = DB>, 

pub fn fetch<'e, E>(self, executor: E) -> <DB as HasCursor<'e, 'q>>::Cursor where
    E: RefExecutor<'e, Database = DB>, 

Trait Implementations

impl<'q, DB> Execute<'q, DB> for Query<'q, DB> where
    DB: Database, 

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.