Struct UpdateBuilder 

pub struct UpdateBuilder<D: Dialect> { /* private fields */ }

Builder for UPDATE queries.

Implementations

impl<D: Dialect> UpdateBuilder<D>

pub fn new(dialect: D, table: impl Into<String>) -> Self

Create a new update builder.

Panics

Panics if the table name is not a valid SQL identifier.

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

Set a column to a value.

Panics

Panics if the column name is not a valid SQL identifier.

pub fn set_many(self, pairs: Vec<(&str, Value)>) -> Self

Set multiple columns at once.

Panics

Panics if any column name is not a valid SQL identifier.

pub fn filter( self, field: impl Into<String>, op: Operator, value: Value, ) -> Self

Add a simple WHERE filter.

Panics

Panics if the field name is not a valid SQL identifier.

pub fn filter_expr(self, expr: FilterExpr) -> Self

Set a compound filter expression (AND, OR, NOT). Use with simple(), and(), or(), not() helpers.

pub fn returning(self, columns: &[&str]) -> Self

Add RETURNING clause (Postgres).

Panics

Panics if any column name is not a valid SQL identifier.

pub fn build(self) -> QueryResult

Build the UPDATE query.

Trait Implementations

impl<D: Debug + Dialect> Debug for UpdateBuilder<D>

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

Formats the value using the given formatter.