Struct diesel::query_builder::SqlQuery[][src]

#[must_use = "Queries are only executed when calling `load`, `get_result` or similar."]
pub struct SqlQuery { /* fields omitted */ }

The return value of sql_query.

Unlike most queries in Diesel, SqlQuery loads its data by column name, rather than by index. This means that you cannot deserialize this query into a tuple, and any structs used must implement QueryableByName.

See sql_query for examples.


impl SqlQuery

Bind a value for use with this SQL query.


This function should be used with care, as Diesel cannot validate that the value is of the right type nor can it validate that you have passed the correct number of parameters.


let users = sql_query("SELECT * FROM users WHERE id > ? AND name <> ?")
    .bind::<Integer, _>(1)
    .bind::<Text, _>("Tess")
let expected_users = vec![
    User { id: 3, name: "Jim".into() },
assert_eq!(Ok(expected_users), users);

Trait Implementations

impl Debug for SqlQuery

Formats the value using the given formatter. Read more

impl Clone for SqlQuery

Returns a copy of the value. Read more

Performs copy-assignment from source. Read more

impl<DB> QueryFragment<DB> for SqlQuery where
    DB: Backend

Walk over this QueryFragment for all passes. Read more

Converts this QueryFragment to its SQL representation. Read more

Serializes all bind parameters in this query. Read more

Is this query safe to store in the prepared statement cache? Read more

impl QueryId for SqlQuery

A type which uniquely represents Self in a SQL query. Read more

HAS_STATIC_QUERY_ID: bool = false

Can the SQL generated by Self be uniquely identified by its type? Read more

Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise. Read more

impl<Conn, T> LoadQuery<Conn, T> for SqlQuery where
    Conn: Connection,
    T: QueryableByName<Conn::Backend>, 

Load this query

impl<Conn> RunQueryDsl<Conn> for SqlQuery

Executes the given command, returning the number of rows affected. Read more

Executes the given query, returning a Vec with the returned rows. Read more

Runs the command, and returns the affected row. Read more

Runs the command, returning an Vec with the affected rows. Read more

Attempts to load a single record. Read more

Auto Trait Implementations

impl Send for SqlQuery

impl Sync for SqlQuery