Badges · Repositories

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

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

BadgeRepository

app/features/badges/BadgeRepository.server.ts

Tables

BadgeBadgeManagerBadgeOwnerSplatoonPlayerTournamentBadgeOwnerUserUserSubmittedImage

Calls

no other repositories

Imports

no other modules

Used by

5 loaders4 actions1 route1 repository4 scripts2 other

Functions & values

function

insert

:61

Adds a badge. authorId is who made it, null for a legacy badge.

export function insert(
	args: Pick<
		TablesInsertable["Badge"],
		"code" | "displayName" | "hue" | "authorId"
	>,
)

TablesBadge

Scriptsscripts/add-badge.ts/add-badge.tsscripts/sync-homemade-badges.ts/sync-homemade-badges.ts

Otherapp/db/BadgeFactory.ts

function

findAll

no JSDoc:74

export async function findAll()

TablesBadgeBadgeManagerUserUserSubmittedImage

Loaders/badges

Scriptsscripts/benchmark-db/cases.ts

function

findById

no JSDoc:90

export async function findById(badgeId: number)

TablesBadgeBadgeManagerBadgeOwnerUserUserSubmittedImage

Loaders/badges/:id

Actions/badges/:id/edit/to/:id/brackets/finalize

Scriptsscripts/benchmark-db/cases.ts

function

findByManagersList

no JSDoc:112

export function findByManagersList(userIds: number[])

TablesBadgeBadgeManager

Loaders/org/:slug/edit

Scriptsscripts/benchmark-db/cases.ts

function

findManagedByUserId

no JSDoc:123

export function findManagedByUserId(userId: number)

TablesBadgeBadgeManager

Loaders/calendar/new

Actions/calendar/new

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findByOwnerUserId

:136

Takes a constant userId on purpose: correlating to an outer "User"."id" would stop SQLite pushing the predicate into both arms of the BadgeOwner view, materializing the full view.

export async function findByOwnerUserId(
	userId: number,
	favoriteBadgeIds: number[],
)

TablesBadgeBadgeOwnerUser

Loaders/u/:identifier/edit-widgets

Routes/user/:identifier

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findByAuthorUserId

no JSDoc:165

export function findByAuthorUserId(userId: number)

TablesBadge

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

replaceManagers

no JSDoc:174

export function replaceManagers({
	badgeId,
	managerIds,
}: {
	badgeId: number;
	managerIds: number[];
})

TablesBadgeManager

Unit tests (1)

• empty list clears existing managers

Actions/badges/:id/edit

Otherapp/db/BadgeFactory.ts

function

replaceOwners

no JSDoc:199

export function replaceOwners({
	badgeId,
	ownerIds,
}: {
	badgeId: number;
	ownerIds: number[];
})

TablesTournamentBadgeOwner

Unit tests (1)

• empty list clears existing owners

Actions/badges/:id/edit

Otherapp/db/BadgeFactory.ts

function

syncXPBadges

no JSDoc:230

export async function syncXPBadges()

TablesBadgeSplatoonPlayerTournamentBadgeOwner

Unit tests (3)

• assigns
  • badge to user with qualifying peakXp
  • highest qualifying badge when peakXp exceeds threshold
• does not assign badge when peakXp is below minimum threshold

Actions/player/:id

Repositoriesadmin/AdminRepository.server.ts

Scriptsscripts/placements/index.ts