[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_342":343,"_344":345},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_253":-5,"_20":254,"_22":255,"_256":257,"_258":259,"_26":260,"_24":261,"_262":263,"_264":265,"_266":51,"_267":268,"_269":74,"_270":-5,"_271":-5,"_272":273},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","sammitbadodekar","name","todo-app","branchName","main","version","path","frontend/components","project",{"_36":203,"_13":14,"_38":204,"_49":-5,"_205":51,"_52":53,"_206":53,"_207":208,"_209":210,"_211":212,"_213":113,"_214":74,"_215":-5,"_216":-5,"_217":76,"_56":218,"_219":220,"_221":222,"_223":224,"_225":-5,"_226":227,"_228":227,"_229":230,"_231":230,"_232":230,"_233":227,"_234":227,"_235":236,"_237":238,"_239":240,"_50":51},"tree",[106,107,108,109,110],"file",{"_36":101,"_13":85,"_65":68,"_67":102,"_69":70,"_71":98,"_73":74,"_38":103,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_18":105},"contents",[60,61,62],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"pull","ahead",9,"behind",2,"envVars","id","961078ea-f528-11ef-aa68-569c3dd06744","createdAt",["D",1740674013689],"updatedAt",["D",1785420707976],"projectId","96102714-f528-11ef-aa68-569c3dd06744",91,"forkedBranchId","forkedBranchVersion","lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","deletedAt","isOwned",false,"privacy","public","userHandle","templates","orgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","react-hono-starter",{"_36":93,"_13":94,"_65":95,"_67":68,"_69":70,"_71":96,"_73":74,"_38":97,"_17":98,"_77":78,"_79":99,"_81":51,"_82":-5,"_18":100},{"_36":86,"_13":87,"_65":88,"_67":68,"_69":70,"_71":89,"_73":74,"_38":90,"_17":76,"_77":78,"_79":91,"_81":51,"_82":-5,"_18":92},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_18":83},"92c760e2-8423-4a18-9a9e-5db1a68d10b2","TodoItem.tsx","fileId","4ff57344-82e2-11f1-8733-1607ee4eb77e","parentId","019f76c9-48ec-747c-8230-2dcaac3b7e51","branchId","a232f2f5-e74e-4b08-815d-f2388bec3492","branchVersion",6,"latest",true,["D",1784404394083],0,"fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Todo } from \"../../shared/types.ts\";\n\ninterface Props {\n todo: Todo;\n onToggle: (todo: Todo) => void;\n onDelete: (id: number) => void;\n onEdit: (id: number, text: string) => Promise;\n}\n\nexport function TodoItem({ todo, onToggle, onDelete, onEdit }: Props) {\n const [editing, setEditing] = useState(false);\n const [draft, setDraft] = useState(todo.text);\n\n async function commitEdit() {\n const trimmed = draft.trim();\n if (!trimmed) {\n setDraft(todo.text);\n setEditing(false);\n return;\n }\n if (trimmed !== todo.text) {\n await onEdit(todo.id, trimmed);\n }\n setEditing(false);\n }\n\n return (\n

