[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_280":281,"_282":283},"routes/_app.x.$handle.$name",{"_97":96,"_31":44,"_105":87,"_26":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":24,"_120":121,"_122":24,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":53,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":24},"version",78,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","dbUtils/populateCreatedBys.js","latestPath","fileId","5aae2d94-f692-11f0-85b0-42dde27851f2","name","populateCreatedBys.js","fileType","script","content","// Script to populate createdBy for existing memory rows\n// Run this script manually to set createdBy based on memory content\n\nexport default async function populateCreatedBy() {\n try {\n // Import SQLite module\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Get all rows without a createdBy\n const rowsWithoutCreatedBy = await sqlite.execute(`\n SELECT rowid, text FROM memories WHERE createdBy IS NULL OR createdBy = ''\n `);\n\n console.log(\n `Found ${rowsWithoutCreatedBy.rows.length} rows without createdBy. Populating...`\n );\n\n // Update each row with the appropriate createdBy\n let updatedCount = 0;\n for (const row of rowsWithoutCreatedBy.rows) {\n let createdBy = \"chat\"; // Default value\n const text = row.text?.toLowerCase() || \"\";\n\n // Determine createdBy based on text content\n if (text.includes(\"weather\")) {\n createdBy = \"weather\";\n } else if (text.includes(\"expecting\")) {\n createdBy = \"usps\";\n }\n\n // Set tags based on createdBy\n let tags = \"\";\n if (createdBy === \"weather\") {\n tags = \"weather\";\n } else if (createdBy === \"usps\") {\n tags = \"mail\";\n }\n\n await sqlite.execute({\n sql: `UPDATE memories\n SET createdBy = :createdBy,\n tags = :tags,\n createdDate = COALESCE(createdDate, :timestamp)\n WHERE rowid = :rowid`,\n args: {\n createdBy,\n tags,\n timestamp: Date.now(),\n rowid: row.rowid,\n },\n });\n updatedCount++;\n }\n\n console.log(\n `Successfully updated ${updatedCount} rows with createdBy values.`\n );\n return `Successfully updated ${updatedCount} rows with createdBy values.`;\n } catch (error) {\n console.error(\"Error populating createdBy:\", error);\n throw error;\n }\n}\n\n// Uncomment to run directly\n// populateCreatedBy();\n","createdAt",["D",1768976889546],"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=1789538399&sig=cc54063ab77abc8a7ba6f9f7d130637fa0d91d11027045d7228cff3e687f5cd6","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",1789445472057],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":24},"branch",{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"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",{"_42":43,"_31":44,"_37":275,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":53,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":276,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":277,"_81":278,"_83":279,"_85":24},"tree",[186,188,189,194,196,199],"files",[186,187,188,189,190,191,192,193,194,195,196,197,198,199],"counts",{"_175":60,"_176":146,"_177":60,"_178":179,"_180":181},"contents",[127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":169,"_31":170,"_29":171,"_136":-5,"_40":41,"_39":172,"_138":24,"_37":173,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_26":174},{"_42":163,"_31":164,"_29":165,"_136":-5,"_40":41,"_39":166,"_138":147,"_37":167,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_26":168},{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":147,"_37":161,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_26":162},{"_42":151,"_31":152,"_29":153,"_136":-5,"_40":41,"_39":154,"_138":147,"_37":155,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_26":156},{"_42":143,"_31":144,"_29":145,"_136":-5,"_40":41,"_39":146,"_138":147,"_37":148,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_26":150},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":139,"_13":60,"_33":34,"_35":140,"_23":24,"_141":-5,"_26":142},"5aab9ec6-f692-11f0-80a8-42dde27851f2","backstory.js","5aaba13c-f692-11f0-80a8-42dde27851f2","parentId",77,"latest",["D",1768976889506],"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 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`;\n","label",[134],"7e97cc8e-f682-11f0-b864-42dde27851f2","importers","7e97cd56-f682-11f0-b864-42dde27851f2",1,true,["D",1768970077837],"directory",[144],"5a2d5584-f692-11f0-80a8-42dde27851f2","dbUtils","5a2d5660-f692-11f0-80a8-42dde27851f2",68,["D",1768976888702],[152],"7ea69688-f682-11f0-8450-42dde27851f2","dashboard","7ea69782-f682-11f0-8450-42dde27851f2",2,["D",1768970077944],[158],"5a4c33d2-f692-11f0-a8c3-42dde27851f2","dailyGreeting","5a4c347c-f692-11f0-a8c3-42dde27851f2",69,["D",1768976888903],[164],"6400b8dc-f68b-11f0-969a-42dde27851f2","bilbo-the-butler","6400b990-f68b-11f0-969a-42dde27851f2",40,["D",1768973898708],[170],"pulls","branches","forks","envVars",{"_182":184,"_185":60},"connections",{"_182":60,"_183":60},"count","unfilledCount",7,"emptyCount",{"_42":169,"_31":170,"_29":171,"_136":-5,"_40":41,"_39":172,"_138":24,"_37":272,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":273,"_26":274},{"_42":266,"_31":170,"_29":267,"_136":171,"_40":41,"_39":268,"_138":24,"_37":269,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":270,"_26":271},{"_42":163,"_31":164,"_29":165,"_136":-5,"_40":41,"_39":166,"_138":147,"_37":263,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":264,"_26":265},{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":147,"_37":260,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":261,"_26":262},{"_42":255,"_31":239,"_29":233,"_136":159,"_40":41,"_39":256,"_138":147,"_37":257,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":258,"_26":259},{"_42":250,"_31":249,"_29":243,"_136":233,"_40":41,"_39":251,"_138":147,"_37":252,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":253,"_26":254},{"_42":240,"_31":241,"_29":242,"_136":243,"_40":41,"_39":244,"_138":24,"_37":245,"_13":60,"_33":34,"_35":246,"_23":24,"_141":-5,"_201":247,"_26":248},{"_42":230,"_31":231,"_29":232,"_136":233,"_40":41,"_39":234,"_138":24,"_37":235,"_13":60,"_33":34,"_35":236,"_23":24,"_141":-5,"_201":237,"_26":238},{"_42":151,"_31":152,"_29":153,"_136":-5,"_40":41,"_39":154,"_138":147,"_37":227,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":228,"_26":229},{"_42":223,"_31":32,"_29":30,"_136":153,"_40":41,"_39":14,"_138":24,"_37":224,"_13":60,"_33":34,"_35":36,"_23":24,"_141":-5,"_201":225,"_26":226},{"_42":143,"_31":144,"_29":145,"_136":-5,"_40":41,"_39":146,"_138":147,"_37":220,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_201":221,"_26":222},{"_42":212,"_31":213,"_29":214,"_136":145,"_40":41,"_39":215,"_138":24,"_37":216,"_13":60,"_33":34,"_35":217,"_23":24,"_141":-5,"_201":218,"_26":219},{"_42":204,"_31":205,"_29":206,"_136":145,"_40":41,"_39":207,"_138":24,"_37":208,"_13":60,"_33":34,"_35":209,"_23":24,"_141":-5,"_201":210,"_26":211},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":200,"_13":60,"_33":34,"_35":140,"_23":24,"_141":-5,"_201":202,"_26":203},["D",1768976889506],"children",[],[134],"5a97cb76-f692-11f0-b45d-42dde27851f2","getWeather.js","5a97cc98-f692-11f0-b45d-42dde27851f2",73,["D",1768976889399],"import { getWeather } from \"https://esm.town/v/emdu-07/getWeather\";\nimport { sqlite } from \"https://esm.town/v/emdu-07/sqlite\";\nimport Anthropic from \"npm:@anthropic-ai/sdk@0.24.3\";\n\nconst TABLE_NAME = \"memories\";\n\nfunction summarizeWeather(weather) {\n const summarizeDay = (day) => ({\n date: day.date,\n highTemp: day.maxtempF,\n lowTemp: day.mintempF,\n hourly:\n day.hourly?.map((hour) => ({\n time: hour.time,\n temp: hour.tempF,\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 generateConciseWeatherSummary(weatherDay) {\n try {\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n if (!apiKey) {\n console.error(\"Anthropic API key is not configured.\");\n return null;\n }\n\n const anthropic = new Anthropic({ apiKey });\n\n const response = await anthropic.messages.create({\n model: \"claude-3-5-sonnet-latest\",\n max_tokens: 150,\n messages: [\n {\n role: \"user\",\n content: [\n {\n type: \"text\",\n text: `\nYou are a weather forecaster. Create a very concise summary of this weather forecast data.\nInclude the high and low temperatures and a brief summary of the overall weather conditions throughout the day.\nThe summary should be helpful for someone planning their day - mention any precipitation, temperature changes, or other notable patterns.\nKeep it under 25 words if possible, no more than one sentence. Don't include the date.\n\nExamples:\n- \"High of 50, low of 31, clear and sunny all day.\"\n- \"High of 80, low of 50, cool and clear morning, warmer afternoon with scattered showers starting around 2pm.\"\n\nWeather data:\n${JSON.stringify(weatherDay, null, 2)}\n\nYour concise summary:\n`,\n },\n ],\n },\n ],\n });\n\n let summary = (response?.content?.[0]?.text || \"\").trim();\n\n summary = summary.replace(/^(your concise summary:)/i, \"\").trim();\n summary = summary.replace(/^[\"']|[\"']$/g, \"\").trim();\n\n return summary;\n } catch (error) {\n console.error(\"Error generating weather summary:\", error);\n return JSON.stringify(weatherDay); // fallback\n }\n}\n\nasync function deleteExistingForecast(date) {\n await sqlite.execute(\n `\n DELETE FROM ${TABLE_NAME}\n WHERE date = ? AND text LIKE 'weather forecast:%'\n `,\n [date]\n );\n}\n\nasync function insertForecast(date, forecast) {\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\n\n await sqlite.execute(\n `\n INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)\n `,\n [\n nanoid(10),\n date,\n `weather forecast: ${forecast}`,\n \"weather\",\n Date.now(),\n \"weather\",\n ]\n );\n}\n\nexport default async function getWeatherForecast(interval) {\n const weather = await getWeather(\"Waterloo, Ontario\");\n console.log({ weather });\n\n const summary = summarizeWeather(weather);\n\n for (const day of summary) {\n const date = new Date(day.date).toISOString().split(\"T\")[0];\n\n const conciseSummary = await generateConciseWeatherSummary(day);\n const forecastText = conciseSummary || JSON.stringify(day);\n\n await deleteExistingForecast(date);\n await insertForecast(date, forecastText);\n }\n\n console.log(\"Weather forecast updated in the database.\");\n return summary;\n}\n",[],[144,205],"5a9a9568-f692-11f0-9451-42dde27851f2","getCalendarEvents.js","5a9a9662-f692-11f0-9451-42dde27851f2",74,["D",1768976889402],"import { getEvents } from \"https://esm.town/v/geoffreylitt/getGoogleCalendarEvents\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { DateTime } from \"https://esm.sh/luxon@3.4.4\";\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\n// Helper function to extract time from ISO string without timezone conversion\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",[],[144,213],["D",1768970077837],[197,198],[144],"5aae2cf4-f692-11f0-85b0-42dde27851f2",["D",1768976889546],[],[152,32],["D",1768976888702],[195],[152],"5aa6d102-f692-11f0-bc77-42dde27851f2","index.js","5aa6d1ca-f692-11f0-bc77-42dde27851f2","5a5ada90-f692-11f0-965a-42dde27851f2",76,["D",1768976889497],"/**\n * @jsxImportSource https://esm.sh/react@18.2.0\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\";\nimport {\n createMemory,\n deleteMemory,\n getAllMemories,\n updateMemory,\n} from \"./database/queries.js\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error in Hono route:\", err);\n return c.json({ error: \"Internal Server Error\", details: err?.message ?? String(err) }, 500);\n});\n\n// --- API Routes for Memories ---\n\n// GET /api/memories - Retrieve all memories\napp.get(\"/api/memories\", async (c) => {\n const memories = await getAllMemories();\n return c.json(memories);\n});\n\n// POST /api/memories - Create a new memory\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\n// PUT /api/memories/:id - Update an existing memory\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 try {\n await updateMemory(id, body);\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating memory:\", error);\n return c.json(\n { error: \"Failed to update memory\", details: error?.message ?? String(error) },\n 500\n );\n }\n});\n\n// DELETE /api/memories/:id - Delete a memory\napp.delete(\"/api/memories/:id\", async (c) => {\n const id = c.req.param(\"id\");\n\n try {\n await deleteMemory(id);\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting memory:\", error);\n return c.json(\n { error: \"Failed to delete memory\", details: error?.message ?? String(error) },\n 500\n );\n }\n});\n\n// --- Blob Image Serving Routes ---\n\n// GET /api/images/:filename - Serve images from blob storage\napp.get(\"/api/images/:filename\", async (c) => {\n const filename = c.req.param(\"filename\");\n\n try {\n const imageData = await blob.get(filename);\n\n if (!imageData) {\n return c.json({ error: \"Image not found\" }, 404);\n }\n\n // Determine content type based on file extension\n let contentType = \"application/octet-stream\";\n if (filename.endsWith(\".jpg\") || filename.endsWith(\".jpeg\")) contentType = \"image/jpeg\";\n else if (filename.endsWith(\".png\")) contentType = \"image/png\";\n else if (filename.endsWith(\".gif\")) contentType = \"image/gif\";\n else if (filename.endsWith(\".svg\")) contentType = \"image/svg+xml\";\n\n return new Response(imageData, {\n headers: {\n \"Content-Type\": contentType,\n \"Cache-Control\": \"public, max-age=3600\",\n },\n });\n } catch (error) {\n console.error(`Error serving image ${filename}:`, error);\n return c.json(\n { error: \"Failed to load image\", details: error?.message ?? String(error) },\n 500\n );\n }\n});\n\n// --- Static File Serving ---\n\n// Serve index.html at the root /\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/dashboard/frontend/index.html\", import.meta.url);\n\n // Inject view source link\n const viewSourceLink = import.meta.url.replace(\"esm.town\", \"val.town\");\n const viewSourceTag = `View Source`;\n html = html.replace(\"\", `${viewSourceTag}`);\n\n return c.html(html);\n});\n\n// Serve all /frontend files (except index.html) under /public\napp.get(\"/public/*\", (c) =>\n serveFile(\n c.req.path.replace(\"/public\", \"/dashboard/frontend\"),\n import.meta.url\n )\n);\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;",[],[158,239,231],"backend","5aa16ff0-f692-11f0-bc77-42dde27851f2","queries.js","5aa17086-f692-11f0-bc77-42dde27851f2","5a7b6ba2-f692-11f0-b45d-42dde27851f2",75,["D",1768976889417],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// toggle the commented out table name to switch between the demo and production tables\n// const tableName = \"memories\";\nconst tableName = \"memories_demo\";\n\n/**\n * If you want runtime “type hints”, here’s the shape:\n * Memory = {\n * id: string,\n * date: string|null,\n * text: string,\n * createdBy: string|null,\n * createdDate: number|null,\n * tags: string|null,\n * }\n */\n\n/** @returns {Promise>} */\nexport async function getAllMemories() {\n const result = await sqlite.execute(\n `SELECT id, date, text, createdBy, createdDate, tags\n FROM ${tableName}\n ORDER BY createdDate DESC`\n );\n\n // Normalize/guard nulls and types (sqlite rows can be loosely typed)\n return (result.rows || []).map((row) => ({\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/**\n * @param {Object} memory - Memory without id\n * @returns {Promise

Diff · v78