Memory Assistant Bot

This bot helps you remember important information.

`,\n { status: 200, headers: { \"content-type\": \"text/html\" } }\n );\n}\n",[194,198],"24b62f303f8b8b951ccfedc0bc43c3c6de9a18d8388324694167f6b06d0df600","importers/getWeather.ts",{"_32":207,"_13":208,"_81":209,"_83":188,"_85":33,"_86":104,"_88":26,"_34":210,"_40":22,"_91":211,"_93":212,"_67":50,"_95":-5,"_96":-7,"_73":213,"_98":214},"f2b79bcc-17c5-11f0-8a41-569c3dd06744","getWeather.ts","6699c2a1-a1ee-4766-a38c-0d6e5bd3f7d9",["D",1744479939609],"interval","import {\n getWeather,\n WeatherResponse,\n} from \"https://esm.town/v/geoffreylitt/getWeather\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport Anthropic from \"npm:@anthropic-ai/sdk@0.24.3\";\n\nconst TABLE_NAME = `memories`;\n\nfunction summarizeWeather(weather: WeatherResponse) {\n const summarizeDay = (day: WeatherResponse[\"weather\"][number]) => ({\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((desc) => desc.value).join(\", \"),\n })) ?? [],\n });\n return weather.weather.map((day) => summarizeDay(day));\n}\n\nasync function generateConciseWeatherSummary(weatherDay) {\n try {\n // Get API key from environment\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 // Initialize Anthropic client\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 // Extract and clean up the summary\n let summary = response.content[0].text.trim();\n\n // Remove any \"Your concise summary:\" text if it got included\n summary = summary.replace(/^(your concise summary:)/i, \"\").trim();\n\n // Remove quotes if the model included them\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 to JSON if summary fails\n }\n}\n\nasync function deleteExistingForecast(date: string) {\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: string, forecast: string) {\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: number) {\n const weather = await getWeather(\"Washington, DC\");\n console.log({ weather });\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 // Generate concise text summary instead of using JSON\n const conciseSummary = await generateConciseWeatherSummary(day);\n\n // If summary generation failed, it will fall back to JSON\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",[194,208],"5690d5130269851606f7c66500e172ac58b50718373dc233f967ed1cf83bc6b6","importers/getCalendarEvents.ts",{"_32":217,"_13":218,"_81":219,"_83":188,"_85":33,"_86":104,"_88":26,"_34":220,"_40":22,"_91":211,"_93":221,"_67":50,"_95":-5,"_96":-7,"_73":222,"_98":223},"f2b7965e-17c5-11f0-8a41-569c3dd06744","getCalendarEvents.ts","ce218dd4-af20-42e7-918d-ef72d19a689a",["D",1744479939609],"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/New_York\";\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 // Match the time portion of the ISO string\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 // Format as AM/PM\n const period = hours >= 12 ? \"pm\" : \"am\";\n const hour12 = hours % 12 || 12; // Convert 0 to 12 for 12 AM\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 // This is a timed event\n const startTime = extractTimeFromISO(event.start.dateTime);\n const endTime = extractTimeFromISO(event.end.dateTime);\n\n // Get timezone information from the event\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 // Check if timezone is America/New_York or equivalent (-04:00 or -05:00 depending on DST)\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 // Add timezone info if not a local timezone\n if (timezone && !isLocalTimezone) {\n // If it's a named timezone like America/Los_Angeles\n if (timezone.includes(\"/\")) {\n const friendlyTimezone =\n timezone.split(\"/\")[1].replace(\"_\", \" \").toLowerCase() + \" time\";\n text += ` (${friendlyTimezone})`;\n }\n // If it's an offset like +08:00\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 // This is an all-day event\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 // Extract date in YYYY-MM-DD format from ISO string\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",[194,218],"6e18f689037c3d80289a870e319a46854ac20250caf5807bdb66378c3e7d52bf","importers/generateFunFacts.ts",{"_32":226,"_13":227,"_81":228,"_83":188,"_85":33,"_86":104,"_88":26,"_34":229,"_40":22,"_91":211,"_93":230,"_67":50,"_95":-5,"_96":-7,"_73":231,"_98":232},"f2b78ec0-17c5-11f0-8a41-569c3dd06744","generateFunFacts.ts","e9bb9019-5723-4ff9-b0da-b41e1ca8eb25",["D",1744479939609],"import { DateTime } from \"https://esm.sh/luxon@3.4.4\";\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport Anthropic from \"npm:@anthropic-ai/sdk@0.24.3\";\n\nconst TABLE_NAME = `memories`;\nconst TAG_NAME = \"fun_fact\";\n\n/**\n * Retrieves previously generated fun facts from the memories database\n * @returns Array of previous fun facts\n */\nasync function getPreviousFunFacts() {\n try {\n const result = await sqlite.execute(\n `SELECT date(date) as date, text FROM ${TABLE_NAME}\n WHERE tags = ?\n ORDER BY date DESC\n LIMIT 50`,\n [TAG_NAME],\n );\n\n return result.rows || [];\n } catch (error) {\n console.error(\"Error retrieving previous fun facts:\", error);\n return [];\n }\n}\n\n/**\n * Deletes existing fun facts for the specified dates\n * @param dates Array of date strings in ISO format\n */\nasync function deleteExistingFunFacts(dates) {\n try {\n for (const date of dates) {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME}\n WHERE date = ? AND tags = ?`,\n [date, TAG_NAME],\n );\n }\n } catch (error) {\n console.error(\"Error deleting existing fun facts:\", error);\n }\n}\n\n/**\n * Inserts a fun fact into the memories database\n * @param date Date for the fun fact in ISO format\n * @param factText The fun fact text\n */\nasync function insertFunFact(date, factText) {\n try {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n nanoid(10),\n date,\n `fun fact: ${factText}`,\n \"fun_fact_generator\",\n Date.now(),\n TAG_NAME,\n ],\n );\n } catch (error) {\n console.error(`Error inserting fun fact for ${date}:`, error);\n }\n}\n\n/**\n * Generates fun facts for the next 7 days using Claude AI\n * @param previousFacts Previous fun facts to avoid duplication\n * @returns Array of generated fun facts\n */\nasync function generateFunFacts(previousFacts) {\n try {\n // Get API key from environment\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 // Initialize Anthropic client\n const anthropic = new Anthropic({ apiKey });\n\n // Format previous facts for the prompt\n const previousFactsText = previousFacts\n .map((fact) => `- ${fact.date}: ${fact.text}`)\n .join(\"\\n\");\n\n // Get today's date in US Eastern Time\n const today = DateTime.now().setZone(\"America/New_York\").startOf(\"day\");\n\n // Hana's birthday - adjust as needed\n const hanaBirthday = \"2025-03-26\";\n const currentDate = today.toFormat(\"yyyy-MM-dd\");\n\n // Format dates for the next 7 days\n const nextSevenDays = Array.from({ length: 7 }, (_, i) => {\n const date = today.plus({ days: i });\n return date.toFormat(\"yyyy-MM-dd\");\n });\n\n const message =\n `Generate 7 unique fun facts, one for each of the next 7 days. Each fact should be brief (1-2 sentences) and relate to one of these categories:\n\n1. Infant development appropriate for Miss Hana, who was born on ${hanaBirthday} (today is ${currentDate})\n2. Cute animals: capybaras, border collies, elephants, or penguins\n3. Plants: monsteras, orchids, ficus, or other common houseplants\n\nRequirements:\n- Each fact must be interesting, educational, and appropriate for formal communication\n- Keep each fact to 1-2 sentences maximum\n- Use different categories across the 7 days for variety\n- Ensure facts are scientifically accurate\n- Make infant development facts age-appropriate for Miss Hana based on her birthdate\n- Do not repeat any previous facts from this list:\n\n${previousFactsText}\n\nFORMAT YOUR RESPONSE AS STRUCTURED JSON INSIDE XML TAGS:\n\n[\n {\n \"date\": \"YYYY-MM-DD\",\n \"text\": \"The fun fact text here\",\n \"category\": \"infant\" | \"animal\" | \"plant\"\n },\n ... (repeat for all 7 days)\n]\n\n\nUse these dates for the 7 facts:\n${nextSevenDays.join(\"\\n\")}`;\n\n console.log({ message });\n\n const response = await anthropic.messages.create({\n model: \"claude-3-5-sonnet-latest\",\n max_tokens: 1000,\n messages: [\n {\n role: \"user\",\n content: [\n {\n type: \"text\",\n text: message,\n },\n ],\n },\n ],\n });\n\n // Extract and parse the response\n const responseText = response.content[0].text.trim();\n\n // Extract JSON between tags\n const factsMatch = responseText.match(/([\\s\\S]*?)<\\/facts>/);\n\n if (!factsMatch || factsMatch.length < 2) {\n console.error(\"Failed to parse facts from response:\", responseText);\n return [];\n }\n\n try {\n // Parse the JSON from the extracted content\n const factData = JSON.parse(factsMatch[1]);\n\n // Validate and format facts\n const facts = factData.map((fact) => ({\n date: fact.date,\n text: fact.text,\n category: fact.category,\n }));\n\n return facts;\n } catch (parseError) {\n console.error(\"Failed to parse facts JSON:\", parseError);\n console.log(\"Raw response:\", responseText);\n\n // Fallback to regex parsing if JSON parsing fails\n return parseFallbackFacts(responseText, nextSevenDays);\n }\n } catch (error) {\n console.error(\"Error generating fun facts:\", error);\n return [];\n }\n}\n\n/**\n * Fallback parser for when JSON parsing fails\n * @param responseText The raw response text from Claude\n * @param expectedDates Array of expected dates for facts\n * @returns Array of parsed facts\n */\nfunction parseFallbackFacts(responseText, expectedDates) {\n // Try to extract facts using regex\n const factPattern = /(\\d{4}-\\d{2}-\\d{2})[\"']?[,:]?\\s*[\"']?(.*?)[\"']?[,}]/gs;\n const facts = [];\n let match;\n\n while ((match = factPattern.exec(responseText)) !== null) {\n if (match.length >= 3) {\n facts.push({\n date: match[1],\n text: match[2].trim(),\n });\n }\n }\n\n // If we couldn't extract any facts, try another approach\n if (facts.length === 0) {\n // Look for quoted text that might be facts\n const lines = responseText.split(\"\\n\");\n let currentDate = null;\n\n for (let i = 0; i < lines.length; i++) {\n const line = lines[i].trim();\n\n // Check if this line contains a date\n const dateMatch = line.match(/(\\d{4}-\\d{2}-\\d{2})/);\n if (dateMatch) {\n currentDate = dateMatch[1];\n } else if (currentDate && line.length > 10) {\n // If we have a date and this is a non-empty line, treat it as a fact\n facts.push({\n date: currentDate,\n text: line.replace(/[\"']/g, \"\").trim(),\n });\n currentDate = null;\n }\n }\n }\n\n // As a last resort, assign facts to dates in order\n if (facts.length === 0 && expectedDates.length > 0) {\n // Extract any sentences that look like facts\n const sentences = responseText.match(/[^.!?]+[.!?]+/g) || [];\n\n for (let i = 0; i < Math.min(sentences.length, expectedDates.length); i++) {\n let factText = sentences[i].trim();\n\n // Clean up the fact text\n factText = factText.replace(/[\"']/g, \"\").trim();\n\n if (factText.length > 10) {\n facts.push({\n date: expectedDates[i],\n text: factText,\n });\n }\n }\n }\n\n return facts;\n}\n\n/**\n * Main function to generate and store fun facts for the next 7 days\n */\nexport async function generateAndStoreFunFacts() {\n try {\n // Get previous fun facts\n const previousFacts = await getPreviousFunFacts();\n\n // Generate new fun facts\n const newFacts = await generateFunFacts(previousFacts);\n\n if (!newFacts || newFacts.length === 0) {\n console.error(\"Failed to generate fun facts\");\n return \"Failed to generate fun facts\";\n }\n\n // Get dates for the next 7 days\n const today = DateTime.now().setZone(\"America/New_York\").startOf(\"day\");\n const nextSevenDays = Array.from({ length: 7 }, (_, i) => {\n return today.plus({ days: i }).toFormat(\"yyyy-MM-dd\");\n });\n\n // Delete existing fun facts for these dates\n await deleteExistingFunFacts(nextSevenDays);\n\n // Insert new fun facts\n for (const fact of newFacts) {\n await insertFunFact(fact.date, fact.text);\n }\n\n console.log(`Generated and stored ${newFacts.length} fun facts`);\n return `Generated and stored ${newFacts.length} fun facts`;\n } catch (error) {\n console.error(\"Error in generateAndStoreFunFacts:\", error);\n return \"Error generating fun facts\";\n }\n}\n\n/**\n * Cron job entry point - runs weekly to generate fun facts for the next 7 days\n * Intended to be used as a Val Town cron job\n */\nexport default async function() {\n console.log(\"Running fun facts generation cron job...\");\n return await generateAndStoreFunFacts();\n}\n\n// For testing with Deno directly\nif (import.meta.main) {\n await generateAndStoreFunFacts();\n}",[194,227],"833fbed10b31312e14d91ef907ec0d4946e223888d48f4e72e33bac2181364ed",{"_32":234,"_13":194,"_81":188,"_83":-5,"_85":33,"_86":104,"_88":26,"_34":235,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":237,"_98":-5},"f2b7ce1c-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],"directory",[194],"dbUtils/setupTelegramChatDb.ts",{"_32":240,"_13":241,"_81":242,"_83":243,"_85":33,"_86":104,"_88":26,"_34":244,"_40":22,"_91":92,"_93":245,"_67":50,"_95":-5,"_96":-7,"_73":246,"_98":247},"f2b78b5a-17c5-11f0-8a41-569c3dd06744","setupTelegramChatDb.ts","16fda3c1-3372-4173-a598-1a30f037552c","8a8535a3-c2cd-46d0-9b31-d1f750cf731f",["D",1744479939609],"// Script to set up the telegram_chats table in SQLite\n// Run this script manually to create the database table\n\nexport default async function setupTelegramChatDb() {\n try {\n // Import SQLite module\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Create the telegram_chats table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS telegram_chats (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id INTEGER NOT NULL,\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 BOOLEAN NOT NULL\n )\n `);\n\n // Create an index on chat_id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_telegram_chats_chat_id ON telegram_chats(chat_id)\n `);\n\n return \"Telegram chat database table created successfully.\";\n } catch (error) {\n console.error(\"Error setting up telegram_chats table:\", error);\n throw error;\n }\n}\n",[248,241],"3090bb1b87475ccaf9cfd296e11d63b2209554ecedc35ad9db5aa6c10d4b5c18","dbUtils","dbUtils/populateMemoryIds.ts",{"_32":251,"_13":252,"_81":253,"_83":243,"_85":33,"_86":104,"_88":26,"_34":254,"_40":22,"_91":92,"_93":255,"_67":50,"_95":-5,"_96":-7,"_73":256,"_98":257},"f2b7874a-17c5-11f0-8a41-569c3dd06744","populateMemoryIds.ts","3a8bbed3-2dd5-482f-b5b7-7ed4c26f3db9",["D",1744479939609],"// 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 populateMemoryIds() {\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}\n\n// Uncomment to run directly\n// populateMemoryIds();\n",[248,252],"54dd42a93be6aeba1c56e6c6e7150bad632df6408a0408de395fe76b5717aa5b","dbUtils/populateCreatedBy.ts",{"_32":260,"_13":261,"_81":262,"_83":243,"_85":33,"_86":104,"_88":26,"_34":263,"_40":22,"_91":92,"_93":264,"_67":50,"_95":-5,"_96":-7,"_73":265,"_98":266},"f2b7848e-17c5-11f0-8a41-569c3dd06744","populateCreatedBy.ts","79e9bc54-ad00-46f5-935e-83b9d41d2e21",["D",1744479939609],"// 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",[248,261],"0104e30ffd5068183cd5f50a1ca6032f6644c1f0eb9df2a76c897160119dfcb8","dbUtils/migrateMemoriesDb.ts",{"_32":269,"_13":270,"_81":271,"_83":243,"_85":33,"_86":104,"_88":26,"_34":272,"_40":22,"_91":92,"_93":273,"_67":50,"_95":-5,"_96":-7,"_73":274,"_98":275},"f2b782f4-17c5-11f0-8a41-569c3dd06744","migrateMemoriesDb.ts","07b346f1-4c06-47a5-847d-84946b89aa4f",["D",1744479939609],"// 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 migrateMemoriesDb() {\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\nmigrateMemoriesDb();\n",[248,270],"a03efce36391bc390ed3ea64b253c4434b37b15567b486041710c5169ec508de",{"_32":277,"_13":248,"_81":243,"_83":-5,"_85":33,"_86":104,"_88":26,"_34":278,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":279,"_98":-5},"f2b78d3a-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[248],"dashboard/shared/utils.ts",{"_32":282,"_13":283,"_81":284,"_83":285,"_85":33,"_86":104,"_88":26,"_34":286,"_40":22,"_91":92,"_93":287,"_67":50,"_95":-5,"_96":-7,"_73":288,"_98":289},"f2b77d18-17c5-11f0-8a41-569c3dd06744","utils.ts","8b541aa5-25cc-475a-bbf7-9cb6bf63a3d1","36d6ad96-a2aa-410b-884e-b76b0b83b442",["D",1744479939609],"export interface Message {\n content: string;\n}\n\nexport const MESSAGE_LIMIT = 5;",[290,100,283],"8027c8a7424f70844bf0af5b6d216ca6a57687f177fb3c6c774d977153bcd845","dashboard","dashboard/shared/types.ts",{"_32":293,"_13":80,"_81":294,"_83":285,"_85":33,"_86":104,"_88":26,"_34":295,"_40":22,"_91":92,"_93":296,"_67":50,"_95":-5,"_96":-7,"_73":297,"_98":298},"f2b77bb0-17c5-11f0-8a41-569c3dd06744","7199fb9e-5129-4f74-a277-bd717b6981dc",["D",1744479939609],"/**\n * @jsxImportSource https://esm.sh/react@18.2.0\n */\n\nexport interface Memory {\n id: string; // UUID\n date: string; // ISO 8601 date string or similar\n text: string;\n createdBy?: string | null; // Optional: Who/what created the memory\n createdDate?: number | null; // Optional: Unix timestamp (integer)\n tags?: string | null; // Optional: Comma-separated string or JSON\n}\n",[290,100,80],"80ea989e4dd5d0b083735f40a4365ebfa71b1d20cf8a900ed15bdac6eb06bc7e","dashboard/shared/README.md",{"_32":301,"_13":109,"_81":302,"_83":285,"_85":33,"_86":104,"_88":26,"_34":303,"_40":22,"_91":117,"_93":304,"_67":50,"_95":-5,"_96":-7,"_73":305,"_98":306},"f2b77a5c-17c5-11f0-8a41-569c3dd06744","66a3e469-392a-44e5-ac58-c770d5a16f93",["D",1744479939609],"# Shared\n\nIt's common to have code and types that are needed on both the frontend and the backend. It's important that you write this code in a particularly defensive way because it's limited by what both environments support:\n\n![shapes at 25-02-25 11.57.13.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/75db1d51-d9b3-45e0-d178-25d886c10700/public)\n\nFor example, you *cannot* use the `Deno` keyword. For imports, you can't use `npm:` specifiers, so we reccomend `https://esm.sh` because it works on the server & client. You *can* use TypeScript because that is transpiled in `/backend/index.ts` for the frontend. Most code that works on the frontend tends to work in Deno, because Deno is designed to support \"web-standards\", but there are definitely edge cases to look out for.",[290,100,109],"073749ef4ec8ccdca43dd4bb0366a7071fe2ab1db5ff325829b822e7b86bc390","dashboard/shared",{"_32":309,"_13":100,"_81":285,"_83":310,"_85":33,"_86":104,"_88":26,"_34":311,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":312,"_98":-5},"f2b77e9e-17c5-11f0-8a41-569c3dd06744","9aec420a-44fc-4bcb-9e6d-e9ad87354d60",["D",1744479939609],[290,100],"dashboard/frontend/index.tsx",{"_32":315,"_13":316,"_81":317,"_83":318,"_85":33,"_86":104,"_88":26,"_34":319,"_40":22,"_91":92,"_93":320,"_67":50,"_95":-5,"_96":-7,"_73":321,"_98":322},"f2b776e2-17c5-11f0-8a41-569c3dd06744","index.tsx","487cba5f-985f-4846-8187-6d19f865ed2c","49422f56-2ed9-473f-8a98-cc5c23d70abf",["D",1744479939609],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst rootElement = document.getElementById(\"root\");\nif (!rootElement) {\n throw new Error(\"Root element #root not found\");\n}\n\nconst root = createRoot(rootElement);\nroot.render();\n",[290,323,316],"b18f39efc1122bec01199f5c122b1b91107cc28dc373f234eb95086d1f592940","frontend","dashboard/frontend/index.html",{"_32":326,"_13":327,"_81":328,"_83":318,"_85":33,"_86":104,"_88":26,"_34":329,"_40":22,"_91":117,"_93":330,"_67":50,"_95":-5,"_96":-7,"_73":331,"_98":332},"f2b75b3a-17c5-11f0-8a41-569c3dd06744","index.html","41922813-5379-4a01-b407-499f07d8d8f3",["D",1744479939609],"\n\n \n \n \n Stevens' Notebook\n \n \n \n \n \n \n \n \n \n

\n \n \n \n\n",[290,323,327],"ba59643ee90a33aa41664cbb45ba261d4144d1e772881319de5d59b8b163317c","dashboard/frontend/favicon.svg",{"_32":335,"_13":336,"_81":337,"_83":318,"_85":33,"_86":104,"_88":26,"_34":338,"_40":22,"_91":117,"_93":339,"_67":50,"_95":-5,"_96":-7,"_73":340,"_98":341},"f2b75892-17c5-11f0-8a41-569c3dd06744","favicon.svg","21f3e40d-630e-469d-963d-bf71a086a268",["D",1744479939609],"",[290,323,336],"fcf78cf67ec933cff369ea4e1ecc918ccc66b991e5c097983437507f3fbfe6c4","dashboard/frontend/components/assets.ts",{"_32":344,"_13":345,"_81":346,"_83":347,"_85":33,"_86":104,"_88":26,"_34":348,"_40":22,"_91":92,"_93":349,"_67":50,"_95":-5,"_96":-7,"_73":350,"_98":351},"f2b74eba-17c5-11f0-8a41-569c3dd06744","assets.ts","60e3da65-2b5b-4541-a869-94ca5c2d2919","73817e14-a7df-46bf-9fb2-6fc61913d11b",["D",1744479939609],"export const ASSETS = {\n // Background\n BACKGROUND:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/8b501664-722e-4be8-cf71-83aab7756e00/public\",\n\n // Stevens\n STEVENS_FRONT:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/8b8432bb-add2-44ad-bb12-44b8ea215500/public\",\n STEVENS_BACK:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/e28da8ab-7710-4b82-8e32-8fdf65c2ed00/public\",\n STEVENS_WALKING:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/bd7b9997-09b2-4b35-6eb9-9975a85bb700/public\",\n\n // Mailman\n MAILMAN_STANDING:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/20a6493d-cc31-475e-aa83-ac97d317e400/public\",\n MAILMAN_WALKING:\n \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/61604576-8a83-4d85-d5e4-8e8e26641700/public\",\n};\n\n// Scene positions for characters and interactive elements\nexport const SCENE_POSITIONS = {\n // Stevens starts inside the house near the notebook\n STEVENS_DEFAULT: { x: 470, y: 600 },\n\n // Interactive elements\n NOTEBOOK: { x: 540, y: 690 }, // The open book on the table\n CALENDAR: { x: 392, y: 524 }, // Calendar on the wall\n MAILBOX: { x: 160, y: 580 }, // Mailbox outside\n TELEGRAPH: { x: 725, y: 580 }, // Telegraph on the desk\n};\n\n// Source types for different animations\nexport const SOURCE_TYPES = {\n CALENDAR: \"calendar\",\n MAIL: \"usps\",\n TELEGRAM: \"telegram\",\n WEATHER: \"weather\",\n DEFAULT: \"default\",\n};\n",[290,323,352,345],"d30d47c6f10352d47b846eb846efc8b55ca98ef8a0589f0c3faac0a43c921748","components","dashboard/frontend/components/NotebookView.tsx",{"_32":355,"_13":356,"_81":357,"_83":347,"_85":33,"_86":104,"_88":26,"_34":358,"_40":22,"_91":92,"_93":359,"_67":50,"_95":-5,"_96":-7,"_73":360,"_98":361},"f2b7417c-17c5-11f0-8a41-569c3dd06744","NotebookView.tsx","c0462e9e-a160-491d-b905-8444e04ef774",["D",1744479939609],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n useState,\n useEffect,\n useCallback,\n useMemo,\n} from \"https://esm.sh/react@18.2.0\";\nimport { type Memory } from \"../../shared/types.ts\";\n\nconst API_BASE = \"/api/memories\";\nconst MEMORIES_PER_PAGE = 20;\n\n// Format date in natural way: \"Wed, April 12\"\nconst formatDate = (dateStr: string) => {\n if (!dateStr) return \"N/A\";\n\n // Parse the date parts manually to avoid timezone issues\n const [year, month, day] = dateStr.split(\"-\").map((num) => parseInt(num, 10));\n\n // Create date with explicit year, month (0-indexed), and day\n const date = new Date(year, month - 1, day);\n\n return date.toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n month: \"long\",\n day: \"numeric\",\n });\n};\n\n// Sort memories by date (ascending)\nconst sortMemoriesByDate = (memories: Memory[]) => {\n return [...memories].sort((a, b) => {\n if (!a.date) return 1;\n if (!b.date) return -1;\n\n // Parse dates manually to avoid timezone issues\n const [aYear, aMonth, aDay] = a.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n const [bYear, bMonth, bDay] = b.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n\n // Compare year, then month, then day\n if (aYear !== bYear) return aYear - bYear;\n if (aMonth !== bMonth) return aMonth - bMonth;\n return aDay - bDay;\n });\n};\n\ninterface NotebookViewProps {\n onClose: () => void;\n avatarUrl: string | null;\n}\n\nexport function NotebookView({ onClose, avatarUrl }: NotebookViewProps) {\n const [memories, setMemories] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [editingMemory, setEditingMemory] = useState(null);\n const [newMemoryText, setNewMemoryText] = useState(\"\");\n const [newMemoryDate, setNewMemoryDate] = useState(\n new Date().toISOString().split(\"T\")[0]\n );\n const [newMemoryTags, setNewMemoryTags] = useState(\"\");\n const [showAddForm, setShowAddForm] = useState(false);\n const [currentPage, setCurrentPage] = useState(1);\n\n const fetchMemories = useCallback(async () => {\n setLoading(true);\n setError(null);\n try {\n const response = await fetch(API_BASE);\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n const data = await response.json();\n setMemories(data);\n } catch (e) {\n console.error(\"Failed to fetch memories:\", e);\n setError(e.message || \"Failed to fetch memories.\");\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n fetchMemories();\n }, [fetchMemories]);\n\n const handleAddMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!newMemoryText.trim()) return;\n\n const memoryData: Omit = {\n text: newMemoryText,\n date: newMemoryDate,\n tags: newMemoryTags || null,\n };\n\n try {\n const response = await fetch(API_BASE, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(memoryData),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setNewMemoryText(\"\");\n setNewMemoryDate(new Date().toISOString().split(\"T\")[0]);\n setNewMemoryTags(\"\");\n setShowAddForm(false);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to add memory:\", e);\n setError(e.message || \"Failed to add memory.\");\n }\n };\n\n const handleDeleteMemory = async (id: string) => {\n if (!confirm(\"Are you sure you want to delete this memory?\")) return;\n\n try {\n const response = await fetch(`${API_BASE}/${id}`, {\n method: \"DELETE\",\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to delete memory:\", e);\n setError(e.message || \"Failed to delete memory.\");\n }\n };\n\n const handleEditMemory = (memory: Memory) => {\n setEditingMemory(memory);\n };\n\n const handleCancelEdit = () => {\n setEditingMemory(null);\n };\n\n const handleUpdateMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!editingMemory || !editingMemory.text.trim()) return;\n\n const updatedFields: Partial> = {\n text: editingMemory.text,\n date: editingMemory.date,\n tags: editingMemory.tags,\n };\n\n try {\n const response = await fetch(`${API_BASE}/${editingMemory.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(updatedFields),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setEditingMemory(null);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to update memory:\", e);\n setError(e.message || \"Failed to update memory.\");\n }\n };\n\n // Sort and paginate memories\n const sortedMemories = useMemo(\n () => sortMemoriesByDate(memories),\n [memories]\n );\n\n const totalPages = Math.max(\n 1,\n Math.ceil(sortedMemories.length / MEMORIES_PER_PAGE)\n );\n\n const paginatedMemories = useMemo(() => {\n const startIndex = (currentPage - 1) * MEMORIES_PER_PAGE;\n return sortedMemories.slice(startIndex, startIndex + MEMORIES_PER_PAGE);\n }, [sortedMemories, currentPage]);\n\n const goToNextPage = () => {\n if (currentPage < totalPages) {\n setCurrentPage(currentPage + 1);\n }\n };\n\n const goToPrevPage = () => {\n if (currentPage > 1) {\n setCurrentPage(currentPage - 1);\n }\n };\n\n // Render edit form modal\n const renderEditForm = () => (\n

\n \n

Edit Entry

\n \n Text\n \n \n setEditingMemory({ ...editingMemory!, text: e.target.value })\n }\n className=\"w-full p-2 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base leading-[1.2em]\"\n rows={3}\n required\n />\n

\n \n Date\n \n \n setEditingMemory({ ...editingMemory!, date: e.target.value })\n }\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n />\n

\n \n Source\n \n \n setEditingMemory({ ...editingMemory!, tags: e.target.value })\n }\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n />\n

\n \n UPDATE\n \n setEditingMemory(null)}\n className=\"px-3 py-1 bg-[#A0522D] text-[#f8f1e0] rounded font-pixel text-base hover:bg-[#8B4513] border-2 border-b-4 border-r-4 border-[#4b3621]\"\n >\n CANCEL\n \n

\n \n editingMemory && handleDeleteMemory(editingMemory.id)\n }\n className=\"px-3 py-1 bg-[#555555] text-white rounded font-pixel text-base hover:bg-[#333333] border-2 border-b-4 border-r-4 border-[#222222]\"\n >\n DELETE\n \n

