Role Mirror

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":36,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":25,"_125":-5,"_126":-5,"_127":128},"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":36,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",2,"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","361e5f6e-ac5c-11f1-8a28-1607ee4eb77e","name","fileType","script","content","","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nasync function ensureTables() {\n await sqlite.execute(`create table if not exists people (\n id text primary key,\n name text,\n created_at text\n )`);\n await sqlite.execute(`create table if not exists responses (\n doc_id text primary key,\n respondent_id text,\n subject_id text,\n is_self integer,\n answers text,\n submitted integer,\n updated_at text\n )`);\n}\n\nfunction jsonResponse(data: unknown, status?: number) {\n return new Response(JSON.stringify(data), {\n status: status || 200,\n headers: { \"content-type\": \"application/json;charset=utf-8\" },\n });\n}\n\nasync function listPeople() {\n const result = await sqlite.execute({\n sql: \"select id, name, created_at from people\",\n args: [],\n });\n return result.rows.map((r: any) => ({\n id: r.id,\n name: r.name,\n createdAt: r.created_at,\n }));\n}\n\nasync function addPerson(name: string) {\n name = (name || \"\").toString().trim().slice(0, 60);\n if (!name) throw new Error(\"empty name\");\n const id = crypto.randomUUID();\n const createdAt = new Date().toISOString();\n await sqlite.execute({\n sql: \"insert into people (id, name, created_at) values (?, ?, ?)\",\n args: [id, name, createdAt],\n });\n return { id, name, createdAt };\n}\n\nasync function listResponses() {\n const result = await sqlite.execute({\n sql:\n \"select doc_id, respondent_id, subject_id, is_self, answers, submitted, updated_at from responses\",\n args: [],\n });\n return result.rows.map((r: any) => ({\n docId: r.doc_id,\n respondentId: r.respondent_id,\n subjectId: r.subject_id,\n isSelf: !!r.is_self,\n answers: JSON.parse(r.answers || \"{}\"),\n submitted: !!r.submitted,\n updatedAt: r.updated_at,\n }));\n}\n\nasync function saveResponse(body: any) {\n if (!body || !body.respondentId || !body.subjectId) {\n throw new Error(\"invalid response\");\n }\n const docId = body.respondentId + \"__\" + body.subjectId;\n const updatedAt = new Date().toISOString();\n const record = {\n docId,\n respondentId: body.respondentId,\n subjectId: body.subjectId,\n isSelf: !!body.isSelf,\n answers: body.answers || {},\n submitted: !!body.submitted,\n updatedAt,\n };\n await sqlite.execute({\n sql:\n `insert into responses (doc_id, respondent_id, subject_id, is_self, answers, submitted, updated_at)\n values (?, ?, ?, ?, ?, ?, ?)\n on conflict(doc_id) do update set\n is_self = excluded.is_self,\n answers = excluded.answers,\n submitted = excluded.submitted,\n updated_at = excluded.updated_at`,\n args: [\n docId,\n record.respondentId,\n record.subjectId,\n record.isSelf ? 1 : 0,\n JSON.stringify(record.answers),\n record.submitted ? 1 : 0,\n updatedAt,\n ],\n });\n return { ok: true, docId };\n}\n\nexport default async function (req: Request): Promise {\n await ensureTables();\n const url = new URL(req.url);\n\n try {\n if (url.pathname === \"/api/people\" && req.method === \"GET\") {\n return jsonResponse(await listPeople());\n }\n if (url.pathname === \"/api/people\" && req.method === \"POST\") {\n const body = await req.json();\n return jsonResponse(await addPerson(body.name));\n }\n if (url.pathname === \"/api/responses\" && req.method === \"GET\") {\n return jsonResponse(await listResponses());\n }\n if (url.pathname === \"/api/responses\" && req.method === \"POST\") {\n const body = await req.json();\n return jsonResponse(await saveResponse(body));\n }\n } catch (err: any) {\n return jsonResponse({ error: String((err && err.message) || err) }, 400);\n }\n\n return new Response(INDEX_HTML, {\n headers: { \"content-type\": \"text/html;charset=utf-8\" },\n });\n}\n\nconst INDEX_HTML = `\n\n\n\nRole Mirror\n\n\n\n\n\n\n\n

\n \n

\n\n\n\n\n`;","createdAt",["D",1788964751706],"branchVersion","branchId","8dc20f3f-6b08-4ef9-91ef-93d8c7b7f5ae","id","8e102f10-948e-41c4-b460-d6ee9d588d22","Role-Mirror",["D",1788964746973],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","2cc5bb30-4ac8-4dde-9ad8-1ed9fce1eb4c","pinnedFileId","88917af6-ac5c-11f1-bdf6-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0869a-1f9b-76ca-b36a-aabd64b43276","tursoName","8e102f10948e41c4b460d6ee9d588d22","tursoHostname","8e102f10948e41c4b460d6ee9d588d22-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789572079973],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","LukasBN","handle","displayName","Lukas Englert","avatar","https://lh3.googleusercontent.com/a/ACg8ocIpL4PzgJTY1qrqJS3agBxk9jBbYd4oUCTXcCQnrM-EaQClhg=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":36,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":153,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":154,"_83":155,"_85":156,"_87":25},"tree",[147],"files",[147],"counts",{"_137":62,"_138":134,"_139":62,"_140":141,"_142":143},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"505875a8-b424-421b-8759-0e32678445a2","parentId","latest",["D",1788964751706],1,"label",[28],"pulls","branches","forks","envVars",{"_144":62,"_146":62},"connections",{"_144":62,"_145":62},"count","unfilledCount","emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":148,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_149":150,"_27":151},["D",1788964751706],"children",[],[28],["D",1788964746973],["D",1789572079973],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":58,"_199":-5,"_200":-7,"_201":-7,"_202":62,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":89,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v2