Item and quest database: a Summer App for game teams

{
  "name": "Game database",
  "purpose": "Every item and quest in the game. They live in this app's shared data.",
  "permissions": ["data"],
  "collections": {
    "items": {
      "description": "One item. The record id is the item id the game uses.",
      "fields": {
        "name": { "type": "string", "required": true },
        "type": { "type": "string", "description": "weapon, armour, consumable, material or quest" },
        "rarity": { "type": "string", "description": "common, rare, epic or legendary" },
        "price": { "type": "integer", "description": "Shop price in gold" },
        "description": { "type": "string" }
      }
    },
    "quests": {
      "description": "One quest. The record id is the quest id the game uses.",
      "fields": {
        "title": { "type": "string", "required": true },
        "giver": { "type": "string", "description": "The NPC who gives it" },
        "region": { "type": "string" },
        "minLevel": { "type": "integer" },
        "status": { "type": "string", "description": "draft, review or done" },
        "rewardGold": { "type": "integer" },
        "rewardItems": { "type": "array", "description": "Item record ids" },
        "steps": { "type": "array", "description": "The steps, as text, in order" }
      }
    }
  },
  "agentEvents": ["record.saved"],
  "agentTools": [
    {
      "name": "check_references",
      "description": "List quests whose rewardItems name an item that does not exist, and items no quest rewards.",
      "input": { "type": "object", "properties": {} }
    }
  ]
}

{
  "appId": "<app id>",
  "as": "seed",
  "ops": [
    { "op": "put", "collection": "items", "recordId": "iron-sword", "data": { "name": "Iron Sword", "type": "weapon", "rarity": "common", "price": 100, "description": "A plain, honest blade." } },
    { "op": "put", "collection": "items", "recordId": "moss-cloak", "data": { "name": "Moss Cloak", "type": "armour", "rarity": "rare", "price": 340, "description": "Quiet in the forest." } },
    { "op": "put", "collection": "items", "recordId": "healing-draught", "data": { "name": "Healing Draught", "type": "consumable", "rarity": "common", "price": 25, "description": "Restores 50 health." } },
    { "op": "put", "collection": "items", "recordId": "drowned-bell", "data": { "name": "Drowned Bell", "type": "quest", "rarity": "epic", "price": 0, "description": "It still rings under water." } },
    { "op": "put", "collection": "quests", "recordId": "the-drowned-bell", "data": { "title": "The Drowned Bell", "giver": "Old Maren", "region": "Mossbank", "minLevel": 4, "status": "review", "rewardGold": 450, "rewardItems": ["moss-cloak"], "steps": ["Find the bell in the flooded chapel", "Ring it three times", "Return to Old Maren"] } },
    { "op": "put", "collection": "quests", "recordId": "supplies-for-the-ferry", "data": { "title": "Supplies for the Ferry", "giver": "Tobin", "region": "Mossbank", "minLevel": 2, "status": "draft", "rewardGold": 120, "rewardItems": ["healing-draught", "rope"], "steps": ["Bring Tobin five planks", "Bring Tobin a rope"] } }
  ]
}

{ "appId": "<app id>", "collection": "items" }

{
  "appId": "<app id>",
  "ops": [
    { "op": "patch", "collection": "items", "recordId": "iron-sword", "patch": { "price": 120 }, "ifRevision": 1 },
    { "op": "put", "collection": "items", "recordId": "rope", "data": { "name": "Rope", "type": "material", "rarity": "common", "price": 5, "description": "Ten metres of hemp." }, "ifRevision": 0 }
  ]
}

async function brokenReferences() {
  const [items, quests] = await Promise.all([
    summer.data.collection("items").list({ limit: 500 }),
    summer.data.collection("quests").list({ limit: 500 }),
  ]);
  const ids = new Set(items.records.map((r) => r.recordId));
  const rewarded = new Set();
  const broken = [];
  for (const q of quests.records) {
    for (const id of q.data.rewardItems ?? []) {
      rewarded.add(id);
      if (!ids.has(id)) broken.push({ quest: q.recordId, item: id });
    }
  }
  return { broken, unused: [...ids].filter((id) => !rewarded.has(id)) };
}
summer.agent.tool("check_references", () => brokenReferences());