SendouQ · Repositories

1 module · 8 exports · 2 repositories · 16 e2e tests · 9 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.

PrivateUserNoteRepository

app/features/sendouq/PrivateUserNoteRepository.server.ts

Tables

PrivateUserNote

Calls

no other repositories

Imports

no other modules

Used by

1 route1 script

Functions & values

function

findAllOwn

no JSDoc:6

export function findAllOwn(
	/** Which users to get notes for, if omitted all notes for the author are returned */
	targetUserIds: number[] = [],
)

TablesPrivateUserNote

Scriptsscripts/benchmark-db/cases.ts

function

upsertOwnNote

no JSDoc:32

export function upsertOwnNote(
	args: Omit<TablesInsertable["PrivateUserNote"], "authorId">,
)

TablesPrivateUserNote

Unit tests (2)

• stamps the acting user as the author
• updates an existing note on conflict

Routes/user-card/:id/note

function

deleteOwnNoteById

no JSDoc:54

export function deleteOwnNoteById(targetId: number)

TablesPrivateUserNote

Routes/user-card/:id/note

Unit tests not about one export (2)

• PrivateUserNoteRepository › deleteOwnNote › deletes the acting user's note
• PrivateUserNoteRepository › findAllOwn throws when called without an acting user

SQGroupRepository

app/features/sendouq/SQGroupRepository.server.ts

Tables

AllTeamAllTeamMemberFriendshipGroupGroupLikeGroupMatchGroupMatchContinueVoteGroupMemberGroupReadyCheckGroupReadyCheckConfirmationGroupSuggestionSkillTeamTeamMemberWithSecondaryTenStarWeaponUserUserSubmittedImageUserWeaponPool

Calls

AdminRepositoryModAuditLogRepositoryChatRepository

Imports

no other modules

Used by

4 loaders7 actions1 route1 repository1 module3 routines1 script8 other

Functions & values

function

findMapModePreferencesByGroupId

no JSDoc:29

export async function findMapModePreferencesByGroupId(groupId: number)

TablesAllTeamGroupGroupMemberUser

Scriptsscripts/benchmark-db/cases.ts

Othersendouq/ready-check.server.ts

function

findAllByChatRoomIds

:65

Groups owning the given chat rooms, with their members' user ids.

export async function findAllByChatRoomIds(chatRoomIds: number[])

TablesGroupGroupMember

Scriptsscripts/benchmark-db/cases.ts

Otherchat/ChatRoomResolver.server.ts

function

findCurrentGroups

no JSDoc:85

export async function findCurrentGroups()

TablesAllTeamGroupGroupMatchGroupMemberTenStarWeaponUserUserSubmittedImageUserWeaponPool

Modulessendouq/SendouQ.server.ts

Scriptsscripts/benchmark-db/cases.ts

function

findActiveGroupMembers

no JSDoc:125

export async function findActiveGroupMembers()

TablesGroupGroupMember

Actions/q/preparing

Scriptsscripts/benchmark-db/cases.ts

function

insert

no JSDoc:138

export async function insert(args: CreateGroupArgs)

TablesGroupGroupMatchGroupMatchContinueVoteGroupMember

CallsChatRepository.insertRoom

Unit tests (8)

• creates an SQ_GROUP chat room owned by the group
• records
  • implicit no-vote on previous matchmade group when user creates a new group
  • the implicit no-vote on the newest matchmade group of many
• overrides the user's own yes vote on the previous match
• clears other members' yes votes on the previous group when recording implicit no
• leaves
  • the previous group's votes alone on a later, unrelated queue action
  • a passed vote alone when a member who voted yes leaves the successor group and queues again
• does not record any vote when user has no previous matchmade group

Actions/q

Otherapp/db/SQGroupFactory.ts

function

insertFromPrevious

no JSDoc:184

export async function insertFromPrevious(
	args: CreateGroupFromPreviousGroupArgs,
)

TablesAllTeamMemberGroupGroupMemberTeam

CallsChatRepository.updateRoomExpiresAtChatRepository.insertRoom

Unit tests (2)

• moves the previous group's chat room to the successor
• carries quick adds over only while the one who quick added stays

Actions/q/match/:id

function

syncTeamId

:276

Stamps the group as a team's when a full group's worth of members share one, else clears it. A team's group queues on the team's own map & mode preferences.

export async function syncTeamId(groupId: number, trx: Transaction<DB>)

TablesAllTeamMemberGroupGroupMemberTeam

Unit tests (4)

• stamps the group as the team's once the last of its members joins
• leaves the group unstamped when its members are not all of one team
• clears the stamp when a member leaves
• recomputes the stamp rather than copying it from the previous group

Repositoriessendouq-match/SQMatchRepository.server.ts

function

deleteLikesAndSuggestionsByGroupId

:339

Deletes every like and suggestion with the group on either side, for when they stop being actionable (roster changed, match started).

export async function deleteLikesAndSuggestionsByGroupId(
	groupId: number,
	trx: Transaction<DB>,
)

