[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_148":149,"_150":151},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_86":-7,"_87":88,"_29":-7,"_89":-5,"_15":90,"_91":92,"_93":94,"_95":96,"_97":98,"_99":-5,"_100":-5,"_101":-5,"_102":38,"_103":104,"_105":106,"_107":-5,"_108":-5,"_109":110},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","packzinoff","name","untitled-8726","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":38,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":59,"_60":59,"_61":62,"_63":62,"_64":62,"_65":59,"_66":59,"_67":68,"_69":70,"_71":72,"_73":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","0a969ad0-04f2-11f1-940a-42dde27851f2","createdAt",["D",1770557303136],"updatedAt",["D",1770558129289],"main","projectId","0a96346e-04f2-11f1-940a-42dde27851f2","version",12,"forkedBranchId","forkedBranchVersion","lockfileKey","1770558129631-esm.town_v_packzinoff_untitled-8726@12-main","deletedAt",["D",1770557303136],"legacyEnvVars",false,"privacy","public","httpPrivacy","description","imageUrl","userId","019c2428-fd3a-7520-8254-753270c44bd1","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c2428-fd3a-7520-8254-7b355c356406","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_85":81},"org",{"_11":12,"_79":-5,"_80":81,"_44":45,"_82":83,"_84":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_74":-5,"_75":-5,"_76":-5,"_77":14,"_78":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOUFKd2s4M2xOdFBNR3gwaGFycGxGUkE5WkIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_20":28,"_13":14,"_22":144,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":38,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":59,"_60":59,"_61":62,"_63":62,"_64":62,"_65":59,"_66":59,"_67":145,"_69":146,"_71":147,"_73":38},"tree",[139],"files",[139],"counts",{"_129":51,"_17":130,"_131":51,"_132":133,"_134":135},"contents",[111],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_20":112,"_13":113,"_114":115,"_116":-5,"_117":21,"_118":30,"_119":106,"_22":120,"_29":121,"_122":123,"_124":125,"_126":38,"_127":-5,"_87":128},"f704cb34-04f3-11f1-9e68-42dde27851f2","main.ts","fileId","0a9a0288-04f2-11f1-940a-42dde27851f2","parentId","branchId","branchVersion","latest",["D",1770558129289],11,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function(req: Request): Promise {\n try {\n // 1. Setup the database\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS fruit_votes_v5 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n fruit TEXT\n )\n `);\n\n const url = new URL(req.url);\n\n // 2. ADMIN VIEW: Check results at your-url.run/admin\n if (url.pathname === \"/admin\") {\n const res = await sqlite.execute(\"SELECT * FROM fruit_votes_v5\");\n const rows = res.rows.map(row => `\n \n ${row[1]}\n ${row[2]}\n \n `).join(\"\");\n\n return new Response(`\n

Results

\n \n \n ${rows}\n

Name	Fruit

Back to form

\n `, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n // 3. HANDLE SUBMISSION\n if (req.method === \"POST\") {\n const data = await req.formData();\n const name = data.get(\"name\");\n const fruit = data.get(\"fruit\");\n\n await sqlite.execute({\n sql: `INSERT INTO fruit_votes_v5 (name, fruit) VALUES (?, ?)`,\n args: [name, fruit],\n });\n\n return new Response(`\n

Thanks, ${name}!

We recorded your favorite fruit as ${fruit}.

\n Submit another | View Results\n

\n `, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n // 4. THE PUBLIC FORM\n return new Response(`\n

Results

Thanks, ${name}!

Fruit Questionnaire

Branches1

Branches
1