\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 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\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",[],[204,258,264,270],{"_102":277,"_95":278,"_158":279,"_160":265,"_161":139,"_162":163,"_164":116,"_104":280,"_99":32,"_166":189,"_168":281,"_169":22,"_170":-5,"_171":282,"_98":283},"d529e862-1a09-11f0-bd50-569c3dd06744","NotebookView.tsx","e9df54f9-d11e-4b8a-8789-fcadc49f728d",["D",1744728998137],"/** @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 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 \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",[],[204,258,264,278],{"_102":285,"_95":286,"_158":287,"_160":265,"_161":139,"_162":163,"_164":116,"_104":288,"_99":32,"_166":189,"_168":289,"_169":22,"_170":-5,"_171":290,"_98":291},"d529f5dc-1a09-11f0-bd50-569c3dd06744","assets.ts","4e43ca83-4c1a-4182-af55-2d1a20d22363",["D",1744728998137],"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",[],[204,258,264,286],[204,258,264],{"_102":294,"_95":223,"_158":295,"_160":259,"_161":139,"_162":163,"_164":116,"_104":296,"_99":32,"_166":226,"_168":297,"_169":22,"_170":-5,"_171":298,"_98":299},"d529fd70-1a09-11f0-bd50-569c3dd06744","08a01eb1-7efd-499d-bfc8-46825814e67a",["D",1744728998137],"# 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.",[],[204,258,223],{"_102":301,"_95":302,"_158":303,"_160":259,"_161":139,"_162":163,"_164":116,"_104":304,"_99":32,"_166":226,"_168":305,"_169":22,"_170":-5,"_171":306,"_98":307},"d52a002c-1a09-11f0-bd50-569c3dd06744","favicon.svg","dc9c3eee-46f7-4c68-b514-a954b10b0733",["D",1744728998137],"",[],[204,258,302],{"_102":309,"_95":310,"_158":311,"_160":259,"_161":139,"_162":163,"_164":116,"_104":312,"_99":32,"_166":226,"_168":313,"_169":22,"_170":-5,"_171":314,"_98":315},"d52a014e-1a09-11f0-bd50-569c3dd06744","index.html","a7e2c8e9-6e84-4b3c-a5b8-7a7f7c541b13",["D",1744728998137],"\n\n \n \n \n Stevens' Notebook\n \n \n \n \n \n \n \n \n \n

\n \n \n \n\n",[],[204,258,310],{"_102":317,"_95":318,"_158":319,"_160":259,"_161":139,"_162":163,"_164":116,"_104":320,"_99":32,"_166":189,"_168":321,"_169":22,"_170":-5,"_171":322,"_98":323},"d52a02d4-1a09-11f0-bd50-569c3dd06744","index.tsx","c89f74d3-34c4-47d1-81f8-d4ea81c7a455",["D",1744728998137],"/** @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",[],[204,258,318],[204,258],{"_102":326,"_95":327,"_158":328,"_160":205,"_161":139,"_162":163,"_164":116,"_104":329,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_171":330,"_98":354},"d52a0a2c-1a09-11f0-bd50-569c3dd06744","shared","ec753c41-b109-4148-866c-a0a7070ac2eb",["D",1744728998137],[331,338,346],{"_102":332,"_95":223,"_158":333,"_160":328,"_161":139,"_162":163,"_164":116,"_104":334,"_99":32,"_166":226,"_168":335,"_169":22,"_170":-5,"_171":336,"_98":337},"d52a0590-1a09-11f0-bd50-569c3dd06744","69b72892-d9b5-4ea7-b54c-ba1a1ff9ac02",["D",1744728998137],"# 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.",[],[204,327,223],{"_102":339,"_95":340,"_158":341,"_160":328,"_161":139,"_162":163,"_164":116,"_104":342,"_99":32,"_166":189,"_168":343,"_169":22,"_170":-5,"_171":344,"_98":345},"d52a0702-1a09-11f0-bd50-569c3dd06744","types.ts","1fb0f54b-4020-4cc0-8efa-43967b9a0f55",["D",1744728998137],"/**\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",[],[204,327,340],{"_102":347,"_95":348,"_158":349,"_160":328,"_161":139,"_162":163,"_164":116,"_104":350,"_99":32,"_166":189,"_168":351,"_169":22,"_170":-5,"_171":352,"_98":353},"d52a0842-1a09-11f0-bd50-569c3dd06744","utils.ts","feb847f8-fb9a-4412-b10b-6b1cfbb7b077",["D",1744728998137],"export interface Message {\n content: string;\n}\n\nexport const MESSAGE_LIMIT = 5;",[],[204,327,348],[204,327],{"_102":356,"_95":223,"_158":357,"_160":205,"_161":139,"_162":163,"_164":116,"_104":358,"_99":32,"_166":226,"_168":359,"_169":22,"_170":-5,"_171":360,"_98":361},"d52a0b94-1a09-11f0-bd50-569c3dd06744","c82d4c5b-f11c-4650-b527-8fe4f3623815",["D",1744728998137],"# 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.",[],[204,223],[204],{"_102":364,"_95":365,"_158":366,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":367,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_171":368,"_98":420},"d52a1792-1a09-11f0-bd50-569c3dd06744","dbUtils","98b9da01-c01e-4a31-9b3a-dc834ec671c5",["D",1744728998137],[369,378,386,394,402,411],{"_102":370,"_95":371,"_158":372,"_160":366,"_161":139,"_162":373,"_164":116,"_104":374,"_99":32,"_166":189,"_168":375,"_169":22,"_170":-5,"_171":376,"_98":377},"372c1706-1aeb-11f0-91c5-569c3dd06744","cleanDatabase.ts","372c17f6-1aeb-11f0-91c5-569c3dd06744",31,["D",1744825799289],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\r\n\r\nconst TABLE_NAME = \"memories\";\r\n\r\n/**\r\n * Clears all data from the memories database\r\n * Can be used to remove demo data or start fresh\r\n */\r\nexport default async function cleanDatabase() {\r\n try {\r\n console.log(\"Clearing all data from memories database...\");\r\n \r\n // Delete all records from the memories table\r\n const result = await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\r\n \r\n console.log(`✅ Deleted ${result.rowsAffected} records from the database.`);\r\n return `Deleted ${result.rowsAffected} records from the database.`;\r\n } catch (error) {\r\n console.error(\"Error clearing database:\", error);\r\n throw error;\r\n }\r\n}\r\n\r\n// Run this file directly if needed\r\n// @ts-ignore: Deno-specific API\r\nif (import.meta.url === Deno.mainModule) {\r\n await cleanDatabase();\r\n} ",[],[365,371],{"_102":379,"_95":380,"_158":381,"_160":366,"_161":139,"_162":163,"_164":116,"_104":382,"_99":32,"_166":189,"_168":383,"_169":22,"_170":-5,"_171":384,"_98":385},"d52a0fb8-1a09-11f0-bd50-569c3dd06744","migrateMemoriesDb.ts","c20203df-d9c0-406c-95ed-4e1110f5b235",["D",1744728998137],"// 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",[],[365,380],{"_102":387,"_95":388,"_158":389,"_160":366,"_161":139,"_162":163,"_164":116,"_104":390,"_99":32,"_166":189,"_168":391,"_169":22,"_170":-5,"_171":392,"_98":393},"d52a122e-1a09-11f0-bd50-569c3dd06744","populateCreatedBy.ts","6187e2b8-4e75-4d61-b545-875bb4a2d201",["D",1744728998137],"// 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",[],[365,388],{"_102":395,"_95":396,"_158":397,"_160":366,"_161":139,"_162":163,"_164":116,"_104":398,"_99":32,"_166":189,"_168":399,"_169":22,"_170":-5,"_171":400,"_98":401},"d52a149a-1a09-11f0-bd50-569c3dd06744","populateMemoryIds.ts","47048fda-74be-42b6-9a9d-b25812390bb9",["D",1744728998137],"// 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",[],[365,396],{"_102":403,"_95":404,"_158":405,"_160":366,"_161":139,"_162":406,"_164":116,"_104":407,"_99":32,"_166":189,"_168":408,"_169":22,"_170":-5,"_171":409,"_98":410},"da3b7a66-1ae8-11f0-a94e-569c3dd06744","setupDatabase.ts","da3b7b56-1ae8-11f0-a94e-569c3dd06744",21,["D",1744824784170],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\r\n\r\nconst TABLE_NAME = \"memories\";\r\n\r\n/**\r\n * Creates the memories table in the database if it doesn't exist\r\n */\r\nexport default async function setupDatabase() {\r\n try {\r\n console.log(\"Setting up memories database...\");\r\n \r\n // Create the memories table\r\n await sqlite.execute(`\r\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\r\n id TEXT PRIMARY KEY,\r\n date TEXT,\r\n text TEXT NOT NULL,\r\n createdBy TEXT,\r\n createdDate NUMBER,\r\n tags TEXT\r\n )\r\n `);\r\n \r\n // Create an index on id for faster lookups\r\n await sqlite.execute(`\r\n CREATE INDEX IF NOT EXISTS idx_memories_id ON ${TABLE_NAME}(id)\r\n `);\r\n \r\n // Create an index on date for faster lookups\r\n await sqlite.execute(`\r\n CREATE INDEX IF NOT EXISTS idx_memories_date ON ${TABLE_NAME}(date)\r\n `);\r\n \r\n // Create an index on tags for faster lookups\r\n await sqlite.execute(`\r\n CREATE INDEX IF NOT EXISTS idx_memories_tags ON ${TABLE_NAME}(tags)\r\n `);\r\n \r\n console.log(\"Database setup complete.\");\r\n return \"Database setup complete.\";\r\n } catch (error) {\r\n console.error(\"Error setting up database:\", error);\r\n throw error;\r\n }\r\n}\r\n\r\n// Run this file directly if needed\r\n// @ts-ignore: Deno-specific API\r\nif (import.meta.url && import.meta.url === Deno.mainModule) {\r\n await setupDatabase();\r\n} ",[],[365,404],{"_102":412,"_95":413,"_158":414,"_160":366,"_161":139,"_162":144,"_164":116,"_104":415,"_99":416,"_166":189,"_168":417,"_169":22,"_170":-5,"_171":418,"_98":419},"9a63b13c-1a17-11f0-ab7e-569c3dd06744","setupTelegramChatDb.ts","84287424-608a-42b3-bb90-d8943851ea7f",["D",1744734912517],2,"export default async function() {\n try {\n console.log(\"Starting direct telegram table creation...\");\n\n // Import SQLite directly\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n console.log(\"SQLite module imported successfully\");\n\n // Create the telegram_chats table directly\n console.log(\"Creating 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 console.log(\"telegram_chats table created\");\n\n // Create an index directly\n console.log(\"Creating index on chat_id...\");\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_telegram_chats_chat_id ON telegram_chats(chat_id)\n `);\n console.log(\"Index created successfully\");\n\n // Verify the table was created\n console.log(\"Verifying table creation...\");\n const tableCheck = await sqlite.execute(`\n SELECT name FROM sqlite_master WHERE type='table' AND name='telegram_chats'\n `);\n console.log(\"Verification result:\", tableCheck.rows);\n\n console.log(\"Setup complete!\");\n return {\n success: true,\n message: \"Telegram chat database table created successfully.\",\n verification: tableCheck.rows,\n };\n } catch (error) {\n console.error(\"ERROR IN DIRECT SETUP:\", error);\n console.error(\"Error stack:\", error.stack);\n return {\n success: false,\n error: error.message,\n stack: error.stack,\n };\n }\n}",[],[365,413],[365],{"_102":422,"_95":423,"_158":424,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":425,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_171":426,"_98":472},"d52a4d8e-1a09-11f0-bd50-569c3dd06744","importers","44507d7e-de5c-4c0f-9887-01add8fe3e17",["D",1744728998137],[427,436,446,455,463],{"_102":428,"_95":429,"_158":430,"_160":424,"_161":139,"_162":431,"_164":116,"_104":432,"_99":416,"_166":179,"_168":433,"_169":22,"_170":-5,"_171":434,"_98":435},"daf55124-1eae-11f0-a670-569c3dd06744","generateFunFacts.ts","6f3fdbdd-f495-49eb-95ba-2c8256bfa9ca",49,["D",1745239679503],"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 * Deletes all fun facts from the database\n */\nasync function deleteAllFunFacts() {\n try {\n // First check if the table exists\n const tableCheck = await sqlite.execute(`\n SELECT name FROM sqlite_master \n WHERE type='table' AND name='${TABLE_NAME}'\n `);\n \n if (tableCheck.rows?.length > 0) {\n // Then delete the fun facts\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE_NAME} WHERE tags = :tag`,\n args: { tag: TAG_NAME }\n });\n \n console.log(\"All fun facts cleared from database\");\n return true;\n } else {\n console.log(\"Memories table does not exist yet, nothing to clear\");\n return true;\n }\n } catch (error) {\n console.error(\"Error deleting all fun facts:\", error);\n return false;\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 * @param category The category of the fun fact\n */\nasync function insertFunFact(date, factText, category = \"\") {\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 Perth time\n const today = DateTime.now().setZone(\"Australia/Perth\").startOf(\"day\");\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. History: Interesting historical events that happened on this day in history\n2. Science: Fascinating scientific discoveries or concepts\n3. Nature: Interesting facts about animals, plants, or natural phenomena\n4. Technology: Innovative technologies or digital advancements\n5. Art & Culture: Noteworthy cultural facts, art history, or literary trivia\n6. Geography: Intriguing places, landmarks, or geographic phenomena\n7. Food & Cuisine: Facts about culinary traditions or interesting foods\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 and well-researched\n- If using \"on this day in history\" facts, make sure they're relevant to the date\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\": \"history\" | \"science\" | \"nature\" | \"technology\" | \"art\" | \"geography\" | \"food\"\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 * @param resetDb Whether to reset the fun facts database before generating new facts\n */\nexport async function generateAndStoreFunFacts(resetDb = false) {\n try {\n // Optionally reset the fun facts database\n if (resetDb) {\n await deleteAllFunFacts();\n }\n \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(\"Australia/Perth\").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, fact.category);\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 * Resets the fun facts database and generates new facts\n */\nexport async function resetAndGenerateFunFacts() {\n return await generateAndStoreFunFacts(true);\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 resetAndGenerateFunFacts();\n}",[],[423,429],{"_102":437,"_95":438,"_158":439,"_160":424,"_161":139,"_162":440,"_164":116,"_104":441,"_99":442,"_166":179,"_168":443,"_169":22,"_170":-5,"_171":444,"_98":445},"62dcb8e0-1f6b-11f0-beb2-569c3dd06744","getCalendarEvents.ts","9297d647-eb37-402c-822a-d651da7b197b",62,["D",1745320652898],10,"import { 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 = \"Australia/Perth\";\n\n// Define TypeScript interfaces for Google Calendar API responses\ninterface CalendarEventDateTime {\n dateTime?: string;\n date?: string;\n timeZone?: string;\n}\n\ninterface CalendarEvent {\n id: string;\n summary: string;\n description?: string;\n location?: string;\n start: CalendarEventDateTime;\n end: CalendarEventDateTime;\n status?: string;\n}\n\ninterface CalendarList {\n kind: string;\n items: {\n id: string;\n summary: string;\n accessRole: string;\n }[];\n}\n\ninterface CalendarEventsResponse {\n kind: string;\n items: CalendarEvent[];\n}\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 parse ISO date string and convert to local timezone\nfunction parseDateTime(isoString: string, timezone: string): DateTime {\n // If no timezone is provided in the event, use LOCAL_TIMEZONE\n const eventTimezone = timezone || LOCAL_TIMEZONE;\n \n // Parse the ISO string with Luxon and set to the event's timezone\n let dt = DateTime.fromISO(isoString, { zone: eventTimezone });\n \n // Then convert to the local timezone for display\n dt = dt.setZone(LOCAL_TIMEZONE);\n \n return dt;\n}\n\n// Format a DateTime object to a user-friendly time string\nfunction formatTime(dt: DateTime): string {\n return dt.toFormat(\"h:mm a\"); // Format as \"1:30 pm\"\n}\n\nfunction formatEventToNaturalLanguage(event: CalendarEvent): string {\n const summary = event.summary || \"Untitled event\";\n\n if (event.start.dateTime) {\n // This is a timed event\n // Get timezone information from the event\n const timezone = event.start.timeZone || \"UTC\";\n \n // Parse the start and end times with timezone conversion\n const startDt = parseDateTime(event.start.dateTime, timezone);\n const endDt = parseDateTime(event.end.dateTime!, timezone);\n \n // Format the start and end times\n const startTime = formatTime(startDt);\n const endTime = formatTime(endDt);\n \n let text = `${summary} from ${startTime} to ${endTime}`;\n \n // Only add timezone if it's different from local and event is not in local timezone\n if (timezone !== LOCAL_TIMEZONE && !timezone.startsWith(\"+08:00\")) {\n // Format timezone in a friendly way\n let friendlyTimezone = timezone;\n if (timezone.includes(\"/\")) {\n friendlyTimezone = timezone.split(\"/\")[1].replace(\"_\", \" \").toLowerCase() + \" time\";\n }\n text += ` (converted from ${friendlyTimezone})`;\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: string, eventText: string): Promise {\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\n\n // Truncate event text if it's too long (SQLite might have limits)\n const truncatedText = eventText.length > 500 ? eventText.substring(0, 500) + \"...\" : eventText;\n \n console.log(\"inserting\", { date, eventTextLength: eventText.length, truncated: eventText.length > 500 });\n\n await sqlite.execute(\n `\n INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)\n `,\n [nanoid(10), date, truncatedText, \"calendar\", Date.now(), \"calendar\"]\n );\n}\n\n// Function to get Google OAuth token using client credentials\nasync function getGoogleAccessToken(): Promise {\n const clientId = Deno.env.get(\"GOOGLE_CLIENT_ID\");\n const clientSecret = Deno.env.get(\"GOOGLE_CLIENT_SECRET\");\n const refreshToken = Deno.env.get(\"GOOGLE_REFRESH_TOKEN\");\n \n // Detailed logging to debug environment variables\n console.log(\"OAuth Debug - Client ID:\", clientId?.substring(0, 10) + \"...\" + clientId?.substring(clientId.length - 10));\n console.log(\"OAuth Debug - Client Secret Length:\", clientSecret?.length);\n console.log(\"OAuth Debug - Refresh Token Length:\", refreshToken?.length);\n \n if (!clientId || !clientSecret || !refreshToken) {\n throw new Error(\"Missing Google credentials in environment variables\");\n }\n\n // Construct the token request body\n const tokenRequestBody = new URLSearchParams({\n client_id: clientId,\n client_secret: clientSecret,\n refresh_token: refreshToken,\n grant_type: \"refresh_token\"\n });\n \n console.log(\"OAuth Debug - Token Request Body:\", tokenRequestBody.toString());\n \n try {\n const tokenResponse = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: tokenRequestBody\n });\n\n console.log(\"OAuth Debug - Token Response Status:\", tokenResponse.status);\n \n const responseText = await tokenResponse.text();\n console.log(\"OAuth Debug - Token Response Body:\", responseText);\n \n if (!tokenResponse.ok) {\n throw new Error(`Failed to get access token: ${responseText}`);\n }\n\n const tokenData = JSON.parse(responseText);\n return tokenData.access_token;\n } catch (error) {\n console.error(\"OAuth Debug - Fetch Error:\", error.message);\n throw error;\n }\n}\n\nexport default async function getCalendarEvents(): Promise {\n try {\n // First, delete existing calendar events\n await deleteExistingCalendarEvents();\n \n // Get the access token once to avoid multiple auth calls\n const accessToken = await getGoogleAccessToken();\n \n // Fetch the list of available calendars\n const calListUrl = \"https://www.googleapis.com/calendar/v3/users/me/calendarList\";\n const calListResponse = await fetch(calListUrl, {\n headers: {\n \"Authorization\": `Bearer ${accessToken}`\n }\n });\n \n if (!calListResponse.ok) {\n throw new Error(`Failed to fetch calendar list: ${await calListResponse.text()}`);\n }\n \n const calendarList = await calListResponse.json() as CalendarList;\n console.log(`Found ${calendarList.items?.length || 0} available calendars:`);\n \n // Store all events from all calendars\n let allEvents: CalendarEvent[] = [];\n \n // Process each calendar that we have at least reader access to\n for (const calendar of calendarList.items || []) {\n console.log(`- ${calendar.summary} (${calendar.id}) - Access role: ${calendar.accessRole}`);\n \n // Skip calendars we don't have at least reader access to\n if (!['reader', 'writer', 'owner'].includes(calendar.accessRole)) {\n console.log(`Skipping calendar ${calendar.summary} due to insufficient access rights`);\n continue;\n }\n \n try {\n // Fetch events for this specific calendar\n const calendarEvents = await fetchCalendarEventsForCalendar(calendar.id, accessToken);\n console.log(`Found ${calendarEvents.length} events in calendar \"${calendar.summary}\"`);\n \n // Add these events to our total collection, tag each event with its source calendar\n for (const event of calendarEvents) {\n // Store the calendar name as a property on the event object\n // We'll use this later to add the calendar name to the event text\n (event as any).calendarSource = calendar.summary;\n }\n \n allEvents = allEvents.concat(calendarEvents);\n } catch (error) {\n console.error(`Error fetching events for calendar ${calendar.summary}:`, error);\n }\n }\n \n console.log(`Found a total of ${allEvents.length} calendar events across all calendars`);\n \n // Process and insert all the events\n for (const event of allEvents) {\n let date: string;\n let formattedDate: string;\n \n if (event.start.dateTime) {\n // For timed events, use Luxon to parse the date properly\n const timezone = event.start.timeZone || \"UTC\";\n const dt = parseDateTime(event.start.dateTime, timezone);\n // Get the date in YYYY-MM-DD format in LOCAL_TIMEZONE\n formattedDate = dt.toFormat(\"yyyy-MM-dd\");\n date = formattedDate;\n \n // Debug log the date conversion\n console.log(`Event: ${event.summary}, Original: ${event.start.dateTime}, Timezone: ${timezone}, Converted: ${formattedDate}`);\n } else if (event.start.date) {\n // All-day events are already in YYYY-MM-DD format\n date = event.start.date;\n } else {\n console.warn(`Event ${event.summary} has no start date/time, skipping`);\n continue;\n }\n\n // Get the basic event text\n let eventText = formatEventToNaturalLanguage(event);\n \n // Add the calendar source in square brackets at the end if available\n const calendarSource = (event as any).calendarSource;\n if (calendarSource) {\n eventText += ` [${calendarSource}]`;\n }\n \n console.log(`Adding calendar event for ${date}: ${eventText.substring(0, 50)}...`);\n await insertCalendarEvent(date, eventText);\n }\n\n console.log(`Calendar events imported into the database.`);\n return allEvents;\n } catch (error) {\n console.error(\"Error importing calendar events:\", error);\n throw error;\n }\n}\n\n// Function to fetch events for a specific calendar\nasync function fetchCalendarEventsForCalendar(calendarId: string, accessToken: string): Promise {\n // Get events for the next 30 days\n const timeMin = new Date();\n const timeMax = new Date();\n timeMax.setDate(timeMax.getDate() + 30);\n \n console.log(`Fetching events for calendar ${calendarId} from ${timeMin.toISOString()} to ${timeMax.toISOString()}`);\n \n const url = `https://www.googleapis.com/calendar/v3/calendars/${encodeURIComponent(calendarId)}/events?` + \n new URLSearchParams({\n timeMin: timeMin.toISOString(),\n timeMax: timeMax.toISOString(),\n singleEvents: \"true\",\n orderBy: \"startTime\",\n maxResults: \"50\" // Explicitly request up to 50 events\n });\n \n const response = await fetch(url, {\n headers: {\n \"Authorization\": `Bearer ${accessToken}`\n }\n });\n \n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to fetch calendar events: ${error}`);\n }\n \n const data = await response.json() as CalendarEventsResponse;\n \n if (data.items?.length > 0) {\n // Log all event summaries to see what we're getting\n console.log(`Events in calendar ${calendarId}:`);\n data.items.forEach((event, index) => {\n const start = event.start.dateTime || event.start.date;\n console.log(` ${index + 1}. [${start}] ${event.summary || 'Unnamed event'}`);\n });\n } else {\n console.log(`No events found in calendar ${calendarId} for the specified date range`);\n }\n \n return data.items || [];\n}\n",[],[423,438],{"_102":447,"_95":448,"_158":449,"_160":424,"_161":139,"_162":450,"_164":116,"_104":451,"_99":144,"_166":179,"_168":452,"_169":22,"_170":-5,"_171":453,"_98":454},"da0fb2be-1ae8-11f0-a2d7-569c3dd06744","getWeather.ts","1d85fc7f-a978-4741-892c-49047d0a6550",15,["D",1744824784133],"import { getWeather, WeatherResponse } 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\n// Helper function to convert Fahrenheit to Celsius and round to 1 decimal\nfunction toCelsius(fahrenheit) {\n return Math.round((fahrenheit - 32) * 5 / 9 * 10) / 10;\n}\n\nfunction summarizeWeather(weather: WeatherResponse) {\n const summarizeDay = (day: WeatherResponse[\"weather\"][number]) => ({\n date: day.date,\n highTemp: toCelsius(day.maxtempF),\n lowTemp: toCelsius(day.mintempF),\n hourly: day.hourly?.map((hour) => ({\n time: hour.time,\n temp: toCelsius(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.\nTemperatures are in Celsius.\n\nExamples:\n- \"High of 10°C, low of 0°C, clear and sunny all day.\"\n- \"High of 27°C, low of 10°C, 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(\"Perth, Western Australia\");\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}",[],[423,448],{"_102":456,"_95":457,"_158":458,"_160":424,"_161":139,"_162":118,"_164":116,"_104":459,"_99":442,"_166":251,"_168":460,"_169":22,"_170":-5,"_171":461,"_98":462},"b0e0c7be-1c25-11f0-80fc-569c3dd06744","handleTelegramMessage.ts","dd89fae4-1499-474b-998d-b0148b160343",["D",1744960865525],"import { Bot, webhookCallback } 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 { formatMemoriesForPrompt, getRelevantMemories } from \"../memoryUtils.ts\";\n\n// Initialize the bot\nif (!Deno.env.get(\"TELEGRAM_TOKEN\")) {\n throw new Error(\"TELEGRAM_TOKEN is not set\");\n}\nconst bot = new Bot(Deno.env.get(\"TELEGRAM_TOKEN\")!);\n\n// Use part of the TELEGRAM_TOKEN itself as the secret_token\nconst SECRET_TOKEN = Deno.env.get(\"TELEGRAM_TOKEN\")!.split(\":\")[1];\nconst handleUpdate = webhookCallback(\n bot,\n \"std/http\",\n undefined,\n undefined,\n SECRET_TOKEN,\n);\n\nlet isEndpointSet = false;\n\n// Special ID for the bot's own messages\nexport const BOT_SENDER_ID = \"mr_stevens_bot\";\nexport const BOT_SENDER_NAME = \"Mr. Stevens\";\n\n/**\n * Store a chat message in the database\n */\nexport async function storeChatMessage(\n chatId,\n senderId,\n senderName,\n message,\n isBot = false,\n) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Check if the telegram_chats table exists, create if it doesn't\n const tableExists = await sqlite.execute(`\n SELECT name FROM sqlite_master WHERE type='table' AND name='telegram_chats'\n `);\n\n if (tableExists.rows.length === 0) {\n console.log(\"Creating 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 await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_telegram_chats_chat_id ON telegram_chats(chat_id)\n `);\n console.log(\"telegram_chats table created successfully\");\n }\n\n const timestamp = Math.floor(Date.now() / 1000); // Unix timestamp in seconds\n\n await sqlite.execute({\n sql: `INSERT INTO telegram_chats (chat_id, sender_id, sender_name, message, timestamp, is_bot)\n VALUES (:chat_id, :sender_id, :sender_name, :message, :timestamp, :is_bot)`,\n args: {\n chat_id: chatId,\n sender_id: senderId,\n sender_name: senderName,\n message: message,\n timestamp: timestamp,\n is_bot: isBot ? 1 : 0,\n },\n });\n return true;\n } catch (error) {\n console.error(\"Error storing chat message:\", error);\n return false;\n }\n}\n\n/**\n * Retrieve chat history for a specific chat\n */\nexport async function getChatHistory(chatId, limit = 50) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const result = await sqlite.execute({\n sql: `SELECT * FROM telegram_chats\n WHERE chat_id = :chat_id\n ORDER BY timestamp ASC\n LIMIT :limit`,\n args: {\n chat_id: chatId,\n limit: limit,\n },\n });\n\n return result.rows || [];\n } catch (error) {\n console.error(\"Error retrieving chat history:\", error);\n return [];\n }\n}\n\n/**\n * Format chat history for Anthropic API\n */\nfunction formatChatHistoryForAI(history) {\n const messages = [];\n\n for (const msg of history) {\n if (msg.is_bot) {\n messages.push({\n role: \"assistant\",\n content: msg.message,\n });\n } else {\n // Format user message with sender name\n messages.push({\n role: \"user\",\n content: `${msg.sender_name} says: ${msg.message}`,\n });\n }\n }\n\n return messages;\n}\n\n/**\n * Check if a similar memory already exists in the database\n */\nasync function checkMemoryExists(text) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n \n // First try an exact match\n const exactMatch = await sqlite.execute({\n sql: `SELECT id FROM memories WHERE text = :text LIMIT 1`,\n args: { text }\n });\n \n if (exactMatch.rows?.length > 0) {\n return true;\n }\n \n // If no exact match, try a more relaxed match (for things like \"Client has ADHD\" vs \"Client and friends have ADHD\")\n // This is a basic implementation - could be improved with more sophisticated text similarity\n const keyTerms = text.toLowerCase().split(' ')\n .filter(word => word.length > 3) // Only consider significant words\n .filter(word => !['with', 'from', 'that', 'this', 'have', 'their', 'about', 'what'].includes(word));\n \n if (keyTerms.length < 2) return false; // Not enough significant terms to match\n \n // Create a LIKE query with the key terms\n const likeConditions = keyTerms.map((term, index) => `text LIKE :term${index}`).join(' AND ');\n const args = keyTerms.reduce((acc, term, index) => {\n acc[`term${index}`] = `%${term}%`;\n return acc;\n }, {});\n \n const similarMatch = await sqlite.execute({\n sql: `SELECT id FROM memories WHERE ${likeConditions} LIMIT 1`,\n args\n });\n \n return similarMatch.rows?.length > 0;\n } catch (error) {\n console.error(\"Error checking for duplicate memories:\", error);\n return false; // If there's an error, assume the memory doesn't exist to be safe\n }\n}\n\n/**\n * Analyze a Telegram message and extract memories from it\n */\nasync function analyzeMessageContent(\n anthropic,\n username,\n messageText,\n chatHistory = [],\n) {\n try {\n // Get relevant memories\n const memories = await getRelevantMemories();\n const memoriesText = formatMemoriesForPrompt(memories);\n\n // Log the username to help identify the issue with Serena's messages\n console.log(`Processing message for username: ${username}`);\n\n // Prepare system prompt with all instructions and memories\n const systemPrompt = `${backstory}\n\nYour job is to read this Telegram message from your employer and respond in a natural, butler-like way, noting any important information that should be remembered for future reference.\n\nYou have access to the following stored memories:\n\n${memoriesText}\n\nIf this appears to be a new client or the conversation is in an early stage, you should conduct an intake interview to gather essential background information. First ask the client if now is a good time to ask them some questions.\n\nAsk about the following topics in a conversational way (not all at once, but continuing the interview naturally based on their responses):\n\nInitial Information:\n- Who are the family members living in the home and their ages?\n- Names of close family members and their relationships to the client?\n\nDaily Life:\n- Which grocery stores and local restaurants they frequent?\n- Family members' food preferences and any dietary restrictions?\n- Typical working hours and recurring commitments?\n- Important dates (birthdays, anniversaries, holidays)?\n- Monthly bills and subscriptions that need tracking?\n- Emergency contacts and regular service providers?\n- Current health goals and any medication reminders needed?\n\nYour goal is to collect this information naturally through conversation and store it as memories (as undated memories). Once you've gathered sufficient background information, you can conclude the intake process and transition to normal reactive chat.\n\nIf the conversation is already past the intake stage, then analyze the message content and think about which memories might be worth creating based on the information provided.\n\nYou should respond in a natural conversational way. You have three options for managing memories:\n\n1. CREATE memories: Include them in tags in JSON format.\n2. EDIT memories: Include them in tags in JSON format (must include memory ID).\n3. DELETE memories: Include them in tags in JSON format (just include memory IDs).\n\nExample response WITHOUT memory modification:\n\"Very good, sir. I shall make a note of that.\"\n\nExample response WITH memory creation:\n\"I've noted that you prefer Earl Grey tea in the morning, sir.\n\n\n[{ \"text\": \"Client prefers Earl Grey tea in the morning.\", \"date\": null }]\n\"\n\nExample response WITH memory editing:\n\"I've updated your birthday in my records, sir.\n\n\n[{ \"id\": \"abc123\", \"text\": \"Client's birthday is on April 15th.\", \"date\": \"2024-04-15\" }]\n\"\n\nExample response WITH memory deletion:\n\"I've removed that note from my records as requested, sir.\n\n\n[\"abc123\"]\n\"\n\nImportant guidelines for memory management:\n1. For new memories, set a date for each memory whenever possible.\n2. The date should be the actual date of the event. You don't need to set reminder dates in advance.\n3. Keep the memory text concise: ideally one short sentence, but include all important details.\n4. Extract any dates mentioned and convert them to ISO format. If the year isn't mentioned, assume the current year.\n5. If no date is relevant to the memory, set \"date\" to null.\n6. For editing or deleting memories, you MUST include the correct memory ID from the displayed memories. Each memory is displayed with its ID in the format \"[ID: xyz123]\".\n7. If no memories need to be managed, simply respond naturally WITHOUT including any memory tags.\n8. When a user asks to delete a memory, you must find its ID from the memory list above and include that ID in the deleteMemories tag.\n9. Do not create duplicate memories. If a memory already exists, do not record the same information again.\n\nIMPORTANT: When the user asks for information like event summaries or calendar entries, you MUST provide that information in your response. Specifically, if someone asks for a summary of events or what's coming up, list all relevant events from the memories provided, organized by date.\n\nYour response style:\n- Use a brief, natural-sounding tone characteristic of a personal assistant\n- Be slightly dignified but sound modern, not too stuffy or old-fashioned\n- Keep responses brief (1-2 sentences)\n- Vary your responses to avoid sounding robotic\n- Be polite and deferential\n- Avoid contractions (use \"do not\" instead of \"don't\")\n\nToday's date is ${\n DateTime.now()\n .setZone(\"Australia/Perth\")\n .toFormat(\"yyyy-MM-dd\")\n }`;\n\n // Prepare formatted chat history\n const formattedHistory = chatHistory.length > 0 ? formatChatHistoryForAI(chatHistory) : [];\n\n // Include the current message when sending to Claude\n const messages = [...formattedHistory];\n if (messages.length === 0 || messages[messages.length - 1].role !== \"user\") {\n messages.push({\n role: \"user\",\n content: `${username} says: ${messageText}`\n });\n }\n\n console.log(`Sending ${messages.length} messages to Claude for user ${username}`);\n if (messages.length > 0) {\n console.log(`Last message: ${messages[messages.length - 1].content}`);\n }\n\n const response = await anthropic.messages.create({\n model: \"claude-3-5-sonnet-latest\",\n max_tokens: 4196,\n system: systemPrompt,\n messages: messages,\n });\n\n // Get the text response\n const responseText = response.content[0].text;\n\n console.log(`Claude response for ${username}: ${responseText.substring(0, 100)}...`);\n\n // Parse the response, extracting memories if present\n try {\n // Check if there are memories to create, edit, or delete\n const createMemoryMatch = responseText.match(\n /([\\s\\S]*?)<\\/createMemories>/,\n );\n const editMemoryMatch = responseText.match(\n /([\\s\\S]*?)<\\/editMemories>/,\n );\n const deleteMemoryMatch = responseText.match(\n /([\\s\\S]*?)<\\/deleteMemories>/,\n );\n\n let cleanedResponse = responseText;\n let memories = [];\n let editMemories = [];\n let deleteMemories = [];\n\n // Parse created memories\n if (createMemoryMatch) {\n cleanedResponse = cleanedResponse\n .replace(/[\\s\\S]*?<\\/createMemories>/, \"\")\n .trim();\n\n try {\n memories = JSON.parse(createMemoryMatch[1]);\n } catch (e) {\n console.error(\"Error parsing created memories JSON:\", e);\n }\n }\n\n // Parse edited memories\n if (editMemoryMatch) {\n cleanedResponse = cleanedResponse\n .replace(/[\\s\\S]*?<\\/editMemories>/, \"\")\n .trim();\n\n try {\n editMemories = JSON.parse(editMemoryMatch[1]);\n } catch (e) {\n console.error(\"Error parsing edited memories JSON:\", e);\n }\n }\n\n // Parse deleted memories\n if (deleteMemoryMatch) {\n cleanedResponse = cleanedResponse\n .replace(/[\\s\\S]*?<\\/deleteMemories>/, \"\")\n .trim();\n\n try {\n deleteMemories = JSON.parse(deleteMemoryMatch[1]);\n } catch (e) {\n console.error(\"Error parsing deleted memories JSON:\", e);\n }\n }\n\n // Handle any trailing/leading newlines that might be left after removing the tags\n cleanedResponse = cleanedResponse.replace(/\\n{3,}/g, \"\\n\\n\"); // Replace 3+ consecutive newlines with 2\n \n // Check if the cleaned response is empty or just whitespace after removing memory tags\n if (!cleanedResponse || cleanedResponse.trim() === \"\") {\n console.log(`WARNING: Empty response detected for ${username} after cleaning. Using default response.`);\n \n // Format a response based on the original request if it's a summary request\n if (messageText.toLowerCase().includes(\"summary\") || \n messageText.toLowerCase().includes(\"events\") || \n messageText.toLowerCase().includes(\"coming up\")) {\n \n // Extract dated events from memories, excluding fun facts and weather\n const events = memories.filter(mem => {\n const hasDate = mem.date && mem.date !== \"null\";\n const isNotFunFact = !mem.text.toLowerCase().includes(\"fun fact\");\n const isNotWeather = !mem.text.toLowerCase().includes(\"weather\");\n return hasDate && isNotFunFact && isNotWeather;\n });\n \n if (events.length > 0) {\n cleanedResponse = \"Certainly. Here is a summary of your upcoming events:\\n\\n\";\n // Sort events by date\n events.sort((a, b) => new Date(a.date) - new Date(b.date));\n \n let currentDate = \"\";\n events.forEach(event => {\n const eventDate = new Date(event.date).toLocaleDateString('en-US', {\n weekday: 'long',\n month: 'long', \n day: 'numeric'\n });\n \n if (eventDate !== currentDate) {\n cleanedResponse += `${eventDate}:\\n`;\n currentDate = eventDate;\n }\n \n cleanedResponse += `- ${event.text}\\n`;\n });\n \n cleanedResponse += \"\\nIs there anything specific you would like more details about?\";\n } else {\n cleanedResponse = \"I have compiled the information you requested about upcoming events. However, I notice there are no specific dated events in your schedule for the coming month. Would you like me to note any new appointments or commitments?\";\n }\n } else {\n cleanedResponse = \"Very good. I have noted that information in my records.\";\n }\n }\n\n console.log(`Final response for ${username}: ${cleanedResponse.substring(0, 100)}...`);\n\n return {\n memories: memories,\n editMemories: editMemories,\n deleteMemories: deleteMemories,\n response: cleanedResponse,\n };\n } catch (error) {\n console.error(\"Error processing AI response:\", error);\n return {\n memories: [],\n editMemories: [],\n deleteMemories: [],\n response: responseText\n || \"I apologize, but I'm unable to process your request at the moment.\",\n };\n }\n } catch (error) {\n console.error(\"Message analysis error:\", error);\n return {\n memories: [],\n editMemories: [],\n deleteMemories: [],\n response: \"I apologize, but I seem to be experiencing some difficulty at the moment.\",\n };\n }\n}\n// Set up message handler for the bot\nbot.on(\"message\", async (ctx) => {\n try {\n // Get Anthropic 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 ctx.reply(\n \"I apologize, but I'm not properly configured at the moment. Please inform the household administrator.\",\n );\n return;\n }\n\n // Initialize Anthropic client\n const anthropic = new Anthropic({ apiKey });\n\n // Get message text and user info\n const messageText = ctx.message.text || \"\";\n const username = ctx.message.from.username || ctx.message.from.first_name || \"Sir/Madam\";\n const chatId = ctx.chat.id;\n const senderId = ctx.message.from.id.toString();\n const senderName = username; // Using username as the sender name\n\n console.log({ chatId, username, messageText });\n\n // Store the incoming message in the chat history\n await storeChatMessage(chatId, senderId, senderName, messageText);\n\n // If the message is a /start command, introduce Mr. Stevens\n if (messageText === \"/start\") {\n const introMessage =\n \"Good day. I am Mr. Stevens, at your service. I shall make note of any important matters you wish me to remember and will ensure they're properly attended to at the appropriate time. If I may, I would like to ask you a few questions to understand how I can better serve you and your household.\";\n await ctx.reply(introMessage);\n\n // Store the bot's response in chat history\n await storeChatMessage(\n chatId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n introMessage,\n true,\n );\n return;\n }\n\n // Add a /reset command to clear chat history and restart the setup\n if (messageText === \"/reset\") {\n try {\n // Delete all records for this specific chat from the telegram_chats table\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n await sqlite.execute(`\n DELETE FROM telegram_chats \n WHERE chat_id = ?\n `, [chatId]);\n \n const resetMessage = \"I have reset our conversation history. You may send /start to begin our setup process again.\";\n await ctx.reply(resetMessage);\n \n // Store the bot's response in chat history (this will be the only message in history now)\n await storeChatMessage(\n chatId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n resetMessage,\n true,\n );\n return;\n } catch (error) {\n console.error(\"Error resetting chat:\", error);\n await ctx.reply(\"I apologize, but I encountered an error while attempting to reset our conversation.\");\n return;\n }\n }\n\n // If it's another command, ignore it\n if (messageText.startsWith(\"/\")) {\n return;\n }\n\n // Retrieve chat history for this chat, which now includes the current message we just stored\n const chatHistory = await getChatHistory(chatId);\n\n // Analyze message content with chat history context\n const analysis = await analyzeMessageContent(\n anthropic,\n username,\n messageText,\n chatHistory,\n );\n\n // Create memories based on the analysis\n if (analysis.memories && analysis.memories.length > 0) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\n\n const createdIds = [];\n const skippedMemories = [];\n\n for (const memory of analysis.memories) {\n // Check if a similar memory already exists\n const exists = await checkMemoryExists(memory.text);\n if (exists) {\n skippedMemories.push(memory.text);\n continue;\n }\n \n const memoryId = nanoid(10);\n createdIds.push(memoryId);\n await sqlite.execute({\n sql: `INSERT INTO memories (id, date, text, createdBy, createdDate, tags)\n VALUES (:id, :date, :text, :createdBy, :createdDate, :tags)`,\n args: {\n id: memoryId,\n date: memory.date,\n text: memory.text,\n createdBy: \"telegram\",\n createdDate: Date.now(),\n tags: \"\",\n },\n });\n }\n\n if (createdIds.length > 0) {\n console.log(\n `Created ${createdIds.length} memories with IDs: ${createdIds.join(\", \")}`,\n );\n }\n \n if (skippedMemories.length > 0) {\n console.log(\n `Skipped ${skippedMemories.length} duplicate memories: ${skippedMemories.join(\", \")}`,\n );\n }\n }\n\n // Edit memories if requested\n if (analysis.editMemories && analysis.editMemories.length > 0) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const editedIds = [];\n\n for (const memory of analysis.editMemories) {\n if (!memory.id) {\n console.error(\"Cannot edit memory without ID:\", memory);\n continue;\n }\n\n editedIds.push(memory.id);\n\n // Create the SET clause dynamically based on what fields are provided\n const updateFields = [];\n const args: Record = { id: memory.id };\n\n if (memory.text !== undefined) {\n updateFields.push(\"text = :text\");\n args.text = memory.text;\n }\n\n if (memory.date !== undefined) {\n updateFields.push(\"date = :date\");\n args.date = memory.date;\n }\n\n if (memory.tags !== undefined) {\n updateFields.push(\"tags = :tags\");\n args.tags = memory.tags;\n }\n\n // Only proceed if we have fields to update\n if (updateFields.length > 0) {\n const setClause = updateFields.join(\", \");\n await sqlite.execute({\n sql: `UPDATE memories SET ${setClause} WHERE id = :id`,\n args,\n });\n }\n }\n\n console.log(\n `Edited ${editedIds.length} memories with IDs: ${editedIds.join(\", \")}`,\n );\n }\n\n // Delete memories if requested\n if (analysis.deleteMemories && analysis.deleteMemories.length > 0) {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n for (const memoryId of analysis.deleteMemories) {\n await sqlite.execute({\n sql: `DELETE FROM memories WHERE id = :id`,\n args: { id: memoryId },\n });\n }\n\n console.log(\n `Deleted ${analysis.deleteMemories.length} memories with IDs: ${analysis.deleteMemories.join(\", \")}`,\n );\n }\n\n // Respond with the butler-like response\n await ctx.reply(analysis.response);\n\n // Store the bot's response in chat history (without debug info to keep it clean)\n await storeChatMessage(\n chatId,\n BOT_SENDER_ID,\n BOT_SENDER_NAME,\n analysis.response,\n true,\n );\n } catch (error) {\n console.error(\"Error processing message:\", error);\n await ctx.reply(\n \"I do apologize, but I seem to be experiencing some difficulty at the moment. Perhaps we could try again shortly.\",\n );\n }\n});\n\n// No additional commands needed for the butler interface\n\n// Handle webhook requests\nexport default async function(req: Request): Promise {\n // Set webhook if it is not set yet\n if (!isEndpointSet) {\n await bot.api.setWebhook(req.url, {\n secret_token: SECRET_TOKEN,\n });\n isEndpointSet = true;\n }\n\n if (req.method === \"POST\") {\n return await handleUpdate(req);\n }\n\n return new Response(\n `

Memory Assistant Bot

This bot helps you remember important information.

`,\n { status: 200, headers: { \"content-type\": \"text/html\" } },\n );\n}",[],[423,457],{"_102":464,"_95":465,"_158":466,"_160":424,"_161":139,"_162":467,"_164":116,"_104":468,"_99":144,"_166":189,"_168":469,"_169":22,"_170":-5,"_171":470,"_98":471},"c2ec0394-1eb2-11f0-90b5-569c3dd06744","resetFunFacts.ts","db1deff8-1eae-11f0-af1a-569c3dd06744",60,["D",1745241357158],"// Script to reset fun facts database and generate new ones\r\n\r\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\r\n\r\nconst TABLE_NAME = \"memories\";\r\nconst TAG_NAME = \"fun_fact\";\r\n\r\n/**\r\n * Reset fun facts and generate new ones for the next 7 days\r\n */\r\nexport default async function resetFunFacts() {\r\n try {\r\n // 1. Check if the memories table exists\r\n const tableExists = await sqlite.execute(`\r\n SELECT name FROM sqlite_master WHERE type='table' AND name='${TABLE_NAME}'\r\n `);\r\n\r\n if (tableExists.rows.length === 0) {\r\n console.log(`Table ${TABLE_NAME} does not exist yet.`);\r\n return {\r\n success: false,\r\n message: `Table ${TABLE_NAME} does not exist yet.`\r\n };\r\n }\r\n\r\n // 2. Delete existing fun facts\r\n console.log(\"Deleting existing fun facts...\");\r\n await sqlite.execute({\r\n sql: `DELETE FROM ${TABLE_NAME} WHERE tags = :tag`,\r\n args: { tag: TAG_NAME }\r\n });\r\n console.log(\"Existing fun facts deleted\");\r\n\r\n // 3. Check for any remaining previous facts\r\n console.log(\"Checking for any remaining previous facts...\");\r\n const result = await sqlite.execute({\r\n sql: `SELECT date(date) as date, text FROM ${TABLE_NAME}\r\n WHERE tags = :tag\r\n ORDER BY date DESC\r\n LIMIT 50`,\r\n args: { tag: TAG_NAME },\r\n });\r\n const previousFacts = result.rows || [];\r\n console.log(`Found ${previousFacts.length} previous facts that weren't deleted`);\r\n\r\n // 4. Generate new fun facts\r\n console.log(\"Generating new fun facts...\");\r\n const newFacts = await generateFunFacts(previousFacts);\r\n \r\n if (!newFacts || newFacts.length === 0) {\r\n return {\r\n success: false,\r\n message: \"No facts were generated\"\r\n };\r\n }\r\n\r\n // 5. Insert new facts\r\n console.log(\"Inserting new facts into database...\");\r\n let insertedCount = 0;\r\n const { nanoid } = await import(\"https://esm.sh/nanoid@5.0.5\");\r\n \r\n for (const fact of newFacts) {\r\n try {\r\n await sqlite.execute({\r\n sql: `INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\r\n VALUES (:id, :date, :text, :createdBy, :createdDate, :tags)`,\r\n args: {\r\n id: nanoid(10),\r\n date: fact.date,\r\n text: `fun fact: ${fact.text}`,\r\n createdBy: \"fun_fact_generator\",\r\n createdDate: Date.now(),\r\n tags: TAG_NAME,\r\n },\r\n });\r\n insertedCount++;\r\n console.log(`Inserted fact for ${fact.date}: ${fact.text.substring(0, 50)}...`);\r\n } catch (error) {\r\n console.error(`Error inserting fact for ${fact.date}:`, error);\r\n }\r\n }\r\n \r\n return {\r\n success: true,\r\n message: `Successfully reset fun facts database and generated ${insertedCount} new fun facts`\r\n };\r\n } catch (error) {\r\n console.error(\"Error in fun facts reset:\", error);\r\n return {\r\n success: false,\r\n error: error.message,\r\n stack: error.stack\r\n };\r\n }\r\n}\r\n\r\n/**\r\n * Generate fun facts using Anthropic API\r\n */\r\nasync function generateFunFacts(previousFacts) {\r\n try {\r\n // Import dependencies\r\n const { DateTime } = await import(\"https://esm.sh/luxon@3.4.4\");\r\n const Anthropic = (await import(\"npm:@anthropic-ai/sdk@0.24.3\")).default;\r\n \r\n // Get API key\r\n const apiKey = Deno.env.get(\"ANTHROPIC_API_KEY\");\r\n if (!apiKey) {\r\n console.error(\"Anthropic API key is not configured.\");\r\n return [];\r\n }\r\n \r\n // Initialize Anthropic client\r\n const anthropic = new Anthropic({ apiKey });\r\n \r\n // Set up dates\r\n const today = DateTime.now().setZone(\"Australia/Perth\").startOf(\"day\");\r\n const nextSevenDays = Array.from({ length: 7 }, (_, i) => {\r\n const date = today.plus({ days: i });\r\n return date.toFormat(\"yyyy-MM-dd\");\r\n });\r\n \r\n // Format previous facts for the prompt\r\n const previousFactsText = previousFacts\r\n .map((fact) => `- ${fact.date}: ${fact.text}`)\r\n .join(\"\\n\");\r\n \r\n // Create the prompt\r\n const message = `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:\r\n\r\n1. History: Interesting historical events that happened on this day in history, especially with a focus on Australian history\r\n2. Science: Fascinating scientific discoveries or concepts\r\n3. Nature: Interesting facts about animals, plants, or natural phenomena\r\n4. Technology: Innovative technologies or digital advancements\r\n5. Art & Culture: Noteworthy cultural facts, art history, or literary trivia\r\n6. Geography: Intriguing places, landmarks, or geographic phenomena\r\n7. Food & Cuisine: Facts about culinary traditions or interesting foods\r\n\r\nRequirements:\r\n- Each fact must be interesting, educational, and appropriate for formal communication\r\n- Keep each fact to 1-2 sentences maximum\r\n- Use different categories across the 7 days for variety\r\n- Ensure facts are scientifically accurate and well-researched\r\n- If using \"on this day in history\" facts, make sure they're relevant to the date\r\n- Do not repeat any previous facts from this list:\r\n\r\n${previousFactsText}\r\n\r\nFORMAT YOUR RESPONSE AS STRUCTURED JSON INSIDE XML TAGS:\r\n\r\n[\r\n {\r\n \"date\": \"YYYY-MM-DD\",\r\n \"text\": \"The fun fact text here\",\r\n \"category\": \"history\" | \"science\" | \"nature\" | \"technology\" | \"art\" | \"geography\" | \"food\"\r\n },\r\n ... (repeat for all 7 days)\r\n]\r\n\r\n\r\nUse these dates for the 7 facts:\r\n${nextSevenDays.join(\"\\n\")}`;\r\n \r\n // Generate facts with Claude\r\n console.log(\"Sending request to Claude...\");\r\n const response = await anthropic.messages.create({\r\n model: \"claude-3-5-sonnet-latest\",\r\n max_tokens: 1000,\r\n messages: [\r\n {\r\n role: \"user\",\r\n content: [\r\n {\r\n type: \"text\",\r\n text: message,\r\n },\r\n ],\r\n },\r\n ],\r\n });\r\n \r\n // Extract and parse the response\r\n const responseText = response.content[0].text.trim();\r\n console.log(\"Claude response received:\", responseText.slice(0, 100) + \"...\");\r\n \r\n // Extract JSON between tags\r\n const factsMatch = responseText.match(/([\\s\\S]*?)<\\/facts>/);\r\n \r\n if (!factsMatch || factsMatch.length < 2) {\r\n console.error(\"Failed to parse facts from response\");\r\n return [];\r\n }\r\n \r\n // Parse JSON\r\n try {\r\n // Parse the JSON from the extracted content\r\n const factData = JSON.parse(factsMatch[1]);\r\n \r\n // Validate and format facts\r\n const newFacts = factData.map((fact) => ({\r\n date: fact.date,\r\n text: fact.text,\r\n category: fact.category,\r\n }));\r\n \r\n console.log(`Successfully parsed ${newFacts.length} facts`);\r\n return newFacts;\r\n } catch (parseError) {\r\n console.error(\"Failed to parse facts JSON:\", parseError);\r\n return [];\r\n }\r\n } catch (error) {\r\n console.error(\"Error generating fun facts:\", error);\r\n return [];\r\n }\r\n}\r\n\r\n// Export a function to run directly\r\nexport async function runReset() {\r\n const result = await resetFunFacts();\r\n console.log(result);\r\n return result;\r\n}\r\n\r\n// This file can be executed directly \r\nrunReset(); ",[],[423,465],[423],{"_102":474,"_95":327,"_158":475,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":476,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_171":477,"_98":485},"d52a52a2-1a09-11f0-bd50-569c3dd06744","a1cca01d-916c-468e-be32-b75101909bb0",["D",1744728998137],[478],{"_102":479,"_95":340,"_158":480,"_160":475,"_161":139,"_162":163,"_164":116,"_104":481,"_99":32,"_166":189,"_168":482,"_169":22,"_170":-5,"_171":483,"_98":484},"d52a4ff0-1a09-11f0-bd50-569c3dd06744","a25a4819-7ee0-491a-a351-7592808258d7",["D",1744728998137],"export interface Memory {\n id: string;\n date: string;\n text: string;\n tags: string | null;\n\n // New fields from schema\n createdBy?: string;\n createdDate?: number;\n}\n",[],[327,340],[327],{"_102":487,"_95":488,"_158":489,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":490,"_99":32,"_166":226,"_168":491,"_169":22,"_170":-5,"_171":492,"_98":493},"d52a5658-1a09-11f0-bd50-569c3dd06744",".cursorrules","ae87c209-b5b3-4b68-8c26-dd2c8a6d3de4",["D",1744728998137],"# Val Town Project Rules and Guidelines\n\nYou are an advanced assistant specialized in generating Val Town code.\n\n\n## Types of Vals\n\n### 1. Script Vals\n\n- Basic JavaScript/TypeScript functions\n- Can be imported by other vals\n- Example structure:\n\n```typescript\nexport function myFunction() {\n // Your code here\n}\n```\n\n### 2. HTTP Vals\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```typescript\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\n### 3. Cron Vals\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```typescript\nexport default async function () {\n // Scheduled task code\n}\n```\n\n### 4. Email Vals\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```typescript\nexport default async function (email: Email) {\n // Process email\n}\n```\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({\n subject: \"Hi\",\n text: \"Hi\",\n html: \"

Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\nAlways import utilities with version pins to avoid breaking changes:\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n1. **parseProject** - Extract information about the current project from import.meta.url:\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\n2. **readFile** - Read files from within the project:\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n3. **serveFile** - Serve project files with proper content types:\n```ts\n// Serve a file from the project with proper Content-Type header\napp.get(\"/public/style.css\", c => serveFile(\"/frontend/style.css\", import.meta.url));\n```\n\n4. **listFiles** - List all files in the project:\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n5. **fetchTranspiledJavaScript** - Fetch and transpile TypeScript to JavaScript:\n```ts\nconst jsCode = await fetchTranspiledJavaScript(\"https://esm.town/v/username/project/path/to/file.ts\");\n```\n\n6. **testServer** - Create a test server for running test suites:\n```ts\nexport default testServer([\n {\n name: \"Feature Tests\",\n tests: [\n {\n name: \"should add numbers correctly\",\n function: () => {\n expect(1 + 1).toBe(2);\n },\n }\n ],\n }\n]);\n```\n\n## Val Town Platform Specifics\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- For AI-generated images, use: `https://maxm-imggenurl.web.val.run/the-description-of-your-image`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link with `import.meta.url.replace(\"esm.town\", \"val.town\")` and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; avoid catches that merely log or return 500s - let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` and minimize their use - prefer APIs without keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- For persistence, use Val Town SQLite or Blob storage with `import.meta.url` for keys/table names\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and include the `@jsxImportSource` pragma\n- When facing client-side render issues, check if all React dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n- Hono is the recommended API framework (similar to Express, Flask, or Sinatra)\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n // Use the serveFile utility to handle content types automatically\n app.get(\"/public/*\", c => serveFile(c.req.path.replace(\"/public\", \"/frontend\"), import.meta.url));\n\n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Be careful with error handling as Hono tends to swallow errors\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Frontend Best Practices\n- Structure as a standard client-side React app\n- Use SVG for favicons (Val Town only supports text files)\n- Separate components into individual files\n- Access bootstrapped data from `window.__INITIAL_DATA__`\n- Use React 18.2.0 consistently in all imports and the `@jsxImportSource` pragma\n- Follow the React component pattern from the example project\n- Handle API calls properly with proper error catching\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n- Follow the queries and migrations pattern from the example\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:**\n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n - Properly handle CORS if needed for external access",[],[488],{"_102":495,"_95":496,"_158":497,"_160":-5,"_161":139,"_162":498,"_164":116,"_104":499,"_99":32,"_166":226,"_168":500,"_169":22,"_170":-5,"_171":501,"_98":502},"da247eec-1ae8-11f0-b207-569c3dd06744",".vtignore","da247fb4-1ae8-11f0-b207-569c3dd06744",20,["D",1744824784168],".git\n.DS_Store\nnode_modules\nvendor",[],[496],{"_102":504,"_95":223,"_158":505,"_160":-5,"_161":139,"_162":506,"_164":116,"_104":507,"_99":163,"_166":226,"_168":508,"_169":22,"_170":-5,"_171":509,"_98":510},"0c04082c-1c21-11f0-b087-569c3dd06744","dc19099b-2bb9-468e-a615-03652bf22366",42,["D",1744958870917],"# Stevens\n\n> \"The great butlers are great by virtue of their ability to inhabit their professional role and inhabit it to the utmost; they will not be shaken out by external events, however surprising, alarming or vexing.\"\n>\n> — the great butler Stevens, in *The Remains of the Day* by Kazuo Ishiguro\n\nStevens is your personal digital butler, ever vigilant and ever helpful in managing the complexities of your digital life.\n\nMuch like his literary namesake, he takes great pride in his work, maintaining a dignified and professional demeanor while ensuring your affairs are in perfect order.\n\nIn the grand tradition of English butlers, Stevens has been designed to be both unobtrusive and indispensable. His primary duty is to learn about your life's context and provide you with daily briefs that keep you informed while saving you precious time.\n\n## Technical Architecture\n\n**⚠️ important caveat: the admin dashboard doesn't have auth! currently it just relies on security by obscurity of people not knowing the url to a private val. this is not very secure. if you fork this project and put sensitive data in a database you should think carefully about how to secure it.**\n\nStevens has been designed with the utmost simplicity and extensibility, much like a well-organized household. At the heart of his operation lies a single \"memories\" table - a digital equivalent of a butler's meticulous records. This table serves as the foundation for all of Stevens' operations.\n\n### Core Components\n\n1. **Memories Table**: A freeform repository of all that Stevens deems worth remembering, much like a butler's mental catalog of household affairs.\n\n **Schema**:\n - `id`: String - Unique identifier for each memory (generated using nanoid)\n - `date`: String - Date in ISO format (YYYY-MM-DD)\n - `text`: String - Content of the memory (e.g., \"weather forecast: High of 75, low of 60, partly cloudy\")\n - `createdBy`: String - Source of the memory (e.g., \"weather\", \"email\")\n - `createdDate`: Number - Timestamp in milliseconds when the memory was created\n - `tags`: String - Categories for organizing memories (e.g., \"weather\")\n\n2. **Importers**: These are Stevens' eyes and ears in the digital world, gathering information from various sources:\n - Weather reports\n - Postal service updates\n - Ingesting messages from email or TElegram\n - And other sources of information that might be of interest to you\n\n3. **Workflows**: Stevens' carefully orchestrated routines that utilize his memories to assist you:\n - Morning briefs sent via Telegram or email\n - Responding to questions via text message\n\n\n### Folder layout\n\n- `importers`: cron jobs for importing data into the memories table\n- `dashboard`: the admin view for showing the memories notebook + visualizing imports\n- `dailyBriefing`: stuff related to sending a daily update via telegram\n- `dbUtils`: little one-off scripts for database stuff\n\n## Hiring your own Stevens\n\nThis project isn't intended to be runnable out of the box, but you can adapt it for yourself if you fork the code.\n\nYou'll need to set up some environment variables to make it run.\n\n- `ANTHROPIC_API_KEY` for LLM calls\n- You'll need to follow [these instructions](https://docs.val.town/integrations/telegram/) to make a telegram bot, and set `TELEGRAM_TOKEN`. You'll also need to get a `TELEGRAM_CHAT_ID` in order to have the bot remember chat contents. Optionally, add `TELEGRAM_SECONDARY_CHAT_ID` if you want to send briefings to multiple recipients.\n- For the Google Calendar integration you'll need `GOOGLE_CALENDAR_ACCOUNT_ID` and `GOOGLE_CALENDAR_CALENDAR_ID`. See [these instuctions](https://www.val.town/v/stevekrouse/pipedream) for details.\n\n**important caveat: the admin dashboard doesn't have auth! currently it just relies on security by obscurity of people not knowing the url to a private val. this is not very secure, if you put sensitive data in a database you should think carefully about how to secure it.**\n\nOverall it's a simple enough project that I encourage you to just copy the ideas and run in your own direction rather than try to use it as-is.",[],[223],{"_102":512,"_95":513,"_158":514,"_160":-5,"_161":139,"_162":515,"_164":116,"_104":516,"_99":163,"_166":226,"_168":517,"_169":22,"_170":-5,"_171":518,"_98":519},"0c085698-1c21-11f0-a5b5-569c3dd06744","SETUP.md","da18d57e-1ae8-11f0-983e-569c3dd06744",43,["D",1744958870920],"# Getting Started with Stevens\r\n\r\nThis guide will help you set up and personalize your Stevens butler app.\r\n\r\n## Initial Setup\r\n\r\n### 1. Initialize the App\r\n\r\nTo set up the app with a fresh database, run:\r\n\r\n```bash\r\ndeno run -A initializeApp.ts --clean\r\n```\r\n\r\nThis will:\r\n- Create a fresh, empty database\r\n- Set up all necessary database tables and indexes\r\n- Import calendar events (if Google Calendar API credentials are set)\r\n\r\n### 2. Environment Variables\r\n\r\nTo use all features, you'll need to set these environment variables:\r\n\r\n#### For LLM functionality:\r\n- `ANTHROPIC_API_KEY` - For AI responses and daily briefings\r\n\r\n#### For Telegram integration:\r\n- `TELEGRAM_TOKEN` - Your Telegram bot token\r\n- `TELEGRAM_CHAT_ID` - Your Telegram chat ID\r\n- `TELEGRAM_SECONDARY_CHAT_ID` - (Optional) Secondary Telegram chat ID for sending briefings to multiple recipients\r\n\r\n#### For Google Calendar integration:\r\n- `GOOGLE_CLIENT_ID` - Google API client ID\r\n- `GOOGLE_CLIENT_SECRET` - Google API client secret \r\n- `GOOGLE_REFRESH_TOKEN` - Google OAuth refresh token\r\n- `GOOGLE_CALENDAR_ID` - Your Google Calendar ID (or \"primary\")\r\n\r\n### 3. Running Imports\r\n\r\nAfter setup, you can run individual importers to populate your database:\r\n\r\n```bash\r\n# Import calendar events\r\ndeno run -A importers/getCalendarEvents.ts\r\n\r\n# Import weather data (for Perth, Australia in Celsius)\r\ndeno run -A importers/getWeather.ts\r\n\r\n# Generate fun facts\r\ndeno run -A importers/generateFunFacts.ts\r\n```\r\n\r\n### 4. Database Management\r\n\r\nYou can manage your database with these utilities:\r\n\r\n```bash\r\n# Clean the database (remove all data)\r\ndeno run -A dbUtils/cleanDatabase.ts\r\n\r\n# Set up the database structure\r\ndeno run -A dbUtils/setupDatabase.ts\r\n```\r\n\r\n## Personalizing Your App\r\n\r\nYou can personalize Stevens by:\r\n\r\n1. Adding your own importers for data sources you care about\r\n2. Modifying the daily briefing format in the `dailyBriefing` directory\r\n3. Adjusting location settings (currently set to Perth, Australia)\r\n4. Changing temperature units (currently set to Celsius)\r\n\r\n## Regional Settings\r\n\r\nThe app is currently configured for:\r\n- **Location**: Perth, Australia\r\n- **Timezone**: Australia/Perth (UTC+8)\r\n- **Temperature**: Celsius (°C)\r\n- **Time Format**: 12-hour (AM/PM)\r\n\r\n## Dashboard\r\n\r\nAccess the admin dashboard through Val Town to view your memories and manage your data.\r\n\r\n## Security Note\r\n\r\n**Important**: The admin dashboard doesn't have authentication. It relies on security by obscurity. Consider implementing proper authentication if storing sensitive data.\r\n\r\n## Troubleshooting\r\n\r\nIf you encounter issues:\r\n\r\n- Check your environment variables are correctly set\r\n- Ensure you have the necessary permissions for API calls\r\n- Look at the console logs for detailed error messages ",[],[513],{"_102":521,"_95":522,"_158":523,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":524,"_99":32,"_166":189,"_168":525,"_169":22,"_170":-5,"_171":526,"_98":527},"d52a6c1a-1a09-11f0-bd50-569c3dd06744","backstory.ts","4f210c0c-6647-43fd-b919-2f49c824cfbb",["D",1744728998137],"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",[],[522],{"_102":529,"_95":530,"_158":531,"_160":-5,"_161":139,"_162":532,"_164":116,"_104":533,"_99":32,"_166":226,"_168":534,"_169":22,"_170":-5,"_171":535,"_98":536},"da217094-1ae8-11f0-9098-569c3dd06744","deno.json","da217152-1ae8-11f0-9098-569c3dd06744",19,["D",1744824784140],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[],[530],{"_102":538,"_95":539,"_158":540,"_160":-5,"_161":139,"_162":541,"_164":116,"_104":542,"_99":32,"_166":189,"_168":543,"_169":22,"_170":-5,"_171":544,"_98":545},"3721e61e-1aeb-11f0-982b-569c3dd06744","initializeApp.ts","3721e6dc-1aeb-11f0-982b-569c3dd06744",28,["D",1744825799285],"import setupDatabase from \"./dbUtils/setupDatabase.ts\";\r\nimport cleanDatabase from \"./dbUtils/cleanDatabase.ts\";\r\nimport getCalendarEvents from \"./importers/getCalendarEvents.ts\";\r\n\r\n/**\r\n * Initializes the application by:\r\n * 1. Optionally cleaning the database (removing all existing data)\r\n * 2. Setting up the database structure\r\n * 3. Importing calendar events (if Google Calendar credentials are set)\r\n * 4. Setting up any other integrations\r\n */\r\nexport default async function initializeApp(options = { cleanFirst: false }) {\r\n try {\r\n console.log(\"Initializing memories app...\");\r\n \r\n // Step 0: Optionally clean the database first\r\n if (options.cleanFirst) {\r\n console.log(\"Cleaning database...\");\r\n await cleanDatabase();\r\n console.log(\"✅ Database cleaned\");\r\n }\r\n \r\n // Step 1: Set up the database\r\n await setupDatabase();\r\n console.log(\"✅ Database initialized\");\r\n \r\n // Step 2: Import calendar events if credentials are set\r\n try {\r\n console.log(\"Importing calendar events...\");\r\n const events = await getCalendarEvents();\r\n console.log(`✅ Imported ${events.length} calendar events`);\r\n } catch (error) {\r\n console.warn(\"⚠️ Could not import calendar events:\", error.message);\r\n console.warn(\"To enable calendar integration, set the required Google Calendar API credentials as environment variables.\");\r\n }\r\n \r\n // Add additional importers or setup steps here\r\n \r\n console.log(\"✅ App initialization complete!\");\r\n return \"App initialization complete.\";\r\n } catch (error) {\r\n console.error(\"❌ Error initializing app:\", error);\r\n throw error;\r\n }\r\n}\r\n\r\n// Run this file directly to initialize the app\r\n// @ts-ignore: Deno-specific API\r\nif (import.meta.url === Deno.mainModule) {\r\n // Check for command line args\r\n // @ts-ignore: Deno-specific API\r\n const args = Deno.args;\r\n const cleanFirst = args.includes(\"--clean\") || args.includes(\"-c\");\r\n \r\n await initializeApp({ cleanFirst });\r\n} ",[],[539],{"_102":547,"_95":548,"_158":549,"_160":-5,"_161":139,"_162":550,"_164":116,"_104":551,"_99":163,"_166":189,"_168":552,"_169":22,"_170":-5,"_171":553,"_98":554},"da152802-1ae8-11f0-abe2-569c3dd06744","memoryUtils.ts","eecd2365-8167-460a-94df-26902ff7fc5c",16,["D",1744824784136],"import { DateTime } from \"https://esm.sh/luxon@3.4.4\";\n\n/**\n * Retrieves all memories from the database\n * @param includeDate Whether to include date-specific memories or not\n * @param startDate Optional start date to filter memories from (ISO format)\n * @returns Array of memory objects\n */\nexport async function getAllMemories(includeDate = true, startDate = null) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Get memories with dates if requested\n let memories = [];\n if (includeDate) {\n const query = startDate\n ? {\n sql: `SELECT id, date(date) as date, text FROM memories WHERE date >= :startDate AND date <= date(:startDate, '+7 days') ORDER BY date ASC`,\n args: { startDate },\n }\n : `SELECT id, date(date) as date, text FROM memories WHERE date IS NOT NULL ORDER BY date ASC`;\n\n const dateMemories = await sqlite.execute(query);\n memories = [...dateMemories.rows];\n }\n\n // Always get dateless memories\n const datelessMemories = await sqlite.execute(\n `SELECT id, date, text FROM memories WHERE date IS NULL`\n );\n\n return [...memories, ...datelessMemories.rows];\n } catch (error) {\n console.error(\"Error retrieving memories:\", error);\n return [];\n }\n}\n\n/**\n * Gets memories relevant to today and future dates\n * @returns Array of memory objects\n */\nexport async function getRelevantMemories() {\n try {\n // Get today's date in Perth time\n const today = DateTime.now().setZone(\"Australia/Perth\").startOf(\"day\");\n const todayFormatted = today.toFormat(\"yyyy-MM-dd\");\n\n return await getAllMemories(true, todayFormatted);\n } catch (error) {\n console.error(\"Error getting relevant memories:\", error);\n return [];\n }\n}\n\n/**\n * Formats memories into a string for the system prompt\n * @param memories Array of memory objects\n * @returns Formatted string of memories\n */\nexport function formatMemoriesForPrompt(memories) {\n if (!memories || memories.length === 0) {\n return \"No stored memories are available.\";\n }\n\n // Format dated memories\n const datedMemories = memories\n .filter((memory) => memory.date)\n .map((memory) => {\n const date = DateTime.fromISO(memory.date);\n return `- ${date.toFormat(\"yyyy-MM-dd\")} [ID: ${memory.id}]: ${\n memory.text\n }`;\n });\n\n // Format dateless memories\n const datelessMemories = memories\n .filter((memory) => !memory.date)\n .map((memory) => `- [ID: ${memory.id}]: ${memory.text}`);\n\n let result = \"\";\n\n if (datedMemories.length > 0) {\n result += \"Dated memories:\\n\" + datedMemories.join(\"\\n\") + \"\\n\\n\";\n }\n\n if (datelessMemories.length > 0) {\n result += \"General memories:\\n\" + datelessMemories.join(\"\\n\");\n }\n\n return result;\n}\n",[],[548],{"_102":556,"_95":557,"_158":558,"_160":-5,"_161":139,"_162":559,"_164":116,"_104":560,"_99":144,"_166":189,"_168":561,"_169":22,"_170":-5,"_171":562,"_98":563},"ed5108c4-1aec-11f0-96fe-569c3dd06744","populateDemo.ts","25f000ec-cf50-4df4-8cbc-4f2cbc441285",33,["D",1744826534450],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst MEMORIES_TABLE = \"memories\";\nconst MEMORIES_DEMO_TABLE = \"memories_demo\";\nconst TELEGRAM_TABLE = \"telegram_chats\";\n\n// Create the memories table\nasync function createMemoriesTable() {\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEMORIES_TABLE} (\n id TEXT PRIMARY KEY,\n date TEXT,\n text TEXT NOT NULL,\n createdBy TEXT,\n createdDate NUMBER,\n tags TEXT\n )\n `);\n console.log(`Created table: ${MEMORIES_TABLE}`);\n\n // Also create demo table with same schema\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEMORIES_DEMO_TABLE} (\n id TEXT PRIMARY KEY,\n date TEXT,\n text TEXT NOT NULL,\n createdBy TEXT,\n createdDate NUMBER,\n tags TEXT\n )\n `);\n console.log(`Created table: ${MEMORIES_DEMO_TABLE}`);\n } catch (error) {\n console.error(\"Error creating memories tables:\", error);\n throw error;\n }\n}\n\n// Clear all memories from the database\nasync function clearMemories() {\n try {\n // Delete all records from both tables\n await sqlite.execute(`DELETE FROM ${MEMORIES_TABLE}`);\n console.log(`Successfully cleared all memories from ${MEMORIES_TABLE}.`);\n \n await sqlite.execute(`DELETE FROM ${MEMORIES_DEMO_TABLE}`);\n console.log(`Successfully cleared all memories from ${MEMORIES_DEMO_TABLE}.`);\n \n return `Successfully cleared all memories from both ${MEMORIES_TABLE} and ${MEMORIES_DEMO_TABLE}.`;\n } catch (error) {\n console.error(\"Error clearing memories:\", error);\n throw error;\n }\n}\n\n// Clear telegram chat history to reset conversation flow\nasync function resetTelegramChat() {\n try {\n // Check if the telegram_chats table exists\n const tableExists = await sqlite.execute(`\n SELECT name FROM sqlite_master WHERE type='table' AND name='${TELEGRAM_TABLE}'\n `);\n\n if (tableExists.rows.length === 0) {\n console.log(`Table ${TELEGRAM_TABLE} does not exist yet.`);\n return `Table ${TELEGRAM_TABLE} does not exist yet.`;\n }\n\n // Delete all records from the telegram_chats table\n await sqlite.execute(`DELETE FROM ${TELEGRAM_TABLE}`);\n console.log(`Successfully cleared all messages from ${TELEGRAM_TABLE}.`);\n return `Successfully cleared all messages from ${TELEGRAM_TABLE}. Stevens will now ask the setup questions again when you restart the conversation with /start.`;\n } catch (error) {\n console.error(\"Error resetting telegram chat:\", error);\n throw error;\n }\n}\n\n// Main function to create empty memory table and reset telegram chat\nexport default async function setupEmptyMemories() {\n try {\n // Create the tables if they don't exist\n await createMemoriesTable();\n\n // Clear any existing memories\n await clearMemories();\n\n // Reset telegram chat\n await resetTelegramChat();\n\n console.log(\"Memory database and telegram chat successfully cleared!\");\n return \"Memory database and telegram chat successfully cleared! Stevens will now ask the setup questions again when you restart the conversation with /start.\";\n } catch (error) {\n console.error(\"Error setting up empty memory database:\", error);\n throw error;\n }\n}\n\n// Run directly\nsetupEmptyMemories();",[],[557],{"_102":565,"_95":566,"_158":567,"_160":-5,"_161":139,"_162":568,"_164":116,"_104":569,"_99":32,"_166":189,"_168":570,"_169":22,"_170":-5,"_171":571,"_98":572},"37284932-1aeb-11f0-b071-569c3dd06744","resetTelegramChat.ts","372849e6-1aeb-11f0-b071-569c3dd06744",30,["D",1744825799288],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\r\n\r\nconst TELEGRAM_TABLE = \"telegram_chats\";\r\n\r\n/**\r\n * Reset telegram chat history to make Stevens ask the setup questions again\r\n */\r\nexport default async function resetTelegramChat() {\r\n try {\r\n // Check if the telegram_chats table exists\r\n const tableExists = await sqlite.execute(`\r\n SELECT name FROM sqlite_master WHERE type='table' AND name='${TELEGRAM_TABLE}'\r\n `);\r\n\r\n if (tableExists.rows.length === 0) {\r\n console.log(`Table ${TELEGRAM_TABLE} does not exist yet.`);\r\n return {\r\n success: false,\r\n message: `Table ${TELEGRAM_TABLE} does not exist yet.`\r\n };\r\n }\r\n\r\n // Delete all records from the telegram_chats table\r\n await sqlite.execute(`DELETE FROM ${TELEGRAM_TABLE}`);\r\n console.log(`Successfully cleared all messages from ${TELEGRAM_TABLE}.`);\r\n \r\n return {\r\n success: true,\r\n message: `Successfully cleared all messages from ${TELEGRAM_TABLE}. Stevens will now ask the setup questions again when you restart the conversation with /start.`\r\n };\r\n } catch (error) {\r\n console.error(\"Error resetting telegram chat:\", error);\r\n return {\r\n success: false,\r\n error: error.message,\r\n stack: error.stack\r\n };\r\n }\r\n}\r\n\r\n// Export a function to run directly\r\nexport async function runReset() {\r\n const result = await resetTelegramChat();\r\n console.log(result);\r\n return result;\r\n}\r\n\r\n// This file can be executed directly \r\nrunReset(); ",[],[566],"files",[155,173,183,193,202,209,215,221,230,240,247,256,262,268,276,284,293,300,308,316,325,331,338,346,355,363,369,378,386,394,402,411,421,427,436,446,455,463,473,478,486,494,503,511,520,528,537,546,555,564],"counts",{"_577":32,"_578":163,"_579":32,"_580":581},"pulls","branches","forks","envVars",9,"contents",[584,587,590,593,596,599,602,605,608,611,614,617,620,623,626],{"_102":156,"_95":157,"_158":159,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":585,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_98":586},["D",1744728998137],[157],{"_102":203,"_95":204,"_158":205,"_160":-5,"_161":139,"_162":206,"_164":116,"_104":588,"_99":163,"_166":167,"_168":-5,"_169":22,"_170":-5,"_98":589},["D",1745241172868],[204],{"_102":364,"_95":365,"_158":366,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":591,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_98":592},["D",1744728998137],[365],{"_102":422,"_95":423,"_158":424,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":594,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_98":595},["D",1744728998137],[423],{"_102":474,"_95":327,"_158":475,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":597,"_99":32,"_166":167,"_168":-5,"_169":22,"_170":-5,"_98":598},["D",1744728998137],[327],{"_102":487,"_95":488,"_158":489,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":600,"_99":32,"_166":226,"_168":491,"_169":22,"_170":-5,"_98":601},["D",1744728998137],[488],{"_102":495,"_95":496,"_158":497,"_160":-5,"_161":139,"_162":498,"_164":116,"_104":603,"_99":32,"_166":226,"_168":500,"_169":22,"_170":-5,"_98":604},["D",1744824784168],[496],{"_102":504,"_95":223,"_158":505,"_160":-5,"_161":139,"_162":506,"_164":116,"_104":606,"_99":163,"_166":226,"_168":508,"_169":22,"_170":-5,"_98":607},["D",1744958870917],[223],{"_102":512,"_95":513,"_158":514,"_160":-5,"_161":139,"_162":515,"_164":116,"_104":609,"_99":163,"_166":226,"_168":517,"_169":22,"_170":-5,"_98":610},["D",1744958870920],[513],{"_102":521,"_95":522,"_158":523,"_160":-5,"_161":139,"_162":163,"_164":116,"_104":612,"_99":32,"_166":189,"_168":525,"_169":22,"_170":-5,"_98":613},["D",1744728998137],[522],{"_102":529,"_95":530,"_158":531,"_160":-5,"_161":139,"_162":532,"_164":116,"_104":615,"_99":32,"_166":226,"_168":534,"_169":22,"_170":-5,"_98":616},["D",1744824784140],[530],{"_102":538,"_95":539,"_158":540,"_160":-5,"_161":139,"_162":541,"_164":116,"_104":618,"_99":32,"_166":189,"_168":543,"_169":22,"_170":-5,"_98":619},["D",1744825799285],[539],{"_102":547,"_95":548,"_158":549,"_160":-5,"_161":139,"_162":550,"_164":116,"_104":621,"_99":163,"_166":189,"_168":552,"_169":22,"_170":-5,"_98":622},["D",1744824784136],[548],{"_102":556,"_95":557,"_158":558,"_160":-5,"_161":139,"_162":559,"_164":116,"_104":624,"_99":144,"_166":189,"_168":561,"_169":22,"_170":-5,"_98":625},["D",1744826534450],[557],{"_102":565,"_95":566,"_158":567,"_160":-5,"_161":139,"_162":568,"_164":116,"_104":627,"_99":32,"_166":189,"_168":570,"_169":22,"_170":-5,"_98":628},["D",1744825799288],[566],"upstreamProject",{"_102":147,"_95":96,"_110":-5,"_111":-5,"_108":109,"_23":631},{"_93":632,"_131":633},"geoffreylitt","https://secure.gravatar.com/avatar/94262cddd28e127e29dacba5f09c8125.jpg?s=200&d=identicon","upstreamBranch",{"_102":142,"_104":636,"_637":638,"_95":43,"_140":147,"_99":581,"_141":639,"_143":640,"_641":642,"_106":-5,"_152":22,"_108":109,"_151":632,"_16":149,"_150":96},["D",1744479939609],"updatedAt",["D",1744990353681],"419a43c8-147b-11f0-96a2-569c3dd06744",228,"lockfileKey","1756138911771-esm.town_v_geoffreylitt_stevensDemo@9-main","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branches",{"_93":94,"_95":96,"_100":649,"_578":654},{"_102":103,"_95":96,"_104":650,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":114,"_115":116,"_117":118,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":651,"_133":652,"_136":653,"_152":22},["D",1744728998137],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_99":138,"_95":43,"_102":139,"_140":103,"_141":142,"_143":144,"_145":109,"_146":147,"_148":149,"_150":96,"_151":94},[655],{"_102":139,"_104":656,"_637":657,"_95":43,"_140":103,"_99":138,"_141":142,"_143":144,"_641":658,"_106":-5},["D",1744728998137],["D",1745320653165],"1756869673748-esm.town_v_yumyab_stevensDemo@63-main","actionData","errors"]

yumyab

stevensDemo

Branches1

Branches
1