[−][src]Struct diesel::query_builder::SqlQuery
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]
pub 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 QueryId for SqlQuery
[src]
type QueryId = ()
A type which uniquely represents Self
in a SQL query. Read more
const HAS_STATIC_QUERY_ID: bool
[src]
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]
fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>
[src]
fn collect_binds(
&self,
out: &mut DB::BindCollector,
metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>
[src]
&self,
out: &mut DB::BindCollector,
metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>
fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>
[src]
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> RunQueryDsl<Conn> for SqlQuery
[src]
fn execute(self, conn: &Conn) -> QueryResult<usize> where
Conn: Connection,
Self: ExecuteDsl<Conn>,
[src]
Conn: Connection,
Self: ExecuteDsl<Conn>,
fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
fn first<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LimitDsl,
Limit<Self>: LoadQuery<Conn, U>,
[src]
Self: LimitDsl,
Limit<Self>: LoadQuery<Conn, U>,
impl Clone for SqlQuery
[src]
impl Debug for SqlQuery
[src]
Auto Trait Implementations
impl Send for SqlQuery
impl Sync for SqlQuery
impl Unpin for SqlQuery
impl UnwindSafe for SqlQuery
impl RefUnwindSafe for SqlQuery
Blanket Implementations
impl<T> IntoSql for T
[src]
fn into_sql<T>(self) -> AsExprOf<Self, T> where
Self: AsExpression<T> + Sized,
[src]
Self: AsExpression<T> + Sized,
fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where
&'a Self: AsExpression<T>,
[src]
&'a Self: AsExpression<T>,
impl<Conn, T, U> LoadQuery<Conn, U> for T where
Conn: Connection,
T: AsQuery + RunQueryDsl<Conn>,
U: Queryable<<T as AsQuery>::SqlType, <Conn as Connection>::Backend>,
<Conn as Connection>::Backend: HasSqlType<<T as AsQuery>::SqlType>,
<T as AsQuery>::Query: QueryFragment<<Conn as Connection>::Backend>,
<T as AsQuery>::Query: QueryId,
[src]
Conn: Connection,
T: AsQuery + RunQueryDsl<Conn>,
U: Queryable<<T as AsQuery>::SqlType, <Conn as Connection>::Backend>,
<Conn as Connection>::Backend: HasSqlType<<T as AsQuery>::SqlType>,
<T as AsQuery>::Query: QueryFragment<<Conn as Connection>::Backend>,
<T as AsQuery>::Query: QueryId,
impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T where
Conn: Connection<Backend = DB>,
DB: Backend,
T: QueryFragment<DB> + QueryId,
[src]
Conn: Connection<Backend = DB>,
DB: Backend,
T: QueryFragment<DB> + QueryId,
impl<T, Conn> RunQueryDsl<Conn> for T where
T: Table,
[src]
T: Table,
fn execute(self, conn: &Conn) -> QueryResult<usize> where
Conn: Connection,
Self: ExecuteDsl<Conn>,
[src]
Conn: Connection,
Self: ExecuteDsl<Conn>,
fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,
[src]
Self: LoadQuery<Conn, U>,
fn first<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LimitDsl,
Limit<Self>: LoadQuery<Conn, U>,
[src]
Self: LimitDsl,
Limit<Self>: LoadQuery<Conn, U>,
impl<T, U> Into<U> for T where
U: From<T>,
[src]
U: From<T>,
impl<T> From<T> for T
[src]
impl<T> ToOwned for T where
T: Clone,
[src]
T: Clone,
type Owned = T
The resulting type after obtaining ownership.
fn to_owned(&self) -> T
[src]
fn clone_into(&self, target: &mut T)
[src]
impl<T, U> TryFrom<U> for T where
U: Into<T>,
[src]
U: Into<T>,
type Error = Infallible
The type returned in the event of a conversion error.
fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>
[src]
impl<T, U> TryInto<U> for T where
U: TryFrom<T>,
[src]
U: TryFrom<T>,
type Error = <U as TryFrom<T>>::Error
The type returned in the event of a conversion error.
fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>
[src]
impl<T> Borrow<T> for T where
T: ?Sized,
[src]
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
[src]
T: ?Sized,
fn borrow_mut(&mut self) -> &mut T
[src]
impl<T> Any for T where
T: 'static + ?Sized,
[src]
T: 'static + ?Sized,