[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_113":95,"_33":107,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":32,"_127":128,"_129":30,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":32,"_54":55,"_56":55,"_57":58,"_59":60,"_19":61,"_62":63,"_64":30,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":32},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","de932852-566f-450c-827b-035fe349e372","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":32,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":32},"previous","deleted",true,"deletedHere",false,"path","server.ts","latestPath","fileId","abaaf418-6116-11f1-b6f1-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst TABLE = \"family_butler_items_v1\";\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n kind TEXT NOT NULL,\n title TEXT NOT NULL,\n day TEXT,\n time TEXT,\n done INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n)`);\n\nconst json = (data: unknown, status = 200) =>\n new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json\" },\n });\n\nexport default async function (req: Request): Promise {\n const { pathname } = new URL(req.url);\n\n if (pathname === \"/api/items\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT id, kind, title, day, time, done FROM ${TABLE} ORDER BY day IS NULL, day, time, id`,\n );\n return json(result.rows.map((r) => ({\n id: r[0], kind: r[1], title: r[2], day: r[3], time: r[4], done: !!r[5],\n })));\n }\n\n if (pathname === \"/api/items\" && req.method === \"POST\") {\n const { kind, title, day, time } = await req.json();\n if (!kind || !title) return json({ error: \"kind and title required\" }, 400);\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (kind, title, day, time) VALUES (?, ?, ?, ?)`,\n args: [kind, title, day || null, time || null],\n });\n return json({ ok: true }, 201);\n }\n\n if (pathname.startsWith(\"/api/items/\") && req.method === \"PATCH\") {\n const id = Number(pathname.split(\"/\").pop());\n const { done } = await req.json();\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET done = ? WHERE id = ?`,\n args: [done ? 1 : 0, id],\n });\n return json({ ok: true });\n }\n\n if (pathname.startsWith(\"/api/items/\") && req.method === \"DELETE\") {\n const id = Number(pathname.split(\"/\").pop());\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n return json({ ok: true });\n }\n\n if (pathname === \"/app.js\") return serveFile(\"/app.js\", import.meta.url);\n return serveFile(\"/page.html\", import.meta.url);\n}\n","createdAt",["D",1780688542218],"branchVersion","branchId","67b31c9f-abdc-460c-820d-3545aa45f61f","id","4bfef0de-e74e-47c0-ba37-39d09b0a8ffe","family-butler",["D",1780688454116],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Daily tasks, calendar, and dinner planning for the family","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/baeef583-a661-47c1-518c-640c7e092a00/square512?exp=1789545599&sig=64f51b4480e2e0273ca7671696efa6242a6507e63f1939bc10b52851c0b65b3b","08b6ee43-68da-4bf2-918a-58fd79608932","pinnedFileId","a19b903c-61d3-11f1-af58-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e994b-5e8f-775e-8465-668beecf3303","tursoName","4bfef0dee74e47c0ba3739d09b0a8ffe","tursoHostname","4bfef0dee74e47c0ba3739d09b0a8ffe-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789502486629],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":107},"org",{"_105":104,"_106":107,"_108":107,"_19":61,"_109":110,"_111":32},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",82,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Robbertd","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_38":50,"_43":206,"_52":-5,"_53":32,"_54":55,"_56":55,"_57":58,"_59":60,"_19":61,"_62":63,"_64":30,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":207,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":208,"_89":209,"_91":210,"_93":32},"tree",[185,186,187,188,189],"files",[185,186,187,188,189],"counts",{"_174":68,"_175":155,"_176":68,"_177":178,"_179":180},"contents",[134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":166,"_38":167,"_36":168,"_140":-5,"_46":47,"_45":169,"_141":32,"_43":170,"_13":68,"_39":171,"_41":172,"_29":32,"_143":-5,"_33":173},{"_48":159,"_38":160,"_36":161,"_140":-5,"_46":47,"_45":162,"_141":32,"_43":163,"_13":68,"_39":26,"_41":164,"_29":32,"_143":-5,"_33":165},{"_48":152,"_38":153,"_36":154,"_140":-5,"_46":47,"_45":155,"_141":32,"_43":156,"_13":68,"_39":40,"_41":157,"_29":32,"_143":-5,"_33":158},{"_48":145,"_38":146,"_36":147,"_140":-5,"_46":47,"_45":148,"_141":32,"_43":149,"_13":68,"_39":26,"_41":150,"_29":32,"_143":-5,"_33":151},{"_48":139,"_38":34,"_36":37,"_140":-5,"_46":47,"_45":14,"_141":32,"_43":142,"_13":68,"_39":40,"_41":42,"_29":32,"_143":-5,"_33":144},"1ba50f93-9c16-470a-9cdf-3a62379a5e48","parentId","latest",["D",1780688542218],"label",[34],"a85f691b-b21c-4f47-bfe7-0cb96da0e1e1","page.html","a359dad6-6116-11f1-990e-1607ee4eb77e",4,["D",1780688528214],"\n\n\n \n \n 🤵 Family Butler\n \n\n\n

