Play Studio — Facilitator

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":120,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","e7cab1d2-1b15-11f1-bf84-42dde27851f2","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ── DB setup — runs once on cold start ───────────────────────────────────────\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS brainstorm_session (\n id INTEGER PRIMARY KEY,\n phase TEXT DEFAULT 'waiting',\n prompt TEXT DEFAULT '',\n total_seconds INTEGER DEFAULT 300,\n started_at INTEGER DEFAULT 0\n )\n`);\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS brainstorm_ideas (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n session_id INTEGER,\n name TEXT,\n idea TEXT,\n submitted_at INTEGER\n )\n`);\nawait sqlite.execute(\n `INSERT OR IGNORE INTO brainstorm_session (id) VALUES (1)`,\n);\n\nasync function getSession() {\n const r = await sqlite.execute(\n `SELECT * FROM brainstorm_session WHERE id = 1`,\n );\n const row = r.rows[0] as any;\n let remaining = 0;\n const total = Number(row.total_seconds);\n if (row.phase === \"active\" && Number(row.started_at) > 0) {\n const elapsed = Math.floor((Date.now() - Number(row.started_at)) / 1000);\n remaining = Math.max(0, total - elapsed);\n }\n return {\n phase: String(row.phase),\n prompt: String(row.prompt),\n totalSeconds: total,\n remaining,\n };\n}\n\nasync function getIdeas() {\n const r = await sqlite.execute(\n `SELECT name, idea FROM brainstorm_ideas WHERE session_id = 1 ORDER BY name, submitted_at`,\n );\n const grouped: Record = {};\n for (const row of r.rows as any[]) {\n if (!grouped[row.name]) grouped[row.name] = [];\n grouped[row.name].push(row.idea);\n }\n return grouped;\n}\n\nasync function getSubmittedNames() {\n const r = await sqlite.execute(\n `SELECT DISTINCT name FROM brainstorm_ideas WHERE session_id = 1`,\n );\n return (r.rows as any[]).map((r) => String(r.name));\n}\n\n// ── Styles ────────────────────────────────────────────────────────────────────\nconst STYLES = ``;\n\n// ── Pages ─────────────────────────────────────────────────────────────────────\nfunction facilitatorPage(origin: string) {\n const participantUrl = origin + \"/\";\n return `\n\nPlay Studio — Facilitator${STYLES}\n

Play Studio — Facilitator View

Set up your brainstorm

The prompt

\n \n

Time (minutes)

\n \n

Share this with participants

\n \n

They open this on their phone — you control everything from here

\n \n

05:00

Submitted so far

Waiting for participants…

\n \n \n

\n \n

⛶ Fullscreen

\n`;\n}\n\nfunction participantPage() {\n return `\n\nPlay Studio — Brainstorm${STYLES}\n

Play Studio

Waiting for the session to start…

Your facilitator will begin shortly

05:00

Your name

\n \n

Your ideas — private until the reveal

\n \n

✓

Ideas submitted!

Sit tight — the facilitator will reveal everything soon

\n \n

Ideas are being revealed!

Look at the main screen

\n`;\n}\n\n// ── Main handler ──────────────────────────────────────────────────────────────\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n const origin = url.origin;\n\n if (path === \"/api/state\") {\n const [session, ideas, submittedNames] = await Promise.all([\n getSession(),\n getIdeas(),\n getSubmittedNames(),\n ]);\n return Response.json({ session, ideas, submittedNames });\n }\n\n if (path === \"/api/start\" && req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON\" }, { status: 400 });\n }\n const prompt = String(body.prompt || \"\").trim();\n const minutes = Number(body.minutes) || 5;\n if (!prompt) {\n return Response.json({ error: \"Prompt required\" }, { status: 400 });\n }\n const totalSeconds = minutes * 60;\n await sqlite.execute(`DELETE FROM brainstorm_ideas WHERE session_id = 1`);\n await sqlite.execute(\n `UPDATE brainstorm_session SET phase='active', prompt=?, total_seconds=?, started_at=? WHERE id=1`,\n [prompt, totalSeconds, Date.now()],\n );\n return Response.json({ ok: true });\n }\n\n if (path === \"/api/reveal\" && req.method === \"POST\") {\n await sqlite.execute(\n `UPDATE brainstorm_session SET phase='revealed' WHERE id=1`,\n );\n return Response.json({ ok: true });\n }\n\n if (path === \"/api/reset\" && req.method === \"POST\") {\n await sqlite.execute(`DELETE FROM brainstorm_ideas WHERE session_id = 1`);\n await sqlite.execute(\n `UPDATE brainstorm_session SET phase='waiting', prompt='', total_seconds=300, started_at=0 WHERE id=1`,\n );\n return Response.json({ ok: true });\n }\n\n if (path === \"/api/submit\" && req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON\" }, { status: 400 });\n }\n const name = String(body.name || \"Anonymous\").trim() || \"Anonymous\";\n const ideas = (body.ideas || []).map((i: any) => String(i).trim()).filter(\n Boolean,\n );\n for (const idea of ideas) {\n await sqlite.execute(\n `INSERT INTO brainstorm_ideas (session_id, name, idea, submitted_at) VALUES (1,?,?,?)`,\n [name, idea, Date.now()],\n );\n }\n return Response.json({ ok: true });\n }\n\n if (path === \"/facilitator\") {\n return new Response(facilitatorPage(origin), {\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n }\n\n return new Response(participantPage(), {\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n}","import { blob } from \"https://esm.town/v/std/blob\";\n\n// ── Types ─────────────────────────────────────────────────────────────────────\ntype Session = {\n phase: \"waiting\" | \"active\" | \"revealed\";\n prompt: string;\n totalSeconds: number;\n startedAt: number;\n ideas: Record;\n};\n\nconst DEFAULT: Session = {\n phase: \"waiting\",\n prompt: \"\",\n totalSeconds: 300,\n startedAt: 0,\n ideas: {},\n};\n\nasync function getSession(): Promise {\n try {\n const s = await blob.getJSON(\"ps_session\");\n return s ?? DEFAULT;\n } catch {\n return DEFAULT;\n }\n}\n\nasync function saveSession(s: Session) {\n await blob.setJSON(\"ps_session\", s);\n}\n\nfunction getRemaining(s: Session): number {\n if (s.phase !== \"active\" || s.startedAt === 0) return s.totalSeconds;\n return Math.max(\n 0,\n s.totalSeconds - Math.floor((Date.now() - s.startedAt) / 1000),\n );\n}\n\n// ── Styles ────────────────────────────────────────────────────────────────────\nconst CSS = `\n`;\n\n// ── Pages ─────────────────────────────────────────────────────────────────────\nfunction facilitatorPage(origin: string) {\n const participantUrl = origin + \"/\";\n return `\n\nPlay Studio — Facilitator${CSS}\n

