Struct scooby::postgres::statements::Update

pub struct Update { /* private fields */ }

UPDATE statement with at least one set of values, and possibly additional clauses.

Finalize and turn into String by calling to_string.

See update docs for more details and examples.

Implementations

impl Update

pub fn set( self, column: impl Into<Column>, value: impl Into<Expression> ) -> Self

Add a column + expression pair to the SET clause of this statement

use scooby::postgres::update;

let sql = update("Dummy").set("x", "$1").set("y", "$2").to_string();

assert_eq!(sql, "UPDATE Dummy SET x = $1, y = $2");

pub fn where_(self, conditions: impl IntoIteratorOfSameType<Condition>) -> Self

Add one or more WHERE conditions, AND’ed together with themselves and existing conditions.

use scooby::postgres::update;

let sql = update("Dummy")
    .set("x", "y + z")
    .where_(("x > 1", "y > 1"))
    .where_("z > 1")
    .to_string();

assert_eq!(sql, "UPDATE Dummy SET x = y + z WHERE x > 1 AND y > 1 AND z > 1");

pub fn returning( self, expressions: impl IntoIteratorOfSameType<OutputExpression> ) -> Self

Add one or more RETURNING expressions.

use scooby::postgres::update;

let sql = update("Dummy")
    .set("x", "$1")
    .returning("id")
    .returning(("width", "height"))
    .to_string();

assert_eq!(sql, "UPDATE Dummy SET x = $1 RETURNING id, width, height");

Trait Implementations

impl Clone for Update

fn clone(&self) -> Update

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Update

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

Formats the value using the given formatter.

impl Display for Update

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

Formats the value using the given formatter.