🤵 Family Butler

At your service — tasks, calendar & dinner, all handled.

✅ Daily Tasks

\n \n

📅 Calendar

\n \n

🍽️ Dinner Plans

\n \n

\n \n\n\n",[146],"89d90dd5-c084-4cf1-a98f-e32275d82f9b","main.ts","7fb71bac-6116-11f1-8d15-1607ee4eb77e",1,["D",1780688468486],"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst TABLE = \"family_butler_items_v1\";\n\nasync function init() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n kind TEXT NOT NULL, -- 'task' | 'event' | 'dinner'\n title TEXT NOT NULL,\n day TEXT, -- ISO date (YYYY-MM-DD), optional\n time TEXT, -- HH:MM, optional\n done INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`);\n}\nawait init();\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n // --- API ---\n if (path === \"/api/items\" && req.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT id, kind, title, day, time, done FROM ${TABLE} ORDER BY day IS NULL, day, time, id`,\n );\n const rows = result.rows.map((r) => ({\n id: r[0], kind: r[1], title: r[2], day: r[3], time: r[4], done: !!r[5],\n }));\n return json(rows);\n }\n\n if (path === \"/api/items\" && req.method === \"POST\") {\n const body = await req.json();\n const { kind, title, day, time } = body;\n if (!kind || !title) return json({ error: \"kind and title required\" }, 400);\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (kind, title, day, time) VALUES (?, ?, ?, ?)`,\n args: [kind, title, day || null, time || null],\n });\n return json({ ok: true }, 201);\n }\n\n if (path.startsWith(\"/api/items/\") && req.method === \"PATCH\") {\n const id = Number(path.split(\"/\").pop());\n const body = await req.json();\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET done = ? WHERE id = ?`,\n args: [body.done ? 1 : 0, id],\n });\n return json({ ok: true });\n }\n\n if (path.startsWith(\"/api/items/\") && req.method === \"DELETE\") {\n const id = Number(path.split(\"/\").pop());\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n return json({ ok: true });\n }\n\n // --- App shell ---\n const { readFile } = await import(\"https://esm.town/v/std/utils/index.ts\");\n const html = await readFile(\"/index.html\", import.meta.url);\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n}\n",[153],"06d17cdd-5784-4da3-827e-a3ed83cdcb09","index.html","88dfad5c-6116-11f1-990e-1607ee4eb77e",2,["D",1780688483812],"\n\n\n \n \n 🤵 Family Butler\n \n\n\n

🤵 Family Butler

At your service — tasks, calendar & dinner, all handled.

✅ Daily Tasks

\n \n

📅 Calendar

\n \n

🍽️ Dinner Plans

\n \n

