[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_339":340,"_341":342},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_251":-5,"_20":252,"_22":253,"_254":255,"_256":257,"_26":258,"_24":259,"_260":-5,"_261":-5,"_262":53,"_263":264,"_265":45,"_266":-5,"_267":-5,"_268":269},"routes/_app.x.$handle.$name.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","frontend/quiz.html","project",{"_33":193,"_13":14,"_46":194,"_195":-5,"_196":53,"_197":198,"_199":198,"_200":201,"_202":-5,"_203":204,"_205":64,"_206":45,"_207":-5,"_208":-5,"_209":48,"_210":211,"_212":213,"_214":215,"_216":217,"_218":-5,"_219":220,"_221":220,"_222":223,"_224":223,"_225":223,"_226":220,"_227":220,"_228":229,"_230":231,"_232":233,"_234":53},"tree",[57,58,59,60,61],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":55},"contents",[],"upstream","pull","ahead","behind","envVars","id","263b91da-9cbf-4b24-8ec5-cfe550af4653","quiz.html","fileId","07636fe2-a785-11f1-abaf-1607ee4eb77e","parentId","01a066e1-7df8-761e-a032-ed0a31d367a2","branchId","3da4bec3-f115-40ba-b376-ae10ca676677","branchVersion",2,"latest",true,"createdAt",["D",1788432522155],0,"fileType","content","\n\n\n\n\nHow You Work — Discover Your Team Role\n\n\n\n\n\n

