[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":58,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"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","// Val Town HTTP val — współdzielone listy zakupów, bez logowania.\n// Jeśli ten import zawiedzie, podmień na: import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst WEEK = 7 * 24 * 3600 * 1000;\nconst ALPHABET = \"abcdefghijkmnopqrstuvwxyz23456789\"; // bez l/1/0/o\n\nlet ready: Promise | null = null;\nfunction init() {\n if (!ready) {\n ready = (async () => {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS lists (\n id TEXT PRIMARY KEY, seq INTEGER NOT NULL DEFAULT 0, last_active INTEGER NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS items (\n list_id TEXT NOT NULL, id TEXT NOT NULL,\n name TEXT, name_c INTEGER, name_d TEXT,\n ord REAL, ord_c INTEGER, ord_d TEXT,\n checked INTEGER, checked_c INTEGER, checked_d TEXT,\n deleted INTEGER, deleted_c INTEGER, deleted_d TEXT,\n seq INTEGER NOT NULL, PRIMARY KEY (list_id, id))`);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS items_by_seq ON items(list_id, seq)`,\n );\n })();\n }\n return ready;\n}\n\nasync function q(sql: string, args: any[] = []) {\n const res: any = await sqlite.execute({ sql, args });\n const cols: string[] = res.columns ?? [];\n return (res.rows ?? []).map((r: any) =>\n Object.fromEntries(cols.map((c, i) => [c, Array.isArray(r) ? r[i] : r[c]]))\n );\n}\n\n// usuwa listy nietknięte od tygodnia (razem z pozycjami)\nasync function sweep() {\n const cutoff = Date.now() - WEEK;\n await sqlite.execute({\n sql:\n `DELETE FROM items WHERE list_id IN (SELECT id FROM lists WHERE last_active < ?)`,\n args: [cutoff],\n });\n await sqlite.execute({\n sql: `DELETE FROM lists WHERE last_active < ?`,\n args: [cutoff],\n });\n}\n\nconst token = () =>\n Array.from(crypto.getRandomValues(new Uint8Array(10)))\n .map((n) => ALPHABET[n % ALPHABET.length])\n .join(\"\");\n\nconst FIELDS = [\"name\", \"ord\", \"checked\", \"deleted\"] as const;\nconst wins = (ac: number, ad: string, bc: number, bd: string) =>\n ac !== bc ? ac > bc : (ad ?? \"\") > (bd ?? \"\");\n\nasync function merge(listId: string, incoming: any[]) {\n const ids = incoming.map((i) => i.id);\n const ph = ids.map(() => \"?\").join(\",\");\n const existing = ids.length\n ? await q(`SELECT * FROM items WHERE list_id = ? AND id IN (${ph})`, [\n listId,\n ...ids,\n ])\n : [];\n const byId = new Map(existing.map((r: any) => [r.id, r]));\n\n const row = await q(`SELECT seq FROM lists WHERE id = ?`, [listId]);\n let seq = Number(row[0]?.seq ?? 0);\n\n for (const inc of incoming) {\n const cur: any = byId.get(inc.id);\n const out: any = { id: inc.id };\n let changed = false;\n for (const f of FIELDS) {\n const ic = Number(inc[f + \"_c\"] ?? 0), id_ = String(inc[f + \"_d\"] ?? \"\");\n const cc = Number(cur?.[f + \"_c\"] ?? -1),\n cd = String(cur?.[f + \"_d\"] ?? \"\");\n if (!cur || wins(ic, id_, cc, cd)) {\n out[f] = inc[f];\n out[f + \"_c\"] = ic;\n out[f + \"_d\"] = id_;\n changed = true;\n } else {\n out[f] = cur[f];\n out[f + \"_c\"] = cc;\n out[f + \"_d\"] = cd;\n }\n }\n if (!changed) continue;\n seq++;\n await sqlite.execute({\n sql: `INSERT INTO items (list_id,id,name,name_c,name_d,ord,ord_c,ord_d,\n checked,checked_c,checked_d,deleted,deleted_c,deleted_d,seq)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(list_id,id) DO UPDATE SET\n name=excluded.name,name_c=excluded.name_c,name_d=excluded.name_d,\n ord=excluded.ord,ord_c=excluded.ord_c,ord_d=excluded.ord_d,\n checked=excluded.checked,checked_c=excluded.checked_c,checked_d=excluded.checked_d,\n deleted=excluded.deleted,deleted_c=excluded.deleted_c,deleted_d=excluded.deleted_d,\n seq=excluded.seq`,\n args: [\n listId,\n out.id,\n out.name,\n out.name_c,\n out.name_d,\n out.ord,\n out.ord_c,\n out.ord_d,\n out.checked ? 1 : 0,\n out.checked_c,\n out.checked_d,\n out.deleted ? 1 : 0,\n out.deleted_c,\n out.deleted_d,\n seq,\n ],\n });\n }\n return seq;\n}\n\nconst json = (data: any) =>\n new Response(JSON.stringify(data), {\n headers: {\n \"content-type\": \"application/json\",\n \"referrer-policy\": \"no-referrer\",\n },\n });\n\nexport default async function (req: Request): Promise {\n await init();\n const url = new URL(req.url);\n const path = url.pathname;\n\n if (path === \"/api/new\" && req.method === \"POST\") {\n await sweep();\n const id = token();\n await sqlite.execute({\n sql: `INSERT INTO lists (id, seq, last_active) VALUES (?, 0, ?)`,\n args: [id, Date.now()],\n });\n return json({ id });\n }\n\n const api = path.match(/^\\/api\\/([a-z2-9]{10})$/);\n if (api) {\n const listId = api[1];\n const exists = await q(`SELECT id FROM lists WHERE id = ?`, [listId]);\n if (!exists.length) return json({ gone: true });\n\n let seq: number | null = null;\n if (req.method === \"POST\") {\n const body = await req.json();\n seq = await merge(listId, body.items ?? []);\n }\n await sqlite.execute({\n sql:\n `UPDATE lists SET last_active = ?, seq = COALESCE(?, seq) WHERE id = ?`,\n args: [Date.now(), seq, listId],\n });\n\n const since = Number(url.searchParams.get(\"since\") ?? 0);\n const items = await q(\n `SELECT id,name,name_c,name_d,ord,ord_c,ord_d,checked,checked_c,checked_d,\n deleted,deleted_c,deleted_d,seq FROM items WHERE list_id = ? AND seq > ?`,\n [listId, since],\n );\n const head = await q(`SELECT seq FROM lists WHERE id = ?`, [listId]);\n if (Math.random() < 0.02) await sweep();\n return json({ seq: Number(head[0]?.seq ?? 0), items });\n }\n\n return new Response(HTML, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"referrer-policy\": \"no-referrer\",\n },\n });\n}\n\nconst HTML = `\nZakupy\n\n\n\n

`;","createdAt",["D",1789210615986],"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",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"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",{"_43":44,"_32":45,"_38":174,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":175,"_80":176,"_82":177,"_84":25},"tree",[161,162,163],"files",[161,162,163],"counts",{"_151":62,"_152":134,"_153":62,"_154":155,"_156":157},"contents",[127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":144,"_32":145,"_30":146,"_131":-5,"_41":42,"_40":147,"_132":58,"_38":148,"_13":62,"_33":20,"_35":149,"_24":25,"_135":-5,"_27":150},{"_43":137,"_32":138,"_30":139,"_131":-5,"_41":42,"_40":140,"_132":58,"_38":141,"_13":62,"_33":34,"_35":142,"_24":25,"_135":-5,"_27":143},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":45,"_27":136},"1f592b26-29c1-4d16-945f-40b8472d7ee6","parentId","latest",["D",1789210615986],1,"label",[28],"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",[138],"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",[145],"pulls","branches","forks","envVars",{"_158":62,"_160":62},"connections",{"_158":62,"_159":62},"count","unfilledCount","emptyCount",{"_43":144,"_32":145,"_30":146,"_131":-5,"_41":42,"_40":147,"_132":58,"_38":171,"_13":62,"_33":20,"_35":149,"_24":25,"_135":-5,"_165":172,"_27":173},{"_43":137,"_32":138,"_30":139,"_131":-5,"_41":42,"_40":140,"_132":58,"_38":168,"_13":62,"_33":34,"_35":142,"_24":25,"_135":-5,"_165":169,"_27":170},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":164,"_13":134,"_33":34,"_35":37,"_24":25,"_135":45,"_165":166,"_27":167},["D",1789210615986],"children",[],[28],["D",1789209904283],[],[138],["D",1789209876444],[],[145],["D",1789209842682],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_124":211,"_212":213,"_214":215,"_216":25,"_217":25,"_218":25,"_219":58,"_220":-5,"_221":-7,"_222":-7,"_223":62,"_224":25,"_225":25,"_226":-5,"_227":25,"_228":25,"_229":25,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":86,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"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 · v4