User card · Repositories

0 modules · 0 exports · 1 repository · 5 e2e tests · 3 routes

OverviewRepositoriesSearch params & storageE2E 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.

UserCardRepository

app/features/user-card/UserCardRepository.server.ts

Tables

LFGPostPlusTierPrivateUserNoteSplatoonPlayerUnvalidatedUserSubmittedImageUserUserFriendCodeUserSubmittedImageXRankPlacement

Calls

AdminRepositoryLeaderboardRepositorySkillRepositoryUserRepository

Imports

Seasons

Used by

15 loaders1 action1 route1 script2 other

Functions & values

function

findAllByUserIds

:41

UserCardData for many users, keyed by user id. One batched query ({@link userCardDataJsonObject}) merged with the in-memory SEASON caches (userSkills, cachedFullUserLeaderboard); privateNote is scoped to the acting user. Spread the result into a route loader so UserCard can find it.

export async function findAllByUserIds({
	userIds,
	include,
	includeHiddenStats = false,
}: {
	userIds: Array<number>;
	/** Opt-in fields skipped from the query by default. */
	include?: { friendCode?: boolean };
	/** Keep hidden stats in `stats`; only the edit page opts in, so hidden values never reach a viewer. */
	includeHiddenStats?: boolean;
}): Promise<{ userCards: UserCardsById }>

TablesLFGPostPlusTierPrivateUserNoteSplatoonPlayerUserUserFriendCodeUserSubmittedImageXRankPlacement

CallsSkillRepository.findOrderedUserOrdinalsBySeasonLeaderboardRepository.findUserSPLeaderboardUserRepository.findAllPlusServerMembersLeaderboardRepository.findSeasonPopularUsersWeaponAdminRepository.findAllBannedUsers

Unit tests (15)

• returns an empty map when given no user ids
• keys cards by user id and builds the stats array from db fields
• surfaces
  • self-reported peak XP only when it beats the verified XP
  • self-reported peak XP equal to the other division's verified peak
• ignores
  • self-reported peak XP that does not beat the verified XP
  • self-reported peak XP more than 200 above the verified XP
  • self-reported peak XP when there is no verified XP
• shows
  • the verified peak XP of the picked division
  • the highest verified peak XP across divisions when none is picked
• falls back to the other division when the picked one has no placements
• judges self-reported peak XP against the picked division's verified XP
• keeps
  • the self-reported peak XP in the picked division without placements there
  • hidden stats in `stats` when includeHiddenStats is set
• persists edited card fields and surfaces hidden stats
• produces a URL banner when an uploaded banner image is set

Loaders/plus/suggestions/plus/voting/scrims/:id/scrims/q/match/:id/q/streams/to/:id/streams/to/:id/admin/seeds/to/:id/looking/user-card/edit/u/:identifier

Routes/trophies/:id/wins/:userId

Scriptsscripts/benchmark-db/cases.ts

function

findAllByUserIdsCached

:78

Like {@link findAllByUserIds} but viewer-independent card data comes from a 30s in-memory cache (for revalidation bursts on the SendouQ looking page); privateNote and friendCode are overlaid fresh per call. The cache holds the in-flight query so concurrent misses share one query.

export async function findAllByUserIdsCached({
	userIds,
	include,
}: {
	userIds: Array<number>;
	/** Opt-in fields skipped from the query by default. */
	include?: { friendCode?: boolean };
}): Promise<{ userCards: UserCardsById }>

TablesLFGPostPlusTierPrivateUserNoteSplatoonPlayerUserUserFriendCodeUserSubmittedImageXRankPlacement

CallsSkillRepository.findOrderedUserOrdinalsBySeasonLeaderboardRepository.findUserSPLeaderboardUserRepository.findAllPlusServerMembersLeaderboardRepository.findSeasonPopularUsersWeaponAdminRepository.findAllBannedUsers

Unit tests (6)

• gives every viewer their own private note
• serves cards from the cache and queries only the users missing from it
• returns
  • a fresh card once the cached one has expired
  • a fresh card right after its owner edited it
• overlays the latest friend code only when opted in
• coalesces concurrent misses for the same user into one query

Loaders/lfg/q/looking/q/ready/to/:id/matches/:mid

Scriptsscripts/benchmark-db/cases.ts

function

clearUserCardCache

:132

Drops every cached card.

export function clearUserCardCache()

Otherapi-private/refresh-caches.server.ts

function

findCardEditExtrasByUserId

:246

Raw card fields the edit form needs that are not part of {@link UserCardData}.

export async function findCardEditExtrasByUserId(userId: number)

TablesUserUserSubmittedImage

Loaders/user-card/edit

Scriptsscripts/benchmark-db/cases.ts

function

findVerifiedXpByUserId

:272

Verified XP the card would show with xpDivision (see {@link verifiedXp}), so the edit form can judge a self-reported peak against it. null without X Rank placements.

export async function findVerifiedXpByUserId(
	userId: number,
	xpDivision: XRankPlacementRegion | null,
)

TablesSplatoonPlayerUserXRankPlacement

Loaders/user-card/edit

Actions/user-card/edit

Scriptsscripts/benchmark-db/cases.ts

function

updateOwnCard

:286

Updates the acting user's own card and drops it from the cache.

export async function updateOwnCard(args: {
	shortBio: string | null;
	bannerPresetImg: string | null;
	bannerImgId: number | null;
	unverifiedPeakXP: PeakXP | null;
	/** `null` leaves the card showing their highest XP across both divisions. */
	xpDivision: XRankPlacementRegion | null;
	hiddenCardStats: Array<HideableUserCardStat>;
})

TablesUnvalidatedUserSubmittedImageUser

Actions/user-card/edit

Otherapp/db/UserFactory.ts