prorm API Reference
    Preparing search index...

    Interface TriggerOptions

    Options for creating a trigger

    interface TriggerOptions {
        name: string;
        tableName: string;
        timing: "BEFORE" | "AFTER" | "INSTEAD OF";
        events: ("INSERT" | "UPDATE" | "DELETE")[];
        body: string;
        level?: "ROW" | "STATEMENT";
        schema?: string;
        replace?: boolean;
        constraint?: string;
        referencing?: { oldRow?: string; newRow?: string };
        comment?: string;
        when?: string;
    }
    Index
    name tableName timing events body level? schema? replace? constraint? referencing? comment? when?
    name: string

    Trigger name

    tableName: string

    Table to attach trigger to

    timing: "BEFORE" | "AFTER" | "INSTEAD OF"

    Timing: BEFORE, AFTER, or INSTEAD OF

    events: ("INSERT" | "UPDATE" | "DELETE")[]

    Events: INSERT, UPDATE, DELETE

    body

    body: string

    Trigger body (SQL statements)

    level?: "ROW" | "STATEMENT"

    For each row or for each statement

    schema?: string

    Schema (for PostgreSQL)

    replace?: boolean

    If true, uses OR REPLACE

    constraint?: string

    Constraint name for triggers that fire on constraint

    referencing?: { oldRow?: string; newRow?: string }

    REFERENCING clause for transition tables (PostgreSQL)

    comment?: string

    Optional comment

    when?: string

    WHEN clause for conditional triggers (Oracle, PostgreSQL)

    Settings
    Member Visibility

    On This Page
    Properties