[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_119":-5,"_20":120,"_22":121,"_122":123,"_124":125,"_25":126,"_24":-5,"_127":-5,"_128":-5,"_129":53,"_130":131,"_132":44,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","arvindfroi","name","footballKitSurvey","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":82,"_83":84,"_85":86,"_87":-5,"_88":89,"_90":89,"_91":92,"_93":92,"_94":92,"_95":89,"_96":89,"_97":98,"_99":100,"_101":102,"_103":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","e172991a-504b-11f1-9d2e-ee650bb23af1","main.ts","fileId","7453c616-504a-11f1-8637-ee650bb23af1","parentId","branchId","744f5e82-504a-11f1-8637-ee650bb23af1","branchVersion",2,"latest",true,"createdAt",["D",1778842225999],1,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n\n if (req.method === \"POST\" && url.pathname === \"/submit\") {\n try {\n const data = await req.json();\n await sqlite.execute({\n sql: `INSERT INTO kit_responses (\n submitted_at, participant_name, importance_weight,\n home_fit, home_sleeve, home_collar, home_color1, home_color2, home_color3,\n home_pattern, home_craziness, home_sponsors, home_extras, home_comments,\n wants_away_different,\n away_fit, away_sleeve, away_collar, away_color1, away_color2, away_color3,\n away_pattern, away_craziness, away_sponsors, away_extras, away_comments\n ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [\n new Date().toISOString(), data.name || \"Anonymous\", data.weight || 5,\n data.home?.fit, data.home?.sleeve, data.home?.collar,\n data.home?.color1, data.home?.color2, data.home?.color3,\n data.home?.pattern, data.home?.craziness, data.home?.sponsors,\n JSON.stringify(data.home?.extras || []), data.home?.comments,\n data.wantsAway ? 1 : 0,\n data.away?.fit, data.away?.sleeve, data.away?.collar,\n data.away?.color1, data.away?.color2, data.away?.color3,\n data.away?.pattern, data.away?.craziness, data.away?.sponsors,\n JSON.stringify(data.away?.extras || []), data.away?.comments,\n ],\n });\n return new Response(JSON.stringify({ ok: true }), { headers: { \"Content-Type\": \"application/json\" } });\n } catch (e) {\n return new Response(JSON.stringify({ ok: false, error: String(e) }), { status: 500, headers: { \"Content-Type\": \"application/json\" } });\n }\n }\n\n if (url.pathname === \"/results\") {\n const rows = await sqlite.execute({ sql: \"SELECT * FROM kit_responses ORDER BY submitted_at DESC\", args: [] });\n return new Response(JSON.stringify(rows.rows), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (url.pathname === \"/export\") {\n const rows = await sqlite.execute({ sql: \"SELECT * FROM kit_responses ORDER BY submitted_at ASC\", args: [] });\n const cols = rows.columns;\n const lines = [cols.join(\"\\t\")];\n for (const row of rows.rows) {\n lines.push(cols.map(c => {\n const v = (row as any)[c];\n return v == null ? \"\" : String(v).replace(/\\t/g, \" \");\n }).join(\"\\t\"));\n }\n return new Response(lines.join(\"\\n\"), {\n headers: {\n \"Content-Type\": \"text/tab-separated-values\",\n \"Content-Disposition\": \"attachment; filename=\\\"kit-survey-results.tsv\\\"\",\n },\n });\n }\n\n if (url.pathname === \"/admin\") {\n return new Response(adminHTML(), { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n return new Response(formHTML(), { headers: { \"Content-Type\": \"text/html\" } });\n}\n\nfunction adminHTML(): string {\n return `\n\n\n\nKit Survey — Admin\n\n\n\n\n

⚽ Kit Survey — Admin Dashboard

\n\n\n

Loading…

\n\n`;\n}\n\nfunction formHTML(): string {\n return `\n\n\n\nFootball Kit Design Survey\n\n\n\n

⚽

Football Kit Design Survey

Help us choose the design for our two football kits.
No prior knowledge needed — just pick what you like!

\n\n

🎉

Thank you for your vote!

Your preferences have been saved.

\n\n\n`;\n}\n","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1778842225999],"children",[],[35],"744e8af2-504a-11f1-8637-ee650bb23af1",["D",1778841613430],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Football kit design deliberation form with Excel export","imageUrl","userId","019c8c94-1b18-70ab-9d66-67b2531c59ef","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c8c94-1b18-70ab-9d66-68fabd795643","tursoName","744e8af2504a11f18637ee650bb23af1","tursoHostname","744e8af2504a11f18637ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789576313835],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_118":114},"org",{"_11":12,"_112":-5,"_113":114,"_71":72,"_115":116,"_117":53},"branch",{"_17":42,"_13":16,"_33":40,"_104":61,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":14,"_111":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNBNWFrb3FkY3pXQTkyNk5oeWFEa25zSkhBayJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":151,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":82,"_83":84,"_85":152,"_87":-5,"_88":89,"_90":89,"_91":92,"_93":92,"_94":92,"_95":89,"_96":89,"_97":153,"_99":154,"_101":155,"_103":53},[148],"files",[148],"counts",{"_139":78,"_140":47,"_141":78,"_31":142,"_143":144},[137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":138},[35],"pulls","branches","forks",{"_145":78,"_147":78},"connections",{"_145":78,"_146":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":149,"_18":150},[],[35],["D",1778841613430],["D",1789576313835],{"_11":12,"_118":114},{"_11":12,"_112":-5,"_113":114,"_71":72,"_115":116,"_117":53},{"_17":42,"_13":16,"_33":40,"_104":61,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":14,"_111":12},"ctx",{"_97":-5,"_134":189,"_190":191,"_192":193,"_194":53,"_195":53,"_196":53,"_197":44,"_198":-5,"_199":-7,"_200":-7,"_201":78,"_202":53,"_203":53,"_204":-5,"_205":53,"_206":53,"_207":53,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":16,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Code