Struct CreateTrigger 

pub struct CreateTrigger {

    pub or_alter: bool,
    pub or_replace: bool,
    pub is_constraint: bool,
    pub name: ObjectName,
    pub period: 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: TriggerObject,
    pub include_each: bool,
    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

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: 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.

-- 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: TriggerObject

This specifies whether the trigger function should be fired once for every row affected by the trigger event, or just once per SQL statement.

include_each: bool

Whether to include the EACH term of the FOR EACH, as it is optional syntax.

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<(), Error>

Formats the value using the given formatter.

impl Display for CreateTrigger

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

Formats the value using the given formatter.

impl From<CreateTrigger> for Statement

fn from(c: CreateTrigger) -> Statement

Converts to this type from the input type.

impl Hash for CreateTrigger

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

where __H: Hasher,

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 Visit for CreateTrigger

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

where V: Visitor,

impl VisitMut for CreateTrigger

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

where V: VisitorMut,

impl Eq for CreateTrigger

impl StructuralPartialEq for CreateTrigger