The Seven

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_189":190,"_191":192},"routes/_app.x.$handle.$name",{"_95":94,"_31":43,"_104":85,"_26":51,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":57,"_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",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","probe.jsx","latestPath","fileId","3fdd0718-8d16-11f1-a30f-1607ee4eb77e","name","fileType","script","content","export function Hello() {\n return

;\n}\n","createdAt",["D",1785526212302],"branchVersion","branchId","312ebaf7-e0b1-4530-aaab-4d9fc8062f04","id","7117a07f-ade0-4feb-8307-c273fcc81b59","test-7sin",["D",1785524994632],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","1a462252-a94c-489b-af65-10503a4bd8d7","pinnedFileId","6a00bbf0-8d13-11f1-a8a6-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019fb994-b409-706f-9d96-0907feb38003","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_103":99},"org",{"_95":94,"_96":97,"_98":99,"_18":53,"_100":101,"_102":24},"branch",{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","matthieuharel","handle","displayName","Matthieu HAREL","avatar","https://lh3.googleusercontent.com/a/ACg8ocKzLAKA-YzHffBmMEW5mZg8iA6RM8MK0ER5zCVRo3hiv08SURnu_A=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_41":42,"_31":43,"_36":185,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":186,"_79":187,"_81":188,"_83":24},"tree",[168,169,170,171],"files",[168,169,170,171],"counts",{"_157":61,"_158":159,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":149,"_31":150,"_29":55,"_132":-5,"_39":40,"_38":151,"_134":24,"_36":152,"_13":153,"_32":154,"_34":155,"_23":24,"_137":-5,"_26":156},{"_41":146,"_31":27,"_29":30,"_132":-5,"_39":40,"_38":14,"_134":57,"_36":147,"_13":61,"_32":33,"_34":35,"_23":24,"_137":-5,"_26":148},{"_41":139,"_31":140,"_29":141,"_132":-5,"_39":40,"_38":142,"_134":24,"_36":143,"_13":61,"_32":33,"_34":144,"_23":24,"_137":-5,"_26":145},{"_41":129,"_31":130,"_29":131,"_132":-5,"_39":40,"_38":133,"_134":57,"_36":135,"_13":61,"_32":20,"_34":136,"_23":24,"_137":-5,"_26":138},"d4bd1c91-da06-4e75-972b-f52e0d878c99","probe.txt","26fcc0ee-8d16-11f1-a60e-1607ee4eb77e","parentId",6,"latest",["D",1785526170801],"hello-text-import","label",[130],"2548f935-49be-4567-8096-49cf37ae675e","probe.ts","30928080-8d16-11f1-9c19-1607ee4eb77e",7,["D",1785526186734],"import txt from \"./probe.txt\" with { type: \"text\" };\nconsole.log(\"TEXT_IMPORT_OK\", txt.length, JSON.stringify(txt));\n",[140],"a0ad03fe-2019-4d77-ac66-b6115e2d55c7",["D",1785526212302],[27],"2de8945e-bfd8-4bb6-9d19-06e5cc816da5","main.ts",5,["D",1785525701430],4,"http","/**\n * test-7sin / main.ts — collection endpoint for the seven-sins quiz.\n *\n * Setup:\n * 1. Paste this into main.ts and hit Save.\n * 2. Add an HTTP trigger (the \"Add trigger\" button top-right).\n * 3. Add an environment variable ADMIN_KEY with a long random string.\n * 4. Copy the val's HTTP URL into the quiz's ENDPOINT constant,\n * and the same ADMIN_KEY into its ADMIN_KEY constant.\n *\n * Routes:\n * POST / store one response {ts, sex, answers, fc}\n * GET /?key=ADMIN_KEY all responses as JSON\n * GET /count number stored (no key needed, no data)\n * DELETE /?key=ADMIN_KEY&id=N delete one row\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sins_responses (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ts INTEGER NOT NULL,\n sex TEXT,\n answers TEXT NOT NULL,\n fc TEXT,\n received_at INTEGER NOT NULL\n )\n`);\n\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, DELETE, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nconst json = (body: unknown, status = 200) =>\n new Response(JSON.stringify(body), {\n status,\n headers: { \"Content-Type\": \"application/json\", ...CORS },\n });\n\n/** std/sqlite returns rows as arrays; older clients return objects. Handle both. */\nconst cell = (row: any, i: number, name: string) =>\n Array.isArray(row) ? row[i] : row[name];\n\nconst safeParse = (s: any, fallback: unknown) => {\n try {\n return JSON.parse(s);\n } catch {\n return fallback;\n }\n};\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS });\n }\n\n const adminKey = Deno.env.get(\"ADMIN_KEY\");\n const authed = !!adminKey && url.searchParams.get(\"key\") === adminKey;\n\n if (url.pathname === \"/count\") {\n const r = await sqlite.execute(\"SELECT COUNT(*) FROM sins_responses\");\n return json({ count: Number(cell(r.rows[0], 0, \"COUNT(*)\")) });\n }\n\n if (req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ error: \"Body must be JSON.\" }, 400);\n }\n if (!body?.answers || typeof body.answers !== \"object\") {\n return json({ error: \"Missing answers.\" }, 400);\n }\n const payload = JSON.stringify(body.answers);\n if (payload.length > 20000) {\n return json({ error: \"Payload too large.\" }, 413);\n }\n\n await sqlite.execute({\n sql:\n \"INSERT INTO sins_responses (ts, sex, answers, fc, received_at) VALUES (?, ?, ?, ?, ?)\",\n args: [\n/**\n * test-7sin / main.ts — serves the quiz AND collects responses, one val.\n *\n * Files in this val:\n * main.ts this file\n * app.jsx the quiz component (paste it as a second file)\n *\n * Setup:\n * 1. Add an HTTP trigger.\n * 2. Add env var ADMIN_KEY (a long random string).\n * 3. Open the val URL. To see responses: tap the \"The Seven\"\n * wordmark five times, then enter ADMIN_KEY.\n *\n * The admin key is never baked into the page — it's typed in and\n * checked server-side, so nothing secret ships to respondents.\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport appSource from \"./app.jsx\" with { type: \"text\" };\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sins_responses (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ts INTEGER NOT NULL,\n sex TEXT,\n answers TEXT NOT NULL,\n fc TEXT,\n received_at INTEGER NOT NULL\n )\n`);\n\nconst json = (body: unknown, status = 200) =>\n new Response(JSON.stringify(body), {\n status,\n headers: { \"Content-Type\": \"application/json\" },\n });\n\nconst cell = (row: any, i: number, name: string) =>\n Array.isArray(row) ? row[i] : row[name];\n\nconst safeParse = (s: any, fallback: unknown) => {\n try {\n return JSON.parse(s);\n } catch {\n return fallback;\n }\n};\n\nconst PAGE = `\n\n\n\n\nThe Seven\n\n\n\n\n\n\n

\n\n\n`;\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.pathname === \"/app.jsx\") {\n return new Response(appSource, {\n headers: { \"Content-Type\": \"text/plain; charset=utf-8\" },\n });\n }\n\n if (url.pathname === \"/api/responses\") {\n const adminKey = Deno.env.get(\"ADMIN_KEY\");\n const authed = !!adminKey && url.searchParams.get(\"key\") === adminKey;\n\n if (req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ error: \"Body must be JSON.\" }, 400);\n }\n if (!body?.answers || typeof body.answers !== \"object\") {\n return json({ error: \"Missing answers.\" }, 400);\n }\n const payload = JSON.stringify(body.answers);\n if (payload.length > 20000) return json({ error: \"Payload too large.\" }, 413);\n\n await sqlite.execute({\n sql: \"INSERT INTO sins_responses (ts, sex, answers, fc, received_at) VALUES (?, ?, ?, ?, ?)\",\n args: [\n Number(body.ts) || Date.now(),\n String(body.sex ?? \"unspecified\").slice(0, 20),\n payload,\n JSON.stringify(body.fc ?? []),\n Date.now(),\n ],\n });\n return json({ ok: true }, 201);\n }\n\n if (req.method === \"GET\") {\n if (!authed) return json({ error: \"Bad or missing key.\" }, 401);\n const r = await sqlite.execute(\n \"SELECT id, ts, sex, answers, fc FROM sins_responses ORDER BY ts DESC LIMIT 2000\",\n );\n const responses = r.rows.map((row: any) => ({\n id: Number(cell(row, 0, \"id\")),\n ts: Number(cell(row, 1, \"ts\")),\n sex: cell(row, 2, \"sex\"),\n answers: safeParse(cell(row, 3, \"answers\"), {}),\n fc: safeParse(cell(row, 4, \"fc\"), []),\n }));\n return json({ responses });\n }\n\n if (req.method === \"DELETE\") {\n if (!authed) return json({ error: \"Bad or missing key.\" }, 401);\n const id = url.searchParams.get(\"id\");\n if (!id) return json({ error: \"Missing id.\" }, 400);\n await sqlite.execute({\n sql: \"DELETE FROM sins_responses WHERE id = ?\",\n args: [Number(id)],\n });\n return json({ ok: true });\n }\n\n return json({ error: \"Method not allowed.\" }, 405);\n }\n\n return new Response(PAGE, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\n{ error: \"Not found.\" }, 404);\n}",[150],"pulls","branches",1,"forks","envVars",{"_165":159,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_41":149,"_31":150,"_29":55,"_132":-5,"_39":40,"_38":151,"_134":24,"_36":182,"_13":153,"_32":154,"_34":155,"_23":24,"_137":-5,"_173":183,"_26":184},{"_41":146,"_31":27,"_29":30,"_132":-5,"_39":40,"_38":14,"_134":57,"_36":179,"_13":61,"_32":33,"_34":35,"_23":24,"_137":-5,"_173":180,"_26":181},{"_41":139,"_31":140,"_29":141,"_132":-5,"_39":40,"_38":142,"_134":24,"_36":176,"_13":61,"_32":33,"_34":144,"_23":24,"_137":-5,"_173":177,"_26":178},{"_41":129,"_31":130,"_29":131,"_132":-5,"_39":40,"_38":133,"_134":57,"_36":172,"_13":61,"_32":20,"_34":136,"_23":24,"_137":-5,"_173":174,"_26":175},["D",1785526170801],"children",[],[130],["D",1785526186734],[],[140],["D",1785526212302],[],[27],["D",1785525701430],[],[150],["D",1785524994632],{"_95":94,"_103":99},{"_95":94,"_96":97,"_98":99,"_18":53,"_100":101,"_102":24},{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"ctx",{"_77":-5,"_122":222,"_223":224,"_225":226,"_227":24,"_228":24,"_229":24,"_230":57,"_231":-5,"_232":-7,"_233":-7,"_234":61,"_235":24,"_236":24,"_237":-5,"_238":24,"_239":24,"_240":24,"_241":-5},"ENV",{"_193":194,"_195":196,"_197":85,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221},"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 · v8