Img upload · Repositories

I

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

OverviewRepositoriesPermissions

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.

ImageRepository

app/features/img-upload/ImageRepository.server.ts

Tables

ArtCalendarEventTeamUnvalidatedUserSubmittedImageUser

Calls

no other repositories

Imports

no other modules

Used by

2 loaders1 action1 script2 other

Functions & values

function

findById

:9

Unvalidated image's submitter with its calendar event data.

export function findById(id: number)

TablesCalendarEventUnvalidatedUserSubmittedImage

Unit tests (3)

• finds
  • image by id
  • image with calendar event data
• returns undefined for non-existent image

Actions/upload/admin

Scriptsscripts/benchmark-db/cases.ts

Otherimg-upload/image-field.server.ts

function

deleteById

:26

Deletes an image and its art entry.

export function deleteById(id: number)

TablesArtUnvalidatedUserSubmittedImage

Unit tests (2)

• deletes
  • image by id
  • associated art when deleting image

Actions/upload/admin

function

countUnvalidatedArt

:37

Count of the author's unvalidated art images.

export async function countUnvalidatedArt(authorId: number)

TablesArtUnvalidatedUserSubmittedImage

Unit tests (3)

• counts unvalidated art by author
• does not count validated art
• returns 0 when author has no unvalidated art

Loaders/u/:identifier/art

Scriptsscripts/benchmark-db/cases.ts

function

countAllUnvalidated

:92

Count of unvalidated images used in teams, art or calendar events.

export async function countAllUnvalidated()

TablesArtCalendarEventTeamUnvalidatedUserSubmittedImage

Unit tests (5)

• counts
  • unvalidated images used in art
  • unvalidated images used in calendar events
  • multiple unvalidated images across different types
• does not count validated images
• returns 0 when no unvalidated images exist

Loaders/upload/admin

Scriptsscripts/benchmark-db/cases.ts

function

findAllUnvalidated

:100

Unvalidated images for admin review, with submitter info.

export function findAllUnvalidated()

TablesArtCalendarEventTeamUnvalidatedUserSubmittedImageUser

Unit tests (5)

• fetches
  • unvalidated images with submitter info
  • images from art and calendar events
• does not fetch validated images
• respects the max unvalidated images to show at once for approval limit constant
• returns empty array when no unvalidated images exist

Loaders/upload/admin

Scriptsscripts/benchmark-db/cases.ts

function

countUnvalidatedBySubmitterUserId

:120

Count of the user's unvalidated images connected to a team, art or event (orphans excluded); gates image() uploads.

export async function countUnvalidatedBySubmitterUserId(userId: number)

TablesArtCalendarEventTeamUnvalidatedUserSubmittedImage

Unit tests (5)

• counts unvalidated images connected to art by submitter
• does
  • not count orphan images not connected to anything
  • not count validated images
  • not count images from other submitters
• returns 0 when user has no unvalidated images

Scriptsscripts/benchmark-db/cases.ts

Otherimg-upload/image-field.server.ts

function

validateById

:129

Marks an image as validated.

export function validateById(id: number)

TablesUnvalidatedUserSubmittedImage

Unit tests (2)

• marks image as validated
• validated image is not included in unvalidated count

Actions/upload/admin

Otherapp/db/ImageFactory.ts

function

insert

:138

Inserts an unvalidated image row without an owner. Returns the inserted row.

export function insert(
	args: TablesInsertable["UnvalidatedUserSubmittedImage"],
	trx?: Transaction<DB>,
)

TablesUnvalidatedUserSubmittedImage

Otherapp/db/ImageFactory.tsimg-upload/image-field.server.ts