| 78 | * @returns Object with status of each trigger |
| 79 | */ |
| 80 | export async function verifyRowCountTriggers(): Promise<{ |
| 81 | incrementTrigger: boolean |
| 82 | decrementTrigger: boolean |
| 83 | }> { |
| 84 | const result = (await db.execute(` |
| 85 | SELECT tgname |
| 86 | FROM pg_trigger |
| 87 | WHERE tgname IN ('trg_increment_row_count', 'trg_decrement_row_count') |
| 88 | AND NOT tgisinternal |
| 89 | `)) as { tgname: string }[] |
| 90 | |
| 91 | const triggers = Array.isArray(result) ? result.map((r) => r.tgname) : [] |
| 92 | |
| 93 | return { |
| 94 | incrementTrigger: triggers.includes('trg_increment_row_count'), |
| 95 | decrementTrigger: triggers.includes('trg_decrement_row_count'), |
| 96 | } |
| 97 | } |