Builds · Repositories

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

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

BuildRepository

app/features/builds/BuildRepository.server.ts

Tables

BuildBuildAbilitySumBuildWeaponBuildWeaponAbilityPlusTierSplatoonPlayerUserUserSubmittedImageXRankPlacement

Calls

no other repositories

Imports

no other modules

Used by

5 loaders2 actions1 repository2 scripts6 other

Functions & values

function

findAllByUserId

no JSDoc:46

export async function findAllByUserId(
	userId: number,
	options: {
		showPrivate?: boolean;
		sortAbilities?: boolean;
		limit?: number;
	} = {},
)

TablesBuildBuildWeapon

PermissionsEDIT

Loaders/u/:identifier/builds/new

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

insert

no JSDoc:107

export async function insert(args: CreateArgs)

TablesBuildBuildAbilitySumBuildWeaponBuildWeaponAbilityPlusTierSplatoonPlayerXRankPlacement

Actions/u/:identifier/builds/new

Otherapp/db/BuildFactory.ts

function

update

no JSDoc:146

export async function update(args: CreateArgs & { id: number })

TablesBuildBuildAbilitySumBuildWeaponBuildWeaponAbilityPlusTierSplatoonPlayerXRankPlacement

Actions/u/:identifier/builds/new

function

deleteById

no JSDoc:188

export function deleteById(id: number)

TablesBuild

Actions/u/:identifier/builds

function

findOwnerIdById

no JSDoc:192

export async function findOwnerIdById(buildId: number)

TablesBuild

Actions/u/:identifier/builds

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/user-page-schemas.server.ts

function

findAllAbilityPointSums

:203

Ability point sums of every public build updated after the date (YYYY-MM-DD, all when null), a build counted once however many weapons it lists.

export async function findAllAbilityPointSums(updatedSince: string | null)

TablesBuildBuildAbilitySum

Unit tests (2)

• sums the AP of every public build, a multi-weapon build counted once
• only sums builds updated after the date

Loaders/builds/:slug/stats

Scriptsscripts/benchmark-db/cases.ts

Otherbuild-stats/build-stats-utils.ts

function

findAbilityPointCountsByWeaponIds

:239

For each of the weapons (alt skins folded), how many public builds updated after the date (YYYY-MM-DD, all when null) run each amount of AP of each ability, plus their build counts.

export async function findAbilityPointCountsByWeaponIds({
	weaponIds,
	updatedSince,
}: {
	weaponIds: MainWeaponId[];
	updatedSince: string | null;
})

TablesBuildWeaponBuildWeaponAbility

Unit tests (2)

• counts the builds running each amount of AP of each ability per weapon
• only counts builds updated after the date

Loaders/builds/:slug/stats

Scriptsscripts/benchmark-db/cases.ts

Otherbuild-stats/build-stats-utils.ts

function

findNewestBuildPerOwnerByWeaponId

:299

The newest public build of each owner listing the weapon (alt skins folded), if updated after the date (YYYY-MM-DD, any time when null).

export async function findNewestBuildPerOwnerByWeaponId({
	weaponId,
	updatedSince,
}: {
	weaponId: MainWeaponId;
	updatedSince: string | null;
})

TablesBuildBuildWeapon

Unit tests (4)

• returns only each owner's newest build
• only returns public builds
• folds alt skins via canonicalWeaponSplId
• leaves out owners whose newest build was updated before the date

Loaders/builds/:slug/popular

Scriptsscripts/benchmark-db/cases.ts

Otherbuild-stats/build-stats-utils.ts

function

findPageByWeaponId

:356

A page of the authors of public builds listing the weapon (alt skins folded) that match the filters, with all of their matching builds. Authors rank by their best ranked build and their builds come together, best first. buildCount counts every matching build but only while filtering (null otherwise, as it would cost an extra read).

export async function findPageByWeaponId({
	weaponId,
	filters,
	page,
	sortAbilities: shouldSortAbilities,
}: {
	weaponId: MainWeaponId;
	filters: BuildListFilters;
	page: number;
	sortAbilities: boolean;
})

TablesBuildBuildWeaponBuildWeaponAbilityPlusTierUserUserSubmittedImage

Unit tests (8)

• pages by author with all of their builds, counting the authors
• keeps an author's builds together, after their newest
• ranks authors by their best ranked build
• excludes private builds
• filters
  • by abilities: $why
  • by mode
  • by the date the build was last updated after
• counts the matching builds only when filtering

Loaders/builds/:slug

