src/server/shopEquipment.ts

   1 import { db } from './lib/db';
   2 import {ShopEquipment} from '../shared/inventory';
   3
   4 export function listShopItems(where: Partial<ShopEquipment>): Promise<ShopEquipment[]> {
   5   return db.select('*').from<ShopEquipment>('shop_equipment')
   6         .where(where)
   7         .orderBy('type')
   8         .orderBy('equipment_slot')
   9         .orderByRaw(`requirements->>'level' asc`);
  10 }
  11
  12 export function getShopEquipment(item_id: number, location_id: number): Promise<ShopEquipment> {
  13   return db.select('*').from<ShopEquipment>('shop_equipment').where({
  14     id: item_id,
  15     location_id
  16   }).first();
  17
  18 }
  19
  20 export function getShopItem(id: number): Promise<ShopEquipment> {
  21   return db.select('*').from<ShopEquipment>('shop_equipment').where({
  22     id
  23   }).first();
  24 }