Struct Update

pub struct Update<'a, State = NoneSet> { /* private fields */ }

A struct for building UPDATE queries.

The query can only be executed once at least one update has been made.

Implementations

impl<'a, T> Update<'a, T>

pub fn new(table: &'static str) -> Update<'a, NoneSet>

Begin building a new UPDATE query.

pub fn where_(self, where_: Where<'a>) -> Update<'a, T>

Add a WHERE to the query.

If called multiple times, the conditions are joined using AND.

pub fn where_raw( self, statement: impl Into<String>, params: Vec<&'a (dyn ToSql + Sync)>, ) -> Update<'a, T>

Add a raw WHERE clause to your query.

You can reference the params by using the ? placeholder in your statement.

Note: you need to pass the exact types Postgres is expecting. Failure to do so will result in (sometimes confusing) runtime errors.

Otherwise this behaves exactly like where_.

Example

Book::select()
    .where_(Book::id.neq(&3))
    .where_raw("complex_function(book.title, ?, ?)", vec![&true, &"Foobar"])
    .await?;

pub fn set<U: ToSql + Sync>( self, col: TypedColumn<U>, value: &'a U, ) -> Update<'a, SomeSet>

Add a SET instruction to your UPDATE query.

This function has to be called at least once before you can execute the query.