[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_111":112,"_113":114},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","pikachu","name","Quickstart-Full-Stack","path","backend/handlers.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":58,"_59":60,"_61":62,"_63":34,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/pikachu/Quickstart-Full-Stack/code/backend/handlers.ts","extension","id","79a7c1ac-adb4-4a22-b1a2-6f18265cb2de","handlers.ts","fileId","080cdc9e-5023-11f1-915b-ee650bb23af1","parentId","8630361c-4951-11f1-a193-42b51c65c3df","branchId","5a0a7ac8-4895-11f1-80ec-42b51c65c3df","branchVersion",340,"latest",true,"createdAt",["D",1788140102348],"version",2,"fileType","script","content","// handlers.ts — API route handler implementations.\n// Each handler receives a RouteCxt and returns a Response.\n\nimport {\n createReminder,\n deleteReminder,\n getCronRuns,\n getRecentVisits,\n getVisitCount,\n listRecentEmails,\n listReminders,\n listUsers,\n pruneOldVisits,\n setReminderDone,\n setUserAdmin,\n} from \"./db.ts\";\nimport { jsonError, jsonOk, type RouteCxt } from \"./api-utils.ts\";\nimport { APP_NAME } from \"./shared.ts\";\nimport { listKeys, loadJSON, saveJSON } from \"./storage.ts\";\n\n// ── Core ──────────────────────────────────────────────────────────────────────\n\nexport function healthCheck(): Response {\n return jsonOk({\n name: APP_NAME,\n timestamp: new Date().toISOString(),\n runtime: `Deno ${Deno.version?.deno ?? \"unknown\"}`,\n });\n}\n\nexport function me(cxt: RouteCxt): Response {\n return jsonOk({\n user: cxt.uc.user,\n isAdmin: cxt.uc.isAdmin,\n isSuperAdmin: cxt.uc.isSuperAdmin,\n });\n}\n\n// ── SQLite demos ──────────────────────────────────────────────────────────────\n\nexport async function visits(): Promise {\n try {\n const total = await getVisitCount();\n const recent = await getRecentVisits(20);\n return jsonOk({ total, recent });\n } catch {\n return jsonError(\"SQLite unavailable (off-platform?)\", 503);\n }\n}\n\nexport async function pruneVisits(): Promise {\n try {\n await pruneOldVisits(30);\n return jsonOk({ pruned: \"visits older than 30 days\" });\n } catch {\n return jsonError(\"SQLite unavailable (off-platform?)\", 503);\n }\n}\n\nexport async function cronRuns(): Promise {\n try {\n const runs = await getCronRuns(30);\n return jsonOk({ runs });\n } catch {\n return jsonError(\"SQLite unavailable (off-platform?)\", 503);\n }\n}\n\n// ── Reminders — the flagship shared \"tiny app\" demo ───────────────────────────\n// Public read; sign-in required to write (see index.http.ts's route table).\n\nexport async function remindersList(): Promise {\n try {\n const reminders = await listReminders();\n return jsonOk({ reminders });\n } catch {\n return jsonError(\"SQLite unavailable (off-platform?)\", 503);\n }\n}\n\nexport async function remindersCreate(cxt: RouteCxt): Promise {\n try {\n const body = await cxt.req.json() as { title?: string; note?: string; dueDate?: string };\n const title = (body.title ?? \"\").trim();\n if (!title) return jsonError(\"title required\");\n await createReminder(\n title,\n body.note?.trim() || null,\n body.dueDate?.trim() || null,\n cxt.uc.user!.username,\n );\n return jsonOk({ reminders: await listReminders() });\n } catch {\n return jsonError(\"Failed to create reminder\", 500);\n }\n}\n\nexport async function remindersSetDone(cxt: RouteCxt): Promise {\n try {\n const body = await cxt.req.json() as { id?: number; done?: boolean };\n if (typeof body.id !== \"number\") return jsonError(\"id required\");\n if (typeof body.done !== \"boolean\") return jsonError(\"done must be boolean\");\n const updated = await setReminderDone(body.id, body.done);\n if (!updated) return jsonError(\"Reminder not found\", 404);\n return jsonOk({ reminders: await listReminders() });\n } catch {\n return jsonError(\"Failed to update reminder\", 500);\n }\n}\n\nexport async function remindersDelete(cxt: RouteCxt): Promise {\n try {\n const body = await cxt.req.json() as { id?: number };\n if (typeof body.id !== \"number\") return jsonError(\"id required\");\n const deleted = await deleteReminder(body.id);\n if (!deleted) return jsonError(\"Reminder not found\", 404);\n return jsonOk({ reminders: await listReminders() });\n } catch {\n return jsonError(\"Failed to delete reminder\", 500);\n }\n}\n\n// ── Inbound email inbox — the AI spam/summary triage demo ─────────────────────\n// Public read-only; written by email.ts's inbound handler.\n\nexport async function emailsList(): Promise {\n try {\n const emails = await listRecentEmails();\n return jsonOk({ emails });\n } catch {\n return jsonError(\"SQLite unavailable (off-platform?)\", 503);\n }\n}\n\n// ── Blob demos ────────────────────────────────────────────────────────────────\n// Any signed-in user may read/write — keys are namespaced per-user so\n// concurrent demo visitors don't collide.\n\nfunction blobKeyPrefix(cxt: RouteCxt): string {\n return `${cxt.uc.user!.username}/`;\n}\n\nexport function blobKeys(cxt: RouteCxt): Response | Promise {\n return listKeys(blobKeyPrefix(cxt))\n .then((keys) => jsonOk({ keys }))\n .catch(() => jsonError(\"Blob unavailable (off-platform?)\", 503));\n}\n\nexport async function blobWrite(cxt: RouteCxt): Promise {\n try {\n const { key, value } = await cxt.req.json() as { key: string; value: unknown };\n if (!key) return jsonError(\"key required\");\n await saveJSON(`${blobKeyPrefix(cxt)}${key}`, value);\n return jsonOk({ key });\n } catch {\n return jsonError(\"Blob write failed\", 500);\n }\n}\n\nexport async function blobRead(cxt: RouteCxt): Promise {\n try {\n const key = cxt.url.searchParams.get(\"key\") ?? \"\";\n if (!key) return jsonError(\"key required\");\n const value = await loadJSON(`${blobKeyPrefix(cxt)}${key}`);\n return jsonOk({ key, value });\n } catch {\n return jsonError(\"Blob read failed\", 500);\n }\n}\n\n// ── Admin (super-admin only) ──────────────────────────────────────────────────\n\nexport async function adminListUsers(): Promise {\n try {\n const users = await listUsers();\n return jsonOk({ users });\n } catch {\n return jsonError(\"SQLite unavailable (off-platform?)\", 503);\n }\n}\n\nexport async function adminSetAdmin(cxt: RouteCxt): Promise {\n try {\n const body = await cxt.req.json() as { username: string; isAdmin: boolean };\n const username = (body.username ?? \"\").trim();\n if (!username) return jsonError(\"username required\");\n if (typeof body.isAdmin !== \"boolean\") return jsonError(\"isAdmin must be boolean\");\n const updated = await setUserAdmin(username, body.isAdmin);\n if (!updated) return jsonError(\"User not found\", 404);\n return jsonOk({ username, isAdmin: body.isAdmin });\n } catch {\n return jsonError(\"Failed to update admin status\", 500);\n }\n}\n","deleted",false,"label",[47,24],"backend","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","userId","173e7424-8658-428f-a3bc-ae4faeaabd1c","pinnedFileId","e1c705aa-4b18-11f1-b4ae-ee650bb23af1","pinPreview","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",{"_9":10,"_110":106},"org",{"_9":10,"_103":104,"_105":106,"_59":60,"_107":108,"_109":44},"branch",{"_37":93,"_11":94,"_22":30,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":12,"_102":10},"isOwned",384,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Minion","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/22c8ba37-42c8-4af4-8daf-8cdd2f5f1800/square512?exp=1789538399&sig=21cdba23f818845c8391e88088eb5ea9255dbc43e05efe79e25bd70ab9ddb43a","tier","free","canRestrictVals","profileImageUrl","ctx",{"_86":-5,"_144":145,"_146":147,"_148":149,"_150":44,"_151":44,"_152":44,"_153":34,"_154":-5,"_155":-7,"_156":-7,"_157":158,"_159":44,"_160":44,"_161":-5,"_162":44,"_163":44,"_164":44,"_165":-5},"ENV",{"_115":116,"_117":118,"_119":94,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141,"_142":143},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount",0,"flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]