[{"_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",{"_100":99,"_37":49,"_109":90,"_32":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_26":-5,"_121":-5,"_122":-5,"_123":30,"_124":125,"_126":62,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":30},"version",1,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","8a5540ed-230d-48dd-a06c-c2c2016e8a65","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","main.ts","latestPath","fileId","e72362d2-ae96-11f1-a2ee-1607ee4eb77e","name","fileType","http","content","import { Database } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst db = new Database(\"shopping.sqlite\");\ndb.exec(`\n CREATE TABLE IF NOT EXISTS items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n done INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL DEFAULT (strftime('%s','now'))\n );\n`);\n\nfunction list() {\n return db\n .prepare(\"SELECT id, name, done FROM items ORDER BY created_at DESC\")\n .all();\n}\n\nasync function handle(req: Request): Promise {\n const url = new URL(req.url);\n\n // --- JSON API ---\n if (url.pathname === \"/api\") {\n if (req.method === \"GET\") {\n return Response.json(list());\n }\n\n if (req.method === \"POST\") {\n const body = await req.json();\n const name = String(body.name ?? \"\").trim();\n if (!name) return Response.json({ error: \"empty\" }, { status: 400 });\n db.prepare(\"INSERT INTO items (name, done) VALUES (?, 0)\").run(name);\n return Response.json(list());\n }\n\n if (req.method === \"PATCH\") {\n const body = await req.json();\n db.prepare(\"UPDATE items SET done = ? WHERE id = ?\").run(\n body.done ? 1 : 0,\n body.id,\n );\n return Response.json(list());\n }\n\n if (req.method === \"DELETE\") {\n db.prepare(\"DELETE FROM items WHERE id = ?\").run(bodyId(req));\n return Response.json(list());\n }\n }\n\n // --- HTML app (mobile first) ---\n const items = list();\n const rows = items\n .map(\n (it) => `\n

\n \n \n ${escapeHtml(it.name)}\n \n \n

`,\n )\n .join(\"\");\n\n const html = `\n\n\n\n\n🛒 Shopping List\n\n\n\n

🛒 Shared Shopping List

Anyone with this link sees and changes the same list — no account needed.

\n \n

${rows}\n

\n\n\n`;\n return new Response(html, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction bodyId(req: Request): number {\n let n = 0;\n req\n .clone()\n .json()\n .then((b) => (n = b.id));\n return n;\n}\n\nfunction escapeHtml(s: string): string {\n return s.replace(/[&<>\"']/g, (c) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\", \"'\": \"'\" }[c]!),\n );\n}\n\nexport default handle;\n","createdAt",["D",1789209857115],"branchVersion","branchId","d5e5aedb-f0e2-46c6-8a05-bdcaaae91856","id","7ee09195-c8e2-45b0-b671-25b8e0394316","shopping-list",["D",1789209842682],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Collaborative anonymous shopping list","imageUrl","3a05a99a-d3c1-4fe5-ae98-f493eeba0a25","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09534-ca05-73e4-a6fb-f40192267d88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_19":59,"_105":106,"_107":30},"branch",{"_13":89,"_37":90,"_47":46,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","yonee","handle","displayName","Michał Jonik","avatar","https://lh3.googleusercontent.com/a/ACg8ocJnSGA3CWWEnfMTui3cDlkDz2_2VYUzL9T_CGJUVx8-xymZ7feMUQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":153,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":154,"_84":155,"_86":156,"_88":30},"tree",[148],"files",[148],"counts",{"_138":66,"_139":14,"_140":66,"_141":142,"_143":144},"contents",[131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":132,"_37":33,"_35":36,"_133":-5,"_45":46,"_44":14,"_134":30,"_42":135,"_13":66,"_38":39,"_40":41,"_29":30,"_136":49,"_32":137},"635c6454-28eb-4ce4-a60e-eafc3f242b37","parentId","latest",["D",1789209857115],"label",[33],"pulls","branches","forks","envVars",{"_145":66,"_147":66},"connections",{"_145":66,"_146":66},"count","unfilledCount","emptyCount",{"_47":132,"_37":33,"_35":36,"_133":-5,"_45":46,"_44":14,"_134":30,"_42":149,"_13":66,"_38":39,"_40":41,"_29":30,"_136":49,"_150":151,"_32":152},["D",1789209857115],"children",[],[33],["D",1789209842682],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_19":59,"_105":106,"_107":30},{"_13":89,"_37":90,"_47":46,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_128":190,"_191":192,"_193":194,"_195":30,"_196":30,"_197":30,"_198":62,"_199":-5,"_200":-7,"_201":-7,"_202":66,"_203":30,"_204":30,"_205":-5,"_206":30,"_207":30,"_208":30,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":90,"_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","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v1