\n \n

\n );\n\n // Render add form\n const renderAddForm = () => (\n

\n \n

New Entry

\n setNewMemoryText(e.target.value)}\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base leading-[1.2em]\"\n rows={2}\n placeholder=\"Enter your note...\"\n required\n />\n

\n \n Date\n \n setNewMemoryDate(e.target.value)}\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n />\n

\n \n Source\n \n setNewMemoryTags(e.target.value)}\n className=\"w-full p-1 bg-[#fff8dc] border-2 border-[#8B4513] text-[#4b3621] focus:outline-none focus:border-[#654321] font-pixel text-base\"\n placeholder=\"Optional source\"\n />\n

\n \n SAVE\n \n setShowAddForm(false)}\n className=\"px-3 py-1 bg-[#A0522D] text-[#f8f1e0] rounded font-pixel text-base hover:bg-[#8B4513] border-2 border-b-4 border-r-4 border-[#4b3621]\"\n >\n CANCEL\n \n

\n \n

\n );\n\n return (\n

\n \n CLOSE\n \n\n

\n Stevens' Notebook\n

\n\n {error && (\n \n ERROR: {error}\n

\n )}\n\n {loading ? (\n

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n {paginatedMemories.length === 0 ? (\n \n \n \n ) : (\n paginatedMemories.map((memory) => (\n \n \n \n \n \n \n ))\n )}\n \n

\n DATE\n	\n NOTE\n	\n SOURCE\n	\n EDIT\n
\n \n NO ENTRIES FOUND\n \n
\n \n {formatDate(memory.date)}\n \n	\n \n {memory.text}\n \n	\n \n {memory.tags \|\| \"\"}\n \n	\n handleEditMemory(memory)}\n className=\"mr-1 text-[#8B4513] hover:text-[#654321] font-pixel text-lg\"\n title=\"Edit\"\n >\n ✎\n \n

\n )}\n\n

\n \n PREV\n \n \n NEXT\n \n

\n Page {currentPage} of {totalPages}\n

\n\n

\n {!showAddForm ? (\n setShowAddForm(true)}\n className=\"px-4 py-2 bg-[#8B4513] text-[#f8f1e0] rounded font-pixel text-lg hover:bg-[#654321] shadow-md border-2 border-b-4 border-r-4 border-[#4b3621]\"\n >\n NEW ENTRY\n \n ) : (\n

{renderAddForm()}

\n )}\n

\n\n {/* Edit Modal */}\n {editingMemory && renderEditForm()}\n \n );\n}\n",[290,323,352,356],"9965822ccd30d2bbc1a88d3d16f2f4e026b714d8ebda924f7c90ae5ff2e2ecd0","dashboard/frontend/components/App.tsx",{"_32":364,"_13":365,"_81":366,"_83":347,"_85":33,"_86":104,"_88":26,"_34":367,"_40":22,"_91":92,"_93":368,"_67":50,"_95":-5,"_96":-7,"_73":369,"_98":370},"f2b72c5a-17c5-11f0-8a41-569c3dd06744","App.tsx","56e22218-4430-4251-97ac-0d116d973d09",["D",1744479939609],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n useState,\n useEffect,\n useCallback,\n useMemo,\n} from \"https://esm.sh/react@18.2.0\";\nimport { type Memory } from \"../../shared/types.ts\";\nimport { ASSETS, SCENE_POSITIONS, SOURCE_TYPES } from \"./assets.ts\";\nimport { NotebookView } from \"./NotebookView.tsx\";\n\nconst API_BASE = \"/api/memories\";\nconst MEMORIES_PER_PAGE = 20; // Increased from 7 to 20 memories per page\n\n// Format date in natural way: \"Wed, April 12\"\nconst formatDate = (dateStr: string) => {\n if (!dateStr) return \"N/A\";\n\n // Parse the date parts manually to avoid timezone issues\n const [year, month, day] = dateStr.split(\"-\").map((num) => parseInt(num, 10));\n\n // Create date with explicit year, month (0-indexed), and day\n const date = new Date(year, month - 1, day);\n\n return date.toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n month: \"long\",\n day: \"numeric\",\n });\n};\n\n// Sort memories by date (ascending)\nconst sortMemoriesByDate = (memories: Memory[]) => {\n return [...memories].sort((a, b) => {\n if (!a.date) return 1;\n if (!b.date) return -1;\n\n // Parse dates manually to avoid timezone issues\n const [aYear, aMonth, aDay] = a.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n const [bYear, bMonth, bDay] = b.date\n .split(\"-\")\n .map((num) => parseInt(num, 10));\n\n // Compare year, then month, then day\n if (aYear !== bYear) return aYear - bYear;\n if (aMonth !== bMonth) return aMonth - bMonth;\n return aDay - bDay;\n });\n};\n\n// Scene positions for specific elements on the 512x512 grid\nconst SCENE_ELEMENTS = {\n // Main elements\n DESK: { x: 209, y: 304, width: 84, height: 36 },\n DESK_SITTING: { x: 219, y: 264, width: 64, height: 64 },\n MAILBOX: { x: 61, y: 249, width: 52, height: 79 },\n CALENDAR: { x: 156, y: 226, width: 53, height: 53 },\n TELEGRAM: { x: 308, y: 242, width: 62, height: 80 },\n OUTSIDE: { x: 219, y: 366, width: 64, height: 64 },\n};\n\nexport function App() {\n const [memories, setMemories] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [editingMemory, setEditingMemory] = useState(null);\n const [newMemoryText, setNewMemoryText] = useState(\"\");\n const [newMemoryDate, setNewMemoryDate] = useState(\n new Date().toISOString().split(\"T\")[0]\n );\n const [newMemoryTags, setNewMemoryTags] = useState(\"\");\n const [showAddForm, setShowAddForm] = useState(false);\n const [currentPage, setCurrentPage] = useState(1);\n const [avatarUrl, setAvatarUrl] = useState(null);\n const [woodUrl, setWoodUrl] = useState(null);\n const [showNotebook, setShowNotebook] = useState(false);\n const [currentMemoryIndex, setCurrentMemoryIndex] = useState(0);\n const [showCaption, setShowCaption] = useState(false);\n const [isAnimating, setIsAnimating] = useState(false);\n const [cookieAndTeaMode, setCookieAndTeaMode] = useState(false);\n\n // Fetch images from backend instead of blob storage directly\n useEffect(() => {\n // Set default background color in case image doesn't load\n if (document.body) {\n document.body.style.backgroundColor = \"#2D1700\"; // Dark brown leather color\n }\n\n // Fetch avatar image\n fetch(\"/api/images/stevens.jpg\")\n .then((response) => {\n if (response.ok) return response.blob();\n throw new Error(\"Failed to load avatar image\");\n })\n .then((imageBlob) => {\n const url = URL.createObjectURL(imageBlob);\n setAvatarUrl(url);\n })\n .catch((err) => {\n console.error(\"Failed to load avatar:\", err);\n });\n\n // Fetch wood background\n fetch(\"/api/images/wood.jpg\")\n .then((response) => {\n if (response.ok) return response.blob();\n throw new Error(\"Failed to load wood background\");\n })\n .then((imageBlob) => {\n const url = URL.createObjectURL(imageBlob);\n setWoodUrl(url);\n\n // Apply wood background to body\n if (document.body) {\n document.body.style.backgroundImage = `url(${url})`;\n }\n })\n .catch((err) => {\n console.error(\"Failed to load background:\", err);\n });\n\n // Cleanup blob URLs on unmount\n return () => {\n if (avatarUrl) URL.revokeObjectURL(avatarUrl);\n if (woodUrl) URL.revokeObjectURL(woodUrl);\n };\n }, []);\n\n const fetchMemories = useCallback(async () => {\n setLoading(true);\n setError(null);\n try {\n const response = await fetch(API_BASE);\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n const data = await response.json();\n\n // Change the sorting function to show memories in chronological order\n const sortedMemories = [...data].sort((a, b) => {\n const dateA = a.createdDate || 0;\n const dateB = b.createdDate || 0;\n return dateA - dateB; // Oldest first, chronological order\n });\n\n setMemories(sortedMemories);\n\n // Set current index to the last memory (newest one)\n if (sortedMemories.length > 0) {\n setCurrentMemoryIndex(sortedMemories.length - 1);\n setShowCaption(true);\n }\n } catch (e) {\n console.error(\"Failed to fetch memories:\", e);\n setError(e.message || \"Failed to fetch memories.\");\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n fetchMemories();\n }, [fetchMemories]);\n\n const handleAddMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!newMemoryText.trim()) return;\n\n const memoryData: Omit = {\n text: newMemoryText,\n date: newMemoryDate,\n tags: newMemoryTags || null,\n };\n\n try {\n const response = await fetch(API_BASE, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(memoryData),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setNewMemoryText(\"\");\n setNewMemoryDate(new Date().toISOString().split(\"T\")[0]);\n setNewMemoryTags(\"\");\n setShowAddForm(false);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to add memory:\", e);\n setError(e.message || \"Failed to add memory.\");\n }\n };\n\n const handleDeleteMemory = async (id: string) => {\n if (!confirm(\"Are you sure you want to delete this memory?\")) return;\n\n try {\n const response = await fetch(`${API_BASE}/${id}`, {\n method: \"DELETE\",\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to delete memory:\", e);\n setError(e.message || \"Failed to delete memory.\");\n }\n };\n\n const handleEditMemory = (memory: Memory) => {\n setEditingMemory(memory);\n };\n\n const handleCancelEdit = () => {\n setEditingMemory(null);\n };\n\n const handleUpdateMemory = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!editingMemory || !editingMemory.text.trim()) return;\n\n const updatedFields: Partial> = {\n text: editingMemory.text,\n date: editingMemory.date,\n tags: editingMemory.tags,\n };\n\n try {\n const response = await fetch(`${API_BASE}/${editingMemory.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(updatedFields),\n });\n if (!response.ok) {\n throw new Error(`HTTP error! status: ${response.status}`);\n }\n setEditingMemory(null);\n await fetchMemories();\n } catch (e) {\n console.error(\"Failed to update memory:\", e);\n setError(e.message || \"Failed to update memory.\");\n }\n };\n\n // Sort and paginate memories\n const sortedMemories = useMemo(\n () => sortMemoriesByDate(memories),\n [memories]\n );\n\n const totalPages = Math.max(\n 1,\n Math.ceil(sortedMemories.length / MEMORIES_PER_PAGE)\n );\n\n const paginatedMemories = useMemo(() => {\n const startIndex = (currentPage - 1) * MEMORIES_PER_PAGE;\n return sortedMemories.slice(startIndex, startIndex + MEMORIES_PER_PAGE);\n }, [sortedMemories, currentPage]);\n\n const goToNextPage = () => {\n if (currentPage < totalPages) {\n setCurrentPage(currentPage + 1);\n }\n };\n\n const goToPrevPage = () => {\n if (currentPage > 1) {\n setCurrentPage(currentPage - 1);\n }\n };\n\n // Animation delay to keep Stevens in place briefly\n const handleAnimationEnd = () => {\n setIsAnimating(false);\n };\n\n // Memory navigation handlers\n const goToNextMemory = () => {\n if (currentMemoryIndex < memories.length - 1) {\n // Reset cookie and tea mode on navigation\n setCookieAndTeaMode(false);\n\n // Trigger animation transition\n setIsAnimating(true);\n\n // Change memory after a brief delay\n setCurrentMemoryIndex(currentMemoryIndex + 1);\n setShowCaption(true);\n }\n };\n\n const goToPrevMemory = () => {\n if (currentMemoryIndex > 0) {\n // Reset cookie and tea mode on navigation\n setCookieAndTeaMode(false);\n\n // Trigger animation transition\n setIsAnimating(true);\n\n // Change memory after a brief delay\n setCurrentMemoryIndex(currentMemoryIndex - 1);\n setShowCaption(true);\n }\n };\n\n // Add keyboard navigation\n useEffect(() => {\n const handleKeyDown = (e: KeyboardEvent) => {\n if (showNotebook) return; // Don't navigate when notebook is open\n\n if (e.key === \"ArrowLeft\") {\n goToPrevMemory();\n } else if (e.key === \"ArrowRight\") {\n goToNextMemory();\n }\n };\n\n window.addEventListener(\"keydown\", handleKeyDown);\n\n return () => {\n window.removeEventListener(\"keydown\", handleKeyDown);\n };\n }, [currentMemoryIndex, memories.length, showNotebook]);\n\n // Generate caption based on memory source and content\n const generateCaption = (memory: Memory | undefined) => {\n if (cookieAndTeaMode) {\n return \"Ah, a lovely cup of tea and a cookie. Most refreshing indeed.\";\n }\n\n if (!memory) return \"No memories to display\";\n\n const source = memory.createdBy || \"unknown\";\n const sourceText =\n source === SOURCE_TYPES.WEATHER\n ? \"Hmm, I should check the weather today.\"\n : source === SOURCE_TYPES.MAIL\n ? \"Ah! A new letter has arrived.\"\n : source === SOURCE_TYPES.TELEGRAM\n ? \"A telegram! I must read it right away.\"\n : source === SOURCE_TYPES.CALENDAR\n ? \"I should check my calendar.\"\n : \"I must make note of this.\";\n\n return `${sourceText} Note for ${memory.date}: ${memory.text}`;\n };\n\n // Handle cookie and tea button\n const handleServeCookieAndTea = () => {\n setCookieAndTeaMode(true);\n };\n\n // Get Stevens' position and appearance based on memory source\n const getStevensState = (memory: Memory | undefined) => {\n // Override with cookie and tea mode\n if (cookieAndTeaMode) {\n return {\n position: SCENE_ELEMENTS.DESK_SITTING,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: SCENE_ELEMENTS.DESK,\n animationClass: \"no-animation\",\n };\n }\n\n if (!memory) {\n // Default state: sitting at desk\n return {\n position: SCENE_ELEMENTS.DESK_SITTING,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: null,\n animationClass: \"no-animation\",\n };\n }\n\n const source = memory.createdBy || \"unknown\";\n\n switch (source) {\n case SOURCE_TYPES.MAIL:\n return {\n position: {\n x: SCENE_ELEMENTS.MAILBOX.x + 20,\n y: SCENE_ELEMENTS.MAILBOX.y - 20,\n },\n image: ASSETS.STEVENS_BACK,\n highlightElement: SCENE_ELEMENTS.MAILBOX,\n animationClass: \"walk-to-mailbox\",\n };\n\n case SOURCE_TYPES.CALENDAR:\n return {\n position: {\n x: SCENE_ELEMENTS.CALENDAR.x + 10,\n y: SCENE_ELEMENTS.CALENDAR.y + 30,\n },\n image: ASSETS.STEVENS_BACK,\n highlightElement: SCENE_ELEMENTS.CALENDAR,\n animationClass: \"walk-to-calendar\",\n };\n\n case SOURCE_TYPES.TELEGRAM:\n return {\n position: {\n x: SCENE_ELEMENTS.TELEGRAM.x - 20,\n y: SCENE_ELEMENTS.TELEGRAM.y + 10,\n },\n image: ASSETS.STEVENS_BACK,\n highlightElement: SCENE_ELEMENTS.TELEGRAM,\n animationClass: \"walk-to-telegram\",\n };\n\n case SOURCE_TYPES.WEATHER:\n return {\n position: SCENE_ELEMENTS.OUTSIDE,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: null,\n animationClass: \"walk-to-outside\",\n };\n\n default:\n return {\n position: SCENE_ELEMENTS.DESK_SITTING,\n image: ASSETS.STEVENS_FRONT,\n highlightElement: SCENE_ELEMENTS.DESK,\n animationClass: \"walk-to-desk\",\n };\n }\n };\n\n // Current memory\n const currentMemory = memories[currentMemoryIndex];\n const caption = generateCaption(currentMemory);\n const stevensState = getStevensState(currentMemory);\n\n // Scale factor for world coordinates (1/2 original size)\n const scaleFactor = 0.5;\n const scalePosition = (pos: { x: number; y: number }) => ({\n x: pos.x * scaleFactor,\n y: pos.y * scaleFactor,\n });\n\n // Render edit form modal\n const renderEditForm = () => (\n