TablesGroupLikeGroupSuggestion

Repositoriessendouq-match/SQMatchRepository.server.ts

function

morphGroups

no JSDoc:372

export function morphGroups({
	survivingGroupId,
	otherGroupId,
}: {
	survivingGroupId: number;
	otherGroupId: number;
})

TablesAllTeamMemberGroupGroupLikeGroupMemberGroupSuggestionTeam

CallsChatRepository.updateRoomExpiresAtChatRepository.insertRoom

Unit tests (1)

• the survivor keeps its chat room and the other group's room is deleted

Actions/q/looking

function

insertMember

:470

Adds the user to the group. addedByUserId is the member who quick added them as their friend, null when they joined on their own.

export async function insertMember(
	groupId: number,
	{
		userId,
		addedByUserId = null,
	}: { userId: number; addedByUserId?: number | null },
)

TablesAllTeamMemberGroupGroupLikeGroupMatchGroupMatchContinueVoteGroupMemberGroupSuggestionTeam

Unit tests (1)

• records implicit no-vote on previous matchmade group when user joins another group

Actions/q/preparing/q

Otherapp/db/SQGroupFactory.ts

function

findCurrentReceivedLikerGroupIds

:503

Ids of the groups that have pending likes on each non-inactive group, keyed by the liked group's id.

export async function findCurrentReceivedLikerGroupIds()

TablesGroupGroupLike

Modulessendouq/SendouQ.server.ts

Scriptsscripts/benchmark-db/cases.ts

function

findAllLikesByGroupId

no JSDoc:521

export async function findAllLikesByGroupId(groupId: number)

TablesGroupLikeUser

Loaders/q/looking

Actions/q/looking

Scriptsscripts/benchmark-db/cases.ts

Othersendouq/likes.server.ts

function

findAllSuggestionsByGroupId

:557

Suggestions the given group's members have made to each other, newest first.

export async function findAllSuggestionsByGroupId(groupId: number)

TablesGroupSuggestionUser

Loaders/q/looking

Scriptsscripts/benchmark-db/cases.ts

function

rechallenge

no JSDoc:575

export function rechallenge({
	likerGroupId,
	targetGroupId,
}: {
	likerGroupId: number;
	targetGroupId: number;
})

TablesGroupLike

Actions/q/looking

function

findFriendsAndTeammates

no JSDoc:590

export async function findFriendsAndTeammates(userId: number)

TablesFriendshipTeamTeamMemberWithSecondaryUserUserSubmittedImage

CallsAdminRepository.findAllBannedUsers

Loaders/scrims/new/to/:id/register

Actions/scrims/new/q/preparing/to/:id/register

Routes/friends-for-adding

Scriptsscripts/benchmark-db/cases.ts

function

setOldGroupsAsInactive

no JSDoc:661

export async function setOldGroupsAsInactive()

TablesGroupGroupLikeGroupMatchGroupSuggestion

Unit tests (1)

• deletes the expired groups' likes and suggestions

Routinesapp/routines/setOldGroupsAsInactive.ts

function

closeExpiredContinueVotes

no JSDoc:710

export async function closeExpiredContinueVotes()

TablesGroupGroupMatchGroupMatchContinueVoteGroupMember

Routinesapp/routines/closeExpiredContinueVotes.ts

function

findAllMapModePreferencesBySeasonNth

no JSDoc:778

export async function findAllMapModePreferencesBySeasonNth(seasonNth: number)

TablesSkillUser

Scriptsscripts/benchmark-db/cases.ts

Othersendouq/default-maps.server.ts

function

findRecentlyFinishedMatches

no JSDoc:796

export async function findRecentlyFinishedMatches()

TablesGroupMatchGroupMember

Modulessendouq/SendouQ.server.ts

Scriptsscripts/benchmark-db/cases.ts

function

insertLike

no JSDoc:825

export function insertLike({
	likerGroupId,
	targetGroupId,
	createdByUserId,
}: {
	likerGroupId: number;
	targetGroupId: number;
	createdByUserId: number;
})

TablesGroupGroupLikeGroupSuggestion

Actions/q/looking

Otherapp/db/SQGroupFactory.tsapp/db/SQGroupLikeFactory.ts

function

insertSuggestion

:862

Marks a group as worth a look for the suggester's own teammates. Suggesting twice is a no-op.

export function insertSuggestion({
	suggesterGroupId,
	targetGroupId,
	createdByUserId,
}: {
	suggesterGroupId: number;
	targetGroupId: number;
	createdByUserId: number;
})

TablesGroupGroupSuggestion

Actions/q/looking

Otherapp/db/SQGroupSuggestionFactory.ts

function

deleteLike

no JSDoc:891

export function deleteLike({
	likerGroupId,
	targetGroupId,
}: {
	likerGroupId: number;
	targetGroupId: number;
})

TablesGroupGroupLike

Actions/q/looking

function

deleteAllLikesByGroupId

:910

