1 import { db } from './lib/db';
2 import {ShopItem} from '../shared/inventory';
4 export function listShopItems(where: Partial<ShopItem>): Promise<ShopItem[]> {
5 return db.select('*').from<ShopItem>('shop_items')
8 .orderBy('equipment_slot')
9 .orderByRaw(`requirements->>'level' asc`);
12 export function getShopItem(id: number): Promise<ShopItem> {
13 return db.select('*').from<ShopItem>('shop_items').where({