[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_143":144,"_145":146},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_81":64,"_82":83,"_62":-7,"_84":-5,"_13":85,"_86":87,"_11":88,"_89":90,"_91":92,"_93":-5,"_94":-5,"_95":-5,"_96":26,"_97":98,"_99":100,"_101":-5,"_102":-5,"_103":104},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":-5,"_35":26,"_36":-5,"_37":-5,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":-5,"_45":-5,"_46":47,"_48":47,"_49":50,"_51":50,"_52":50,"_53":47,"_54":47,"_55":56,"_57":58,"_59":60,"_61":26},"query","handle","packzinoff","id","0a96346e-04f2-11f1-940a-42dde27851f2","name","untitled-8726","createdAt",["D",1770557303136],"deletedAt","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",{"_16":17,"_80":76},"org",{"_16":17,"_74":-5,"_75":76,"_32":33,"_77":78,"_79":26},"branch",{"_62":63,"_20":64,"_18":65,"_66":19,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":21,"_73":17},"isOwned","version",12,"main","0a969ad0-04f2-11f1-940a-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOUFKd2s4M2xOdFBNR3gwaGFycGxGUkE5WkIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":139,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":-5,"_35":26,"_36":-5,"_37":-5,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":-5,"_45":-5,"_46":47,"_48":47,"_49":50,"_51":50,"_52":50,"_53":47,"_54":47,"_55":140,"_57":141,"_59":142,"_61":26},"tree",[134],[134],"counts",{"_123":39,"_124":125,"_126":39,"_127":128,"_129":130},"contents",[105],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_18":106,"_20":107,"_108":109,"_110":-5,"_111":65,"_112":63,"_113":100,"_22":114,"_62":115,"_116":117,"_118":119,"_120":26,"_121":-5,"_82":122},"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

Search