Skip to content

Email for professionals and teams

846 B
Raw Blame
import { eq } from "drizzle-orm";
import type { getDb } from "@/db";
import { messages } from "@/db/schema";

type Db = ReturnType<typeof getDb>;

export function selectDraftWithBody(db: Db, userId: string, draftId: string) {
	return db
		.select({
			id: messages.id,
			userId: messages.userId,
			mailboxId: messages.mailboxId,
			fromAddr: messages.fromAddr,
			toAddr: messages.toAddr,
			ccAddr: messages.ccAddr,
			bccAddr: messages.bccAddr,
			subject: messages.subject,
			inReplyTo: messages.inReplyTo,
			references: messages.references,
			threadId: messages.threadId,
			status: messages.status,
			textBody: messages.textBody,
			htmlBody: messages.htmlBody,
		})
		.from(messages)
		.where(eq(messages.id, draftId))
		.limit(1)
		.then(([draft]) => (draft && draft.userId === userId && draft.status === "draft" ? draft : null));
}