Struct UpdateBuilder 

pub struct UpdateBuilder { /* private fields */ }

Runtime UPDATE query builder for custom updates.

Accepts either a &DbPool or a &mut Transaction via execute().

Implementations

impl UpdateBuilder

pub fn table(table: &str) -> Self

pub fn set<T>(self, column: &str, value: T) -> Self

where T: Type<Db> + Encode<'static, Db> + Send + 'static,

SET column = ? with a bound value

pub fn set_raw(self, column: &str, expr: &str) -> Self

SET column = (e.g. NOW(), NULL, column + 1)

pub fn set_if<T>(self, column: &str, value: Option<T>) -> Self

where T: Type<Db> + Encode<'static, Db> + Send + 'static,

SET column = ? only if value is Some, skip if None

pub fn where_eq<T>(self, column: &str, value: T) -> Self

where T: Type<Db> + Encode<'static, Db> + Send + 'static,

WHERE column = ? with a bound value

pub fn where_raw(self, condition: &str) -> Self

WHERE (e.g. “revoked = FALSE”, “expires_at > NOW()”)

pub fn where_ne<T>(self, column: &str, value: T) -> Self

where T: Type<Db> + Encode<'static, Db> + Send + 'static,

WHERE column != ? with a bound value

pub async fn execute<'e, E>(self, executor: E) -> AppResult<u64>

where E: Executor<'e, Database = Db>,

Execute the UPDATE and return rows_affected