import type { LoadManyCallback, LoadOneCallback, Maybe } from 'grafast'; export type ItemType = 'Equipment' | 'Consumable' | 'UtilityItem' | 'MiscItem'; export type ItemSpec = `${ItemType}:${number}`; export type LocationType = 'BetaLocation' | 'SafeRoom' | 'Club' | 'Stairwell'; export type LootTier = 'Bronze' | 'Silver' | 'Gold'; export type LootCategory = 'Adventurer' | 'Boss' | 'Fan' | 'Quest'; export interface CrawlerData { id: number; species: 'Human' | 'Cat' | 'Crocodilian'; name: string; items?: ItemSpec[]; favouriteItem?: ItemSpec; friends?: number[]; bestFriend?: number; crawlerNumber?: number; deleted?: true; } export interface NpcData { id: number; type: 'Manager' | 'Security' | 'Guide' | 'Staff'; species: 'Changeling' | 'Rock Monster' | 'Half Elf' | 'Gondii' | 'Bopca Protector'; name: string; exCrawler?: boolean; client?: number; clients?: number[]; items?: ItemSpec[]; friends?: number[]; bestFriend?: number; } export interface ItemData { id: number; name: string; creator?: number; contents?: ItemSpec[]; type?: string; } export interface EquipmentData extends ItemData { currentDurability?: number; maxDurability: number; contents?: ItemSpec[]; } export interface ConsumableData extends ItemData { effect?: string; contents?: ItemSpec[]; } export interface UtilityItemData extends ItemData { contents?: ItemSpec[]; } export interface MiscItemData extends ItemData {} export interface LootBoxData { id: number; tier: LootTier; category: LootCategory; } export interface LootDataData { id: number; itemType: ItemType; itemId: number; lootBoxId: number; percentageChance: number; } export interface LocationData { id: number; name: string; type: LocationType; floors: number[]; } export interface SafeRoomData { id: number; hasPersonalSpace?: true; manager?: number; stock?: ItemSpec[]; } export interface ClubData { id: number; manager?: number; security?: number[]; tagline: string; stock?: ItemSpec[]; } export interface StairwellData { id: number; } export interface BetaLocationData { id: number; } export interface FloorData { number: number; } export interface Database { crawlers: readonly CrawlerData[]; npcs: readonly NpcData[]; equipment: readonly EquipmentData[]; consumables: readonly ConsumableData[]; utilityItems: readonly UtilityItemData[]; miscItems: readonly MiscItemData[]; lootBoxes: readonly LootBoxData[]; lootData: readonly LootDataData[]; locations: readonly LocationData[]; saferooms: readonly SafeRoomData[]; stairwells: readonly StairwellData[]; betaLocations: readonly BetaLocationData[]; clubs: readonly ClubData[]; } export function makeDb(): Database { return { crawlers: [ { id: 101, species: 'Human', name: 'Carl', items: [ 'Consumable:205', 'Equipment:211', 'Consumable:206', 'UtilityItem:206', 'Equipment:201', 'Equipment:202', 'Equipment:203', 'Consumable:201', 'UtilityItem:202', 'Consumable:203', 'Consumable:204', ], favouriteItem: 'Equipment:211', friends: [102, 103, 104, 105, 301], bestFriend: 102, crawlerNumber: 4122, }, { id: 102, species: 'Cat', name: 'Princess Donut', items: [ 'Equipment:204', 'Equipment:206', 'Consumable:201', 'UtilityItem:202', 'Consumable:203', 'Consumable:204', 'Consumable:205', ], favouriteItem: 'Equipment:205' /* Favourite item is not in inventory */, friends: [101, 103, 104, 105, 301, 302, 303], bestFriend: 101, crawlerNumber: 4119, }, { id: 103, species: 'Human', name: 'Katia', items: ['Equipment:207', 'Consumable:203', 'Consumable:204', 'Equipment:210'], favouriteItem: 'Equipment:210' /* Favourite item has a creator */, friends: [101, 102], bestFriend: 107 /* Best friend is deleted */, crawlerNumber: 9077265, }, { id: 104, species: 'Human', name: 'Imani', items: [ 'Equipment:208', 'Equipment:209', 'Consumable:204', 'UtilityItem:202', 'Consumable:203', ], friends: [101, 102, 105], }, { id: 105, species: 'Human', name: 'Elle', items: ['UtilityItem:202', 'Consumable:203'], friends: [101, 102, 104], }, { id: 106, species: 'Crocodilian', name: 'Dolores', items: ['Consumable:205'], }, { id: 107, species: 'Human', name: 'Hekla', deleted: true }, ], npcs: [ { id: 301, type: 'Manager', species: 'Changeling', name: 'Mordecai', exCrawler: true, client: 102, items: ['Consumable:203', 'Consumable:203', 'Consumable:203'], friends: [101, 102, 103, 306], }, { id: 302, type: 'Security', species: 'Rock Monster', name: 'Bomo', friends: [102, 303], clients: [101, 102, 103], bestFriend: 303, }, { id: 303, type: 'Security', species: 'Rock Monster', name: 'Sledge', friends: [102, 302], clients: [101, 102, 103], bestFriend: 302, }, { id: 304, type: 'Manager', species: 'Half Elf', name: 'Tiatha', exCrawler: true, client: 105, }, { id: 305, type: 'Staff', species: 'Gondii', name: 'Orren', }, { /* Has an item of Equipment type, which isn't allowed in SaferoomStock type */ id: 306, type: 'Staff', species: 'Bopca Protector', name: 'Tally', friends: [102, 301], items: ['UtilityItem:202', 'Equipment:208'], }, { id: 307, type: 'Security', species: 'Rock Monster', name: 'Clay-ton', clients: [105], }, ], equipment: [ { id: 201, name: 'Cloak of Stoutness', currentDurability: 300, maxDurability: 300, }, { id: 202, name: 'Toe Ring of the Splatter Skunk', currentDurability: 50, maxDurability: 1000, }, { id: 203, name: 'Enchanted War Gauntlet', currentDurability: 50, maxDurability: 1800, }, { id: 204, name: 'Enchanted Crown', maxDurability: 5000 }, { id: 205, name: 'Enchanted Tiara of Mana', currentDurability: 0, maxDurability: 2500, }, { id: 206, name: 'Enchanted Anklet', maxDurability: 100 }, { id: 207, name: 'Enchanted Repeating Crossbow', currentDurability: 1500, maxDurability: 3000, }, { id: 208, name: 'Longsword', currentDurability: 10000, maxDurability: 10000, }, { id: 209, name: 'Enchanted Cloak', currentDurability: 70, maxDurability: 400, }, { /* This item can have an inventory */ id: 210, name: 'Ugly Backpack With a Completely Useless Design', creator: 101, currentDurability: 100, maxDurability: 100, contents: [ 'MiscItem:201', 'MiscItem:201', 'MiscItem:202', 'MiscItem:202', 'MiscItem:203', 'MiscItem:203', ], }, { id: 211, name: "Enchanted Anarchist's Battle Rattle", maxDurability: 10000, currentDurability: 10000, contents: ['Equipment:212', 'Equipment:213'], }, { id: 212, name: 'Earth Upgrade Patch', maxDurability: 10000 }, { id: 213, name: 'Skyfowl Upgrade Patch', maxDurability: 10000 }, ], consumables: [ { id: 201, name: 'Rev-Up Immunity Smoothie', effect: 'Temporary immunity to all health-seeping conditions and debuffs', }, { id: 203, name: 'Mana Potion', effect: 'Fully restores MP', }, { id: 204, name: 'Healing Potion', effect: 'Heal 50%+ total health', }, { id: 205, name: "Dolores Doesn't Splat Potion", creator: 106, effect: 'Soften impact surface. Impact x 5', contents: ['Consumable:207', 'Consumable:208'], }, { id: 206, name: "Carl's Jug O' Boom", creator: 101, effect: 'Intense Fire for (Incendiary Device Handling Skill Level x 15) sec.', contents: ['Consumable:209', 'MiscItem:204', 'MiscItem:205'], }, { id: 207, name: 'Crowd Blast Potion', effect: 'Imitates the Crowd Blast skill', }, { id: 208, name: 'Rock Buffalo Potion', effect: "A required component of Dolores Doesn't Splat Potion", }, { id: 209, name: 'Goblin Oil', effect: 'Has many uses', }, ], utilityItems: [ { id: 202, name: 'Bandage' }, { id: 206, name: 'Fireball or Custard? Scratchcard', }, ], miscItems: [ { id: 201, name: 'Scrap Metal', }, { id: 202, name: 'Scrap Metal Pole', }, { id: 203, name: 'Metal Bearing', }, { id: 204, name: 'Low-Grade Moonshine Jug', }, { id: 205, name: 'Torch', }, ], lootBoxes: [ { id: 501, tier: 'Bronze', category: 'Adventurer' }, { id: 502, tier: 'Bronze', category: 'Quest' }, { id: 503, tier: 'Silver', category: 'Adventurer' }, { id: 504, tier: 'Silver', category: 'Boss' }, { id: 505, tier: 'Gold', category: 'Fan' }, { id: 506, tier: 'Gold', category: 'Quest' }, ], lootData: [ { id: 101, itemType: 'Equipment', itemId: 201, lootBoxId: 501, percentageChance: 50, }, { id: 102, itemType: 'Equipment', itemId: 202, lootBoxId: 503, percentageChance: 10, }, { id: 103, itemType: 'Equipment', itemId: 203, lootBoxId: 503, percentageChance: 10, }, { id: 104, itemType: 'Equipment', itemId: 204, lootBoxId: 505, percentageChance: 50, }, { id: 105, itemType: 'Equipment', itemId: 205, lootBoxId: 505, percentageChance: 50, }, { id: 201, itemType: 'Consumable', itemId: 203, lootBoxId: 501, percentageChance: 100, }, { id: 202, itemType: 'Consumable', itemId: 203, lootBoxId: 502, percentageChance: 100, }, { id: 203, itemType: 'Consumable', itemId: 203, lootBoxId: 503, percentageChance: 100, }, { id: 204, itemType: 'Consumable', itemId: 203, lootBoxId: 504, percentageChance: 100, }, ], locations: [ { id: 100, type: 'BetaLocation', name: 'Alleyway', floors: [1] }, { id: 101, type: 'SafeRoom', name: 'Peruvian Taco Bell', floors: [1, 2] }, { id: 102, type: 'SafeRoom', name: 'DMV waiting room', floors: [1, 2] }, { id: 103, type: 'Club', name: 'Tutorial Guild', floors: [1, 2] }, { id: 104, type: 'Stairwell', name: 'Stairwell 1-1', floors: [1] }, { id: 105, type: 'Stairwell', name: 'Stairwell 1-2', floors: [1] }, { id: 201, type: 'SafeRoom', name: 'French storm shelter', floors: [2, 3], }, { id: 204, type: 'Stairwell', name: 'Stairwell 2-1', floors: [2] }, { id: 205, type: 'Stairwell', name: 'Stairwell 2-2', floors: [2] }, { id: 206, type: 'Stairwell', name: 'Stairwell 2-3', floors: [2] }, { id: 301, type: 'Club', name: 'Desperado Club', floors: [3, 4, 5] }, { id: 302, type: 'Club', name: 'Club Vanquisher', floors: [3, 4, 5] }, { id: 303, type: 'Stairwell', name: 'Stairwell 3-1', floors: [3] }, { id: 304, type: 'Stairwell', name: 'Stairwell 3-2', floors: [3] }, { id: 401, type: 'Stairwell', name: 'Stairwell 4-1', floors: [4] }, { id: 402, type: 'Stairwell', name: 'Stairwell 4-2', floors: [4] }, { id: 501, type: 'Stairwell', name: 'Stairwell 5-1', floors: [5] }, ], saferooms: [ { id: 101, hasPersonalSpace: true, stock: ['Consumable:203', 'Consumable:204', 'MiscItem:205'], manager: 306, }, { id: 102, }, { id: 201, }, { /* An orphaned saferoom sharing the id of a club */ id: 301, hasPersonalSpace: true, stock: ['Consumable:203', 'Consumable:204'], }, ], clubs: [ { id: 103, manager: 301, tagline: 'Crawlers are recommended to join, but not required', stock: ['Consumable:203', 'Consumable:204', 'UtilityItem:202'], }, { id: 301, manager: 305, security: [302, 303], tagline: 'So fun it hurts', stock: ['Consumable:203', 'Consumable:204', 'Consumable:209', 'UtilityItem:206'], }, { id: 302, tagline: 'Heathens will find no solace here', stock: ['UtilityItem:202'], security: [307], }, ], stairwells: [ { id: 104 }, { id: 105 }, { id: 204 }, { id: 205 }, { id: 206 }, { id: 303 }, { id: 304 }, { id: 401 }, { id: 402 }, { id: 501 }, ], /* A Location type without a field plan, which should return null */ betaLocations: [{ id: 100 }], }; } export const batchGetCrawlerById: LoadOneCallback< number, CrawlerData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.crawlers.find((c) => c.id === id)); }; export const batchGetCrawlersByIds: LoadManyCallback< number[], CrawlerData, Maybe[]>, never, Database > = (idsList, { unary: data }) => { return idsList.map((ids) => ids.map((id) => data.crawlers.find((c) => c.id === id))); }; export const batchGetNpcById: LoadOneCallback, never, Database> = ( ids, { unary: data }, ) => { return ids.map((id) => data.npcs.find((c) => c.id === id)); }; export const batchGetNpcsByIds: LoadManyCallback< number[], NpcData, Maybe[]>, never, Database > = (idsList, { unary: data }) => { return idsList.map((ids) => ids.map((id) => data.npcs.find((c) => c.id === id))); }; export const batchGetEquipmentById: LoadOneCallback< number, EquipmentData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.equipment.find((c) => c.id === id)); }; export const batchGetConsumableById: LoadOneCallback< number, ConsumableData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.consumables.find((c) => c.id === id)); }; export const batchGetUtilityItemById: LoadOneCallback< number, UtilityItemData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.utilityItems.find((c) => c.id === id)); }; export const batchGetMiscItemById: LoadOneCallback< number, MiscItemData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.miscItems.find((c) => c.id === id)); }; export const batchGetLocationsByFloorNumber: LoadManyCallback< number, LocationData, Maybe[]>, never, Database > = (floorNumberList, { unary: data }) => { return floorNumberList.map((floorNumber) => data.locations.filter((c) => c.floors.includes(floorNumber)), ); }; export const batchGetLocationById: LoadOneCallback< number, LocationData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.locations.find((c) => c.id === id)); }; export const batchGetSafeRoomById: LoadOneCallback< number, SafeRoomData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.saferooms.find((c) => c.id === id)); }; export const batchGetClubById: LoadOneCallback< number, ClubData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.clubs.find((c) => c.id === id)); }; export const batchGetStairwellById: LoadOneCallback< number, StairwellData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.stairwells.find((c) => c.id === id)); }; export const batchGetBetaLocationById: LoadOneCallback< number, BetaLocationData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.betaLocations.find((c) => c.id === id)); }; export const batchGetLootDataByItemTypeAndId: LoadManyCallback< readonly [string, number], LootDataData, Maybe[]>, never, Database > = (identifiersList, { shared: data }) => { return identifiersList.map(([type, id]) => data.lootData.filter((c) => c.itemType === type && c.itemId === id), ); }; export const batchGetLootDataByLootBoxId: LoadManyCallback< number, LootDataData, Maybe[]>, never, Database > = (identifiersList, { shared: data }) => { return identifiersList.map((id) => data.lootData.filter((c) => c.lootBoxId === id)); }; export const batchGetLootBoxById: LoadOneCallback< number, LootBoxData, Maybe, never, Database > = (ids, { unary: data }) => { return ids.map((id) => data.lootBoxes.find((c) => c.id === id)); };