Deletes every like where the given group is the liker or the target.

export function deleteAllLikesByGroupId(groupId: number)

TablesGroupLike

Othersendouq/likes.server.ts

function

leaveGroup

:921

Removes the user from their group (deleting it if they were last) along with the members they quick added, and in turn the ones those quick added. With keepQuickAddedMembers only the user is removed, for when they are kicked rather than leave, and the members they quick added stay as regular members. A ready check the group was in is called off. Challenges the group received and challenges/suggestions the leavers made are cleared.

• @returns

  the ids of the groups that were in the called off ready check and the ids of the users who left

export function leaveGroup(
	userId: number,
	{ keepQuickAddedMembers = false }: { keepQuickAddedMembers?: boolean } = {},
)

TablesAllTeamMemberGroupGroupLikeGroupMatchGroupMemberGroupReadyCheckGroupReadyCheckConfirmationGroupSuggestionTeam

Unit tests (7)

• takes the members the leaver quick added along, and the ones they quick added in turn
• deletes
  • the group when only members the leaver quick added would remain
  • the group and its chat room when the last member leaves
• leaves the members the leaver quick added in the group, no longer tied to the leaver, when told to keep them
• clears
  • the challenges the group received
  • the challenges the leaver sent but not those of the members who stay
  • the suggestions the leaver made but not those of the members who stay

Actions/q/looking

function

refreshGroup

no JSDoc:1025

export function refreshGroup(groupId: number, trx?: Transaction<DB>)

TablesGroup

Actions/q/looking

function

updateOwnMemberNote

no JSDoc:1033

export function updateOwnMemberNote({
	groupId,
	value,
}: {
	groupId: number;
	value: string | null;
})

TablesGroupGroupMember

CallsModAuditLogRepository.insert

Actions/q/looking

function

findAllMissedReadyCheckUserIdsByGroupId

:1060

User ids of the group's members who let a ready check expire without confirming, and can thus be kicked by the rest of the group.

export async function findAllMissedReadyCheckUserIdsByGroupId(groupId: number)

TablesGroupMember

Loaders/q/looking

Actions/q/looking

Scriptsscripts/benchmark-db/cases.ts

function

findReadyCheckByGroupId

:1072

The ready check the group is in, with each member of both groups and when (if at all) they confirmed being ready.

export async function findReadyCheckByGroupId(groupId: number)

TablesGroupMemberGroupReadyCheckGroupReadyCheckConfirmation

Loaders/q/ready

Actions/q/ready

Modulessendouq/SendouQ.server.ts

Scriptsscripts/benchmark-db/cases.ts

Othersendouq/ready-check.server.ts

function

findAllReadyChecksStartedBefore

:1113

Ready checks that were started before the given time.

export function findAllReadyChecksStartedBefore(date: Date)

TablesGroupMemberGroupReadyCheck

Routinesapp/routines/expireReadyChecks.ts

Scriptsscripts/benchmark-db/cases.ts

function

insertReadyCheck

:1145

Starts a ready check between two groups, taking both and everything they had pending out of the looking pool. The starter counts as ready right away.

export function insertReadyCheck({
	alphaGroupId,
	bravoGroupId,
	confirmedByUserId,
}: {
	alphaGroupId: number;
	bravoGroupId: number;
	confirmedByUserId: number;
})

TablesGroupGroupLikeGroupMemberGroupReadyCheckGroupReadyCheckConfirmationGroupSuggestion

Otherapp/db/SQReadyCheckFactory.tssendouq/ready-check.server.ts

function

insertReadyCheckConfirmation

:1197

Records the user as ready to play. Confirming twice is a no-op.

• @returns

  Whether every member of both groups has now confirmed, or null if the ready check no longer exists

export function insertReadyCheckConfirmation({
	readyCheckId,
	userId,
}: {
	readyCheckId: number;
	userId: number;
})

TablesGroupMemberGroupReadyCheckGroupReadyCheckConfirmation

Otherapp/db/SQReadyCheckFactory.tssendouq/ready-check.server.ts

function

deleteReadyCheck

:1237

Ends a ready check, returning both groups to the looking pool. markMissedMembers marks the unconfirmed as having missed it, which lets the rest of their group kick them.

export function deleteReadyCheck(
	{ id, markMissedMembers }: { id: number; markMissedMembers: boolean },
	trx?: Transaction<DB>,
)

TablesGroupGroupMemberGroupReadyCheckGroupReadyCheckConfirmation

Repositoriessendouq-match/SQMatchRepository.server.ts

Othersendouq/ready-check.server.ts

function

setPreparingGroupAsActive

no JSDoc:1247

export function setPreparingGroupAsActive(groupId: number)

TablesGroup

Actions/q/preparing

function

setAsInactive

no JSDoc:1256

export function setAsInactive(groupId: number, trx?: Transaction<DB>)

TablesGroup

Repositoriessendouq-match/SQMatchRepository.server.ts

Modulessendouq/SendouQ.server.ts