[][src]Struct diesel::query_builder::UpdateStatement

#[must_use =
  "Queries are only executed when calling `load`, `get_result` or similar."]pub struct UpdateStatement<T, U, V = SetNotCalled, Ret = NoReturningClause> { /* fields omitted */ }

Represents a complete UPDATE statement.

See update for usage examples, or the update guide for a more exhaustive set of examples.

Implementations

impl<T, U> UpdateStatement<T, U, SetNotCalled>[src]

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
[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]

pub fn filter<Predicate>(self, predicate: Predicate) -> Filter<Self, Predicate> where
    Self: FilterDsl<Predicate>, 
[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
    DB: Backend,
    Self: BoxedDsl<'a, DB>, 
[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]

pub fn returning<E>(
    self,
    returns: E
) -> UpdateStatement<T, U, V, ReturningClause<E>> where
    T: Table,
    UpdateStatement<T, U, V, ReturningClause<E>>: Query
[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> 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>, 
[src]

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?

impl<'a, T, U, V, Ret, DB> BoxedDsl<'a, DB> for UpdateStatement<T, U, V, Ret> where
    U: Into<BoxedWhereClause<'a, DB>>, 
[src]

type Output = BoxedUpdateStatement<'a, DB, T, V, Ret>

The return type of internal_into_boxed

impl<T: Clone, U: Clone, V: Clone, Ret: Clone> Clone for UpdateStatement<T, U, V, Ret>[src]

impl<T: Copy, U: Copy, V: Copy, Ret: Copy> Copy for UpdateStatement<T, U, V, Ret>[src]

impl<T: Debug, U: Debug, V: Debug, Ret: Debug> Debug for UpdateStatement<T, U, V, Ret>[src]

impl<T, U, V, Ret, Predicate> FilterDsl<Predicate> for UpdateStatement<T, U, V, Ret> where
    U: WhereAnd<Predicate>,
    Predicate: AppearsOnTable<T>, 
[src]

type Output = UpdateStatement<T, U::Output, V, Ret>

The type returned by .filter.

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>, 
[src]

type SqlType = Ret::SqlType

The SQL type that this query represents. Read more

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> QueryId for UpdateStatement<T, U, V, Ret>[src]

type QueryId = ()

A type which uniquely represents Self in a SQL query. Read more

impl<T, U, V, Ret, Conn> RunQueryDsl<Conn> for UpdateStatement<T, U, V, Ret>[src]

Auto Trait Implementations

impl<T, U, V, Ret> RefUnwindSafe for UpdateStatement<T, U, V, Ret> where
    Ret: RefUnwindSafe,
    T: RefUnwindSafe,
    U: RefUnwindSafe,
    V: RefUnwindSafe

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> Unpin for UpdateStatement<T, U, V, Ret> where
    Ret: Unpin,
    T: Unpin,
    U: Unpin,
    V: Unpin

impl<T, U, V, Ret> UnwindSafe for UpdateStatement<T, U, V, Ret> where
    Ret: UnwindSafe,
    T: UnwindSafe,
    U: UnwindSafe,
    V: UnwindSafe

Blanket Implementations

impl<T> Any for T where
    T: 'static + ?Sized
[src]

impl<T> AsQuery for T where
    T: Query
[src]

type SqlType = <T as Query>::SqlType

The SQL type of Self::Query

type Query = T

What kind of query does this type represent?

impl<T> Borrow<T> for T where
    T: ?Sized
[src]

impl<T> BorrowMut<T> for T where
    T: ?Sized
[src]

impl<'a, T, DB> BoxedDsl<'a, DB> for T where
    T: Table + AsQuery,
    <T as AsQuery>::Query: BoxedDsl<'a, DB>, 
[src]

type Output = <<T as AsQuery>::Query as BoxedDsl<'a, DB>>::Output

The return type of internal_into_boxed

impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T where
    Conn: Connection<Backend = DB>,
    DB: Backend,
    T: QueryFragment<DB> + QueryId
[src]

impl<T, Predicate> FilterDsl<Predicate> for T where
    T: Table,
    <T as AsQuery>::Query: FilterDsl<Predicate>, 
[src]

type Output = <<T as AsQuery>::Query as FilterDsl<Predicate>>::Output

The type returned by .filter.

impl<T> From<T> for T[src]

impl<T, U> Into<U> for T where
    U: From<T>, 
[src]

impl<T> IntoSql for T[src]

impl<Conn, T, U> LoadQuery<Conn, U> for T where
    Conn: Connection,
    T: AsQuery + RunQueryDsl<Conn>,
    U: FromSqlRow<<T as AsQuery>::SqlType, <Conn as Connection>::Backend>,
    <T as AsQuery>::Query: QueryFragment<<Conn as Connection>::Backend>,
    <T as AsQuery>::Query: QueryId,
    <Conn as Connection>::Backend: QueryMetadata<<T as AsQuery>::SqlType>, 
[src]

impl<T, Conn> RunQueryDsl<Conn> for T where
    T: Table
[src]

impl<T> ToOwned for T where
    T: Clone
[src]

type Owned = T

The resulting type after obtaining ownership.

impl<T, U> TryFrom<U> for T where
    U: Into<T>, 
[src]

type Error = Infallible

The type returned in the event of a conversion error.

impl<T, U> TryInto<U> for T where
    U: TryFrom<T>, 
[src]

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.

impl<V, T> VZip<V> for T where
    V: MultiLane<T>, 
[src]