[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_503":504,"_505":506},"routes/_app.x.$handle.$name",{"_103":102,"_33":47,"_112":93,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":-5,"_125":-5,"_126":25,"_127":128,"_129":62,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_45":46,"_33":47,"_40":48,"_49":-5,"_50":25,"_51":52,"_53":52,"_54":55,"_56":57,"_18":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":25},"version",333,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":30},"file",{"_31":32,"_33":34,"_35":36,"_37":39,"_40":41,"_42":14,"_43":44,"_24":25},"previous",{"_31":32,"_33":34,"_35":36,"_37":38},"deleted",false,"deletedHere","path","frontend/pages/page-sqlite.tsx","latestPath","frontend/pages/docs/page-sqlite.tsx","fileId","094c700a-4c96-11f1-a693-ee650bb23af1","name","page-sqlite.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@19.2.0 */\n// page-sqlite.tsx — SQLite: live visit table + interactive demos.\n\nimport {\n Badge,\n Banner,\n Button,\n CodeBlock,\n Heading,\n HStack,\n Link,\n Section,\n Table,\n TableBody,\n TableCell,\n TableHeader,\n TableHeaderCell,\n TableRow,\n Text,\n VStack,\n} from \"../astryx/components.ts\";\nimport { PageLinks } from \"./kit.tsx\";\nimport type { AppProps, CodeSnippet } from \"../types.ts\";\n\nconst LINKS = [\n { href: \"https://docs.val.town/reference/std/sqlite/\", label: \"SQLite docs\" },\n { href: \"https://www.val.town/pricing\", label: \"Pricing\" },\n { href: \"https://www.val.town/limits\", label: \"Limits\" },\n];\n\nconst MIGRATE_SNIPPET: CodeSnippet = {\n filename: \"backend/db.ts — migrate()\",\n code: `// Each App gets its own isolated SQLite — no prefix needed.\nlet migrated = false;\n\nasync function migrate(): Promise {\n if (migrated) return; // run once per cold-start\n migrated = true;\n 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 ]);\n}`,\n};\n\nconst QUERY_SNIPPET: CodeSnippet = {\n filename: \"backend/db.ts — queries\",\n code: `export 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\nexport async function getRecentVisits(limit = 20) {\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 return rows.map(r => ({ id: r[0], path: r[1], ts: r[2] }));\n}`,\n};\n\nconst CONCEPT_ROWS: { concept: string; example: string; note: string }[] = [\n { concept: \"App\", example: \"sample-val\", note: \"One App = one isolated SQLite DB\" },\n {\n concept: \"Service\",\n example: \"index.http.ts, cron.ts, email.ts\",\n note: \"All services share the App's single DB\",\n },\n {\n concept: \"No prefix needed\",\n example: \"visits, cron_runs\",\n note: \"DB is isolated — plain table names are fine\",\n },\n];\n\nconst RULE_ROWS: { rule: string; reason: string }[] = [\n {\n rule: \"Lazy migrate\",\n reason: \"Run schema in first call, not at import — avoids errors off-platform\",\n },\n { rule: \"Parameterised\", reason: \"Always use args: [...] — never interpolate into SQL strings\" },\n {\n rule: \"Schema versioning\",\n reason: \"Rename tables (_v2) when changing columns — no ALTER needed\",\n },\n {\n rule: \"Blob ≠ SQLite\",\n reason: \"Blob is account-scoped (all your Apps share it) — SQLite is App-scoped\",\n },\n];\n\nexport function SqlitePage({ user }: AppProps) {\n return (\n \n \n SQLite\n \n Each App gets its own isolated SQLite database, shared by all its services (HTTP, Cron,\n Email). 10 MB free / 1 GB Pro, backed by Turso. No connection string — import the client\n and query.\n \n \n \n\n \n Admin session\n

