import type { DrizzleClient } from '../client.js';
import { opsAlertState } from '../schema.js';

export async function upsertOpsAlertState(
  db: DrizzleClient,
  value: { alertKey: string; lastSeverity: string; lastFiredAt: Date },
): Promise<void> {
  await db
    .insert(opsAlertState)
    .values(value)
    .onConflictDoUpdate({
      target: opsAlertState.alertKey,
      set: { lastSeverity: value.lastSeverity, lastFiredAt: value.lastFiredAt },
    });
}