[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_309":310,"_311":312},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",23,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","reminder-api.http.ts","latestPath","fileId","85a5e346-5d37-11f1-9b30-1607ee4eb77e","name","fileType","http","content","/** HTTP admin UI and CRUD API for the Val Town reminders SQLite people table. */\n\nimport { runAiCommand } from \"./lib/admin/ai.ts\";\nimport {\n AuthError,\n requireAdminAccess,\n requireAdminSession,\n withValTownAuth,\n} from \"./lib/admin/auth.ts\";\nimport { parsePeopleCsv } from \"./lib/admin/csv.ts\";\nimport {\n createPerson,\n deletePerson,\n getPerson,\n importPeople,\n listPeople,\n updatePerson,\n} from \"./lib/db.ts\";\nimport { renderAdminPage, renderLockedPage } from \"./lib/admin/ui.tsx\";\n\ntype RouteMatch = { id?: number };\n\nasync function handler(req: Request): Promise {\n try {\n return await routeRequest(req);\n } catch (err) {\n if (err instanceof AuthError) return jsonError(err.message, err.status);\n if (err instanceof Response) return err;\n const message = err instanceof Error ? err.message : String(err);\n return jsonError(message, 400);\n }\n}\n\nexport default withValTownAuth(handler);\n\nasync function routeRequest(req: Request): Promise {\n const url = new URL(req.url);\n\n if (req.method === \"GET\" && isAdminPage(url.pathname)) {\n return await adminPage(req);\n }\n if (req.method === \"POST\" && url.pathname === \"/people/import-csv\") {\n await requireAdminAccess(req);\n return await importCsvFromRequest(req);\n }\n if (req.method === \"POST\" && url.pathname === \"/ai\") {\n await requireAdminAccess(req);\n return await aiFromRequest(req);\n }\n\n const match = matchPeopleRoute(url.pathname);\n if (!match) return jsonError(\"not found\", 404);\n await requireAdminAccess(req);\n\n if (req.method === \"GET\" && match.id == null) {\n return jsonOk({ people: await listPeople() });\n }\n if (req.method === \"GET\" && match.id != null) {\n return await fetchPerson(match.id);\n }\n if (req.method === \"POST\" && match.id == null) {\n return await createFromRequest(req);\n }\n if (req.method === \"PUT\" && match.id != null) {\n return await updateFromRequest(req, match.id);\n }\n if (req.method === \"DELETE\" && match.id != null) {\n return await deleteFromRequest(match.id);\n }\n return jsonError(\"method not allowed\", 405);\n}\n\nfunction isAdminPage(pathname: string): boolean {\n return pathname === \"/\" || pathname === \"/admin\";\n}\n\nfunction matchPeopleRoute(pathname: string): RouteMatch | null {\n const parts = pathname.replace(/\\/+$/, \"\").split(\"/\").filter(Boolean);\n if (parts.length === 1 && parts[0] === \"people\") return {};\n if (parts.length === 2 && parts[0] === \"people\") {\n const id = Number(parts[1]);\n return Number.isInteger(id) && id > 0 ? { id } : null;\n }\n return null;\n}\n\nasync function adminPage(req: Request): Promise {\n try {\n const session = await requireAdminSession(req);\n const html = renderAdminPage(await listPeople(), session.username);\n return htmlResponse(html);\n } catch (err) {\n if (err instanceof AuthError) return htmlResponse(renderLockedPage(err.message), err.status);\n throw err;\n }\n}\n\nasync function fetchPerson(id: number): Promise {\n const person = await getPerson(id);\n return person ? jsonOk({ person }) : jsonError(\"person not found\", 404);\n}\n\nasync function createFromRequest(req: Request): Promise {\n const person = await createPerson(await req.json());\n return jsonOk({ person }, 201);\n}\n\nasync function updateFromRequest(req: Request, id: number): Promise {\n const person = await updatePerson(id, await req.json());\n return person ? jsonOk({ person }) : jsonError(\"person not found\", 404);\n}\n\nasync function deleteFromRequest(id: number): Promise {\n const deleted = await deletePerson(id);\n return deleted ? jsonOk({ deleted: true }) : jsonError(\"person not found\", 404);\n}\n\nasync function importCsvFromRequest(req: Request): Promise {\n const body = await req.json();\n const csv = typeof body.csv === \"string\" ? body.csv : \"\";\n if (!csv.trim()) throw new Error(\"csv is required\");\n\n const parsed = parsePeopleCsv(csv);\n const people = await importPeople(parsed.people);\n return jsonOk({ imported: people.length, skipped: parsed.skipped, people }, 201);\n}\n\nasync function aiFromRequest(req: Request): Promise {\n const body = await req.json();\n const query = typeof body.query === \"string\" ? body.query : \"\";\n const dryRun = body.dryRun === true;\n return jsonOk({ result: await runAiCommand({ query, dryRun }) });\n}\n\nfunction htmlResponse(html: string, status = 200): Response {\n return new Response(html, {\n status,\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction jsonOk(data: Record, status = 200): Response {\n return Response.json({ ok: true, ...data }, { status });\n}\n\nfunction jsonError(message: string, status: number): Response {\n return Response.json({ ok: false, error: message }, { status });\n}\n","/** HTTP admin UI and CRUD API for the Val Town reminders SQLite people table. */\n\nimport { runAiCommand } from \"./lib/admin/ai.ts\";\nimport {\n AuthError,\n requireAdminAccess,\n requireAdminSession,\n withValTownAuth,\n} from \"./lib/admin/auth.ts\";\nimport { parsePeopleCsv } from \"./lib/admin/csv.ts\";\nimport {\n createPerson,\n deletePerson,\n getPerson,\n importPeople,\n listPeople,\n updatePerson,\n} from \"./lib/db.ts\";\nimport { renderAdminPage, renderLockedPage } from \"./lib/admin/ui.tsx\";\n\ntype RouteMatch = { id?: number };\n\nasync function handler(req: Request): Promise {\n try {\n return await routeRequest(req);\n } catch (err) {\n if (err instanceof AuthError) return jsonError(err.message, err.status);\n if (err instanceof Response) return err;\n const message = err instanceof Error ? err.message : String(err);\n return jsonError(message, 400);\n }\n}\n\nexport default withValTownAuth(handler);\n\nasync function routeRequest(req: Request): Promise {\n const url = new URL(req.url);\n\n if (req.method === \"GET\" && isAdminPage(url.pathname)) {\n return await adminPage(req);\n }\n if (req.method === \"POST\" && url.pathname === \"/people/import-csv\") {\n await requireAdminAccess(req);\n return await importCsvFromRequest(req);\n }\n if (req.method === \"POST\" && url.pathname === \"/ai\") {\n await requireAdminAccess(req);\n return await aiFromRequest(req);\n }\n\n const match = matchPeopleRoute(url.pathname);\n if (!match) return jsonError(\"not found\", 404);\n await requireAdminAccess(req);\n\n if (req.method === \"GET\" && match.id == null) {\n return jsonOk({ people: await listPeople() });\n }\n if (req.method === \"GET\" && match.id != null) {\n return await fetchPerson(match.id);\n }\n if (req.method === \"POST\" && match.id == null) {\n return await createFromRequest(req);\n }\n if (req.method === \"PUT\" && match.id != null) {\n return await updateFromRequest(req, match.id);\n }\n if (req.method === \"DELETE\" && match.id != null) {\n return await deleteFromRequest(match.id);\n }\n return jsonError(\"method not allowed\", 405);\n}\n\nfunction isAdminPage(pathname: string): boolean {\n return pathname === \"/\" || pathname === \"/admin\";\n}\n\nfunction matchPeopleRoute(pathname: string): RouteMatch | null {\n const parts = pathname.replace(/\\/+$/, \"\").split(\"/\").filter(Boolean);\n if (parts.length === 1 && parts[0] === \"people\") return {};\n if (parts.length === 2 && parts[0] === \"people\") {\n const id = Number(parts[1]);\n return Number.isInteger(id) && id > 0 ? { id } : null;\n }\n return null;\n}\n\nasync function adminPage(req: Request): Promise {\n try {\n const session = await requireAdminSession(req);\n const html = renderAdminPage(await listPeople(), session.username);\n return htmlResponse(html);\n } catch (err) {\n if (err instanceof AuthError) return htmlResponse(renderLockedPage(err.message));\n throw err;\n }\n}\n\nasync function fetchPerson(id: number): Promise {\n const person = await getPerson(id);\n return person ? jsonOk({ person }) : jsonError(\"person not found\", 404);\n}\n\nasync function createFromRequest(req: Request): Promise {\n const person = await createPerson(await req.json());\n return jsonOk({ person }, 201);\n}\n\nasync function updateFromRequest(req: Request, id: number): Promise {\n const person = await updatePerson(id, await req.json());\n return person ? jsonOk({ person }) : jsonError(\"person not found\", 404);\n}\n\nasync function deleteFromRequest(id: number): Promise {\n const deleted = await deletePerson(id);\n return deleted ? jsonOk({ deleted: true }) : jsonError(\"person not found\", 404);\n}\n\nasync function importCsvFromRequest(req: Request): Promise {\n const body = await req.json();\n const csv = typeof body.csv === \"string\" ? body.csv : \"\";\n if (!csv.trim()) throw new Error(\"csv is required\");\n\n const parsed = parsePeopleCsv(csv);\n const people = await importPeople(parsed.people);\n return jsonOk({ imported: people.length, skipped: parsed.skipped, people }, 201);\n}\n\nasync function aiFromRequest(req: Request): Promise {\n const body = await req.json();\n const query = typeof body.query === \"string\" ? body.query : \"\";\n const dryRun = body.dryRun === true;\n return jsonOk({ result: await runAiCommand({ query, dryRun }) });\n}\n\nfunction htmlResponse(html: string, status = 200): Response {\n return new Response(html, {\n status,\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction jsonOk(data: Record, status = 200): Response {\n return Response.json({ ok: true, ...data }, { status });\n}\n\nfunction jsonError(message: string, status: number): Response {\n return Response.json({ ok: false, error: message }, { status });\n}\n","createdAt",["D",1780266386616],"branchVersion","branchId","84bf5548-5d37-11f1-b50f-1607ee4eb77e","id","84bea404-5d37-11f1-b50f-1607ee4eb77e","reminders",["D",1780262845686],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A personal app to remind of important events in life","imageUrl","173e7424-8658-428f-a3bc-ae4faeaabd1c","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019df771-9af8-7238-99a4-541e39355038","tursoName","84bea4045d3711f1b50f1607ee4eb77e","tursoHostname","84bea4045d3711f1b50f1607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789508444194],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",33,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pikachu","handle","displayName","Minion","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/22c8ba37-42c8-4af4-8daf-8cdd2f5f1800/square512?exp=1789559999&sig=7b712b29dcf48c68d1e9520535f5dc60d43a44973694971c2746d2d1c6f0552b","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":304,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":305,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":306,"_83":307,"_85":308,"_87":25},"tree",[189,200,201,202,203,204],"files",[189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204],"counts",{"_179":62,"_180":143,"_181":62,"_182":183,"_184":185},"contents",[130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":173,"_32":174,"_30":175,"_139":-5,"_41":42,"_40":143,"_141":58,"_38":176,"_13":62,"_33":177,"_35":-5,"_24":25,"_145":-5,"_27":178},{"_43":166,"_32":167,"_30":168,"_139":-5,"_41":42,"_40":169,"_141":25,"_38":170,"_13":143,"_33":20,"_35":171,"_24":25,"_145":-5,"_27":172},{"_43":159,"_32":160,"_30":161,"_139":-5,"_41":42,"_40":162,"_141":58,"_38":163,"_13":62,"_33":20,"_35":164,"_24":25,"_145":-5,"_27":165},{"_43":155,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":58,"_38":156,"_13":150,"_33":34,"_35":37,"_24":25,"_145":157,"_27":158},{"_43":147,"_32":148,"_30":149,"_139":-5,"_41":42,"_40":150,"_141":58,"_38":151,"_13":62,"_33":152,"_35":153,"_24":25,"_145":-5,"_27":154},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":143,"_33":20,"_35":144,"_24":25,"_145":-5,"_27":146},"6e4919fe-5d3f-11f1-bdd9-1607ee4eb77e","val.yml","85c55e9c-5d37-11f1-8c4a-1607ee4eb77e","parentId",18,"latest",["D",1780266243883],1,"name: \"reminders\"\npublic: true\nunlisted: false\norg: \"me\"\nfiles:\n reminder-api.http.ts: http\n reminder-check.cron.ts: interval\nenv:\n ADMIN_USERNAME: required # Val Town username allowed to see the admin UI\n ADMIN_TOKEN: required # bearer token for direct API access\n TELEGRAM_BOT_TOKEN: required # Telegram bot token\n TELEGRAM_CHAT_ID: required # destination chat/channel id\n LOOKAHEAD_DAYS: optional # default 8\n DRY_RUN: optional # true skips Telegram send and returns/logs message\n","label",[137],"85bfd332-5d37-11f1-a35f-1607ee4eb77e","reminder-check.cron.ts","85bfd418-5d37-11f1-a35f-1607ee4eb77e",3,["D",1780262847362],"interval","/** Daily cron entrypoint for look-ahead reminders and Telegram delivery. */\n\nimport { listPeople } from \"./lib/db.ts\";\nimport { upcomingReminderEvents } from \"./lib/dates.ts\";\nimport {\n formatReminderMessage,\n hasMeaningfulReminderMessage,\n} from \"./lib/messages.ts\";\nimport { sendTelegramMessage } from \"./lib/telegram.ts\";\nimport type { ReminderCheckResult } from \"./lib/types.ts\";\n\nexport default async function reminderCheck(\n req?: Request,\n): Promise {\n const result = await runReminderCheck({\n dryRun: isDryRun(req),\n lookaheadDays: lookaheadDaysFromEnv(),\n startDate: new Date(),\n });\n console.log(result.message);\n return result;\n}\n\nexport async function runReminderCheck(options: {\n dryRun: boolean;\n lookaheadDays: number;\n startDate: Date;\n}): Promise {\n const people = await listPeople();\n const events = upcomingReminderEvents(\n people,\n options.startDate,\n options.lookaheadDays,\n );\n const message = formatReminderMessage(events, options.lookaheadDays);\n const shouldSend = hasMeaningfulReminderMessage(events) && !options.dryRun;\n\n if (shouldSend) await sendTelegramMessage(message);\n return {\n lookaheadDays: options.lookaheadDays,\n dryRun: options.dryRun,\n events,\n message,\n sent: shouldSend,\n };\n}\n\nfunction lookaheadDaysFromEnv(): number {\n const raw = Number(Deno.env.get(\"LOOKAHEAD_DAYS\") ?? \"8\");\n if (!Number.isFinite(raw) || raw < 1) return 8;\n return Math.floor(raw);\n}\n\nfunction isDryRun(req?: Request): boolean {\n if (Deno.env.get(\"DRY_RUN\") === \"true\") return true;\n if (!req) return false;\n return new URL(req.url).searchParams.get(\"dryRun\") === \"1\";\n}\n",[148],"c355dcc0-5d3f-11f1-9464-1607ee4eb77e",["D",1780266386616],"my-reminders",[28],"85cdbe66-5d37-11f1-940a-1607ee4eb77e","deno.json","85cdbf10-5d37-11f1-940a-1607ee4eb77e",5,["D",1780262847362],"{\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\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"fmt\": {\n \"lineWidth\": 100\n },\n \"lint\": {\n \"rules\": {\n \"exclude\": [\"no-external-import\", \"no-import-prefix\"]\n }\n },\n \"node_modules_dir\": false,\n \"unstable\": [\"temporal\", \"worker-options\", \"sloppy-imports\", \"node-globals\"]\n}\n",[160],"6e5ec92a-5d3f-11f1-9656-1607ee4eb77e","README.md","86341fbc-5d37-11f1-8021-1607ee4eb77e",19,["D",1780266244109],"# Reminders\n\nSQLite-backed birthday and anniversary reminders for Val Town.\n\nThis val is intentionally small: one HTTP admin UI/API, one daily cron checker, pure date/message\nhelpers, and inline Telegram delivery.\n\nThis repo owns the app-specific reminder port. The sibling uApps repo owns the shared `vtx` wrapper\nplus reusable Val Town templates/examples such as `$HOME/minion/uApps/vals/_template/` and\n`$HOME/minion/uApps/vals/null-css/`.\n\n## Files\n\n```text\nreminders/\n├── lib/\n│ ├── admin/\n│ │ ├── ai.ts # GPT command endpoint helpers\n│ │ ├── auth.ts # Val Town OAuth + bearer token admin auth\n│ │ ├── csv.ts # CSV schema import parser\n│ │ └── ui.tsx # Preact SSR + null-css admin UI\n│ ├── db.ts # SQLite schema + CRUD helpers\n│ ├── dates.ts # pure look-ahead date calculations\n│ ├── messages.ts # pure Telegram message formatting\n│ ├── telegram.ts # Bot API fetch helper\n│ └── types.ts # Person and reminder event types\n├── reminder-api.http.ts # HTTP admin UI, CRUD, CSV, and AI API\n├── reminder-check.cron.ts # daily reminder check\n├── deno.json # Deno/Val Town typecheck config\n├── val.yml # Val Town metadata\n└── README.md\n```\n\n## Environment\n\nSet these in the Val Town UI.\n\n| Variable | Required | Purpose |\n| ------------------ | -------- | --------------------------------------------- |\n| ADMIN_USERNAME | yes | Val Town username allowed to see the admin UI |\n| ADMIN_TOKEN | yes | Bearer token for direct API routes |\n| TELEGRAM_BOT_TOKEN | yes | Telegram BotFather token |\n| TELEGRAM_CHAT_ID | yes | Destination chat or channel id |\n| LOOKAHEAD_DAYS | no | Days to scan, default `8` |\n| DRY_RUN | no | `true` skips Telegram delivery |\n\nThe AI endpoint uses Val Town's `std/openai` integration and does not need an OpenAI API key.\n\n## Admin UI\n\nVisit `/` or `/admin` and sign in with Val Town. The UI renders only for `ADMIN_USERNAME`. Direct\nAPI clients can use `ADMIN_TOKEN`.\n\nThe page supports:\n\n- listing, creating, editing, and deleting people\n- CSV upload with columns `name`, `nickName`, `birthdate`, `anniversary`, `isAccurate`, `relation`,\n `email`\n- AI commands that can dry-run or apply `save-row`, `update-row`, and `send-telegram` actions\n\n## API\n\nAll JSON API routes require either the admin Val Town browser session,\n`Authorization: Bearer `, or `X-Admin-Token: `.\n\n```bash\n# list people\ncurl \"$VAL_URL/people\" \\\n -H \"authorization: Bearer $ADMIN_TOKEN\"\n\n# create person\ncurl -X POST \"$VAL_URL/people\" \\\n -H \"authorization: Bearer $ADMIN_TOKEN\" \\\n -H \"content-type: application/json\" \\\n -d '{\"name\":\"Ada Lovelace\",\"birthdate\":\"1815-12-10\",\"relation\":\"history\"}'\n\n# update person\ncurl -X PUT \"$VAL_URL/people/1\" \\\n -H \"authorization: Bearer $ADMIN_TOKEN\" \\\n -H \"content-type: application/json\" \\\n -d '{\"nickName\":\"Ada\",\"isAccurate\":true}'\n\n# delete person\ncurl -X DELETE \"$VAL_URL/people/1\" \\\n -H \"authorization: Bearer $ADMIN_TOKEN\"\n\n# import CSV\ncurl -X POST \"$VAL_URL/people/import-csv\" \\\n -H \"authorization: Bearer $ADMIN_TOKEN\" \\\n -H \"content-type: application/json\" \\\n -d '{\"csv\":\"name,nickName,birthdate,anniversary,isAccurate,relation,email\\nAda,,1815-12-10,,true,history,\"}'\n\n# AI command\ncurl -X POST \"$VAL_URL/ai\" \\\n -H \"authorization: Bearer $ADMIN_TOKEN\" \\\n -H \"content-type: application/json\" \\\n -d '{\"query\":\"Dry-run adding Ada Lovelace with birthday 1815-12-10\",\"dryRun\":true}'\n```\n\nPerson fields: `id`, `name`, `nickName`, `birthdate`, `anniversary`, `isAccurate`, `relation`,\n`email`.\n\nDates are stored as `YYYY-MM-DD`.\n\nLeap-day birthdays and anniversaries are reminded on Feb 28 in non-leap years.\n\n## Local Validation\n\nUse the uApps `vtx` wrapper. Local discovery and validation are safe. Source the toolbox shell first\nso the uApps plugin exposes `vtx`.\n\n```bash\n[[ -n \"$ZSH_VERSION\" && -z \"$TBX_SHELL_INSTALLED\" ]] && source \"$HOME/.zshrc\" 2>/dev/null || true\ncd \"$TOOLBOX/exp/vals/reminders\"\n\nvtx ls\nvtx map\nvtx check\nvtx env\n```\n\n## Cron Type Check\n\nThis checks the cron entrypoint without sending Telegram messages. A real dry run requires invoking\nthe linked Val Town val with `DRY_RUN=true` or `?dryRun=1`.\n\n```bash\ncd \"$TOOLBOX/exp/vals/reminders\"\nDRY_RUN=true LOOKAHEAD_DAYS=8 deno check --config deno.json reminder-check.cron.ts\n```\n\n## Remote Commands\n\nThese mutate Val Town remotely and require explicit approval for the turn:\n\n- `vtx new`\n- `vtx link`\n- `vtx push`\n- `vtx sync`\n- `vtx apply-types`\n- raw mutating `vt` commands\n",[167],"8584eb8c-5d37-11f1-9b30-1607ee4eb77e","lib","8584eca4-5d37-11f1-9b30-1607ee4eb77e",["D",1780262846974],"directory",[174],"pulls","branches","forks","envVars",{"_186":143,"_188":62},"connections",{"_186":62,"_187":62},"count","unfilledCount","emptyCount",{"_43":173,"_32":174,"_30":175,"_139":-5,"_41":42,"_40":143,"_141":58,"_38":301,"_13":62,"_33":177,"_35":-5,"_24":25,"_145":-5,"_206":302,"_27":303},{"_43":296,"_32":271,"_30":265,"_139":175,"_41":42,"_40":297,"_141":58,"_38":298,"_13":62,"_33":177,"_35":-5,"_24":25,"_145":-5,"_206":299,"_27":300},{"_43":288,"_32":289,"_30":290,"_139":265,"_41":42,"_40":291,"_141":25,"_38":292,"_13":62,"_33":226,"_35":293,"_24":25,"_145":-5,"_206":294,"_27":295},{"_43":280,"_32":281,"_30":282,"_139":265,"_41":42,"_40":283,"_141":58,"_38":284,"_13":143,"_33":226,"_35":285,"_24":25,"_145":-5,"_206":286,"_27":287},{"_43":272,"_32":273,"_30":274,"_139":265,"_41":42,"_40":275,"_141":58,"_38":276,"_13":62,"_33":226,"_35":277,"_24":25,"_145":-5,"_206":278,"_27":279},{"_43":262,"_32":263,"_30":264,"_139":265,"_41":42,"_40":266,"_141":25,"_38":267,"_13":143,"_33":226,"_35":268,"_24":25,"_145":-5,"_206":269,"_27":270},{"_43":254,"_32":255,"_30":256,"_139":175,"_41":42,"_40":257,"_141":25,"_38":258,"_13":62,"_33":226,"_35":259,"_24":25,"_145":-5,"_206":260,"_27":261},{"_43":246,"_32":247,"_30":248,"_139":175,"_41":42,"_40":249,"_141":25,"_38":250,"_13":62,"_33":226,"_35":251,"_24":25,"_145":-5,"_206":252,"_27":253},{"_43":238,"_32":239,"_30":240,"_139":175,"_41":42,"_40":241,"_141":25,"_38":242,"_13":62,"_33":226,"_35":243,"_24":25,"_145":-5,"_206":244,"_27":245},{"_43":230,"_32":231,"_30":232,"_139":175,"_41":42,"_40":233,"_141":58,"_38":234,"_13":62,"_33":226,"_35":235,"_24":25,"_145":-5,"_206":236,"_27":237},{"_43":221,"_32":222,"_30":223,"_139":175,"_41":42,"_40":224,"_141":25,"_38":225,"_13":62,"_33":226,"_35":227,"_24":25,"_145":-5,"_206":228,"_27":229},{"_43":166,"_32":167,"_30":168,"_139":-5,"_41":42,"_40":169,"_141":25,"_38":218,"_13":143,"_33":20,"_35":171,"_24":25,"_145":-5,"_206":219,"_27":220},{"_43":159,"_32":160,"_30":161,"_139":-5,"_41":42,"_40":162,"_141":58,"_38":215,"_13":62,"_33":20,"_35":164,"_24":25,"_145":-5,"_206":216,"_27":217},{"_43":155,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":58,"_38":212,"_13":150,"_33":34,"_35":37,"_24":25,"_145":157,"_206":213,"_27":214},{"_43":147,"_32":148,"_30":149,"_139":-5,"_41":42,"_40":150,"_141":58,"_38":209,"_13":62,"_33":152,"_35":153,"_24":25,"_145":-5,"_206":210,"_27":211},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":205,"_13":143,"_33":20,"_35":144,"_24":25,"_145":-5,"_206":207,"_27":208},["D",1780266243883],"children",[],[137],["D",1780262847362],[],[148],["D",1780266386616],[],[28],["D",1780262847362],[],[160],["D",1780266244109],[],[167],"85e17fc8-5d37-11f1-80e4-1607ee4eb77e","types.ts","85e18090-5d37-11f1-80e4-1607ee4eb77e",7,["D",1780262847584],"script","/** Shared person and reminder event types for the Val Town reminders app. */\n\nexport interface Person {\n id: number;\n name: string;\n nickName: string;\n birthdate: string | null;\n anniversary: string | null;\n isAccurate: boolean;\n relation: string;\n email: string;\n}\n\nexport interface PersonInput {\n name: string;\n nickName?: string | null;\n birthdate?: string | null;\n anniversary?: string | null;\n isAccurate?: boolean | null;\n relation?: string | null;\n email?: string | null;\n}\n\nexport type PersonPatch = Partial;\n\nexport type ReminderKind = \"birthday\" | \"anniversary\";\n\nexport interface ReminderEvent {\n kind: ReminderKind;\n person: Person;\n date: string;\n mmdd: string;\n daysFromStart: number;\n isToday: boolean;\n years?: number;\n}\n\nexport interface ReminderCheckResult {\n lookaheadDays: number;\n dryRun: boolean;\n events: ReminderEvent[];\n message: string;\n sent: boolean;\n}\n",[],[174,222],"85f1eaa2-5d37-11f1-aa51-1607ee4eb77e","telegram.ts","85f1eb6a-5d37-11f1-aa51-1607ee4eb77e",9,["D",1780262847690],"/** Telegram Bot API delivery helper using only fetch and Val Town env vars. */\n\nexport interface TelegramConfig {\n token: string;\n chatId: string;\n}\n\nexport function telegramConfigFromEnv(): TelegramConfig {\n return {\n token: requiredEnv(\"TELEGRAM_BOT_TOKEN\"),\n chatId: requiredEnv(\"TELEGRAM_CHAT_ID\"),\n };\n}\n\nexport async function sendTelegramMessage(\n text: string,\n config = telegramConfigFromEnv(),\n): Promise {\n const res = await fetch(\n `https://api.telegram.org/bot${config.token}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: config.chatId,\n text,\n disable_web_page_preview: true,\n }),\n },\n );\n\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Telegram send failed (${res.status}): ${body}`);\n }\n}\n\nfunction requiredEnv(key: string): string {\n const value = Deno.env.get(key);\n if (!value) throw new Error(`${key} is required`);\n return value;\n}\n",[],[174,231],"85e9d4d4-5d37-11f1-ab82-1607ee4eb77e","messages.ts","85e9d57e-5d37-11f1-ab82-1607ee4eb77e",8,["D",1780262847559],"/** Plain-text reminder message formatting with no network dependencies. */\n\nimport type { ReminderEvent } from \"./types.ts\";\n\nexport function formatReminderMessage(\n events: ReminderEvent[],\n lookaheadDays: number,\n): string {\n if (events.length === 0) {\n return `No birthdays or anniversaries in the next ${lookaheadDays} days.`;\n }\n\n const rows = events.map(formatReminderEvent);\n return [\"Upcoming Reminders\", ...rows].join(\"\\n\");\n}\n\nexport function hasMeaningfulReminderMessage(events: ReminderEvent[]): boolean {\n return events.length > 0;\n}\n\nfunction formatReminderEvent(event: ReminderEvent): string {\n const icon = event.kind === \"birthday\" ? \"Birthday\" : \"Anniversary\";\n const name = event.person.nickName || event.person.name;\n const rel = event.person.relation ? ` (${event.person.relation})` : \"\";\n const today = event.isToday ? \" TODAY\" : \"\";\n const years = event.years && event.years > 0 ? `, ${event.years}y` : \"\";\n return `- [${\n formatDisplayDate(event.date)\n }] ${icon}: ${name}${rel}${today}${years}`;\n}\n\nfunction formatDisplayDate(isoDate: string): string {\n const date = new Date(`${isoDate}T12:00:00`);\n return new Intl.DateTimeFormat(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n }).format(date);\n}\n",[],[174,239],"85f85978-5d37-11f1-a234-1607ee4eb77e","db.ts","85f85a18-5d37-11f1-a234-1607ee4eb77e",10,["D",1780262847728],"/** SQLite schema and typed CRUD helpers for reminder people. */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Person, PersonInput, PersonPatch } from \"./types.ts\";\n\nlet migrated = false;\n\nexport async function ensureSchema(): Promise {\n if (migrated) return;\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS people (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n nick_name TEXT NOT NULL DEFAULT '',\n birthdate TEXT,\n anniversary TEXT,\n is_accurate INTEGER NOT NULL DEFAULT 0,\n relation TEXT NOT NULL DEFAULT '',\n email TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n migrated = true;\n}\n\nexport async function listPeople(): Promise {\n await ensureSchema();\n const { rows } = await sqlite.execute(`\n SELECT id, name, nick_name, birthdate, anniversary, is_accurate, relation, email\n FROM people\n ORDER BY name COLLATE NOCASE\n `);\n return rows.map(rowToPerson);\n}\n\nexport async function getPerson(id: number): Promise {\n await ensureSchema();\n const { rows } = await sqlite.execute({\n sql: `\n SELECT id, name, nick_name, birthdate, anniversary, is_accurate, relation, email\n FROM people\n WHERE id = ?\n `,\n args: [id],\n });\n return rows.length ? rowToPerson(rows[0]) : null;\n}\n\nexport async function createPerson(input: PersonInput): Promise {\n await ensureSchema();\n const person = normalizePersonInput(input);\n const { lastInsertRowid } = await sqlite.execute({\n sql: `\n INSERT INTO people (name, nick_name, birthdate, anniversary, is_accurate, relation, email)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `,\n args: [\n person.name,\n person.nickName,\n person.birthdate,\n person.anniversary,\n person.isAccurate ? 1 : 0,\n person.relation,\n person.email,\n ],\n });\n return await mustGetPerson(Number(lastInsertRowid));\n}\n\nexport async function updatePerson(\n id: number,\n patch: PersonPatch,\n): Promise {\n await ensureSchema();\n const current = await getPerson(id);\n if (!current) return null;\n\n const next = normalizePersonInput({ ...current, ...patch });\n await sqlite.execute({\n sql: `\n UPDATE people\n SET name = ?,\n nick_name = ?,\n birthdate = ?,\n anniversary = ?,\n is_accurate = ?,\n relation = ?,\n email = ?,\n updated_at = datetime('now')\n WHERE id = ?\n `,\n args: [\n next.name,\n next.nickName,\n next.birthdate,\n next.anniversary,\n next.isAccurate ? 1 : 0,\n next.relation,\n next.email,\n id,\n ],\n });\n return await mustGetPerson(id);\n}\n\nexport async function deletePerson(id: number): Promise {\n await ensureSchema();\n const { rowsAffected } = await sqlite.execute({\n sql: `DELETE FROM people WHERE id = ?`,\n args: [id],\n });\n return rowsAffected > 0;\n}\n\nexport async function importPeople(people: PersonInput[]): Promise {\n const created: Person[] = [];\n for (const person of people) created.push(await createPerson(person));\n return created;\n}\n\nfunction normalizePersonInput(input: PersonInput): PersonInput {\n const name = text(input.name);\n if (!name) throw new Error(\"name is required\");\n\n return {\n name,\n nickName: text(input.nickName),\n birthdate: dateText(input.birthdate),\n anniversary: dateText(input.anniversary),\n isAccurate: input.isAccurate === true,\n relation: text(input.relation),\n email: text(input.email),\n };\n}\n\nasync function mustGetPerson(id: number): Promise {\n const person = await getPerson(id);\n if (!person) throw new Error(`person ${id} was not found after write`);\n return person;\n}\n\nfunction rowToPerson(row: ArrayLike): Person {\n return {\n id: Number(row[0]),\n name: String(row[1]),\n nickName: String(row[2] ?? \"\"),\n birthdate: nullableText(row[3]),\n anniversary: nullableText(row[4]),\n isAccurate: Number(row[5]) === 1,\n relation: String(row[6] ?? \"\"),\n email: String(row[7] ?? \"\"),\n };\n}\n\nfunction text(value: unknown): string {\n return typeof value === \"string\" ? value.trim() : \"\";\n}\n\nfunction nullableText(value: unknown): string | null {\n return typeof value === \"string\" && value.trim() ? value.trim() : null;\n}\n\nfunction dateText(value: unknown): string | null {\n const textValue = nullableText(value);\n if (!textValue) return null;\n const match = /^(\\d{4})-(\\d{2})-(\\d{2})$/.exec(textValue);\n if (!match) {\n throw new Error(`invalid date '${textValue}', expected YYYY-MM-DD`);\n }\n const [, year, month, day] = match.map(Number);\n const date = new Date(year, month - 1, day, 12, 0, 0, 0);\n if (\n date.getFullYear() !== year || date.getMonth() !== month - 1 ||\n date.getDate() !== day\n ) {\n throw new Error(`invalid calendar date '${textValue}'`);\n }\n return textValue;\n}\n",[],[174,247],"85dae2b2-5d37-11f1-a234-1607ee4eb77e","dates.ts","85dae37a-5d37-11f1-a234-1607ee4eb77e",6,["D",1780262847376],"/** Pure reminder date calculations for birthday and anniversary look-ahead. */\n\nimport type { Person, ReminderEvent, ReminderKind } from \"./types.ts\";\n\nexport function upcomingReminderEvents(\n people: Person[],\n startDate: Date,\n lookaheadDays: number,\n): ReminderEvent[] {\n const days = normalizeLookaheadDays(lookaheadDays);\n const dateByMmdd = new Map(\n dateRange(startDate, days).map((date, idx) => [\n monthDayKey(date),\n { date, idx },\n ]),\n );\n\n return people\n .flatMap((person) => eventsForPerson(person, dateByMmdd, startDate))\n .sort((a, b) =>\n a.daysFromStart - b.daysFromStart || a.kind.localeCompare(b.kind)\n );\n}\n\nexport function normalizeLookaheadDays(value: number): number {\n if (!Number.isFinite(value)) return 8;\n if (value < 1) return 1;\n return Math.floor(value);\n}\n\nexport function dateRange(startDate: Date, numberOfDays: number): Date[] {\n const days = normalizeLookaheadDays(numberOfDays);\n return Array.from({ length: days }, (_, idx) => {\n const date = new Date(startDate);\n date.setHours(12, 0, 0, 0);\n date.setDate(startDate.getDate() + idx);\n return date;\n });\n}\n\nexport function monthDayKey(date: Date): string {\n return `${date.getMonth()}-${date.getDate()}`;\n}\n\nexport function parseLocalDate(value: string | null): Date | null {\n if (!value) return null;\n const match = /^(\\d{4})-(\\d{2})-(\\d{2})/.exec(value);\n if (!match) return null;\n const [, year, month, day] = match;\n return new Date(Number(year), Number(month) - 1, Number(day), 12, 0, 0, 0);\n}\n\nfunction eventsForPerson(\n person: Person,\n dateByMmdd: Map,\n startDate: Date,\n): ReminderEvent[] {\n const candidates: Array<[ReminderKind, string | null]> = [\n [\"birthday\", person.birthdate],\n [\"anniversary\", person.anniversary],\n ];\n\n return candidates.flatMap(([kind, rawDate]) => {\n const sourceDate = parseLocalDate(rawDate);\n if (!sourceDate) return [];\n const due = dueDateFor(sourceDate, dateByMmdd);\n if (!due) return [];\n\n return [{\n kind,\n person,\n date: isoLocalDate(due.date),\n mmdd: monthDayKey(sourceDate),\n daysFromStart: due.idx,\n isToday: due.idx === 0,\n years: elapsedYears(sourceDate, startDate, due.date),\n }];\n });\n}\n\nfunction dueDateFor(\n sourceDate: Date,\n dateByMmdd: Map,\n): { date: Date; idx: number } | undefined {\n const exact = dateByMmdd.get(monthDayKey(sourceDate));\n if (exact) return exact;\n if (!isLeapDay(sourceDate)) return undefined;\n\n const feb28 = dateByMmdd.get(monthDayKey(new Date(2000, 1, 28, 12)));\n if (!feb28 || isLeapYear(feb28.date.getFullYear())) return undefined;\n return feb28;\n}\n\nfunction elapsedYears(\n sourceDate: Date,\n startDate: Date,\n dueDate: Date,\n): number | undefined {\n const years = dueDate.getFullYear() - sourceDate.getFullYear();\n return years >= 0 && dueDate >= startOfDay(startDate) ? years : undefined;\n}\n\nfunction isoLocalDate(date: Date): string {\n const year = date.getFullYear();\n const month = String(date.getMonth() + 1).padStart(2, \"0\");\n const day = String(date.getDate()).padStart(2, \"0\");\n return `${year}-${month}-${day}`;\n}\n\nfunction startOfDay(date: Date): Date {\n const copy = new Date(date);\n copy.setHours(0, 0, 0, 0);\n return copy;\n}\n\nfunction isLeapDay(date: Date): boolean {\n return date.getMonth() === 1 && date.getDate() === 29;\n}\n\nfunction isLeapYear(year: number): boolean {\n return year % 4 === 0 && (year % 100 !== 0 || year % 400 === 0);\n}\n",[],[174,255],"83c19716-5d3f-11f1-b415-1607ee4eb77e","ui.tsx","6e28e06c-5d3f-11f1-9633-1607ee4eb77e","6df70132-5d3f-11f1-9656-1607ee4eb77e",21,["D",1780266279950],"/** Preact SSR admin UI using null-css tokens and compact local behavior. */\n\n/** @jsxImportSource https://esm.sh/preact@10.29.1 */\n\nimport { render } from \"https://esm.sh/preact-render-to-string@6.6.7?deps=preact@10.29.1\";\nimport { NULL_CSS } from \"https://esm.town/v/uapps/null-css/core/main.ts\";\nimport type { ComponentChildren } from \"https://esm.sh/preact@10.29.1\";\nimport type { Person } from \"../types.ts\";\n\nexport function renderLockedPage(\n message = \"Sign in with the configured Val Town admin account.\",\n): string {\n return doc(\n

