import { DatabaseSync } from "node:sqlite"; import { fileURLToPath } from "node:url"; import { dirname, join } from "node:path"; import { insertStack } from "../../shared/items/inventory.js"; import { ItemId, itemDefinition } from "../../shared/definitions/items.js"; const root = dirname(fileURLToPath(import.meta.url)); const dbPath = join(root, "../data/state.sqlite"); const db = new DatabaseSync(dbPath); const char = db.prepare(` SELECT character_id, first_name, last_name FROM characters WHERE first_normalized = ? AND last_normalized = ? `).get("tim", "falken"); if (!char) { throw new Error("character not found"); } const row = db.prepare("SELECT inventory_blob FROM character_bags WHERE character_id = ?") .get(char.character_id); if (!row) { throw new Error("no bag row"); } const slots = JSON.parse(row.inventory_blob || "[]"); const def = itemDefinition(ItemId.glassBottle); const result = insertStack(slots, { itemId: ItemId.glassBottle, quantity: 20 }, def); if (!result.ok || result.remainder > 0) { throw new Error(`inventory full / remainder ${result.remainder}`); } db.prepare("UPDATE character_bags SET inventory_blob = ? WHERE character_id = ?") .run(JSON.stringify(result.slots), char.character_id); console.log(`granted 20 glass bottles to ${char.first_name} ${char.last_name} (id=${char.character_id})`);