Struct Trigger 

pub struct Trigger {
    pub name: String,
    pub timing: TriggerTiming,
    pub operation: TriggerOperation,
    pub table: String,
    pub for_each: ForEachType,
    pub condition: Option<String>,
    pub body: Vec<String>,
    pub created_at: u64,
}

SQL 표준 Trigger

Fields

name: String

Trigger 이름

timing: TriggerTiming

타이밍 (BEFORE/AFTER)

operation: TriggerOperation

작업 (INSERT/UPDATE/DELETE)

table: String

대상 테이블

for_each: ForEachType

FOR EACH ROW/STATEMENT

condition: Option<String>

WHEN 조건 (SQL 표현식)

body: Vec<String>

실행할 SQL 문장들

created_at: u64

생성 시각

Implementations

impl Trigger

pub fn new( name: impl Into<String>, timing: TriggerTiming, operation: TriggerOperation, table: impl Into<String>, for_each: ForEachType, condition: Option<String>, body: Vec<String>, ) -> Self

새 SQL Trigger 생성

pub fn to_json(&self) -> DbxResult<String>

Trigger를 JSON으로 직렬화

pub fn from_json(json: &str) -> DbxResult<Self>

JSON에서 Trigger 역직렬화

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