⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { createHmac } from "node:crypto";
import { and, eq, sql } from "drizzle-orm";
import db, { schema } from "../../database";
import { decryptSecret } from "../../notification-preferences/secrets";
import {
OutboundRequestError,
sendOutboundRequest,
} from "../../utils/outbound-request";
import { pruneWebhookDeliveries } from "./prune-webhook-deliveries";
import {
claimWebhookDelivery,
MAX_WEBHOOK_ATTEMPTS,
} from "./claim-webhook-delivery";
export async function sendWebhookDelivery() {
const job = await claimWebhookDelivery();
if (!job) return false;
const { delivery, url, signingSecret } = job;
const table = schema.instanceWebhookDeliveryTable;
const webhook = schema.instanceWebhookTable;
// A disable/re-enable may have committed since the claim.
const [current] = await db
.select({ id: table.id })
.from(table)
.innerJoin(webhook, eq(table.webhookId, webhook.id))
.where(
and(
eq(table.id, delivery.id),
eq(table.state, "pending"),
eq(table.attempts, delivery.attempts),
eq(webhook.enabled, true),
sql`${table.createdAt} > COALESCE(${webhook.cancelPendingBefore}, '-infinity'::timestamp)`,
),
);
if (!current) return true;
let statusCode: number | null = null;
let errorCode: string | null = null;
let retryable = false;
try {
const secret = decryptSecret(signingSecret);
if (!secret) throw new Error("Missing signing secret");
const body = JSON.stringify(delivery.payload);
const timestamp = Math.floor(Date.now() / 1000).toString();
const signature = createHmac("sha256", secret)
.update(`${timestamp}.${body}`)
.digest("hex");
statusCode = (await sendOutboundRequest(
url,
{
body,
headers: {
"content-type": "application/json",
"x-kaneo-timestamp": timestamp,
"x-kaneo-signature": `sha256=${signature}`,
"x-kaneo-delivery": delivery.id,
},
},
{ publicDestination: true, readStatus: true, timeoutMs: 5_000 },
)) as number;
} catch (error) {
// Neither an untrusted response body nor an error containing a URL is kept.
errorCode =
error instanceof OutboundRequestError ? error.reason : "signing";
statusCode =
error instanceof OutboundRequestError ? (error.status ?? null) : null;
retryable =
errorCode === "network" ||
errorCode === "timeout" ||
(errorCode === "http" &&
(statusCode === 408 || statusCode === 429 || (statusCode ?? 0) >= 500));
}
const retry =
errorCode !== null && retryable && delivery.attempts < MAX_WEBHOOK_ATTEMPTS;
await db
.update(table)
.set({
state: retry ? "pending" : errorCode ? "failed" : "succeeded",
statusCode,
errorCode,
nextAttemptAt: sql`(clock_timestamp() AT TIME ZONE 'utc') + ${delivery.attempts === 1 ? 5 : 30} * interval '1 second'`,
})
.where(
and(
eq(table.id, delivery.id),
eq(table.state, "pending"),
eq(table.attempts, delivery.attempts),
),
);
await pruneWebhookDeliveries(db, delivery.webhookId);
return true;
}