[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_680":681,"_682":683},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_55":-7,"_280":-5,"_19":281,"_282":283,"_284":285,"_286":287,"_288":289,"_21":290,"_291":-5,"_292":-5,"_293":24,"_294":295,"_296":238,"_297":-5,"_298":-5,"_299":300},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","pikachu","name","Quickstart-Full-Stack","branchName","main","path","backend/db.ts","project",{"_49":224,"_13":14,"_53":225,"_226":-5,"_227":24,"_228":229,"_230":229,"_231":232,"_233":234,"_30":84,"_235":236,"_237":238,"_239":-5,"_240":-5,"_241":242,"_57":58,"_243":244,"_245":246,"_247":248,"_249":-5,"_250":251,"_252":251,"_253":254,"_255":254,"_256":254,"_257":251,"_258":251,"_68":259,"_260":261,"_262":263,"_264":24},"file",{"_78":79,"_13":80,"_81":82,"_83":24,"_223":-5},"isDirectory",false,"page",0,"history",[31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48],"hasNext","userId",{"_49":215,"_51":52,"_53":216,"_55":217,"_57":58,"_59":218,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":219,"_21":220,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":221},{"_49":207,"_51":52,"_53":208,"_55":209,"_57":58,"_59":210,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":211,"_21":212,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":213},{"_49":199,"_51":52,"_53":200,"_55":201,"_57":58,"_59":202,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":203,"_21":204,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":205},{"_49":191,"_51":52,"_53":192,"_55":193,"_57":58,"_59":194,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":195,"_21":196,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":197},{"_49":183,"_51":52,"_53":184,"_55":185,"_57":58,"_59":186,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":187,"_21":188,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":189},{"_49":175,"_51":52,"_53":176,"_55":177,"_57":58,"_59":178,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":179,"_21":180,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":181},{"_49":167,"_51":52,"_53":168,"_55":169,"_57":58,"_59":170,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":171,"_21":172,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":173},{"_49":159,"_51":52,"_53":160,"_55":161,"_57":58,"_59":162,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":163,"_21":164,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":165},{"_49":151,"_51":52,"_53":152,"_55":153,"_57":58,"_59":154,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":155,"_21":156,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":157},{"_49":143,"_51":52,"_53":144,"_55":145,"_57":58,"_59":146,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":147,"_21":148,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":149},{"_49":135,"_51":52,"_53":136,"_55":137,"_57":58,"_59":138,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":139,"_21":140,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":141},{"_49":127,"_51":52,"_53":128,"_55":129,"_57":58,"_59":130,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":131,"_21":132,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":133},{"_49":119,"_51":52,"_53":120,"_55":121,"_57":58,"_59":122,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":123,"_21":124,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":125},{"_49":111,"_51":52,"_53":112,"_55":113,"_57":58,"_59":114,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":115,"_21":116,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":117},{"_49":103,"_51":52,"_53":104,"_55":105,"_57":58,"_59":106,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":107,"_21":108,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":109},{"_49":95,"_51":52,"_53":96,"_55":97,"_57":58,"_59":98,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":99,"_21":100,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":101},{"_49":87,"_51":52,"_53":88,"_55":89,"_57":58,"_59":90,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":91,"_21":92,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":93},{"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_21":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76},"id","aad52126-48c5-11f1-bfb8-42b51c65c3df","branchId","5a0a7ac8-4895-11f1-80ec-42b51c65c3df","createdAt",["D",1778014923340],"version",8,"orgId","019df771-9af8-7238-99a4-541e39355038","parentId","aac24196-48c5-11f1-9920-42b51c65c3df","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},"pull","merge","revert","multiple","commits",[77],{"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_21":70,"_71":-5,"_72":-5,"_73":-5},"fileId","aad2cfa2-48c5-11f1-bfb8-42b51c65c3df","db.ts","fileType","script","deleted","173e7424-8658-428f-a3bc-ae4faeaabd1c","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/22c8ba37-42c8-4af4-8daf-8cdd2f5f1800/square512?exp=1789538399&sig=21cdba23f818845c8391e88088eb5ea9255dbc43e05efe79e25bd70ab9ddb43a","5a4ebd9e-491e-11f1-913b-42b51c65c3df",["D",1778053013706],12,"5a42b602-491e-11f1-9e87-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[94],{"_49":87,"_51":52,"_53":88,"_55":89,"_57":58,"_59":90,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":91,"_21":92,"_71":-5,"_72":-5,"_73":-5},"95171886-4923-11f1-9001-42b51c65c3df",["D",1778055259851],18,"950f1a5a-4923-11f1-978f-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[102],{"_49":95,"_51":52,"_53":96,"_55":97,"_57":58,"_59":98,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":99,"_21":100,"_71":-5,"_72":-5,"_73":-5},"eb23e5ce-4932-11f1-9ffc-42b51c65c3df",["D",1778061846711],20,"951d381a-4923-11f1-a0cc-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[110],{"_49":103,"_51":52,"_53":104,"_55":105,"_57":58,"_59":106,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":107,"_21":108,"_71":-5,"_72":-5,"_73":-5},"7b8d5972-4944-11f1-9847-42b51c65c3df",["D",1778069390420],24,"eb47d61e-4932-11f1-bf20-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[118],{"_49":111,"_51":52,"_53":112,"_55":113,"_57":58,"_59":114,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":115,"_21":116,"_71":-5,"_72":-5,"_73":-5},"dce52930-494d-11f1-9738-42b51c65c3df",["D",1778073418897],29,"dcd180b0-494d-11f1-9cb0-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[126],{"_49":119,"_51":52,"_53":120,"_55":121,"_57":58,"_59":122,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":123,"_21":124,"_71":-5,"_72":-5,"_73":-5},"86918eb2-4951-11f1-a16a-42b51c65c3df",["D",1778074992215],40,"86827ec2-4951-11f1-a193-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[134],{"_49":127,"_51":52,"_53":128,"_55":129,"_57":58,"_59":130,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":131,"_21":132,"_71":-5,"_72":-5,"_73":-5},"7c60f31a-496f-11f1-8274-42b51c65c3df",["D",1778087860187],51,"7c35b876-496f-11f1-8f5c-42b51c65c3df",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[142],{"_49":135,"_51":52,"_53":136,"_55":137,"_57":58,"_59":138,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":139,"_21":140,"_71":-5,"_72":-5,"_73":-5},"a91c5eb8-4b17-11f1-bff1-ee650bb23af1",["D",1778270041839],59,"a8fa37c0-4b17-11f1-9c61-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[150],{"_49":143,"_51":52,"_53":144,"_55":145,"_57":58,"_59":146,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":147,"_21":148,"_71":-5,"_72":-5,"_73":-5},"be409914-4c96-11f1-bddd-ee650bb23af1",["D",1778434574553],144,"be363294-4c96-11f1-bddd-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[158],{"_49":151,"_51":52,"_53":152,"_55":153,"_57":58,"_59":154,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":155,"_21":156,"_71":-5,"_72":-5,"_73":-5},"b80fc3b8-4cae-11f1-8df1-ee650bb23af1",["D",1778444872087],159,"b8095168-4cae-11f1-967f-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[166],{"_49":159,"_51":52,"_53":160,"_55":161,"_57":58,"_59":162,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":163,"_21":164,"_71":-5,"_72":-5,"_73":-5},"1b5e4150-4cb0-11f1-8ddf-ee650bb23af1",["D",1778445468186],174,"1b52aa8e-4cb0-11f1-a48e-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[174],{"_49":167,"_51":52,"_53":168,"_55":169,"_57":58,"_59":170,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":171,"_21":172,"_71":-5,"_72":-5,"_73":-5},"a20224b0-4cb0-11f1-aac1-ee650bb23af1",["D",1778445694098],185,"a1f91050-4cb0-11f1-9b5d-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[182],{"_49":175,"_51":52,"_53":176,"_55":177,"_57":58,"_59":178,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":179,"_21":180,"_71":-5,"_72":-5,"_73":-5},"7d53e0ec-4cb3-11f1-8771-ee650bb23af1",["D",1778446921043],214,"7d41c59c-4cb3-11f1-b66c-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[190],{"_49":183,"_51":52,"_53":184,"_55":185,"_57":58,"_59":186,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":187,"_21":188,"_71":-5,"_72":-5,"_73":-5},"d3f7b130-4d03-11f1-8887-ee650bb23af1",["D",1778481426096],217,"d3efcbbe-4d03-11f1-bd36-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[198],{"_49":191,"_51":52,"_53":192,"_55":193,"_57":58,"_59":194,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":195,"_21":196,"_71":-5,"_72":-5,"_73":-5},"085473a6-5023-11f1-830b-ee650bb23af1",["D",1778824681801],239,"084b6c20-5023-11f1-a5af-ee650bb23af1",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[206],{"_49":199,"_51":52,"_53":200,"_55":201,"_57":58,"_59":202,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":203,"_21":204,"_71":-5,"_72":-5,"_73":-5},"c97870a8-9670-4b25-8a38-ed499c479572",["D",1788104437757],254,"94290f0d-f27e-43ef-a81b-e8a5893b7607",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[214],{"_49":207,"_51":52,"_53":208,"_55":209,"_57":58,"_59":210,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":211,"_21":212,"_71":-5,"_72":-5,"_73":-5},"6daaae7b-275a-4a4d-9d2b-4e26f35cae39",["D",1788140102565],341,"21d7399d-f076-4545-9193-57f531373485",{"_49":84,"_57":58,"_11":12,"_85":86},{"_78":79,"_13":80,"_81":82,"_83":24},[222],{"_49":215,"_51":52,"_53":216,"_55":217,"_57":58,"_59":218,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":219,"_21":220,"_71":-5,"_72":-5,"_73":-5},"deletedAtVersion","5a09ae54-4895-11f1-80ec-42b51c65c3df",["D",1777994172310],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","An elegant template for an elegant single-person full stack app.","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3ed9401e-3850-4a69-dec2-1bdd924c0900/square512?exp=1789538399&sig=8ded5b974bfebef9817e2fbdffe4de4e1704e0d4cab9518c811db2594c0af107","pinnedFileId","e1c705aa-4b18-11f1-b4ae-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"tursoName","5a09ae54489511f180ec42b51c65c3df","tursoHostname","5a09ae54489511f180ec42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789511441255],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_279":86},"org",{"_11":12,"_274":275,"_85":86,"_30":84,"_276":277,"_278":24},"branch",{"_55":265,"_13":16,"_49":52,"_266":224,"_267":-5,"_268":-5,"_269":-5,"_270":-5,"_271":-5,"_272":14,"_273":12},"isOwned",384,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Minion","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_49":224,"_13":14,"_53":675,"_226":-5,"_227":24,"_228":229,"_230":229,"_231":232,"_233":234,"_30":84,"_235":236,"_237":238,"_239":-5,"_240":-5,"_241":242,"_57":58,"_243":244,"_245":246,"_247":676,"_249":-5,"_250":251,"_252":251,"_253":254,"_255":254,"_256":254,"_257":251,"_258":251,"_68":677,"_260":678,"_262":679,"_264":24},"tree",[321,329,351,354,355,356,357,358,359],"files",[321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359],"counts",{"_311":26,"_312":242,"_313":242,"_314":315,"_316":317},"contents",[],{"_49":301,"_51":52,"_78":79,"_13":80,"_302":303,"_81":82,"_55":304,"_59":305,"_53":306,"_307":217,"_308":-5,"_17":309},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"13e917a6-48a2-4036-8e6e-cc9fdd7d8442","content","// db.ts — SQLite helpers for this App's isolated database.\n// Each val (App) gets its own SQLite — no shared namespace with other vals.\n// Docs: https://docs.val.town/reference/std/sqlite/\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { DEMO_DATA_RETENTION_HOURS } from \"./shared.ts\";\n\n// ── Schema Migration ──────────────────────────────────────────────────────────\n// Lazily run on first DB call, not at import time. This prevents crashes\n// when running locally (off Val Town) where the SQLite API isn't available.\n\nlet migration: Promise | null = null;\n\n/** Share one migration across concurrent calls and reset it after failure. */\nasync function migrate(): Promise {\n migration ??= runMigration();\n await migration;\n}\n\nasync function runMigration(): Promise {\n return await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS visits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n path TEXT NOT NULL,\n ts TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS cron_runs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n task TEXT NOT NULL,\n note TEXT,\n ts TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS users (\n username TEXT PRIMARY KEY,\n email TEXT,\n first_login TEXT NOT NULL DEFAULT (datetime('now')),\n last_login TEXT NOT NULL DEFAULT (datetime('now')),\n is_admin INTEGER NOT NULL DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS reminders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n note TEXT,\n due_date TEXT,\n done INTEGER NOT NULL DEFAULT 0,\n created_by TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS inbound_emails (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_addr TEXT NOT NULL,\n subject TEXT,\n is_spam INTEGER NOT NULL DEFAULT 0,\n summary TEXT,\n received_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n ]).then(() => undefined).catch((error) => {\n migration = null;\n throw error;\n });\n}\n\n// ── Visits ────────────────────────────────────────────────────────────────────\n\n/** Record a page visit. */\nexport async function recordVisit(path: string): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO visits (path) VALUES (?)`,\n args: [path],\n });\n}\n\n/** Get total visit count. */\nexport async function getVisitCount(): Promise {\n await migrate();\n const { rows } = await sqlite.execute(\n `SELECT COUNT(*) as count FROM visits`,\n );\n // Row supports [key: number] indexing — no cast required.\n return Number(rows[0][0]);\n}\n\n/** Get the N most recent visits. */\nexport async function getRecentVisits(\n limit = 20,\n): Promise> {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, path, ts FROM visits ORDER BY ts DESC LIMIT ?`,\n args: [limit],\n });\n // Row is ArrayLike with [key: number]: Value — index directly, no cast.\n return rows.map((r) => ({\n id: Number(r[0]),\n path: String(r[1]),\n ts: String(r[2]),\n }));\n}\n\n/** Delete visits older than `days` days. Idempotent — safe to call repeatedly. */\nexport async function pruneOldVisits(days = 30): Promise {\n await migrate();\n const interval = `-${Math.floor(Math.abs(days))} days`;\n await sqlite.execute({\n sql: `DELETE FROM visits WHERE ts < datetime('now', ?)`,\n args: [interval],\n });\n}\n\n// ── Cron runs ─────────────────────────────────────────────────────────────────\n\n/** Append a cron run log entry. Called by cron.ts tasks. */\nexport async function logCronRun(task: string, note?: string): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO cron_runs (task, note) VALUES (?, ?)`,\n args: [task, note ?? null],\n });\n}\n\n/** Get the N most recent cron run entries across all tasks. */\nexport async function getCronRuns(\n limit = 30,\n): Promise<\n Array<{ id: number; task: string; note: string | null; ts: string }>\n> {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, task, note, ts FROM cron_runs ORDER BY ts DESC LIMIT ?`,\n args: [limit],\n });\n // Row is ArrayLike with [key: number]: Value — index directly, no cast.\n return rows.map((r) => ({\n id: Number(r[0]),\n task: String(r[1]),\n note: r[2] != null ? String(r[2]) : null,\n ts: String(r[3]),\n }));\n}\n\n// ── Users ─────────────────────────────────────────────────────────────────────\n\nexport interface UserRow {\n username: string;\n email: string | null;\n first_login: string;\n last_login: string;\n is_admin: boolean;\n}\n\n/** Upsert user on login — sets first_login on create, updates last_login always. */\nexport async function upsertUser(\n username: string,\n email?: string | null,\n): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO users (username, email)\n VALUES (?, ?)\n ON CONFLICT(username) DO UPDATE SET\n last_login = datetime('now'),\n email = COALESCE(excluded.email, users.email)`,\n args: [username, email ?? null],\n });\n}\n\n/** Get a single user by username. */\nexport async function getUser(username: string): Promise {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT username, email, first_login, last_login, is_admin FROM users WHERE username = ?`,\n args: [username],\n });\n if (!rows.length) return null;\n return rowToUser(rows[0]);\n}\n\n/** List all registered users (most recent login first). */\nexport async function listUsers(): Promise {\n await migrate();\n const { rows } = await sqlite.execute(\n `SELECT username, email, first_login, last_login, is_admin FROM users ORDER BY last_login DESC`,\n );\n return rows.map(rowToUser);\n}\n\n/** Set is_admin flag for a user. Only super-admins should call this. */\nexport async function setUserAdmin(\n username: string,\n isAdmin: boolean,\n): Promise {\n await migrate();\n const { rowsAffected } = await sqlite.execute({\n sql: `UPDATE users SET is_admin = ? WHERE username = ?`,\n args: [isAdmin ? 1 : 0, username],\n });\n return rowsAffected > 0;\n}\n\nfunction rowToUser(r: ArrayLike): UserRow {\n return {\n username: String(r[0]),\n email: r[1] != null ? String(r[1]) : null,\n first_login: String(r[2]),\n last_login: String(r[3]),\n is_admin: Number(r[4]) === 1,\n };\n}\n\n// ── Reminders — the flagship shared \"tiny app\" demo ───────────────────────────\n// Public read, sign-in-required write (see backend/auth.ts's getAuthedUc).\n// Demo data — filtered at read time AND physically pruned by cron.ts's pulse\n// so the \"wiped every 24 hours\" promise holds even between cron ticks.\n\nexport interface Reminder {\n id: number;\n title: string;\n note: string | null;\n dueDate: string | null;\n done: boolean;\n createdBy: string;\n createdAt: string;\n}\n\nexport async function createReminder(\n title: string,\n note: string | null,\n dueDate: string | null,\n createdBy: string,\n): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO reminders (title, note, due_date, created_by) VALUES (?, ?, ?, ?)`,\n args: [title, note, dueDate, createdBy],\n });\n}\n\n/** List reminders created within the retention window — oldest expired rows never surface. */\nexport async function listReminders(\n hours = DEMO_DATA_RETENTION_HOURS,\n): Promise {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, title, note, due_date, done, created_by, created_at\n FROM reminders\n WHERE created_at > datetime('now', ?)\n ORDER BY done ASC, (due_date IS NULL), due_date ASC, created_at DESC`,\n args: [`-${hours} hours`],\n });\n return rows.map(rowToReminder);\n}\n\nexport async function setReminderDone(id: number, done: boolean): Promise {\n await migrate();\n const { rowsAffected } = await sqlite.execute({\n sql: `UPDATE reminders SET done = ? WHERE id = ?`,\n args: [done ? 1 : 0, id],\n });\n return rowsAffected > 0;\n}\n\nexport async function deleteReminder(id: number): Promise {\n await migrate();\n const { rowsAffected } = await sqlite.execute({\n sql: `DELETE FROM reminders WHERE id = ?`,\n args: [id],\n });\n return rowsAffected > 0;\n}\n\n/** Physically delete reminders past the retention window. Idempotent. */\nexport async function pruneOldReminders(hours = DEMO_DATA_RETENTION_HOURS): Promise {\n await migrate();\n await sqlite.execute({\n sql: `DELETE FROM reminders WHERE created_at < datetime('now', ?)`,\n args: [`-${hours} hours`],\n });\n}\n\nfunction rowToReminder(r: ArrayLike): Reminder {\n return {\n id: Number(r[0]),\n title: String(r[1]),\n note: r[2] != null ? String(r[2]) : null,\n dueDate: r[3] != null ? String(r[3]) : null,\n done: Number(r[4]) === 1,\n createdBy: String(r[5]),\n createdAt: String(r[6]),\n };\n}\n\n// ── Inbound emails — the AI spam/summary triage demo ──────────────────────────\n// Public read-only. Written by email.ts's inbound handler. Same 24h demo-data\n// retention as Reminders.\n\nexport interface InboundEmail {\n id: number;\n from: string;\n subject: string;\n isSpam: boolean;\n summary: string | null;\n receivedAt: string;\n}\n\nexport async function recordInboundEmail(\n from: string,\n subject: string,\n isSpam: boolean,\n summary: string | null,\n): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO inbound_emails (from_addr, subject, is_spam, summary) VALUES (?, ?, ?, ?)`,\n args: [from, subject, isSpam ? 1 : 0, summary],\n });\n}\n\nexport async function listRecentEmails(\n hours = DEMO_DATA_RETENTION_HOURS,\n limit = 20,\n): Promise {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, from_addr, subject, is_spam, summary, received_at\n FROM inbound_emails\n WHERE received_at > datetime('now', ?)\n ORDER BY received_at DESC\n LIMIT ?`,\n args: [`-${hours} hours`, limit],\n });\n return rows.map(rowToInboundEmail);\n}\n\n/** Physically delete inbound emails past the retention window. Idempotent. */\nexport async function pruneOldEmails(hours = DEMO_DATA_RETENTION_HOURS): Promise {\n await migrate();\n await sqlite.execute({\n sql: `DELETE FROM inbound_emails WHERE received_at < datetime('now', ?)`,\n args: [`-${hours} hours`],\n });\n}\n\nfunction rowToInboundEmail(r: ArrayLike): InboundEmail {\n return {\n id: Number(r[0]),\n from: String(r[1]),\n subject: String(r[2]),\n isSpam: Number(r[3]) === 1,\n summary: r[4] != null ? String(r[4]) : null,\n receivedAt: String(r[5]),\n };\n}\n",17,"8630361c-4951-11f1-a193-42b51c65c3df",["D",1788140102565],"branchVersion","label",[310,80],"backend","pulls","branches","forks","envVars",{"_318":242,"_320":26},"connections",{"_318":26,"_319":26},"count","unfilledCount","emptyCount",{"_49":670,"_13":310,"_78":305,"_59":-5,"_51":52,"_307":671,"_364":238,"_53":672,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":673,"_17":674},{"_49":662,"_13":663,"_78":664,"_59":305,"_51":52,"_307":665,"_364":238,"_53":666,"_55":26,"_81":82,"_302":667,"_83":24,"_308":-5,"_368":668,"_17":669},{"_49":654,"_13":655,"_78":656,"_59":305,"_51":52,"_307":657,"_364":238,"_53":658,"_55":396,"_81":82,"_302":659,"_83":24,"_308":-5,"_368":660,"_17":661},{"_49":646,"_13":647,"_78":648,"_59":305,"_51":52,"_307":649,"_364":238,"_53":650,"_55":396,"_81":82,"_302":651,"_83":24,"_308":-5,"_368":652,"_17":653},{"_49":301,"_13":80,"_78":79,"_59":305,"_51":52,"_307":217,"_364":238,"_53":643,"_55":304,"_81":82,"_302":303,"_83":24,"_308":-5,"_368":644,"_17":645},{"_49":635,"_13":636,"_78":637,"_59":305,"_51":52,"_307":638,"_364":238,"_53":639,"_55":502,"_81":82,"_302":640,"_83":24,"_308":-5,"_368":641,"_17":642},{"_49":626,"_13":627,"_78":628,"_59":305,"_51":52,"_307":629,"_364":238,"_53":630,"_55":631,"_81":82,"_302":632,"_83":24,"_308":-5,"_368":633,"_17":634},{"_49":618,"_13":619,"_78":620,"_59":305,"_51":52,"_307":621,"_364":238,"_53":622,"_55":386,"_81":82,"_302":623,"_83":24,"_308":-5,"_368":624,"_17":625},{"_49":613,"_13":450,"_78":444,"_59":-5,"_51":52,"_307":614,"_364":238,"_53":615,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":616,"_17":617},{"_49":608,"_13":591,"_78":585,"_59":444,"_51":52,"_307":609,"_364":238,"_53":610,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":611,"_17":612},{"_49":600,"_13":601,"_78":602,"_59":585,"_51":52,"_307":603,"_364":238,"_53":604,"_55":473,"_81":82,"_302":605,"_83":24,"_308":-5,"_368":606,"_17":607},{"_49":592,"_13":593,"_78":594,"_59":585,"_51":52,"_307":595,"_364":238,"_53":596,"_55":568,"_81":82,"_302":597,"_83":24,"_308":-5,"_368":598,"_17":599},{"_49":582,"_13":583,"_78":584,"_59":585,"_51":52,"_307":586,"_364":238,"_53":587,"_55":26,"_81":82,"_302":588,"_83":24,"_308":-5,"_368":589,"_17":590},{"_49":577,"_13":477,"_78":470,"_59":444,"_51":52,"_307":578,"_364":238,"_53":579,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":580,"_17":581},{"_49":572,"_13":546,"_78":539,"_59":470,"_51":52,"_307":573,"_364":238,"_53":574,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":575,"_17":576},{"_49":563,"_13":564,"_78":565,"_59":539,"_51":52,"_307":566,"_364":238,"_53":567,"_55":568,"_81":82,"_302":569,"_83":24,"_308":-5,"_368":570,"_17":571},{"_49":555,"_13":556,"_78":557,"_59":539,"_51":52,"_307":558,"_364":238,"_53":559,"_55":492,"_81":82,"_302":560,"_83":24,"_308":-5,"_368":561,"_17":562},{"_49":547,"_13":548,"_78":549,"_59":539,"_51":52,"_307":550,"_364":238,"_53":551,"_55":542,"_81":82,"_302":552,"_83":24,"_308":-5,"_368":553,"_17":554},{"_49":536,"_13":537,"_78":538,"_59":539,"_51":52,"_307":540,"_364":238,"_53":541,"_55":542,"_81":82,"_302":543,"_83":24,"_308":-5,"_368":544,"_17":545},{"_49":531,"_13":496,"_78":489,"_59":470,"_51":52,"_307":532,"_364":238,"_53":533,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":534,"_17":535},{"_49":523,"_13":524,"_78":525,"_59":489,"_51":52,"_307":526,"_364":238,"_53":527,"_55":502,"_81":82,"_302":528,"_83":24,"_308":-5,"_368":529,"_17":530},{"_49":514,"_13":515,"_78":516,"_59":489,"_51":52,"_307":517,"_364":238,"_53":518,"_55":519,"_81":82,"_302":520,"_83":24,"_308":-5,"_368":521,"_17":522},{"_49":506,"_13":507,"_78":508,"_59":489,"_51":52,"_307":509,"_364":238,"_53":510,"_55":386,"_81":82,"_302":511,"_83":24,"_308":-5,"_368":512,"_17":513},{"_49":497,"_13":498,"_78":499,"_59":489,"_51":52,"_307":500,"_364":238,"_53":501,"_55":502,"_81":82,"_302":503,"_83":24,"_308":-5,"_368":504,"_17":505},{"_49":486,"_13":487,"_78":488,"_59":489,"_51":52,"_307":490,"_364":238,"_53":491,"_55":492,"_81":82,"_302":493,"_83":24,"_308":-5,"_368":494,"_17":495},{"_49":478,"_13":479,"_78":480,"_59":470,"_51":52,"_307":265,"_364":238,"_53":481,"_55":482,"_81":82,"_302":483,"_83":24,"_308":-5,"_368":484,"_17":485},{"_49":467,"_13":468,"_78":469,"_59":470,"_51":52,"_307":471,"_364":238,"_53":472,"_55":473,"_81":82,"_302":474,"_83":24,"_308":-5,"_368":475,"_17":476},{"_49":459,"_13":460,"_78":461,"_59":444,"_51":52,"_307":462,"_364":238,"_53":463,"_55":97,"_81":82,"_302":464,"_83":24,"_308":-5,"_368":465,"_17":466},{"_49":451,"_13":452,"_78":453,"_59":444,"_51":52,"_307":454,"_364":238,"_53":455,"_55":89,"_81":82,"_302":456,"_83":24,"_308":-5,"_368":457,"_17":458},{"_49":441,"_13":442,"_78":443,"_59":444,"_51":52,"_307":445,"_364":238,"_53":446,"_55":242,"_81":82,"_302":447,"_83":24,"_308":-5,"_368":448,"_17":449},{"_49":435,"_13":426,"_78":420,"_59":-5,"_51":52,"_307":436,"_364":238,"_53":437,"_55":26,"_81":438,"_302":-5,"_83":24,"_308":-5,"_368":439,"_17":440},{"_49":427,"_13":428,"_78":429,"_59":420,"_51":52,"_307":430,"_364":238,"_53":431,"_55":26,"_81":82,"_302":432,"_83":24,"_308":-5,"_368":433,"_17":434},{"_49":417,"_13":418,"_78":419,"_59":420,"_51":52,"_307":421,"_364":238,"_53":422,"_55":26,"_81":82,"_302":423,"_83":24,"_308":-5,"_368":424,"_17":425},{"_49":409,"_13":410,"_78":411,"_59":-5,"_51":52,"_307":412,"_364":238,"_53":413,"_55":89,"_81":21,"_302":414,"_83":24,"_308":-5,"_368":415,"_17":416},{"_49":400,"_13":401,"_78":402,"_59":-5,"_51":52,"_307":403,"_364":238,"_53":404,"_55":366,"_81":405,"_302":406,"_83":24,"_308":-5,"_368":407,"_17":408},{"_49":391,"_13":392,"_78":393,"_59":-5,"_51":52,"_307":394,"_364":238,"_53":395,"_55":396,"_81":21,"_302":397,"_83":24,"_308":-5,"_368":398,"_17":399},{"_49":381,"_13":382,"_78":383,"_59":-5,"_51":52,"_307":384,"_364":238,"_53":385,"_55":386,"_81":387,"_302":388,"_83":24,"_308":-5,"_368":389,"_17":390},{"_49":371,"_13":372,"_78":236,"_59":-5,"_51":52,"_307":373,"_364":238,"_53":374,"_55":375,"_81":376,"_302":377,"_83":24,"_308":378,"_368":379,"_17":380},{"_49":360,"_13":361,"_78":362,"_59":-5,"_51":52,"_307":363,"_364":238,"_53":365,"_55":366,"_81":21,"_302":367,"_83":24,"_308":-5,"_368":369,"_17":370},"490a09b0-2a98-4fc5-a448-02058c3a5820","val.yml","aa729402-48c5-11f1-87ca-42b51c65c3df",337,"latest",["D",1788140101761],10,"name: \"Val-Town-Quickstart\"\npublic: true\n# Each file here is a service. Services share one isolated SQLite DB.\n# index.http.ts → HTTP service (SPA + API routes)\n# cron.ts → Cron service (scheduled tasks)\n# email.ts → Email service (inbound trigger + outbound helpers)\nfiles:\n index.http.ts: http\n cron.ts: interval\n email.ts: email\n# Env vars this App reads. Set them in the Val Town UI sidebar — never in code.\n# required: App will not work without it | optional: has a safe default\nenv:\n APP_NAME: optional # display/logging name (vtx new sets the code fallback)\n VAL_TOWN_USERNAME: optional # your Val Town username — powers \"view source\"/Fork links (see README)\n DAILY_HOUR_UTC: optional # 0-23 UTC hour for the daily cron task (default: \"2\")\n AUTH_SUPER_ADMINS: optional # comma-separated Val Town usernames — these users are super-admins\n","children",[],[361],"bb0a8ae5-55f3-45b9-86b6-c6e1c53666b6","index.http.ts",367,["D",1788210559007],19,"http","// index.http.ts — HTTP entry point: per-route SSR page serving + API route\n// table. Handlers live in backend/handlers.ts; this file is pure wiring.\n// Docs: https://docs.val.town/vals/http\n\nimport { recordVisit } from \"./backend/db.ts\";\nimport { type ApiRoute, jsonError, route } from \"./backend/api-utils.ts\";\nimport {\n getAdminUc,\n getAuthedUc,\n getSuperAdminUc,\n getUc,\n getUcWithTracking,\n isAuthError,\n type UserCxt,\n withValTownAuth,\n} from \"./backend/auth.ts\";\nimport {\n adminListUsers,\n adminSetAdmin,\n blobKeys,\n blobRead,\n blobWrite,\n cronRuns,\n emailsList,\n healthCheck,\n me,\n pruneVisits,\n remindersCreate,\n remindersDelete,\n remindersList,\n remindersSetDone,\n visits,\n} from \"./backend/handlers.ts\";\nimport { APP_NAME, VAL_TOWN_USERNAME } from \"./backend/shared.ts\";\nimport { renderApp } from \"./frontend/app.tsx\";\nimport type { ThemeMode, UserInfo } from \"./frontend/types.ts\";\n\n// Valid page slugs — anything else falls back to \"home\".\n// Keep in sync with PAGES in frontend/app.tsx.\nconst PAGES = new Set([\n \"home\",\n \"reminders\",\n \"docs\",\n \"http\",\n \"sqlite\",\n \"cron\",\n \"email\",\n \"blob\",\n \"admin\",\n \"ui\",\n]);\nconst MODES = new Set([\"light\", \"dark\", \"system\"]);\nconst THEME_COOKIE = \"theme\";\n\n// -----------------------------------------------------------------------------\n// entry\n// -----------------------------------------------------------------------------\n\nasync function handler(req: Request): Promise {\n const url = new URL(req.url);\n if (url.pathname.startsWith(\"/api/\")) return await routeApi(req, url);\n if (url.pathname === \"/theme\") return setThemeAndRedirect(url);\n return await servePage(req, url);\n}\n\nexport default withValTownAuth(handler);\n\n// -----------------------------------------------------------------------------\n// page rendering\n// -----------------------------------------------------------------------------\n\nasync function servePage(req: Request, url: URL): Promise {\n try {\n await recordVisit(url.pathname);\n } catch { /* off-platform */ }\n\n const uc = await getUcWithTracking(req);\n const html = renderApp({\n appName: APP_NAME,\n renderedAt: new Date().toISOString(),\n mode: cookieMode(req),\n page: pathToPage(url.pathname),\n user: ucToUserInfo(uc),\n valTownUsername: VAL_TOWN_USERNAME,\n });\n return new Response(html, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\n/** GET /theme?mode=light|dark|system&page= — sets the mode cookie, redirects back. */\nfunction setThemeAndRedirect(url: URL): Response {\n const mode = url.searchParams.get(\"mode\");\n const page = pathToPage(`/${url.searchParams.get(\"page\") ?? \"\"}`);\n const headers = new Headers({ location: page === \"home\" ? \"/\" : `/${page}` });\n if (mode && (MODES as Set).has(mode)) {\n headers.append(\"set-cookie\", `${THEME_COOKIE}=${mode}; Path=/; Max-Age=31536000; SameSite=Lax`);\n }\n return new Response(null, { status: 303, headers });\n}\n\n/** Map backend UserCxt → frontend UserInfo (layer boundary). */\nfunction ucToUserInfo(uc: UserCxt): UserInfo | null {\n if (!uc.user) return null;\n return {\n username: uc.user.username,\n avatarUrl: uc.user.avatarUrl,\n isAdmin: uc.isAdmin,\n isSuperAdmin: uc.isSuperAdmin,\n };\n}\n\nfunction cookieMode(req: Request): ThemeMode {\n const cookie = req.headers.get(\"Cookie\") ?? \"\";\n const m = cookie.match(new RegExp(`(?:^|;\\\\s*)${THEME_COOKIE}=([^;]+)`));\n const value = m ? decodeURIComponent(m[1]) : \"\";\n return (MODES as Set).has(value) ? (value as ThemeMode) : \"system\";\n}\n\nfunction pathToPage(pathname: string): string {\n const seg = pathname.slice(1);\n return PAGES.has(seg) ? seg : \"home\";\n}\n\n// -----------------------------------------------------------------------------\n// API routing\n// -----------------------------------------------------------------------------\n\nconst API_ROUTES = new Map([\n [\"GET /api/health\", route(getUc, healthCheck)],\n [\"GET /api/me\", route(getUcWithTracking, me)],\n [\"GET /api/visits\", route(getUc, visits)],\n [\"POST /api/prune-visits\", route(getAdminUc, pruneVisits)],\n [\"GET /api/cron-runs\", route(getUc, cronRuns)],\n [\"GET /api/reminders\", route(getUc, remindersList)],\n [\"POST /api/reminders\", route(getAuthedUc, remindersCreate)],\n [\"POST /api/reminders/done\", route(getAuthedUc, remindersSetDone)],\n [\"POST /api/reminders/delete\", route(getAuthedUc, remindersDelete)],\n [\"GET /api/emails\", route(getUc, emailsList)],\n [\"GET /api/blob-keys\", route(getAuthedUc, blobKeys)],\n [\"POST /api/blob-write\", route(getAuthedUc, blobWrite)],\n [\"GET /api/blob-read\", route(getAuthedUc, blobRead)],\n [\"GET /api/admin/users\", route(getSuperAdminUc, adminListUsers)],\n [\"POST /api/admin/set-admin\", route(getSuperAdminUc, adminSetAdmin)],\n]);\n\nasync function routeApi(req: Request, url: URL): Promise {\n const apiRoute = API_ROUTES.get(`${req.method} ${url.pathname}`);\n if (!apiRoute) return jsonError(`Not found: ${url.pathname}`, 404);\n\n try {\n const uc = await apiRoute.resolveUc(req);\n return await apiRoute.handle({ req, url, uc });\n } catch (error) {\n if (isAuthError(error)) return jsonError(error.message, error.status);\n throw error;\n }\n}\n","d-template",[],[372],"6da22813-bc26-432e-8840-2d89796753cd","email.ts","aa7742d6-48c5-11f1-831b-42b51c65c3df",339,["D",1788140102069],11,"email","// email.ts — Email service: inbound handler + outbound helpers.\n// Address shape: .@valtown.email\n\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\nimport { APP_NAME, type Email } from \"./backend/shared.ts\";\nimport { triageEmail } from \"./backend/ai.ts\";\nimport { recordInboundEmail } from \"./backend/db.ts\";\n\n// -----------------------------------------------------------------------------\n// inbound\n// -----------------------------------------------------------------------------\n\nexport default async function emailHandler(inbound: Email): Promise {\n console.log(\n `📧 [${APP_NAME}] From: ${inbound.from} Subject: ${inbound.subject ?? \"(none)\"}`,\n );\n console.log(` Body: ${inbound.text?.slice(0, 200) ?? \"(empty)\"}...`);\n\n for (const file of inbound.attachments) {\n console.log(` 📎 ${file.name} (${file.type}, ${file.size}b)`);\n // await blob.set(`emails/${file.name}`, await file.arrayBuffer());\n }\n\n // AI triage feeds the live \"Email Inbox\" demo (frontend/pages/page-mail.tsx) —\n // best-effort: a triage/DB hiccup should never fail the inbound trigger.\n try {\n const subject = inbound.subject ?? \"\";\n const { isSpam, summary } = await triageEmail(subject, inbound.text ?? \"\");\n await recordInboundEmail(inbound.from, subject, isSpam, summary);\n } catch (error) {\n console.error(` ⚠️ triage/record failed: ${error}`);\n }\n\n // await sendNotification(`Re: ${inbound.subject}`, \"Got your message!\");\n}\n\n// -----------------------------------------------------------------------------\n// outbound\n// -----------------------------------------------------------------------------\n// Free plan: sends to yourself only. Pro: send to anyone + cc/bcc.\n\nexport async function sendNotification(\n subject: string,\n body: string,\n options?: { to?: string; html?: string },\n): Promise {\n await sendEmail({\n subject,\n text: body,\n ...(options?.to && { to: options.to }),\n ...(options?.html && { html: options.html }),\n });\n console.log(`📤 [${APP_NAME}] Sent: \"${subject}\"`);\n}\n\n/** `attachment.content` must be base64-encoded (use `btoa()`). */\nexport async function sendWithAttachment(\n subject: string,\n body: string,\n attachment: { content: string; filename: string; type?: string },\n): Promise {\n await sendEmail({\n subject,\n text: body,\n attachments: [{\n content: attachment.content,\n filename: attachment.filename,\n type: attachment.type ?? \"application/octet-stream\",\n disposition: \"attachment\",\n }],\n });\n console.log(\n `📤 [${APP_NAME}] Sent with attachment: \"${attachment.filename}\"`,\n );\n}\n",[],[382],"e9ede3b4-4f02-11f1-8b31-ee650bb23af1","deno.json","86adc21c-4951-11f1-b797-42b51c65c3df",225,["D",1778700935796],3,"{\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 \"fmt\": {\n \"lineWidth\": 100\n },\n \"lint\": {\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\",\n \"no-external-import\",\n \"no-import-prefix\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"unstable\": [\"temporal\", \"worker-options\", \"sloppy-imports\", \"node-globals\"]\n}\n",[],[392],"0a74464d-228b-4071-9a89-a17e86f0c8ff","cron.ts","aa651980-48c5-11f1-bfb8-42b51c65c3df",344,["D",1788140103018],"interval","// cron.ts — Cron service: pulse (every run) + daily (UTC-hour window).\n// Schedule is set in the Val Town UI via a cron expression. Free tier: ≥ 15 min.\n// Tasks are intentionally idempotent. Val Town fires each tick once; concurrent\n// cold-starts are rare but possible on Pro — design tasks to tolerate it.\n\nimport { APP_NAME, DEMO_DATA_RETENTION_HOURS, env } from \"./backend/shared.ts\";\nimport { logCronRun, pruneOldEmails, pruneOldReminders, pruneOldVisits } from \"./backend/db.ts\";\n\nexport default async function (\n interval: { lastRunAt: Date | undefined },\n): Promise {\n const now = new Date();\n await pulse(now);\n await daily(now, interval.lastRunAt);\n}\n\n// ── Pulse — runs on every cron tick ───────────────────────────────────────────\n// Good for health-checks, polling an external feed, draining a work queue.\n// Set the Val Town cron to your desired cadence (UI → val → Cron → expression).\n\nasync function pulse(now: Date): Promise {\n console.log(`⚡ [${APP_NAME}] pulse ${now.toISOString()}`);\n await logCronRun(\"pulse\", `hello at ${now.toISOString()}`);\n // Demo data (Reminders, Email inbox) is wiped on a rolling window — see\n // backend/shared.ts's DEMO_DATA_RETENTION_HOURS and the README's demo notice.\n await pruneOldReminders(DEMO_DATA_RETENTION_HOURS);\n await pruneOldEmails(DEMO_DATA_RETENTION_HOURS);\n // TODO: replace with your own high-frequency task\n // await fetch(\"https://api.example.com/feed\");\n}\n\n// ── Daily — runs once per day in a UTC-hour window ────────────────────────────\n// Uses Val Town's lastRunAt to run only on the first tick inside the target hour.\n// Env: DAILY_HOUR_UTC — which UTC hour to run (0-23, default \"2\").\n\nasync function daily(now: Date, lastRunAt: Date | undefined): Promise {\n const targetHour = Number(env(\"DAILY_HOUR_UTC\", \"2\"));\n if (!shouldRunDaily(now, lastRunAt, targetHour)) return;\n\n console.log(`🔧 [${APP_NAME}] daily ${now.toISOString()}`);\n await pruneOldVisits(30);\n await logCronRun(\"daily\", `pruned visits older than 30 days`);\n console.log(`✅ [${APP_NAME}] daily done`);\n}\n\nfunction shouldRunDaily(\n now: Date,\n lastRunAt: Date | undefined,\n targetHour: number,\n): boolean {\n if (now.getUTCHours() !== targetHour) return false;\n const target = new Date(Date.UTC(\n now.getUTCFullYear(),\n now.getUTCMonth(),\n now.getUTCDate(),\n targetHour,\n ));\n return !lastRunAt || lastRunAt < target;\n}\n",[],[401],"3d8b63af-625e-401b-a675-b02284a05ddf","README.md","aabf7b64-48c5-11f1-9920-42b51c65c3df",347,["D",1788140102864],"# Val Town Quickstart\n\nA live, forkable full-stack Val Town starter — disguised as a working app. Sign in, add a reminder\nto the shared list, email its inbox and watch AI triage it as spam or not. Then fork it and swap in\nyour own idea. Sized for a solo project or a family's shared tools (<10 people), not an enterprise\nplatform.\n\n**Try it live, then fork:** open this App, click **Fork this App** on the home page. `vtx new` (see\nbelow) is for the CLI-first workflow inside this monorepo; forking on val.town works standalone too.\n\nAll demo data (the shared Reminders list, the AI email inbox) is public and is **permanently deleted\n24 hours after creation** — see `backend/db.ts`'s `pruneOld*` functions and `cron.ts`. Don't put\nanything sensitive in it.\n\nThe UI is built on [Astryx](https://astryx.atmeta.com), Meta's open-source React + StyleX design\nsystem. See [`_specs/astryx-template.md`](../../_specs/astryx-template.md) for the migration\nhistory, version pins, and the Deno SSR workarounds.\n\n`_template` is excluded from main-branch deployment because its directory starts with `_`.\n\nSince every Val Town HTTP val is browsable source, the deployed copy of this App is readable at\n`https://www.val.town/x///code/` — e.g.\n`https://www.val.town/x/pikachu/Val-Town-Quickstart/code/backend/auth.ts`. In-app \"view source\" and\n\"Fork\" links use this same pattern (see `VAL_TOWN_USERNAME` below).\n\n---\n\n## What it demos\n\n| Page | What you'll see |\n| ------------ | -------------------------------------------------------------------------------------------------------- |\n| `/` (Home) | Demo-first landing: fork CTA, live-demo cards, then the building blocks |\n| `/reminders` | **Flagship demo.** Shared list any signed-in user can add to / check off / delete |\n| `/email` | **AI demo.** Your App's real inbound address; a free GPT-mini model triages spam and summarises the rest |\n| `/anatomy` | Block diagram of Val Town's infra layer, this App's routing, and its core stack |\n| `/http` | HTTP routes and live request demos |\n| `/sqlite` | Visit log and admin controls |\n| `/cron` | Scheduled task history — this is what wipes demo data every 24h |\n| `/blob` | Sign-in-gated Blob read/write/list demo, keys namespaced per user |\n| `/ui` | Astryx theming explainer + component showcase |\n\n## Create Your Own Fork\n\n**On val.town:** open the deployed App → **Fork this App** on the home page → rename → done.\n\n**Inside this monorepo**, from any directory after sourcing the uApps shell plugin:\n\n```bash\nvtx new my-app\ncd vals/my-app\nvtx status\nvtx push --dry-run\nvtx push\nvtx url\n```\n\n`vtx new` copies the template, replaces the application name and account-scoped Blob prefix, writes\nthe new `val.yml` name, and links the new remote val. Existing destinations are refused.\n\n## Application Shape\n\nThe HTTP entry wraps the app in Val Town OAuth, routes `/api/*` through typed auth boundaries, and\nrenders the selected SSR page for every other path.\n\nAPI routes:\n\n| Method | Path | Access |\n| ------ | ----------------------- | ---------------------- |\n| `GET` | `/api/health` | Public |\n| `GET` | `/api/me` | Public session context |\n| `GET` | `/api/visits` | Public |\n| `POST` | `/api/prune-visits` | Admin |\n| `GET` | `/api/cron-runs` | Public |\n| `GET` | `/api/reminders` | Public read |\n| `POST` | `/api/reminders` | Signed-in |\n| `POST` | `/api/reminders/done` | Signed-in |\n| `POST` | `/api/reminders/delete` | Signed-in |\n| `GET` | `/api/emails` | Public read |\n| `GET` | `/api/blob-keys` | Signed-in, per-user |\n| `POST` | `/api/blob-write` | Signed-in, per-user |\n| `GET` | `/api/blob-read` | Signed-in, per-user |\n| `GET` | `/api/admin/users` | Super-admin |\n| `POST` | `/api/admin/set-admin` | Super-admin |\n\n\"Signed-in\" means any authenticated Val Town user — see `backend/auth.ts`'s `getAuthedUc` — not just\nadmins. This App is deliberately open: it's a shared demo, not a private tool.\n\n## Runtime Configuration\n\nSet these in the created val's Val Town environment UI, never in Git or GitHub Actions:\n\n| Variable | Kind | Purpose |\n| ------------------- | -------- | -------------------------------------------------------------------------------------- |\n| `APP_NAME` | Optional | Display name override |\n| `VAL_TOWN_USERNAME` | Optional | Your Val Town username — powers \"view source\"/Fork links and the inbound email address |\n| `DAILY_HOUR_UTC` | Optional | Daily task hour, `0`–`23` UTC |\n| `AUTH_SUPER_ADMINS` | Optional | Comma-separated Val Town usernames |\n\nNo API key is needed for the AI email triage — `backend/ai.ts` uses Val Town's free-tier\n`ValTownOpenAI` proxy.\n\nThe repository-level `VAL_TOWN_API_KEY` secret is only for CI deployment. See the root\n[`README.md`](../../README.md#cicd).\n\n## Trigger Contract\n\n`val.yml.files` declares the intended remote types:\n\n```yaml\nfiles:\n index.http.ts: http\n cron.ts: interval\n email.ts: email\n```\n\nRun `vtx types` after linking. Use `vtx apply-types` only when deliberately repairing remote trigger\nmetadata.\n\n## Architecture\n\n- `index.http.ts` — HTTP composition root: per-route SSR page serving, `GET /theme` (zero-JS mode\n switch), and the API route table.\n- `backend/auth.ts` — OAuth context and role enforcement (`getUc`/`getAuthedUc`/`getAdminUc`/\n `getSuperAdminUc`). Auth types use `Cxt` (e.g. `UserCxt`, `RouteCxt`) — the more common short form\n for \"context\" — not `Ctx`.\n- `backend/handlers.ts` — focused API handlers, including Reminders CRUD and the email inbox list.\n- `backend/db.ts` — retryable migration, visits, Cron runs, users, Reminders, and the inbound email\n log — the latter two carry a 24h retention window baked into every query.\n- `backend/ai.ts` — spam/summary triage via Val Town's free `ValTownOpenAI` proxy, using Structured\n Outputs so the response is guaranteed valid JSON.\n- `backend/storage.ts` — val-namespaced account Blob access, with per-user key sub-prefixing.\n- `frontend/app.tsx` — React SSR composition root; dispatches one page per request via a `PAGES` map\n (no client-side router — navigation is real ``).\n- `frontend/astryx/` — pinned Astryx component barrel (`components.ts`), the RAF/CAF SSR shim\n (`ssr-shims.ts`), and the side-nav/theme-form shell (`shell.tsx`).\n- `frontend/pages/` — one file per route, composed from Astryx components. `home.tsx` leads with the\n live demos and a Fork CTA; `page-anatomy.tsx` is the code deep-dive for visitors who want it.\n- `frontend/pages/kit.tsx` — shared page pieces: `SourceLink`/`SourceLinkList` (\"view source\") and\n `ForkButton` — both degrade gracefully when `VAL_TOWN_USERNAME` is unset.\n- `frontend/client.ts` — non-hydrated demo API wiring only (no router, no theme JS — both are\n server-driven). Dynamic table rows (Reminders, the email inbox) are cloned from a hidden, real\n Astryx-rendered `

History · db.ts