Skip to content

Email for professionals and teams

1.6 KB
Raw Blame
export type DeliveryStatRow = {
	webhookId: string;
	status: string;
	total: number;
	lastAttemptAt: Date | number | null;
};

export type WebhookDeliveryStats = {
	total: number;
	delivered: number;
	failing: number;
	pending: number;
	lastAttemptAt: number | null;
};

/**
 * Aggregate columns bypass Drizzle's timestamp mapper, so `max()` comes back as the raw
 * SQLite value — seconds, since the column uses `mode: "timestamp"`. Normalise to epoch ms.
 */
function toEpochMs(value: Date | number | null | undefined): number | null {
	if (value === null || value === undefined) return null;
	if (value instanceof Date) return value.getTime();
	const numeric = Number(value);
	if (!Number.isFinite(numeric) || numeric <= 0) return null;
	return numeric < 1e12 ? numeric * 1000 : numeric;
}

/** Folds the grouped delivery counts into per-endpoint health for the webhooks list. */
export function summariseDeliveryStats(rows: DeliveryStatRow[], webhookId: string): WebhookDeliveryStats {
	const own = rows.filter((row) => row.webhookId === webhookId);
	const byStatus = (status: string) =>
		own.filter((row) => row.status === status).reduce((sum, row) => sum + row.total, 0);

	const lastAttemptAt = own.reduce<number | null>((latest, row) => {
		const value = toEpochMs(row.lastAttemptAt);
		if (value === null) return latest;
		return latest === null || value > latest ? value : latest;
	}, null);

	return {
		total: own.reduce((sum, row) => sum + row.total, 0),
		delivered: byStatus("delivered"),
		failing: byStatus("failed") + byStatus("exhausted"),
		pending: byStatus("pending") + byStatus("retrying"),
		lastAttemptAt,
	};
}