Plus suggestions · Repositories

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.

PlusSuggestionRepository

app/features/plus-suggestions/PlusSuggestionRepository.server.ts

Tables: PlusSuggestion PlusTier User UserSubmittedImage
Calls: no other repositories
Imports: no other modules
Used by: 1 loader3 actions1 route1 repository1 script3 other

Types

type

`FindAllByMonthItem`

no JSDoc:15

export type FindAllByMonthItem = Unwrapped<typeof findAllByMonth>;

Routes/plus/suggestions

Repositoriesplus-voting/PlusVotingRepository.server.ts

Otherplus-suggestions/plus-suggestions-utils.ts

interface

`MonthSummary`

no JSDoc:125

export interface MonthSummary {
	/** How many users have been suggested, per tier. */
	suggestionCountsByTier: Record<PlusTier, number>;
	/** Tiers `userId` has themselves been suggested to. */
	suggestedForTiers: Array<PlusTier>;
	/** Whether `userId` has started a suggestion of their own this month. */
	hasSuggested: boolean;
}

Only used inside the module

Functions & values

function

`findAllByMonth`

no JSDoc:17

export async function findAllByMonth(args: MonthYear & { tier?: number })

TablesPlusSuggestion PlusTier User UserSubmittedImage

PermissionsEDIT DELETE

Loaders/plus/suggestions

Actions/plus/suggestions/comment/:tier/:userId /plus/suggestions

Repositoriesplus-voting/PlusVotingRepository.server.ts

Scriptsscripts/benchmark-db/cases.ts

Otherplus-suggestions/plus-suggestions-schemas.server.ts

function

`findMonthSummary`

no JSDoc:134

export async function findMonthSummary(
	args: MonthYear & { userId: number | null },
): Promise<MonthSummary>

TablesPlusSuggestion PlusTier

Loaders/plus/suggestions

Actions/plus/suggestions/new

Scriptsscripts/benchmark-db/cases.ts

function

`insert`

no JSDoc:172

export function insert(args: Insertable<DB["PlusSuggestion"]>)

TablesPlusSuggestion

Actions/plus/suggestions/comment/:tier/:userId /plus/suggestions/new

Otherapp/db/PlusSuggestionFactory.ts

function

`updateTextById`

no JSDoc:180

export function updateTextById(id: number, text: string)

TablesPlusSuggestion

Actions/plus/suggestions

function

`deleteById`

no JSDoc:188

export function deleteById(id: number)

TablesPlusSuggestion

Actions/plus/suggestions

function

`deleteWithCommentsBySuggestedUserId`

no JSDoc:192

export function deleteWithCommentsBySuggestedUserId({
	tier,
	userId,
	month,
	year,
}: {
	tier: number;
	userId: number;
	month: number;
	year: number;
})

TablesPlusSuggestion

Actions/plus/suggestions