Friends · Repositories

F

0 modules · 0 exports · 1 repository · 6 e2e tests · 1 route

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

FriendRepository

app/features/friends/FriendRepository.server.ts

Tables

CalendarEventCalendarEventDateFriendRequestFriendshipTeamMemberWithSecondaryTournamentTournamentTeamTournamentTeamMemberUserUserSubmittedImage

Calls

no other repositories

Imports

no other modules

Used by

2 loaders1 action1 route1 repository1 routine1 script5 other

Functions & values

function

findByUserIdWithActivity

no JSDoc:11

export async function findByUserIdWithActivity(userId: number)

TablesCalendarEventCalendarEventDateFriendshipTeamMemberWithSecondaryTournamentTournamentTeamTournamentTeamMemberUserUserSubmittedImage

Unit tests (2)

• returns
  • friends with friendshipId and createdAt
  • empty array when user has no friends or team members

Loaders/friends

Scriptsscripts/benchmark-db/cases.ts

Othersidebar/sidebar.server.ts

function

findPendingSentRequests

no JSDoc:145

export async function findPendingSentRequests(senderId: number)

TablesFriendRequestUserUserSubmittedImage

Loaders/friends

Scriptsscripts/benchmark-db/cases.ts

function

insertFriendRequest

no JSDoc:159

export async function insertFriendRequest({
	senderId,
	receiverId,
}: {
	senderId: number;
	receiverId: number;
})

TablesFriendRequest

Actions/friends

Otherapp/db/FriendRequestFactory.tsapp/db/FriendshipFactory.ts

function

deleteFriendRequest

no JSDoc:173

export async function deleteFriendRequest({
	id,
	senderId,
}: {
	id: number;
	senderId: number;
})

TablesFriendRequest

Unit tests (2)

• deletes request by sender
• does not delete when wrong senderId is used

Actions/friends

function

deleteOldPendingRequests

no JSDoc:188

export function deleteOldPendingRequests()

TablesFriendRequest

Routinesapp/routines/deleteOldPendingFriendRequests.ts

function

findFriendRequestBetween

no JSDoc:201

export async function findFriendRequestBetween({
	senderId,
	receiverId,
}: {
	senderId: number;
	receiverId: number;
})

TablesFriendRequest

Routes/user-card/:id/friendship

Scriptsscripts/benchmark-db/cases.ts

Otherfriends/friends-schemas.server.ts

function

deleteOwnFriendshipById

no JSDoc:226

export async function deleteOwnFriendshipById(id: number)

TablesFriendship

Actions/friends

function

updateOwnFriendshipPinned

:241

Pins or unpins the friendship for the acting user only, the other side keeps their own choice.

export async function updateOwnFriendshipPinned({
	friendshipId,
	isPinned,
}: {
	friendshipId: number;
	isPinned: boolean;
})

TablesFriendship

Unit tests (3)

• pins the friendship for the acting user only
• unpins a pinned friendship
• does not pin a friendship the user is not part of

Actions/friends

function

findPendingReceivedRequests

no JSDoc:277

export async function findPendingReceivedRequests(receiverId: number)

TablesFriendRequestUserUserSubmittedImage

Loaders/friends

Scriptsscripts/benchmark-db/cases.ts

function

findPendingReceivedRequestIds

no JSDoc:291

export async function findPendingReceivedRequestIds(
	receiverId: number,
): Promise<number[]>

TablesFriendRequest

Scriptsscripts/benchmark-db/cases.ts

Othersidebar/sidebar.server.ts

function

insertFriendship

no JSDoc:303

export async function insertFriendship({
	userOneId,
	userTwoId,
	friendRequestId,
}: {
	userOneId: number;
	userTwoId: number;
	friendRequestId: number;
})

TablesFriendRequestFriendship

Actions/friends

Otherapp/db/FriendshipFactory.ts

function

findFriendRequestByIdAndReceiver

no JSDoc:331

export async function findFriendRequestByIdAndReceiver({
	id,
	receiverId,
}: {
	id: number;
	receiverId: number;
})

TablesFriendRequestUser

Unit tests (2)

• returns
  • sender ID when request exists for receiver
  • undefined for wrong receiver

Actions/friends

Scriptsscripts/benchmark-db/cases.ts

function

deleteFriendRequestByReceiver

no JSDoc:347

export async function deleteFriendRequestByReceiver({
	id,
	receiverId,
}: {
	id: number;
	receiverId: number;
})

TablesFriendRequest

Unit tests (1)

• deletes request by receiver

Actions/friends

function

findMutualFriends

no JSDoc:361

export async function findMutualFriends({
	loggedInUserId,
	targetUserId,
}: {
	loggedInUserId: number;
	targetUserId: number;
})

TablesFriendshipUserUserSubmittedImage

Unit tests (2)

• returns
  • mutual friend when two users share a common friend
  • empty array when no common friends

Loaders/u/:identifier

Routes/user-card/:id/friendship

Scriptsscripts/benchmark-db/cases.ts

function

countPendingSentRequests

no JSDoc:421

export async function countPendingSentRequests(
	senderId: number,
): Promise<number>

TablesFriendRequest

Unit tests (2)

• returns
  • 0 with no requests
  • correct count after inserting multiple requests

Actions/friends

Scriptsscripts/benchmark-db/cases.ts

function

findFriendsByUserId

no JSDoc:433

export async function findFriendsByUserId(userId: number)

TablesFriendshipUserUserSubmittedImage

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findFriendIds

no JSDoc:461

export async function findFriendIds(userId: number): Promise<number[]>

TablesFriendship

Repositoriesassociations/AssociationRepository.server.ts

Scriptsscripts/benchmark-db/cases.ts

function

findFriendship

no JSDoc:484

export async function findFriendship({
	userOneId,
	userTwoId,
}: {
	userOneId: number;
	userTwoId: number;
})

TablesFriendship

Routes/user-card/:id/friendship

Scriptsscripts/benchmark-db/cases.ts

Otherfriends/friends-schemas.server.ts

Unit tests not about one export (13)

• insertFriendRequest / findFriendRequestBetween › finds
  • request from sender to receiver
  • request in reverse direction
• insertFriendRequest / findFriendRequestBetween › returns undefined for unrelated users
• findPendingSentRequests / findPendingReceivedRequests › sent
  • request appears in sender's sent requests
  • request appears in receiver's received requests
• findPendingSentRequests / findPendingReceivedRequests › does not appear in wrong user's requests
• insertFriendship / findFriendship / findFriendIds › creates friendship and removes friend request
• insertFriendship / findFriendship / findFriendIds › normalizes IDs so userOneId < userTwoId
• insertFriendship / findFriendship / findFriendIds › findFriendIds
  • returns friend's ID
  • returns friend ID from both sides
  • returns empty array with no friends
• deleteFriendship › removes friendship
• deleteFriendship › does not delete friendship user is not part of