Repository Public
1// Répartiteur des webhooks : file persistante, baux, recul exponentiel (voir attemptDelivery).2import { sql } from "../db.js"3import { attemptDelivery } from "../webhooks.js"45export async function deliverWebhooks() {6 const rows = await sql`update webhook_deliveries set locked_until = now() + interval '1 minute'7 where id in (select id from webhook_deliveries where status in ('pending','retrying') and next_attempt_at <= now()8 and (locked_until is null or locked_until < now()) order by next_attempt_at limit 10 for update skip locked)9 returning id`10 await Promise.all(rows.map((r) => attemptDelivery(r.id).catch(() => sql`update webhook_deliveries set locked_until = null where id = ${r.id}`)))11}12