Scriptsscripts/benchmark-db/cases.ts

function

findPageByUserId

:451

A page of the user's builds matching the filters, in their chosen sort order.

export async function findPageByUserId({
	userId,
	showPrivate,
	filters,
	sorting,
	page,
	sortAbilities: shouldSortAbilities,
}: {
	userId: number;
	showPrivate: boolean;
	filters: BuildListFilters & {
		/** Exact weapon id, alt skins and kits not folded. */
		weaponId: MainWeaponId | null;
		visibility: "PUBLIC" | "PRIVATE" | null;
	};
	sorting: {
		buildSorting: BuildSort[] | null;
		weaponPool: MainWeaponId[];
	};
	page: number;
	sortAbilities: boolean;
})

TablesBuildBuildWeapon

PermissionsEDIT

Unit tests (17)

• hides private builds unless asked to show them
• filters
  • private builds by their abilities too
  • by abilities: $why
  • by exact weapon id
  • by visibility
• returns a page of builds and the total count
• grants the owner edit permission
• sorting › sorts
  • by UPDATED_AT, newest first
  • by ALPHABETICAL_TITLE ignoring case
  • by WEAPON_POOL, kits of a pool weapon counting as it and builds without pool weapons last
  • by WEAPON_IN_GAME_ORDER using the build's lowest weapon id
  • by MODE in mode order, builds without modes last
  • by TOP_500
  • by HEADGEAR_ID, builds without one last
  • by $sort× 2
  • by weapon pool, then newest first, when the user hasn't chosen
• sorting › breaks ties with the next sort

Loaders/u/:identifier/builds

Scriptsscripts/benchmark-db/cases.ts

function

countsByUserId

:534

How many builds the user has, how many of them are private and the count per (exact) weapon id.

export async function countsByUserId(
	userId: number,
	{ showPrivate }: { showPrivate: boolean },
)

TablesBuildBuildWeapon

Unit tests (2)

• counts the builds, private ones and builds per exact weapon id
• leaves private builds out unless asked to show them

Loaders/u/:identifier/builds

Scriptsscripts/benchmark-db/cases.ts

function

countAllPublicByWeaponId

:570

Public build count per canonical weapon id (alt skins folded), weapons without builds omitted.

export async function countAllPublicByWeaponId()

TablesBuildWeapon

Unit tests (2)

• counts public builds per weapon with alt skins folded
• excludes private builds

Scriptsscripts/benchmark-db/cases.ts

Otherbuilds/public-build-counts.server.ts

function

recalculateAllSortValues

:585

Recomputes BuildWeapon.sortValue (plus tier + per-weapon top500), for one user's builds if given.

export async function recalculateAllSortValues(
	userId?: number,
	trx?: Transaction<DB>,
)

TablesBuildBuildWeaponPlusTierSplatoonPlayerXRankPlacement

Repositoriesadmin/AdminRepository.server.ts

Scriptsscripts/placements/index.ts

Otherapp/db/XRankPlacementFactory.ts

Unit tests not about one export (16)

• BuildRepository.insert — computeBuildData › abilitiesSignature
  • & ability sums › writes the serialized abilitiesSignature sorted by AP desc
  • & ability sums › inserts one BuildAbilitySum row per distinct ability with summed AP
  • & ability sums › agrees with the analyzer's AP calculation for Ability Doubler builds
  • & ability sums › does not insert BuildAbilitySum rows for private builds
  • & ability sums › still writes abilitiesSignature for private builds
• BuildRepository.insert — computeBuildData › BuildWeaponAbility
  • rows › inserts one row per weapon × ability for public builds
  • rows › folds alt skins to their canonical weapon id
  • rows › does not insert any rows for private builds
• BuildRepository.insert — computeBuildData › BuildWeapon.canonicalWeaponSplId › stores the canonical id alongside the original weaponSplId
• BuildRepository.insert — computeBuildData › sortValue
  • › defaults to tier 4 (sortValue = 9) when owner has no PlusTier
  • › uses owner's PlusTier (tier 2 → sortValue = 5)
  • › is null for private builds regardless of tier
  • › subtracts 1 when the weapon is top500 for the owner
  • › combines top500 with the owner's PlusTier
• BuildRepository.insert — computeBuildData › findPageByWeaponId.weapons[].isTop500 matches the sortValue formula
• BuildRepository.insert — computeBuildData › a multi-weapon build is returned by findPageByWeaponId for each of its weapons

Not shown, only used by tests: BuildListFilters