[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_177":178,"_179":180},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_134":-5,"_20":135,"_22":136,"_137":138,"_139":140,"_25":141,"_24":-5,"_142":-5,"_143":-5,"_144":54,"_145":146,"_147":45,"_148":-5,"_149":-5,"_150":151},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","niteshgarg","name","wedding-help","branchName","main","version","path","","project",{"_34":75,"_13":14,"_46":76,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":83,"_84":85,"_86":87,"_88":-5,"_89":54,"_90":-5,"_91":-5,"_92":48,"_93":94,"_95":96,"_97":98,"_99":100,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_111":112,"_113":114,"_115":116,"_117":54},"tree",[66,67],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":64,"_53":54,"_55":14,"_18":65},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","a5203ac4-b40f-412d-bdf9-d5db14c38fa9","notify.ts","fileId","6a128228-7e1c-11f1-946b-1607ee4eb77e","parentId","branchId","3fbef200-6444-4479-ab38-c25ee905c43a","branchVersion",34,"latest",true,"createdAt",["D",1783879592890],0,"fileType","interval","content","// Hourly digest: emails the val owner when new comments land on the wedding board.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport default async function (interval: Interval) {\n // On first run (no lastRunAt), look back one hour.\n const since = (interval.lastRunAt ?? new Date(Date.now() - 60 * 60 * 1000)).getTime();\n const r = await sqlite.execute({\n sql: `select c.name, c.body, c.ts, c.votes, t.title\n from comments c join tasks t on t.id = c.task_id\n where c.ts > ? order by c.ts`,\n args: [since],\n });\n const rows = r.rows as any[];\n if (!rows.length) {\n console.log(\"No new comments since\", new Date(since).toISOString());\n return;\n }\n const lines = rows.map((c) =>\n `🫧 ${c.title}\\n ${c.name || \"Anonymous\"}: ${c.body}\\n (${new Date(Number(c.ts)).toLocaleString(\"en-IN\", { timeZone: \"Asia/Kolkata\" })} IST)`\n );\n await email({\n subject: `💬 ${rows.length} new comment${rows.length > 1 ? \"s\" : \"\"} on your wedding board`,\n text:\n `Someone dropped new help on https://wedding-help.val.run 💛\\n\\n` +\n lines.join(\"\\n\\n\"),\n });\n console.log(`Emailed digest of ${rows.length} comment(s).`);\n}\n","deleted",false,"label",[36],"4f9d58a4-c3ef-4aea-b53f-d5a93f05b4a4","main.ts","f5331cda-7df6-11f1-a77e-1607ee4eb77e",67,["D",1783910600613],65,"http","// Task Bubbles — full app with backend, for Val Town (HTTP val)\n// Tasks + comments live in this val's private SQLite database.\n// Admin actions require the ADMIN_PASSWORD environment variable (set it in Val Town).\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/* ---------------- database ---------------- */\n\nconst SEED_TASKS = [\n { id: \"t1\", title: \"Find a Granthi for Sikh Wedding\", details: \"Find a Granthi who can conduct the Anand Karaj ceremony. Please share any contacts or leads you have.\", priority: \"high\", status: \"pending\", due: \"\" },\n { id: \"t2\", title: \"Find the perfect Reception Lehnga\", details: \"Looking for the perfect Reception Lehnga. Please share the best store names along with the markets they are in.\", priority: \"high\", status: \"pending\", due: \"\" },\n { id: \"t3\", title: \"Jewellery shopping\", details: \"Wedding jewellery shopping — please recommend trusted shops.\", priority: \"high\", status: \"pending\", due: \"\" },\n { id: \"t4\", title: \"Book Indian restaurant for food items\", details: \"Book an Indian restaurant to cater the dinner buffet for both wedding days, near the resort. Recommendations welcome.\", priority: \"high\", status: \"pending\", due: \"\" },\n { id: \"t5\", title: \"Book a cheap DJ\", details: \"Book a budget-friendly DJ — preferably an Indian DJ living in Vietnam. Share quotes or contacts if you know any.\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t6\", title: \"Find a Henna artist\", details: \"Find a Henna (Mehndi) artist from Ho Chi Minh City. Recommendations appreciated.\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t7\", title: \"Room hamper ideas\", details: \"Collecting ideas for guest room hampers — drop your suggestions in the comments!\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t8\", title: \"Honeymoon destinations\", details: \"Where should we go for the honeymoon? Please recommend destinations.\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t9\", title: \"Must haves for wedding day\", details: \"Help us list down the wedding-day essentials we might be forgetting — add your must-haves in the comments.\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t10\", title: \"Pre-wedding shoot ideas\", details: \"Share themes, locations, and concept ideas for the pre-wedding shoot.\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t11\", title: \"Book transport for guests\", details: \"Arrange transport for guests from the airport to the resort.\", priority: \"medium\", status: \"pending\", due: \"\" },\n { id: \"t12\", title: \"Book a cheap band\", details: \"Book a budget-friendly band — preferably a high-energy English rock and roll band from Ho Chi Minh City, for 11th December.\", priority: \"low\", status: \"pending\", due: \"\" },\n { id: \"t13\", title: \"Accessories ideas\", details: \"Ideas for wedding accessories — suggestions welcome.\", priority: \"low\", status: \"pending\", due: \"\" },\n { id: \"t14\", title: \"Find a local Dholi\", details: \"Find a local Dholi (dhol player) in Ho Chi Minh City. Contacts and recommendations welcome.\", priority: \"low\", status: \"pending\", due: \"\" },\n];\n\nlet dbReady = false;\nasync function initDb() {\n if (dbReady) return;\n await sqlite.batch([\n `create table if not exists tasks(\n id text primary key, title text not null, details text default '',\n priority text default 'medium', status text default 'pending',\n due text default '', pos integer default 0)`,\n `create table if not exists comments(\n id integer primary key autoincrement, task_id text not null,\n name text default '', body text not null, ts integer not null)`,\n ]);\n try { await sqlite.execute(`alter table comments add column votes integer default 0`); } catch (_) { /* column exists */ }\n try { await sqlite.execute(`alter table comments add column parent_id integer`); } catch (_) { /* column exists */ }\n const c = await sqlite.execute(`select count(*) as n from tasks`);\n if (Number((c.rows[0] as any).n) === 0) {\n await sqlite.batch(SEED_TASKS.map((t, i) => ({\n sql: `insert into tasks(id,title,details,priority,status,due,pos) values(?,?,?,?,?,?,?)`,\n args: [t.id, t.title, t.details, t.priority, t.status, t.due, i],\n })));\n }\n dbReady = true;\n}\n\n/* ---------------- helpers ---------------- */\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json\", \"Cache-Control\": \"no-store\" },\n });\n}\n\nfunction isAdmin(req: Request) {\n const pw = Deno.env.get(\"ADMIN_PASSWORD\");\n if (!pw) return false;\n return req.headers.get(\"x-admin-key\") === pw;\n}\n\nconst PRIORITIES = [\"high\", \"medium\", \"low\"];\nconst STATUSES = [\"pending\", \"done\"];\n\n/* ---------------- request handler ---------------- */\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n if (!path.startsWith(\"/api/\")) {\n return new Response(HTML, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n }\n\n await initDb();\n\n // check admin password\n if (path === \"/api/login\" && req.method === \"POST\") {\n const body = await req.json().catch(() => ({}));\n const pw = Deno.env.get(\"ADMIN_PASSWORD\");\n if (!pw) return json({ ok: false, error: \"Admin password not set. In Val Town, open Environment Variables and add ADMIN_PASSWORD.\" }, 500);\n return json({ ok: body.password === pw });\n }\n\n // full board: tasks + comment counts\n if (path === \"/api/board\" && req.method === \"GET\") {\n const t = await sqlite.execute(`select id,title,details,priority,status,due from tasks order by pos, rowid`);\n const c = await sqlite.execute(`select id, task_id, name, body, ts, votes, parent_id from comments order by ts`);\n const counts: Record = {};\n const comments: Record = {};\n for (const r of c.rows as any[]) {\n counts[r.task_id] = (counts[r.task_id] || 0) + 1;\n (comments[r.task_id] = comments[r.task_id] || []).push({ id: r.id, name: r.name, body: r.body, ts: r.ts, votes: r.votes, parent_id: r.parent_id });\n }\n return json({ tasks: t.rows, counts, comments });\n }\n\n // comments for one task\n if (path === \"/api/comments\" && req.method === \"GET\") {\n const task = url.searchParams.get(\"task\") || \"\";\n const r = await sqlite.execute({\n sql: `select id, name, body, ts, votes, parent_id from comments where task_id = ? order by ts`,\n args: [task],\n });\n return json({ comments: r.rows });\n }\n\n // post a comment (anyone)\n if (path === \"/api/comments\" && req.method === \"POST\") {\n const b = await req.json().catch(() => ({}));\n const task = String(b.task || \"\").slice(0, 60);\n const name = String(b.name || \"\").trim().slice(0, 30);\n const body = String(b.text || \"\").trim().slice(0, 500);\n if (!task || !body) return json({ error: \"Missing comment text\" }, 400);\n const exists = await sqlite.execute({ sql: `select 1 from tasks where id = ?`, args: [task] });\n if (!exists.rows.length) return json({ error: \"Unknown task\" }, 404);\n const n = await sqlite.execute({ sql: `select count(*) as n from comments where task_id = ?`, args: [task] });\n if (Number((n.rows[0] as any).n) >= 300) return json({ error: \"Comment limit reached for this task\" }, 429);\n const parent = Number(b.parent) || 0;\n let parentId: number | null = null;\n if (parent) {\n const p = await sqlite.execute({ sql: `select id from comments where id = ? and task_id = ? and parent_id is null`, args: [parent, task] });\n if (p.rows.length) parentId = parent;\n }\n await sqlite.execute({\n sql: `insert into comments(task_id, name, body, ts, parent_id) values(?,?,?,?,?)`,\n args: [task, name, body, Date.now(), parentId],\n });\n return json({ ok: true });\n }\n\n // upvote a comment (anyone; one-per-person enforced client-side)\n if (path === \"/api/vote\" && req.method === \"POST\") {\n const b = await req.json().catch(() => ({}));\n const id = Number(b.id);\n if (!id) return json({ error: \"Missing comment id\" }, 400);\n await sqlite.execute({ sql: `update comments set votes = votes + 1 where id = ?`, args: [id] });\n const r = await sqlite.execute({ sql: `select votes from comments where id = ?`, args: [id] });\n if (!r.rows.length) return json({ error: \"Unknown comment\" }, 404);\n return json({ ok: true, votes: Number((r.rows[0] as any).votes) });\n }\n\n // delete a comment (admin)\n if (path === \"/api/comments\" && req.method === \"DELETE\") {\n if (!isAdmin(req)) return json({ error: \"Unauthorized\" }, 401);\n const id = Number(url.searchParams.get(\"id\"));\n await sqlite.execute({ sql: `delete from comments where id = ? or parent_id = ?`, args: [id, id] });\n return json({ ok: true });\n }\n\n // add or update a task (admin)\n if (path === \"/api/tasks\" && req.method === \"POST\") {\n if (!isAdmin(req)) return json({ error: \"Unauthorized\" }, 401);\n const b = await req.json().catch(() => ({}));\n const id = String(b.id || \"t\" + Date.now()).slice(0, 60);\n const title = String(b.title || \"\").trim().slice(0, 80);\n const details = String(b.details || \"\").trim().slice(0, 2000);\n const priority = PRIORITIES.includes(b.priority) ? b.priority : \"medium\";\n const status = STATUSES.includes(b.status) ? b.status : \"pending\";\n const due = String(b.due || \"\").slice(0, 10);\n if (!title) return json({ error: \"Title required\" }, 400);\n await sqlite.execute({\n sql: `insert into tasks(id,title,details,priority,status,due,pos)\n values(?,?,?,?,?,?, coalesce((select max(pos)+1 from tasks), 0))\n on conflict(id) do update set title=excluded.title, details=excluded.details,\n priority=excluded.priority, status=excluded.status, due=excluded.due`,\n args: [id, title, details, priority, status, due],\n });\n return json({ ok: true, id });\n }\n\n // delete a task and its comments (admin)\n if (path === \"/api/tasks\" && req.method === \"DELETE\") {\n if (!isAdmin(req)) return json({ error: \"Unauthorized\" }, 401);\n const id = url.searchParams.get(\"id\") || \"\";\n await sqlite.batch([\n { sql: `delete from comments where task_id = ?`, args: [id] },\n { sql: `delete from tasks where id = ?`, args: [id] },\n ]);\n return json({ ok: true });\n }\n\n return json({ error: \"Not found\" }, 404);\n}\n\n/* ---------------- the web page ---------------- */\n// NOTE: no backticks or dollar-brace interpolation may appear inside this HTML string.\n\nconst HTML = `\n\n\n\n\nTask Bubbles — Public Board\n\n\n\n\n\n\n\n