\n onToggle(todo)}\n aria-label={todo.completed ? \"Mark as active\" : \"Mark as completed\"}\n class={`w-6 h-6 shrink-0 rounded-full border-2 flex items-center justify-center transition-colors cursor-pointer ${\n todo.completed\n ? \"bg-emerald-500 border-emerald-500 text-white\"\n : \"border-gray-300 hover:border-indigo-400 text-transparent\"\n }`}\n >\n ✓\n \n\n {editing\n ? (\n setDraft(e.target.value)}\n onBlur={commitEdit}\n onKeyDown={(e) => {\n if (e.key === \"Enter\") commitEdit();\n if (e.key === \"Escape\") {\n setDraft(todo.text);\n setEditing(false);\n }\n }}\n autoFocus\n class=\"flex-1 px-2 py-1 rounded border border-indigo-300 focus:outline-none focus:ring-2 focus:ring-indigo-400\"\n />\n )\n : (\n setEditing(true)}\n title=\"Double-click to edit\"\n class={`flex-1 cursor-text break-words min-w-0 ${\n todo.completed ? \"line-through text-gray-400\" : \"text-gray-800\"\n }`}\n >\n {todo.text}\n \n )}\n\n onDelete(todo.id)}\n aria-label=\"Delete todo\"\n class=\"opacity-0 group-hover:opacity-100 focus:opacity-100 text-gray-300 hover:text-red-500 transition-all text-xl leading-none cursor-pointer px-1\"\n >\n ×\n \n

\n );\n}\n","deleted","label",[84,85,64],"frontend","components","4d06a363-5284-4530-9465-6e9ef3f9c8e2","TodoInput.tsx","4a6dd7ae-82e2-11f1-98d1-1607ee4eb77e",5,["D",1784404384799],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n onAdd: (text: string) => Promise;\n disabled?: boolean;\n}\n\nexport function TodoInput({ onAdd, disabled }: Props) {\n const [text, setText] = useState(\"\");\n const [submitting, setSubmitting] = useState(false);\n\n async function handleSubmit(e: { preventDefault: () => void }) {\n e.preventDefault();\n const trimmed = text.trim();\n if (!trimmed || submitting) return;\n setSubmitting(true);\n try {\n await onAdd(trimmed);\n setText(\"\");\n } finally {\n setSubmitting(false);\n }\n }\n\n return (\n

\n setText(e.target.value)}\n placeholder=\"What needs to be done?\"\n maxLength={500}\n disabled={disabled || submitting}\n autoFocus\n class=\"flex-1 px-4 py-3 rounded-xl border border-gray-200 bg-white shadow-sm focus:outline-none focus:ring-2 focus:ring-indigo-400 focus:border-transparent placeholder-gray-400 disabled:opacity-50\"\n />\n \n Add\n \n \n );\n}\n",[84,85,87],"2f8af389-17b6-49d5-a012-62205912cdab","App.tsx","019f76c9-48eb-72d8-ad33-f2fdd02bc82a",7,["D",1784404418188],1,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Filter, Todo } from \"../../shared/types.ts\";\nimport { TodoInput } from \"./TodoInput.tsx\";\nimport { TodoItem } from \"./TodoItem.tsx\";\n\nasync function api(path: string, options?: RequestInit): Promise {\n const res = await fetch(path, {\n headers: { \"Content-Type\": \"application/json\" },\n ...options,\n });\n if (!res.ok) {\n const body = await res.json().catch(() => ({}));\n throw new Error(body.error || `Request failed (${res.status})`);\n }\n return res.json();\n}\n\nconst FILTERS: Filter[] = [\"all\", \"active\", \"completed\"];\n\nexport function App() {\n const [todos, setTodos] = useState([]);\n const [filter, setFilter] = useState(\"all\");\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n function showError(message: string) {\n setError(message);\n setTimeout(() => setError(null), 4000);\n }\n\n async function refresh() {\n try {\n setTodos(await api(\"/api/todos\"));\n setError(null);\n } catch (e) {\n showError(e instanceof Error ? e.message : \"Failed to load todos\");\n } finally {\n setLoading(false);\n }\n }\n\n useEffect(() => {\n refresh();\n }, []);\n\n async function addTodo(text: string) {\n try {\n const todo = await api(\"/api/todos\", {\n method: \"POST\",\n body: JSON.stringify({ text }),\n });\n setTodos((prev) => [todo, ...prev]);\n } catch (e) {\n showError(e instanceof Error ? e.message : \"Failed to add todo\");\n throw e;\n }\n }\n\n async function toggleTodo(todo: Todo) {\n // Optimistic update, roll back on failure\n setTodos((prev) =>\n prev.map((t) => t.id === todo.id ? { ...t, completed: !t.completed } : t)\n );\n try {\n await api(`/api/todos/${todo.id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ completed: !todo.completed }),\n });\n } catch (e) {\n setTodos((prev) => prev.map((t) => t.id === todo.id ? todo : t));\n showError(e instanceof Error ? e.message : \"Failed to update todo\");\n }\n }\n\n async function editTodo(id: number, text: string) {\n const previous = todos;\n setTodos((prev) => prev.map((t) => t.id === id ? { ...t, text } : t));\n try {\n await api(`/api/todos/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ text }),\n });\n } catch (e) {\n setTodos(previous);\n showError(e instanceof Error ? e.message : \"Failed to edit todo\");\n }\n }\n\n async function deleteTodo(id: number) {\n const previous = todos;\n setTodos((prev) => prev.filter((t) => t.id !== id));\n try {\n await api<{ ok: boolean }>(`/api/todos/${id}`, { method: \"DELETE\" });\n } catch (e) {\n setTodos(previous);\n showError(e instanceof Error ? e.message : \"Failed to delete todo\");\n }\n }\n\n async function clearCompleted() {\n const previous = todos;\n setTodos((prev) => prev.filter((t) => !t.completed));\n try {\n await api<{ cleared: number }>(\"/api/todos/clear-completed\", {\n method: \"POST\",\n });\n } catch (e) {\n setTodos(previous);\n showError(e instanceof Error ? e.message : \"Failed to clear completed\");\n }\n }\n\n const visible = todos.filter((t) =>\n filter === \"all\" ? true : filter === \"active\" ? !t.completed : t.completed\n );\n const activeCount = todos.filter((t) => !t.completed).length;\n const completedCount = todos.length - activeCount;\n\n return (\n