\n \n \n Pruning is an admin action. Sign in with Val Town and set{\" \"}\n AUTH_ADMIN_USERS to your Val Town username.\n \n \n {user\n ? (\n

\n \n\n \n Visit log — live from SQLite\n

\n \n \n

\n \n\n \n App → service → SQLite\n \n \n \n Concept\n Example\n Note\n \n \n \n {CONCEPT_ROWS.map((r) => (\n \n \n \n \n \n {r.example}\n \n {r.note}\n \n ))}\n \n

\n \n\n \n Rules\n \n \n \n Rule\n Reason\n \n \n \n {RULE_ROWS.map((r) => (\n \n \n \n \n {r.reason}\n \n ))}\n \n

\n \n\n \n \n \n \n );\n}\n","/** @jsxImportSource https://esm.sh/react@19.2.0 */\n// page-sqlite.tsx — SQLite: live visit table + interactive demos.\n\nimport {\n Badge,\n Banner,\n Button,\n CodeBlock,\n Heading,\n HStack,\n Link,\n Section,\n Table,\n TableBody,\n TableCell,\n TableHeader,\n TableHeaderCell,\n TableRow,\n Text,\n VStack,\n} from \"../astryx/components.ts\";\nimport { PageLinks } from \"./kit.tsx\";\nimport type { AppProps, CodeSnippet } from \"../types.ts\";\n\nconst LINKS = [\n { href: \"https://docs.val.town/reference/std/sqlite/\", label: \"SQLite docs\" },\n { href: \"https://www.val.town/pricing\", label: \"Pricing\" },\n { href: \"https://www.val.town/limits\", label: \"Limits\" },\n];\n\nconst MIGRATE_SNIPPET: CodeSnippet = {\n filename: \"backend/db.ts — migrate()\",\n code: `// Each App gets its own isolated SQLite — no prefix needed.\nlet migrated = false;\n\nasync function migrate(): Promise {\n if (migrated) return; // run once per cold-start\n migrated = true;\n 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 ]);\n}`,\n};\n\nconst QUERY_SNIPPET: CodeSnippet = {\n filename: \"backend/db.ts — queries\",\n code: `export 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\nexport async function getRecentVisits(limit = 20) {\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 return rows.map(r => ({ id: r[0], path: r[1], ts: r[2] }));\n}`,\n};\n\nconst CONCEPT_ROWS: { concept: string; example: string; note: string }[] = [\n { concept: \"App\", example: \"val-town-quickstart\", note: \"One App = one isolated SQLite DB\" },\n {\n concept: \"Service\",\n example: \"index.http.ts, cron.ts, email.ts\",\n note: \"All services share the App's single DB\",\n },\n {\n concept: \"No prefix needed\",\n example: \"visits, cron_runs\",\n note: \"DB is isolated — plain table names are fine\",\n },\n];\n\nconst RULE_ROWS: { rule: string; reason: string }[] = [\n {\n rule: \"Lazy migrate\",\n reason: \"Run schema in first call, not at import — avoids errors off-platform\",\n },\n { rule: \"Parameterised\", reason: \"Always use args: [...] — never interpolate into SQL strings\" },\n {\n rule: \"Schema versioning\",\n reason: \"Rename tables (_v2) when changing columns — no ALTER needed\",\n },\n {\n rule: \"Blob ≠ SQLite\",\n reason: \"Blob is account-scoped (all your Apps share it) — SQLite is App-scoped\",\n },\n];\n\nexport function SqlitePage({ user }: AppProps) {\n return (\n \n \n SQLite\n \n Each App gets its own isolated SQLite database, shared by all its services (HTTP, Cron,\n Email). 10 MB free / 1 GB Pro, backed by Turso. No connection string — import the client\n and query.\n \n \n \n\n \n Admin session\n

