Team · Repositories | sendou.ink docs

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.

TeamRepository

app/features/team/TeamRepository.server.ts

Tables: AllTeam AllTeamMember CalendarEvent CalendarEventDate Team TeamMember TeamMemberWithSecondary TenStarWeapon Tournament TournamentDivisionTier TournamentResult TournamentTeam UnvalidatedUserSubmittedImage User UserSubmittedImage UserWeaponPool
Calls: LFGRepository MatchProfileRepository
Imports: no other modules
Used by: 11 loaders10 actions2 routes1 script6 other

Types

type

`findByCustomUrl`

no JSDoc:103

export type findByCustomUrl = NonNullable<
	Awaited<ReturnType<typeof findByCustomUrl>>
>;

Loaders/t/:customUrl/schedule /t/:customUrl/edit /t/:customUrl/join /t/:customUrl/results /t/:customUrl/roster /t/:customUrl

Actions/t/:customUrl/schedule /t/:customUrl/edit /t/:customUrl /t/:customUrl/join /t/:customUrl/roster

Routes/t/:customUrl

Scriptsscripts/benchmark-db/cases.ts

Otherteam/team-schemas.server.ts team/team-utils.ts

type

`FindResultPlacementsById`

no JSDoc:202

export type FindResultPlacementsById = NonNullable<
	Awaited<ReturnType<typeof findResultPlacementsById>>
>;

Loaders/t/:customUrl

Functions & values

function

`searchByName`

no JSDoc:23

export function searchByName({
	query,
	limit,
}: {
	query: string;
	limit: number;
})

TablesTeam TeamMemberWithSecondary User UserSubmittedImage

Routes/search

Scriptsscripts/benchmark-db/cases.ts

function

`findById`

no JSDoc:71

export function findById(teamId: number)

TablesAllTeam

Actions/to/:id/register /to/:id/admin/registration/:tid?

Scriptsscripts/benchmark-db/cases.ts

Othertournament/tournament-register-schemas.server.ts tournament-admin/tournament-admin-registration-schemas.server.ts

function

`findAllMemberOfByUserId`

no JSDoc:79

export function findAllMemberOfByUserId(userId: number)

TablesTeam TeamMemberWithSecondary UserSubmittedImage

Loaders/events /t/new /to/:id/register

Actions/events /t/new /to/:id/register

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

`findByCustomUrl`

no JSDoc:107

export async function findByCustomUrl(
	customUrl: string,
	{
		includeInviteCode = false,
		includeUnvalidatedImages = false,
		includeMapModePreferences = false,
	} = {},
)

TablesTeam TeamMemberWithSecondary TenStarWeapon UnvalidatedUserSubmittedImage User UserSubmittedImage UserWeaponPool

PermissionsEDIT MANAGE_ROSTER DELETE

Loaders/t/:customUrl/schedule /t/:customUrl/edit /t/:customUrl/join /t/:customUrl/results /t/:customUrl/roster /t/:customUrl

Actions/t/:customUrl/schedule /t/:customUrl/edit /t/:customUrl /t/:customUrl/join /t/:customUrl/roster

Routes/t/:customUrl

Scriptsscripts/benchmark-db/cases.ts

Otherteam/team-schemas.server.ts team/team-utils.ts

function

`findResultPlacementsById`

no JSDoc:206

export function findResultPlacementsById(teamId: number)

TablesTournamentResult TournamentTeam

Loaders/t/:customUrl

Scriptsscripts/benchmark-db/cases.ts

function

`findResultsById`

:221

Tournament results of the team.

export async function findResultsById(teamId: number)

TablesAllTeamMember CalendarEvent CalendarEventDate Tournament TournamentDivisionTier TournamentResult TournamentTeam UnvalidatedUserSubmittedImage User UserSubmittedImage

Unit tests (1)

participant who was on the roster at the result's time but left later is not a sub

Loaders/t/:customUrl/results

Scriptsscripts/benchmark-db/cases.ts

function

`findAllByMemberUserId`