\n \n

Edit Entry

\n \n DELETE\n \n

\n \n

\n );\n\n // Render add form\n const renderAddForm = () => (\n

\n \n

New Entry

\n \n

\n );\n\n return (\n

\n \n\n {/* Main game container with fixed dimensions */}\n

\n {/* Game world */}\n \n {/* Notebook clickable area (transparent) */}\n setShowNotebook(true)}\n title=\"Click to open Stevens' notebook\"\n >

\n\n {/* Highlight for interactive elements */}\n {stevensState.highlightElement && (\n

\n )}\n\n {/* Stevens character */}\n \n\n {/* Cookie and teacup for easter egg */}\n {cookieAndTeaMode && (\n <>\n \n \n \n )}\n \n\n {/* Caption area */}\n

\n {showCaption && (currentMemory || cookieAndTeaMode) ? (\n

{caption}

\n ) : (\n

\n Use arrows or buttons to navigate through Stevens' memories\n

\n )}\n

\n\n {/* Timeline controls */}\n

\n {loading\n ? \"Loading memories...\"\n : `Memory ${currentMemoryIndex + 1} of ${memories.length}`}\n

\n\n

\n \n ◀ PREV\n \n\n = memories.length - 1}\n className={`px-4 py-2 rounded-lg border-2 border-b-4 border-r-4 ${\n currentMemoryIndex >= memories.length - 1\n ? \"bg-gray-600 border-gray-700 opacity-50 cursor-not-allowed\"\n : \"bg-[#8B4513] border-[#654321] hover:bg-[#A0522D]\"\n }`}\n aria-label=\"Next memory\"\n >\n NEXT ▶\n \n

