Function strip_create_trigger_prefix

nodedb-sql/src/ddl_ast/parse/trigger.rs:122–138

Strip `CREATE [OR REPLACE] [SYNC|DEFERRED] TRIGGER ` prefix. Returns `(or_replace, execution_mode, original_rest)`.

(upper: &str, original: &'a str)

/// Strip `CREATE [OR REPLACE] [SYNC|DEFERRED] TRIGGER ` prefix.
/// Returns `(or_replace, execution_mode, original_rest)`.
fn strip_create_trigger_prefix<'a>(upper: &str, original: &'a str) -> (bool, String, &'a str) {
    const PREFIXES: &[(&str, bool, &str)] = &[
        ("CREATE OR REPLACE SYNC TRIGGER ", true, "SYNC"),
        ("CREATE OR REPLACE DEFERRED TRIGGER ", true, "DEFERRED"),
        ("CREATE OR REPLACE TRIGGER ", true, "ASYNC"),
        ("CREATE SYNC TRIGGER ", false, "SYNC"),
        ("CREATE DEFERRED TRIGGER ", false, "DEFERRED"),
        ("CREATE TRIGGER ", false, "ASYNC"),
    ];
    for &(prefix, or_replace, mode) in PREFIXES {
        if upper.starts_with(prefix) {
            let rest = &original[prefix.len()..];
            return (or_replace, mode.to_string(), rest);
        }
    }
    (false, "ASYNC".to_string(), original)
}

/// Split trigger SQL into (header_original, header_upper, body_sql).
/// Handles both `$$ ... $$` and `BEGIN ... END` body forms.