Reminders

{message}

\n Sign in with Val Town\n

,\n );\n}\n\nexport function renderAdminPage(people: Person[], username: string): string {\n return doc(\n

\n \n\n

\n \n \n \n \n Schema: name, nickName, birthdate, anniversary, isAccurate, relation, email\n \n \n \n

\n\n

People

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {people.map((person) => )}\n \n

Name	Birthday	Anniversary	Relation	Email	Accurate	Actions

\n\n

Log

Ready.

,\n );\n}\n\nfunction Panel(props: { title: string; children: ComponentChildren }) {\n return (\n

{props.title}

\n {props.children}\n

\n );\n}\n\nfunction PersonFields() {\n return (\n <>\n \n \n Name \n \n \n Nickname \n \n \n Birthday \n \n \n Anniversary \n \n \n Relation \n \n \n Email \n \n \n Dates accurate\n \n \n );\n}\n\nfunction PersonRow({ person }: { person: Person }) {\n return (\n \n \n {person.name}\n {person.nickName\n ? (\n <>\n
\n {person.nickName}\n \n )\n : null}\n \n {person.birthdate ?? \"\"}\n {person.anniversary ?? \"\"}\n {person.relation}\n {person.email}\n {person.isAccurate ? \"yes\" : \"no\"}\n \n \n \n \n \n );\n}\n\nfunction doc(children: ComponentChildren): string {\n return \"\" + render(\n \n \n \n \n Reminders Admin\n

Diff · v23