Eventos

booking.hold_created
booking.hold_released
booking.confirmed
booking.expired
booking.cancelled
booking.rescheduled
booking.refunded
booking.partially_refunded
booking.no_show
product.updated
customer.updated
booking_event_type.updated

create table simplepay_webhook_events (
  id text primary key,
  type text not null,
  received_at timestamptz not null default now(),
  processed_at timestamptz,
  payload jsonb not null
);

async function handleEvent(event: SimplePayEvent) {
  const inserted = await insertEventIfNew(event.id, event.type, event);

  if (!inserted) {
    return { duplicate: true };
  }

  switch (event.type) {
    case "booking.confirmed":
      await confirmBooking(event.data.booking);
      break;
    case "booking.expired":
    case "booking.cancelled":
      await releaseBooking(event.data.booking);
      break;
    default:
      await recordUnhandledEvent(event);
  }
}