Skip to content

Email for professionals and teams

950 B
Raw Blame
import type { MailboxRevisionRow } from "./types";

/** Covers every mailbox visible to a user, including shared mailboxes. */
export async function getUserMailRevision(env: CloudflareEnv, userId: string): Promise<string> {
	const result = await env.DB.prepare(`
		SELECT m.id AS mailbox_id, COALESCE(r.revision, 0) AS revision, 'owner' AS permission
		FROM mailboxes m
		LEFT JOIN jmap_mailbox_revisions r ON r.mailbox_id = m.id
		WHERE m.user_id = ? AND NOT m.disabled
		UNION
		SELECT m.id AS mailbox_id, COALESCE(r.revision, 0) AS revision, a.permission AS permission
		FROM mailbox_access a
		JOIN mailboxes m ON m.id = a.mailbox_id
		LEFT JOIN jmap_mailbox_revisions r ON r.mailbox_id = m.id
		WHERE a.user_id = ? AND m.type = 'shared' AND NOT m.disabled
		ORDER BY mailbox_id, permission
	`).bind(userId, userId).all<MailboxRevisionRow>();
	return JSON.stringify(result.results.map((row) => [row.mailbox_id, row.revision, row.permission]));
}