[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"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","packzinoff","name","untitled-8726","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":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","f704cb34-04f3-11f1-9e68-42dde27851f2","main.ts","fileId","0a9a0288-04f2-11f1-940a-42dde27851f2","parentId","branchId","0a969ad0-04f2-11f1-940a-42dde27851f2","branchVersion",12,"latest",true,"createdAt",["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

Code