[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_338":339,"_340":341},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_250":-5,"_20":251,"_22":252,"_253":254,"_255":256,"_26":257,"_24":258,"_259":-5,"_260":-5,"_261":51,"_262":263,"_264":43,"_265":-5,"_266":-5,"_267":268},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","sarahscanzoni","name","team-role-quiz","branchName","main","version","path","README.md","project",{"_33":192,"_13":14,"_44":193,"_194":-5,"_195":51,"_196":197,"_198":197,"_199":200,"_201":-5,"_202":203,"_204":61,"_205":43,"_206":-5,"_207":-5,"_208":78,"_209":210,"_211":212,"_213":214,"_215":216,"_217":-5,"_218":219,"_220":219,"_221":222,"_223":222,"_224":222,"_225":219,"_226":219,"_227":228,"_229":230,"_231":232,"_233":51},"tree",[54,55,56,57,58],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","d0c018d2-c131-41aa-accd-7e27d6f25389","fileId","01a066e1-7df8-761e-a032-f0040755d6a2","parentId","branchId","3da4bec3-f115-40ba-b376-ae10ca676677","branchVersion",7,"latest",true,"createdAt",["D",1788432591989],1,"fileType","content","# How You Work — Team Role Quiz\n\nA shareable Belbin-style team role assessment, hosted on Val Town.\n\n**Live quiz:** https://how-you-work.val.run/\n\n## What it is\n\nNine short \"set\" questions, each with three statements rated on a 1–5 scale. The\nquiz scores all nine Belbin team roles, shows your top roles with strengths and\nallowable weaknesses, lets you download a PDF of your profile, and offers a\n**shared team board** so everyone who enters the same team code shows up on one\nboard with their top roles.\n\n## Access\n\nThe app is public by default, so anyone with the link can take the quiz. Only a\nperson who matches the team code influences that team's board — the quiz itself is\nfully client-side and no answers leave the browser unless someone adds themselves\nto a team board.\n\n## How it's built\n\n```\nmain.tsx Hono routes (the HTTP entry)\n / serves the quiz (frontend/quiz.html)\n /api/team (GET) reads a team board by ?code=\n /api/team (POST) adds/replaces a member, returns the updated board\n /dashboard leftover artifact uploader from the original template\nfrontend/\n quiz.html the entire quiz UI + client-side scoring and rendering\nbackend/\n team.ts team board storage in project-scoped SQLite\n```\n\n## Team board\n\nAfter finishing the quiz, a viewer enters a name and a team code. The app stores\n`{code, name, topRoles}` in the val's SQLite database. Anyone opening the link and\nusing the same code sees the same board — each member's top role(s), plus which of\nthe nine roles aren't naturally covered yet.\n\nThis replaced the original `window.storage` implementation, which only worked\ninside Claude Artifacts. Here it's a real shared store that works for anyone with\nthe link.\n\n## Remix\n\nClick **Remix** in the top right of this val to get your own copy, then claim your\nown subdomain on the online val.\n","deleted",false,"label",[19],{"_33":162,"_13":163,"_35":164,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":165,"_17":78,"_47":79,"_48":-5,"_50":51,"_52":-5,"_68":166,"_18":167},{"_33":132,"_13":133,"_35":134,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":135,"_17":78,"_47":79,"_48":-5,"_50":51,"_52":-5,"_68":136,"_18":137},{"_33":74,"_13":75,"_35":76,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":77,"_17":78,"_47":79,"_48":-5,"_50":51,"_52":-5,"_68":80,"_18":81},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":71,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_68":72,"_18":73},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":65,"_48":66,"_50":51,"_52":67,"_68":69,"_18":70},"a8dfcd6d-0fa3-46e2-b7aa-3a090a63bed1","main.tsx","01a066e1-7df8-761e-a032-f716b490a090",6,["D",1788432562405],3,"http","/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono } from \"npm:hono@4\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nimport { getTeam, initTeamDb, upsertMember } from \"./backend/team.ts\";\n\nimport {\n createArtifact,\n deleteArtifact,\n getArtifact,\n initDb,\n listArtifacts,\n renameArtifact,\n} from \"./backend/db.ts\";\nimport { renderArtifact } from \"./backend/render.ts\";\nimport { Dashboard } from \"./frontend/Dashboard.tsx\";\nimport { Landing } from \"./frontend/Landing.tsx\";\nimport { Layout } from \"./frontend/Layout.tsx\";\nimport { Viewer } from \"./frontend/Viewer.tsx\";\n\nconst ORG = parseVal().username;\nconst IS_TEMPLATE_DEMO = ORG === \"templates\";\nconst IDENTITY_HEADER = \"X-Val-Town-User\";\n\nawait initDb();\nawait initTeamDb();\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err)); // surface real stack traces\n\n// Render a JSX page as a full HTML document.\nconst page = (node: any, status = 200) =>\n new Response(\"\" + node.toString(), {\n status,\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n\n// Resolve the signed identity added by Val Town Access for human viewers.\n// Public and automation-bypass requests have no viewer identity.\nasync function getViewer(req: Request): Promise<{ username: string | null } | null> {\n const signed = req.headers.get(IDENTITY_HEADER);\n const token = Deno.env.get(\"valtown\");\n if (!signed || !token) return null;\n\n const response = await fetch(\"https://api.val.town/v3/val/viewer\", {\n headers: {\n Authorization: `Bearer ${token}`,\n [IDENTITY_HEADER]: signed,\n },\n });\n if (!response.ok) return null;\n return await response.json();\n}\n\n// Serve the quiz at the root — this is the shareable link.\napp.get(\"/\", (c) =>\n serveFile(\"./frontend/quiz.html\", import.meta.url));\n\n// Team board API: read the board for a team code.\napp.get(\"/api/team\", async (c) => {\n const code = (c.req.query(\"code\") ?? \"\").trim().slice(0, 120);\n if (!code) return c.json({ members: [] });\n const members = await getTeam(code);\n return c.json({ members });\n});\n\n// Team board API: add/replace a member and return the updated board.\napp.post(\"/api/team\", async (c) => {\n const body = await c.req.json().catch(() => null) as {\n code?: string; name?: string; topRoles?: string[];\n } | null;\n const code = (body?.code ?? \"\").trim().slice(0, 120);\n const name = (body?.name ?? \"\").trim().slice(0, 80);\n const topRoles = Array.isArray(body?.topRoles)\n ? body!.topRoles.filter((r) => typeof r === \"string\").slice(0, 2)\n : [];\n if (!code || !name) return c.json({ error: \"Code and name required.\" }, 400);\n const members = await upsertMember(code, name, topRoles);\n return c.json({ members });\n});\n\napp.get(\"/dashboard\", async (c) => {\n const artifacts = await listArtifacts();\n return page(\n \n \n ,\n );\n});\n\n// Create an artifact from a dropped/selected HTML or Markdown file.\napp.post(\"/upload\", async (c) => {\n if (IS_TEMPLATE_DEMO) return c.text(\"Uploads are disabled in the template demo.\", 403);\n const form = await c.req.formData();\n const file = form.get(\"file\");\n const source = file instanceof File\n ? await file.text()\n : (form.get(\"html\")?.toString() ?? \"\");\n if (!source.trim()) return c.text(\"That file is empty.\", 400);\n const rawName = form.get(\"name\")?.toString()\n || (file instanceof File ? file.name : \"\")\n || \"untitled\";\n // Markdown when the filename says so (or the form explicitly asks); else HTML.\n const kind = /\\.(md|markdown)$/i.test(rawName) ||\n form.get(\"kind\")?.toString() === \"md\"\n ? \"md\"\n : \"html\";\n const name = rawName.replace(/\\.(html?|md|markdown)$/i, \"\").trim().slice(0, 80) ||\n \"untitled\";\n const viewer = await getViewer(c.req.raw);\n const id = await createArtifact({\n name,\n html: source,\n kind,\n createdBy: viewer?.username ?? \"anonymous\",\n });\n return c.json({ id, url: `/a/${id}` });\n});\n\n// View an artifact, rendered inside a sandboxed iframe (see Viewer).\napp.get(\"/a/:id\", async (c) => {\n const artifact = await getArtifact(c.req.param(\"id\"));\n if (!artifact) {\n return page(, 404);\n }\n return page(\n ,\n );\n});\n\n// Raw artifact HTML — the source for the sandboxed iframe. The CSP `sandbox`\n// directive forces an opaque origin even on a top-level visit, so uploaded\n// scripts can never act as the viewer (mirrors Viewer).\napp.get(\"/a/:id/raw\", async (c) => {\n const artifact = await getArtifact(c.req.param(\"id\"));\n if (!artifact) return c.text(\"Not found\", 404);\n return new Response(renderArtifact(artifact), {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"content-security-policy\":\n \"sandbox allow-scripts allow-forms allow-popups allow-modals\",\n \"x-content-type-options\": \"nosniff\",\n },\n });\n});\n\napp.post(\"/a/:id/rename\", async (c) => {\n if (IS_TEMPLATE_DEMO) return c.text(\"Renaming is disabled in the template demo.\", 403);\n const form = await c.req.formData();\n const name = (form.get(\"name\")?.toString() ?? \"\").trim().slice(0, 80);\n if (!name) return c.text(\"Name is required.\", 400);\n if (!await renameArtifact(c.req.param(\"id\"), name)) {\n return c.text(\"Not found\", 404);\n }\n return c.redirect(\"/dashboard\");\n});\n\napp.post(\"/a/:id/delete\", async (c) => {\n if (IS_TEMPLATE_DEMO) return c.text(\"Deleting is disabled in the template demo.\", 403);\n await deleteArtifact(c.req.param(\"id\"));\n return c.redirect(\"/dashboard\");\n});\n\n// Drag-and-drop client script (kept out of the markup per house style).\napp.get(\n \"/upload.client.js\",\n (c) => serveFile(\"./frontend/upload.client.ts\", import.meta.url),\n);\n\n// Every Val Town app links to its own source.\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app.fetch;\n","how-you-work","children",[],[60],["D",1788432591989],[],[19],"155fa63a-6c29-4628-a28f-bd81a3231a71","frontend","01a066e1-7df8-761e-a032-ed0a31d367a2",["D",1788432448946],0,"directory",[82,83,84,85,86,87],[75],{"_33":125,"_13":126,"_35":127,"_37":76,"_38":39,"_40":46,"_42":43,"_44":128,"_17":78,"_47":92,"_48":129,"_50":51,"_52":-5,"_68":130,"_18":131},{"_33":118,"_13":119,"_35":120,"_37":76,"_38":39,"_40":46,"_42":43,"_44":121,"_17":78,"_47":92,"_48":122,"_50":51,"_52":-5,"_68":123,"_18":124},{"_33":111,"_13":112,"_35":113,"_37":76,"_38":39,"_40":46,"_42":43,"_44":114,"_17":78,"_47":92,"_48":115,"_50":51,"_52":-5,"_68":116,"_18":117},{"_33":104,"_13":105,"_35":106,"_37":76,"_38":39,"_40":46,"_42":43,"_44":107,"_17":78,"_47":92,"_48":108,"_50":51,"_52":-5,"_68":109,"_18":110},{"_33":96,"_13":97,"_35":98,"_37":76,"_38":39,"_40":99,"_42":43,"_44":100,"_17":78,"_47":24,"_48":101,"_50":51,"_52":-5,"_68":102,"_18":103},{"_33":88,"_13":89,"_35":90,"_37":76,"_38":39,"_40":46,"_42":43,"_44":91,"_17":78,"_47":92,"_48":93,"_50":51,"_52":-5,"_68":94,"_18":95},"40356ad0-42c7-4ec6-a16a-ec8be26057f6","upload.client.ts","01a066e1-7df8-761e-a032-eab935b29196",["D",1788432448946],"script","// Drag-and-drop / file-picker uploader for the dashboard, plus a small\n// confirm() for delete forms. Kept out of the markup per house style.\n\nconst zone = document.getElementById(\"dropzone\");\nconst input = document.getElementById(\"fileInput\") as HTMLInputElement | null;\nconst statusEl = document.getElementById(\"dropStatus\");\n\nfunction setStatus(msg: string) {\n if (statusEl) statusEl.textContent = msg;\n}\n\nif (zone && input) {\n const highlight = (on: boolean) =>\n zone.classList.toggle(\"border-blue-400\", on);\n\n zone.addEventListener(\"dragover\", (e) => {\n e.preventDefault();\n highlight(true);\n });\n zone.addEventListener(\"dragleave\", (e) => {\n // dragleave also fires when the pointer moves onto a child element; only\n // clear the highlight when it actually leaves the zone.\n if (!zone.contains((e as DragEvent).relatedTarget as Node | null)) {\n highlight(false);\n }\n });\n zone.addEventListener(\"drop\", (e) => {\n e.preventDefault();\n highlight(false);\n const files = (e as DragEvent).dataTransfer?.files;\n if (files && files.length) uploadAll(files);\n });\n input.addEventListener(\"change\", () => {\n if (input.files && input.files.length) uploadAll(input.files);\n });\n}\n\nasync function uploadAll(files: FileList) {\n const list = [...files].filter(\n (f) =>\n /\\.(html?|md|markdown)$/i.test(f.name) ||\n f.type === \"text/html\" ||\n f.type === \"text/markdown\",\n );\n if (!list.length) {\n setStatus(\"Please drop .html or .md files.\");\n return;\n }\n setStatus(`Uploading ${list.length} file${list.length > 1 ? \"s\" : \"\"}…`);\n let lastUrl = \"\";\n try {\n for (const file of list) {\n const body = new FormData();\n body.set(\"file\", file);\n body.set(\"name\", file.name);\n const res = await fetch(\"/upload\", { method: \"POST\", body });\n if (!res.ok) throw new Error(await res.text());\n lastUrl = (await res.json()).url;\n }\n } catch (err) {\n setStatus(\n \"Upload failed: \" + (err instanceof Error ? err.message : String(err)),\n );\n return;\n }\n location.href = list.length === 1 ? lastUrl : \"/dashboard\";\n}\n\n// Confirm before submitting any form marked with data-confirm.\nfor (\n const form of document.querySelectorAll(\"form[data-confirm]\")\n) {\n form.addEventListener(\"submit\", (e) => {\n if (!confirm(form.getAttribute(\"data-confirm\") || \"Are you sure?\")) {\n e.preventDefault();\n }\n });\n}\n",[],[75,89],"263b91da-9cbf-4b24-8ec5-cfe550af4653","quiz.html","07636fe2-a785-11f1-abaf-1607ee4eb77e",2,["D",1788432522155],"\n\n\n\n\nHow You Work — Discover Your Team Role\n\n\n\n\n\n

