alert-pruning.ts

// src/lib/alert-pruning.ts

import { and, inArray, lt } from "drizzle-orm"
import type { AlertType } from "@/lib/dashboard"
import { db } from "@/lib/db"
import { dismissedAlerts } from "@/lib/db/schema"

export const EXPIRING_ALERT_TYPES: AlertType[] = ["stale-data", "zero-seeding"]
export const NON_DISMISSIBLE_ALERT_TYPES = new Set<AlertType>(["client-error", "poll-paused"])
export const ALERT_EXPIRY_MS = 24 * 60 * 60 * 1000

export async function pruneDismissedAlerts(): Promise<void> {
  const cutoff = new Date(Date.now() - ALERT_EXPIRY_MS)
  await db
    .delete(dismissedAlerts)
    .where(
      and(
        inArray(dismissedAlerts.alertType, EXPIRING_ALERT_TYPES),
        lt(dismissedAlerts.dismissedAt, cutoff)
      )
    )
}