[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_529":530,"_531":532},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":54,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",302,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"deleted",false,"deletedHere","path","dashboard/frontend/index.html","latestPath","fileId","f6ad82ea-ff01-11f0-bf3a-42dde27851f2","name","index.html","fileType","content","\n\n \n \n \n \n \n \n Logbook\n\n \n \n\n \n \n\n \n \n \n \n

\n\n \n \n \n","\n\n \n \n \n \n \n \n Logbook\n\n \n \n\n \n \n\n \n \n \n \n

\n\n \n \n \n","createdAt",["D",1771225901891],"branchVersion","branchId","7d9e159a-f682-11f0-8e20-42dde27851f2","id","7d9ddce2-f682-11f0-8e20-42dde27851f2","Bilbo-The-Butler",["D",1768970076214],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/a16b1514-f142-4542-9055-1dbb3a84d800/square512?exp=1789588619&sig=9d20f2dc21673f4ae901f2a11bcda3467e178d28927db9b8dfc9054ad24d1d59","019bcfa3-cdfc-70ea-9450-feb48ee938e5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019bcfa3-cdfc-70ea-9451-0150afac3039","tursoName","7d9ddce2f68211f08e2042dde27851f2","tursoHostname","7d9ddce2f68211f08e2042dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789532458193],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",415,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","emdu_07","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOFB4bUFwaHpVUVhxVUM2Z3ZTN3lEMFRzNGQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":524,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":54,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":525,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":526,"_82":527,"_84":528,"_86":25},"tree",[234,240,256,261,265,266,267,268,269,270,271],"files",[234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271],"counts",{"_223":61,"_224":183,"_225":61,"_226":227,"_228":229},"contents",[129,130,131,132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":217,"_32":218,"_30":219,"_143":-5,"_41":42,"_40":220,"_145":124,"_38":221,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_27":222},{"_43":212,"_32":213,"_30":214,"_143":-5,"_41":42,"_40":147,"_145":124,"_38":215,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_27":216},{"_43":206,"_32":207,"_30":208,"_143":-5,"_41":42,"_40":209,"_145":124,"_38":210,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_27":211},{"_43":200,"_32":201,"_30":202,"_143":-5,"_41":42,"_40":183,"_145":124,"_38":203,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_27":205},{"_43":193,"_32":194,"_30":195,"_143":-5,"_41":42,"_40":196,"_145":124,"_38":197,"_13":61,"_34":20,"_35":198,"_24":25,"_150":-5,"_27":199},{"_43":186,"_32":187,"_30":188,"_143":-5,"_41":42,"_40":189,"_145":124,"_38":190,"_13":61,"_34":20,"_35":191,"_24":25,"_150":-5,"_27":192},{"_43":178,"_32":179,"_30":180,"_143":-5,"_41":42,"_40":181,"_145":124,"_38":182,"_13":183,"_34":148,"_35":184,"_24":25,"_150":-5,"_27":185},{"_43":171,"_32":172,"_30":173,"_143":-5,"_41":42,"_40":174,"_145":124,"_38":175,"_13":61,"_34":20,"_35":176,"_24":25,"_150":-5,"_27":177},{"_43":162,"_32":163,"_30":164,"_143":-5,"_41":42,"_40":165,"_145":25,"_38":166,"_13":167,"_34":158,"_35":168,"_24":25,"_150":169,"_27":170},{"_43":152,"_32":153,"_30":154,"_143":-5,"_41":42,"_40":155,"_145":25,"_38":156,"_13":157,"_34":158,"_35":159,"_24":25,"_150":160,"_27":161},{"_43":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":124,"_38":146,"_13":147,"_34":148,"_35":149,"_24":25,"_150":-5,"_27":151},"2862b03e-f6f7-11f0-9af6-42dde27851f2","memoryUtils.js","243b0f9c-f6f7-11f0-89a8-42dde27851f2","parentId",119,"latest",["D",1769020184327],2,"script","import { DateTime } from \"https://esm.sh/luxon@3.4.4\";\n\nconst LOCAL_TIMEZONE = \"America/Toronto\";\n\n/**\n * Retrieves all memories from the database\n * @param {boolean} includeDate Whether to include date-specific memories or not\n * @param {string|null} startDate Optional start date (ISO yyyy-MM-dd) to filter a 7-day window\n * @returns {Promise>}\n */\nexport async function getAllMemories(includeDate = true, startDate = null) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n let memories = [];\n\n // Get memories with dates if requested\n if (includeDate) {\n const dateQuery = startDate\n ? {\n sql: `\n SELECT id, date(date) AS date, text\n FROM memories\n WHERE date >= :startDate\n AND date <= date(:startDate, '+7 days')\n ORDER BY date ASC\n `,\n args: { startDate },\n }\n : `\n SELECT id, date(date) AS date, text\n FROM memories\n WHERE date IS NOT NULL\n ORDER BY date ASC\n `;\n\n const dateMemories = await sqlite.execute(dateQuery);\n memories = dateMemories?.rows ?? [];\n }\n\n // Always get dateless memories\n const datelessMemories = await sqlite.execute(`\n SELECT id, date, text\n FROM memories\n WHERE date IS NULL\n `);\n\n return [...memories, ...(datelessMemories?.rows ?? [])];\n } catch (error) {\n console.error(\"Error retrieving memories:\", error);\n return [];\n }\n}\n\n/**\n * Gets memories relevant to today and future dates (7-day window)\n * @returns {Promise>}\n */\nexport async function getRelevantMemories() {\n try {\n const today = DateTime.now().setZone(LOCAL_TIMEZONE).startOf(\"day\");\n const todayFormatted = today.toFormat(\"yyyy-MM-dd\");\n return await getAllMemories(true, todayFormatted);\n } catch (error) {\n console.error(\"Error getting relevant memories:\", error);\n return [];\n }\n}\n\n/**\n * Formats memories into a string for the system prompt\n * @param {Array<{id: string, date: string|null, text: string}>} memories\n * @returns {string}\n */\nexport function formatMemoriesForPrompt(memories) {\n if (!Array.isArray(memories) || memories.length === 0) {\n return \"No stored memories are available.\";\n }\n\n const datedMemories = memories\n .filter((m) => m.date)\n .map((m) => {\n const date = DateTime.fromISO(m.date);\n return `- ${date.toFormat(\"yyyy-MM-dd\")} [ID: ${m.id}]: ${m.text}`;\n });\n\n const datelessMemories = memories\n .filter((m) => !m.date)\n .map((m) => `- [ID: ${m.id}]: ${m.text}`);\n\n let result = \"\";\n\n if (datedMemories.length > 0) {\n result += `Dated memories:\\n${datedMemories.join(\"\\n\")}\\n\\n`;\n }\n\n if (datelessMemories.length > 0) {\n result += `General memories:\\n${datelessMemories.join(\"\\n\")}`;\n }\n\n return result.trim();\n}","label",[141],"3b2be92c-f753-11f0-9c78-42dde27851f2","discordWorker.js","908016ea-f6f5-11f0-bccc-42dde27851f2",144,["D",1769059729545],11,"http","// discordWorker.js\nimport Anthropic from \"npm:@anthropic-ai/sdk@0.24.3\";\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { DateTime } from \"https://esm.sh/luxon@3.4.4\";\n\nimport { backstory } from \"./backstory.js\";\nimport {\n formatMemoriesForPrompt,\n getRelevantMemories,\n} from \"./memoryUtils.js\";\n\nconst BOT_SENDER_ID = \"mr_bilbo_bot\";\nconst BOT_SENDER_NAME = \"Mr. Bilbo\";\n\nconst LOCAL_TIMEZONE = \"America/Toronto\"; // Waterloo, Ontario\n\nfunction getConversationId({ guildId, channelId, userId }) {\n // DMs: stable by user; Servers/threads: by channel\n if (!guildId) return `dm:${userId}`;\n return `chan:${channelId}`;\n}\n\nasync function discordSendMessage(channelId, content) {\n const token = Deno.env.get(\"DISCORD_BOT_TOKEN\");\n if (!token) throw new Error(\"DISCORD_BOT_TOKEN is not set\");\n\n const body = { content: String(content || \"\").slice(0, 1900) };\n\n const resp = await fetch(\n `https://discord.com/api/v10/channels/${channelId}/messages`,\n {\n method: \"POST\",\n headers: {\n authorization: `Bot ${token}`,\n \"content-type\": \"application/json\",\n },\n body: JSON.stringify(body),\n },\n );\n\n if (!resp.ok) {\n const text = await resp.text();\n throw new Error(`Discord send failed (${resp.status}): ${text}`);\n }\n\n return await resp.json();\n}\n\nasync function storeChatMessage(\n conversationId,\n channelId,\n guildId,\n senderId,\n senderName,\n message,\n isBot = false,\n) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const timestamp = Math.floor(Date.now() / 1000);\n\n await sqlite.execute({\n sql: `\n INSERT INTO discord_chats (\n conversation_id, channel_id, guild_id,\n sender_id, sender_name, message, timestamp, is_bot\n ) VALUES (\n :conversation_id, :channel_id, :guild_id,\n :sender_id, :sender_name, :message, :timestamp, :is_bot\n )\n `,\n args: {\n conversation_id: conversationId,\n channel_id: String(channelId),\n guild_id: guildId ? String(guildId) : null,\n sender_id: String(senderId),\n sender_name: String(senderName),\n message: String(message),\n timestamp,\n is_bot: isBot ? 1 : 0,\n },\n });\n}\n\nasync function getChatHistory(conversationId, limit = 50) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const result = await sqlite.execute({\n sql: `\n SELECT * FROM discord_chats\n WHERE conversation_id = :conversation_id\n ORDER BY timestamp DESC\n LIMIT :limit\n `,\n args: { conversation_id: conversationId, limit },\n });\n\n return (result.rows || []).reverse();\n}\n\nfunction formatChatHistoryForAI(history) {\n return (history || []).map((msg) => {\n if (msg.is_bot) return { role: \"assistant\", content: msg.message };\n return { role: \"user\", content: `${msg.sender_name} says: ${msg.message}` };\n });\n}\n\nasync function analyze(anthropic, history) {\n const memories = await getRelevantMemories();\n const memoriesText = formatMemoriesForPrompt(memories);\n\n const todayStr = DateTime.now().setZone(LOCAL_TIMEZONE).toFormat(\n \"yyyy-MM-dd\",\n );\n\n const systemPrompt = `${backstory}\n\nYour job is to read this Discord message from your employer and respond in a natural, butler-like way, noting any important information that should be remembered for future reference.\n\nYou have access to the following stored memories:\n\n${memoriesText}\n\nYou have three options for managing memories:\n\n1. CREATE memories: Include them in tags in JSON format.\n2. EDIT memories: Include them in tags in JSON format (must include memory ID).\n3. DELETE memories: Include them in tags in JSON format (just include memory IDs).\n\nImportant guidelines:\n- Do not create duplicate memories.\n- For new memories, set a date whenever possible, otherwise null.\n- For edits/deletes, you MUST include the correct memory ID.\n\nYour response style:\n- 1-2 sentences, brief and polite\n- Slightly dignified but modern\n- Avoid contractions\n- Be deferential\n\nToday's date is ${todayStr}`;\n\n const resp = await anthropic.messages.create({\n model: \"claude-sonnet-4-5-20250929\",\n max_tokens: 1200,\n system: systemPrompt,\n messages: formatChatHistoryForAI(history),\n });\n\n const text = resp.content?.[0]?.text || \"\";\n\n const create = text.match(/([\\s\\S]*?)<\\/createMemories>/);\n const edit = text.match(/([\\s\\S]*?)<\\/editMemories>/);\n const del = text.match(/([\\s\\S]*?)<\\/deleteMemories>/);\n\n const cleaned = text\n .replace(/[\\s\\S]*?<\\/createMemories>/, \"\")\n .replace(/[\\s\\S]*?<\\/editMemories>/, \"\")\n .replace(/[\\s\\S]*?<\\/deleteMemories>/, \"\")\n .trim()\n .replace(/\\n{3,}/g, \"\\n\\n\");\n\n let toCreate = [];\n let toEdit = [];\n let toDelete = [];\n\n if (create) {\n try {\n toCreate = JSON.parse(create[1]);\n } catch (e) {\n console.error(\"create JSON parse:\", e);\n }\n }\n if (edit) {\n try {\n toEdit = JSON.parse(edit[1]);\n } catch (e) {\n console.error(\"edit JSON parse:\", e);\n }\n }\n if (del) {\n try {\n toDelete = JSON.parse(del[1]);\n } catch (e) {\n console.error(\"delete JSON parse:\", e);\n }\n }\n\n return { response: cleaned || \"Very good.\", toCreate, toEdit, toDelete };\n}\n\nasync function applyMemoryChanges({ toCreate, toEdit, toDelete }) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Create\n for (const m of toCreate || []) {\n await sqlite.execute({\n sql: `\n INSERT INTO memories (id, date, text, createdBy, createdDate, tags)\n VALUES (:id, :date, :text, :createdBy, :createdDate, :tags)\n `,\n args: {\n id: nanoid(10),\n date: m?.date ?? null,\n text: m?.text ?? \"\",\n createdBy: \"discord\",\n createdDate: Date.now(),\n tags: m?.tags ?? \"\",\n },\n });\n }\n\n // Edit\n for (const m of toEdit || []) {\n if (!m?.id) continue;\n\n const fields = [];\n const args = { id: m.id };\n\n if (m.text !== undefined) {\n fields.push(\"text = :text\");\n args.text = m.text;\n }\n if (m.date !== undefined) {\n fields.push(\"date = :date\");\n args.date = m.date;\n }\n if (m.tags !== undefined) {\n fields.push(\"tags = :tags\");\n args.tags = m.tags;\n }\n\n if (fields.length) {\n await sqlite.execute({\n sql: `UPDATE memories SET ${fields.join(\", \")} WHERE id = :id`,\n args,\n });\n }\n }\n\n // Delete\n for (const id of toDelete || []) {\n await sqlite.execute({\n sql: `DELETE FROM memories WHERE id = :id`,\n args: { id },\n });\n }\n}\n\nexport default async function (req) {\n // If you open this URL in a browser, it will be a GET with no JSON body.\n if (req.method !== \"POST\") {\n return new Response(\"ok\", { status: 200 });\n }\n\n let payload;\n try {\n payload = await req.json();\n } catch (e) {\n console.error(\"Invalid/empty JSON body:\", e);\n return new Response(\"Expected JSON body\", { status: 400 });\n }\n\n const channelId = payload.channelId;\n const guildId = payload.guildId || null;\n\n const userId = payload.userId;\n const username = payload.username || \"Sir/Madam\";\n const messageText = String(payload.messageText || \"\").trim();\n if (!channelId || !userId || !messageText) {\n console.error(\"Missing required fields:\", payload);\n return new Response(\"missing fields\", { status: 400 });\n }\n\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n if (!apiKey) throw new Error(\"ANTHROPIC_API_KEY is not set\");\n const anthropic = new Anthropic({ apiKey });\n\n const conversationId = getConversationId({ guildId, channelId, userId });\n\n // Store inbound\n await storeChatMessage(\n conversationId,\n channelId,\n guildId,\n userId,\n username,\n messageText,\n false,\n );\n\n // Load history + analyze\n const history = await getChatHistory(conversationId, 50);\n const analysis = await analyze(anthropic, history);\n\n // Apply memory changes\n await applyMemoryChanges(analysis);\n\n // Post response + store outbound\n await discordSendMessage(channelId, analysis.response);\n\n await storeChatMessage(\n conversationId,\n channelId,\n guildId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n analysis.response,\n true,\n );\n\n return new Response(\"ok\", { status: 200 });\n}","bilbo-butler-worker",[153],"4ddaf76a-f6fa-11f0-ba77-42dde27851f2","discordInteractions.js","86eb69b8-f6f5-11f0-8f13-42dde27851f2",127,["D",1769021535684],6,"import nacl from \"npm:tweetnacl@1.0.3\";\n\nconst WORKER_URL = \"https://bilbo-butler-worker.val.run/\";\n\nconst PUBLIC_KEY_HEX = Deno.env.get(\"discordPublicKey\");\nif (!PUBLIC_KEY_HEX) throw new Error(\"discordPublicKey is not set\");\n\nfunction hexToBytes(hex) {\n const out = new Uint8Array(hex.length / 2);\n for (let i = 0; i < out.length; i++) {\n out[i] = parseInt(hex.slice(i * 2, i * 2 + 2), 16);\n }\n return out;\n}\n\nasync function verifyDiscordRequest(req, rawBody) {\n const sigHex = req.headers.get(\"X-Signature-Ed25519\");\n const ts = req.headers.get(\"X-Signature-Timestamp\");\n if (!sigHex || !ts) return false;\n\n const msg = new TextEncoder().encode(ts + rawBody);\n return nacl.sign.detached.verify(\n msg,\n hexToBytes(sigHex),\n hexToBytes(PUBLIC_KEY_HEX),\n );\n}\n\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\"ok\", { status: 200 });\n }\n\n const rawBody = await req.text();\n\n if (!(await verifyDiscordRequest(req, rawBody))) {\n return new Response(\"invalid signature\", { status: 401 });\n }\n\n const interaction = JSON.parse(rawBody);\n\n // Discord PING -> PONG (required for endpoint verification)\n if (interaction.type === 1) {\n return Response.json({ type: 1 });\n }\n\n // Slash command invocation\n if (interaction.type === 2) {\n const name = interaction.data && interaction.data.name;\n\n // Only handle /chat\n if (name !== \"chat\") {\n return Response.json({ type: 4, data: { content: \"Unknown command.\" } });\n }\n\n const options = (interaction.data && interaction.data.options) || [];\n const messageOpt = options.find((o) => o && o.name === \"message\");\n const messageText =\n (messageOpt && messageOpt.value ? String(messageOpt.value) : \"\").trim();\n\n const channelId = interaction.channel_id;\n const guildId = interaction.guild_id || null;\n\n const user = (interaction.member && interaction.member.user) ||\n interaction.user;\n const userId = user && user.id;\n const username = (user && (user.global_name || user.username)) ||\n \"Sir/Madam\";\n\n // Kick off the long work (do not await)\n fetch(WORKER_URL, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ channelId, guildId, userId, username, messageText }),\n})\n .then(async (r) => {\n const t = await r.text();\n console.log(\"worker status:\", r.status, t.slice(0, 200));\n })\n .catch((e) => console.error(\"worker call failed:\", e));\n\n // In-channel acknowledgement (NOT ephemeral)\n return Response.json({\n type: 4,\n data: { content: \"Very good. I am attending to that now…\" },\n });\n }\n\n return Response.json({\n type: 4,\n data: { content: \"Unsupported interaction type.\" },\n });\n}","biblo-butler-interactions",[163],"5b5ad65c-f692-11f0-8387-42dde27851f2","deno.json","5b5ad74c-f692-11f0-8387-42dde27851f2",90,["D",1768976889400],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[172],"bad7260e-fbeb-11f0-b8e7-42dde27851f2","backstory.js","5aaba13c-f692-11f0-80a8-42dde27851f2",154,["D",1769565031884],1,"export const backstory = `\nYou are Bilbo, a dignified and professional butler that also happens to be a cat but can still talk human language fluently.\n\nYou've been appointed as a personal assistant, and you serve your client turned family, Emma, faithfully.\n\nYou can only perform digital tasks, and you are not able to perform any physical tasks, so don't offer.\nYour abilities are limited to messaging your client to remind them of things; you can't access websites or other tools.\n`;",[179],"5ac71a66-f692-11f0-bc77-42dde27851f2","AGENTS.md","5ac71b38-f692-11f0-bc77-42dde27851f2",82,["D",1768976889699],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[187],"5acbd178-f692-11f0-92bb-42dde27851f2",".vtignore","5acbd376-f692-11f0-92bb-42dde27851f2",83,["D",1768976889705],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[194],"7e97cc8e-f682-11f0-b864-42dde27851f2","importers","7e97cd56-f682-11f0-b864-42dde27851f2",["D",1768970077837],"directory",[201],"5a2d5584-f692-11f0-80a8-42dde27851f2","dbUtils","5a2d5660-f692-11f0-80a8-42dde27851f2",68,["D",1768976888702],[207],"7ea69688-f682-11f0-8450-42dde27851f2","dashboard","7ea69782-f682-11f0-8450-42dde27851f2",["D",1768970077944],[213],"5a4c33d2-f692-11f0-a8c3-42dde27851f2","dailyGreeting","5a4c347c-f692-11f0-a8c3-42dde27851f2",69,["D",1768976888903],[218],"pulls","branches","forks","envVars",{"_230":232,"_233":61},"connections",{"_230":61,"_231":61},"count","unfilledCount",7,"emptyCount",{"_43":217,"_32":218,"_30":219,"_143":-5,"_41":42,"_40":220,"_145":124,"_38":521,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":522,"_27":523},{"_43":512,"_32":513,"_30":514,"_143":219,"_41":42,"_40":515,"_145":124,"_38":516,"_13":517,"_34":508,"_35":518,"_24":25,"_150":-5,"_273":519,"_27":520},{"_43":503,"_32":504,"_30":505,"_143":219,"_41":42,"_40":506,"_145":25,"_38":507,"_13":354,"_34":508,"_35":509,"_24":25,"_150":-5,"_273":510,"_27":511},{"_43":494,"_32":495,"_30":496,"_143":219,"_41":42,"_40":497,"_145":25,"_38":498,"_13":499,"_34":148,"_35":500,"_24":25,"_150":-5,"_273":501,"_27":502},{"_43":486,"_32":487,"_30":488,"_143":219,"_41":42,"_40":489,"_145":124,"_38":490,"_13":183,"_34":148,"_35":491,"_24":25,"_150":-5,"_273":492,"_27":493},{"_43":477,"_32":478,"_30":479,"_143":219,"_41":42,"_40":480,"_145":25,"_38":481,"_13":482,"_34":148,"_35":483,"_24":25,"_150":-5,"_273":484,"_27":485},{"_43":212,"_32":213,"_30":214,"_143":-5,"_41":42,"_40":147,"_145":124,"_38":474,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":475,"_27":476},{"_43":469,"_32":453,"_30":447,"_143":214,"_41":42,"_40":470,"_145":124,"_38":471,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":472,"_27":473},{"_43":464,"_32":463,"_30":457,"_143":447,"_41":42,"_40":465,"_145":124,"_38":466,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":467,"_27":468},{"_43":454,"_32":455,"_30":456,"_143":457,"_41":42,"_40":458,"_145":124,"_38":459,"_13":147,"_34":148,"_35":460,"_24":25,"_150":-5,"_273":461,"_27":462},{"_43":444,"_32":445,"_30":446,"_143":447,"_41":42,"_40":448,"_145":124,"_38":449,"_13":414,"_34":158,"_35":450,"_24":25,"_150":-5,"_273":451,"_27":452},{"_43":439,"_32":371,"_30":364,"_143":214,"_41":42,"_40":440,"_145":124,"_38":441,"_13":183,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":442,"_27":443},{"_43":432,"_32":433,"_30":434,"_143":364,"_41":42,"_40":435,"_145":124,"_38":436,"_13":183,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":437,"_27":438},{"_43":427,"_32":418,"_30":411,"_143":364,"_41":42,"_40":428,"_145":124,"_38":429,"_13":183,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":430,"_27":431},{"_43":419,"_32":420,"_30":421,"_143":411,"_41":42,"_40":422,"_145":25,"_38":423,"_13":299,"_34":148,"_35":424,"_24":25,"_150":-5,"_273":425,"_27":426},{"_43":408,"_32":409,"_30":410,"_143":411,"_41":42,"_40":412,"_145":25,"_38":413,"_13":414,"_34":148,"_35":415,"_24":25,"_150":-5,"_273":416,"_27":417},{"_43":403,"_32":402,"_30":396,"_143":364,"_41":42,"_40":404,"_145":124,"_38":405,"_13":183,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":406,"_27":407},{"_43":393,"_32":394,"_30":395,"_143":396,"_41":42,"_40":397,"_145":25,"_38":398,"_13":147,"_34":148,"_35":399,"_24":25,"_150":-5,"_273":400,"_27":401},{"_43":385,"_32":386,"_30":387,"_143":364,"_41":42,"_40":388,"_145":124,"_38":389,"_13":345,"_34":20,"_35":390,"_24":25,"_150":-5,"_273":391,"_27":392},{"_43":380,"_32":33,"_30":31,"_143":364,"_41":42,"_40":14,"_145":124,"_38":381,"_13":382,"_34":20,"_35":37,"_24":25,"_150":-5,"_273":383,"_27":384},{"_43":372,"_32":373,"_30":374,"_143":364,"_41":42,"_40":375,"_145":124,"_38":376,"_13":147,"_34":148,"_35":377,"_24":25,"_150":-5,"_273":378,"_27":379},{"_43":361,"_32":362,"_30":363,"_143":364,"_41":42,"_40":365,"_145":25,"_38":366,"_13":367,"_34":20,"_35":368,"_24":25,"_150":-5,"_273":369,"_27":370},{"_43":206,"_32":207,"_30":208,"_143":-5,"_41":42,"_40":209,"_145":124,"_38":358,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":359,"_27":360},{"_43":349,"_32":350,"_30":351,"_143":208,"_41":42,"_40":352,"_145":124,"_38":353,"_13":354,"_34":158,"_35":355,"_24":25,"_150":-5,"_273":356,"_27":357},{"_43":340,"_32":341,"_30":342,"_143":208,"_41":42,"_40":343,"_145":25,"_38":344,"_13":345,"_34":148,"_35":346,"_24":25,"_150":-5,"_273":347,"_27":348},{"_43":332,"_32":333,"_30":334,"_143":208,"_41":42,"_40":335,"_145":124,"_38":336,"_13":147,"_34":148,"_35":337,"_24":25,"_150":-5,"_273":338,"_27":339},{"_43":323,"_32":324,"_30":325,"_143":208,"_41":42,"_40":326,"_145":124,"_38":327,"_13":328,"_34":158,"_35":329,"_24":25,"_150":-5,"_273":330,"_27":331},{"_43":200,"_32":201,"_30":202,"_143":-5,"_41":42,"_40":183,"_145":124,"_38":320,"_13":61,"_34":204,"_35":-5,"_24":25,"_150":-5,"_273":321,"_27":322},{"_43":312,"_32":313,"_30":314,"_143":202,"_41":42,"_40":315,"_145":124,"_38":316,"_13":183,"_34":148,"_35":317,"_24":25,"_150":-5,"_273":318,"_27":319},{"_43":303,"_32":304,"_30":305,"_143":202,"_41":42,"_40":306,"_145":25,"_38":307,"_13":308,"_34":148,"_35":309,"_24":25,"_150":-5,"_273":310,"_27":311},{"_43":294,"_32":295,"_30":296,"_143":202,"_41":42,"_40":297,"_145":124,"_38":298,"_13":299,"_34":148,"_35":300,"_24":25,"_150":-5,"_273":301,"_27":302},{"_43":193,"_32":194,"_30":195,"_143":-5,"_41":42,"_40":196,"_145":124,"_38":291,"_13":61,"_34":20,"_35":198,"_24":25,"_150":-5,"_273":292,"_27":293},{"_43":186,"_32":187,"_30":188,"_143":-5,"_41":42,"_40":189,"_145":124,"_38":288,"_13":61,"_34":20,"_35":191,"_24":25,"_150":-5,"_273":289,"_27":290},{"_43":178,"_32":179,"_30":180,"_143":-5,"_41":42,"_40":181,"_145":124,"_38":285,"_13":183,"_34":148,"_35":184,"_24":25,"_150":-5,"_273":286,"_27":287},{"_43":171,"_32":172,"_30":173,"_143":-5,"_41":42,"_40":174,"_145":124,"_38":282,"_13":61,"_34":20,"_35":176,"_24":25,"_150":-5,"_273":283,"_27":284},{"_43":162,"_32":163,"_30":164,"_143":-5,"_41":42,"_40":165,"_145":25,"_38":279,"_13":167,"_34":158,"_35":168,"_24":25,"_150":169,"_273":280,"_27":281},{"_43":152,"_32":153,"_30":154,"_143":-5,"_41":42,"_40":155,"_145":25,"_38":276,"_13":157,"_34":158,"_35":159,"_24":25,"_150":160,"_273":277,"_27":278},{"_43":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":124,"_38":272,"_13":147,"_34":148,"_35":149,"_24":25,"_150":-5,"_273":274,"_27":275},["D",1769020184327],"children",[],[141],["D",1769059729545],[],[153],["D",1769021535684],[],[163],["D",1768976889400],[],[172],["D",1769565031884],[],[179],["D",1768976889699],[],[187],["D",1768976889705],[],[194],"0ff15328-f753-11f0-a075-42dde27851f2","handleDiscordMessages.js","5b5e1f60-f692-11f0-b444-42dde27851f2",142,["D",1769059657014],3,"import { DateTime } from \"https://esm.sh/luxon@3.4.4\";\nimport Anthropic from \"npm:@anthropic-ai/sdk@0.24.3\";\nimport nacl from \"npm:tweetnacl@1.0.3\";\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\n\nimport { backstory } from \"../backstory.js\";\nimport { formatMemoriesForPrompt, getRelevantMemories } from \"../memoryUtils.js\";\n\n// ---- Bot identity ----\nexport const BOT_SENDER_ID = \"mr_bilbo_bot\";\nexport const BOT_SENDER_NAME = \"Mr. Bilbo\";\n\n// ---- Env vars required ----\n// Set these in Val Town environment variables:\n// discordPublicKey: your app public key (for verifying requests)\n// ANTHROPIC_API_KEY: your Anthropic key\nconst DISCORD_PUBLIC_KEY = Deno.env.get(\"discordPublicKey\");\nif (!DISCORD_PUBLIC_KEY) throw new Error(\"discordPublicKey is not set\");\n\n// --------------------\n// Discord verification\n// --------------------\nfunction hexToUint8Array(hex) {\n if (typeof hex !== \"string\" || hex.length % 2 !== 0) return new Uint8Array();\n const arr = new Uint8Array(hex.length / 2);\n for (let i = 0; i < arr.length; i++) {\n arr[i] = parseInt(hex.slice(i * 2, i * 2 + 2), 16);\n }\n return arr;\n}\n\nasync function verifyDiscordRequest(req, rawBody) {\n const signature = req.headers.get(\"X-Signature-Ed25519\");\n const timestamp = req.headers.get(\"X-Signature-Timestamp\");\n if (!signature || !timestamp) return false;\n\n const message = new TextEncoder().encode(timestamp + rawBody);\n const sig = hexToUint8Array(signature);\n\n // Discord public key is hex-encoded\n const publicKey = hexToUint8Array(DISCORD_PUBLIC_KEY);\n\n return nacl.sign.detached.verify(message, sig, publicKey);\n}\n\n// --------------------\n// Conversation helpers\n// --------------------\nfunction getConversationId({ guild_id, channel_id, user_id }) {\n // DMs: key by user so the convo stays stable even if Discord changes DM channel IDs\n if (!guild_id) return `dm:${user_id}`;\n // Servers/threads: key by channel\n return `chan:${channel_id}`;\n}\n\nfunction truncateDiscord(text, max = 1900) {\n if (!text) return \"\";\n if (text.length <= max) return text;\n return text.slice(0, max - 20).trimEnd() + \"\\n\\n(…truncated)\";\n}\n\n// --------------------\n// DB: store + history\n// --------------------\nexport async function storeChatMessage(\n conversationId,\n channelId,\n guildId,\n senderId,\n senderName,\n message,\n isBot = false\n) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const timestamp = Math.floor(Date.now() / 1000);\n\n await sqlite.execute({\n sql: `\n INSERT INTO discord_chats (\n conversation_id, channel_id, guild_id,\n sender_id, sender_name, message, timestamp, is_bot\n ) VALUES (\n :conversation_id, :channel_id, :guild_id,\n :sender_id, :sender_name, :message, :timestamp, :is_bot\n )\n `,\n args: {\n conversation_id: conversationId,\n channel_id: String(channelId),\n guild_id: guildId ? String(guildId) : null,\n sender_id: String(senderId),\n sender_name: String(senderName),\n message: String(message),\n timestamp,\n is_bot: isBot ? 1 : 0,\n },\n });\n\n return true;\n } catch (err) {\n console.error(\"Error storing chat message:\", err);\n return false;\n }\n}\n\nexport async function getChatHistory(conversationId, limit = 50) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Get *most recent* N then reverse to chronological\n const result = await sqlite.execute({\n sql: `\n SELECT * FROM discord_chats\n WHERE conversation_id = :conversation_id\n ORDER BY timestamp DESC\n LIMIT :limit\n `,\n args: {\n conversation_id: conversationId,\n limit,\n },\n });\n\n const rows = result.rows || [];\n return rows.reverse();\n } catch (err) {\n console.error(\"Error retrieving chat history:\", err);\n return [];\n }\n}\n\nfunction formatChatHistoryForAI(history) {\n const messages = [];\n for (const msg of history) {\n if (msg.is_bot) {\n messages.push({ role: \"assistant\", content: msg.message });\n } else {\n messages.push({\n role: \"user\",\n content: `${msg.sender_name} says: ${msg.message}`,\n });\n }\n }\n return messages;\n}\n\n// --------------------\n// AI analysis + memory tags\n// --------------------\nasync function analyzeMessageContent(anthropic, username, messageText, chatHistory = []) {\n try {\n const memories = await getRelevantMemories();\n const memoriesText = formatMemoriesForPrompt(memories);\n\n const systemPrompt = `${backstory}\n\nYour job is to read this Discord message from your employer and respond in a natural, butler-like way, noting any important information that should be remembered for future reference.\n\nYou have access to the following stored memories:\n\n${memoriesText}\n\nIf this appears to be a new client or the conversation is in an early stage, you should conduct an intake interview to gather essential background information. First ask the client if now is a good time to ask them some questions.\n\nAsk about the following topics in a conversational way (not all at once, but continuing the interview naturally based on their responses):\n\nInitial Information:\n- Who are the family members living in the home and their ages?\n- Names of close family members and their relationships to the client?\n\nDaily Life:\n- Which grocery stores and local restaurants they frequent?\n- Family members' food preferences and any dietary restrictions?\n- Typical working hours and recurring commitments?\n- Important dates (birthdays, anniversaries, holidays)?\n- Monthly bills and subscriptions that need tracking?\n- Emergency contacts and regular service providers?\n- Current health goals and any medication reminders needed?\n\nYour goal is to collect this information naturally through conversation and store it as memories (as undated memories). Once you've gathered sufficient background information, you can conclude the intake process and transition to normal reactive chat.\n\nIf the conversation is already past the intake stage, then analyze the message content and think about which memories might be worth creating based on the information provided.\n\nYou should respond in a natural conversational way. You have three options for managing memories:\n\n1. CREATE memories: Include them in tags in JSON format.\n2. EDIT memories: Include them in tags in JSON format (must include memory ID).\n3. DELETE memories: Include them in tags in JSON format (just include memory IDs).\n\nImportant guidelines for memory management:\n1. For new memories, set a date for each memory whenever possible.\n2. The date should be the actual date of the event. You don't need to set reminder dates in advance.\n3. Keep the memory text concise: ideally one short sentence, but include all important details.\n4. Extract any dates mentioned and convert them to ISO format. If the year isn't mentioned, assume the current year.\n5. If no date is relevant to the memory, set \"date\" to null.\n6. For editing or deleting memories, you MUST include the correct memory ID from the displayed memories. Each memory is displayed with its ID in the format \"[ID: xyz123]\".\n7. If no memories need to be managed, simply respond naturally WITHOUT including any memory tags.\n8. When a user asks to delete a memory, you must find its ID from the memory list above and include that ID in the deleteMemories tag.\n9. Do not create duplicate memories. If a memory already exists, do not record the same information again.\n\nYour response style:\n- Use a brief, natural-sounding tone characteristic of a personal assistant\n- Be slightly dignified but sound modern, not too stuffy or old-fashioned\n- Keep responses brief (1-2 sentences)\n- Vary your responses to avoid sounding robotic\n- Be polite and deferential\n- Avoid contractions (use \"do not\" instead of \"don't\")\n\nToday's date is ${DateTime.now()\n .setZone(\"America/Toronto\")\n .toFormat(\"yyyy-MM-dd\")}`;\n\n const formattedHistory = chatHistory.length ? formatChatHistoryForAI(chatHistory) : [];\n\n const response = await anthropic.messages.create({\n model: \"claude-sonnet-4-5-20250929\",\n max_tokens: 2000,\n system: systemPrompt,\n messages: formattedHistory,\n });\n\n const responseText = response.content?.[0]?.text || \"\";\n\n const createMemoryMatch = responseText.match(/([\\s\\S]*?)<\\/createMemories>/);\n const editMemoryMatch = responseText.match(/([\\s\\S]*?)<\\/editMemories>/);\n const deleteMemoryMatch = responseText.match(/([\\s\\S]*?)<\\/deleteMemories>/);\n\n let cleanedResponse = responseText;\n let memoriesToCreate = [];\n let memoriesToEdit = [];\n let memoriesToDelete = [];\n\n if (createMemoryMatch) {\n cleanedResponse = cleanedResponse.replace(/[\\s\\S]*?<\\/createMemories>/, \"\").trim();\n try { memoriesToCreate = JSON.parse(createMemoryMatch[1]); } catch (e) { console.error(e); }\n }\n if (editMemoryMatch) {\n cleanedResponse = cleanedResponse.replace(/[\\s\\S]*?<\\/editMemories>/, \"\").trim();\n try { memoriesToEdit = JSON.parse(editMemoryMatch[1]); } catch (e) { console.error(e); }\n }\n if (deleteMemoryMatch) {\n cleanedResponse = cleanedResponse.replace(/[\\s\\S]*?<\\/deleteMemories>/, \"\").trim();\n try { memoriesToDelete = JSON.parse(deleteMemoryMatch[1]); } catch (e) { console.error(e); }\n }\n\n cleanedResponse = cleanedResponse.replace(/\\n{3,}/g, \"\\n\\n\");\n\n return {\n memories: memoriesToCreate,\n editMemories: memoriesToEdit,\n deleteMemories: memoriesToDelete,\n response: cleanedResponse || \"Very good. I shall attend to it.\",\n };\n } catch (err) {\n console.error(\"Message analysis error:\", err);\n return {\n memories: [],\n editMemories: [],\n deleteMemories: [],\n response: \"I do apologize, but I seem to be experiencing some difficulty at the moment.\",\n };\n }\n}\n\n// --------------------\n// Memories CRUD (same as yours)\n// --------------------\nasync function applyMemoryChanges(analysis) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Create\n if (analysis.memories?.length) {\n const createdIds = [];\n for (const memory of analysis.memories) {\n const memoryId = nanoid(10);\n createdIds.push(memoryId);\n await sqlite.execute({\n sql: `\n INSERT INTO memories (id, date, text, createdBy, createdDate, tags)\n VALUES (:id, :date, :text, :createdBy, :createdDate, :tags)\n `,\n args: {\n id: memoryId,\n date: memory.date ?? null,\n text: memory.text ?? \"\",\n createdBy: \"discord\",\n createdDate: Date.now(),\n tags: memory.tags ?? \"\",\n },\n });\n }\n console.log(`Created ${analysis.memories.length} memories: ${createdIds.join(\", \")}`);\n }\n\n // Edit\n if (analysis.editMemories?.length) {\n const editedIds = [];\n for (const memory of analysis.editMemories) {\n if (!memory.id) continue;\n editedIds.push(memory.id);\n\n const updateFields = [];\n const args = { id: memory.id };\n\n if (memory.text !== undefined) { updateFields.push(\"text = :text\"); args.text = memory.text; }\n if (memory.date !== undefined) { updateFields.push(\"date = :date\"); args.date = memory.date; }\n if (memory.tags !== undefined) { updateFields.push(\"tags = :tags\"); args.tags = memory.tags; }\n\n if (updateFields.length) {\n await sqlite.execute({\n sql: `UPDATE memories SET ${updateFields.join(\", \")} WHERE id = :id`,\n args,\n });\n }\n }\n console.log(`Edited ${editedIds.length} memories: ${editedIds.join(\", \")}`);\n }\n\n // Delete\n if (analysis.deleteMemories?.length) {\n for (const memoryId of analysis.deleteMemories) {\n await sqlite.execute({\n sql: `DELETE FROM memories WHERE id = :id`,\n args: { id: memoryId },\n });\n }\n console.log(`Deleted ${analysis.deleteMemories.length} memories: ${analysis.deleteMemories.join(\", \")}`);\n }\n}\n\n// --------------------\n// Main HTTP handler\n// --------------------\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\n `

