[−][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 Clone for SqlQuery
[src]
impl Debug for SqlQuery
[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<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 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<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>,
Auto Trait Implementations
impl RefUnwindSafe for SqlQuery
impl Send for SqlQuery
impl Sync for SqlQuery
impl Unpin for SqlQuery
impl UnwindSafe for SqlQuery
Blanket Implementations
impl<T> Any for T where
T: 'static + ?Sized,
[src]
T: 'static + ?Sized,
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<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> From<T> for T
[src]
impl<T, U> Into<U> for T where
U: From<T>,
[src]
U: From<T>,
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<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> 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>,