Calendar · Repositories

3 modules · 31 exports · 1 repository · 11 e2e tests · 6 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.

CalendarRepository

app/features/calendar/CalendarRepository.server.ts

Tables

BadgeCalendarEventCalendarEventBadgeCalendarEventDateCalendarEventResultPlayerCalendarEventResultTeamMapPoolMapTournamentTournamentOrganizationTournamentOrganizationMemberTournamentResultTournamentStaffTournamentStageTournamentTeamTournamentTeamCheckInTournamentTeamMemberTrophyUnvalidatedUserSubmittedImageUserUserSubmittedImage

Calls

TournamentOrganizationRepository

Imports

CalendarEventTeamPickProgressionSeries

Used by

6 loaders4 actions1 script4 other

Functions & values

function

findAllBetweenTwoTimestamps

no JSDoc:126

export async function findAllBetweenTwoTimestamps(
	args: FindAllBetweenTwoTimestampsArgs,
)

TablesBadgeCalendarEventCalendarEventBadgeCalendarEventDateMapPoolMapTournamentTournamentOrganizationTournamentResultTournamentStageTournamentTeamTournamentTeamCheckInTournamentTeamMemberTrophyUnvalidatedUserSubmittedImage

CallsTournamentOrganizationRepository.findAllSeries

Unit tests (1)

• tags only leagues with the virtual LEAGUE tag, ahead of their own tags

Loaders/calendar/calendar.ics

Scriptsscripts/benchmark-db/cases.ts

function

findById

no JSDoc:312

export async function findById(
	id: number,
	{
		includeMapPool = false,
		includeBadgePrizes = false,
		includeTrophy = false,
	}: {
		includeMapPool?: boolean;
		includeBadgePrizes?: boolean;
		includeTrophy?: boolean;
	} = {},
)

TablesBadgeCalendarEventCalendarEventBadgeCalendarEventDateMapPoolMapTournamentTournamentOrganizationTrophyUserUserSubmittedImage

PermissionsEDITDELETEREPORT_WINNERS

Loaders/calendar/:id/report-winners/calendar/:id/calendar/new/to/:id/brackets/finalize

Actions/calendar/:id/report-winners/calendar/:id/calendar/new/to/:id/brackets/finalize

Scriptsscripts/benchmark-db/cases.ts

Otherapp/db/TournamentFactory.ts

function

findAvatarImgIds

:383

Logo image ids of the given event and of the given tournament's event: what the new event form may keep when editing or copying.

export async function findAvatarImgIds({
	eventId,
	tournamentId,
}: {
	eventId?: number;
	tournamentId?: number;
})

TablesCalendarEvent

Unit tests (2)

• returns
  • the logos of the edited event and of the copied tournament's event
  • nothing when neither an event nor a tournament is given

Actions/calendar/new

Scriptsscripts/benchmark-db/cases.ts

function

findRecentTournamentsByOrganizerUserId

:413

Past year's tournaments the user organized (author, organization ADMIN/ORGANIZER or staff ORGANIZER), newest first. Latest event per series only, the next newest filling spare spots.

export async function findRecentTournamentsByOrganizerUserId(userId: number)

TablesCalendarEventCalendarEventDateTournamentTournamentOrganizationMemberTournamentStaff

CallsTournamentOrganizationRepository.findAllSeriesByOrganizationIds

Unit tests (6)

• drops the older edition of a series when there are more events than spots
• keeps
  • the latest edition of an older series over the older edition of a newer one
  • every event of an organization whose names match no series
• fills the remaining spots with older editions of a series
• excludes events that started over a year ago
• includes events that belong to no organization

Loaders/calendar/new

Scriptsscripts/benchmark-db/cases.ts

function

findResultsByEventId

no JSDoc:500

export async function findResultsByEventId(eventId: number)

TablesCalendarEventResultPlayerCalendarEventResultTeamUserUserSubmittedImage

Loaders/calendar/:id/report-winners/calendar/:id

Scriptsscripts/benchmark-db/cases.ts

Otherapp/db/CalendarEventResultFactory.ts

function

findTopThreeResultsByEventIds

:528

Podium players of the events, one row each; players reported as plain text have a null id.

export async function findTopThreeResultsByEventIds(eventIds: number[])

TablesCalendarEventResultPlayerCalendarEventResultTeamUserUserSubmittedImage

Scriptsscripts/benchmark-db/cases.ts

Othertournament-organization/leaderboards.server.ts

function

insert

no JSDoc:591

export async function insert(args: CreateArgs)

TablesCalendarEventCalendarEventBadgeCalendarEventDateMapPoolMapTournamentTournamentStaffUnvalidatedUserSubmittedImage

Actions/calendar/new

Otherapp/db/CalendarEventFactory.tsapp/db/TournamentFactory.ts

function

update

no JSDoc:710

export async function update(args: UpdateArgs)

TablesCalendarEventCalendarEventBadgeCalendarEventDateMapPoolMapTournamentTournamentTeamTournamentTeamCheckInUnvalidatedUserSubmittedImage

Actions/calendar/new

function

upsertReportedScores

no JSDoc:947

export function upsertReportedScores(args: {
	eventId: number;
	participantCount: number;
	results: Array<{
		teamName: string;
		placement: number;
		players: Array<{
			userId: number | null;
			name: string | null;
		}>;
	}>;
})

TablesCalendarEventCalendarEventResultPlayerCalendarEventResultTeam

Actions/calendar/:id/report-winners

Otherapp/db/CalendarEventResultFactory.ts

function

deleteById

:1026

Deletes the event, and its tournament if it has one.

export function deleteById(eventId: number)

TablesCalendarEvent

Unit tests (2)

• deleting a tournament's event deletes the tournament and its chat rooms
• deletes an event without a tournament

Actions/calendar/:id