\n \n \n Pruning is an admin action. Sign in with Val Town and set{\" \"}\n AUTH_ADMIN_USERS to your Val Town username.\n \n \n {user\n ? (\n

\n \n\n \n Visit log — live from SQLite\n

\n \n \n

\n \n\n \n App → service → SQLite\n \n \n \n Concept\n Example\n Note\n \n \n \n {CONCEPT_ROWS.map((r) => (\n \n \n \n \n \n {r.example}\n \n {r.note}\n \n ))}\n \n

\n \n\n \n Rules\n \n \n \n Rule\n Reason\n \n \n \n {RULE_ROWS.map((r) => (\n \n \n \n \n {r.reason}\n \n ))}\n \n

\n \n\n \n \n \n \n );\n}\n","createdAt",["D",1788140101098],"branchVersion","branchId","5a0a7ac8-4895-11f1-80ec-42b51c65c3df","id","5a09ae54-4895-11f1-80ec-42b51c65c3df","Quickstart-Full-Stack",["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","173e7424-8658-428f-a3bc-ae4faeaabd1c","pinnedFileId","e1c705aa-4b18-11f1-b4ae-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","019df771-9af8-7238-99a4-541e39355038","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","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_18":58,"_108":109,"_110":25},"branch",{"_13":92,"_33":93,"_45":44,"_94":46,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":47,"_101":102},"isOwned",384,"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=1789538399&sig=21cdba23f818845c8391e88088eb5ea9255dbc43e05efe79e25bd70ab9ddb43a","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_45":46,"_33":47,"_40":498,"_49":-5,"_50":25,"_51":52,"_53":52,"_54":55,"_56":57,"_18":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":499,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":500,"_87":501,"_89":502,"_91":25},"tree",[226,234,252,255,256,257,258,259,260],"files",[226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260],"counts",{"_216":201,"_217":66,"_218":66,"_219":220,"_221":222},"contents",[134,135,136,137,138,139,140,141,142],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":210,"_33":211,"_31":212,"_146":-5,"_43":44,"_42":213,"_148":62,"_40":214,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_27":215},{"_45":204,"_33":205,"_31":206,"_146":-5,"_43":44,"_42":207,"_148":62,"_40":208,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_27":209},{"_45":196,"_33":197,"_31":198,"_146":-5,"_43":44,"_42":199,"_148":62,"_40":200,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_27":203},{"_45":188,"_33":189,"_31":190,"_146":-5,"_43":44,"_42":191,"_148":25,"_40":192,"_13":193,"_35":20,"_37":194,"_24":25,"_152":-5,"_27":195},{"_45":180,"_33":181,"_31":182,"_146":-5,"_43":44,"_42":183,"_148":25,"_40":184,"_13":150,"_35":185,"_37":186,"_24":25,"_152":-5,"_27":187},{"_45":172,"_33":173,"_31":174,"_146":-5,"_43":44,"_42":175,"_148":62,"_40":176,"_13":177,"_35":20,"_37":178,"_24":25,"_152":-5,"_27":179},{"_45":163,"_33":164,"_31":165,"_146":-5,"_43":44,"_42":166,"_148":25,"_40":167,"_13":168,"_35":169,"_37":170,"_24":25,"_152":-5,"_27":171},{"_45":154,"_33":155,"_31":60,"_146":-5,"_43":44,"_42":156,"_148":25,"_40":157,"_13":158,"_35":159,"_37":160,"_24":25,"_152":161,"_27":162},{"_45":143,"_33":144,"_31":145,"_146":-5,"_43":44,"_42":147,"_148":25,"_40":149,"_13":150,"_35":20,"_37":151,"_24":25,"_152":-5,"_27":153},"b1059b1c-15b9-4150-98e5-5b215bbe92e0","val.yml","aa729402-48c5-11f1-87ca-42b51c65c3df","parentId",298,"latest",["D",1788122838701],9,"name: \"Quickstart-Full-Stack\"\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\" links (see README)\n DAILY_HOUR_UTC: optional # 0-23 UTC hour for the daily cron task (default: \"2\")\n BLOB_DEMO_TOKEN: optional # protects public Blob demo read/write/list routes\n AUTH_SUPER_ADMINS: optional # comma-separated Val Town usernames — these users are super-admins\n","label",[144],"0d29c21a-0254-4800-af28-981986567366","index.http.ts",306,["D",1788122839148],17,"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 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 healthCheck,\n me,\n pruneVisits,\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([\"home\", \"anatomy\", \"http\", \"sqlite\", \"cron\", \"email\", \"blob\", \"ui\"]);\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/blob-keys\", route(getUc, blobKeys)],\n [\"POST /api/blob-write\", route(getUc, blobWrite)],\n [\"GET /api/blob-read\", route(getUc, 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",[155],"e5f0c888-7997-4647-b1b2-9f6ea91fb72e","email.ts","aa7742d6-48c5-11f1-831b-42b51c65c3df",299,["D",1788122838784],10,"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\";\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 // 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",[164],"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",[173],"ea1f8c34-4f02-11f1-ac5b-ee650bb23af1","cron.ts","aa651980-48c5-11f1-bfb8-42b51c65c3df",228,["D",1778700936143],"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, env } from \"./backend/shared.ts\";\nimport { logCronRun, 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 // TODO: replace with your 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",[181],"8847569b-3cc7-47b7-8dd7-016542787858","README.md","aabf7b64-48c5-11f1-9920-42b51c65c3df",305,["D",1788122839143],11,"# Quickstart-Full-Stack\n\n`_template` is uApps' onboarding tutorial and scaffold source: a small, production-shaped full-stack\nVal Town App you read top to bottom to learn the platform, then copy as the starting point for your\nown single-person or family app. It demonstrates one HTTP application with auth, APIs, SQLite, Blob,\nCron, Email, SSR pages, and small browser controllers — sized for a solo project, not an enterprise\nplatform team.\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 two Deno SSR bugs that had to be worked around.\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/Quickstart-Full-Stack/code/backend/auth.ts`. In-app \"view source\"\nlinks use this same pattern (see `VAL_TOWN_USERNAME` below).\n\n---\n\n## Create a Val\n\nFrom 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\nPages — read in this order the first time:\n\n- `/` — what this App is, who it's for, and where to go next.\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.\n- `/email` — inbound and outbound email examples.\n- `/blob` — token-protected Blob read/write/list demo.\n- `/ui` — Astryx theming explainer + component showcase.\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/blob-keys` | Demo token |\n| `POST` | `/api/blob-write` | Demo token |\n| `GET` | `/api/blob-read` | Demo token |\n| `GET` | `/api/admin/users` | Super-admin |\n| `POST` | `/api/admin/set-admin` | Super-admin |\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\" links on `/` and `/anatomy` |\n| `DAILY_HOUR_UTC` | Optional | Daily task hour, `0`–`23` UTC |\n| `BLOB_DEMO_TOKEN` | Optional | Enables public Blob demo routes |\n| `AUTH_SUPER_ADMINS` | Optional | Comma-separated Val Town usernames |\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. Auth types use `Cxt` (e.g. `UserCxt`,\n `RouteCxt`) — the more common short form for \"context\" — not `Ctx`.\n- `backend/handlers.ts` — focused API handlers.\n- `backend/db.ts` — retryable migration, visits, Cron runs, and users.\n- `backend/storage.ts` — val-namespaced account Blob access.\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` and\n `page-anatomy.tsx` are the tutorial's two \"read first\" pages; the rest are live feature demos.\n- `frontend/pages/kit.tsx` — shared page pieces, including `SourceLink`/`SourceLinkList` (the \"view\n source\" links, 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).\n\nThis template does not hydrate React: `client.ts` is inlined via `dangerouslySetInnerHTML` and only\ndoes `fetch` + `textContent` DOM updates by element `id`. Components that need hydration (Astryx's\n`CodeBlock` copy button, `TextInput`/`Field`) are either disabled or avoided — see\n[`_specs/astryx-template.md`](../../_specs/astryx-template.md) for the full list and reasoning.\n\n## Key Files\n\n| Path | Purpose |\n| --------------------------------- | -------------------------------------------- |\n| `index.http.ts` | HTTP, page routing, `GET /theme`, API table |\n| `backend/auth.ts` | Val Town OAuth and roles |\n| `backend/db.ts` | Val-scoped SQLite repositories |\n| `backend/storage.ts` | Account-scoped Blob adapter |\n| `frontend/app.tsx` | React SSR root, per-route page dispatch |\n| `frontend/astryx/` | Pinned Astryx imports, SSR shim, nav shell |\n| `frontend/pages/home.tsx` | Tutorial intro: what/who-for + source links |\n| `frontend/pages/page-anatomy.tsx` | Infra diagram, routing flow, core stack |\n| `frontend/pages/` | Interactive reference pages |\n| `frontend/client.ts` | Non-hydrated demo API wiring |\n| `cron.ts` | Scheduled tasks |\n| `email.ts` | Email trigger and helpers |\n| `val.yml` | Identity, triggers, and environment contract |\n| `../../_specs/astryx-template.md` | Approved Astryx migration plan |\n",[189],"da547397-0b24-4a21-b428-980fc6197902","tests","2e57dcec-a4dc-11f1-9d85-1607ee4eb77e",326,["D",1788140100236],0,"directory",[197],"85f9d626-4951-11f1-a16a-42b51c65c3df","frontend","85f9d6f8-4951-11f1-a16a-42b51c65c3df",34,["D",1778074991402],[205],"86303568-4951-11f1-a193-42b51c65c3df","backend","8630361c-4951-11f1-a193-42b51c65c3df",35,["D",1778074991756],[211],"pulls","branches","forks","envVars",{"_223":66,"_225":201},"connections",{"_223":201,"_224":201},"count","unfilledCount","emptyCount",{"_45":210,"_33":211,"_31":212,"_146":-5,"_43":44,"_42":213,"_148":62,"_40":495,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_262":496,"_27":497},{"_45":487,"_33":488,"_31":489,"_146":212,"_43":44,"_42":490,"_148":62,"_40":491,"_13":201,"_35":36,"_37":492,"_24":25,"_152":-5,"_262":493,"_27":494},{"_45":479,"_33":480,"_31":481,"_146":212,"_43":44,"_42":482,"_148":62,"_40":483,"_13":177,"_35":36,"_37":484,"_24":25,"_152":-5,"_262":485,"_27":486},{"_45":470,"_33":471,"_31":472,"_146":212,"_43":44,"_42":473,"_148":25,"_40":474,"_13":475,"_35":36,"_37":476,"_24":25,"_152":-5,"_262":477,"_27":478},{"_45":461,"_33":462,"_31":463,"_146":212,"_43":44,"_42":464,"_148":25,"_40":465,"_13":466,"_35":36,"_37":467,"_24":25,"_152":-5,"_262":468,"_27":469},{"_45":453,"_33":454,"_31":455,"_146":212,"_43":44,"_42":456,"_148":25,"_40":457,"_13":66,"_35":36,"_37":458,"_24":25,"_152":-5,"_262":459,"_27":460},{"_45":445,"_33":446,"_31":447,"_146":212,"_43":44,"_42":448,"_148":25,"_40":449,"_13":360,"_35":36,"_37":450,"_24":25,"_152":-5,"_262":451,"_27":452},{"_45":437,"_33":438,"_31":439,"_146":212,"_43":44,"_42":440,"_148":25,"_40":441,"_13":168,"_35":36,"_37":442,"_24":25,"_152":-5,"_262":443,"_27":444},{"_45":204,"_33":205,"_31":206,"_146":-5,"_43":44,"_42":207,"_148":62,"_40":434,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_262":435,"_27":436},{"_45":429,"_33":411,"_31":405,"_146":206,"_43":44,"_42":430,"_148":62,"_40":431,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_262":432,"_27":433},{"_45":421,"_33":422,"_31":423,"_146":405,"_43":44,"_42":424,"_148":25,"_40":425,"_13":417,"_35":36,"_37":426,"_24":25,"_152":-5,"_262":427,"_27":428},{"_45":412,"_33":413,"_31":414,"_146":405,"_43":44,"_42":415,"_148":25,"_40":416,"_13":417,"_35":36,"_37":418,"_24":25,"_152":-5,"_262":419,"_27":420},{"_45":402,"_33":403,"_31":404,"_146":405,"_43":44,"_42":406,"_148":62,"_40":407,"_13":201,"_35":36,"_37":408,"_24":25,"_152":-5,"_262":409,"_27":410},{"_45":397,"_33":333,"_31":327,"_146":206,"_43":44,"_42":398,"_148":62,"_40":399,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_262":400,"_27":401},{"_45":389,"_33":390,"_31":391,"_146":327,"_43":44,"_42":392,"_148":25,"_40":393,"_13":193,"_35":36,"_37":394,"_24":25,"_152":-5,"_262":395,"_27":396},{"_45":381,"_33":382,"_31":383,"_146":327,"_43":44,"_42":384,"_148":25,"_40":385,"_13":177,"_35":36,"_37":386,"_24":25,"_152":-5,"_262":387,"_27":388},{"_45":373,"_33":374,"_31":375,"_146":327,"_43":44,"_42":376,"_148":25,"_40":377,"_13":177,"_35":36,"_37":378,"_24":25,"_152":-5,"_262":379,"_27":380},{"_45":364,"_33":365,"_31":366,"_146":327,"_43":44,"_42":367,"_148":25,"_40":368,"_13":369,"_35":36,"_37":370,"_24":25,"_152":-5,"_262":371,"_27":372},{"_45":355,"_33":356,"_31":357,"_146":327,"_43":44,"_42":358,"_148":25,"_40":359,"_13":360,"_35":36,"_37":361,"_24":25,"_152":-5,"_262":362,"_27":363},{"_45":347,"_33":348,"_31":349,"_146":327,"_43":44,"_42":350,"_148":25,"_40":351,"_13":193,"_35":36,"_37":352,"_24":25,"_152":-5,"_262":353,"_27":354},{"_45":339,"_33":340,"_31":341,"_146":327,"_43":44,"_42":342,"_148":25,"_40":343,"_13":336,"_35":36,"_37":344,"_24":25,"_152":-5,"_262":345,"_27":346},{"_45":334,"_33":34,"_31":32,"_146":327,"_43":44,"_42":14,"_148":25,"_40":335,"_13":336,"_35":36,"_37":39,"_24":25,"_152":-5,"_262":337,"_27":338},{"_45":324,"_33":325,"_31":326,"_146":327,"_43":44,"_42":328,"_148":25,"_40":329,"_13":193,"_35":36,"_37":330,"_24":25,"_152":-5,"_262":331,"_27":332},{"_45":315,"_33":316,"_31":317,"_146":206,"_43":44,"_42":318,"_148":25,"_40":319,"_13":320,"_35":36,"_37":321,"_24":25,"_152":-5,"_262":322,"_27":323},{"_45":307,"_33":308,"_31":309,"_146":206,"_43":44,"_42":310,"_148":25,"_40":311,"_13":168,"_35":36,"_37":312,"_24":25,"_152":-5,"_262":313,"_27":314},{"_45":299,"_33":300,"_31":301,"_146":206,"_43":44,"_42":302,"_148":62,"_40":303,"_13":66,"_35":36,"_37":304,"_24":25,"_152":-5,"_262":305,"_27":306},{"_45":196,"_33":197,"_31":198,"_146":-5,"_43":44,"_42":199,"_148":62,"_40":296,"_13":201,"_35":202,"_37":-5,"_24":25,"_152":-5,"_262":297,"_27":298},{"_45":288,"_33":289,"_31":290,"_146":198,"_43":44,"_42":291,"_148":62,"_40":292,"_13":201,"_35":36,"_37":293,"_24":25,"_152":-5,"_262":294,"_27":295},{"_45":280,"_33":281,"_31":282,"_146":198,"_43":44,"_42":283,"_148":62,"_40":284,"_13":201,"_35":36,"_37":285,"_24":25,"_152":-5,"_262":286,"_27":287},{"_45":188,"_33":189,"_31":190,"_146":-5,"_43":44,"_42":191,"_148":25,"_40":277,"_13":193,"_35":20,"_37":194,"_24":25,"_152":-5,"_262":278,"_27":279},{"_45":180,"_33":181,"_31":182,"_146":-5,"_43":44,"_42":183,"_148":25,"_40":274,"_13":150,"_35":185,"_37":186,"_24":25,"_152":-5,"_262":275,"_27":276},{"_45":172,"_33":173,"_31":174,"_146":-5,"_43":44,"_42":175,"_148":62,"_40":271,"_13":177,"_35":20,"_37":178,"_24":25,"_152":-5,"_262":272,"_27":273},{"_45":163,"_33":164,"_31":165,"_146":-5,"_43":44,"_42":166,"_148":25,"_40":268,"_13":168,"_35":169,"_37":170,"_24":25,"_152":-5,"_262":269,"_27":270},{"_45":154,"_33":155,"_31":60,"_146":-5,"_43":44,"_42":156,"_148":25,"_40":265,"_13":158,"_35":159,"_37":160,"_24":25,"_152":161,"_262":266,"_27":267},{"_45":143,"_33":144,"_31":145,"_146":-5,"_43":44,"_42":147,"_148":25,"_40":261,"_13":150,"_35":20,"_37":151,"_24":25,"_152":-5,"_262":263,"_27":264},["D",1788122838701],"children",[],[144],["D",1788122839148],[],[155],["D",1788122838784],[],[164],["D",1778700935796],[],[173],["D",1778700936143],[],[181],["D",1788122839143],[],[189],"1df9127a-96ba-4073-9ed7-962976ae2c22","shared_test.ts","2e7f5452-a4dc-11f1-9001-1607ee4eb77e",328,["D",1788140100486],"import { assertEquals } from \"jsr:@std/assert@1\";\nimport { emailSlug, maskEmail } from \"../backend/shared.ts\";\n\ninterface TestCase {\n name: string;\n input: Input;\n expected: Expected;\n}\n\nconst SLUG_CASES: TestCase[] = [\n { name: \"spaces to hyphens\", input: \"Val Town Quickstart\", expected: \"val-town-quickstart\" },\n { name: \"already lowercase\", input: \"sample-val\", expected: \"sample-val\" },\n { name: \"punctuation collapses\", input: \"My App!! v2\", expected: \"my-app-v2\" },\n { name: \"leading/trailing junk trimmed\", input: \"--Hello--\", expected: \"hello\" },\n];\n\nconst MASK_CASES: TestCase[] = [\n { name: \"typical address\", input: \"johndoe@example.com\", expected: \"jo*****@example.com\" },\n { name: \"short local part\", input: \"ab@example.com\", expected: \"ab***@example.com\" },\n { name: \"no @ sign\", input: \"not-an-email\", expected: \"***\" },\n];\n\nfor (const c of SLUG_CASES) {\n Deno.test(`emailSlug: ${c.name}`, () => assertEquals(emailSlug(c.input), c.expected));\n}\n\nfor (const c of MASK_CASES) {\n Deno.test(`maskEmail: ${c.name}`, () => assertEquals(maskEmail(c.input), c.expected));\n}\n",[],[197,281],"3e4aea82-ed7f-417d-93db-5edd9aac9090","ai_test.ts","2e924436-a4dc-11f1-8d39-1607ee4eb77e",329,["D",1788140100442],"import { assertEquals } from \"jsr:@std/assert@1\";\nimport { type EmailTriage, parseTriage } from \"../backend/ai.ts\";\n\ninterface TestCase {\n name: string;\n input: string;\n expected: EmailTriage;\n}\n\nconst CASES: TestCase[] = [\n {\n name: \"spam clears the summary\",\n input: JSON.stringify({ isSpam: true, summary: \"should be dropped\" }),\n expected: { isSpam: true, summary: null },\n },\n {\n name: \"genuine message keeps its summary\",\n input: JSON.stringify({ isSpam: false, summary: \"Asking to reschedule Tuesday's call.\" }),\n expected: { isSpam: false, summary: \"Asking to reschedule Tuesday's call.\" },\n },\n {\n name: \"long summary is truncated to 200 chars\",\n input: JSON.stringify({ isSpam: false, summary: \"x\".repeat(500) }),\n expected: { isSpam: false, summary: \"x\".repeat(200) },\n },\n {\n name: \"malformed JSON fails safe to not-spam, no summary\",\n input: \"not json at all\",\n expected: { isSpam: false, summary: null },\n },\n {\n name: \"missing fields default sanely\",\n input: \"{}\",\n expected: { isSpam: false, summary: null },\n },\n];\n\nfor (const c of CASES) {\n Deno.test(`parseTriage: ${c.name}`, () => assertEquals(parseTriage(c.input), c.expected));\n}\n",[],[197,289],["D",1788140100236],[253,254],[197],"c38b96ba-98e2-415e-b24e-45256ebcc7a3","types.ts","dda64cce-a4a5-11f1-99b0-1607ee4eb77e",297,["D",1788122838479],"// types.ts — Shared UI data contracts for the SSR app.\n\nexport interface UserInfo {\n username: string;\n avatarUrl?: string;\n isAdmin: boolean;\n isSuperAdmin: boolean;\n}\n\n/** One color mode axis Astryx understands: light, dark, or follow the OS. */\nexport type ThemeMode = \"light\" | \"dark\" | \"system\";\n\nexport interface AppProps {\n appName: string;\n renderedAt: string;\n mode: ThemeMode;\n page: string;\n user: UserInfo | null;\n /** Owner's Val Town username, or \"\" if VAL_TOWN_USERNAME isn't set — powers\n * \"view source\" links (see frontend/pages/kit.tsx's SourceLink). */\n valTownUsername: string;\n}\n\nexport interface CodeSnippet {\n filename: string;\n code: string;\n}\n",[],[205,300],"4f2fa568-b5c5-4d6b-9aa8-6d99344c1ec0","client.ts","48ed4cf0-4b21-11f1-b54f-ee650bb23af1",260,["D",1788116689438],"// client.ts — Small per-page demo wiring. No router, no theme JS: navigation\n// is real page loads and the theme switch is a plain HTML form\n// (see astryx/shell.tsx) — both work with JavaScript disabled.\n//\n// Note: clientJs is a raw JS string injected into

Diff · v333