pub struct UncheckedBind<Query, Value> { /* private fields */ }
Expand description
Returned by the SqlLiteral::bind()
method when binding a value to a fragment of SQL.
Implementations§
Source§impl<Query, Value> UncheckedBind<Query, Value>where
Query: Expression,
impl<Query, Value> UncheckedBind<Query, Value>where
Query: Expression,
Sourcepub fn sql(self, sql: &str) -> SqlLiteral<Query::SqlType, Self>
pub fn sql(self, sql: &str) -> SqlLiteral<Query::SqlType, Self>
Use literal SQL in the query builder
This function is intended for use when you need a small bit of raw SQL in
your query. If you want to write the entire query using raw SQL, use
sql_query
instead.
§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.
§Examples
let query = users
.select(name)
.filter(
sql("id > ")
.bind::<Integer,_>(1)
.sql(" AND name <> 'Ryan'")
)
.get_results(&connection);
let expected = vec!["Tess".to_string()];
assert_eq!(Ok(expected), query);
Trait Implementations§
Source§impl<Query: Clone, Value: Clone> Clone for UncheckedBind<Query, Value>
impl<Query: Clone, Value: Clone> Clone for UncheckedBind<Query, Value>
Source§fn clone(&self) -> UncheckedBind<Query, Value>
fn clone(&self) -> UncheckedBind<Query, Value>
Returns a copy of the value. Read more
1.0.0 · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
Performs copy-assignment from
source
. Read moreSource§impl<Query, Value> Expression for UncheckedBind<Query, Value>where
Query: Expression,
impl<Query, Value> Expression for UncheckedBind<Query, Value>where
Query: Expression,
Source§type SqlType = <Query as Expression>::SqlType
type SqlType = <Query as Expression>::SqlType
The type that this expression represents in SQL
Source§impl<Q, Value> Query for UncheckedBind<Q, Value>where
Q: Query,
impl<Q, Value> Query for UncheckedBind<Q, Value>where
Q: Query,
Source§impl<Query, Value, DB> QueryFragment<DB> for UncheckedBind<Query, Value>
impl<Query, Value, DB> QueryFragment<DB> for UncheckedBind<Query, Value>
Source§fn walk_ast(&self, out: AstPass<'_, DB>) -> QueryResult<()>
fn walk_ast(&self, out: AstPass<'_, DB>) -> QueryResult<()>
Walk over this
QueryFragment
for all passes. Read moreSource§fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>
fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>
Converts this
QueryFragment
to its SQL representation. Read moreSource§fn collect_binds(
&self,
out: &mut DB::BindCollector,
metadata_lookup: &DB::MetadataLookup,
) -> QueryResult<()>
fn collect_binds( &self, out: &mut DB::BindCollector, metadata_lookup: &DB::MetadataLookup, ) -> QueryResult<()>
Serializes all bind parameters in this query. Read more
Source§fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>
fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>
Is this query safe to store in the prepared statement cache? Read more
Source§impl<Query: QueryId, Value: QueryId> QueryId for UncheckedBind<Query, Value>
impl<Query: QueryId, Value: QueryId> QueryId for UncheckedBind<Query, Value>
Source§impl<Query, Value, Conn> RunQueryDsl<Conn> for UncheckedBind<Query, Value>
impl<Query, Value, Conn> RunQueryDsl<Conn> for UncheckedBind<Query, Value>
Source§fn execute(self, conn: &Conn) -> QueryResult<usize>where
Conn: Connection,
Self: ExecuteDsl<Conn>,
fn execute(self, conn: &Conn) -> QueryResult<usize>where
Conn: Connection,
Self: ExecuteDsl<Conn>,
Executes the given command, returning the number of rows affected. Read more
Source§fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>>where
Self: LoadQuery<Conn, U>,
fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>>where
Self: LoadQuery<Conn, U>,
Executes the given query, returning a
Vec
with the returned rows. Read moreSource§fn get_result<U>(self, conn: &Conn) -> QueryResult<U>where
Self: LoadQuery<Conn, U>,
fn get_result<U>(self, conn: &Conn) -> QueryResult<U>where
Self: LoadQuery<Conn, U>,
Runs the command, and returns the affected row. Read more
Source§fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>>where
Self: LoadQuery<Conn, U>,
fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>>where
Self: LoadQuery<Conn, U>,
Runs the command, returning an
Vec
with the affected rows. Read moreimpl<QS, Query, Value> AppearsOnTable<QS> for UncheckedBind<Query, Value>where
Self: Expression,
impl<Query: Copy, Value: Copy> Copy for UncheckedBind<Query, Value>
impl<Query, Value> NonAggregate for UncheckedBind<Query, Value>where
Self: Expression,
impl<QS, Query, Value> SelectableExpression<QS> for UncheckedBind<Query, Value>where
Self: AppearsOnTable<QS>,
Auto Trait Implementations§
impl<Query, Value> Freeze for UncheckedBind<Query, Value>
impl<Query, Value> RefUnwindSafe for UncheckedBind<Query, Value>where
Query: RefUnwindSafe,
Value: RefUnwindSafe,
impl<Query, Value> Send for UncheckedBind<Query, Value>
impl<Query, Value> Sync for UncheckedBind<Query, Value>
impl<Query, Value> Unpin for UncheckedBind<Query, Value>
impl<Query, Value> UnwindSafe for UncheckedBind<Query, Value>where
Query: UnwindSafe,
Value: UnwindSafe,
Blanket Implementations§
Source§impl<T> AsExpression<<T as Expression>::SqlType> for Twhere
T: Expression,
impl<T> AsExpression<<T as Expression>::SqlType> for Twhere
T: Expression,
Source§type Expression = T
type Expression = T
The expression being returned
Source§fn as_expression(self) -> T
fn as_expression(self) -> T
Perform the conversion
Source§impl<T> BoolExpressionMethods for Twhere
T: Expression<SqlType = Bool>,
impl<T> BoolExpressionMethods for Twhere
T: Expression<SqlType = Bool>,
Source§fn and<T: AsExpression<Bool>>(self, other: T) -> And<Self, T::Expression>
fn and<T: AsExpression<Bool>>(self, other: T) -> And<Self, T::Expression>
Creates a SQL
AND
expression Read moreSource§fn or<T: AsExpression<Bool>>(self, other: T) -> Grouped<Or<Self, T::Expression>>
fn or<T: AsExpression<Bool>>(self, other: T) -> Grouped<Or<Self, T::Expression>>
Creates a SQL
OR
expression Read moreSource§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
Source§impl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
Source§impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T
impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T
Source§impl<T> IntoSql for T
impl<T> IntoSql for T
Source§impl<T> NullableExpressionMethods for Twhere
T: Expression,
impl<T> NullableExpressionMethods for Twhere
T: Expression,
Source§impl<T, ST> PgArrayExpressionMethods<ST> for Twhere
T: Expression<SqlType = Array<ST>>,
impl<T, ST> PgArrayExpressionMethods<ST> for Twhere
T: Expression<SqlType = Array<ST>>,
Source§fn overlaps_with<T>(self, other: T) -> OverlapsWith<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
fn overlaps_with<T>(self, other: T) -> OverlapsWith<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
Creates a PostgreSQL
&&
expression. Read moreSource§fn contains<T>(self, other: T) -> Contains<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
fn contains<T>(self, other: T) -> Contains<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
Creates a PostgreSQL
@>
expression. Read moreSource§fn is_contained_by<T>(self, other: T) -> IsContainedBy<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
fn is_contained_by<T>(self, other: T) -> IsContainedBy<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
Creates a PostgreSQL
<@
expression. Read moreSource§impl<T> PgExpressionMethods for Twhere
T: Expression,
impl<T> PgExpressionMethods for Twhere
T: Expression,
Source§fn is_not_distinct_from<T>(
self,
other: T,
) -> IsNotDistinctFrom<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
fn is_not_distinct_from<T>(
self,
other: T,
) -> IsNotDistinctFrom<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
Creates a PostgreSQL
IS NOT DISTINCT FROM
expression. Read moreSource§fn is_distinct_from<T>(self, other: T) -> IsDistinctFrom<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
fn is_distinct_from<T>(self, other: T) -> IsDistinctFrom<Self, T::Expression>where
T: AsExpression<Self::SqlType>,
Creates a PostgreSQL
IS DISTINCT FROM
expression. Read more