1 import {db} from "./lib/db";
2 import {EquippedItemDetails} from "../shared/equipped";
3 import {EquipmentSlot, InventoryItem} from "../shared/inventory";
5 export async function getEquippedItems(playerId: string): Promise<EquippedItemDetails[]> {
6 return db.raw<EquippedItemDetails[]>(`
19 e.item_id is not null as is_equipped
21 join equipped e on e.item_id = i.item_id
28 export async function equip(player_id: string, item: InventoryItem, desiredSlot: EquipmentSlot) {
29 return db('equipped').insert({
31 item_id: item.item_id,
33 equipment_slot: desiredSlot
37 export async function unequip(player_id: string, item_id: string) {
38 return db('equipped').where({
44 export async function unequipItems(player_id: string, item_ids: string[]) {
45 return db('equipped').where({
47 }).whereIn('item_id', item_ids).delete();