\n\n\n\n\n","deleted",false,"label",[56,35],"frontend",{"_33":163,"_13":164,"_36":165,"_38":-5,"_40":41,"_42":79,"_44":45,"_46":166,"_17":48,"_49":85,"_50":-5,"_52":53,"_54":-5,"_71":167,"_18":168},{"_33":133,"_13":134,"_36":135,"_38":-5,"_40":41,"_42":79,"_44":45,"_46":136,"_17":48,"_49":85,"_50":-5,"_52":53,"_54":-5,"_71":137,"_18":138},{"_33":83,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":79,"_44":45,"_46":84,"_17":48,"_49":85,"_50":-5,"_52":53,"_54":-5,"_71":86,"_18":87},{"_33":74,"_13":75,"_36":76,"_38":-5,"_40":41,"_42":77,"_44":45,"_46":78,"_17":79,"_49":24,"_50":80,"_52":53,"_54":-5,"_71":81,"_18":82},{"_33":62,"_13":63,"_36":64,"_38":-5,"_40":41,"_42":65,"_44":45,"_46":66,"_17":67,"_49":68,"_50":69,"_52":53,"_54":70,"_71":72,"_18":73},"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",[],[63],"d0c018d2-c131-41aa-accd-7e27d6f25389","README.md","01a066e1-7df8-761e-a032-f0040755d6a2",7,["D",1788432591989],1,"# 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",[],[75],"155fa63a-6c29-4628-a28f-bd81a3231a71",["D",1788432448946],"directory",[88,89,90,91,92,93],[56],{"_33":126,"_13":127,"_36":128,"_38":39,"_40":41,"_42":79,"_44":45,"_46":129,"_17":48,"_49":98,"_50":130,"_52":53,"_54":-5,"_71":131,"_18":132},{"_33":119,"_13":120,"_36":121,"_38":39,"_40":41,"_42":79,"_44":45,"_46":122,"_17":48,"_49":98,"_50":123,"_52":53,"_54":-5,"_71":124,"_18":125},{"_33":112,"_13":113,"_36":114,"_38":39,"_40":41,"_42":79,"_44":45,"_46":115,"_17":48,"_49":98,"_50":116,"_52":53,"_54":-5,"_71":117,"_18":118},{"_33":105,"_13":106,"_36":107,"_38":39,"_40":41,"_42":79,"_44":45,"_46":108,"_17":48,"_49":98,"_50":109,"_52":53,"_54":-5,"_71":110,"_18":111},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":102,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_71":103,"_18":104},{"_33":94,"_13":95,"_36":96,"_38":39,"_40":41,"_42":79,"_44":45,"_46":97,"_17":48,"_49":98,"_50":99,"_52":53,"_54":-5,"_71":100,"_18":101},"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",[],[56,95],["D",1788432522155],[],[56,35],"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",[],[56,106],"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",[],[56,113],"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",[],[56,120],"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}",[],[56,127],"2c726ff0-91cf-45d6-8074-ad59f1565f49","examples","01a066e1-7df8-761e-a032-d4d9bce1e62f",["D",1788432448946],[139,140,141],[134],{"_33":156,"_13":157,"_36":158,"_38":135,"_40":41,"_42":79,"_44":45,"_46":159,"_17":48,"_49":24,"_50":160,"_52":53,"_54":-5,"_71":161,"_18":162},{"_33":149,"_13":150,"_36":151,"_38":135,"_40":41,"_42":79,"_44":45,"_46":152,"_17":48,"_49":24,"_50":153,"_52":53,"_54":-5,"_71":154,"_18":155},{"_33":142,"_13":143,"_36":144,"_38":135,"_40":41,"_42":79,"_44":45,"_46":145,"_17":48,"_49":24,"_50":146,"_52":53,"_54":-5,"_71":147,"_18":148},"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",[],[134,143],"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",[],[134,150],"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",[],[134,157],"4f360e5f-28ee-445f-9fdf-17ceb6edb283","backend","01a066e1-7df8-761e-a032-c6be217dfed8",["D",1788432448946],[169,170,171],[164],{"_33":186,"_13":187,"_36":188,"_38":165,"_40":41,"_42":79,"_44":45,"_46":189,"_17":48,"_49":98,"_50":190,"_52":53,"_54":-5,"_71":191,"_18":192},{"_33":179,"_13":180,"_36":181,"_38":165,"_40":41,"_42":79,"_44":45,"_46":182,"_17":48,"_49":98,"_50":183,"_52":53,"_54":-5,"_71":184,"_18":185},{"_33":172,"_13":173,"_36":174,"_38":165,"_40":41,"_42":67,"_44":45,"_46":175,"_17":48,"_49":98,"_50":176,"_52":53,"_54":-5,"_71":177,"_18":178},"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",[],[164,173],"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",[],[164,180],"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",[],[164,187],"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,"_250":246},"org",{"_11":12,"_243":244,"_245":246,"_203":204,"_247":248,"_249":53},"branch",{"_17":77,"_13":16,"_33":41,"_235":193,"_236":-5,"_237":-5,"_238":-5,"_239":-5,"_240":-5,"_241":14,"_242":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":193,"_13":14,"_46":334,"_195":-5,"_196":53,"_197":198,"_199":198,"_200":201,"_202":-5,"_203":204,"_205":64,"_206":45,"_207":-5,"_208":-5,"_209":48,"_210":211,"_212":213,"_214":215,"_216":335,"_218":-5,"_219":220,"_221":220,"_222":223,"_224":223,"_225":223,"_226":220,"_227":220,"_228":336,"_230":337,"_232":338,"_234":53},[283,287,291,298,299],"files",[283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299],"counts",{"_274":48,"_275":79,"_276":48,"_32":277,"_278":279},[],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":273},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[270],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":271,"_272":-5},"8c942a2d-96d9-4eb3-ad02-c3d0a48b2266","reporterId",[56,35],"pulls","branches","forks",{"_280":48,"_282":48},"connections",{"_280":48,"_281":48},"count","unfilledCount","emptyCount",{"_33":163,"_13":164,"_36":165,"_38":-5,"_40":41,"_42":79,"_44":45,"_46":166,"_17":48,"_49":85,"_50":-5,"_52":53,"_54":-5,"_71":332,"_18":333},{"_33":186,"_13":187,"_36":188,"_38":165,"_40":41,"_42":79,"_44":45,"_46":189,"_17":48,"_49":98,"_50":190,"_52":53,"_54":-5,"_71":330,"_18":331},{"_33":179,"_13":180,"_36":181,"_38":165,"_40":41,"_42":79,"_44":45,"_46":182,"_17":48,"_49":98,"_50":183,"_52":53,"_54":-5,"_71":328,"_18":329},{"_33":172,"_13":173,"_36":174,"_38":165,"_40":41,"_42":67,"_44":45,"_46":175,"_17":48,"_49":98,"_50":176,"_52":53,"_54":-5,"_71":326,"_18":327},{"_33":133,"_13":134,"_36":135,"_38":-5,"_40":41,"_42":79,"_44":45,"_46":136,"_17":48,"_49":85,"_50":-5,"_52":53,"_54":-5,"_71":324,"_18":325},{"_33":156,"_13":157,"_36":158,"_38":135,"_40":41,"_42":79,"_44":45,"_46":159,"_17":48,"_49":24,"_50":160,"_52":53,"_54":-5,"_71":322,"_18":323},{"_33":149,"_13":150,"_36":151,"_38":135,"_40":41,"_42":79,"_44":45,"_46":152,"_17":48,"_49":24,"_50":153,"_52":53,"_54":-5,"_71":320,"_18":321},{"_33":142,"_13":143,"_36":144,"_38":135,"_40":41,"_42":79,"_44":45,"_46":145,"_17":48,"_49":24,"_50":146,"_52":53,"_54":-5,"_71":318,"_18":319},{"_33":83,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":79,"_44":45,"_46":84,"_17":48,"_49":85,"_50":-5,"_52":53,"_54":-5,"_71":316,"_18":317},{"_33":126,"_13":127,"_36":128,"_38":39,"_40":41,"_42":79,"_44":45,"_46":129,"_17":48,"_49":98,"_50":130,"_52":53,"_54":-5,"_71":314,"_18":315},{"_33":119,"_13":120,"_36":121,"_38":39,"_40":41,"_42":79,"_44":45,"_46":122,"_17":48,"_49":98,"_50":123,"_52":53,"_54":-5,"_71":312,"_18":313},{"_33":112,"_13":113,"_36":114,"_38":39,"_40":41,"_42":79,"_44":45,"_46":115,"_17":48,"_49":98,"_50":116,"_52":53,"_54":-5,"_71":310,"_18":311},{"_33":105,"_13":106,"_36":107,"_38":39,"_40":41,"_42":79,"_44":45,"_46":108,"_17":48,"_49":98,"_50":109,"_52":53,"_54":-5,"_71":308,"_18":309},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":102,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_71":306,"_18":307},{"_33":94,"_13":95,"_36":96,"_38":39,"_40":41,"_42":79,"_44":45,"_46":97,"_17":48,"_49":98,"_50":99,"_52":53,"_54":-5,"_71":304,"_18":305},{"_33":74,"_13":75,"_36":76,"_38":-5,"_40":41,"_42":77,"_44":45,"_46":78,"_17":79,"_49":24,"_50":80,"_52":53,"_54":-5,"_71":302,"_18":303},{"_33":62,"_13":63,"_36":64,"_38":-5,"_40":41,"_42":65,"_44":45,"_46":66,"_17":67,"_49":68,"_50":69,"_52":53,"_54":70,"_71":300,"_18":301},[],[63],[],[75],[],[56,95],[],[56,35],[],[56,106],[],[56,113],[],[56,120],[],[56,127],[292,293,294,295,296,297],[56],[],[134,143],[],[134,150],[],[134,157],[288,289,290],[134],[],[164,173],[],[164,180],[],[164,187],[284,285,286],[164],["D",1788432448946],["D",1789650647385],{"_11":12,"_250":246},{"_11":12,"_243":244,"_245":246,"_203":204,"_247":248,"_249":53},{"_17":77,"_13":16,"_33":41,"_235":193,"_236":-5,"_237":-5,"_238":-5,"_239":-5,"_240":-5,"_241":14,"_242":12},"ctx",{"_228":-5,"_267":372,"_373":374,"_375":376,"_377":53,"_378":53,"_379":53,"_380":45,"_381":-5,"_382":-7,"_383":-7,"_384":48,"_385":53,"_386":53,"_387":-5,"_388":53,"_389":53,"_390":53,"_391":-5},"ENV",{"_343":344,"_345":346,"_347":16,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]