Tournament bracket · Repositories

11 modules · 98 exports · 2 repositories · 35 e2e tests · 3 routes

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

BracketRepository

app/features/tournament-bracket/BracketRepository.server.ts

Tables

TournamentGroupTournamentMatchTournamentRoundTournamentStageTournamentTeam

Calls

ChatRepository

Imports

no other modules

Used by

3 actions1 module1 script2 other

Functions & values

function

findByTournamentId

:29

Full BracketData of all stages, with score/totalKos aggregated over TournamentMatchGameResult. Also called inside write transactions: propagation needs fresh rows, not the cached Tournament.

export async function findByTournamentId(
	tournamentId: number,
	trx?: Transaction<DB>,
): Promise<BracketData>

TablesTournamentGroupTournamentMatchTournamentRoundTournamentStage

Unit tests (2)

• counts each opponent's KO wins into totalKos
• does not count games won without a KO

Actions/to/:id/admin

Modulestournament-bracket/Tournament.server.ts

Scriptsscripts/benchmark-db/cases.ts

Othertournament-bracket/executeBracketOperation.server.ts

function

insertBracket

:142

Persists Engine.create output, translating local ids to row ids. Stage number follows the existing stages.

export function insertBracket(args: {
	tournamentId: number;
	name: string;
	bracket: BracketData;
	/** League rounds are all playable from the start, so their chat rooms live longer unless the stage is real-time. */
	isLeague: boolean;
}): Promise<{ stageId: number }>

TablesTournamentGroupTournamentMatchTournamentRoundTournamentStageTournamentTeam

CallsChatRepository.insertRooms

Actions/to/:id/brackets

Otherapp/db/TournamentFactory.ts

function

applyMatchChanges

:260

UPDATEs the changed matches' opponents and syncs startedAt with the implied statuses. Called inside the caller's transaction with the bracket data the operation was computed from.

• @returns

  ids of the chat rooms whose inactive flag changed, to notify participants of after commit

export async function applyMatchChanges(
	args: {
		previousData: BracketData;
		result: EngineResult;
		/** League rounds are all playable from the start, so their chat rooms live longer unless the stage is real-time. */
		isLeague: boolean;
	},
	trx: Transaction<DB>,
): Promise<number[]>

TablesTournamentMatch

CallsChatRepository.updateRoomsExpiresAtChatRepository.insertRoomsChatRepository.updateRoomsInactive

Unit tests (3)

• completing a match marks its chat room inactive
• tells the match's participants their room list changed
• reopening a completed match marks its chat room back active

Actions/to/:id/admin

Othertournament-bracket/executeBracketOperation.server.ts

function

insertRoundMatches

:477

INSERTs a generated round's matches (swiss advance).

export async function insertRoundMatches(
	args: {
		stageId: number;
		round: GeneratedRound;
		/** The teams schedule the sets (league), so their chat rooms live longer. */
		hasScheduling: boolean;
	},
	trx?: Transaction<DB>,
): Promise<void>

TablesTournamentMatch

CallsChatRepository.insertRooms

Actions/to/:id/brackets

Otherapp/db/TournamentFactory.ts

function

deleteRoundMatches

:525

DELETEs a round's matches (swiss unadvance).

export async function deleteRoundMatches(args: {
	stageId: number;
	groupId: number;
	roundId: number;
}): Promise<void>

TablesTournamentMatch

Actions/to/:id/brackets

function

resetBracket

:539

Deletes the whole stage subtree (matches, rounds, groups, stage).

export function resetBracket(tournamentStageId: number)

TablesTournamentGroupTournamentMatchTournamentRoundTournamentStage

Unit tests (1)

• deletes the chat rooms of the stage's matches

Actions/to/:id/admin/brackets

Unit tests not about one export (4)

• BracketRepository league chat room expiry › a
  • league match's room lives two months
  • real-time league bracket's room lives a week, also after reopening
• BracketRepository league chat room expiry › completing a league match cuts its room down to a week
• BracketRepository league chat room expiry › reopening a league match restores its room's lifespan

TournamentMatchVodRepository

app/features/tournament-bracket/TournamentMatchVodRepository.server.ts

Tables

CalendarEventCalendarEventDateTournamentTournamentGroupTournamentMatchTournamentMatchGameResultTournamentMatchGameResultParticipantTournamentMatchVodTournamentRoundTournamentStageTournamentStreamerTournamentTeamTournamentTeamMemberUserUserSubmittedImage

Calls

no other repositories

Imports

no other modules

Used by

1 loader1 component2 routines2 scripts

Types

type

VodsByTournamentId

no JSDoc:13

export type VodsByTournamentId = Awaited<
	ReturnType<typeof findVodsByTournamentId>
>;

Loaders/to/:id

Componentstournament-bracket/Match.tsx

Functions & values

function

findVodsByTournamentId

no JSDoc:16

export function findVodsByTournamentId(tournamentId: number)

TablesTournamentMatchTournamentMatchVodTournamentStageTournamentTeamTournamentTeamMemberUserUserSubmittedImage

Loaders/to/:id

Scriptsscripts/benchmark-db/cases.ts

function

findAllForDownloadByTournamentId

:71

Every VoD of the tournament with what is needed to download its match: its round, when the match started and when its last game was reported, plus the streamer and the team whose POV the VoD is and how many sets that team won (null for casts).

export async function findAllForDownloadByTournamentId(tournamentId: number)

TablesTournamentGroupTournamentMatchTournamentMatchGameResultTournamentMatchVodTournamentRoundTournamentStageTournamentTeamMember

Scriptsscripts/download-tournament-vods.ts/download-tournament-vods.ts

function

insertMany

no JSDoc:170

export function insertMany(vods: Omit<Tables["TournamentMatchVod"], "id">[])

TablesTournamentMatchVod

Routinesapp/routines/syncTournamentVods.ts

function

findTournamentsNeedingVodSync

no JSDoc:184

export function findTournamentsNeedingVodSync()

TablesCalendarEventCalendarEventDateTournament

Routinesapp/routines/syncTournamentVods.ts

Scriptsscripts/benchmark-db/cases.ts

function

markVodSyncCompleted

no JSDoc:215

export function markVodSyncCompleted(tournamentId: number)

TablesTournament

Routinesapp/routines/syncTournamentVods.ts

function

deleteObsolete

no JSDoc:226

export function deleteObsolete()

TablesCalendarEventCalendarEventDateTournamentMatchTournamentMatchVodTournamentStage

Routinesapp/routines/deleteObsoleteMatchVods.ts

function

findStreamersByTournamentId

no JSDoc:259

export function findStreamersByTournamentId(tournamentId: number)

TablesTournamentStreamer

Routinesapp/routines/syncTournamentVods.ts

Scriptsscripts/benchmark-db/cases.ts

function

findMatchesWithStartedAt

no JSDoc:271

export function findMatchesWithStartedAt(tournamentId: number)

TablesTournamentGroupTournamentMatchTournamentMatchGameResultTournamentMatchGameResultParticipantTournamentRoundTournamentStage

Routinesapp/routines/syncTournamentVods.ts

Scriptsscripts/benchmark-db/cases.ts

function

findCastedMatchHistoryByTournamentId

no JSDoc:317

export async function findCastedMatchHistoryByTournamentId(
	tournamentId: number,
)

TablesTournament

Routinesapp/routines/syncTournamentVods.ts

Scriptsscripts/benchmark-db/cases.ts