Admin · Repositories

A

0 modules · 0 exports · 3 repositories · 5 e2e tests · 2 routes

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.

AdminRepository

app/features/admin/AdminRepository.server.ts

Tables

AllTeamMemberApiTokenBadgeBadgeManagerBanLogBuildGroupMemberLFGPostModNotePendingTrophyPendingTrophyApprovalPlusTierSpecialTrophyOwnerSplatoonPlayerTeamMemberTournamentBadgeOwnerTournamentStreamerTournamentTeamMemberTrophyTrophyOwnerUnvalidatedUserSubmittedImageUserUserFriendCodeUserReport

Calls

BadgeRepositoryBuildRepositoryXRankPlacementRepositoryTrophyRepository

Imports

no other modules

Used by

1 loader3 actions1 script3 other

Functions & values

function

migrate

:16

For a user switching Discord accounts: moves the new account's data onto the old user and deletes the new one. Resolves to null on success, or an error message if validation fails.

export function migrate(args: { newUserId: number; oldUserId: number })

TablesAllTeamMemberBadgeBadgeManagerBanLogBuildGroupMemberLFGPostModNotePendingTrophyPendingTrophyApprovalSpecialTrophyOwnerTeamMemberTournamentBadgeOwnerTournamentStreamerTournamentTeamMemberTrophyTrophyOwnerUnvalidatedUserSubmittedImageUserUserFriendCodeUserReport

Unit tests (4)

• re-points
  • trophy data to the remaining user
  • badge and streamer data to the remaining user
• drops the migrated account's duplicate rows when both accounts own the same trophy
• merges badge grants and drops duplicate manager rows when both accounts have the same badge

Actions/admin

function

replacePlusTiers

:388

Replaces every PlusTier row, also refreshing the build sort values derived from them.

export function replacePlusTiers(
	plusTiers: Array<{ userId: number; plusTier: number }>,
)

TablesPlusTier

CallsBuildRepository.recalculateAllSortValues

Unit tests (2)

• refreshes
  • the sort values of the builds a new tier applies to
  • the sort values of the builds of a user left out of the new tiers

Actions/admin

Otherapp/db/PlusVoteFactory.tsapp/db/UserFactory.ts

function

makeVideoAdderByUserId

no JSDoc:406

export function makeVideoAdderByUserId(userId: number)

TablesUser

Actions/admin

Otherapp/db/UserFactory.ts

function

makeArtistByUserId

no JSDoc:414

export function makeArtistByUserId(userId: number)

TablesUser

Actions/admin

Otherapp/db/UserFactory.ts

function

makeTournamentOrganizerByUserId

no JSDoc:422

export function makeTournamentOrganizerByUserId(userId: number)

TablesUser

Actions/admin

Otherapp/db/UserFactory.ts

function

makeApiAccesserByUserId

no JSDoc:430

export function makeApiAccesserByUserId(userId: number)

TablesUser

Actions/admin

Otherapp/db/UserFactory.ts

function

linkUserAndPlayer

no JSDoc:438

export async function linkUserAndPlayer({
	userId,
	playerId,
}: {
	userId: number;
	playerId: number;
})

TablesSplatoonPlayer

CallsBadgeRepository.syncXPBadgesTrophyRepository.syncSpecialTrophiesBuildRepository.recalculateAllSortValuesXRankPlacementRepository.refreshTenStarWeapons

Actions/admin

function

forcePatron

no JSDoc:464

export async function forcePatron(args: {
	id: number;
	patronTier: Tables["User"]["patronTier"];
	patronStartedAt: Date;
	patronExpiresAt: Date;
})

TablesUser

Actions/admin

Otherapp/db/UserFactory.ts

function

findAllBannedUsers

no JSDoc:481

export async function findAllBannedUsers()

TablesUser

Unit tests (5)

• returns
  • empty Map when no users are banned
  • Map with single banned user
  • Map with multiple banned users
• excludes non-banned users from results
• includes both permanently and temporarily banned users

Loaders/suspended

Scriptsscripts/benchmark-db/cases.ts