Play Studio — Facilitator View

Set up your brainstorm

The prompt

\n \n

Time (minutes)

\n \n

Share this with participants

\n \n

\n\n

05:00

Submitted so far

Waiting for participants…

\n \n \n

\n\n

\n \n

⛶ Fullscreen

\n`;\n}\n\nfunction participantPage() {\n return `\n\nPlay Studio — Brainstorm${CSS}\n

Play Studio

Waiting for the session to start…

Your facilitator will begin shortly

05:00

Your name

\n \n

Your ideas — private until the reveal

\n \n

✓

Ideas submitted!

Sit tight — the facilitator will reveal everything soon

\n \n

Ideas are being revealed!

Look at the main screen

\n`;\n}\n\n// ── Handler ───────────────────────────────────────────────────────────────────\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n const origin = url.origin;\n\n if (path === \"/api/state\") {\n const s = await getSession();\n return Response.json({\n session: {\n phase: s.phase,\n prompt: s.prompt,\n totalSeconds: s.totalSeconds,\n remaining: getRemaining(s),\n },\n ideas: s.ideas,\n submittedNames: Object.keys(s.ideas),\n });\n }\n\n if (path === \"/api/start\" && req.method === \"POST\") {\n const body = await req.json();\n const s: Session = {\n phase: \"active\",\n prompt: String(body.prompt || \"\").trim(),\n totalSeconds: Number(body.minutes || 5) * 60,\n startedAt: Date.now(),\n ideas: {},\n };\n await saveSession(s);\n return Response.json({ ok: true });\n }\n\n if (path === \"/api/reveal\" && req.method === \"POST\") {\n const s = await getSession();\n s.phase = \"revealed\";\n await saveSession(s);\n return Response.json({ ok: true });\n }\n\n if (path === \"/api/reset\" && req.method === \"POST\") {\n await saveSession({ ...DEFAULT });\n return Response.json({ ok: true });\n }\n\n if (path === \"/api/submit\" && req.method === \"POST\") {\n const body = await req.json();\n const name = String(body.name || \"Anonymous\").trim() || \"Anonymous\";\n const ideas = (body.ideas || []).map((i: any) => String(i).trim()).filter(\n Boolean,\n );\n const s = await getSession();\n if (s.phase === \"active\") {\n s.ideas[name] = ideas;\n await saveSession(s);\n }\n return Response.json({ ok: true });\n }\n\n if (path === \"/facilitator\") {\n return new Response(facilitatorPage(origin), {\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n }\n\n return new Response(participantPage(), {\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n}","createdAt",["D",1772992969001],"branchVersion","branchId","e7c7c706-1b15-11f1-bf84-42dde27851f2","id","e7c77cd8-1b15-11f1-bf84-42dde27851f2","playstudio-brainstorm",["D",1772991632202],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019cce88-62f9-70a9-a425-7e3b793c3cd3","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019cce88-62f9-70a9-a425-828f0cef004c","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","tsc","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNBZmxVaXltbUl3OFpEbUZQSEVMaUh0ejVhZiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":150,"_78":151,"_80":152,"_82":25},"tree",[144],"files",[144],"counts",{"_133":60,"_134":135,"_136":60,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"049dad98-1b19-11f1-9150-42dde27851f2","parentId","latest",["D",1772992969001],6,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":60,"_143":60},"connections",{"_141":60,"_142":60},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1772992969001],"children",[],[28],["D",1772991632202],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":120,"_195":-5,"_196":-7,"_197":-7,"_198":60,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":84,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v7