Mr. Bilbo (Discord)

This endpoint handles Discord slash-command interactions.

`,\n { status: 200, headers: { \"content-type\": \"text/html\" } }\n );\n }\n\n const rawBody = await req.text();\n\n const verified = await verifyDiscordRequest(req, rawBody);\n if (!verified) {\n return new Response(\"signature invalid\", { status: 401 });\n }\n\n const interaction = JSON.parse(rawBody);\n\n // Discord PING (type 1) -> respond with PONG (type 1)\n if (interaction.type === 1) {\n return Response.json({ type: 1 });\n }\n\n // We only handle slash commands here (type 2)\n if (interaction.type !== 2) {\n return Response.json({\n type: 4,\n data: { content: \"I only respond to slash commands at the moment.\" },\n });\n }\n\n try {\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n if (!apiKey) {\n return Response.json({\n type: 4,\n data: { content: \"I apologize, but I am not properly configured at the moment.\" },\n });\n }\n const anthropic = new Anthropic({ apiKey });\n\n const commandName = interaction.data?.name || \"\";\n const options = interaction.data?.options || [];\n\n // Expect an option named \"message\" (string)\n const messageOpt = options.find((o) => o?.name === \"message\");\n const messageText = (messageOpt?.value || \"\").toString().trim();\n\n // Basic “start/introduction”\n if (commandName === \"start\" || messageText === \"/start\" || messageText === \"!start\") {\n const intro =\n \"Good day. I am Mr. Bilbo, at your service. I shall make note of any important matters you wish me to remember. Would you mind if I ask you a few questions?\";\n return Response.json({ type: 4, data: { content: intro } });\n }\n\n if (!messageText) {\n return Response.json({\n type: 4,\n data: { content: \"Kindly provide a message. For example: /bilbo message: \\\"What shall I do today?\\\"\" },\n });\n }\n\n // Identify user + channel context\n const channelId = interaction.channel_id;\n const guildId = interaction.guild_id || null;\n\n // user differs for DMs vs guild\n const user = interaction.member?.user || interaction.user;\n const userId = user?.id;\n const username = user?.global_name || user?.username || \"Sir/Madam\";\n\n const conversationId = getConversationId({\n guild_id: guildId,\n channel_id: channelId,\n user_id: userId,\n });\n\n // Store incoming\n await storeChatMessage(conversationId, channelId, guildId, userId, username, messageText, false);\n\n // Load history (includes the message we just inserted)\n const chatHistory = await getChatHistory(conversationId, 50);\n\n // Analyze + respond\n const analysis = await analyzeMessageContent(anthropic, username, messageText, chatHistory);\n\n // Apply memory changes\n await applyMemoryChanges(analysis);\n\n // Store bot reply\n await storeChatMessage(\n conversationId,\n channelId,\n guildId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n analysis.response,\n true\n );\n\n return Response.json({\n type: 4,\n data: { content: truncateDiscord(analysis.response) },\n });\n } catch (err) {\n console.error(err);\n return Response.json({\n type: 4,\n data: {\n content:\n \"I do apologize, but I seem to be experiencing some difficulty at the moment. Perhaps we could try again shortly.\",\n },\n });\n }\n}",[],[201,295],"bd27df1c-fc0d-11f0-afe8-42dde27851f2","getWeather.js","5a97cc98-f692-11f0-b45d-42dde27851f2",212,["D",1769579638663],16,"import { DateTime } from \"https://esm.sh/luxon@3.4.4\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { getWeather } from \"https://esm.town/v/stevekrouse/getWeather\";\n\nconst TABLE_NAME = \"memories\";\nconst ZONE = \"America/Toronto\";\n\nfunction summarizeWeather(weather) {\n const summarizeDay = (day) => ({\n date: day.date,\n highTemp: day.maxtempC,\n lowTemp: day.mintempC,\n hourly: day.hourly?.map((hour) => ({\n time: hour.time,\n temp: hour.tempC,\n chanceOfRain: hour.chanceofrain,\n chanceOfSnow: hour.chanceofsnow,\n desc: (hour.weatherDesc || []).map((d) => d.value).join(\", \"),\n })) ?? [],\n });\n\n return (weather.weather || []).map(summarizeDay);\n}\n\nasync function deleteExistingForecast(dateISO) {\n await sqlite.execute({\n sql: `\n DELETE FROM ${TABLE_NAME}\n WHERE date = :date AND text LIKE 'weather forecast:%'\n `,\n args: { date: dateISO },\n });\n}\n\nasync function insertForecast(dateISO, forecastText) {\n await sqlite.execute({\n sql: `\n INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\n VALUES (:id, :date, :text, :createdBy, :createdDate, :tags)\n `,\n args: {\n id: nanoid(10),\n date: dateISO,\n text: `weather forecast: ${forecastText}`,\n createdBy: \"weather\",\n createdDate: Date.now(),\n tags: \"weather\",\n },\n });\n}\n\nexport default async function updateWeatherForecast() {\n const raw = await getWeather(\"Waterloo, Ontario\");\n const days = summarizeWeather(raw);\n\n for (const day of days) {\n // normalize date to YYYY-MM-DD in Toronto timezone\n const dateISO = DateTime.fromISO(day.date, { zone: ZONE }).toISODate();\n const forecastText = `High of ${day.highTemp}°C, low of ${day.lowTemp}°C, ${day.hourly?.[0]?.desc || \"forecast available\"}.`;\n\n await deleteExistingForecast(dateISO);\n await insertForecast(dateISO, forecastText);\n }\n\n console.log(\"Weather forecast updated in memories.\");\n return days;\n}",[],[201,304],"cbd988f0-f693-11f0-ba82-42dde27851f2","getCalendarEvents.js","5a9a9662-f692-11f0-9451-42dde27851f2",100,["D",1768977508898],"import { getEvents } from \"https://esm.town/v/geoffreylitt/getGoogleCalendarEvents\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = `memories`;\nconst LOCAL_TIMEZONE = \"America/Toronto\";\n\nasync function deleteExistingCalendarEvents() {\n await sqlite.execute(\n `\n DELETE FROM ${TABLE_NAME}\n WHERE createdBy = 'calendar'\n `\n );\n}\n\nfunction extractTimeFromISO(isoString) {\n const timeMatch = isoString.match(/T(\\d{2}):(\\d{2}):/);\n if (!timeMatch) return null;\n\n const hours = parseInt(timeMatch[1], 10);\n const minutes = timeMatch[2];\n\n const period = hours >= 12 ? \"pm\" : \"am\";\n const hour12 = hours % 12 || 12;\n\n return `${hour12}:${minutes} ${period}`;\n}\n\nfunction formatEventToNaturalLanguage(event) {\n const summary = event.summary || \"Untitled event\";\n\n if (event.start.dateTime) {\n const startTime = extractTimeFromISO(event.start.dateTime);\n const endTime = extractTimeFromISO(event.end.dateTime);\n\n const timezone =\n event.start.timeZone ||\n (event.start.dateTime.includes(\"+\") || event.start.dateTime.includes(\"-\")\n ? event.start.dateTime.match(/[+-]\\d{2}:\\d{2}$/)?.[0]\n : \"UTC\");\n\n const isLocalTimezone =\n timezone === LOCAL_TIMEZONE ||\n timezone?.startsWith(\"-04:00\") ||\n timezone?.startsWith(\"-05:00\");\n\n let text = `${summary} from ${startTime} - ${endTime}`;\n\n if (timezone && !isLocalTimezone) {\n if (timezone.includes(\"/\")) {\n const friendlyTimezone =\n timezone.split(\"/\")[1].replace(\"_\", \" \").toLowerCase() + \" time\";\n text += ` (${friendlyTimezone})`;\n } else if (timezone.match(/[+-]\\d{2}:\\d{2}/)) {\n text += ` (${timezone})`;\n }\n }\n\n if (event.location) {\n text += ` at ${event.location}`;\n }\n\n return text;\n } else if (event.start.date) {\n return `All-day event: ${summary}${\n event.location ? ` at ${event.location}` : \"\"\n }`;\n }\n\n return summary;\n}\n\nasync function insertCalendarEvent(date, eventText) {\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\n\n console.log(\"inserting\", { date, eventText });\n\n await sqlite.execute(\n `\n INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)\n `,\n [nanoid(10), date, eventText, \"calendar\", Date.now(), \"calendar\"]\n );\n}\n\nexport default async function getCalendarEvents() {\n try {\n const events = await getEvents(\n Deno.env.get(\"GOOGLE_CALENDAR_ACCOUNT_ID\"),\n Deno.env.get(\"GOOGLE_CALENDAR_CALENDAR_ID\")\n );\n\n console.log(`Found ${events.length} calendar events`);\n\n await deleteExistingCalendarEvents();\n\n for (const event of events) {\n let date;\n if (event.start.dateTime) {\n date = event.start.dateTime.split(\"T\")[0];\n } else if (event.start.date) {\n date = event.start.date;\n } else {\n console.warn(`Event ${event.summary} has no start date/time, skipping`);\n continue;\n }\n\n const eventText = formatEventToNaturalLanguage(event);\n console.log(`Adding calendar event for ${date}: ${eventText}`);\n await insertCalendarEvent(date, eventText);\n }\n\n console.log(`Calendar events imported into the database.`);\n return events;\n } catch (error) {\n console.error(\"Error importing calendar events:\", error);\n throw error;\n }\n}\n",[],[201,313],["D",1768970077837],[262,263,264],[201],"cc7d3ee6-f751-11f0-871b-42dde27851f2","setupDiscordDb.js","5ab9c000-f692-11f0-9451-42dde27851f2",137,["D",1769059114355],8,"// dbUtils/setupDiscordDb.js\n// One-time init endpoint: creates discord_chats (and indexes) and returns table list.\n\nexport default async function setupDiscordDb(_req) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS discord_chats (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n conversation_id TEXT NOT NULL,\n channel_id TEXT NOT NULL,\n guild_id TEXT,\n sender_id TEXT NOT NULL,\n sender_name TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp INTEGER NOT NULL,\n is_bot INTEGER NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_discord_chats_conversation_time\n ON discord_chats(conversation_id, timestamp)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_discord_chats_channel_id\n ON discord_chats(channel_id)\n `);\n\n const tables = await sqlite.execute(`\n SELECT name FROM sqlite_master\n WHERE type='table'\n ORDER BY name\n `);\n\n return Response.json({\n ok: true,\n tables: (tables.rows || []).map((r) => r.name),\n });\n}",[],[207,324],"4c96bd54-f6f9-11f0-b0a6-42dde27851f2","populateIds.js","5ab6632e-f692-11f0-bc77-42dde27851f2",125,["D",1769021104064],"// dbUtils/populateIds.js\n// Run this manually to generate IDs for memory rows that don't have them\n\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\n\nexport default async function populateIds() {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const rowsWithoutId = await sqlite.execute(`\n SELECT rowid, createdDate, createdBy\n FROM memories\n WHERE id IS NULL OR id = ''\n `);\n\n console.log(\n `Found ${rowsWithoutId.rows.length} rows without IDs. Generating IDs...`,\n );\n\n let updatedCount = 0;\n\n for (const row of rowsWithoutId.rows || []) {\n const id = nanoid(10);\n const timestamp = row.createdDate ?? Date.now();\n const createdBy = row.createdBy ?? \"migration\";\n\n await sqlite.execute({\n sql: `\n UPDATE memories\n SET id = :id,\n createdDate = :createdDate,\n createdBy = :createdBy\n WHERE rowid = :rowid\n `,\n args: {\n id,\n createdDate: timestamp,\n createdBy,\n rowid: row.rowid,\n },\n });\n\n updatedCount++;\n }\n\n console.log(`✅ Successfully updated ${updatedCount} rows with new IDs.`);\n return `Successfully updated ${updatedCount} rows with new IDs.`;\n } catch (error) {\n console.error(\"Error populating memory IDs:\", error);\n throw error;\n }\n}",[],[207,333],"30120bd2-fefd-11f0-b004-42dde27851f2","populateCreatedBys.js","5aae2d94-f692-11f0-85b0-42dde27851f2",217,["D",1769902383508],5,"// dbUtils/populateCreatedBys.js\n// Run manually to set createdBy/tags for rows missing createdBy.\n// Safer: does not overwrite existing tags, and doesn't label everything \"chat\".\n\nexport default async function populateCreatedBys() {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const rows = await sqlite.execute(`\n SELECT rowid, text, tags, createdBy, createdDate\n FROM memories\n WHERE createdBy IS NULL OR createdBy = ''\n `);\n\n console.log(`Found ${rows.rows.length} rows without createdBy. Populating...`);\n\n let updatedCount = 0;\n\n for (const row of rows.rows || []) {\n let createdBy = \"migration\"; // safe default\n const text = (row.text || \"\").toLowerCase();\n\n if (text.includes(\"weather\")) {\n createdBy = \"weather\";\n }\n\n // Only set tags if missing/blank\n let newTags = row.tags;\n if (!newTags || String(newTags).trim() === \"\") {\n if (createdBy === \"weather\") newTags = \"weather\";\n else if (createdBy === \"usps\") newTags = \"mail\";\n else newTags = \"\";\n }\n\n await sqlite.execute({\n sql: `\n UPDATE memories\n SET createdBy = :createdBy,\n tags = :tags,\n createdDate = COALESCE(createdDate, :timestamp)\n WHERE rowid = :rowid\n `,\n args: {\n createdBy,\n tags: newTags,\n timestamp: Date.now(),\n rowid: row.rowid,\n },\n });\n\n updatedCount++;\n }\n\n console.log(`✅ Successfully updated ${updatedCount} rows with createdBy values.`);\n return `Successfully updated ${updatedCount} rows with createdBy values.`;\n } catch (error) {\n console.error(\"Error populating createdBy:\", error);\n throw error;\n }\n}",[],[207,341],"40bf5ade-ffa7-11f0-84f7-42dde27851f2","migrateDb.js","5ac21822-f692-11f0-9437-42dde27851f2",256,["D",1769975425929],4,"// dbUtils/migrateDb.js\n// HTTP init endpoint: ensures memories table + columns + indexes exist,\n// and returns a table list + column list for verification.\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE = \"memories\";\n\nexport default async function migrateDb(_req) {\n await sqlite.execute({\n sql: `\n CREATE TABLE IF NOT EXISTS ${TABLE} (\n id TEXT PRIMARY KEY,\n date TEXT,\n text TEXT NOT NULL,\n createdBy TEXT,\n createdDate INTEGER,\n tags TEXT\n )\n `,\n args: [],\n });\n\n const info = await sqlite.execute({ sql: `PRAGMA table_info(${TABLE})`, args: [] });\n const existingCols = new Set((info.rows || []).map((r) => r.name));\n\n const addColumn = async (name, typeSql) => {\n if (!existingCols.has(name)) {\n await sqlite.execute({\n sql: `ALTER TABLE ${TABLE} ADD COLUMN ${name} ${typeSql}`,\n args: [],\n });\n existingCols.add(name);\n }\n };\n\n // Keep compatibility if schema evolves\n await addColumn(\"date\", \"TEXT\");\n await addColumn(\"text\", \"TEXT\");\n await addColumn(\"createdBy\", \"TEXT\");\n await addColumn(\"createdDate\", \"INTEGER\");\n await addColumn(\"tags\", \"TEXT\");\n\n // Indexes to match common queries / sorting\n await sqlite.execute({\n sql: `CREATE INDEX IF NOT EXISTS idx_memories_date ON ${TABLE}(date)`,\n args: [],\n });\n\n await sqlite.execute({\n sql: `CREATE INDEX IF NOT EXISTS idx_memories_createdBy ON ${TABLE}(createdBy)`,\n args: [],\n });\n\n // Helps ORDER BY createdDate DESC\n await sqlite.execute({\n sql: `CREATE INDEX IF NOT EXISTS idx_memories_createdDate ON ${TABLE}(createdDate)`,\n args: [],\n });\n\n const tables = await sqlite.execute({\n sql: `\n SELECT name FROM sqlite_master\n WHERE type='table'\n ORDER BY name\n `,\n args: [],\n });\n\n const cols = await sqlite.execute({ sql: `PRAGMA table_info(${TABLE})`, args: [] });\n\n return Response.json({\n ok: true,\n tables: (tables.rows || []).map((r) => r.name),\n memoriesColumns: (cols.rows || []).map((r) => r.name),\n });\n}",[],[207,350],["D",1768976888702],[257,258,259,260],[207],"f89ed8f0-0b05-11f1-85c1-42dde27851f2","style.css","01696212-ff02-11f0-a182-42dde27851f2","f3a401a0-ff01-11f0-9c9d-42dde27851f2",299,["D",1771225569891],12,":root {\n --bg: #0b0d12;\n --panel: #121621;\n --panel2: #0f131c;\n --text: #e9eefc;\n --muted: #9fb0d0;\n --border: rgba(255, 255, 255, 0.08);\n --accent: #7aa7ff;\n --danger: #ff6b6b;\n --app-font: \"Oregano\", system-ui, -apple-system, Segoe UI, Roboto, Arial, sans-serif;\n}\n\n* { box-sizing: border-box; }\nhtml, body { height: 100%; }\nbody {\n min-height: 100vh;\n background: #0b0d12; /* fallback */\n margin: 0;\n font-family: var(--app-font);\n}\n\n/* Background image layer */\nbody::before {\n content: \"\";\n position: fixed;\n inset: 0;\n z-index: -1;\n background-image:\n linear-gradient(rgba(0,0,0,0.55), rgba(0,0,0,0.55)),\n url(\"/api/images/logbook_bg.png\");\n background-size: cover;\n background-position: center;\n}\n\na { color: var(--accent); text-decoration: none; }\na:hover { text-decoration: underline; }\n\n.shell {\n max-width: 1100px;\n margin: 0 auto;\n padding: 22px 16px 48px;\n\n /* The rectangle */\n background: rgba(255, 255, 255, 0.10);\n border: 1px solid rgba(255,255,255,0.14);\n border-radius: 18px;\n backdrop-filter: blur(8px);\n}\n\n\n.topbar {\n display: flex;\n align-items: baseline;\n justify-content: space-between;\n gap: 12px;\n margin-bottom: 14px;\n}\n\nh1 {\n font-size: 18px;\n margin: 0;\n letter-spacing: 0.2px;\n}\n\n.sub {\n color: var(--muted);\n font-size: 12px;\n margin-top: 4px;\n}\n\n.pill {\n display: inline-flex;\n align-items: center;\n gap: 8px;\n padding: 6px 10px;\n border: 1px solid var(--border);\n border-radius: 999px;\n background: rgba(255,255,255,0.03);\n color: var(--muted);\n font-size: 12px;\n}\n\n.layout {\n display: grid;\n grid-template-columns: 360px 1fr;\n gap: 12px;\n}\n\n@media (max-width: 920px) {\n .layout { grid-template-columns: 1fr; }\n}\n\n.card {\n border: 1px solid var(--border);\n background: rgba(18, 22, 33, 0.72);\n border-radius: 14px;\n box-shadow: 0 10px 28px rgba(0,0,0,0.25);\n overflow: hidden;\n}\n\n.cardHeader {\n padding: 12px 12px 10px;\n border-bottom: 1px solid var(--border);\n background: rgba(15,19,28,0.55);\n}\n\n.cardBody { padding: 12px; }\n\n.row { display: flex; gap: 10px; align-items: center; flex-wrap: wrap; }\n.spread { justify-content: space-between; }\n\n.input, .textarea {\n width: 100%;\n padding: 10px 11px;\n border-radius: 12px;\n border: 1px solid var(--border);\n background: rgba(255,255,255,0.04);\n color: var(--text);\n outline: none;\n}\n\n.textarea { min-height: 140px; resize: vertical; }\n\n.input:focus, .textarea:focus {\n border-color: rgba(122,167,255,0.55);\n box-shadow: 0 0 0 3px rgba(122,167,255,0.14);\n}\n\n.btn {\n padding: 9px 11px;\n border-radius: 12px;\n border: 1px solid var(--border);\n background: rgba(255,255,255,0.06);\n color: var(--text);\n cursor: pointer;\n user-select: none;\n}\n.btn:hover { background: rgba(255,255,255,0.09); }\n.btn.primary {\n border-color: rgba(122,167,255,0.35);\n background: rgba(122,167,255,0.14);\n}\n.btn.danger {\n border-color: rgba(255,107,107,0.35);\n background: rgba(255,107,107,0.12);\n}\n\n.list {\n display: flex;\n flex-direction: column;\n gap: 8px;\n}\n\n.item {\n border: 1px solid var(--border);\n background: rgba(255,255,255,0.03);\n border-radius: 12px;\n padding: 10px;\n cursor: pointer;\n}\n.item:hover { background: rgba(255,255,255,0.05); }\n\n.itemActive {\n border-color: rgba(122,167,255,0.5);\n background: rgba(122,167,255,0.10);\n}\n\n.itemTitle {\n font-size: 13px;\n margin: 0 0 6px;\n color: var(--text);\n}\n.itemMeta {\n font-size: 11px;\n color: var(--muted);\n display: flex;\n gap: 8px;\n flex-wrap: wrap;\n}\n\n.hr { border: none; border-top: 1px solid var(--border); margin: 12px 0; }\n\n.kbd {\n font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, \"Liberation Mono\", \"Courier New\";\n font-size: 12px;\n color: var(--muted);\n border: 1px solid var(--border);\n background: rgba(255,255,255,0.03);\n padding: 2px 6px;\n border-radius: 8px;\n}\n\n/* ---- Notebook horizontal layout overrides ---- */\n\n/* make the app container feel like a page */\n.shell{\n max-width: 1250px;\n margin: 24px auto;\n padding: 18px;\n border-radius: 18px;\n background: rgba(10, 14, 22, 0.35);\n border: 1px solid rgba(255,255,255,0.12);\n backdrop-filter: blur(6px);\n}\n\n/* wider, horizontal split */\n.layout{\n display: grid;\n grid-template-columns: 520px 1fr; /* entries left, editor right */\n gap: 14px;\n}\n\n@media (max-width: 980px){\n .layout{ grid-template-columns: 1fr; }\n}\n\n/* blue frame around the whole notebook area */\n.layoutWrap{\n border: 2px solid rgba(122,167,255,0.80);\n border-radius: 16px;\n padding: 10px;\n box-shadow: 0 0 0 6px rgba(122,167,255,0.12);\n}\n\n/* slightly more “notebook” feel */\n.card{\n background: rgba(14, 18, 26, 0.70);\n border: 1px solid rgba(255,255,255,0.10);\n}\n\n.list{\n gap: 0;\n border: 1px solid rgba(255,255,255,0.10);\n border-radius: 12px;\n overflow: hidden;\n}\n\n.item{\n border: none;\n border-bottom: 1px solid rgba(255,255,255,0.08);\n border-radius: 0;\n background: rgba(255,255,255,0.03);\n}\n\n.item:last-child{ border-bottom: none; }\n\n.itemRow{\n display: grid;\n grid-template-columns: 120px 1fr 160px;\n gap: 10px;\n align-items: start;\n}\n\n.itemDate{\n font-size: 12px;\n opacity: 0.9;\n white-space: nowrap;\n overflow: hidden;\n text-overflow: ellipsis;\n}\n\n.itemNote{\n font-size: 13px;\n line-height: 1.25;\n}\n\n.itemTags{\n font-size: 12px;\n text-align: right;\n opacity: 0.85;\n white-space: nowrap;\n overflow: hidden;\n text-overflow: ellipsis;\n}\n/* hide old meta line (since we’ve moved it into columns) */\n.itemMeta{ display: none; }",[],[213,371,362],"frontend","2462542c-ff02-11f0-9c9d-42dde27851f2","index.tsx","20a3a17e-ff02-11f0-9019-42dde27851f2",235,["D",1769904511371],"/**\n * @jsxImportSource https://esm.sh/react@18.2.0\n */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"/public/components/App.tsx\";\n\ndeclare global {\n interface Window {\n __INITIAL_DATA?: unknown;\n }\n}\n\nconst rootEl = document.getElementById(\"root\");\nif (!rootEl) throw new Error(\"Missing #root element\");\n\nconst initialData = window.__INITIAL_DATA ?? null;\n\ncreateRoot(rootEl).render(\n \n \n \n);",[],[213,371,373],"be81e706-0b06-11f1-bac6-42dde27851f2",["D",1771225901891],9,[],[213,371,33],"2ae8eca6-0ade-11f1-a341-42dde27851f2","favicon.svg","13aab03e-ff02-11f0-a8bb-42dde27851f2",283,["D",1771208474401],"",[],[213,371,386],"5b751e24-ff32-11f0-bc83-42dde27851f2","types.ts","540df174-ff32-11f0-ab2f-42dde27851f2","5196b21e-ff32-11f0-87f4-42dde27851f2",251,["D",1769925219623],"export type Memory = {\n id: string;\n date: string | null;\n text: string;\n createdBy: string | null;\n createdDate: number | null; // epoch ms\n tags: string | null;\n};",[],[213,371,402,394],"shared","52ded71e-ff32-11f0-ab2f-42dde27851f2",248,["D",1769925205212],[251],[213,371,402],"690e6484-0b06-11f1-bac6-42dde27851f2","NotebookView.tsx","13c900cc-ff1e-11f0-b4a8-42dde27851f2","2bb364f0-ff02-11f0-919e-42dde27851f2",301,["D",1771225758530],15,"/**\n * @jsxImportSource https://esm.sh/react@18.2.0\n */\nimport React, { useEffect, useMemo, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Memory } from \"/public/shared/types.ts\";\n\ntype CreateBody = Partial>;\ntype Patch = Partial>;\n\ntype Props = {\n loading: boolean;\n memories: Memory[];\n onRefresh: () => Promise;\n onCreate: (body: CreateBody) => Promise;\n onUpdate: (id: string, patch: Patch) => Promise;\n onDelete: (id: string) => Promise;\n};\n\nfunction preview(text: string, max = 180) {\n const t = (text ?? \"\").trim().replace(/\\s+/g, \" \");\n return t.length > max ? t.slice(0, max - 1) + \"…\" : (t || \"(empty)\");\n}\n\nfunction normalizeTags(tags: string) {\n return tags\n .split(/[,]+/)\n .map((t) => t.trim())\n .filter(Boolean)\n .join(\", \");\n}\n\nexport function NotebookView({\n loading,\n memories,\n onRefresh,\n onCreate,\n onUpdate,\n onDelete,\n}: Props) {\n const [selectedId, setSelectedId] = useState(memories[0]?.id ?? null);\n\n // Pagination like the demo (“Page 1 of 2”)\n const PAGE_SIZE = 10;\n const [page, setPage] = useState(0);\n\n // Create form\n const [newText, setNewText] = useState(\"\");\n const [newDate, setNewDate] = useState(\"\");\n const [newTags, setNewTags] = useState(\"\");\n const newTextareaRef = useRef(null);\n\n // Edit overlay\n const [editOpen, setEditOpen] = useState(false);\n const [editText, setEditText] = useState(\"\");\n const [editDate, setEditDate] = useState(\"\");\n const [editTags, setEditTags] = useState(\"\");\n\n const selected = useMemo(\n () => memories.find((m) => m.id === selectedId) ?? null,\n [memories, selectedId],\n );\n\n const pageCount = Math.max(1, Math.ceil(memories.length / PAGE_SIZE));\n const pagedMemories = useMemo(() => {\n const start = page * PAGE_SIZE;\n return memories.slice(start, start + PAGE_SIZE);\n }, [memories, page]);\n\n // keep selection valid\n useEffect(() => {\n if (selectedId && !memories.some((m) => m.id === selectedId)) {\n setSelectedId(memories[0]?.id ?? null);\n }\n if (!selectedId && memories[0]?.id) {\n setSelectedId(memories[0].id);\n }\n }, [memories]);\n\n // keep page in range\n useEffect(() => {\n if (page > pageCount - 1) setPage(Math.max(0, pageCount - 1));\n }, [pageCount]);\n\n // load selected into editor\n useEffect(() => {\n if (!selected) return;\n setEditText(selected.text ?? \"\");\n setEditDate(selected.date ?? \"\");\n setEditTags(selected.tags ?? \"\");\n }, [selectedId]);\n\n // Ctrl/Cmd+Enter create or save (matches your old behavior)\n useEffect(() => {\n const onKeyDown = (e: KeyboardEvent) => {\n const isAction = (e.ctrlKey || e.metaKey) && e.key === \"Enter\";\n if (!isAction) return;\n\n if (document.activeElement === newTextareaRef.current) {\n void create();\n } else if (editOpen && selected) {\n void save();\n }\n };\n window.addEventListener(\"keydown\", onKeyDown);\n return () => window.removeEventListener(\"keydown\", onKeyDown);\n }, [editOpen, selected, editText, editDate, editTags, newText, newDate, newTags]);\n\n async function create() {\n const text = newText.trim();\n if (!text) return;\n\n const body: CreateBody = {\n text,\n date: newDate.trim() ? newDate.trim() : null,\n tags: newTags.trim() ? normalizeTags(newTags) : null,\n createdDate: Date.now(),\n };\n\n const created = await onCreate(body);\n\n setNewText(\"\");\n setNewDate(\"\");\n setNewTags(\"\");\n\n // Assume appended -> jump to last page\n const newIndex = memories.length;\n setPage(Math.floor(newIndex / PAGE_SIZE));\n\n setSelectedId(created.id);\n setEditOpen(true);\n }\n\n async function save() {\n if (!selected) return;\n\n const patch: Patch = {\n text: editText,\n date: editDate.trim() ? editDate.trim() : null,\n tags: editTags.trim() ? normalizeTags(editTags) : null,\n };\n\n await onUpdate(selected.id, patch);\n setEditOpen(false);\n }\n\n async function del() {\n if (!selected) return;\n const ok = confirm(\"Delete this entry?\");\n if (!ok) return;\n await onDelete(selected.id);\n setEditOpen(false);\n }\n\n function openEditor(id: string) {\n setSelectedId(id);\n setEditOpen(true);\n }\n\n return (\n

\n \n\n

Logbook

\n\n

\n \n \n

\n\n

\n {/* Left: Create */}\n

New Entry

{loading ? \"Loading…\" : \"Write something, then click NEW ENTRY.\"}

\n\n \n\n

\n setNewDate(e.target.value)}\n />\n

\n setNewTags(e.target.value)}\n />\n

