Skip to content

Email for professionals and teams

775 B
Raw Blame
import { sql } from "drizzle-orm";
import { getDb } from "@/db";
import { spamReputation } from "@/db/schema";
import type { ReputationKey } from "./types";

export async function recordReputationObservation(env: CloudflareEnv, mailboxId: string, keys: ReputationKey[]): Promise<void> {
	if (keys.length === 0) return;
	const db = getDb(env);
	const now = new Date();
	await db.batch(keys.map((item) => db
		.insert(spamReputation)
		.values({ mailboxId, type: item.type, key: item.key, messagesSeen: 1, spamCount: 0, hamCount: 0, firstSeenAt: now, lastSeenAt: now })
		.onConflictDoUpdate({
			target: [spamReputation.mailboxId, spamReputation.type, spamReputation.key],
			set: { messagesSeen: sql`${spamReputation.messagesSeen} + 1`, lastSeenAt: now },
		})) as never);
}