[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_259":260,"_261":262},"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",76,"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","dashboard/backend/index.js","latestPath","fileId","5aa6d1ca-f692-11f0-bc77-42dde27851f2","name","index.js","fileType","script","content","/**\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;","createdAt",["D",1768976889497],"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=1789567199&sig=f4ed57ca7b58c6c785b6957f9fdcaa7e643b0b9262d2c82f0468df79d6f17df8","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",{"_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":254,"_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":255,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":256,"_81":257,"_83":258,"_85":24},"tree",[178,180,181,186,187],"files",[178,179,180,181,182,183,184,185,186,187,188,189],"counts",{"_167":60,"_168":136,"_169":60,"_170":171,"_172":173},"contents",[127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":161,"_31":162,"_29":163,"_135":-5,"_40":41,"_39":164,"_137":24,"_37":165,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_26":166},{"_42":155,"_31":156,"_29":157,"_135":-5,"_40":41,"_39":158,"_137":138,"_37":159,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_26":160},{"_42":149,"_31":150,"_29":151,"_135":-5,"_40":41,"_39":152,"_137":138,"_37":153,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_26":154},{"_42":143,"_31":144,"_29":145,"_135":-5,"_40":41,"_39":146,"_137":138,"_37":147,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_26":148},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":138,"_37":139,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_26":142},"7e97cc8e-f682-11f0-b864-42dde27851f2","importers","7e97cd56-f682-11f0-b864-42dde27851f2","parentId",1,"latest",true,["D",1768970077837],"directory","label",[133],"5a2d5584-f692-11f0-80a8-42dde27851f2","dbUtils","5a2d5660-f692-11f0-80a8-42dde27851f2",68,["D",1768976888702],[144],"7ea69688-f682-11f0-8450-42dde27851f2","dashboard","7ea69782-f682-11f0-8450-42dde27851f2",2,["D",1768970077944],[150],"5a4c33d2-f692-11f0-a8c3-42dde27851f2","dailyGreeting","5a4c347c-f692-11f0-a8c3-42dde27851f2",69,["D",1768976888903],[156],"6400b8dc-f68b-11f0-969a-42dde27851f2","bilbo-the-butler","6400b990-f68b-11f0-969a-42dde27851f2",40,["D",1768973898708],[162],"pulls","branches","forks","envVars",{"_174":176,"_177":60},"connections",{"_174":60,"_175":60},"count","unfilledCount",7,"emptyCount",{"_42":161,"_31":162,"_29":163,"_135":-5,"_40":41,"_39":164,"_137":24,"_37":251,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":252,"_26":253},{"_42":245,"_31":162,"_29":246,"_135":163,"_40":41,"_39":247,"_137":24,"_37":248,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":249,"_26":250},{"_42":155,"_31":156,"_29":157,"_135":-5,"_40":41,"_39":158,"_137":138,"_37":242,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":243,"_26":244},{"_42":149,"_31":150,"_29":151,"_135":-5,"_40":41,"_39":152,"_137":138,"_37":239,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":240,"_26":241},{"_42":234,"_31":218,"_29":214,"_135":151,"_40":41,"_39":235,"_137":138,"_37":236,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":237,"_26":238},{"_42":229,"_31":228,"_29":222,"_135":214,"_40":41,"_39":230,"_137":138,"_37":231,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":232,"_26":233},{"_42":219,"_31":220,"_29":221,"_135":222,"_40":41,"_39":223,"_137":24,"_37":224,"_13":60,"_33":34,"_35":225,"_23":24,"_141":-5,"_196":226,"_26":227},{"_42":213,"_31":32,"_29":30,"_135":214,"_40":41,"_39":14,"_137":24,"_37":215,"_13":60,"_33":34,"_35":36,"_23":24,"_141":-5,"_196":216,"_26":217},{"_42":143,"_31":144,"_29":145,"_135":-5,"_40":41,"_39":146,"_137":138,"_37":210,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":211,"_26":212},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":138,"_37":207,"_13":60,"_33":140,"_35":-5,"_23":24,"_141":-5,"_196":208,"_26":209},{"_42":199,"_31":200,"_29":201,"_135":134,"_40":41,"_39":202,"_137":24,"_37":203,"_13":60,"_33":34,"_35":204,"_23":24,"_141":-5,"_196":205,"_26":206},{"_42":190,"_31":191,"_29":192,"_135":134,"_40":41,"_39":193,"_137":24,"_37":194,"_13":60,"_33":34,"_35":195,"_23":24,"_141":-5,"_196":197,"_26":198},"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","children",[],[133,191],"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",[],[133,200],["D",1768970077837],[188,189],[133],["D",1768976888702],[],[144],"5aa6d102-f692-11f0-bc77-42dde27851f2","5a5ada90-f692-11f0-965a-42dde27851f2",["D",1768976889497],[],[150,218,32],"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 · v76