Struct CreateTrigger 

pub struct CreateTrigger {

    pub or_alter: bool,
    pub temporary: bool,
    pub or_replace: bool,
    pub is_constraint: bool,
    pub name: ObjectName,
    pub period: Option<TriggerPeriod>,
    pub period_before_table: bool,
    pub events: Vec<TriggerEvent>,
    pub table_name: ObjectName,
    pub referenced_table_name: Option<ObjectName>,
    pub referencing: Vec<TriggerReferencing>,
    pub trigger_object: Option<TriggerObjectKind>,
    pub condition: Option<Expr>,
    pub exec_body: Option<TriggerExecBody>,
    pub statements_as: bool,
    pub statements: Option<ConditionalStatements>,
    pub characteristics: Option<ConstraintCharacteristics>,
}

CREATE TRIGGER

Examples:

CREATE TRIGGER trigger_name
BEFORE INSERT ON table_name
FOR EACH ROW
EXECUTE FUNCTION trigger_function();

Postgres: https://www.postgresql.org/docs/current/sql-createtrigger.html SQL Server: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql

Fields

or_alter: bool

True if this is a CREATE OR ALTER TRIGGER statement

MsSql

temporary: bool

True if this is a temporary trigger.

Examples:

CREATE TEMP TRIGGER trigger_name

or

CREATE TEMPORARY TRIGGER trigger_name;
CREATE TEMP TRIGGER trigger_name;

SQLite

or_replace: bool

The OR REPLACE clause is used to re-create the trigger if it already exists.

Example:

CREATE OR REPLACE TRIGGER trigger_name
AFTER INSERT ON table_name
FOR EACH ROW
EXECUTE FUNCTION trigger_function();

is_constraint: bool

The CONSTRAINT keyword is used to create a trigger as a constraint.

name: ObjectName

The name of the trigger to be created.

period: Option<TriggerPeriod>

Determines whether the function is called before, after, or instead of the event.

Example of BEFORE:

CREATE TRIGGER trigger_name
BEFORE INSERT ON table_name
FOR EACH ROW
EXECUTE FUNCTION trigger_function();

Example of AFTER:

CREATE TRIGGER trigger_name
AFTER INSERT ON table_name
FOR EACH ROW
EXECUTE FUNCTION trigger_function();

Example of INSTEAD OF:

CREATE TRIGGER trigger_name
INSTEAD OF INSERT ON table_name
FOR EACH ROW
EXECUTE FUNCTION trigger_function();

period_before_table: bool

Whether the trigger period was specified before the target table name. This does not refer to whether the period is BEFORE, AFTER, or INSTEAD OF, but rather the position of the period clause in relation to the table name.

-- period_before_table == true: Postgres, MySQL, and standard SQL
CREATE TRIGGER t BEFORE INSERT ON table_name ...;
-- period_before_table == false: MSSQL
CREATE TRIGGER t ON table_name BEFORE INSERT ...;

events: Vec<TriggerEvent>

Multiple events can be specified using OR, such as INSERT, UPDATE, DELETE, or TRUNCATE.

table_name: ObjectName

The table on which the trigger is to be created.

referenced_table_name: Option<ObjectName>

The optional referenced table name that can be referenced via the FROM keyword.

referencing: Vec<TriggerReferencing>

This keyword immediately precedes the declaration of one or two relation names that provide access to the transition relations of the triggering statement.

trigger_object: Option<TriggerObjectKind>

This specifies whether the trigger function should be fired once for every row affected by the trigger event, or just once per SQL statement. This is optional in some SQL dialects, such as SQLite, and if not specified, in those cases, the implied default is FOR EACH ROW.

condition: Option<Expr>

Triggering conditions

exec_body: Option<TriggerExecBody>

Execute logic block

statements_as: bool

For MSSQL and dialects where statements are preceded by AS

statements: Option<ConditionalStatements>

For SQL dialects with statement(s) for a body

characteristics: Option<ConstraintCharacteristics>

The characteristic of the trigger, which include whether the trigger is DEFERRABLE, INITIALLY DEFERRED, or INITIALLY IMMEDIATE,

Trait Implementations

impl Clone for CreateTrigger

fn clone(&self) -> CreateTrigger

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateTrigger

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for CreateTrigger

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for CreateTrigger

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

Formats the value using the given formatter.

impl From<CreateTrigger> for Statement

fn from(c: CreateTrigger) -> Self

Converts to this type from the input type.

impl Hash for CreateTrigger

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for CreateTrigger

fn cmp(&self, other: &CreateTrigger) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for CreateTrigger

fn eq(&self, other: &CreateTrigger) -> 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 PartialOrd for CreateTrigger

fn partial_cmp(&self, other: &CreateTrigger) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for CreateTrigger

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Visit for CreateTrigger

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

impl VisitMut for CreateTrigger

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

impl Eq for CreateTrigger

impl StructuralPartialEq for CreateTrigger