`;","deleted","label",[112],"ebbaaf27-cf44-4a45-9c51-d1bf3a990f39","index.ts","033fe2e2-ae97-11f1-b3c5-1607ee4eb77e",3,["D",1789209904283],"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 if (url.pathname === \"/api\") {\n if (req.method === \"GET\") return Response.json(list());\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 Number(body.id),\n );\n return Response.json(list());\n }\n\n if (req.method === \"DELETE\") {\n const body = await req.json();\n db.prepare(\"DELETE FROM items WHERE id = ?\").run(Number(body.id));\n return Response.json(list());\n }\n }\n\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 escapeHtml(s: string): string {\n return s.replace(/[&<>\"']/g, (c) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\", \"'\": \"'\" }[c]!),\n );\n}\n\nexport default handle;\n",[128],"4670abcd-f842-40a1-980a-78dd5ac399c7","README.md","f2a7ecb8-ae96-11f1-adca-1607ee4eb77e",2,["D",1789209876444],"# 🛒 Shared Shopping List\n\nA mobile-first, collaborative shopping list for friends and family. No accounts,\nno sign-in — anyone with the link sees and edits the same list.\n\n## Features\n- **Mobile-first** UI, optimized for phones (large touch targets, safe-area support)\n- **Fast sync** — polls every 2 seconds, plus an instant refresh after your own edits\n- **Anonymous** — shared purely by URL, no accounts or personal data\n- **Persistent** — items live in project-scoped SQLite\n\n## Try it\n[Open the app](url:main.ts)\n\n## API\nAll endpoints on `main.ts` under `/api`, returning the full item list as JSON.\n\n| Method | Path | Body | Effect |\n|--------|------|------|--------|\n| GET | `/api` | – | List items |\n| POST | `/api` | `{\"name\": \"Milk\"}` | Add an item |\n| PATCH| `/api` | `{\"id\": 1, \"done\": true}` | Check/uncheck |\n| DELETE | `/api` | `{\"id\": 1}` | Remove an item |\n",[135],"pulls","branches",1,"forks","envVars",{"_149":42,"_151":42},"connections",{"_149":42,"_150":42},"count","unfilledCount","emptyCount",{"_18":134,"_20":135,"_113":136,"_114":-5,"_115":68,"_116":137,"_117":38,"_22":162,"_65":42,"_120":97,"_122":139,"_124":26,"_125":-5,"_156":163,"_86":164},{"_18":127,"_20":128,"_113":129,"_114":-5,"_115":68,"_116":130,"_117":38,"_22":159,"_65":42,"_120":121,"_122":132,"_124":26,"_125":-5,"_156":160,"_86":161},{"_18":111,"_20":112,"_113":36,"_114":-5,"_115":68,"_116":66,"_117":38,"_22":155,"_65":119,"_120":121,"_122":123,"_124":26,"_125":21,"_156":157,"_86":158},["D",1789212740716],"children",[],[112],["D",1789209904283],[],[128],["D",1789209876444],[],[135],["D",1789209842682],{"_16":17,"_84":80},{"_16":17,"_77":78,"_79":80,"_33":34,"_81":82,"_83":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_105":202,"_203":204,"_205":206,"_207":26,"_208":26,"_209":26,"_210":38,"_211":-5,"_212":-7,"_213":-7,"_214":42,"_215":26,"_216":26,"_217":-5,"_218":26,"_219":26,"_220":26,"_221":-5},"ENV",{"_173":174,"_175":176,"_177":67,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201},"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"]

Search