`;","deleted","label",[118],"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",[134],"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",[141],"pulls",1,"forks","envVars",{"_154":54,"_156":54},"connections",{"_154":54,"_155":54},"count","unfilledCount","emptyCount",{"_20":140,"_13":141,"_119":142,"_120":-5,"_121":21,"_122":143,"_123":50,"_22":167,"_29":54,"_126":103,"_128":145,"_130":38,"_131":-5,"_161":168,"_91":169},{"_20":133,"_13":134,"_119":135,"_120":-5,"_121":21,"_122":136,"_123":50,"_22":164,"_29":54,"_126":127,"_128":138,"_130":38,"_131":-5,"_161":165,"_91":166},{"_20":117,"_13":118,"_119":48,"_120":-5,"_121":21,"_122":30,"_123":50,"_22":160,"_29":125,"_126":127,"_128":129,"_130":38,"_131":14,"_161":162,"_91":163},["D",1789212740716],"children",[],[118],["D",1789209904283],[],[134],["D",1789209876444],[],[141],["D",1789209842682],{"_11":12,"_89":85},{"_11":12,"_82":83,"_84":85,"_45":46,"_86":87,"_88":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_111":207,"_208":209,"_210":211,"_212":38,"_213":38,"_214":38,"_215":50,"_216":-5,"_217":-7,"_218":-7,"_219":54,"_220":38,"_221":38,"_222":-5,"_223":38,"_224":38,"_225":38,"_226":-5},"ENV",{"_178":179,"_180":181,"_182":26,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206},"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"]

Branches1

Branches
1