\n\n {error && (\n

\n {error}\n

\n )}\n\n {/* Timeline visualization and cookie/tea button */}\n

\n Source:{\" \"}\n {cookieAndTeaMode\n ? \"Tea Time\"\n : currentMemory?.createdBy || \"None\"}\n

\n Use ◀ ▶ arrow keys or buttons to navigate\n

\n\n {/* Easter egg button */}\n \n 🍪☕ Serve Cookie & Tea\n \n

\n\n {/* Notebook View Modal */}\n {showNotebook && (\n setShowNotebook(false)}\n avatarUrl={avatarUrl}\n />\n )}\n \n \n );\n}\n",[290,323,352,365],"8a9098df593fbabc2ee3a613cb22e6cc40e5473acee62e3f855318ce2661b861","dashboard/frontend/components",{"_32":373,"_13":352,"_81":347,"_83":318,"_85":33,"_86":104,"_88":26,"_34":374,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":375,"_98":-5},"f2b75374-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[290,323,352],"dashboard/frontend/README.md",{"_32":378,"_13":109,"_81":379,"_83":318,"_85":33,"_86":104,"_88":26,"_34":380,"_40":22,"_91":117,"_93":381,"_67":50,"_95":-5,"_96":-7,"_73":382,"_98":383},"f2b7554a-17c5-11f0-8a41-569c3dd06744","55d37a49-6972-45c6-815b-fb6c3b07851b",["D",1744479939609],"# Frontend\n\nThis template is a classic client-side-only React app. \n\n## `index.html`\n\nThe **entrypoint** for the frontend is `/frontend/index.html`. This is the HTML page that is returned at the root from `/backend/index.ts`.\n\nThis HTML file imports `/frontend/style.css` from `/public/style.css` and `/frontend/favicon.svg` from `/frontend/favicon.svg`. Everything in `/frontend/` is mapped to `/public` by `/backend/index.ts`. This is just a convention. You could import & serve everything out of the same folder name.\n\nThis HTML file has a `

`, which is where we mount the React app.\n\nThis HTML file imports `/frontend/index.tsx` from `/public/index.tsx`, which is the **entrypoint** for all frontend JavaScript, including all the React. It is not a problem that it imports a file with a `.tsx` extension becaues browsers ignore file extensions. They only pay attention to content-types, which is great, because all these files will be returned as transpiled JS with the appropriate JS content type by [stevekrouse/utils/serve-public](https://www.val.town/x/stevekrouse/utils/branch/main/code/serve-public/README.md).)\n\n## `index.tsx`\n\nThis file is the **entrypoint** for frontend JavaScript. It imports the React app from `/frontend/components/App.tsx` and mounts it on `