\n\n\n\n\n",[],[75,97],"44d6675d-5526-4066-95ab-f623e9c6b7ac","Viewer.tsx","01a066e1-7df8-761e-a032-e6918d8755a8",["D",1788432448946],"/** @jsxImportSource npm:hono@4/jsx */\nimport type { Artifact } from \"../backend/db.ts\";\n\nexport function Viewer(props: { artifact?: Artifact; notFound?: boolean }) {\n if (props.notFound || !props.artifact) {\n return (\n

\n That artifact doesn't exist.{\" \"}\n Back to artifacts\n

\n );\n }\n const a = props.artifact;\n return (\n

\n \n ← all\n \n \n {a.name}\n \n \n by {a.createdBy}\n \n

\n \n

\n );\n}\n",[],[75,105],"d79fab4b-b305-4cab-9d63-0e7e5a37cdbf","Layout.tsx","01a066e1-7df8-761e-a032-e31e51ccccc5",["D",1788432448946],"/** @jsxImportSource npm:hono@4/jsx */\n\nexport function Layout(\n props: { title: string; bare?: boolean; children: any },\n) {\n return (\n \n \n \n \n {props.title}\n \n \n \n \n {props.bare ? props.children : (\n

\n {props.children}\n

\n )}\n \n \n );\n}\n\nfunction Footer() {\n return (\n \n );\n}\n",[],[75,112],"8770cbbe-e2dd-4cea-ac99-566783dd42af","Landing.tsx","01a066e1-7df8-761e-a032-de310a0ce75d",["D",1788432448946],"/** @jsxImportSource npm:hono@4/jsx */\n\nexport function Landing(props: { org: string }) {\n return (\n

\n \n Built for{\" \"}\n @{props.org}\n

\n Artifacts\n

\n A simple place to host and share HTML pages and Markdown docs. Drop in an{\" \"}\n \n .html\n {\" \"}\n or{\" \"}\n \n .md\n {\" \"}\n file and get a link you can share.\n

\n\n

\n \n Open artifacts\n \n

\n\n

\n \n \n \n

\n );\n}\n\nfunction Feature(props: { title: string; body: string }) {\n return (\n

{props.title}

{props.body}

\n );\n}\n",[],[75,119],"a7612886-7f8f-4490-a40a-814bc6b7d8e6","Dashboard.tsx","01a066e1-7df8-761e-a032-db52561dbf5f",["D",1788432448946],"/** @jsxImportSource npm:hono@4/jsx */\nimport type { Artifact } from \"../backend/db.ts\";\n\nexport function Dashboard(\n props: { org: string; artifacts: Artifact[]; readOnly?: boolean },\n) {\n const count = props.artifacts.length;\n return (\n

\n Artifacts\n

\n @{props.org} · {count} {count === 1 ? \"page\" : \"pages\"}\n

\n \n about\n \n

\n\n {props.readOnly && (\n

\n Note:{\" \"}\n for this demo, uploads are not enabled. When you remix this val, your\n team will be able to upload / rename / delete artifacts!\n

\n )}\n\n \n \n

\n Drop an HTML or Markdown file here\n

\n .html or .md · or click to choose · published instantly\n

\n \n\n {count === 0\n ? (\n

\n No artifacts yet. Drop an HTML or Markdown file above to create your\n first one.\n

\n )\n : (\n

\n ))}\n

\n )}\n\n {!props.readOnly && (\n \n )}\n

\n );\n}\n\nfunction Row(props: { a: Artifact; readOnly?: boolean }) {\n const a = props.a;\n return (\n

\n \n

\n {a.name}\n \n {a.kind === \"md\" ? \"MD\" : \"HTML\"}\n \n

\n by {a.createdBy} · /a/{a.id}\n

\n \n

\n \n open\n \n {props.readOnly\n ? (\n <>\n \n rename\n \n \n delete\n \n \n )\n : (\n <>\n

\n rename\n

\n \n \n \n save\n \n \n

\n \n \n delete\n \n \n \n )}\n

\n );\n}",[],[75,126],"2c726ff0-91cf-45d6-8074-ad59f1565f49","examples","01a066e1-7df8-761e-a032-d4d9bce1e62f",["D",1788432448946],[138,139,140],[133],{"_33":155,"_13":156,"_35":157,"_37":134,"_38":39,"_40":46,"_42":43,"_44":158,"_17":78,"_47":24,"_48":159,"_50":51,"_52":-5,"_68":160,"_18":161},{"_33":148,"_13":149,"_35":150,"_37":134,"_38":39,"_40":46,"_42":43,"_44":151,"_17":78,"_47":24,"_48":152,"_50":51,"_52":-5,"_68":153,"_18":154},{"_33":141,"_13":142,"_35":143,"_37":134,"_38":39,"_40":46,"_42":43,"_44":144,"_17":78,"_47":24,"_48":145,"_50":51,"_52":-5,"_68":146,"_18":147},"6ae1df25-f6f4-47f4-b67e-c7094d2ab9e4","welcome.html","01a066e1-7df8-761e-a032-d10f6930e591",["D",1788432448946],"\n\n\n \n \n Welcome\n \n\n\n

👋 This is an artifact

It's a single HTML file, hosted and shared from Val Town.

Make your own by dragging an .html file onto the dashboard.

\n\n\n",[],[133,142],"d993d5a1-eeb4-471b-b473-8a59cce1eae6","markdown-demo.md","01a066e1-7df8-761e-a032-cc4458efebf1",["D",1788432448946],"# Welcome to Team Artifacts\n\nThis is a **Markdown** artifact. Drop a `.md` file on the dashboard and it\nrenders as a clean, readable page — no build step, no HTML required.\n\n## What renders\n\n- **Bold**, _italic_, and `inline code`\n- Lists, like this one\n- [Links](https://val.town) to anywhere\n- Tables, quotes, and fenced code blocks\n\n```ts\n// Code blocks get monospace styling.\nexport function hello(name: string) {\n return `Hi, ${name}!`;\n}\n```\n\n> Markdown artifacts render in the same sandboxed iframe as HTML ones, so the\n> security model is identical.\n\n| Format | Extension | Rendered as |\n| ------ | -------------- | ------------------------ |\n| HTML | `.html` | served as-is |\n| Markdown | `.md` / `.markdown` | converted to HTML |\n\nDelete this example whenever you like — it won't come back.\n",[],[133,149],"983df801-8bbc-4559-b10a-63b131f2fc56","live-clock.html","01a066e1-7df8-761e-a032-cb545ff9fcea",["D",1788432448946],"\n\n\n \n \n Live clock\n \n\n\n

--:--:--

This artifact runs JavaScript — inside a sandboxed frame.

\n \n

\n \n\n\n",[],[133,156],"4f360e5f-28ee-445f-9fdf-17ceb6edb283","backend","01a066e1-7df8-761e-a032-c6be217dfed8",["D",1788432448946],[168,169,170],[163],{"_33":185,"_13":186,"_35":187,"_37":164,"_38":39,"_40":46,"_42":43,"_44":188,"_17":78,"_47":92,"_48":189,"_50":51,"_52":-5,"_68":190,"_18":191},{"_33":178,"_13":179,"_35":180,"_37":164,"_38":39,"_40":46,"_42":43,"_44":181,"_17":78,"_47":92,"_48":182,"_50":51,"_52":-5,"_68":183,"_18":184},{"_33":171,"_13":172,"_35":173,"_37":164,"_38":39,"_40":64,"_42":43,"_44":174,"_17":78,"_47":92,"_48":175,"_50":51,"_52":-5,"_68":176,"_18":177},"629e20a4-4423-4d41-a103-084833ef3b3c","team.ts","13742970-a785-11f1-8ed6-1607ee4eb77e",["D",1788432542396],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Shared team board storage. Each team code maps to a list of members and\n// their top roles. Anyone who knows a team code can read/write that board —\n// it's a lightweight shared doc, not a secure system.\n\nconst TABLE = \"team_members\";\n\nlet ready: Promise | null = null;\n\nexport function initTeamDb(): Promise {\n if (!ready) ready = setup();\n return ready;\n}\n\nasync function setup() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n code TEXT NOT NULL,\n name TEXT NOT NULL,\n roles TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n PRIMARY KEY (code, name)\n )`,\n );\n}\n\nexport type TeamMember = { name: string; topRoles: string[] };\n\nexport async function getTeam(code: string): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT name, roles FROM ${TABLE} WHERE code = ? ORDER BY created_at ASC, name ASC`,\n args: [code],\n });\n return rows.map((r: any) => ({\n name: r.name as string,\n topRoles: JSON.parse(r.roles as string),\n }));\n}\n\n/** Add (or replace) a member on a team board. Returns the updated board. */\nexport async function upsertMember(\n code: string,\n name: string,\n topRoles: string[],\n): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (code, name, roles, created_at) VALUES (?, ?, ?, ?)\n ON CONFLICT(code, name) DO UPDATE SET roles = excluded.roles, created_at = excluded.created_at`,\n args: [code, name, JSON.stringify(topRoles), Date.now()],\n });\n return getTeam(code);\n}\n",[],[163,172],"e988119c-7bec-48bd-912b-d7173beec6e0","render.ts","01a066e1-7df8-761e-a032-c011fa3c1f8d",["D",1788432448946],"import { marked } from \"npm:marked@12\";\nimport type { Artifact } from \"./db.ts\";\n\n// Minimal GitHub-ish styling so a bare Markdown doc reads nicely inside the\n// sandboxed iframe. The artifact still renders with an opaque origin (see the\n// CSP/sandbox in main.tsx), so this HTML is treated as untrusted either way.\nconst MD_STYLES = `\n :root { color-scheme: light dark; }\n body {\n font: 16px/1.6 -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Helvetica, Arial, sans-serif;\n max-width: 760px;\n margin: 0 auto;\n padding: 2.5rem 1.25rem 4rem;\n color: #1f2328;\n }\n h1, h2 { border-bottom: 1px solid #d1d9e0; padding-bottom: .3em; }\n h1, h2, h3, h4 { margin-top: 1.6em; line-height: 1.25; }\n a { color: #0969da; }\n code {\n background: rgba(129,139,152,.16);\n padding: .2em .4em;\n border-radius: 6px;\n font-size: 85%;\n }\n pre {\n background: #f6f8fa;\n padding: 1rem;\n border-radius: 8px;\n overflow: auto;\n }\n pre code { background: none; padding: 0; font-size: 100%; }\n blockquote {\n margin: 0;\n padding: 0 1em;\n color: #59636e;\n border-left: .25em solid #d1d9e0;\n }\n table { border-collapse: collapse; }\n th, td { border: 1px solid #d1d9e0; padding: 6px 13px; }\n img { max-width: 100%; }\n @media (prefers-color-scheme: dark) {\n body { color: #e6edf3; }\n h1, h2 { border-color: #3d444d; }\n a { color: #4493f8; }\n pre { background: #161b22; }\n blockquote { color: #9198a1; border-color: #3d444d; }\n th, td { border-color: #3d444d; }\n }\n`;\n\n/** The HTML to serve for an artifact, given its kind. */\nexport function renderArtifact(artifact: Artifact): string {\n if (artifact.kind !== \"md\") return artifact.html;\n const body = marked.parse(artifact.html, { gfm: true, breaks: false });\n const title = escapeHtml(artifact.name);\n return `\n\n\n\n\n${title}\n\n\n${body}\n`;\n}\n\nfunction escapeHtml(s: string): string {\n return s.replace(/[&<>\"]/g, (c) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[c]!));\n}\n",[],[163,179],"8bd92650-5f56-4460-a2fb-dad48cb05c1a","db.ts","01a066e1-7df8-761e-a032-be855bc7105f",["D",1788432448946],"import { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { listFiles, readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n/** How the stored source should be rendered when viewed. */\nexport type ArtifactKind = \"html\" | \"md\";\n\nexport type Artifact = {\n id: string;\n name: string;\n /** Raw uploaded source, loaded from blob storage when fetching one artifact. */\n html: string;\n kind: ArtifactKind;\n createdBy: string;\n createdAt: number;\n};\n\nconst TABLE = \"artifacts_v2\";\nconst META = \"artifacts_meta_v1\";\nconst BLOB_PREFIX = \"artifacts/\";\n\nlet ready: Promise | null = null;\n\n/** Idempotent: creates storage and seeds examples once. */\nexport function initDb(): Promise {\n if (!ready) ready = setup();\n return ready;\n}\n\nasync function setup() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n blob_key TEXT NOT NULL UNIQUE,\n kind TEXT NOT NULL DEFAULT 'html',\n created_by TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${META} (key TEXT PRIMARY KEY, value TEXT NOT NULL)`,\n );\n await seedExamples();\n}\n\n// Seed example artifacts exactly once. Deterministic ids plus INSERT OR IGNORE\n// make concurrent cold starts safe.\nasync function seedExamples() {\n const seen = await sqlite.execute(`SELECT 1 FROM ${META} WHERE key = 'seeded'`);\n if (seen.rows.length) return;\n\n const files = await listFiles();\n const examples = files\n .filter((f: any) =>\n f.type === \"file\" && f.path.startsWith(\"examples/\") &&\n /\\.(html?|md|markdown)$/i.test(f.path)\n )\n .map((f: any) => f.path as string)\n .sort();\n\n for (const path of examples) {\n const source = await readFile(path);\n const kind: ArtifactKind = /\\.(md|markdown)$/i.test(path) ? \"md\" : \"html\";\n const name = path.replace(/^examples\\//, \"\").replace(/\\.(html?|md|markdown)$/i, \"\");\n const id = kind === \"md\" ? `ex_${name}_md` : `ex_${name}`;\n await storeArtifact({\n id,\n name,\n html: source,\n kind,\n createdBy: \"example\",\n createdAt: Date.now(),\n });\n }\n\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO ${META} (key, value) VALUES ('seeded', ?)`,\n args: [String(Date.now())],\n });\n}\n\nfunction newId() {\n return crypto.randomUUID().replace(/-/g, \"\").slice(0, 12);\n}\n\nfunction artifactKey(id: string, kind: ArtifactKind) {\n return `${BLOB_PREFIX}${id}.${kind === \"md\" ? \"md\" : \"html\"}`;\n}\n\nasync function storeArtifact(\n input: {\n id: string;\n name: string;\n html: string;\n kind: ArtifactKind;\n createdBy: string;\n createdAt: number;\n },\n) {\n const blobKey = artifactKey(input.id, input.kind);\n await blob.set(blobKey, input.html);\n try {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${TABLE} (id, name, blob_key, kind, created_by, created_at) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n input.id,\n input.name,\n blobKey,\n input.kind,\n input.createdBy,\n input.createdAt,\n ],\n });\n } catch (error) {\n await blob.delete(blobKey);\n throw error;\n }\n}\n\nexport async function createArtifact(\n input: {\n name: string;\n html: string;\n kind: ArtifactKind;\n createdBy: string;\n },\n): Promise {\n const id = newId();\n await storeArtifact({ ...input, id, createdAt: Date.now() });\n return id;\n}\n\n/** List metadata only; artifact bodies stay in blob storage. */\nexport async function listArtifacts(): Promise {\n const { rows } = await sqlite.execute(\n `SELECT id, name, kind, created_by, created_at FROM ${TABLE} ORDER BY created_at DESC`,\n );\n return rows.map(toArtifact);\n}\n\nexport async function getArtifact(id: string): Promise {\n const { rows } = await sqlite.execute({\n sql:\n `SELECT id, name, blob_key, kind, created_by, created_at FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n if (!rows.length) return null;\n const artifact = toArtifact(rows[0]);\n const source = await blob.get(rows[0].blob_key as string);\n return { ...artifact, html: await source.text() };\n}\n\nexport async function renameArtifact(id: string, name: string): Promise {\n const result = await sqlite.execute({\n sql: `UPDATE ${TABLE} SET name = ? WHERE id = ?`,\n args: [name, id],\n });\n return result.rowsAffected > 0;\n}\n\nexport async function deleteArtifact(id: string): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT blob_key FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n if (!rows.length) return;\n await blob.delete(rows[0].blob_key as string);\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n}\n\nfunction toArtifact(r: any): Artifact {\n return {\n id: r.id as string,\n name: r.name as string,\n html: \"\",\n kind: (r.kind as ArtifactKind) ?? \"html\",\n createdBy: r.created_by as string,\n createdAt: Number(r.created_at),\n };\n}\n",[],[163,186],"9706f9f2-5cac-4473-bb36-bb26af88b0fc",["D",1788432448946],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Host the \"How You Work\" team role quiz with a shareable link","imageUrl","userId","d6e7b121-513b-4c7e-9bc4-2bae13250f4a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a066df-91b2-72c9-9ecb-95c06a6c84f8","tursoName","9706f9f25cac4473bb36bb26af88b0fc","tursoHostname","9706f9f25cac4473bb36bb26af88b0fc-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789650647385],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_249":245},"org",{"_11":12,"_242":243,"_244":245,"_202":203,"_246":247,"_248":51},"branch",{"_17":41,"_13":16,"_33":39,"_234":192,"_235":-5,"_236":-5,"_237":-5,"_238":-5,"_239":-5,"_240":14,"_241":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Sarah Scanzoni","avatar","https://lh3.googleusercontent.com/a/ACg8ocI6PlKwyCqdfezzK44AF2Ebqjcz_1wFT9ezGOuJZjgWdX_5MlKTig=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":192,"_13":14,"_44":333,"_194":-5,"_195":51,"_196":197,"_198":197,"_199":200,"_201":-5,"_202":203,"_204":61,"_205":43,"_206":-5,"_207":-5,"_208":78,"_209":210,"_211":212,"_213":214,"_215":334,"_217":-5,"_218":219,"_220":219,"_221":222,"_223":222,"_224":222,"_225":219,"_226":219,"_227":335,"_229":336,"_231":337,"_233":51},[282,286,290,297,298],"files",[282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298],"counts",{"_273":78,"_274":46,"_275":78,"_32":276,"_277":278},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":272},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[269],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":270,"_271":-5},"8c942a2d-96d9-4eb3-ad02-c3d0a48b2266","reporterId",[19],"pulls","branches","forks",{"_279":78,"_281":78},"connections",{"_279":78,"_280":78},"count","unfilledCount","emptyCount",{"_33":162,"_13":163,"_35":164,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":165,"_17":78,"_47":79,"_48":-5,"_50":51,"_52":-5,"_68":331,"_18":332},{"_33":185,"_13":186,"_35":187,"_37":164,"_38":39,"_40":46,"_42":43,"_44":188,"_17":78,"_47":92,"_48":189,"_50":51,"_52":-5,"_68":329,"_18":330},{"_33":178,"_13":179,"_35":180,"_37":164,"_38":39,"_40":46,"_42":43,"_44":181,"_17":78,"_47":92,"_48":182,"_50":51,"_52":-5,"_68":327,"_18":328},{"_33":171,"_13":172,"_35":173,"_37":164,"_38":39,"_40":64,"_42":43,"_44":174,"_17":78,"_47":92,"_48":175,"_50":51,"_52":-5,"_68":325,"_18":326},{"_33":132,"_13":133,"_35":134,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":135,"_17":78,"_47":79,"_48":-5,"_50":51,"_52":-5,"_68":323,"_18":324},{"_33":155,"_13":156,"_35":157,"_37":134,"_38":39,"_40":46,"_42":43,"_44":158,"_17":78,"_47":24,"_48":159,"_50":51,"_52":-5,"_68":321,"_18":322},{"_33":148,"_13":149,"_35":150,"_37":134,"_38":39,"_40":46,"_42":43,"_44":151,"_17":78,"_47":24,"_48":152,"_50":51,"_52":-5,"_68":319,"_18":320},{"_33":141,"_13":142,"_35":143,"_37":134,"_38":39,"_40":46,"_42":43,"_44":144,"_17":78,"_47":24,"_48":145,"_50":51,"_52":-5,"_68":317,"_18":318},{"_33":74,"_13":75,"_35":76,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":77,"_17":78,"_47":79,"_48":-5,"_50":51,"_52":-5,"_68":315,"_18":316},{"_33":125,"_13":126,"_35":127,"_37":76,"_38":39,"_40":46,"_42":43,"_44":128,"_17":78,"_47":92,"_48":129,"_50":51,"_52":-5,"_68":313,"_18":314},{"_33":118,"_13":119,"_35":120,"_37":76,"_38":39,"_40":46,"_42":43,"_44":121,"_17":78,"_47":92,"_48":122,"_50":51,"_52":-5,"_68":311,"_18":312},{"_33":111,"_13":112,"_35":113,"_37":76,"_38":39,"_40":46,"_42":43,"_44":114,"_17":78,"_47":92,"_48":115,"_50":51,"_52":-5,"_68":309,"_18":310},{"_33":104,"_13":105,"_35":106,"_37":76,"_38":39,"_40":46,"_42":43,"_44":107,"_17":78,"_47":92,"_48":108,"_50":51,"_52":-5,"_68":307,"_18":308},{"_33":96,"_13":97,"_35":98,"_37":76,"_38":39,"_40":99,"_42":43,"_44":100,"_17":78,"_47":24,"_48":101,"_50":51,"_52":-5,"_68":305,"_18":306},{"_33":88,"_13":89,"_35":90,"_37":76,"_38":39,"_40":46,"_42":43,"_44":91,"_17":78,"_47":92,"_48":93,"_50":51,"_52":-5,"_68":303,"_18":304},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":71,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_68":301,"_18":302},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":65,"_48":66,"_50":51,"_52":67,"_68":299,"_18":300},[],[60],[],[19],[],[75,89],[],[75,97],[],[75,105],[],[75,112],[],[75,119],[],[75,126],[291,292,293,294,295,296],[75],[],[133,142],[],[133,149],[],[133,156],[287,288,289],[133],[],[163,172],[],[163,179],[],[163,186],[283,284,285],[163],["D",1788432448946],["D",1789650647385],{"_11":12,"_249":245},{"_11":12,"_242":243,"_244":245,"_202":203,"_246":247,"_248":51},{"_17":41,"_13":16,"_33":39,"_234":192,"_235":-5,"_236":-5,"_237":-5,"_238":-5,"_239":-5,"_240":14,"_241":12},"ctx",{"_227":-5,"_266":371,"_372":373,"_374":375,"_376":51,"_377":51,"_378":51,"_379":43,"_380":-5,"_381":-7,"_382":-7,"_383":78,"_384":51,"_385":51,"_386":-5,"_387":51,"_388":51,"_389":51,"_390":-5},"ENV",{"_342":343,"_344":345,"_346":16,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]