\n \n\n\n",[160],"9dfbdda1-fa3a-42af-8a38-25c423fcb8be","app.js","8f3e770a-6116-11f1-8b53-1607ee4eb77e",3,["D",1780688494547],"script","const fmtDay = (d) => {\n if (!d) return \"\";\n const dt = new Date(d + \"T00:00:00\");\n return dt.toLocaleDateString(undefined, { weekday: \"short\", month: \"short\", day: \"numeric\" });\n};\n\nasync function load() {\n const items = await fetch(\"/api/items\").then((r) => r.json());\n document.querySelectorAll(\".col\").forEach((col) => {\n const kind = col.dataset.kind;\n const ul = col.querySelector(\"ul\");\n const mine = items.filter((i) => i.kind === kind);\n if (!mine.length) {\n ul.innerHTML = '

Nothing here yet.

';\n return;\n }\n ul.innerHTML = mine.map((i) => {\n const meta = [fmtDay(i.day), i.time].filter(Boolean).join(\" · \");\n const check = kind === \"task\"\n ? ``\n : \"\";\n return `

\n ${check}\n ${escapeHtml(i.title)}${meta ? `

${meta}

` : \"\"}\n \n

`;\n }).join(\"\");\n });\n}\n\nfunction escapeHtml(s) {\n return s.replace(/[&<>\"']/g, (c) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\", \"'\": \"'\" }[c]));\n}\n\ndocument.querySelectorAll(\"form\").forEach((form) => {\n form.addEventListener(\"submit\", async (e) => {\n e.preventDefault();\n const kind = form.closest(\".col\").dataset.kind;\n const data = Object.fromEntries(new FormData(form));\n await fetch(\"/api/items\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ kind, ...data }),\n });\n form.reset();\n load();\n });\n});\n\ndocument.body.addEventListener(\"click\", async (e) => {\n const del = e.target.dataset.del;\n if (del) {\n await fetch(\"/api/items/\" + del, { method: \"DELETE\" });\n load();\n }\n});\n\ndocument.body.addEventListener(\"change\", async (e) => {\n const id = e.target.dataset.id;\n if (id) {\n await fetch(\"/api/items/\" + id, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ done: e.target.checked }),\n });\n load();\n }\n});\n\nload();\n",[167],"pulls","branches","forks","envVars",{"_181":183,"_184":68},"connections",{"_181":155,"_182":68},"count","unfilledCount",8,"emptyCount",{"_48":166,"_38":167,"_36":168,"_140":-5,"_46":47,"_45":169,"_141":32,"_43":203,"_13":68,"_39":171,"_41":172,"_29":32,"_143":-5,"_191":204,"_33":205},{"_48":159,"_38":160,"_36":161,"_140":-5,"_46":47,"_45":162,"_141":32,"_43":200,"_13":68,"_39":26,"_41":164,"_29":32,"_143":-5,"_191":201,"_33":202},{"_48":152,"_38":153,"_36":154,"_140":-5,"_46":47,"_45":155,"_141":32,"_43":197,"_13":68,"_39":40,"_41":157,"_29":32,"_143":-5,"_191":198,"_33":199},{"_48":145,"_38":146,"_36":147,"_140":-5,"_46":47,"_45":148,"_141":32,"_43":194,"_13":68,"_39":26,"_41":150,"_29":32,"_143":-5,"_191":195,"_33":196},{"_48":139,"_38":34,"_36":37,"_140":-5,"_46":47,"_45":14,"_141":32,"_43":190,"_13":68,"_39":40,"_41":42,"_29":32,"_143":-5,"_191":192,"_33":193},["D",1780688542218],"children",[],[34],["D",1780688528214],[],[146],["D",1780688468486],[],[153],["D",1780688483812],[],[160],["D",1780688494547],[],[167],["D",1780688454116],["D",1789502486629],{"_105":104,"_112":107},{"_105":104,"_106":107,"_108":107,"_19":61,"_109":110,"_111":32},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_131":244,"_245":246,"_247":248,"_249":32,"_250":32,"_251":32,"_252":30,"_253":-5,"_254":-7,"_255":-7,"_256":68,"_257":32,"_258":32,"_259":-5,"_260":32,"_261":32,"_262":32,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":95,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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 · v5