[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_307":308,"_309":310},"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",81,"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/migrateDb.js","latestPath","fileId","5ac21822-f692-11f0-9437-42dde27851f2","name","migrateDb.js","fileType","script","content","// Script to migrate the memories table in SQLite\n// Run this script manually to add new columns to the memories table\n\nexport default async function migrateDb() {\n try {\n // Import SQLite module\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // First, backup the current table contents\n const backup = await sqlite.execute(`SELECT * FROM memories`);\n console.log(\"Backup of memories table (JSON format):\");\n console.log(JSON.stringify(backup.rows, null, 2));\n\n // Create a new table with the updated schema\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS memories_new (\n id TEXT,\n date TEXT,\n text TEXT,\n createdBy TEXT,\n createdDate INTEGER,\n tags TEXT\n )\n `);\n\n // Copy data from old table to new table\n await sqlite.execute(`\n INSERT INTO memories_new (date, text)\n SELECT date, text FROM memories\n `);\n\n // Drop the old table\n await sqlite.execute(`DROP TABLE memories`);\n\n // Rename the new table to the original name\n await sqlite.execute(`ALTER TABLE memories_new RENAME TO memories`);\n\n // Create an index on id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_memories_id ON memories(id)\n `);\n\n return \"Memories table migrated successfully with new columns.\";\n } catch (error) {\n console.error(\"Error migrating memories table:\", error);\n throw error;\n }\n}\n\nmigrateDb();\n","createdAt",["D",1768976889675],"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=1789534799&sig=d8fafca652e90b276ed4f858de659a0beee27374951f12938e09430a5dfb9268","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":302,"_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":303,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":304,"_81":305,"_83":306,"_85":24},"tree",[186,188,189,194,199,202],"files",[186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202],"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":299,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":300,"_26":301},{"_42":293,"_31":170,"_29":294,"_136":171,"_40":41,"_39":295,"_138":24,"_37":296,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":297,"_26":298},{"_42":163,"_31":164,"_29":165,"_136":-5,"_40":41,"_39":166,"_138":147,"_37":290,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":291,"_26":292},{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":147,"_37":287,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":288,"_26":289},{"_42":282,"_31":266,"_29":260,"_136":159,"_40":41,"_39":283,"_138":147,"_37":284,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":285,"_26":286},{"_42":277,"_31":276,"_29":270,"_136":260,"_40":41,"_39":278,"_138":147,"_37":279,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":280,"_26":281},{"_42":267,"_31":268,"_29":269,"_136":270,"_40":41,"_39":271,"_138":24,"_37":272,"_13":60,"_33":34,"_35":273,"_23":24,"_141":-5,"_204":274,"_26":275},{"_42":257,"_31":258,"_29":259,"_136":260,"_40":41,"_39":261,"_138":24,"_37":262,"_13":60,"_33":34,"_35":263,"_23":24,"_141":-5,"_204":264,"_26":265},{"_42":151,"_31":152,"_29":153,"_136":-5,"_40":41,"_39":154,"_138":147,"_37":254,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":255,"_26":256},{"_42":250,"_31":32,"_29":30,"_136":153,"_40":41,"_39":14,"_138":24,"_37":251,"_13":60,"_33":34,"_35":36,"_23":24,"_141":-5,"_204":252,"_26":253},{"_42":242,"_31":243,"_29":244,"_136":153,"_40":41,"_39":245,"_138":24,"_37":246,"_13":60,"_33":34,"_35":247,"_23":24,"_141":-5,"_204":248,"_26":249},{"_42":234,"_31":235,"_29":236,"_136":153,"_40":41,"_39":237,"_138":24,"_37":238,"_13":60,"_33":34,"_35":239,"_23":24,"_141":-5,"_204":240,"_26":241},{"_42":226,"_31":227,"_29":228,"_136":153,"_40":41,"_39":229,"_138":24,"_37":230,"_13":60,"_33":34,"_35":231,"_23":24,"_141":-5,"_204":232,"_26":233},{"_42":143,"_31":144,"_29":145,"_136":-5,"_40":41,"_39":146,"_138":147,"_37":223,"_13":60,"_33":149,"_35":-5,"_23":24,"_141":-5,"_204":224,"_26":225},{"_42":215,"_31":216,"_29":217,"_136":145,"_40":41,"_39":218,"_138":24,"_37":219,"_13":60,"_33":34,"_35":220,"_23":24,"_141":-5,"_204":221,"_26":222},{"_42":207,"_31":208,"_29":209,"_136":145,"_40":41,"_39":210,"_138":24,"_37":211,"_13":60,"_33":34,"_35":212,"_23":24,"_141":-5,"_204":213,"_26":214},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":203,"_13":60,"_33":34,"_35":140,"_23":24,"_141":-5,"_204":205,"_26":206},["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,208],"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,216],["D",1768970077837],[200,201],[144],"5ab9be3e-f692-11f0-9451-42dde27851f2","setupDiscordDb.js","5ab9c000-f692-11f0-9451-42dde27851f2",80,["D",1768976889622],"// Script to set up the discord_messages table in SQLite\n// Run this script manually to create the database table\n\nexport default async function setupDiscordDb() {\n try {\n // Import SQLite module\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Create the discord_messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS discord_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n channel_id TEXT NOT NULL,\n author_id TEXT NOT NULL,\n author_name TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp INTEGER NOT NULL,\n is_bot BOOLEAN NOT NULL\n )\n `);\n\n // Create an index on channel_id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_discord_messages_channel_id ON discord_messages(channel_id)\n `);\n\n return \"Discord messages database table created successfully.\";\n } catch (error) {\n console.error(\"Error setting up discord_messages table:\", error);\n throw error;\n }\n}\n",[],[152,227],"5ab6625c-f692-11f0-bc77-42dde27851f2","populateIds.js","5ab6632e-f692-11f0-bc77-42dde27851f2",79,["D",1768976889598],"// Script to populate random IDs for existing memory rows\n// Run this script manually to generate IDs for 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 // Import SQLite module\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Get all rows without an ID\n const rowsWithoutId = await sqlite.execute(`\n SELECT rowid FROM memories WHERE id IS NULL OR id = ''\n `);\n\n console.log(\n `Found ${rowsWithoutId.rows.length} rows without IDs. Generating IDs...`\n );\n\n // Update each row with a unique ID\n let updatedCount = 0;\n for (const row of rowsWithoutId.rows) {\n const id = nanoid(10); // Generate a 10-character ID\n await sqlite.execute({\n sql: `UPDATE memories SET id = :id, createdDate = :timestamp WHERE rowid = :rowid`,\n args: {\n id,\n timestamp: Date.now(),\n rowid: row.rowid,\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}",[],[152,235],"5aae2cf4-f692-11f0-85b0-42dde27851f2","populateCreatedBys.js","5aae2d94-f692-11f0-85b0-42dde27851f2",78,["D",1768976889546],"// 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",[],[152,243],"5ac21700-f692-11f0-9437-42dde27851f2",["D",1768976889675],[],[152,32],["D",1768976888702],[195,196,197,198],[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,266,258],"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 · v81