Skip to content

Email for professionals and teams

1.0 KB
Raw Blame
import { drizzle } from "drizzle-orm/d1";
import { sql } from "drizzle-orm";

export function at(seconds, id, threadId = id, mailboxId = "mine", status = "received") {
	return { id, threadId, createdAt: seconds, mailboxId, status };
}

export function createConversationFixture(SqliteDatabase, rows) {
	const database = new SqliteDatabase(":memory:");
	database.db.exec("CREATE TABLE messages (id TEXT PRIMARY KEY, thread_id TEXT, created_at INTEGER NOT NULL, mailbox_id TEXT, status TEXT)");
	const insert = database.db.prepare("INSERT INTO messages (id, thread_id, created_at, mailbox_id, status) VALUES (?, ?, ?, ?, ?)");
	database.db.transaction(() => {
		for (const row of rows) insert.run(row.id, row.threadId, row.createdAt, row.mailboxId, row.status);
	})();

	let queries = 0;
	const prepare = database.prepare.bind(database);
	database.prepare = (query) => {
		queries += 1;
		return prepare(query);
	};

	return {
		database,
		db: drizzle(database),
		where: sql`mailbox_id = ${"mine"} and status = ${"received"}`,
		queryCount: () => queries,
	};
}