React Hono Val Town Starter

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_279":280,"_281":282},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_113":95,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":64,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","cf0b71fa-84ac-4726-9729-2e4fceaa32bc","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","backend/surveys.ts","latestPath","fileId","65dd734e-a8eb-11f1-83ff-1607ee4eb77e","name","surveys.ts","fileType","script","content","import type { Answers, Question, Survey } from \"../shared/types.ts\";\nimport { ensureSchema, randomId, sha256, sqlite } from \"./db.ts\";\n\nfunction rowToSurvey(r: Record): Survey {\n return {\n id: String(r.id),\n slug: String(r.slug),\n title: String(r.title),\n description: String(r.description ?? \"\"),\n resultsVisible: Number(r.results_visible) === 1,\n acceptingResponses: Number(r.accepting_responses) === 1,\n audienceFacets: Number(r.audience_facets) === 1,\n createdAt: String(r.created_at),\n questions: JSON.parse(String(r.questions_json ?? \"[]\")),\n };\n}\n\nexport async function createSurvey(title: string): Promise<{ survey: Survey; adminKey: string }> {\n await ensureSchema();\n const id = randomId(12);\n const slug = randomId(6);\n const adminKey = randomId(28);\n const hash = await sha256(adminKey);\n await sqlite.execute({\n sql: `INSERT INTO surveys (id, slug, admin_key_hash, title) VALUES (?, ?, ?, ?)`,\n args: [id, slug, hash, title || \"Untitled survey\"],\n });\n const survey = await getSurveyBySlug(slug);\n return { survey: survey!, adminKey };\n}\n\nexport async function getSurveyBySlug(slug: string): Promise {\n await ensureSchema();\n const r = await sqlite.execute({ sql: `SELECT * FROM surveys WHERE slug = ?`, args: [slug] });\n return r.rows[0] ? rowToSurvey(r.rows[0] as Record) : null;\n}\n\nexport async function getSurveyByAdminKey(adminKey: string): Promise {\n await ensureSchema();\n const hash = await sha256(adminKey);\n const r = await sqlite.execute({ sql: `SELECT * FROM surveys WHERE admin_key_hash = ?`, args: [hash] });\n return r.rows[0] ? rowToSurvey(r.rows[0] as Record) : null;\n}\n\nexport interface SurveyPatch {\n title?: string;\n description?: string;\n resultsVisible?: boolean;\n acceptingResponses?: boolean;\n audienceFacets?: boolean;\n questions?: Question[];\n}\n\nexport async function updateSurvey(id: string, patch: SurveyPatch): Promise {\n await ensureSchema();\n const sets: string[] = [];\n const args: (string | number)[] = [];\n if (patch.title !== undefined) sets.push(\"title = ?\"), args.push(patch.title);\n if (patch.description !== undefined) sets.push(\"description = ?\"), args.push(patch.description);\n if (patch.resultsVisible !== undefined) sets.push(\"results_visible = ?\"), args.push(patch.resultsVisible ? 1 : 0);\n if (patch.acceptingResponses !== undefined) {\n sets.push(\"accepting_responses = ?\"), args.push(patch.acceptingResponses ? 1 : 0);\n }\n if (patch.audienceFacets !== undefined) sets.push(\"audience_facets = ?\"), args.push(patch.audienceFacets ? 1 : 0);\n if (patch.questions !== undefined) {\n const qs = patch.questions.map((q, i) => ({ ...q, position: i }));\n sets.push(\"questions_json = ?\"), args.push(JSON.stringify(qs));\n }\n if (!sets.length) return;\n args.push(id);\n await sqlite.execute({ sql: `UPDATE surveys SET ${sets.join(\", \")} WHERE id = ?`, args });\n}\n\nexport async function deleteSurvey(id: string): Promise {\n await ensureSchema();\n await sqlite.batch([\n { sql: `DELETE FROM responses WHERE survey_id = ?`, args: [id] },\n { sql: `DELETE FROM surveys WHERE id = ?`, args: [id] },\n ]);\n}\n\nexport async function clearResponses(surveyId: string): Promise {\n await ensureSchema();\n await sqlite.execute({ sql: `DELETE FROM responses WHERE survey_id = ?`, args: [surveyId] });\n}\n\nexport async function upsertResponse(surveyId: string, sid: string, answers: Answers): Promise {\n await ensureSchema();\n await sqlite.execute({\n sql: `INSERT INTO responses (survey_id, sid, answers_json) VALUES (?, ?, ?)\n ON CONFLICT(survey_id, sid) DO UPDATE SET answers_json = excluded.answers_json, updated_at = datetime('now')`,\n args: [surveyId, sid, JSON.stringify(answers)],\n });\n}\n\nexport async function getResponse(surveyId: string, sid: string): Promise {\n await ensureSchema();\n const r = await sqlite.execute({\n sql: `SELECT answers_json FROM responses WHERE survey_id = ? AND sid = ?`,\n args: [surveyId, sid],\n });\n return r.rows[0] ? JSON.parse(String(r.rows[0].answers_json)) : null;\n}\n\nexport async function getAllResponses(surveyId: string): Promise {\n await ensureSchema();\n const r = await sqlite.execute({\n sql: `SELECT answers_json FROM responses WHERE survey_id = ? ORDER BY id`,\n args: [surveyId],\n });\n return r.rows.map((row) => JSON.parse(String(row.answers_json)));\n}\n\n/** Validate & normalize incoming answers against the survey's questions. Drops unknown keys. */\nexport function sanitizeAnswers(survey: Survey, raw: unknown): Answers {\n const out: Answers = {};\n if (!raw || typeof raw !== \"object\") return out;\n const input = raw as Record;\n for (const q of survey.questions) {\n const v = input[q.id];\n if (v === undefined || v === null || v === \"\") continue;\n const optIds = new Set(q.options.map((o) => o.id));\n switch (q.type) {\n case \"single_choice\":\n case \"emoji_reaction\":\n if (typeof v === \"string\" && optIds.has(v)) out[q.id] = v;\n break;\n case \"multi_choice\":\n if (Array.isArray(v)) out[q.id] = v.filter((x) => typeof x === \"string\" && optIds.has(x));\n break;\n case \"ranked_choice\":\n if (Array.isArray(v)) {\n const seen = new Set();\n out[q.id] = v.filter((x) => typeof x === \"string\" && optIds.has(x) && !seen.has(x) && seen.add(x));\n }\n break;\n case \"scale\": {\n const n = Number(v);\n const min = q.scaleMin ?? 1, max = q.scaleMax ?? 5;\n if (Number.isFinite(n) && n >= min && n <= max) out[q.id] = Math.round(n);\n break;\n }\n case \"free_text\":\n if (typeof v === \"string\") out[q.id] = v.slice(0, 2000);\n break;\n case \"word_cloud\":\n if (typeof v === \"string\") out[q.id] = v.trim().slice(0, 40);\n break;\n }\n }\n return out;\n}\n","createdAt",["D",1788586440486],"branchVersion","branchId","00e09eca-4d1b-4e02-b98f-8565c54b4542","id","ae520107-1d25-47b9-ad83-831e36befb67","presentation-survey",["D",1788585574393],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live talk polling: QR join, ranked choice, demographic facets","imageUrl","0198fc74-a2ac-77df-bbdc-e23a8e395bee","pinnedFileId","01a0700e-6ffa-7369-be27-ef5029df6316","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0198fc74-a2ad-7019-840f-e164a0170dfc","tursoName","ae5201071d2547b9ad83831e36befb67","tursoHostname","ae5201071d2547b9ad83831e36befb67-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789542098478],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":108},"org",{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",150,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","khxu","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMjFKVFdGYXdiZmFXS0hOajdwWHNBOUlZUE4ifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":274,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":275,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":276,"_89":277,"_91":278,"_93":30},"tree",[185,188,195,197,198],"files",[185,186,187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_175":68,"_176":160,"_177":68,"_178":179,"_180":181},"contents",[135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":169,"_37":170,"_35":171,"_143":-5,"_46":47,"_45":172,"_145":64,"_43":173,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_32":174},{"_48":164,"_37":165,"_35":166,"_143":-5,"_46":47,"_45":151,"_145":64,"_43":167,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_32":168},{"_48":157,"_37":158,"_35":159,"_143":-5,"_46":47,"_45":160,"_145":64,"_43":161,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_32":163},{"_48":149,"_37":150,"_35":62,"_143":-5,"_46":47,"_45":151,"_145":30,"_43":152,"_13":68,"_39":153,"_41":154,"_29":30,"_147":155,"_32":156},{"_48":140,"_37":141,"_35":142,"_143":-5,"_46":47,"_45":144,"_145":30,"_43":146,"_13":68,"_39":40,"_41":114,"_29":30,"_147":-5,"_32":148},"71c5a6dd-6c8b-480b-990d-6172d4a18ad3","main.ts","61a59e16-a8e9-11f1-87f5-1607ee4eb77e","parentId",1,"latest",["D",1788585574415],"label",[141],"43443e42-137a-4a82-a286-e4015771f287","index.ts",2,["D",1788586389500],"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","audience-survey",[150],"3d8da2dc-c72c-49b4-824a-0d8647503817","shared","b40de0d0-1c08-44ab-bea0-624350d7cf7b",3,["D",1788586405154],"directory",[158],"0f6bbd75-0daf-4112-b29a-623560ed0730","frontend","01a0700e-6ffa-7369-be27-f3f825983851",["D",1788586389500],[165],"96062b4f-f92b-4507-8af4-a9d865f43436","backend","a73fa0d1-3dea-4570-b0fc-54f92da89dd6",4,["D",1788586412989],[170],"pulls","branches","forks","envVars",{"_182":68,"_184":68},"connections",{"_182":68,"_183":68},"count","unfilledCount","emptyCount",{"_48":169,"_37":170,"_35":171,"_143":-5,"_46":47,"_45":172,"_145":64,"_43":271,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_200":272,"_32":273},{"_48":264,"_37":265,"_35":266,"_143":171,"_46":47,"_45":172,"_145":30,"_43":267,"_13":68,"_39":40,"_41":268,"_29":30,"_147":-5,"_200":269,"_32":270},{"_48":260,"_37":38,"_35":36,"_143":171,"_46":47,"_45":14,"_145":30,"_43":261,"_13":68,"_39":40,"_41":42,"_29":30,"_147":-5,"_200":262,"_32":263},{"_48":164,"_37":165,"_35":166,"_143":-5,"_46":47,"_45":151,"_145":64,"_43":257,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_200":258,"_32":259},{"_48":253,"_37":245,"_35":240,"_143":166,"_46":47,"_45":151,"_145":64,"_43":254,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_200":255,"_32":256},{"_48":246,"_37":247,"_35":248,"_143":240,"_46":47,"_45":151,"_145":30,"_43":249,"_13":68,"_39":40,"_41":250,"_29":30,"_147":-5,"_200":251,"_32":252},{"_48":237,"_37":238,"_35":239,"_143":240,"_46":47,"_45":151,"_145":30,"_43":241,"_13":68,"_39":40,"_41":242,"_29":30,"_147":-5,"_200":243,"_32":244},{"_48":230,"_37":231,"_35":232,"_143":166,"_46":47,"_45":151,"_145":30,"_43":233,"_13":68,"_39":26,"_41":234,"_29":30,"_147":-5,"_200":235,"_32":236},{"_48":223,"_37":224,"_35":225,"_143":166,"_46":47,"_45":151,"_145":30,"_43":226,"_13":68,"_39":40,"_41":227,"_29":30,"_147":-5,"_200":228,"_32":229},{"_48":216,"_37":217,"_35":218,"_143":166,"_46":47,"_45":151,"_145":30,"_43":219,"_13":68,"_39":40,"_41":220,"_29":30,"_147":-5,"_200":221,"_32":222},{"_48":157,"_37":158,"_35":159,"_143":-5,"_46":47,"_45":160,"_145":64,"_43":213,"_13":68,"_39":162,"_41":-5,"_29":30,"_147":-5,"_200":214,"_32":215},{"_48":206,"_37":207,"_35":208,"_143":159,"_46":47,"_45":160,"_145":30,"_43":209,"_13":68,"_39":40,"_41":210,"_29":30,"_147":-5,"_200":211,"_32":212},{"_48":149,"_37":150,"_35":62,"_143":-5,"_46":47,"_45":151,"_145":30,"_43":203,"_13":68,"_39":153,"_41":154,"_29":30,"_147":155,"_200":204,"_32":205},{"_48":140,"_37":141,"_35":142,"_143":-5,"_46":47,"_45":144,"_145":30,"_43":199,"_13":68,"_39":40,"_41":114,"_29":30,"_147":-5,"_200":201,"_32":202},["D",1788585574415],"children",[],[141],["D",1788586389500],[],[150],"4394ede1-0223-409e-b89b-5f538bba5b2e","types.ts","50d89668-a8eb-11f1-a50d-1607ee4eb77e",["D",1788586405154],"export type QuestionType =\n | \"single_choice\"\n | \"multi_choice\"\n | \"scale\"\n | \"free_text\"\n | \"ranked_choice\"\n | \"word_cloud\"\n | \"emoji_reaction\";\n\nexport interface Option {\n id: string;\n label: string;\n}\n\nexport interface Question {\n id: string;\n position: number;\n type: QuestionType;\n prompt: string;\n options: Option[]; // for choice/ranked/emoji types\n scaleMin?: number; // for scale\n scaleMax?: number;\n isDemographic: boolean;\n required: boolean;\n hidden: boolean; // per-question hide override on results\n}\n\nexport interface Survey {\n id: string;\n slug: string;\n title: string;\n description: string;\n resultsVisible: boolean;\n acceptingResponses: boolean;\n audienceFacets: boolean; // can the audience use group-by on results?\n createdAt: string;\n questions: Question[];\n}\n\n/** Answer values: single -> optionId; multi -> optionId[]; scale -> number;\n * free_text/word_cloud -> string; ranked_choice -> optionId[] (ordered); emoji -> optionId */\nexport type AnswerValue = string | number | string[];\n\nexport type Answers = Record;\n\nexport interface IRVRound {\n round: number;\n tallies: Record;\n eliminated: string | null;\n winner: string | null;\n}\n\nexport interface QuestionAggregate {\n questionId: string;\n type: QuestionType;\n responseCount: number;\n /** For choice/emoji: counts by optionId. */\n counts?: Record;\n /** For scale: counts by value, plus mean. */\n distribution?: Record;\n mean?: number | null;\n /** For text/word cloud. */\n texts?: string[];\n words?: { text: string; value: number }[];\n /** For ranked choice. */\n irv?: IRVRound[];\n borda?: Record;\n firstChoice?: Record;\n}\n\nexport interface FacetGroup {\n key: string; // optionId or scale value, or \"__all__\"\n label: string;\n responseCount: number;\n aggregates: QuestionAggregate[];\n}\n\nexport interface ResultsPayload {\n survey: Survey;\n totalResponses: number;\n groupBy: string | null;\n groups: FacetGroup[];\n}\n\nexport const QUESTION_TYPE_LABELS: Record = {\n single_choice: \"Multiple choice (pick one)\",\n multi_choice: \"Multiple choice (pick many)\",\n scale: \"Scale / rating\",\n free_text: \"Free text\",\n ranked_choice: \"Ranked choice\",\n word_cloud: \"Word cloud (one word/phrase)\",\n emoji_reaction: \"Emoji reaction\",\n};\n\nexport const DEFAULT_EMOJIS = [\"🔥\", \"😍\", \"🤔\", \"😴\", \"😂\", \"🤯\"];\n\nexport function hasOptions(t: QuestionType) {\n return t === \"single_choice\" || t === \"multi_choice\" || t === \"ranked_choice\" || t === \"emoji_reaction\";\n}\n",[],[158,207],["D",1788586405154],[196],[158],"9ffd55ca-ae79-4954-854f-8e35fad9f87d","root.tsx","01a0700e-6ffb-769f-9a4d-f2d83060ed96",["D",1788586389500],"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"\")}\n \n \n \n \n React Hono Val Town Starter\n

Diff · v5