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.
Methods
impl SqlQuery
[src]
fn bind<ST, Value>(self, value: Value) -> UncheckedBind<Self, Value, ST>
[src]
Bind a value for use with this SQL query.
Safety
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.
Example
let users = sql_query("SELECT * FROM users WHERE id > ? AND name <> ?") .bind::<Integer, _>(1) .bind::<Text, _>("Tess") .get_results(&connection); let expected_users = vec![ User { id: 3, name: "Jim".into() }, ]; assert_eq!(Ok(expected_users), users);
Trait Implementations
impl Debug for SqlQuery
[src]
impl Clone for SqlQuery
[src]
fn clone(&self) -> SqlQuery
[src]
Returns a copy of the value. Read more
fn clone_from(&mut self, source: &Self)
1.0.0[src]
Performs copy-assignment from source
. Read more
impl QueryId for SqlQuery
[src]
type QueryId = ()
const HAS_STATIC_QUERY_ID: bool
HAS_STATIC_QUERY_ID: bool = false
fn query_id() -> Option<TypeId>
[src]
impl<DB> QueryFragment<DB> for SqlQuery where
DB: Backend,
[src]
DB: Backend,
fn walk_ast(&self, out: AstPass<DB>) -> QueryResult<()>
[src]
Walk over this QueryFragment
for all passes. Read more
fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>
[src]
Converts this QueryFragment
to its SQL representation
fn collect_binds(
&self,
out: &mut DB::BindCollector,
metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>
[src]
&self,
out: &mut DB::BindCollector,
metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>
Serializes all bind parameters in this query. Read more
fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>
[src]
Is this query safe to store in the prepared statement cache? Read more
impl<Conn, T> LoadQuery<Conn, T> for SqlQuery where
Conn: Connection,
T: QueryableByName<Conn::Backend>,
[src]
Conn: Connection,
T: QueryableByName<Conn::Backend>,
fn internal_load(self, conn: &Conn) -> QueryResult<Vec<T>>
[src]
impl<Conn> LoadDsl<Conn> for SqlQuery
[src]
fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
Executes the given query, returning a Vec
with the returned rows.
fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
Runs the command, and returns the affected row. Err(NotFound)
will be returned if the query affected 0 rows. You can call .optional()
on the result of this if the command was optional to get back a Result<Option<U>>
Read more
fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
Runs the command, returning an Vec
with the affected rows.