Leaderboards · Repositories

0 modules · 0 exports · 1 repository · 1 e2e test · 1 route

OverviewRepositoriesPermissionsSearch 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.

LeaderboardRepository

app/features/leaderboards/LeaderboardRepository.server.ts

Tables

GroupMatchLeaderboardTeamSkipReportedWeaponSkillSkillTeamUserSplatoonPlayerTeamTeamMemberWithSecondaryTournamentTournamentMatchTournamentResultTournamentStageUserUserSubmittedImageXRankPlacement

Calls

no other repositories

Imports

Seasons

Used by

6 loaders1 action1 route2 scripts4 other

Types

type

XPLeaderboardItem

no JSDoc:275

export type XPLeaderboardItem = Awaited<
	ReturnType<typeof findAllXPLeaderboard>
>[number];

Routes/leaderboards

type

UserSPLeaderboardItem

no JSDoc:379

export type UserSPLeaderboardItem = Awaited<
	ReturnType<typeof findUserSPLeaderboard>
>[number];

Otherleaderboards/leaderboards.server.ts

type

SeasonPopularUsersWeapon

no JSDoc:412

export type SeasonPopularUsersWeapon = Record<
	Tables["User"]["id"],
	MainWeaponId
>;

Otherleaderboards/leaderboards.server.ts

Functions & values

function

findTeamLeaderboardBySeason

no JSDoc:117

export async function findTeamLeaderboardBySeason({
	season,
	onlyOneEntryPerUser,
}: {
	season: number;
	onlyOneEntryPerUser: boolean;
})

TablesLeaderboardTeamSkipSkillSkillTeamUserTeamTeamMemberWithSecondaryUserUserSubmittedImage

Unit tests (4)

• shows only the highest placing roster of each player
• keeps a skipped team in its spot without a placement, freeing its players' other roster
• places a skipped team normally on the all rosters leaderboard
• gives a team its placement back when it is unskipped

Loaders/

Scriptsscripts/add-leaderboard-teams-to-tournament.ts/add-leaderboard-teams-to-tournament.tsscripts/benchmark-db/cases.ts

Otherleaderboards/leaderboards.server.ts

function

insertTeamSkip

:240

Marks a team as not counting for the season's team leaderboard placements. Records the acting user as skippedByUserId.

export async function insertTeamSkip(args: {
	season: number;
	identifier: SkillTeamIdentifier;
})

TablesLeaderboardTeamSkip

Actions/leaderboards

function

deleteTeamSkip

no JSDoc:251

export async function deleteTeamSkip(args: {
	season: number;
	identifier: SkillTeamIdentifier;
})

TablesLeaderboardTeamSkip

Actions/leaderboards

function

findSeasonsParticipatedInByUserId

no JSDoc:262

export async function findSeasonsParticipatedInByUserId(userId: number)

TablesSkillTournamentResult

Loaders/u/:identifier/seasons/u/:identifier/seasons/stats/u/:identifier/seasons/summary-graphic

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findAllXPLeaderboard

no JSDoc:367

export async function findAllXPLeaderboard()

TablesSplatoonPlayerUserUserSubmittedImageXRankPlacement

Loaders/leaderboards

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findModeXPLeaderboard

no JSDoc:371

export async function findModeXPLeaderboard(mode: RankedModeShort)

TablesSplatoonPlayerUserUserSubmittedImageXRankPlacement

Loaders/leaderboards

Scriptsscripts/benchmark-db/cases.ts

function

findWeaponXPLeaderboard

no JSDoc:375

export async function findWeaponXPLeaderboard(weaponSplId: MainWeaponId)

TablesSplatoonPlayerUserUserSubmittedImageXRankPlacement

Loaders/leaderboards

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findUserSPLeaderboard

no JSDoc:383

export async function findUserSPLeaderboard(season: number)

TablesSkillUserUserSubmittedImage

Scriptsscripts/benchmark-db/cases.ts

Otheradmin/plus-tier.server.tsleaderboards/leaderboards.server.tsuser-page/utils.server.ts

function

findSeasonPopularUsersWeapon

no JSDoc:417

export async function findSeasonPopularUsersWeapon(
	season: number,
): Promise<SeasonPopularUsersWeapon>

TablesGroupMatchReportedWeaponTournamentTournamentMatchTournamentStage

Unit tests (8)

• returns
  • user's most reported SendouQ weapon
  • weapons of multiple users
• requires more reports than the threshold
• counts weapons reported in finalized tournaments
• ignores
  • weapons reported in unfinalized tournaments
  • reports outside the season
• combines SendouQ and tournament reports of the same weapon
• picks the most reported weapon across both sources

Scriptsscripts/benchmark-db/cases.ts

Otherleaderboards/leaderboards.server.ts