\n setNewText(e.target.value)}\n />\n\n

\n Create: Ctrl+Enter\n

\n\n {/* Right: Table */}\n

DATE

NOTE

SOURCE

EDIT

\n\n

\n {pagedMemories.map((m) => (\n openEditor(m.id)}\n role=\"row\"\n >\n

{m.date ?? \"—\"}

{preview(m.text, 220)}

{m.tags?.trim() ? m.tags : \"—\"}

\n \n

\n ))}\n\n {!loading && memories.length === 0 ? (\n

\n No entries yet.\n

\n ) : null}\n

\n\n

\n \n setPage((p) => Math.min(pageCount - 1, p + 1))}\n disabled={page >= pageCount - 1}\n >\n Next\n \n

\n\n

\n Page {page + 1} of {pageCount}\n

\n\n {/* Edit overlay */}\n {editOpen ? (\n

setEditOpen(false)}>\n

e.stopPropagation()}>\n

Edit Note

{selected ? `Editing ${selected.id}` : \"No selection\"}

\n \n \n \n

\n\n

\n {!selected ? (\n

Pick an entry to edit.

\n ) : (\n <>\n setEditDate(e.target.value)}\n />\n

\n setEditTags(e.target.value)}\n />\n

\n setEditText(e.target.value)}\n style={{ minHeight: 180 }}\n />\n

