Struct Update

Source
pub struct Update<'a> { /* private fields */ }
Expand description

A builder for an UPDATE statement.

Implementations§

Source§

impl<'a> Update<'a>

Source

pub fn table<T>(table: T) -> Self
where T: Into<Table<'a>>,

Creates the basis for an UPDATE statement to the given table.

Source

pub fn set<K, V>(&mut self, column: K, value: V)
where K: Into<Column<'a>>, V: Into<Expression<'a>>,

Add another column value assignment to the query

let mut query = Update::table("users");
query.set("foo", 10);
query.set("bar", false);

let (sql, params) = renderer::Postgres::build(query);
assert_eq!(r#"UPDATE "users" SET "foo" = $1, "bar" = $2"#, sql);

assert_eq!(
    vec![
        Value::from(10),
        Value::from(false),
    ],
    params,
);
Source

pub fn so_that<T>(&mut self, conditions: T)
where T: Into<ConditionTree<'a>>,

Adds WHERE conditions to the query. See Comparable for more examples.

let mut query = Update::table("users");
query.set("foo", 1);
query.so_that("bar".equals(false));

let (sql, params) = renderer::Postgres::build(query);

assert_eq!(r#"UPDATE "users" SET "foo" = $1 WHERE "bar" = $2"#, sql);

assert_eq!(
    vec![
        Value::from(1),
        Value::from(false),
    ],
    params,
);

We can also use a nested SELECT in the conditions.

let mut select = Select::from_table("bars");
select.column("id");
select.so_that("uniq_val".equals(3));

let mut query = Update::table("users");
query.set("foo", 1);
query.so_that("bar".equals(select));

let (sql, params) = renderer::Postgres::build(query);

assert_eq!(
    r#"UPDATE "users" SET "foo" = $1 WHERE "bar" = (SELECT "id" FROM "bars" WHERE "uniq_val" = $2)"#,
    sql
);

assert_eq!(
    vec![
        Value::from(1),
        Value::from(3),
    ],
    params,
);
Source

pub fn returning<K, I>(&mut self, columns: I)
where K: Into<Column<'a>>, I: IntoIterator<Item = K>,

Sets the returned columns.

let mut update = Update::table("users");
update.set("foo", 10);
update.returning(vec!["id"]);

let (sql, _) = renderer::Postgres::build(update);

assert_eq!(r#"UPDATE "users" SET "foo" = $1 RETURNING "id""#, sql);

Trait Implementations§

Source§

impl<'a> Clone for Update<'a>

Source§

fn clone(&self) -> Update<'a>

Returns a copy of the value. Read more
1.0.0 · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more
Source§

impl<'a> Debug for Update<'a>

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl<'a> From<Update<'a>> for Query<'a>

Source§

fn from(update: Update<'a>) -> Self

Converts to this type from the input type.
Source§

impl<'a> PartialEq for Update<'a>

Source§

fn eq(&self, other: &Update<'a>) -> bool

Tests for self and other values to be equal, and is used by ==.
1.0.0 · Source§

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.
Source§

impl<'a> StructuralPartialEq for Update<'a>

Auto Trait Implementations§

§

impl<'a> Freeze for Update<'a>

§

impl<'a> RefUnwindSafe for Update<'a>

§

impl<'a> Send for Update<'a>

§

impl<'a> Sync for Update<'a>

§

impl<'a> Unpin for Update<'a>

§

impl<'a> UnwindSafe for Update<'a>

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

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

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.