`.\n\nIt also looks for *bootstrapped* JSON data at `window.__INITIAL_DATA`, and passes that only to the ``.\n\n## `favicon.svg`\n\nAs of this writing Val Town only supports text files, which is why the favicon is an SVG and not an .ico or any other binary image format. If you need binary file storage, check out [Blob Storage](https://docs.val.town/std/blob/).\n\n## `components/`\n\nThis directory is where the React components are stored. They're pretty standard client-side React components.",[290,323,109],"8f764021914125280810bc36d58605ff1632411dba20f1029b817911972e8bd1","dashboard/frontend",{"_32":386,"_13":323,"_81":318,"_83":310,"_85":33,"_86":104,"_88":26,"_34":387,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":388,"_98":-5},"f2b778d6-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[290,323],"dashboard/backend/index.ts",{"_32":391,"_13":392,"_81":393,"_83":394,"_85":33,"_86":41,"_88":26,"_34":395,"_40":124,"_91":201,"_93":396,"_67":50,"_95":-5,"_96":-7,"_73":397,"_98":398},"59308712-1c6a-11f0-b534-569c3dd06744","index.ts","923664b2-349c-4d3b-a749-641b13e4de92","97a5e92b-b1ad-4f07-8c68-dde53f14b279",["D",1744990353681],"/**\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 { type Memory } from \"../shared/types.ts\";\nimport { createMemory, deleteMemory, getAllMemories, updateMemory } from \"./database/queries.ts\";\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 // Optionally re-throw or return a custom error response\n // throw err;\n return c.json({ error: \"Internal Server Error\", details: err.message }, 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 const body = await c.req.json>();\n if (!body.text) {\n return c.json({ error: \"Memory text cannot be empty\" }, 400);\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 const body = await c.req.json>>();\n\n if (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 // Handle cases like memory not found, if needed\n console.error(\"Error updating memory:\", error);\n return c.json(\n { error: \"Failed to update memory\", details: error.message },\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 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 },\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 // Get image data from blob storage\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\"; // Default\n if (filename.endsWith(\".jpg\") || filename.endsWith(\".jpeg\")) {\n contentType = \"image/jpeg\";\n } else if (filename.endsWith(\".png\")) {\n contentType = \"image/png\";\n } else if (filename.endsWith(\".gif\")) {\n contentType = \"image/gif\";\n } else if (filename.endsWith(\".svg\")) {\n contentType = \"image/svg+xml\";\n }\n\n // Return the image with appropriate headers\n return new Response(imageData, {\n headers: {\n \"Content-Type\": contentType,\n \"Cache-Control\": \"public, max-age=3600\", // Cache for 1 hour\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 },\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 // 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 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// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;",[290,399,392],"400d5f9ed06c04897772556b0aba774600ab5a8a95140bf270156f521cf0dc40","backend","dashboard/backend/database/queries.ts",{"_32":402,"_13":403,"_81":404,"_83":405,"_85":33,"_86":104,"_88":26,"_34":406,"_40":22,"_91":92,"_93":407,"_67":50,"_95":-5,"_96":-7,"_73":408,"_98":409},"f2b71d3c-17c5-11f0-8a41-569c3dd06744","queries.ts","a1bdff2f-26e4-41a6-b5de-4ab47706ec22","18fb3b56-64c8-47bf-adee-53638436ec5e",["D",1744479939609],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { type Memory } from \"../../shared/types.ts\";\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\nexport async function getAllMemories(): Promise {\n const result = await sqlite.execute(\n `SELECT id, date, text, createdBy, createdDate, tags FROM ${tableName}\n ORDER BY createdDate DESC`\n );\n\n // Ensure correct typing, especially for potential null values\n return result.rows.map((row) => ({\n id: row.id as string,\n date: row.date as string | null,\n text: row.text as string,\n createdBy: row.createdBy as string | null,\n createdDate: row.createdDate as number | null,\n tags: row.tags as string | null,\n })) as Memory[];\n}\n\nexport async function createMemory(\n memory: Omit\n): Promise {\n // Use nanoid like in getWeather.ts\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\n const newId = nanoid(10); // Generate a shorter ID like in getWeather\n const createdDate = memory.createdDate ?? Date.now(); // Default to now if not provided\n\n await sqlite.execute(\n `INSERT INTO ${tableName} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n newId,\n memory.date,\n memory.text,\n memory.createdBy || \"dashboard\", // Default creator\n createdDate,\n memory.tags,\n ]\n );\n\n return {\n ...memory,\n id: newId,\n createdDate,\n };\n}\n\nexport async function updateMemory(\n id: string,\n memory: Partial>\n): Promise {\n const fields = Object.keys(memory).filter((key) => key !== \"id\");\n const values = Object.values(memory);\n\n if (fields.length === 0) {\n throw new Error(\"No fields provided for update\");\n }\n\n const setClause = fields.map((field) => `${field} = ?`).join(\", \");\n\n await sqlite.execute(`UPDATE ${tableName} SET ${setClause} WHERE id = ?`, [\n ...values,\n id,\n ]);\n}\n\nexport async function deleteMemory(id: string): Promise {\n await sqlite.execute(`DELETE FROM ${tableName} WHERE id = ?`, [id]);\n}\n",[290,399,410,403],"606dc2fea3fd36dcf2cb86c9143275059c38ceee7a5b6032d42ec96df81e528c","database","dashboard/backend/database/README.md",{"_32":413,"_13":109,"_81":414,"_83":405,"_85":33,"_86":104,"_88":26,"_34":415,"_40":22,"_91":117,"_93":416,"_67":50,"_95":-5,"_96":-7,"_73":417,"_98":418},"f2b71968-17c5-11f0-8a41-569c3dd06744","591be43f-6dff-4f69-8f7e-044ad17beb99",["D",1744479939609],"# Database\n\nThis app uses [Val Town SQLite](https://docs.val.town/std/sqlite/) to manage data. Every Val Town account comes with a free SQLite database, hosted on [Turso](https://turso.tech/). This folder is broken up into two files:\n\n* `migrations.ts` - code to set up the database tables the app needs\n* `queries.ts` - functions to run queries against those tables, which are imported and used in the main Hono server in `/backend/index.ts`\n\n## Migrations\n\nIn `backend/database/migrations.ts`, this app creates a new SQLite table `reactHonoStarter_messages` to store messages. \n\nThis \"migration\" runs once on every app startup because it's imported in `index.ts`. You can comment this line out for a slight (30ms) performance improvement on cold starts. It's left in so that users who fork this project will have the migration run correctly.\n\nSQLite has much more limited support for altering existing tables as compared to other databases. Often it's easier to create new tables with the schema you want, and then copy the data over. Happily LLMs are quite good at those sort of database operations, but please reach out in the [Val Town Discord](https://discord.com/invite/dHv45uN5RY) if you need help.\n\n## Queries\n\nThe queries file is where running the migrations happen in this app. It'd also be reasonable for that to happen in index.ts, or as is said above, for that line to be commented out, and only run when actual changes are made to your database schema.\n\nThe queries file exports functions to get and write data. It relies on shared types and data imported from the `/shared` directory.",[290,399,410,109],"dff234f478f20b038a86834efdc8c41b962b8677b46a5141ebbb92e6f0188aa8","dashboard/backend/database",{"_32":421,"_13":410,"_81":405,"_83":394,"_85":33,"_86":104,"_88":26,"_34":422,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":423,"_98":-5},"f2b7200c-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[290,399,410],"dashboard/backend/README.md",{"_32":426,"_13":109,"_81":427,"_83":394,"_85":33,"_86":104,"_88":26,"_34":428,"_40":22,"_91":117,"_93":429,"_67":50,"_95":-5,"_96":-7,"_73":430,"_98":431},"f2b721f6-17c5-11f0-8a41-569c3dd06744","13bcfc3a-2103-4d82-b8e0-7793fda72e49",["D",1744479939609],"# Backend\n\nThis folder contains all backend-only code in this project. It's broken up into:\n\n* `index.ts` - this is the **entrypoint** for this whole project\n* `database/` - this contains the code for interfacing with the app's SQLite database table\n\n## Hono\n\nThis app uses [Hono](https://hono.dev/) as the API framework. You can think of Hono as a replacement for [ExpressJS](https://expressjs.com/) that works in serverless environments like Val Town or Cloudflare Workers. If you come from Python or Ruby, Hono is also a lot like [Flask](https://github.com/pallets/flask) or [Sinatra](https://github.com/sinatra/sinatra), respectively.\n\n## Serving assets to the frontend\n\nThis backend HTTP server is responsible for serving all static assets to the browser to render the app, including HTML, JavaScript (including all client-side React), CSS, and even the favicon SVG.\n\nIn a normal server environment, you would likely use a middleware [like this one](https://hono.dev/docs/getting-started/nodejs#serve-static-files) to serve static files. Some frameworks or deployment platforms automatically make any content inside a `public/` folder public. \n\nHowever in Val Town you need to handle this yourself, and it can be suprisingly difficult to read and serve files in a Val Town Project. This template uses helper functions from [stevekrouse/utils/serve-public](https://www.val.town/x/stevekrouse/utils/branch/main/code/serve-public/README.md), which handle reading project files in a way that will work across branches and forks, automatically transpiles typescript to javascript, and assigns content-types based on the file's extension.\n\n### `index.html`\n\nThe most complicated part of this backend API is serving index.html. In this app (like most apps) we serve it at the root, ie `GET /`. \n\nWe *bootstrap* `index.html` with some initial data from the server, so that it gets dynamically injected JSON data without having to make another round-trip request to the server to get that data on the frontend. This is a common pattern for client-side rendered apps.\n\n## CRUD API Routes\n\nThis app has two CRUD API routes: for reading and inserting into the messages table. They both speak JSON, which is standard. They import their functions from `/backend/database/queries.ts`. These routes are called from the React app to refresh and update data.\n\n## Errors\n\nHono and other API frameworks have a habit of swallowing up Errors. We turn off this default behavior by re-throwing errors, because we think most of the time you'll want to see the full stack trace instead of merely \"Internal Server Error\". You can customize how you want errors to appear.",[290,399,109],"f8ab454a012eb557444cff7912903199d8df92b666e76171ea63adf938537dc7","dashboard/backend",{"_32":434,"_13":399,"_81":394,"_83":310,"_85":33,"_86":104,"_88":26,"_34":435,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":436,"_98":-5},"f2b72aac-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[290,399],"dashboard/README.md",{"_32":439,"_13":109,"_81":440,"_83":310,"_85":33,"_86":104,"_88":26,"_34":441,"_40":22,"_91":117,"_93":442,"_67":50,"_95":-5,"_96":-7,"_73":443,"_98":444},"f2b77fde-17c5-11f0-8a41-569c3dd06744","57f55366-2c44-43fe-8be9-141ae6178423",["D",1744479939609],"# React Hono Val Town Project Starter Template\n\nThis is a starter template for a full-stack app in a Val Town Project. The app itself is a simple persistent message board.\n\nThis app is broken up into three folders, corresponding to where the code in those folders run:\n\n- `backend/` - runs on Val Town serverless infrastructure in Deno\n- `frontend/` - runs in the user's browser\n- `shared/` - runs in both the frontend and backend\n\nThe entrypoint of this app is `backend/index.ts`, which is the Hono HTTP server, which serves the HTML, CSS, and JS, which run client-side.\n\nYou can click into each of those folders to view their respective READMEs.",[290,109],"798045dde62a94faaa6da2e1dc260b6592e7a060ba916744101ddc9ff7690ef3",{"_32":446,"_13":290,"_81":310,"_83":-5,"_85":33,"_86":104,"_88":26,"_34":447,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":448,"_98":-5},"f2b78128-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[290],"dailyBriefing/testDailyBrief.ts",{"_32":451,"_13":452,"_81":453,"_83":454,"_85":33,"_86":104,"_88":26,"_34":455,"_40":22,"_91":92,"_93":456,"_67":50,"_95":-5,"_96":-7,"_73":457,"_98":458},"f2b6fafa-17c5-11f0-8a41-569c3dd06744","testDailyBrief.ts","e2afcbfe-16b1-415e-99da-986ebadc2f21","6bf99520-d665-4acb-96a3-9d2a37ff956c",["D",1744479939609],"// Send a test of the daily brief to a test chat id\n\nimport { sendDailyBriefing } from \"./sendDailyBrief.ts\";\nimport { DateTime } from \"https://esm.sh/luxon@3.4.4\";\n\nexport async function testDailyBrief() {\n try {\n const testChatId = Deno.env.get(\"TEST_TELEGRAM_CHAT_ID\");\n if (!testChatId) {\n console.error(\"TEST_TELEGRAM_CHAT_ID is not configured.\");\n return;\n }\n\n console.log(\"Sending test daily briefing for tomorrow...\");\n const result = await sendDailyBriefing(\n testChatId,\n DateTime.now()\n .setZone(\"America/New_York\")\n .startOf(\"day\")\n .plus({ days: 1 })\n );\n return result;\n } catch (error) {\n console.error(\"Error sending test daily briefing:\", error);\n throw error;\n }\n}\n\n// Export as default for direct execution\ntestDailyBrief();\n",[459,452],"d85b41b2c1d938361741406286b21fa8a2e8ccc35dcde798c2364e7ffb2b7722","dailyBriefing","dailyBriefing/sendDailyBrief.ts",{"_32":462,"_13":463,"_81":464,"_83":454,"_85":33,"_86":104,"_88":26,"_34":465,"_40":22,"_91":92,"_93":466,"_67":50,"_95":-5,"_96":-7,"_73":467,"_98":468},"f2b6f1d6-17c5-11f0-8a41-569c3dd06744","sendDailyBrief.ts","da2b6a7a-cd8b-48ce-baa4-486e1b73e8e5",["D",1744479939609],"import { Bot } from \"https://deno.land/x/grammy@v1.35.0/mod.ts\";\nimport { DateTime } from \"https://esm.sh/luxon@3.4.4\";\nimport Anthropic from \"npm:@anthropic-ai/sdk@0.24.3\";\nimport { backstory } from \"../backstory.ts\";\nimport {\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n storeChatMessage,\n} from \"../importers/handleTelegramMessage.ts\";\nimport {\n formatMemoriesForPrompt,\n getRelevantMemories,\n} from \"../memoryUtils.ts\";\n\nasync function generateBriefingContent(anthropic, memories, today, isSunday) {\n try {\n const weekdaysHelp = generateWeekDays(today);\n // Create system prompt\n const systemPrompt = `${backstory}`;\n\n // Create user message\n const userMessage = {\n role: \"user\",\n content: `Today it is your duty to provide a daily briefing summarizing important information for the day. The briefing should have the following sections:\n\nBegin with a formal morning greeting, maintaining professional decorum. Try to mix up the greetings, for example mention the season or the weather.\n\n*Today*\n\nNote any reminders about today's affairs.\nProvide a summary of today's meteorological conditions.\nDetail the day's postal correspondence, highlighting any significant items such as important documents, personal letters, or parcels. Advertisements need not be mentioned. If there is no mail, this section may be omitted.\n\n*Looking Ahead*\n\nOffer a brief overview of forthcoming engagements and tasks for the remainder of the week, with particular attention to tomorrow's schedule.\nShould there be noteworthy meteorological conditions anticipated later in the week (such as precipitation or significant temperature variations), these should be mentioned. If the weather is unremarkable, this need not be addressed.\nOne concise paragraph, 2-3 sentences maximum, without bullet points or subsections.\n\n*Daily fact*\n\nInclude the fun fact for today from the memories. This will be labeled with \"fun fact:\" in the text field.\nIf no fun fact is available for today, you may omit this section.\n\nSign off with a formal greeting.\n\nUse the following memories to fill in the information for your briefing:\n\n${formatMemoriesForPrompt(memories)}\n\nResponse guidelines:\n\nAlways follow these rules:\n- Use Telegram-friendly markdown format (supports *bold*, _italic_, [links](http://example.com))). Do not use markdown headings like ## as they are not supported in Telegram messages.\n- Make the briefing easily skimmable by using clear sections. Use bolded text to begin each section, eg *Today*\n- Use emojis to help reinforce the content visually. Use emojis for specific concepts like sun/rainy weather, paper forms for a logistical todo, etc. Don't use emojis for general concepts like \"today\"\n\n- Address the message to \"Sir and Madam\".\n- Maintain a formal and professional tone throughout.\n- Use phrases characteristic of Stevens' speech patterns, such as:\n - \"I should say...\"\n - \"I would venture...\"\n - \"If I may be so bold...\"\n - \"It would appear that...\"\n - \"One might observe...\"\n - \"I trust you will find...\"\n - \"I would be remiss not to mention...\"\n- Avoid contractions (use \"do not\" instead of \"don't\")\n- Express opinions tentatively and with great deference\n- Use British English spelling and terminology\n- Keep the content concise but informative, maintaining the highest standards of professional communication\n- You should reference upcoming days as \"today\", \"tomorrow\", \"Thursday\", etc. rather than using dates. Here's a guide:\n${weekdaysHelp}`,\n };\n\n console.log(\"Sending prompt to Anthropic...\", userMessage);\n\n const response = await anthropic.messages.create({\n model: \"claude-3-7-sonnet-latest\",\n max_tokens: 30000,\n system: systemPrompt,\n thinking: {\n type: \"enabled\",\n budget_tokens: 24000,\n },\n messages: [userMessage],\n });\n\n const text = response.content.find((block) => block.type === \"text\").text;\n\n return text;\n } catch (error) {\n console.error(\"Briefing generation error:\", error);\n throw error;\n }\n}\n\nexport async function sendDailyBriefing(chatId?: string, today?: DateTime) {\n // Get API keys from environment\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\n const telegramToken = Deno.env.get(\"TELEGRAM_TOKEN\");\n\n // If no chatId is provided, try to get it from environment variables\n if (!chatId) {\n chatId = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n }\n\n if (!apiKey) {\n console.error(\"Anthropic API key is not configured.\");\n return;\n }\n\n if (!telegramToken) {\n console.error(\"TELEGRAM_TOKEN is not configured.\");\n return;\n }\n\n if (!chatId) {\n console.error(\"No chat ID provided or found in environment variables.\");\n return;\n }\n\n // Initialize Anthropic client\n const anthropic = new Anthropic({ apiKey });\n\n // Initialize Telegram bot\n const bot = new Bot(telegramToken);\n\n // Use provided date or get today's date in US Eastern Time\n if (!today) {\n today = DateTime.now().setZone(\"America/New_York\").startOf(\"day\");\n }\n\n // Get the date of the last Sunday\n const lastSunday = today.startOf(\"week\").minus({ days: 1 });\n\n // Fetch relevant memories using the utility function\n const memories = await getRelevantMemories();\n\n console.log(memories);\n\n // Check if today is Sunday (1 is Sunday in Luxon)\n const isSunday = today.weekday === 7;\n\n // Generate briefing content\n const content = await generateBriefingContent(\n anthropic,\n memories,\n today,\n isSunday\n );\n\n console.log(\"content\", content);\n\n console.log(\"Sending Telegram message...\");\n\n // Format message for Telegram\n // Telegram supports Markdown V2, but it's more restrictive than regular Markdown\n // For simplicity, we'll use the content as is, which should work with basic formatting\n\n // First send the title as a separate message\n\n // disabled title for now, it seemes unnecessary...\n // await bot.api.sendMessage(chatId, `*${title}*`, { parse_mode: \"Markdown\" });\n\n // Then send the main content\n // Telegram has a 4096 character limit per message, so we might need to split it\n const MAX_LENGTH = 4000; // A bit less than 4096 to be safe\n\n if (content.length <= MAX_LENGTH) {\n await bot.api.sendMessage(chatId, content, { parse_mode: \"Markdown\" });\n // Store the briefing in chat history\n await storeChatMessage(\n chatId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n content,\n true\n );\n } else {\n // Split the content into chunks\n const chunks = [];\n let currentChunk = \"\";\n\n for (const line of content.split(\"\\n\")) {\n if ((currentChunk + line + \"\\n\").length > MAX_LENGTH) {\n chunks.push(currentChunk);\n currentChunk = line + \"\\n\";\n } else {\n currentChunk += line + \"\\n\";\n }\n }\n\n if (currentChunk) {\n chunks.push(currentChunk);\n }\n\n // Send each chunk as a separate message and store in chat history\n for (const chunk of chunks) {\n await bot.api.sendMessage(chatId, chunk, { parse_mode: \"Markdown\" });\n // Store each chunk in chat history\n await storeChatMessage(\n chatId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n chunk,\n true\n );\n // Add a small delay to avoid rate limiting\n await new Promise((resolve) => setTimeout(resolve, 500));\n }\n }\n\n console.log(\"Daily briefing sent successfully via Telegram.\");\n return \"Daily briefing sent successfully.\";\n}\n\nfunction generateWeekDays(today) {\n let output = [];\n\n // Add today\n output.push(`* Today: ${today.toFormat(\"EEEE, MMMM d\")}`);\n\n // Add tomorrow\n const tomorrow = today.plus({ days: 1 });\n output.push(`* Tomorrow: ${tomorrow.toFormat(\"EEEE, MMMM d\")}`);\n\n // Add rest of the week\n for (let i = 2; i < 7; i++) {\n const futureDay = today.plus({ days: i });\n output.push(`* ${futureDay.toFormat(\"EEEE, MMMM d\")}`);\n }\n\n return output.join(\"\\n\");\n}\n\n// Example usage:\n// const weekDays = generateWeekDays();\n// console.log(weekDays);\n\n// Export a function that calls sendDailyBriefing with no parameters\n// This maintains backward compatibility with existing cron jobs\nexport default async function (overrideToday?: DateTime) {\n return await sendDailyBriefing(undefined, overrideToday);\n}\n",[459,463],"8d04111547c57b24589ca0a42419a515431d3171ccc1e9308f54ac323c526413","dailyBriefing/cronDailyBrief.ts",{"_32":471,"_13":472,"_81":473,"_83":454,"_85":33,"_86":104,"_88":26,"_34":474,"_40":22,"_91":211,"_93":475,"_67":50,"_95":-5,"_96":-7,"_73":476,"_98":477},"f2b6e90c-17c5-11f0-8a41-569c3dd06744","cronDailyBrief.ts","61acb00d-24f0-49a2-bbb0-7411e0566414",["D",1744479939609],"import { sendDailyBriefing } from \"./sendDailyBrief.ts\";\n\nexport async function cronDailyBrief() {\n try {\n const chatId = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!chatId) {\n console.error(\"TELEGRAM_CHAT_ID is not configured.\");\n return;\n }\n\n console.log(\"Sending scheduled daily briefing...\");\n const result = await sendDailyBriefing(chatId);\n return result;\n } catch (error) {\n console.error(\"Error sending scheduled daily briefing:\", error);\n throw error;\n }\n}\n\n// Export as default for cron scheduling\nexport default cronDailyBrief;\n",[459,472],"86b457a7246ef1a23ad8766add77aa3fceb73db2fe7ee9455fa2741e522a6b39",{"_32":479,"_13":459,"_81":454,"_83":-5,"_85":33,"_86":104,"_88":26,"_34":480,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":481,"_98":-5},"f2b6fed8-17c5-11f0-8a41-569c3dd06744",["D",1744479939609],[459],"backstory.ts",{"_32":484,"_13":482,"_81":485,"_83":-5,"_85":33,"_86":104,"_88":26,"_34":486,"_40":22,"_91":92,"_93":487,"_67":50,"_95":-5,"_96":-7,"_73":488,"_98":489},"f2b7e140-17c5-11f0-8a41-569c3dd06744","2c4e5f35-8ec4-4018-b94e-6f3829ece4b4",["D",1744479939609],"export const backstory = `\nYou are Stevens, the dignified and highly professional butler from Kazuo Ishiguro's \"The Remains of the Day\".\n\nYou are now employed by a new family, who you serve 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",[482],"5fb5c7d6b24b57b74b58de055ccf4d0511f95eb5a2879fdae437b14094a23654",{"_73":865,"_75":-7,"_77":1148},{"_73":1139,"_75":-7,"_77":1140},{"_73":1129,"_75":-7,"_77":1130},{"_73":1118,"_75":-7,"_77":1119},{"_73":1109,"_75":-7,"_77":1110},{"_73":399,"_75":-7,"_77":1105},{"_73":1099,"_75":-7,"_77":1100},{"_73":1089,"_75":-7,"_77":1090},{"_73":1079,"_75":-7,"_77":1080},{"_73":1068,"_75":-7,"_77":1069},{"_73":1058,"_75":-7,"_77":1059},{"_73":1047,"_75":-7,"_77":1048},{"_73":1040,"_75":-7,"_77":1041},{"_73":1030,"_75":-7,"_77":1031},{"_73":1017,"_75":-7,"_77":1018},{"_73":1008,"_75":-7,"_77":1009},{"_73":954,"_75":-7,"_77":1004},{"_73":995,"_75":-7,"_77":996},{"_73":985,"_75":-7,"_77":986},{"_73":975,"_75":-7,"_77":976},{"_73":965,"_75":-7,"_77":966},{"_73":955,"_75":-7,"_77":956},{"_73":943,"_75":-7,"_77":944},{"_73":323,"_75":-7,"_77":938},{"_73":928,"_75":-7,"_77":929},{"_73":918,"_75":-7,"_77":919},{"_73":907,"_75":-7,"_77":908},{"_73":565,"_75":-7,"_77":902},{"_73":892,"_75":-7,"_77":893},{"_73":882,"_75":-7,"_77":883},{"_73":876,"_75":-7,"_77":877},{"_73":866,"_75":-7,"_77":867},{"_73":854,"_75":-7,"_77":855},{"_73":845,"_75":-7,"_77":846},{"_73":835,"_75":-7,"_77":836},{"_73":825,"_75":-7,"_77":826},{"_73":819,"_75":-7,"_77":820},{"_73":813,"_75":-7,"_77":814},{"_73":803,"_75":-7,"_77":804},{"_73":793,"_75":-7,"_77":794},{"_73":784,"_75":-7,"_77":785},{"_73":774,"_75":-7,"_77":775},{"_73":764,"_75":-7,"_77":765},{"_73":754,"_75":-7,"_77":755},{"_73":744,"_75":-7,"_77":745},{"_73":734,"_75":-7,"_77":735},{"_73":724,"_75":-7,"_77":725},{"_73":714,"_75":-7,"_77":715},{"_73":704,"_75":-7,"_77":705},{"_73":694,"_75":-7,"_77":695},{"_73":684,"_75":-7,"_77":685},{"_73":674,"_75":-7,"_77":675},{"_73":664,"_75":-7,"_77":665},{"_73":655,"_75":-7,"_77":656},{"_73":645,"_75":-7,"_77":646},{"_73":636,"_75":-7,"_77":637},{"_73":626,"_75":-7,"_77":627},{"_73":619,"_75":-7,"_77":620},{"_73":606,"_75":-7,"_77":607},{"_73":596,"_75":-7,"_77":597},{"_73":586,"_75":-7,"_77":587},{"_73":576,"_75":-7,"_77":577},{"_73":566,"_75":-7,"_77":567},{"_73":554,"_75":-7,"_77":555},"ui-kit/vitest.config.ts",{"_32":556,"_13":557,"_81":558,"_83":559,"_85":60,"_86":560,"_88":26,"_34":561,"_40":22,"_91":92,"_93":562,"_67":50,"_95":-5,"_96":-7,"_73":563,"_98":564},"874c38ea-4d8d-11f0-825e-76b3cceeab13","vitest.config.ts","874c39b2-4d8d-11f0-825e-76b3cceeab13","868edb7e-4d8d-11f0-b958-76b3cceeab13",191,["D",1750393070407],"import { defineConfig } from 'vitest/config';\nimport react from '@vitejs/plugin-react';\n\nexport default defineConfig({\n plugins: [react()],\n test: {\n environment: 'jsdom',\n setupFiles: ['./src/setupTests.ts'],\n globals: true,\n css: true,\n coverage: {\n reporter: ['text', 'html'],\n exclude: [\n '**/*.d.ts',\n '**/*.stories.*',\n '**/index.ts',\n '**/setupTests.ts',\n ],\n },\n include: [\n 'src/**/*.test.{ts,tsx}',\n 'src/**/*.spec.{ts,tsx}',\n 'src/**/__tests__/*.{ts,tsx}',\n 'src/components/**/*.test.{ts,tsx}',\n ],\n },\n});\n",[565,557],"41b86b895154b9a4cd1bbab4c1a3d47b6ef06b279b1da2d3a0a0e345b1efb53f","ui-kit","ui-kit/vite.config.ts",{"_32":568,"_13":569,"_81":570,"_83":559,"_85":60,"_86":571,"_88":26,"_34":572,"_40":22,"_91":92,"_93":573,"_67":50,"_95":-5,"_96":-7,"_73":574,"_98":575},"87482a7a-4d8d-11f0-ade6-76b3cceeab13","vite.config.ts","87482b2e-4d8d-11f0-ade6-76b3cceeab13",190,["D",1750393070380],"import { defineConfig } from 'vite'\nimport react from '@vitejs/plugin-react'\nimport dts from 'vite-plugin-dts'\nimport { resolve } from 'path'\n\n// https://vitejs.dev/config/\nexport default defineConfig({\n plugins: [\n react(),\n dts({\n insertTypesEntry: true,\n }),\n ],\n build: {\n lib: {\n entry: resolve(__dirname, 'src/index.ts'),\n name: 'PersonalShopperUIKit',\n formats: ['es'],\n fileName: 'index',\n },\n rollupOptions: {\n external: ['react', 'react-dom', 'react/jsx-runtime'],\n output: {\n globals: {\n react: 'React',\n 'react-dom': 'ReactDOM',\n 'react/jsx-runtime': 'react/jsx-runtime',\n },\n },\n },\n },\n resolve: {\n alias: {\n '@': resolve(__dirname, './src'),\n },\n },\n})\n",[565,569],"17a60a1366e6ae2f3ad36ab4250d752ad36acab5db7ae16e8f696dad6e4ae357","ui-kit/tsconfig.node.json",{"_32":578,"_13":579,"_81":580,"_83":559,"_85":60,"_86":581,"_88":26,"_34":582,"_40":22,"_91":117,"_93":583,"_67":50,"_95":-5,"_96":-7,"_73":584,"_98":585},"8721c984-4d8d-11f0-ade6-76b3cceeab13","tsconfig.node.json","8721ca4c-4d8d-11f0-ade6-76b3cceeab13",182,["D",1750393070118],"{\n \"compilerOptions\": {\n \"composite\": true,\n \"skipLibCheck\": true,\n \"module\": \"ESNext\",\n \"moduleResolution\": \"bundler\",\n \"allowSyntheticDefaultImports\": true,\n \"strict\": true\n },\n \"include\": [\"vite.config.ts\", \".storybook/**/*\"]\n}\n",[565,579],"97314c3154f51cb6fde3196e3797f813945c10e1dc3f9e506b3863256e7b42b0","ui-kit/tsconfig.json",{"_32":588,"_13":589,"_81":590,"_83":559,"_85":60,"_86":591,"_88":26,"_34":592,"_40":22,"_91":117,"_93":593,"_67":50,"_95":-5,"_96":-7,"_73":594,"_98":595},"8744acba-4d8d-11f0-bb34-76b3cceeab13","tsconfig.json","8744ad82-4d8d-11f0-bb34-76b3cceeab13",189,["D",1750393070359],"{\n \"compilerOptions\": {\n \"target\": \"ES2020\",\n \"useDefineForClassFields\": true,\n \"lib\": [\"ES2020\", \"DOM\", \"DOM.Iterable\"],\n \"module\": \"ESNext\",\n \"skipLibCheck\": true,\n\n /* Bundler mode */\n \"moduleResolution\": \"bundler\",\n \"allowImportingTsExtensions\": true,\n \"resolveJsonModule\": true,\n \"isolatedModules\": true,\n \"noEmit\": true,\n \"jsx\": \"react-jsx\",\n\n /* Linting */\n \"strict\": true,\n \"noUnusedLocals\": true,\n \"noUnusedParameters\": true,\n \"noFallthroughCasesInSwitch\": true,\n\n /* Path mapping */\n \"baseUrl\": \".\",\n \"paths\": {\n \"@/*\": [\"./src/*\"]\n },\n\n /* Library build */\n \"declaration\": true,\n \"declarationMap\": true,\n \"outDir\": \"./dist\"\n },\n \"include\": [\n \"src/**/*\",\n \"components/**/*\"\n ],\n \"exclude\": [\n \"node_modules\",\n \"dist\",\n \"storybook-static\"\n ],\n \"references\": [{ \"path\": \"./tsconfig.node.json\" }]\n}\n",[565,589],"c91f0a30699f3d128f339fce95463f85d96fec70a052f74d7f7c092c8aafa9f1","ui-kit/tailwind.config.js",{"_32":598,"_13":599,"_81":600,"_83":559,"_85":60,"_86":601,"_88":26,"_34":602,"_40":22,"_91":92,"_93":603,"_67":50,"_95":-5,"_96":-7,"_73":604,"_98":605},"87250ea0-4d8d-11f0-a09a-76b3cceeab13","tailwind.config.js","87250f36-4d8d-11f0-a09a-76b3cceeab13",183,["D",1750393070119],"/** @type {import('tailwindcss').Config} */\nexport default {\n content: [\n \"./components/**/*.{js,ts,jsx,tsx}\",\n \"./src/**/*.{js,ts,jsx,tsx}\",\n \"./.storybook/**/*.{js,ts,jsx,tsx}\",\n ],\n theme: {\n extend: {\n colors: {\n primary: {\n 50: '#eff6ff',\n 100: '#dbeafe',\n 200: '#bfdbfe',\n 300: '#93c5fd',\n 400: '#60a5fa',\n 500: '#3b82f6',\n 600: '#2563eb',\n 700: '#1d4ed8',\n 800: '#1e40af',\n 900: '#1e3a8a',\n },\n secondary: {\n 50: '#f9fafb',\n 100: '#f3f4f6',\n 200: '#e5e7eb',\n 300: '#d1d5db',\n 400: '#9ca3af',\n 500: '#6b7280',\n 600: '#4b5563',\n 700: '#374151',\n 800: '#1f2937',\n 900: '#111827',\n },\n success: {\n 50: '#f0fdf4',\n 100: '#dcfce7',\n 200: '#bbf7d0',\n 300: '#86efac',\n 400: '#4ade80',\n 500: '#22c55e',\n 600: '#16a34a',\n 700: '#15803d',\n 800: '#166534',\n 900: '#14532d',\n },\n warning: {\n 50: '#fffbeb',\n 100: '#fef3c7',\n 200: '#fde68a',\n 300: '#fcd34d',\n 400: '#fbbf24',\n 500: '#f59e0b',\n 600: '#d97706',\n 700: '#b45309',\n 800: '#92400e',\n 900: '#78350f',\n },\n error: {\n 50: '#fef2f2',\n 100: '#fee2e2',\n 200: '#fecaca',\n 300: '#fca5a5',\n 400: '#f87171',\n 500: '#ef4444',\n 600: '#dc2626',\n 700: '#b91c1c',\n 800: '#991b1b',\n 900: '#7f1d1d',\n },\n },\n fontFamily: {\n sans: [\n '-apple-system',\n 'BlinkMacSystemFont',\n 'Segoe UI',\n 'Roboto',\n 'Oxygen',\n 'Ubuntu',\n 'Cantarell',\n 'Fira Sans',\n 'Droid Sans',\n 'Helvetica Neue',\n 'sans-serif',\n ],\n },\n spacing: {\n '18': '4.5rem',\n '88': '22rem',\n },\n maxWidth: {\n '8xl': '88rem',\n '9xl': '96rem',\n },\n animation: {\n 'fade-in': 'fadeIn 0.5s ease-in-out',\n 'slide-up': 'slideUp 0.3s ease-out',\n 'slide-down': 'slideDown 0.3s ease-out',\n },\n keyframes: {\n fadeIn: {\n '0%': { opacity: '0' },\n '100%': { opacity: '1' },\n },\n slideUp: {\n '0%': { transform: 'translateY(10px)', opacity: '0' },\n '100%': { transform: 'translateY(0)', opacity: '1' },\n },\n slideDown: {\n '0%': { transform: 'translateY(-10px)', opacity: '0' },\n '100%': { transform: 'translateY(0)', opacity: '1' },\n },\n },\n },\n },\n plugins: [],\n}\n",[565,599],"bd2ecfbaa593eefc3eb04faa8e33da3c12837b99ae63115570bf6746016af3b7","ui-kit/src/styles/globals.css",{"_32":608,"_13":609,"_81":610,"_83":611,"_85":60,"_86":612,"_88":26,"_34":613,"_40":22,"_91":117,"_93":614,"_67":50,"_95":-5,"_96":-7,"_73":615,"_98":616},"877016ac-4d8d-11f0-a392-76b3cceeab13","globals.css","87701742-4d8d-11f0-a392-76b3cceeab13","86c69a6e-4d8d-11f0-b958-76b3cceeab13",198,["D",1750393070485],"@tailwind base;\n@tailwind components;\n@tailwind utilities;\n\n/* Custom base styles */\n@layer base {\n * {\n box-sizing: border-box;\n }\n\n html,\n body {\n padding: 0;\n margin: 0;\n font-family: -apple-system, BlinkMacSystemFont, Segoe UI, Roboto, Oxygen,\n Ubuntu, Cantarell, Fira Sans, Droid Sans, Helvetica Neue, sans-serif;\n }\n\n a {\n color: inherit;\n text-decoration: none;\n }\n\n button {\n font-family: inherit;\n }\n}\n\n/* Custom component styles */\n@layer components {\n .btn-primary {\n @apply inline-flex items-center px-4 py-2 border border-transparent text-sm font-medium rounded-md shadow-sm text-white bg-blue-600 hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500;\n }\n\n .btn-secondary {\n @apply inline-flex items-center px-4 py-2 border border-gray-300 text-sm font-medium rounded-md shadow-sm text-gray-700 bg-white hover:bg-gray-50 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500;\n }\n\n .card {\n @apply bg-white overflow-hidden shadow rounded-lg;\n }\n\n .form-input {\n @apply block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm;\n }\n}\n\n/* Custom utility styles */\n@layer utilities {\n .text-balance {\n text-wrap: balance;\n }\n}\n",[565,617,618,609],"98038622d63b1b9284c5f252f5865f5a8d6a1bc87f62323e121111e2b3e72100","src","styles","ui-kit/src/styles",{"_32":621,"_13":618,"_81":611,"_83":622,"_85":60,"_86":623,"_88":26,"_34":624,"_40":22,"_91":236,"_93":-5,"_67":50,"_95":-5,"_96":-7,"_73":625,"_98":-5},"86c699c4-4d8d-11f0-b958-76b3cceeab13","86b5cd92-4d8d-11f0-9d77-76b3cceeab13",169,["D",1750393069531],[565,617,618],"ui-kit/src/setupTests.ts",{"_32":628,"_13":629,"_81":630,"_83":622,"_85":60,"_86":631,"_88":26,"_34":632,"_40":22,"_91":92,"_93":633,"_67":50,"_95":-5,"_96":-7,"_73":634,"_98":635},"8757b030-4d8d-11f0-863f-76b3cceeab13","setupTests.ts","8757b102-4d8d-11f0-863f-76b3cceeab13",193,["D",1750393070483],"import \"@testing-library/jest-dom\";\n\n// Mock window.alert for tests (Vitest)\nbeforeAll(() => {\n window.alert = vi.fn();\n});\n\n// Only mock setSelectionRange as a no-op for Vitest/jsdom\nbeforeAll(() => {\n Object.defineProperty(HTMLTextAreaElement.prototype, \"setSelectionRange\", {\n writable: true,\n value: () => {},\n });\n});\n",[565,617,629],"54ffb7315e3a15c53a42c0dd9a466e56919c421902866e0ceed3948e62638573","ui-kit/src/index.ts",{"_32":638,"_13":392,"_81":639,"_83":622,"_85":60,"_86":640,"_88":26,"_34":641,"_40":22,"_91":92,"_93":642,"_67":50,"_95":-5,"_96":-7,"_73":643,"_98":644},"878032a8-4d8d-11f0-a7ec-76b3cceeab13","87803352-4d8d-11f0-a7ec-76b3cceeab13",201,["D",1750393070747],"// Main library exports\nexport { Dashboard } from \"src/components/Dashboard\";\nexport { DashboardCard } from \"src/components/DashboardCard\";\nexport { CurrentLocationIndicator } from \"src/components/CurrentLocationIndicator\";\nexport { LocationSearch } from \"src/components/LocationSearch\";\nexport { LoginPage } from \"src/components/LoginPage\";\nexport { Navbar } from \"src/components/Navbar\";\nexport { ShoppingListCreator } from \"src/components/ShoppingListCreator\";\nexport { ProductCard } from \"src/components/ProductCard\";\n\n// Type exports\nexport type {\n DashboardProps,\n DashboardCardProps,\n CurrentLocationIndicatorProps,\n LocationSearchProps,\n NavbarProps,\n} from \"src/components/types\";\nexport type { ProductCardProps, Product } from \"src/components/ProductCard\";\n\n// Re-export shared types for convenience\nexport type { UserData, Location } from \"../../shared/types\";\n",[565,617,392],"3e5a9afeead89e4bfbc949dd6f7b2881c6040c4b444a0e117dba617974d4d5e2","ui-kit/src/components/types.ts",{"_32":647,"_13":80,"_81":648,"_83":649,"_85":60,"_86":650,"_88":26,"_34":651,"_40":104,"_91":92,"_93":652,"_67":50,"_95":-5,"_96":-7,"_73":653,"_98":654},"871abfa4-4d8d-11f0-aae6-76b3cceeab13","e312bb92-44e4-11f0-bb93-76b3cceeab13","86d722f8-4d8d-11f0-bcd0-76b3cceeab13",180,["D",1750393069755],"import { ReactNode } from \"react\";\nimport { UserData, Location } from \"../../shared/types.ts\";\n\nexport interface DashboardCardProps {\n title: string;\n count: string | number;\n icon: ReactNode;\n actionText: string;\n onAction: () => void;\n}\n\nexport interface NavbarProps {\n userData: UserData;\n}\n\nexport interface DashboardProps {\n userData: UserData;\n}\n\nexport interface LocationSearchProps {\n onLocationSelected?: () => void;\n}\n\nexport interface CurrentLocationIndicatorProps {\n location: Location | null;\n onClick: () => void;\n}\n",[565,617,352,80],"74942df82919b4bc56f8a0f0e8419336dbd6100592030af181071eb2b4302821","ui-kit/src/components/ShoppingListCreator.tsx",{"_32":657,"_13":658,"_81":659,"_83":649,"_85":60,"_86":59,"_88":26,"_34":660,"_40":104,"_91":92,"_93":661,"_67":50,"_95":-5,"_96":-7,"_73":662,"_98":663},"1bfd5c80-4d8e-11f0-8ebd-76b3cceeab13","ShoppingListCreator.tsx","87cfa3ec-4d8d-11f0-be1b-76b3cceeab13",["D",1750393319539],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef } from \"https://esm.sh/react@18.2.0\";\n\ntype ShoppingListCreatorProps = {\n initialValue?: string | string[];\n onChange?: (value: string[]) => void;\n onCursorLineChange?: (lineNumber: number) => void;\n};\n\n/**\n * Utility to process textarea value into array of items.\n * Removes leading '*' and trims whitespace from each line.\n */\nfunction parseItems(value: string): string[] {\n return value\n .split(\"\\n\")\n .map((line) => line.replace(/^\\s*\\*\\s?/, \"\").trim())\n .filter((line) => line.length > 0);\n}\n\n/**\n * Converts an array of strings (or a string) into textarea value,\n * ensuring each line starts with '* ' and is trimmed.\n */\nfunction toTextareaValue(val: string | string[] | undefined): string {\n if (Array.isArray(val)) {\n return val\n .map((item) => {\n const clean = String(item)\n .replace(/^\\s*\\*\\s?/, \"\")\n .trim();\n return clean.length > 0 ? `* ${clean}` : \"\";\n })\n .filter(Boolean)\n .join(\"\\n\");\n }\n if (typeof val === \"string\") {\n return val;\n }\n return \"\";\n}\n\nexport function ShoppingListCreator({\n initialValue = \"\",\n onChange,\n onCursorLineChange,\n}: ShoppingListCreatorProps): JSX.Element {\n const [value, setValue] = useState(() => toTextareaValue(initialValue));\n const lastLineRef = useRef(null);\n\n // Expose processed items array\n const items = parseItems(value);\n\n const handleChange = (e: React.ChangeEvent) => {\n setValue(e.target.value);\n if (onChange) {\n onChange(parseItems(e.target.value));\n }\n // Also check cursor position on change\n maybeNotifyCursorLine(e.target);\n };\n\n const handleSelect = (e: React.SyntheticEvent) => {\n maybeNotifyCursorLine(e.target as HTMLTextAreaElement);\n };\n\n // Helper to determine line number and call onCursorLineChange if changed\n const maybeNotifyCursorLine = (textarea: HTMLTextAreaElement) => {\n const cursorPos = textarea.selectionStart;\n const textUptoCursor = textarea.value.slice(0, cursorPos);\n const lineNumber = textUptoCursor.split(\"\\n\").length; // 1-based\n if (lastLineRef.current !== lineNumber) {\n lastLineRef.current = lineNumber;\n if (onCursorLineChange) {\n onCursorLineChange(lineNumber);\n }\n }\n };\n\n return (\n

\n Shopping List\n

\n\n {/* Shopping List Textarea */}\n

\n \n

\n );\n}\n",[565,617,352,658],"6940e0779d4a1dc9f6243c04fa6e64cd022a2c39e31b78e08a7cc563a21991a3","ui-kit/src/components/ShoppingListCreator.stories.tsx",{"_32":666,"_13":667,"_81":668,"_83":649,"_85":60,"_86":669,"_88":26,"_34":670,"_40":22,"_91":92,"_93":671,"_67":50,"_95":-5,"_96":-7,"_73":672,"_98":673},"87784f20-4d8d-11f0-a7ec-76b3cceeab13","ShoppingListCreator.stories.tsx","87784ff2-4d8d-11f0-a7ec-76b3cceeab13",200,["D",1750393070695],"import React from \"react\";\nimport { Meta, StoryObj } from \"@storybook/react\";\nimport { ShoppingListCreator } from \"./ShoppingListCreator\";\n\nconst meta: Meta = {\n title: \"Components/ShoppingListCreator\",\n component: ShoppingListCreator,\n parameters: {\n layout: \"centered\",\n },\n};\n\nexport default meta;\n\ntype Story = StoryObj;\n\nexport const Default: Story = {\n render: () => {\n const [items, setItems] = React.useState([]);\n const [cursorLine, setCursorLine] = React.useState(null);\n\n return (\n

\n {\n setItems(value);\n // eslint-disable-next-line no-console\n console.log(\"onChange:\", value);\n }}\n onCursorLineChange={(line) => {\n setCursorLine(line);\n // eslint-disable-next-line no-console\n console.log(\"onCursorLineChange: line\", line);\n }}\n />\n

\n Current items:\n

\n              {JSON.stringify(items, null, 2)}\n

Compare

Mergebgschiller/mainintogeoffreylitt/main

README.md+112-40

shared/types.ts+176-0

.storybook

.storybook/main.ts+31-0

.storybook/preview-head.html+1-0

.storybook/preview.tsx+17-0

.vtignore+7-0

backend

backend/database

backend/database/db.ts+65-0

backend/database/krogerQueries.ts+330-0

backend/database/migrations.ts+63-0

backend/files.ts+87-0

Hbackend/index.ts+535-0

backend/services

backend/services/fakeKrogerAuth.ts+167-0

backend/services/krogerAuth.ts+225-0

deno.json+34-0

docs

docs/kroger-authorize.md+121-0

docs/kroger-cart.md+32-0

docs/kroger-identity.md+39-0

docs/kroger-location.md+366-0

docs/kroger-products.md+243-0

docs/oauth-setup.md+154-0

frontend

frontend/index.html+15-0

frontend/index.tsx+13-0

frontend/style.css+129-0

ui-kit

ui-kit/.eslintrc.cjs+43-0

ui-kit/.gitignore+115-0

ui-kit/.storybook

ui-kit/.storybook/main.ts+28-0

ui-kit/.storybook/preview.ts+46-0

ui-kit/README.md+156-0

ui-kit/package.json+70-0

ui-kit/postcss.config.js+6-0

ui-kit/src

ui-kit/src/components

ui-kit/src/components/CurrentLocationIndicator.stories.tsx+40-0

ui-kit/src/components/CurrentLocationIndicator.tsx+77-0

ui-kit/src/components/Dashboard.tsx+151-0

ui-kit/src/components/DashboardCard.stories.tsx+58-0

ui-kit/src/components/DashboardCard.tsx+39-0

ui-kit/src/components/LocationSearch.tsx+220-0

ui-kit/src/components/LoginPage.stories.tsx+18-0

ui-kit/src/components/LoginPage.tsx+49-0

ui-kit/src/components/Navbar.stories.tsx+38-0

ui-kit/src/components/Navbar.tsx+40-0

ui-kit/src/components/ProductCard.stories.tsx+133-0

ui-kit/src/components/ProductCard.tsx+222-0

ui-kit/src/components/ProductResultsList.stories.tsx+219-0

ui-kit/src/components/ProductResultsList.tsx+178-0

ui-kit/src/components/ShoppingListCreator.stories.tsx+244-0

ui-kit/src/components/ShoppingListCreator.tsx+100-0

ui-kit/src/components/types.ts+27-0

ui-kit/src/index.ts+22-0

ui-kit/src/setupTests.ts+14-0

ui-kit/src/styles

ui-kit/src/styles/globals.css+53-0

ui-kit/tailwind.config.js+117-0

ui-kit/tsconfig.json+44-0

ui-kit/tsconfig.node.json+11-0

ui-kit/vite.config.ts+37-0

ui-kit/vitest.config.ts+27-0

backstory.ts+0-8

dailyBriefing

CdailyBriefing/cronDailyBrief.ts+0-21

dailyBriefing/sendDailyBrief.ts+0-245

dailyBriefing/testDailyBrief.ts+0-30

dashboard

dashboard/README.md+0-13

dashboard/backend

dashboard/backend/README.md+0-32

dashboard/backend/database

dashboard/backend/database/README.md+0-20

dashboard/backend/database/queries.ts+0-74