Rallly is an open-source scheduling and collaboration tool designed to make organizing events and meetings easier.
TypeScript i18nextnext-authnextjspostgresqlprismareact-emailt3-stacktailwindcsstrpcturborepotypescriptzod
import "server-only";
import { Prisma, prisma } from "@rallly/database";
import { env } from "@/env";
import { defaultNotificationPreferences } from "./constants";
import type { ActivityEventType } from "./schema";
import { parseUnsubscribeToken } from "./utils";
export async function updateNotificationPreference({
userId,
eventType,
enabled,
}: {
userId: string;
eventType: ActivityEventType;
enabled: boolean;
}) {
const patch = JSON.stringify({ [eventType]: enabled });
// The merge happens in the database (jsonb ||) so concurrent toggles of
// different keys can't clobber each other the way a read-merge-replace
// upsert would.
const mergeIntoExistingRow = () => prisma.$executeRaw`
UPDATE user_notification_preferences
SET prefs = prefs || ${patch}::jsonb, updated_at = now()
WHERE user_id = ${userId}
`;
if ((await mergeIntoExistingRow()) > 0) {
return;
}
// No row yet — create through Prisma for the client-generated cuid. A
// concurrent create surfaces as P2002 and falls back to the atomic merge.
try {
await prisma.userNotificationPreferences.create({
data: {
userId,
prefs: { ...defaultNotificationPreferences, [eventType]: enabled },
},
});
} catch (e) {
if (
e instanceof Prisma.PrismaClientKnownRequestError &&
e.code === "P2002"
) {
await mergeIntoExistingRow();
return;
}
throw e;
}
}
/**
* Mutes whatever a signed unsubscribe token points at. The token is the
* credential (there is no session on either caller: the one-click POST from a
* mail client or the confirmation page), so it is verified here rather than
* in an action gate.
*/
export async function unsubscribeWithToken({ token }: { token: string }) {
const target = parseUnsubscribeToken({
token,
secret: env.SECRET_PASSWORD,
});
if (!target) {
return { ok: false as const, reason: "invalidToken" as const };
}
switch (target.kind) {
case "poll": {
// The same row write as the poll feature's setPollMuted, kept here so
// notifications never imports poll: poll depends on this feature for
// recipients and tokens, and features must not import each other in
// both directions.
const { count } = await prisma.poll.updateMany({
where: {
id: target.pollId,
userId: target.userId,
deletedAt: null,
},
data: { muted: true },
});
if (count === 0) {
return { ok: false as const, reason: "notFound" as const };
}
return { ok: true as const, target };
}
}
}