variable ATTENDEE_LISTING_CONTRIBUTIONS_SQL

Per-listing aggregate contributions of an attendee's lines, summed so the hold-delete restore can add them back after deleting. tickets_count counts only quantity > 0 rows (mirroring the delete trigger, which now subtracts 0 for a no-quantity line — see ticketCountSumExpr); booked_quantity sums over all rows. Exported for the shared-predicate guard test.

Type

string

Usage

import { ATTENDEE_LISTING_CONTRIBUTIONS_SQL } from "docs/database.ts";