Otherban/banned.server.ts

function

banUser

:498

Bans the user, logging it unless it's an automatic ban. Revokes their API tokens.

export function banUser({
	userId,
	banned,
	bannedReason,
	bannedByUserId,
}: {
	userId: number;
	banned: 1 | Date;
	bannedReason: string | null;
	/** null means an automatic ban. */
	bannedByUserId: number | null;
})

TablesApiTokenBanLogUser

Unit tests (7)

• permanently bans user (banned = 1)
• temporarily bans user (banned = Date)
• sets bannedReason correctly
• creates BanLog entry when bannedByUserId is provided
• does not create BanLog when bannedByUserId is null (automatic ban)
• updates existing user correctly
• revokes the banned user's API tokens

Actions/admin/q

Otherapp/db/UserFactory.ts

function

unbanUser

no JSDoc:537

export function unbanUser({
	userId,
	unbannedByUserId,
}: {
	userId: number;
	unbannedByUserId: number;
})

TablesBanLogUser

Unit tests (4)

• unbans a previously banned user
• creates BanLog entry with correct unbannedByUserId
• can
  • unban permanently banned user
  • unban temporarily banned user

Actions/admin

function

addModNote

no JSDoc:567

export function addModNote(
	args: Omit<TablesInsertable["ModNote"], "authorId">,
)

TablesModNote

Actions/u/:identifier/admin

function

findModNoteById

no JSDoc:576

export function findModNoteById(id: number)

TablesModNote

Actions/u/:identifier/admin

Scriptsscripts/benchmark-db/cases.ts

function

deleteModNote

no JSDoc:584

export function deleteModNote(id: number)

TablesModNote

Actions/u/:identifier/admin

ExternalStreamRepository

app/features/admin/ExternalStreamRepository.server.ts

Tables

ExternalStreamUserSubmittedImage

Calls

no other repositories

Imports

no other modules

Used by

1 loader1 action1 routine1 script1 other

Functions & values

function

insert

:10

Inserts an admin-curated external stream.

export function insert(
	args: Pick<
		TablesInsertable["ExternalStream"],
		"name" | "url" | "avatarImgId" | "startsAt"
	>,
)

TablesExternalStream

Actions/admin/streams

function

deleteById

:20

Deletes an external stream by its id.

export function deleteById(id: number)

TablesExternalStream

Actions/admin/streams

function

findAll

:25

All external streams, soonest first.

export function findAll()

TablesExternalStreamUserSubmittedImage

Loaders/admin/streams

Scriptsscripts/benchmark-db/cases.ts

function

findAllForSidebar

:47

Streams started under 6h ago or upcoming.

export function findAllForSidebar()

TablesExternalStreamUserSubmittedImage

Scriptsscripts/benchmark-db/cases.ts

Othersidebar/sidebar.server.ts

function

deleteOld

:73

Deletes streams that started over 24h ago.

export function deleteOld()

TablesExternalStream

Routinesapp/routines/deleteOldExternalStreams.ts

ModAuditLogRepository

app/features/admin/ModAuditLogRepository.server.ts

Tables

ModAuditLog

Calls

no other repositories

Imports

Seasons

Used by

1 loader1 repository1 script1 other

Functions & values

function

insert

:11

Logs a text written by the acting user, in the caller's transaction.

export function insert(
	{ type, text }: { type: ModAuditLogType; text: string },
	trx: Transaction<DB>,
)

TablesModAuditLog

Repositoriessendouq/SQGroupRepository.server.ts

Otherapp/db/ModAuditLogFactory.ts

function

findSeasonByUserId

:23

Texts of the type the user wrote during the season, newest first.

export function findSeasonByUserId({
	userId,
	season,
	type,
}: {
	userId: number;
	season: number;
	type: ModAuditLogType;
})

TablesModAuditLog

Unit tests (3)

• returns the public notes written during the season, newest first
• excludes public notes written outside the season
• does not log clearing the public note

Loaders/u/:identifier/seasons

Scriptsscripts/benchmark-db/cases.ts