\n ✅ Todos\n

\n {activeCount} {activeCount === 1 ? \"task\" : \"tasks\"} remaining\n

\n\n {error && (\n \n {error}\n

\n )}\n\n \n\n

\n {FILTERS.map((f) => (\n setFilter(f)}\n class={`px-3 py-1 rounded-lg capitalize transition-colors cursor-pointer ${\n filter === f\n ? \"bg-indigo-100 text-indigo-700 font-medium\"\n : \"text-gray-500 hover:bg-gray-100\"\n }`}\n >\n {f}\n \n ))}\n

\n {completedCount > 0 && (\n \n Clear completed ({completedCount})\n \n )}\n

\n\n {loading\n ?

Loading…

\n : visible.length === 0\n ? (\n

\n {todos.length === 0\n ? \"No todos yet. Add one above! 🎉\"\n : `No ${filter} todos.`}\n

\n )\n : (\n

\n ))}\n

\n )}\n\n \n \n );\n}\n",[84,85,94],"1f35f3e6-6deb-4bcf-be5d-4586c6af4f7e","019f76c9-48ec-747c-8230-3feb2342c717",["D",1784404330602],"directory",[84,85],{"_36":188,"_13":189,"_65":190,"_67":-5,"_69":70,"_71":191,"_73":74,"_38":192,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":193,"_18":194},{"_36":143,"_13":84,"_65":102,"_67":-5,"_69":70,"_71":98,"_73":74,"_38":144,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":145,"_18":146},{"_36":129,"_13":130,"_65":131,"_67":-5,"_69":70,"_71":34,"_73":74,"_38":132,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":133,"_18":134},{"_36":121,"_13":122,"_65":123,"_67":-5,"_69":70,"_71":124,"_73":74,"_38":125,"_17":98,"_77":24,"_79":126,"_81":51,"_82":-5,"_118":127,"_18":128},{"_36":111,"_13":112,"_65":113,"_67":-5,"_69":70,"_71":114,"_73":74,"_38":115,"_17":98,"_77":116,"_79":117,"_81":51,"_82":-5,"_118":119,"_18":120},"6fc46c5f-7704-4ab3-b6d7-b36618fbf576","index.ts","019f76c9-48ec-747c-8230-47d98cf8330e",4,["D",1784404372218],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport * as db from \"./backend/db.ts\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// Serve shared types for the frontend\napp.get(\"/shared/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- Todos API ----\n\nconst MAX_TEXT_LENGTH = 500;\n\nfunction validateText(text: unknown): string | null {\n if (typeof text !== \"string\") return null;\n const trimmed = text.trim();\n if (trimmed.length === 0 || trimmed.length > MAX_TEXT_LENGTH) return null;\n return trimmed;\n}\n\nfunction parseId(raw: string): number | null {\n const id = Number(raw);\n return Number.isInteger(id) && id > 0 ? id : null;\n}\n\napp.get(\"/api/todos\", async (c) => {\n const todos = await db.listTodos();\n return c.json(todos);\n});\n\napp.post(\"/api/todos\", async (c) => {\n const body = await c.req.json().catch(() => null);\n const text = validateText(body?.text);\n if (!text) {\n return c.json(\n { error: `text is required (1-${MAX_TEXT_LENGTH} chars)` },\n 400,\n );\n }\n const todo = await db.createTodo(text);\n return c.json(todo, 201);\n});\n\napp.patch(\"/api/todos/:id\", async (c) => {\n const id = parseId(c.req.param(\"id\"));\n if (!id) return c.json({ error: \"invalid id\" }, 400);\n\n const body = await c.req.json().catch(() => null);\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"invalid body\" }, 400);\n }\n\n const fields: { text?: string; completed?: boolean } = {};\n if (\"text\" in body) {\n const text = validateText(body.text);\n if (!text) {\n return c.json(\n { error: `text must be 1-${MAX_TEXT_LENGTH} chars` },\n 400,\n );\n }\n fields.text = text;\n }\n if (\"completed\" in body) {\n if (typeof body.completed !== \"boolean\") {\n return c.json({ error: \"completed must be a boolean\" }, 400);\n }\n fields.completed = body.completed;\n }\n\n const todo = await db.updateTodo(id, fields);\n if (!todo) return c.json({ error: \"todo not found\" }, 404);\n return c.json(todo);\n});\n\napp.delete(\"/api/todos/:id\", async (c) => {\n const id = parseId(c.req.param(\"id\"));\n if (!id) return c.json({ error: \"invalid id\" }, 400);\n const deleted = await db.deleteTodo(id);\n if (!deleted) return c.json({ error: \"todo not found\" }, 404);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/todos/clear-completed\", async (c) => {\n const cleared = await db.clearCompleted();\n return c.json({ cleared });\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","children",[],[112],"ff87bc3c-a176-47db-93e9-431b73889970","README.md","019f76c9-48ec-747c-8230-43f68aa2cb1a",10,["D",1784404457706],"# Todo App\n\nA production-ready todo app built with React, Hono, and SQLite on Val Town.\n\n## Features\n\n- ✅ Add, edit (double-click), complete, and delete todos\n- 🔍 Filter by all / active / completed\n- 🧹 Clear all completed todos at once\n- ⚡ Optimistic UI updates with automatic rollback on failure\n- 💾 Persistent storage in val-scoped SQLite\n- 🛡️ Server-side input validation (1–500 chars, type checks)\n- 🚨 User-visible error messages + client errors surfaced to val logs\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser[\"React SPA
(frontend/)\"] -->|\"fetch /api/todos\"| Hono[\"index.ts
(Hono server)\"]\n Hono --> DB[\"backend/db.ts
(SQLite)\"]\n Hono -->|serves| Static[\"frontend/ files\"]\n```\n\n## File structure\n\n```\nindex.ts ← HTTP entrypoint: Hono server (static files + API)\nbackend/\n db.ts ← SQLite schema + query functions\nshared/\n types.ts ← Todo/Filter types shared by client & server\nfrontend/\n index.html ← HTML shell (Twind + React)\n index.tsx ← React entrypoint\n components/\n App.tsx ← Root component: state, API calls, filters\n TodoInput.tsx ← New-todo form\n TodoItem.tsx ← Single todo row (toggle/edit/delete)\n```\n\n## API\n\n| Method | Path | Description |\n| --- | --- | --- |\n| `GET` | `/api/todos` | List all todos |\n| `POST` | `/api/todos` | Create — body: `{ text }` |\n| `PATCH` | `/api/todos/:id` | Update — body: `{ text?, completed? }` |\n| `DELETE` | `/api/todos/:id` | Delete a todo |\n| `POST` | `/api/todos/clear-completed` | Delete all completed todos |\n\nAll endpoints return JSON; errors are `{ error: string }` with 400/404 status codes.\n\n## Notes\n\n- Data is stored in this val's scoped SQLite database (`todos_v1` table).\n- Schema setup is idempotent (`CREATE TABLE IF NOT EXISTS`), safe across restarts.\n- All queries are parameterized — no SQL injection.\n",[],[122],"3be65090-91e1-4d70-9ae5-c96d783baa9b","shared","328bcb98-fcc7-4755-a03b-b14a85ac6061",["D",1784404344892],[135],[130],{"_36":136,"_13":137,"_65":138,"_67":131,"_69":70,"_71":34,"_73":74,"_38":139,"_17":76,"_77":78,"_79":140,"_81":51,"_82":-5,"_118":141,"_18":142},"134e0c1a-5bfe-40c2-9bf5-2b750d398217","types.ts","32a3c1ce-82e2-11f1-9ce7-1607ee4eb77e",["D",1784404344892],"export interface Todo {\n id: number;\n text: string;\n completed: boolean;\n createdAt: string;\n}\n\nexport type Filter = \"all\" | \"active\" | \"completed\";\n",[],[130,137],"89f3b209-221b-44b6-ab94-610eff048f3e",["D",1784404330602],[147,148,149,150],[84],{"_36":101,"_13":85,"_65":68,"_67":102,"_69":70,"_71":98,"_73":74,"_38":173,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":174,"_18":175},{"_36":166,"_13":167,"_65":168,"_67":102,"_69":70,"_71":98,"_73":74,"_38":169,"_17":76,"_77":24,"_79":170,"_81":51,"_82":-5,"_118":171,"_18":172},{"_36":158,"_13":159,"_65":160,"_67":102,"_69":70,"_71":161,"_73":74,"_38":162,"_17":98,"_77":24,"_79":163,"_81":51,"_82":-5,"_118":164,"_18":165},{"_36":151,"_13":152,"_65":153,"_67":102,"_69":70,"_71":98,"_73":74,"_38":154,"_17":76,"_77":78,"_79":155,"_81":51,"_82":-5,"_118":156,"_18":157},"197d34ae-8cac-4cc6-87e5-b3388ea9a01e","index.tsx","019f76c9-48ec-747c-8230-38243d5ac0dc",["D",1784404330602],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[84,152],"49e20246-bd39-4f5d-8e8d-fa2976543ef8","index.html","019f76c9-48ec-747c-8230-3664e187b632",8,["D",1784404418940],"\n\n \n \n \n Todos\n \n \n \n \n

\n \n \n \n",[],[84,159],"034b04ff-51bf-42d5-a1ad-e1c7d334e8b0","favicon.svg","019f76c9-48ec-747c-8230-30a96bf481c2",["D",1784404330602],"\n",[],[84,167],["D",1784404330602],[176,177,178],[84,85],{"_36":93,"_13":94,"_65":95,"_67":68,"_69":70,"_71":96,"_73":74,"_38":185,"_17":98,"_77":78,"_79":99,"_81":51,"_82":-5,"_118":186,"_18":187},{"_36":86,"_13":87,"_65":88,"_67":68,"_69":70,"_71":89,"_73":74,"_38":182,"_17":76,"_77":78,"_79":91,"_81":51,"_82":-5,"_118":183,"_18":184},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":179,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_118":180,"_18":181},["D",1784404394083],[],[84,85,64],["D",1784404384799],[],[84,85,87],["D",1784404418188],[],[84,85,94],"e0f9aee7-2e17-4ac4-bd25-dd16ba86c183","backend","bae2d9a3-6411-466b-a8b2-8da9bfef0d43",3,["D",1784404353689],[195],[189],{"_36":196,"_13":197,"_65":198,"_67":190,"_69":70,"_71":191,"_73":74,"_38":199,"_17":76,"_77":78,"_79":200,"_81":51,"_82":-5,"_118":201,"_18":202},"71051082-14a9-4218-8526-23fa0f80018a","db.ts","37e20f6a-82e2-11f1-838b-1607ee4eb77e",["D",1784404353689],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Todo } from \"../shared/types.ts\";\n\nconst TABLE = \"todos_v1\";\n\n// Idempotent schema setup\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n completed INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))\n)`);\n\nfunction rowToTodo(row: Record): Todo {\n return {\n id: Number(row.id),\n text: String(row.text),\n completed: Boolean(row.completed),\n createdAt: String(row.created_at),\n };\n}\n\nexport async function listTodos(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE} ORDER BY completed ASC, created_at DESC`,\n );\n return result.rows.map(rowToTodo);\n}\n\nexport async function createTodo(text: string): Promise {\n const result = await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (text) VALUES (?) RETURNING *`,\n args: [text],\n });\n return rowToTodo(result.rows[0]);\n}\n\nexport async function updateTodo(\n id: number,\n fields: { text?: string; completed?: boolean },\n): Promise {\n const sets: string[] = [];\n const args: (string | number)[] = [];\n if (fields.text !== undefined) {\n sets.push(\"text = ?\");\n args.push(fields.text);\n }\n if (fields.completed !== undefined) {\n sets.push(\"completed = ?\");\n args.push(fields.completed ? 1 : 0);\n }\n if (sets.length === 0) return getTodo(id);\n args.push(id);\n const result = await sqlite.execute({\n sql: `UPDATE ${TABLE} SET ${sets.join(\", \")} WHERE id = ? RETURNING *`,\n args,\n });\n return result.rows.length ? rowToTodo(result.rows[0]) : null;\n}\n\nexport async function getTodo(id: number): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n return result.rows.length ? rowToTodo(result.rows[0]) : null;\n}\n\nexport async function deleteTodo(id: number): Promise {\n const result = await sqlite.execute({\n sql: `DELETE FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n return result.rowsAffected > 0;\n}\n\nexport async function clearCompleted(): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TABLE} WHERE completed = 1`,\n );\n return result.rowsAffected;\n}\n",[],[189,197],"96de70b5-cf69-4373-88be-fba56284d53f",["D",1784404330602],"legacyEnvVars","httpPrivacy","description","Production-ready todo app with React + Hono + SQLite","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789549199&sig=78a5bc27f03474c98a49b09a954e18cc6dd63f22ba19ce3e096717a88d3522b5","userId","23d6c179-74ab-40bf-910d-c9f38f237b3e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019f76c7-863b-76f6-960c-e9095bbf0cf4","tursoName","96de70b5cf69437388befba56284d53f","tursoHostname","96de70b5cf69437388befba56284d53f-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_252":248},"org",{"_11":12,"_245":246,"_247":248,"_211":212,"_249":250,"_251":51},"branch",{"_17":124,"_13":16,"_36":70,"_42":203,"_45":37,"_46":241,"_242":53,"_243":43,"_244":57,"_58":14,"_54":12},89,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Sammit Badodekar","avatar","https://lh3.googleusercontent.com/a/ACg8ocIQo7pgMGin8u5Xt1nd4WrJ3iSmUTsxwqbXj1smuSwPDnHPDUXn=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":203,"_13":14,"_38":337,"_49":-5,"_205":51,"_52":53,"_206":53,"_207":208,"_209":210,"_211":212,"_213":113,"_214":74,"_215":-5,"_216":-5,"_217":76,"_56":218,"_219":220,"_221":222,"_223":338,"_225":-5,"_226":227,"_228":227,"_229":230,"_231":230,"_232":230,"_233":227,"_234":227,"_235":339,"_237":340,"_239":341,"_50":51},[295,297,305,307,308],"files",[295,296,297,298,299,300,301,302,303,304,305,306,307,308],"counts",{"_286":76,"_287":98,"_288":76,"_35":289,"_290":291},[280,281,282],{"_36":101,"_13":85,"_65":68,"_67":102,"_69":70,"_71":98,"_73":74,"_38":103,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_18":279},"upstreamProject",{"_36":43,"_13":59,"_207":276,"_209":210,"_52":53,"_235":277},"upstreamBranch",{"_36":37,"_38":274,"_40":275,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],"Starter template with client-side React & Hono server",{"_11":55,"_252":278},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789549199&sig=85ec03bbe2ae9af315fa5e89fceebe840b59020b3ec43df39e2ab37ef0d215ad",[84,85],{"_36":93,"_13":94,"_65":95,"_67":68,"_69":70,"_71":96,"_73":74,"_38":97,"_17":98,"_77":78,"_79":99,"_81":51,"_82":-5,"_18":285},{"_36":86,"_13":87,"_65":88,"_67":68,"_69":70,"_71":89,"_73":74,"_38":90,"_17":76,"_77":78,"_79":91,"_81":51,"_82":-5,"_18":284},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_18":283},[84,85,64],[84,85,87],[84,85,94],"pulls","branches","forks",{"_292":76,"_294":76},"connections",{"_292":76,"_293":76},"count","unfilledCount","emptyCount",{"_36":188,"_13":189,"_65":190,"_67":-5,"_69":70,"_71":191,"_73":74,"_38":192,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":335,"_18":336},{"_36":196,"_13":197,"_65":198,"_67":190,"_69":70,"_71":191,"_73":74,"_38":199,"_17":76,"_77":78,"_79":200,"_81":51,"_82":-5,"_118":333,"_18":334},{"_36":143,"_13":84,"_65":102,"_67":-5,"_69":70,"_71":98,"_73":74,"_38":144,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":331,"_18":332},{"_36":101,"_13":85,"_65":68,"_67":102,"_69":70,"_71":98,"_73":74,"_38":173,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":329,"_18":330},{"_36":93,"_13":94,"_65":95,"_67":68,"_69":70,"_71":96,"_73":74,"_38":185,"_17":98,"_77":78,"_79":99,"_81":51,"_82":-5,"_118":327,"_18":328},{"_36":86,"_13":87,"_65":88,"_67":68,"_69":70,"_71":89,"_73":74,"_38":182,"_17":76,"_77":78,"_79":91,"_81":51,"_82":-5,"_118":325,"_18":326},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":179,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_118":323,"_18":324},{"_36":166,"_13":167,"_65":168,"_67":102,"_69":70,"_71":98,"_73":74,"_38":169,"_17":76,"_77":24,"_79":170,"_81":51,"_82":-5,"_118":321,"_18":322},{"_36":158,"_13":159,"_65":160,"_67":102,"_69":70,"_71":161,"_73":74,"_38":162,"_17":98,"_77":24,"_79":163,"_81":51,"_82":-5,"_118":319,"_18":320},{"_36":151,"_13":152,"_65":153,"_67":102,"_69":70,"_71":98,"_73":74,"_38":154,"_17":76,"_77":78,"_79":155,"_81":51,"_82":-5,"_118":317,"_18":318},{"_36":129,"_13":130,"_65":131,"_67":-5,"_69":70,"_71":34,"_73":74,"_38":132,"_17":76,"_77":104,"_79":-5,"_81":51,"_82":-5,"_118":315,"_18":316},{"_36":136,"_13":137,"_65":138,"_67":131,"_69":70,"_71":34,"_73":74,"_38":139,"_17":76,"_77":78,"_79":140,"_81":51,"_82":-5,"_118":313,"_18":314},{"_36":121,"_13":122,"_65":123,"_67":-5,"_69":70,"_71":124,"_73":74,"_38":125,"_17":98,"_77":24,"_79":126,"_81":51,"_82":-5,"_118":311,"_18":312},{"_36":111,"_13":112,"_65":113,"_67":-5,"_69":70,"_71":114,"_73":74,"_38":115,"_17":98,"_77":116,"_79":117,"_81":51,"_82":-5,"_118":309,"_18":310},[],[112],[],[122],[],[130,137],[306],[130],[],[84,152],[],[84,159],[],[84,167],[],[84,85,64],[],[84,85,87],[],[84,85,94],[299,300,301],[84,85],[298,302,303,304],[84],[],[189,197],[296],[189],["D",1784404330602],["D",1789472446807],{"_11":12,"_252":248},{"_11":12,"_245":246,"_247":248,"_211":212,"_249":250,"_251":51},{"_17":124,"_13":16,"_36":70,"_42":203,"_45":37,"_46":241,"_242":53,"_243":43,"_244":57,"_58":14,"_54":12},"ctx",{"_235":-5,"_271":375,"_376":377,"_378":379,"_380":51,"_381":51,"_382":51,"_383":74,"_384":-5,"_385":-7,"_386":-7,"_387":76,"_388":51,"_389":51,"_390":-5,"_391":51,"_392":51,"_393":51,"_394":-5},"ENV",{"_346":347,"_348":349,"_350":16,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374},"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"]