Art · Repositories

0 modules · 0 exports · 1 repository · 2 e2e tests · 2 routes

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

ArtRepository

app/features/art/ArtRepository.server.ts

Tables

ArtArtTagArtUserMetadataTaggedArtUnvalidatedUserSubmittedImageUserUserSubmittedImage

Calls

no other repositories

Imports

no other modules

Used by

3 loaders2 actions1 routine1 script2 other

Functions & values

function

unlinkOwnFromArt

no JSDoc:14

export function unlinkOwnFromArt(artId: number)

TablesArtUserMetadata

Actions/u/:identifier/art

function

findShowcaseArts

no JSDoc:30

export async function findShowcaseArts(): Promise<ListedArt[]>

TablesArtArtUserMetadataUserUserSubmittedImage

PermissionsEDITUNLINK

Unit tests (5)

• shows
  • one art per artist
  • only one art per artist even with multiple pieces
  • artist even if no showcase art exists
• prioritizes showcase art over regular art for same artist
• returns empty array when no art exists

Loaders/art

Scriptsscripts/benchmark-db/cases.ts

function

findShowcaseArtsByTag

no JSDoc:90

export async function findShowcaseArtsByTag(
	tagId: Tables["ArtTag"]["id"],
): Promise<ListedArt[]>

TablesArtArtUserMetadataTaggedArtUserUserSubmittedImage

PermissionsEDITUNLINK

Unit tests (2)

• returns arts filtered by tag
• shows only one art per artist

Loaders/art

Scriptsscripts/benchmark-db/cases.ts

function

findRecentlyUploadedArts

no JSDoc:144

export async function findRecentlyUploadedArts(): Promise<ListedArt[]>

TablesArtArtUserMetadataUserUserSubmittedImage

PermissionsEDITUNLINK

Unit tests (1)

• returns recently uploaded arts

Loaders/art

Scriptsscripts/benchmark-db/cases.ts

function

findAllTags

no JSDoc:182

export async function findAllTags()

TablesArtTag

Unit tests (2)

• returns
  • all art tags
  • empty array when no tags exist

Loaders/art/new/art

Scriptsscripts/benchmark-db/cases.ts

function

deleteOrphanTags

no JSDoc:186

export async function deleteOrphanTags()

TablesArtTagTaggedArt

Unit tests (2)

• deletes tags with no associated art
• does not delete tags that are still linked to art

Routinesapp/routines/deleteOrphanArtTags.ts

function

findById

:196

Art by its id, with the ids of the users tagged in it.

export async function findById(id: Tables["Art"]["id"])

TablesArtArtUserMetadata

PermissionsEDITUNLINK

Actions/art/new/u/:identifier/art

Scriptsscripts/benchmark-db/cases.ts

function

findArtsByUserId

no JSDoc:219

export async function findArtsByUserId(
	userId: number,
	{ includeAuthored = true, includeTagged = true } = {},
): Promise<ListedArt[]>

TablesArtArtTagArtUserMetadataTaggedArtUserUserSubmittedImage

PermissionsEDITUNLINK

Unit tests (2)

• returns
  • authored art
  • tagged art

Loaders/art/new/u/:identifier/art

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

deleteById

no JSDoc:341

export async function deleteById(id: number)

TablesArt

Unit tests (2)

• deletes
  • art by id
  • only the specified art

Actions/u/:identifier/art

function

insert

no JSDoc:353

export async function insert(args: InsertArtArgs)

TablesArtArtTagArtUserMetadataTaggedArtUnvalidatedUserSubmittedImage

Unit tests (2)

• inserts art with all metadata
• sets first art as showcase

Actions/art/new

Otherapp/db/ArtFactory.ts

function

update

no JSDoc:400

export async function update(id: number, args: UpdateArtArgs)

TablesArtArtTagArtUserMetadataTaggedArt

Unit tests (2)

• updates art metadata
• unsets other showcase art when setting new showcase

Actions/art/new

Unit tests not about one export (1)

• unlinkUserFromArt › removes user link from art