generateEventTriggerCreateSQL() — supabase Function Reference

Architecture documentation for the generateEventTriggerCreateSQL() function in EventTriggerList.utils.ts from the supabase codebase.

Function typescript ContentManagement Migrations calls 3 called by 1

Entity Profile

ContentManagement→ Migrations→ generateEventTriggerCreateSQL() — supabase Function Reference

Dependency Diagram

graph TD
  13ab5d66_f5f8_d5d4_55d8_46b8eaf9cfb5["generateEventTriggerCreateSQL()"]
  e08c0a38_239b_1314_abaa_dd915a2e3396["EventTriggersList()"]
  e08c0a38_239b_1314_abaa_dd915a2e3396 -->|calls| 13ab5d66_f5f8_d5d4_55d8_46b8eaf9cfb5
  73bf37bf_a2e9_f5f5_2d93_99cc2ba22e89["ensureSemicolon()"]
  13ab5d66_f5f8_d5d4_55d8_46b8eaf9cfb5 -->|calls| 73bf37bf_a2e9_f5f5_2d93_99cc2ba22e89
  4989ae6b_49fb_cde4_e1a7_b92672b67777["escapeIdentifier()"]
  13ab5d66_f5f8_d5d4_55d8_46b8eaf9cfb5 -->|calls| 4989ae6b_49fb_cde4_e1a7_b92672b67777
  357b12fc_9687_29a0_3f4d_b0bd2fad928b["escapeLiteral()"]
  13ab5d66_f5f8_d5d4_55d8_46b8eaf9cfb5 -->|calls| 357b12fc_9687_29a0_3f4d_b0bd2fad928b
  style 13ab5d66_f5f8_d5d4_55d8_46b8eaf9cfb5 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

apps/studio/components/interfaces/Database/Triggers/EventTriggersList/EventTriggerList.utils.ts lines 11–37

export const generateEventTriggerCreateSQL = (trigger: DatabaseEventTrigger) => {
  const statements: string[] = []

  if (trigger.function_definition) {
    statements.push(ensureSemicolon(trigger.function_definition))
  }

  if (trigger.event && trigger.function_schema && trigger.function_name) {
    statements.push(`DROP EVENT TRIGGER IF EXISTS "${escapeIdentifier(trigger.name)}";`)
    statements.push(
      [
        `CREATE EVENT TRIGGER "${escapeIdentifier(trigger.name)}"`,
        `ON ${trigger.event}`,
        trigger.tags && trigger.tags.length > 0
          ? `WHEN TAG IN (${trigger.tags.map((tag) => `'${escapeLiteral(tag)}'`).join(', ')})`
          : null,
        `EXECUTE FUNCTION "${escapeIdentifier(trigger.function_schema)}"."${escapeIdentifier(
          trigger.function_name
        )}"();`,
      ]
        .filter(Boolean)
        .join('\n')
    )
  }

  return statements.filter(Boolean).join('\n\n').trim()
}