\n Save: Ctrl+Enter\n

\n \n )}\n

\n ) : null}\n

\n );\n}",[],[213,371,418,409],"components","641e8c40-ff32-11f0-85d4-42dde27851f2","App.tsx","2e7633d4-ff02-11f0-bf3a-42dde27851f2",252,["D",1769925234155],"/**\n * @jsxImportSource https://esm.sh/react@18.2.0\n */\nimport React, { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport { NotebookView } from \"/public/components/NotebookView.tsx\";\nimport type { Memory } from \"/public/shared/types.ts\";\n\ntype Props = {\n initialData: unknown; // may be null or a preloaded { memories: Memory[] }\n};\n\nasync function api(path: string, init?: RequestInit): Promise {\n const res = await fetch(path, {\n headers: { \"content-type\": \"application/json\", ...(init?.headers ?? {}) },\n ...init,\n });\n if (!res.ok) {\n const text = await res.text().catch(() => \"\");\n throw new Error(`HTTP ${res.status}: ${text || res.statusText}`);\n }\n return (await res.json()) as T;\n}\n\nexport function App({ initialData }: Props) {\n const preloaded =\n initialData && typeof initialData === \"object\" ? (initialData as any).memories : null;\n\n const [memories, setMemories] = useState(Array.isArray(preloaded) ? preloaded : []);\n const [loading, setLoading] = useState(!Array.isArray(preloaded));\n const [error, setError] = useState(null);\n\n async function refresh() {\n setError(null);\n setLoading(true);\n try {\n const rows = await api(\"/api/memories\");\n setMemories(rows ?? []);\n } catch (e: any) {\n setError(e?.message ?? String(e));\n } finally {\n setLoading(false);\n }\n }\n\n useEffect(() => {\n if (!Array.isArray(preloaded)) void refresh();\n // eslint-disable-next-line react-hooks/exhaustive-deps\n }, []);\n\n const stats = useMemo(() => {\n const count = memories.length;\n const withTags = memories.filter((m) => (m.tags ?? \"\").trim().length > 0).length;\n return { count, withTags };\n }, [memories]);\n\n return (\n

Logbook

\n Backed by your Hono API: /api/memories\n

\n {stats.count} entries\n •\n {stats.withTags} tagged\n •\n Ctrl+Enter\n

\n\n {error ? (\n

\n Load error: {error}\n

\n \n

\n ) : null}\n\n {\n const created = await api(\"/api/memories\", {\n method: \"POST\",\n body: JSON.stringify(body),\n });\n setMemories((prev) => [created, ...prev]);\n return created;\n }}\n onUpdate={async (id, patch) => {\n await api<{ success: true }>(`/api/memories/${encodeURIComponent(id)}`, {\n method: \"PUT\",\n body: JSON.stringify(patch),\n });\n setMemories((prev) =>\n prev.map((m) => (m.id === id ? ({ ...m, ...patch } as Memory) : m))\n );\n }}\n onDelete={async (id) => {\n await api<{ success: true }>(`/api/memories/${encodeURIComponent(id)}`, {\n method: \"DELETE\",\n });\n setMemories((prev) => prev.filter((m) => m.id !== id));\n }}\n />\n

\n );\n}",[],[213,371,418,420],"2ce14004-ff02-11f0-9c3e-42dde27851f2",237,["D",1769904525637],[248,249],[213,371,418],"8b02706a-ffb4-11f0-9fb4-42dde27851f2","assets","89bd7a6a-ffb4-11f0-a17f-42dde27851f2",258,["D",1769981133977],[],[213,371,433],"f574417a-ff01-11f0-8913-42dde27851f2",220,["D",1769904432638],[246,247,250,252,253,254,255],[213,371],"f7df07f4-0ac0-11f1-9829-42dde27851f2","index.js","5aa6d1ca-f692-11f0-bc77-42dde27851f2","5a5ada90-f692-11f0-965a-42dde27851f2",278,["D",1771195933349],"/**\n * Backend HTTP val (Hono) that:\n * - exposes /api/memories CRUD routes (SQLite via ./database/queries.js)\n * - serves the React frontend from / (index.html)\n * - serves frontend assets from /public/* (maps to /dashboard/frontend/*)\n */\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\n\nimport {\n createMemory,\n deleteMemory,\n getAllMemories,\n updateMemory,\n} from \"./database/queries.js\";\n\nconst app = new Hono();\n\n// Better error output: if the browser wants HTML, return HTML; otherwise JSON.\napp.onError((err, c) => {\n console.error(\"Error in Hono route:\", err);\n\n const accept = c.req.header(\"accept\") ?? \"\";\n const wantsHtml = accept.includes(\"text/html\");\n\n if (wantsHtml) {\n const msg = String(err?.stack ?? err?.message ?? err);\n return c.html(\n `

${msg}

`,\n 500\n );\n }\n\n return c.json(\n { error: \"Internal Server Error\", details: err?.message ?? String(err) },\n 500\n );\n});\n\n// --- Helpers (Blob reading + content types) ---\n\nasync function blobToBytes(data) {\n // Val Town blob.get can return a Response (stream). If so, read it directly.\n if (data instanceof Response) {\n return new Uint8Array(await data.arrayBuffer());\n }\n // Otherwise treat as BodyInit-ish.\n return new Uint8Array(await new Response(data).arrayBuffer());\n}\n\nfunction contentTypeFor(filename) {\n const lower = String(filename).toLowerCase();\n if (lower.endsWith(\".png\")) return \"image/png\";\n if (lower.endsWith(\".jpg\") || lower.endsWith(\".jpeg\")) return \"image/jpeg\";\n if (lower.endsWith(\".gif\")) return \"image/gif\";\n if (lower.endsWith(\".svg\")) return \"image/svg+xml\";\n if (lower.endsWith(\".webp\")) return \"image/webp\";\n return \"application/octet-stream\";\n}\n\n// --- API Routes for Memories ---\n\napp.get(\"/api/memories\", async (c) => {\n const memories = await getAllMemories();\n return c.json(memories);\n});\n\napp.post(\"/api/memories\", async (c) => {\n /** @type {{date?: (string|null), text?: string, createdBy?: (string|null), createdDate?: (number|null), tags?: (string|null)}} */\n const body = await c.req.json();\n\n if (!body?.text) {\n return c.json({ error: \"Memory text cannot be empty\" }, 400);\n }\n\n const newMemory = await createMemory(body);\n return c.json(newMemory, 201);\n});\n\napp.put(\"/api/memories/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n /** @type {Partial<{date: (string|null), text: string, createdBy: (string|null), createdDate: (number|null), tags: (string|null)}>} */\n const body = await c.req.json();\n\n if (!body || Object.keys(body).length === 0) {\n return c.json({ error: \"No update fields provided\" }, 400);\n }\n\n await updateMemory(id, body);\n return c.json({ success: true });\n});\n\napp.delete(\"/api/memories/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n await deleteMemory(id);\n return c.json({ success: true });\n});\n\n// --- Blob Image Serving Routes ---\n\n// --- TEMP: upload a background image into THIS backend's blob store ---\napp.get(\"/api/upload_bg\", (c) =>\n c.html(`\n

Upload logbook_bg.png (to this app's blob store)

\n \n

Then check /api/blob_keys

\n `)\n);\n\napp.post(\"/api/upload_bg\", async (c) => {\n const form = await c.req.formData();\n const file = form.get(\"file\");\n if (!(file instanceof File)) return c.text(\"Missing file\", 400);\n\n const bytes = new Uint8Array(await file.arrayBuffer());\n await blob.set(\"logbook_bg.png\", bytes);\n\n return c.html(`\n

Uploaded logbook_bg.png (${bytes.byteLength} bytes)

\n `);\n});\n\napp.get(\"/api/blob_keys\", async (c) => {\n const keys = await blob.list();\n return c.json({ keys });\n});\n\napp.get(\"/api/images/:filename\", async (c) => {\n const filename = c.req.param(\"filename\");\n console.log(\"images route filename =\", filename);\n\n let data;\n try {\n data = await blob.get(filename);\n } catch (e) {\n console.log(\"blob.get threw for\", filename, e?.name, e?.message);\n return c.json({ error: \"Image not found\", filename, threw: String(e?.name ?? e) }, 404);\n }\n\n if (!data) {\n return c.json({ error: \"Image not found\", filename, got: null }, 404);\n }\n\n const bytes = await blobToBytes(data);\n return new Response(bytes, {\n headers: { \"Content-Type\": contentTypeFor(filename), \"Cache-Control\": \"no-store\" },\n });\n});\n\napp.get(\"/api/images_debug/:filename\", async (c) => {\n const filename = c.req.param(\"filename\");\n\n let data;\n try {\n data = await blob.get(filename);\n } catch {\n return c.json({ ok: false, error: \"not found\" }, 404);\n }\n if (!data) return c.json({ ok: false, error: \"not found\" }, 404);\n\n const bytes = await blobToBytes(data);\n\n // Magic bytes checks (no string formatting edge cases)\n const isPng =\n bytes.length >= 8 &&\n bytes[0] === 0x89 &&\n bytes[1] === 0x50 &&\n bytes[2] === 0x4e &&\n bytes[3] === 0x47 &&\n bytes[4] === 0x0d &&\n bytes[5] === 0x0a &&\n bytes[6] === 0x1a &&\n bytes[7] === 0x0a;\n\n const isJpeg = bytes.length >= 3 && bytes[0] === 0xff && bytes[1] === 0xd8 && bytes[2] === 0xff;\n\n // WEBP starts with \"RIFF....WEBP\"\n const isWebp =\n bytes.length >= 12 &&\n bytes[0] === 0x52 &&\n bytes[1] === 0x49 &&\n bytes[2] === 0x46 &&\n bytes[3] === 0x46 &&\n bytes[8] === 0x57 &&\n bytes[9] === 0x45 &&\n bytes[10] === 0x42 &&\n bytes[11] === 0x50;\n\n let detected = \"unknown\";\n if (isPng) detected = \"png\";\n else if (isJpeg) detected = \"jpeg\";\n else if (isWebp) detected = \"webp\";\n\n const first16 = Array.from(bytes.slice(0, 16))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\" \");\n\n return c.json({\n ok: true,\n filename,\n byteLength: bytes.byteLength,\n first16,\n detected,\n looksLikePng: isPng,\n contentType: contentTypeFor(filename),\n });\n});\n\n// --- (Optional) Debug route ---\n// Handy to confirm you’re hitting the correct HTTP val.\napp.get(\"/__debug\", (c) => {\n return c.json({\n ok: true,\n hint: \"Try /, /public/index.tsx, /public/components/App.tsx, /public/style.css\",\n url: c.req.url,\n });\n});\n\n// --- Static File Serving (Frontend) ---\n\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/dashboard/frontend/index.html\", import.meta.url);\n\n // OPTIONAL: bootstrap initial data like the Stevens demo template.\n // If your memories table is large, you might want to remove this and let the\n // frontend fetch instead.\n try {\n const memories = await getAllMemories();\n const initial = ``;\n html = html.replace(\"\", `${initial}`);\n } catch (e) {\n console.warn(\"Failed to bootstrap __INITIAL_DATA:\", e);\n }\n\n // Inject view source link\n const viewSourceLink = import.meta.url.replace(\"esm.town\", \"val.town\");\n const viewSourceTag =\n `View Source`;\n html = html.replace(\"\", `${viewSourceTag}`);\n\n return c.html(html);\n});\n\n// Serve all frontend files under /public/*\n// Maps /public/whatever -> /dashboard/frontend/whatever\napp.get(\"/public/*\", (c) => {\n const filePath = c.req.path.replace(/^\\/public/, \"/dashboard/frontend\");\n return serveFile(filePath, import.meta.url);\n});\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;",[],[213,453,445],"backend","39359de6-ffa7-11f0-9a7c-42dde27851f2","queries.js","5aa17086-f692-11f0-bc77-42dde27851f2","5a7b6ba2-f692-11f0-b45d-42dde27851f2",255,["D",1769975413280],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE = \"memories\";\n\n// Only allow updating these columns (prevents column-name injection)\nconst UPDATABLE_COLUMNS = new Set([\"date\", \"text\", \"createdBy\", \"createdDate\", \"tags\"]);\n\nfunction normalizeRow(row) {\n return {\n id: row?.id != null ? String(row.id) : \"\",\n date: row?.date == null ? null : String(row.date),\n text: row?.text != null ? String(row.text) : \"\",\n createdBy: row?.createdBy == null ? null : String(row.createdBy),\n createdDate: row?.createdDate == null ? null : Number(row.createdDate),\n tags: row?.tags == null ? null : String(row.tags),\n };\n}\n\n/** @returns {Promise>} */\nexport async function getAllMemories() {\n const result = await sqlite.execute({\n sql: `\n SELECT id, date, text, createdBy, createdDate, tags\n FROM ${TABLE}\n ORDER BY createdDate DESC\n `,\n args: [],\n });\n\n return (result.rows || []).map(normalizeRow);\n}\n\n/**\n * @param {Object} memory - Memory without id\n * @returns {Promise

Diff · v302