\n\n

A little help for our big day ✦ Vietnam, Dec 2026

Task Bubbles.

Pending tasks, floating in space — click a bubble to read & comment

\n \n

\n 🔥 Burning — help soon\n 🌤 Warm\n ❄️ Chilled — no rush\n ✓ Done\n

\n\n

\n\n\n

\n\n

💍✨🎈

Welcome to our little bubble board!

To all of our lovely friends and family — you have been asking us again and again, \"How can we help with the wedding?\" And honestly, that love means the world to us. So we thought — why not bring all that help to one common place? And voila, this board was born! 💛\n\nEvery floating bubble you see is a pending task we are stuck on. Our dream is simple: with your help, we want to burst every single bubble on this board, one by one — until the sky is clear and we are ready to say \"I do!\" 🥂

🫧Tap any bubble to read what we need help with.

💬Got an idea, a contact, or a solution? Drop it in the comments right there on the bubble.

📱Prefer chatting? WhatsApp us directly — +91 88188 94981 or +91 84471 95051 — or simply call. We would love to hear from you!

\n \n

\n\n\n\n\n\n\n`;\n",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":72,"_17":62,"_49":63,"_51":64,"_53":54,"_55":14,"_69":73,"_18":74},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_69":70,"_18":71},["D",1783879592890],"children",[],[36],["D",1783910600613],[],[58],"b21b769d-fafc-43ac-b2e6-b5a522cdae17",["D",1783863505406],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","We need your help to make our wedding a success","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/d3b893ba-5364-437d-7065-317ea4396b00/square512?exp=1789534799&sig=c0abbf54690524f5ea58796c4cde287aafef32d57440f543171225e70ae8d0f2","userId","9fb27c8d-12ff-4687-8d23-4c57f7106bcc","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f568a-526e-749f-bfce-9d7116ddbe2c","tursoName","b21b769dfafc43acb2e6b5a522cdae17","tursoHostname","b21b769dfafc43acb2e6b5a522cdae17-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_133":129},"org",{"_11":12,"_126":127,"_128":129,"_86":87,"_130":131,"_132":54},"branch",{"_17":60,"_13":16,"_34":41,"_118":75,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Nitesh Garg","avatar","https://lh3.googleusercontent.com/a/ACg8ocI3s1ahWykesQS62y9kulHCxNb4oEZxdLUspwqUjPgDKzd0QA=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":75,"_13":14,"_46":172,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":83,"_84":85,"_86":87,"_88":-5,"_89":54,"_90":-5,"_91":-5,"_92":48,"_93":94,"_95":96,"_97":98,"_99":173,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_111":174,"_113":175,"_115":176,"_117":54},[166,167],"files",[166,167],"counts",{"_156":48,"_157":158,"_159":48,"_31":160,"_161":162},[152,153],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":64,"_53":54,"_55":14,"_18":155},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":154},[36],[58],"pulls","branches",1,"forks",{"_163":158,"_165":48},"connections",{"_163":48,"_164":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":72,"_17":62,"_49":63,"_51":64,"_53":54,"_55":14,"_69":170,"_18":171},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_69":168,"_18":169},[],[36],[],[58],["D",1783863505406],["D",1789472446807],{"_11":12,"_133":129},{"_11":12,"_126":127,"_128":129,"_86":87,"_130":131,"_132":54},{"_17":60,"_13":16,"_34":41,"_118":75,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_111":-5,"_149":210,"_211":212,"_213":214,"_215":54,"_216":54,"_217":54,"_218":45,"_219":-5,"_220":-7,"_221":-7,"_222":48,"_223":54,"_224":54,"_225":-5,"_226":54,"_227":54,"_228":54,"_229":-5},"ENV",{"_181":182,"_183":184,"_185":16,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209},"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"]

Code