Notifications · Repositories

N

0 modules · 0 exports · 1 repository · 1 e2e test · 4 routes

OverviewRepositoriesE2E tests

Every table a function queries, its own helpers included, read or written. Calls to other repositories are listed apart, their tables are on their own page.

NotificationRepository

app/features/notifications/NotificationRepository.server.ts

Tables

NotificationNotificationUserNotificationUserSubscriptionUser

Calls

no other repositories

Imports

no other modules

Used by

1 loader3 routes4 routines2 scripts4 other

Functions & values

function

insert

no JSDoc:13

export function insert(
	notification: Notification,
	users: Array<Omit<TablesInsertable["NotificationUser"], "notificationId">>,
)

TablesNotificationNotificationUser

Otherapp/db/NotificationFactory.tsnotifications/notify.server.ts

function

findByUserId

no JSDoc:45

export function findByUserId(
	userId: number,
	{ limit }: { limit?: number } = {},
)

TablesNotificationNotificationUser

Loaders/notifications

Routes/api/notifications

Scriptsscripts/benchmark-db/cases.ts

function

findAllByType

no JSDoc:72

export function findAllByType<T extends Notification["type"]>(type: T)

TablesNotification

Routinesapp/routines/notifyPlusServerVoting.tsapp/routines/notifySeasonEnd.tsapp/routines/notifySeasonStart.ts

Scriptsscripts/benchmark-db/cases.ts

function

markAsSeenByType

:86

Marks the users' unseen notifications of the type (optionally only those whose meta matches every key/value) as seen, returning the user ids whose rows changed. The correlated exists keeps this proportional to the users' own notifications; notificationId in (select ...) makes SQLite materialize every notification of the type first, ~80x slower on a hot path.

export async function markAsSeenByType({
	userIds,
	type,
	meta,
}: {
	userIds: number[];
	type: Notification["type"];
	meta?: Record<string, number | string>;
}): Promise<number[]>

TablesNotificationUser

Unit tests (6)

• marks
  • unseen notification of the type as seen
  • the notification as seen for every given user
• leaves
  • other users' notifications unseen
  • notifications of other types unseen
• meta filter only matches notifications with the given values
• matches on a subset of meta keys, both string and number valued

Othernotifications/resolve.server.ts

function

findUserIdsWithUnseenByType

no JSDoc:128

export async function findUserIdsWithUnseenByType({
	userIds,
	type,
	meta,
}: {
	userIds: number[];
	type: Notification["type"];
	meta: Record<string, number | string>;
}): Promise<number[]>

TablesNotificationNotificationUser

Scriptsscripts/benchmark-db/cases.ts

Otherchat/ChatMentionNotification.server.ts

function

markOwnAsSeen

:165

Marks the actor's notifications as seen. Returns [actorId] if any row changed, else [], shaped for ChatSystemMessage.notifyNotificationsChanged.

export async function markOwnAsSeen(notificationIds: number[])

TablesNotificationUser

Unit tests (4)

• returns
  • the actor's id when a notification flips to seen
  • no user ids when the notifications were already seen
  • the actor's id once even if many notifications flip
• leaves another user's copy of the notification unseen

Routes/notifications/seen

function

deleteOld

no JSDoc:178

export function deleteOld()

TablesNotification

Routinesapp/routines/deleteOldNotifications.ts

function

upsertOwnSubscription

:190

Saves the actor's push subscription, keeping only their {@link NOTIFICATIONS.MAX_PUSH_SUBSCRIPTIONS_PER_USER} most recent ones.

export function upsertOwnSubscription(subscription: NotificationSubscription)

TablesNotificationUserSubscription

Unit tests (6)

• resubscribing
  • with the same endpoint does not duplicate the subscription
  • an old endpoint counts it as the most recent
• another user subscribing on the same browser takes over the endpoint
• different endpoints subscribe separately for the same user
• keeps only the most recent subscriptions of a user
• the cap does not remove other users' subscriptions

Routes/notifications/subscribe

function

findUnseenSubscriptionsByNotificationId

:229

Push subscriptions of the notification's recipients who have not seen it yet, so the push sender skips users who addressed it during the grace period.

export function findUnseenSubscriptionsByNotificationId(
	notificationId: number,
)

TablesNotificationUserNotificationUserSubscriptionUser

Unit tests (4)

• returns
  • the subscriptions of recipients who have not seen the notification
  • every subscription of an unseen recipient
• excludes
  • recipients who have seen the notification
  • subscriptions of users who did not receive the notification

Othernotifications/notify.server.ts

function

findAllSubscriptionsByUserIds

no JSDoc:251

export function findAllSubscriptionsByUserIds(userIds: number[])

TablesNotificationUserSubscription

Scriptsscripts/benchmark-db/cases.tsscripts/send-test-notification.ts/send-test-notification.ts

function

deleteSubscriptionById

no JSDoc:259

export function deleteSubscriptionById(id: number)

TablesNotificationUserSubscription

Othernotifications/notify.server.ts