[−][src]Struct diesel::query_builder::UpdateStatement
Represents a complete UPDATE
statement.
See update
for usage examples, or the update
guide for a more exhaustive
set of examples.
Methods
impl<T, U> UpdateStatement<T, U, SetNotCalled>
[src]
impl<T, U> UpdateStatement<T, U, SetNotCalled>
pub fn set<V>(self, values: V) -> UpdateStatement<T, U, V::Changeset> where | [src] |
Provides the SET
clause of the UPDATE
statement.
See update
for usage examples, or the update
guide for a more exhaustive
set of examples.
impl<T, U, V, Ret> UpdateStatement<T, U, V, Ret>
[src]
impl<T, U, V, Ret> UpdateStatement<T, U, V, Ret>
pub fn filter<Predicate>(self, predicate: Predicate) -> Filter<Self, Predicate> where | [src] |
Adds the given predicate to the WHERE
clause of the statement being
constructed.
If there is already a WHERE
clause, the predicate will be appended
with AND
. There is no difference in behavior between
update(table.filter(x))
and update(table).filter(x)
.
Example
let updated_rows = diesel::update(users) .set(name.eq("Jim")) .filter(name.eq("Sean")) .execute(&connection); assert_eq!(Ok(1), updated_rows); let expected_names = vec!["Jim".to_string(), "Tess".to_string()]; let names = users.select(name).order(id).load(&connection); assert_eq!(Ok(expected_names), names);
pub fn into_boxed<'a, DB>(self) -> IntoBoxed<'a, Self, DB> where | [src] |
Boxes the WHERE
clause of this update statement.
This is useful for cases where you want to conditionally modify a query, but need the type to remain the same. The backend must be specified as part of this. It is not possible to box a query and have it be useable on multiple backends.
A boxed query will incur a minor performance penalty, as the query builder can no longer be inlined by the compiler. For most applications this cost will be minimal.
Example
let mut query = diesel::update(users) .set(name.eq("Jerk")) .into_boxed(); if !params["tess_has_been_a_jerk"] { query = query.filter(name.ne("Tess")); } let updated_rows = query.execute(&connection)?; assert_eq!(1, updated_rows); let expected_names = vec!["Jerk", "Tess"]; let names = users.select(name).order(id).load::<String>(&connection)?; assert_eq!(expected_names, names);
impl<T, U, V> UpdateStatement<T, U, V, NoReturningClause>
[src]
impl<T, U, V> UpdateStatement<T, U, V, NoReturningClause>
pub fn returning<E>( | [src] |
Specify what expression is returned after execution of the update
.
Examples
Updating a single record:
let updated_name = diesel::update(users.filter(id.eq(1))) .set(name.eq("Dean")) .returning(name) .get_result(&connection); assert_eq!(Ok("Dean".to_string()), updated_name);
Trait Implementations
impl<T, U, V, Ret> QueryId for UpdateStatement<T, U, V, Ret>
[src]
impl<T, U, V, Ret> QueryId for UpdateStatement<T, U, V, Ret>
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] |
Returns the type id of Self::QueryId
if Self::HAS_STATIC_QUERY_ID
. Returns None
otherwise. Read more
impl<T, U, V, Ret> Query for UpdateStatement<T, U, V, ReturningClause<Ret>> where
T: Table,
Ret: Expression + SelectableExpression<T> + NonAggregate,
[src]
impl<T, U, V, Ret> Query for UpdateStatement<T, U, V, ReturningClause<Ret>> where
T: Table,
Ret: Expression + SelectableExpression<T> + NonAggregate,
impl<T, U, V, Ret, DB> QueryFragment<DB> for UpdateStatement<T, U, V, Ret> where
DB: Backend,
T: Table,
T::FromClause: QueryFragment<DB>,
U: QueryFragment<DB>,
V: QueryFragment<DB>,
Ret: QueryFragment<DB>,
[src]
impl<T, U, V, Ret, DB> QueryFragment<DB> for UpdateStatement<T, U, V, Ret> where
DB: Backend,
T: Table,
T::FromClause: QueryFragment<DB>,
U: QueryFragment<DB>,
V: QueryFragment<DB>,
Ret: QueryFragment<DB>,
fn walk_ast(&self, out: AstPass<DB>) -> QueryResult<()> | [src] |
fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()> | [src] |
Converts this QueryFragment
to its SQL representation. Read more
fn collect_binds( | [src] |
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<T, U, V> AsQuery for UpdateStatement<T, U, V, NoReturningClause> where
T: Table,
UpdateStatement<T, U, V, ReturningClause<T::AllColumns>>: Query,
[src]
impl<T, U, V> AsQuery for UpdateStatement<T, U, V, NoReturningClause> where
T: Table,
UpdateStatement<T, U, V, ReturningClause<T::AllColumns>>: Query,
type SqlType = <Self::Query as Query>::SqlType
The SQL type of Self::Query
type Query = UpdateStatement<T, U, V, ReturningClause<T::AllColumns>>
What kind of query does this type represent?
fn as_query(self) -> Self::Query | [src] |
impl<'a, T, U, V, Ret, DB> BoxedDsl<'a, DB> for UpdateStatement<T, U, V, Ret> where
U: Into<BoxedWhereClause<'a, DB>>,
[src]
impl<'a, T, U, V, Ret, DB> BoxedDsl<'a, DB> for UpdateStatement<T, U, V, Ret> where
U: Into<BoxedWhereClause<'a, DB>>,
type Output = BoxedUpdateStatement<'a, DB, T, V, Ret>
The return type of internal_into_boxed
fn internal_into_boxed(self) -> Self::Output | [src] |
impl<T, U, V, Ret, Predicate> FilterDsl<Predicate> for UpdateStatement<T, U, V, Ret> where
U: WhereAnd<Predicate>,
Predicate: AppearsOnTable<T>,
[src]
impl<T, U, V, Ret, Predicate> FilterDsl<Predicate> for UpdateStatement<T, U, V, Ret> where
U: WhereAnd<Predicate>,
Predicate: AppearsOnTable<T>,
type Output = UpdateStatement<T, U::Output, V, Ret>
The type returned by .filter
.
fn filter(self, predicate: Predicate) -> Self::Output | [src] |
impl<T, U, V, Ret, Conn> RunQueryDsl<Conn> for UpdateStatement<T, U, V, Ret>
[src]
impl<T, U, V, Ret, Conn> RunQueryDsl<Conn> for UpdateStatement<T, U, V, Ret>
fn execute(self, conn: &Conn) -> QueryResult<usize> where | [src] |
Executes the given command, returning the number of rows affected. Read more
fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where | [src] |
Executes the given query, returning a Vec
with the returned rows. Read more
fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where | [src] |
Runs the command, and returns the affected row. Read more
fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where | [src] |
Runs the command, returning an Vec
with the affected rows. Read more
fn first<U>(self, conn: &Conn) -> QueryResult<U> where | [src] |
Attempts to load a single record. Read more
impl<T: Copy, U: Copy, V: Copy, Ret: Copy> Copy for UpdateStatement<T, U, V, Ret>
[src]
impl<T: Copy, U: Copy, V: Copy, Ret: Copy> Copy for UpdateStatement<T, U, V, Ret>
impl<T: Clone, U: Clone, V: Clone, Ret: Clone> Clone for UpdateStatement<T, U, V, Ret>
[src]
impl<T: Clone, U: Clone, V: Clone, Ret: Clone> Clone for UpdateStatement<T, U, V, Ret>
fn clone(&self) -> UpdateStatement<T, U, V, Ret> | [src] |
fn clone_from(&mut self, source: &Self) | 1.0.0 [src] |
Performs copy-assignment from source
. Read more
impl<T: Debug, U: Debug, V: Debug, Ret: Debug> Debug for UpdateStatement<T, U, V, Ret>
[src]
impl<T: Debug, U: Debug, V: Debug, Ret: Debug> Debug for UpdateStatement<T, U, V, Ret>
Auto Trait Implementations
impl<T, U, V, Ret> Send for UpdateStatement<T, U, V, Ret> where
Ret: Send,
T: Send,
U: Send,
V: Send,
impl<T, U, V, Ret> Send for UpdateStatement<T, U, V, Ret> where
Ret: Send,
T: Send,
U: Send,
V: Send,
impl<T, U, V, Ret> Sync for UpdateStatement<T, U, V, Ret> where
Ret: Sync,
T: Sync,
U: Sync,
V: Sync,
impl<T, U, V, Ret> Sync for UpdateStatement<T, U, V, Ret> where
Ret: Sync,
T: Sync,
U: Sync,
V: Sync,
Blanket Implementations
impl<T> IntoSql for T
[src]
impl<T> IntoSql for T
fn into_sql<T>(self) -> AsExprOf<Self, T> where | [src] |
Convert self
to an expression for Diesel's query builder. Read more
fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where | [src] |
Convert &self
to an expression for Diesel's query builder. Read more
impl<T> AsQuery for T where
T: Query,
[src]
impl<T> AsQuery for T where
T: Query,
type SqlType = <T as Query>::SqlType
The SQL type of Self::Query
type Query = T
What kind of query does this type represent?
fn as_query(Self) -> <T as AsQuery>::Query | [src] |
impl<'a, T, DB> BoxedDsl for T where
T: Table + AsQuery,
<T as AsQuery>::Query: BoxedDsl<'a, DB>,
[src]
impl<'a, T, DB> BoxedDsl for T where
T: Table + AsQuery,
<T as AsQuery>::Query: BoxedDsl<'a, DB>,
type Output = <<T as AsQuery>::Query as BoxedDsl<'a, DB>>::Output
The return type of internal_into_boxed
fn internal_into_boxed(Self) -> <T as BoxedDsl<'a, DB>>::Output | [src] |
impl<T, Predicate> FilterDsl for T where
T: Table,
<T as AsQuery>::Query: FilterDsl<Predicate>,
[src]
impl<T, Predicate> FilterDsl for T where
T: Table,
<T as AsQuery>::Query: FilterDsl<Predicate>,
type Output = <<T as AsQuery>::Query as FilterDsl<Predicate>>::Output
The type returned by .filter
.
fn filter(Self, Predicate) -> <T as FilterDsl<Predicate>>::Output | [src] |
impl<Conn, T, U> LoadQuery 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]
impl<Conn, T, U> LoadQuery 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,
impl<Conn, DB, T> ExecuteDsl for T where
Conn: Connection<Backend = DB>,
DB: Backend,
T: QueryFragment<DB> + QueryId,
[src]
impl<Conn, DB, T> ExecuteDsl for T where
Conn: Connection<Backend = DB>,
DB: Backend,
T: QueryFragment<DB> + QueryId,
impl<T, Conn> RunQueryDsl for T where
T: Table,
[src]
impl<T, Conn> RunQueryDsl for T where
T: Table,
fn execute(self, conn: &Conn) -> QueryResult<usize> where | [src] |
Executes the given command, returning the number of rows affected. Read more
fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where | [src] |
Executes the given query, returning a Vec
with the returned rows. Read more
fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where | [src] |
Runs the command, and returns the affected row. Read more
fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where | [src] |
Runs the command, returning an Vec
with the affected rows. Read more
fn first<U>(self, conn: &Conn) -> QueryResult<U> where | [src] |
Attempts to load a single record. Read more
impl<T> From for T
[src]
impl<T> From for T
impl<T, U> Into for T where
U: From<T>,
[src]
impl<T, U> Into for T where
U: From<T>,
impl<T> ToOwned for T where
T: Clone,
[src]
impl<T> ToOwned for T where
T: Clone,
impl<T, U> TryFrom for T where
T: From<U>,
[src]
impl<T, U> TryFrom for T where
T: From<U>,
type Error = !
try_from
)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> Borrow for T where
T: ?Sized,
[src]
impl<T> Borrow for T where
T: ?Sized,
impl<T> BorrowMut for T where
T: ?Sized,
[src]
impl<T> BorrowMut for T where
T: ?Sized,
fn borrow_mut(&mut self) -> &mut T | [src] |
impl<T, U> TryInto for T where
U: TryFrom<T>,
[src]
impl<T, U> TryInto for T where
U: TryFrom<T>,
type Error = <U as TryFrom<T>>::Error
try_from
)The type returned in the event of a conversion error.
fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error> | [src] |
impl<T> Any for T where
T: 'static + ?Sized,
[src]
impl<T> Any for T where
T: 'static + ?Sized,
fn get_type_id(&self) -> TypeId | [src] |