Struct TriggerBuilder 

pub struct TriggerBuilder { /* private fields */ }

Builder for creating triggers.

Implementations

impl TriggerBuilder

pub fn new(name: impl Into<String>) -> Self

Create a new trigger builder.

pub fn schema(self, schema: impl Into<String>) -> Self

Set the schema.

pub fn on_table(self, table: impl Into<String>) -> Self

Set the table/view the trigger is on.

pub fn on_view(self, view: impl Into<String>) -> Self

Alias for on_table.

pub fn timing(self, timing: TriggerTiming) -> Self

Set the trigger timing.

pub fn before(self) -> Self

Set timing to BEFORE.

pub fn after(self) -> Self

Set timing to AFTER.

pub fn instead_of(self) -> Self

Set timing to INSTEAD OF.

pub fn event(self, event: TriggerEvent) -> Self

Add a triggering event.

pub fn events(self, events: impl IntoIterator<Item = TriggerEvent>) -> Self

Add multiple triggering events.

pub fn on_insert(self) -> Self

Trigger on INSERT.

pub fn on_update(self) -> Self

Trigger on UPDATE.

pub fn on_delete(self) -> Self

Trigger on DELETE.

pub fn on_truncate(self) -> Self

Trigger on TRUNCATE (PostgreSQL only).

pub fn level(self, level: TriggerLevel) -> Self

Set the trigger level.

pub fn for_each_row(self) -> Self

Set to row-level trigger.

pub fn for_each_statement(self) -> Self

Set to statement-level trigger.

pub fn update_of( self, columns: impl IntoIterator<Item = impl Into<String>>, ) -> Self

Specify columns for UPDATE OF.

pub fn when(self, condition: TriggerCondition) -> Self

Add a WHEN condition.

pub fn when_expr(self, expression: impl Into<String>) -> Self

Add a WHEN condition from a raw expression.

pub fn execute_function(self, name: impl Into<String>) -> Self

Set the action to execute a function.

pub fn execute_function_with_args( self, name: impl Into<String>, args: impl IntoIterator<Item = impl Into<String>>, ) -> Self

Set the action to execute a function with arguments.

pub fn execute_sql( self, statements: impl IntoIterator<Item = impl Into<String>>, ) -> Self

Set the action to inline SQL.

pub fn enabled(self, enabled: bool) -> Self

Set whether the trigger is enabled.

pub fn comment(self, comment: impl Into<String>) -> Self

Add a comment/description.

pub fn build(self) -> QueryResult<Trigger>

Build the trigger.

Trait Implementations

impl Clone for TriggerBuilder

fn clone(&self) -> TriggerBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for TriggerBuilder

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

Formats the value using the given formatter.