Struct diesel::query_builder::UpdateStatement
source · pub struct UpdateStatement<T: QuerySource, U, V = SetNotCalled, Ret = NoReturningClause> { /* private fields */ }
Expand description
Represents a complete UPDATE
statement.
See update
for usage examples, or the update
guide for a more exhaustive
set of examples.
Implementations§
source§impl<T: QuerySource, U> UpdateStatement<T, U, SetNotCalled>
impl<T: QuerySource, U> UpdateStatement<T, U, SetNotCalled>
sourcepub fn set<V>(self, values: V) -> UpdateStatement<T, U, V::Changeset>where
T: Table,
V: AsChangeset<Target = T>,
UpdateStatement<T, U, V::Changeset>: AsQuery,
pub fn set<V>(self, values: V) -> UpdateStatement<T, U, V::Changeset>where T: Table, V: AsChangeset<Target = T>, UpdateStatement<T, U, V::Changeset>: AsQuery,
Provides the SET
clause of the UPDATE
statement.
See update
for usage examples, or the update
guide for a more exhaustive
set of examples.
source§impl<T: QuerySource, U, V, Ret> UpdateStatement<T, U, V, Ret>
impl<T: QuerySource, U, V, Ret> UpdateStatement<T, U, V, Ret>
sourcepub fn filter<Predicate>(self, predicate: Predicate) -> Filter<Self, Predicate>where
Self: FilterDsl<Predicate>,
pub fn filter<Predicate>(self, predicate: Predicate) -> Filter<Self, Predicate>where Self: FilterDsl<Predicate>,
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);
sourcepub fn into_boxed<'a, DB>(self) -> IntoBoxed<'a, Self, DB>where
DB: Backend,
Self: BoxedDsl<'a, DB>,
pub fn into_boxed<'a, DB>(self) -> IntoBoxed<'a, Self, DB>where DB: Backend, Self: BoxedDsl<'a, DB>,
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);
source§impl<T: QuerySource, U, V> UpdateStatement<T, U, V, NoReturningClause>
impl<T: QuerySource, U, V> UpdateStatement<T, U, V, NoReturningClause>
sourcepub fn returning<E>(
self,
returns: E
) -> UpdateStatement<T, U, V, ReturningClause<E>>where
T: Table,
UpdateStatement<T, U, V, ReturningClause<E>>: Query,
pub fn returning<E>( self, returns: E ) -> UpdateStatement<T, U, V, ReturningClause<E>>where T: Table, UpdateStatement<T, U, V, ReturningClause<E>>: Query,
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§
source§impl<T, U, V> AsQuery for UpdateStatement<T, U, V, NoReturningClause>where
T: Table,
UpdateStatement<T, U, V, ReturningClause<T::AllColumns>>: Query,
T::AllColumns: ValidGrouping<()>,
<T::AllColumns as ValidGrouping<()>>::IsAggregate: MixedAggregates<No, Output = No>,
impl<T, U, V> AsQuery for UpdateStatement<T, U, V, NoReturningClause>where T: Table, UpdateStatement<T, U, V, ReturningClause<T::AllColumns>>: Query, T::AllColumns: ValidGrouping<()>, <T::AllColumns as ValidGrouping<()>>::IsAggregate: MixedAggregates<No, Output = No>,
§type SqlType = <<UpdateStatement<T, U, V, NoReturningClause> as AsQuery>::Query as Query>::SqlType
type SqlType = <<UpdateStatement<T, U, V, NoReturningClause> as AsQuery>::Query as Query>::SqlType
Self::Query
§type Query = UpdateStatement<T, U, V, ReturningClause<<T as Table>::AllColumns>>
type Query = UpdateStatement<T, U, V, ReturningClause<<T as Table>::AllColumns>>
source§impl<'a, T, U, V, Ret, DB> BoxedDsl<'a, DB> for UpdateStatement<T, U, V, Ret>where
T: QuerySource,
U: Into<BoxedWhereClause<'a, DB>>,
impl<'a, T, U, V, Ret, DB> BoxedDsl<'a, DB> for UpdateStatement<T, U, V, Ret>where T: QuerySource, U: Into<BoxedWhereClause<'a, DB>>,
§type Output = UpdateStatement<T, BoxedWhereClause<'a, DB>, V, Ret>
type Output = UpdateStatement<T, BoxedWhereClause<'a, DB>, V, Ret>
internal_into_boxed
source§fn internal_into_boxed(self) -> Self::Output
fn internal_into_boxed(self) -> Self::Output
source§impl<T: Clone + QuerySource, U: Clone, V: Clone, Ret: Clone> Clone for UpdateStatement<T, U, V, Ret>where
T::FromClause: Clone,
impl<T: Clone + QuerySource, U: Clone, V: Clone, Ret: Clone> Clone for UpdateStatement<T, U, V, Ret>where T::FromClause: Clone,
source§fn clone(&self) -> UpdateStatement<T, U, V, Ret>
fn clone(&self) -> UpdateStatement<T, U, V, Ret>
1.0.0 · source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source
. Read moresource§impl<T: Debug + QuerySource, U: Debug, V: Debug, Ret: Debug> Debug for UpdateStatement<T, U, V, Ret>where
T::FromClause: Debug,
impl<T: Debug + QuerySource, U: Debug, V: Debug, Ret: Debug> Debug for UpdateStatement<T, U, V, Ret>where T::FromClause: Debug,
source§impl<T, U, V, Ret, Predicate> FilterDsl<Predicate> for UpdateStatement<T, U, V, Ret>where
T: QuerySource,
U: WhereAnd<Predicate>,
Predicate: AppearsOnTable<T>,
impl<T, U, V, Ret, Predicate> FilterDsl<Predicate> for UpdateStatement<T, U, V, Ret>where T: QuerySource, U: WhereAnd<Predicate>, Predicate: AppearsOnTable<T>,
source§impl<T, U, V, Ret> Query for UpdateStatement<T, U, V, ReturningClause<Ret>>where
T: Table,
Ret: Expression + SelectableExpression<T> + ValidGrouping<()>,
Ret::IsAggregate: MixedAggregates<No, Output = No>,
impl<T, U, V, Ret> Query for UpdateStatement<T, U, V, ReturningClause<Ret>>where T: Table, Ret: Expression + SelectableExpression<T> + ValidGrouping<()>, Ret::IsAggregate: MixedAggregates<No, Output = No>,
§type SqlType = <Ret as Expression>::SqlType
type SqlType = <Ret as Expression>::SqlType
source§impl<T, U, V, Ret> QueryId for UpdateStatement<T, U, V, Ret>where
T: QuerySource,
impl<T, U, V, Ret> QueryId for UpdateStatement<T, U, V, Ret>where T: QuerySource,
source§const HAS_STATIC_QUERY_ID: bool = false
const HAS_STATIC_QUERY_ID: bool = false
Self
be uniquely identified by its type? Read moresource§impl<T: QuerySource, U, V, Ret, Conn> RunQueryDsl<Conn> for UpdateStatement<T, U, V, Ret>
impl<T: QuerySource, U, V, Ret, Conn> RunQueryDsl<Conn> for UpdateStatement<T, U, V, Ret>
source§fn load<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>where
Self: LoadQuery<'query, Conn, U>,
fn load<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>where Self: LoadQuery<'query, Conn, U>,
source§fn load_iter<'conn, 'query: 'conn, U, B>(
self,
conn: &'conn mut Conn
) -> QueryResult<LoadIter<'conn, 'query, Self, Conn, U, B>>where
U: 'conn,
Self: LoadQuery<'query, Conn, U, B> + 'conn,
fn load_iter<'conn, 'query: 'conn, U, B>( self, conn: &'conn mut Conn ) -> QueryResult<LoadIter<'conn, 'query, Self, Conn, U, B>>where U: 'conn, Self: LoadQuery<'query, Conn, U, B> + 'conn,
source§fn get_result<'query, U>(self, conn: &mut Conn) -> QueryResult<U>where
Self: LoadQuery<'query, Conn, U>,
fn get_result<'query, U>(self, conn: &mut Conn) -> QueryResult<U>where Self: LoadQuery<'query, Conn, U>,
source§fn get_results<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>where
Self: LoadQuery<'query, Conn, U>,
fn get_results<'query, U>(self, conn: &mut Conn) -> QueryResult<Vec<U>>where Self: LoadQuery<'query, Conn, U>,
Vec
with the affected rows. Read moreAuto Trait Implementations§
impl<T, U, V, Ret> RefUnwindSafe for UpdateStatement<T, U, V, Ret>where Ret: RefUnwindSafe, U: RefUnwindSafe, V: RefUnwindSafe, <T as QuerySource>::FromClause: RefUnwindSafe,
impl<T, U, V, Ret> Send for UpdateStatement<T, U, V, Ret>where Ret: Send, U: Send, V: Send, <T as QuerySource>::FromClause: Send,
impl<T, U, V, Ret> Sync for UpdateStatement<T, U, V, Ret>where Ret: Sync, U: Sync, V: Sync, <T as QuerySource>::FromClause: Sync,
impl<T, U, V, Ret> Unpin for UpdateStatement<T, U, V, Ret>where Ret: Unpin, U: Unpin, V: Unpin, <T as QuerySource>::FromClause: Unpin,
impl<T, U, V, Ret> UnwindSafe for UpdateStatement<T, U, V, Ret>where Ret: UnwindSafe, U: UnwindSafe, V: UnwindSafe, <T as QuerySource>::FromClause: UnwindSafe,
Blanket Implementations§
source§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
source§impl<Conn, DB, T> ExecuteDsl<Conn, DB> for Twhere
Conn: Connection<Backend = DB>,
DB: Backend,
T: QueryFragment<DB, NotSpecialized> + QueryId,
impl<Conn, DB, T> ExecuteDsl<Conn, DB> for Twhere Conn: Connection<Backend = DB>, DB: Backend, T: QueryFragment<DB, NotSpecialized> + QueryId,
source§impl<T> IntoSql for T
impl<T> IntoSql for T
source§fn into_sql<T>(self) -> AsExprOf<Self, T>where
Self: AsExpression<T> + Sized,
T: SqlType + TypedExpressionType,
fn into_sql<T>(self) -> AsExprOf<Self, T>where Self: AsExpression<T> + Sized, T: SqlType + TypedExpressionType,
self
to an expression for Diesel’s query builder. Read moresource§fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T>where
&'a Self: AsExpression<T>,
T: SqlType + TypedExpressionType,
fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T>where &'a Self: AsExpression<T>, T: SqlType + TypedExpressionType,
&self
to an expression for Diesel’s query builder. Read more