Struct Trigger 

pub struct Trigger {
    pub name: String,
    pub schema: Option<String>,
    pub table: String,
    pub timing: TriggerTiming,
    pub events: HashSet<TriggerEvent>,
    pub level: TriggerLevel,
    pub update_of: Option<UpdateOf>,
    pub condition: Option<TriggerCondition>,
    pub action: TriggerAction,
    pub enabled: bool,
    pub comment: Option<String>,
}

A database trigger definition.

Fields

name: String

Trigger name.

schema: Option<String>

Schema name (optional).

table: String

Table or view the trigger is attached to.

timing: TriggerTiming

When the trigger fires (BEFORE/AFTER/INSTEAD OF).

events: HashSet<TriggerEvent>

Events that fire the trigger.

level: TriggerLevel

Row-level or statement-level.

update_of: Option<UpdateOf>

Optional column list for UPDATE OF.

condition: Option<TriggerCondition>

Optional WHEN condition.

action: TriggerAction

The action to execute.

enabled: bool

Whether the trigger is enabled.

comment: Option<String>

Optional comment/description.

Implementations

impl Trigger

pub fn builder(name: impl Into<String>) -> TriggerBuilder

Create a new trigger builder.

pub fn qualified_name(&self) -> Cow<'_, str>

Get the fully qualified trigger name.

pub fn qualified_table(&self) -> Cow<'_, str>

Get the fully qualified table name.

pub fn to_postgres_sql(&self) -> QueryResult<String>

Generate PostgreSQL CREATE TRIGGER SQL.

pub fn to_mysql_sql(&self) -> QueryResult<String>

Generate MySQL CREATE TRIGGER SQL.

pub fn to_sqlite_sql(&self) -> QueryResult<String>

Generate SQLite CREATE TRIGGER SQL.

pub fn to_mssql_sql(&self) -> QueryResult<String>

Generate MSSQL CREATE TRIGGER SQL.

pub fn to_sql(&self, db_type: DatabaseType) -> QueryResult<String>

Generate SQL for the configured database type.

pub fn drop_sql(&self, db_type: DatabaseType) -> String

Generate DROP TRIGGER SQL.

Trait Implementations

impl Clone for Trigger

fn clone(&self) -> Trigger

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Trigger

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Trigger

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for Trigger

fn eq(&self, other: &Trigger) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for Trigger

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for Trigger

impl StructuralPartialEq for Trigger