no JSDoc:327

export async function findAllByMemberUserId(
	userId: number,
	trx?: Transaction<DB>,
)

TablesTeam TeamMemberWithSecondary User UserSubmittedImage

Unit tests (1)

returns the main team first

Loaders/scrims/new /scrims /t/:customUrl/join

Actions/scrims/new

Scriptsscripts/benchmark-db/cases.ts

function

`insert`

no JSDoc:357

export async function insert(
	args: Pick<Insertable<Tables["Team"]>, "name"> & {
		ownerUserId: number;
		isMainTeam: boolean;
	},
)

TablesAllTeam AllTeamMember

Actions/t/new

Otherapp/db/TeamFactory.ts

function

`update`

no JSDoc:390

export async function update({
	id,
	name,
	bio,
	bsky,
	tag,
	avatarImgId,
	bannerImgId,
}: Pick<
	Insertable<Tables["Team"]>,
	"id" | "name" | "bio" | "bsky" | "tag" | "avatarImgId" | "bannerImgId"
>)

TablesAllTeam Team UnvalidatedUserSubmittedImage

Actions/t/:customUrl/edit

Otherapp/db/TeamFactory.ts

function

`updateCustomTheme`

no JSDoc:444

export async function updateCustomTheme({
	id,
	customTheme,
}: {
	id: number;
	customTheme: CustomTheme | null;
})

TablesAllTeam

Actions/t/:customUrl/edit

function

`updateMapModePreferences`

:461

Sets (or clears with null) SendouQ map/mode preferences; map pools of modes missing from the new value are kept.

export async function updateMapModePreferences({
	id,
	mapModePreferences,
}: {
	id: number;
	mapModePreferences: UserMapModePreferences | null;
})

TablesAllTeam Team

CallsMatchProfileRepository.mergeExcludedModePreferences

Actions/t/:customUrl/edit

Otherapp/db/TeamFactory.ts

function

`switchOwnMainTeam`

no JSDoc:498

export function switchOwnMainTeam(teamId: number)

TablesAllTeamMember Team TeamMemberWithSecondary User UserSubmittedImage

Actions/t/:customUrl

function

`deleteById`

no JSDoc:525

export function deleteById(teamId: number)

TablesAllTeam AllTeamMember Team TeamMember TeamMemberWithSecondary User UserSubmittedImage

CallsLFGRepository.deletePostsByTeamId

Actions/t/:customUrl

function

`resetInviteCode`

no JSDoc:571

export function resetInviteCode(teamId: number)

TablesAllTeam

Actions/t/:customUrl/roster

function

`insertOwnMembership`

no JSDoc:581

export function insertOwnMembership({
	teamId,
	maxTeamsAllowed,
}: {
	teamId: number;
	maxTeamsAllowed: number;
})

TablesAllTeamMember Team TeamMemberWithSecondary User UserSubmittedImage

Actions/t/:customUrl/join

Otherapp/db/TeamFactory.ts

function

`handleMemberLeaving`

no JSDoc:622

export function handleMemberLeaving({
	userId,
	teamId,
	newOwnerUserId,
}: {
	userId: number;
	teamId: number;
	newOwnerUserId?: number;
})

TablesAllTeamMember Team TeamMemberWithSecondary User UserSubmittedImage

Actions/t/:customUrl

function

`updateRoster`

:637

In one transaction: updates kept members' role & editor status and kicks kickedUserIds.

export function updateRoster({
	teamId,
	members,
	kickedUserIds,
}: {
	teamId: number;
	members: Array<{
		userId: number;
		role: Tables["TeamMember"]["role"];
		customRole: Tables["TeamMember"]["customRole"];
		roleType: Tables["TeamMember"]["roleType"];
		isManager: boolean;
		order: number;
	}>;
	kickedUserIds: number[];
})

TablesAllTeamMember Team TeamMemberWithSecondary User UserSubmittedImage

Actions/t/:customUrl/roster

Otherapp/db/TeamFactory.ts