[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_346":347,"_348":349},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_255":-5,"_20":256,"_22":257,"_258":259,"_260":261,"_26":262,"_24":263,"_264":265,"_266":267,"_268":51,"_269":270,"_271":75,"_272":-5,"_273":-5,"_274":275},"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","project",{"_36":205,"_13":14,"_38":206,"_49":-5,"_207":51,"_52":53,"_208":53,"_209":210,"_211":212,"_213":214,"_215":114,"_216":75,"_217":-5,"_218":-5,"_219":77,"_56":220,"_221":222,"_223":224,"_225":226,"_227":-5,"_228":229,"_230":229,"_231":232,"_233":232,"_234":232,"_235":229,"_236":229,"_237":238,"_239":240,"_241":242,"_50":51},"tree",[107,108,109,110,111],"file",{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":105,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":106},"contents",[60,61,62,63],"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":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":101,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":103},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":95,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_18":97},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":89,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_18":91},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":76,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_18":84},"197d34ae-8cac-4cc6-87e5-b3388ea9a01e","index.tsx","fileId","019f76c9-48ec-747c-8230-38243d5ac0dc","parentId","019f76c9-48ec-747c-8230-3feb2342c717","branchId","a232f2f5-e74e-4b08-815d-f2388bec3492","branchVersion",1,"latest",true,["D",1784404330602],0,"fileType","script","content","/** @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();","deleted","label",[19,65],"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",[19,86],"034b04ff-51bf-42d5-a1ad-e1c7d334e8b0","favicon.svg","019f76c9-48ec-747c-8230-30a96bf481c2",["D",1784404330602],"\n",[19,93],"1f35f3e6-6deb-4bcf-be5d-4586c6af4f7e","components","019f76c9-48ec-747c-8230-2dcaac3b7e51",["D",1784404330602],"directory",[19,99],"89f3b209-221b-44b6-ab94-610eff048f3e",["D",1784404330602],[19],{"_36":190,"_13":191,"_66":192,"_68":-5,"_70":71,"_72":193,"_74":75,"_38":194,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":195,"_18":196},{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":144,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":145,"_18":146},{"_36":130,"_13":131,"_66":132,"_68":-5,"_70":71,"_72":34,"_74":75,"_38":133,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":134,"_18":135},{"_36":122,"_13":123,"_66":124,"_68":-5,"_70":71,"_72":125,"_74":75,"_38":126,"_17":73,"_78":24,"_80":127,"_82":51,"_83":-5,"_119":128,"_18":129},{"_36":112,"_13":113,"_66":114,"_68":-5,"_70":71,"_72":115,"_74":75,"_38":116,"_17":73,"_78":117,"_80":118,"_82":51,"_83":-5,"_119":120,"_18":121},"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",[],[113],"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",[],[123],"3be65090-91e1-4d70-9ae5-c96d783baa9b","shared","328bcb98-fcc7-4755-a03b-b14a85ac6061",["D",1784404344892],[136],[131],{"_36":137,"_13":138,"_66":139,"_68":132,"_70":71,"_72":34,"_74":75,"_38":140,"_17":77,"_78":79,"_80":141,"_82":51,"_83":-5,"_119":142,"_18":143},"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",[],[131,138],["D",1784404330602],[147,148,149,150],[19],{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":160,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":161,"_18":162},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":157,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_119":158,"_18":159},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":154,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_119":155,"_18":156},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":151,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_119":152,"_18":153},["D",1784404330602],[],[19,65],["D",1784404418940],[],[19,86],["D",1784404330602],[],[19,93],["D",1784404330602],[163,164,165],[19,99],{"_36":182,"_13":183,"_66":184,"_68":100,"_70":71,"_72":185,"_74":75,"_38":186,"_17":73,"_78":79,"_80":187,"_82":51,"_83":-5,"_119":188,"_18":189},{"_36":174,"_13":175,"_66":176,"_68":100,"_70":71,"_72":177,"_74":75,"_38":178,"_17":77,"_78":79,"_80":179,"_82":51,"_83":-5,"_119":180,"_18":181},{"_36":166,"_13":167,"_66":168,"_68":100,"_70":71,"_72":169,"_74":75,"_38":170,"_17":77,"_78":79,"_80":171,"_82":51,"_83":-5,"_119":172,"_18":173},"92c760e2-8423-4a18-9a9e-5db1a68d10b2","TodoItem.tsx","4ff57344-82e2-11f1-8733-1607ee4eb77e",6,["D",1784404394083],"/** @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",[],[19,99,167],"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",[],[19,99,175],"2f8af389-17b6-49d5-a012-62205912cdab","App.tsx","019f76c9-48eb-72d8-ad33-f2fdd02bc82a",7,["D",1784404418188],"/** @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",[],[19,99,183],"e0f9aee7-2e17-4ac4-bd25-dd16ba86c183","backend","bae2d9a3-6411-466b-a8b2-8da9bfef0d43",3,["D",1784404353689],[197],[191],{"_36":198,"_13":199,"_66":200,"_68":192,"_70":71,"_72":193,"_74":75,"_38":201,"_17":77,"_78":79,"_80":202,"_82":51,"_83":-5,"_119":203,"_18":204},"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",[],[191,199],"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=1789538399&sig=d91a7ef87f90c894c3b8d0b9fb95840fd02478ac34a646812058e001671e6ecb","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,"_254":250},"org",{"_11":12,"_247":248,"_249":250,"_213":214,"_251":252,"_253":51},"branch",{"_17":125,"_13":16,"_36":71,"_42":205,"_45":37,"_46":243,"_244":53,"_245":43,"_246":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":205,"_13":14,"_38":341,"_49":-5,"_207":51,"_52":53,"_208":53,"_209":210,"_211":212,"_213":214,"_215":114,"_216":75,"_217":-5,"_218":-5,"_219":77,"_56":220,"_221":222,"_223":224,"_225":342,"_227":-5,"_228":229,"_230":229,"_231":232,"_233":232,"_234":232,"_235":229,"_236":229,"_237":343,"_239":344,"_241":345,"_50":51},[299,301,309,311,312],"files",[299,300,301,302,303,304,305,306,307,308,309,310,311,312],"counts",{"_290":77,"_291":73,"_292":77,"_35":293,"_294":295},[282,283,284,285],{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":105,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":281},"upstreamProject",{"_36":43,"_13":59,"_209":278,"_211":212,"_52":53,"_237":279},"upstreamBranch",{"_36":37,"_38":276,"_40":277,"_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,"_254":280},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789538399&sig=ed57122c136965e1015088c1b79a18d1d4e6250d1eb81abacde1e740f48894e7",[19],{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":101,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":289},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":95,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_18":288},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":89,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_18":287},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":76,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_18":286},[19,65],[19,86],[19,93],[19,99],"pulls","branches","forks",{"_296":77,"_298":77},"connections",{"_296":77,"_297":77},"count","unfilledCount","emptyCount",{"_36":190,"_13":191,"_66":192,"_68":-5,"_70":71,"_72":193,"_74":75,"_38":194,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":339,"_18":340},{"_36":198,"_13":199,"_66":200,"_68":192,"_70":71,"_72":193,"_74":75,"_38":201,"_17":77,"_78":79,"_80":202,"_82":51,"_83":-5,"_119":337,"_18":338},{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":144,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":335,"_18":336},{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":160,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":333,"_18":334},{"_36":182,"_13":183,"_66":184,"_68":100,"_70":71,"_72":185,"_74":75,"_38":186,"_17":73,"_78":79,"_80":187,"_82":51,"_83":-5,"_119":331,"_18":332},{"_36":174,"_13":175,"_66":176,"_68":100,"_70":71,"_72":177,"_74":75,"_38":178,"_17":77,"_78":79,"_80":179,"_82":51,"_83":-5,"_119":329,"_18":330},{"_36":166,"_13":167,"_66":168,"_68":100,"_70":71,"_72":169,"_74":75,"_38":170,"_17":77,"_78":79,"_80":171,"_82":51,"_83":-5,"_119":327,"_18":328},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":157,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_119":325,"_18":326},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":154,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_119":323,"_18":324},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":151,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_119":321,"_18":322},{"_36":130,"_13":131,"_66":132,"_68":-5,"_70":71,"_72":34,"_74":75,"_38":133,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_119":319,"_18":320},{"_36":137,"_13":138,"_66":139,"_68":132,"_70":71,"_72":34,"_74":75,"_38":140,"_17":77,"_78":79,"_80":141,"_82":51,"_83":-5,"_119":317,"_18":318},{"_36":122,"_13":123,"_66":124,"_68":-5,"_70":71,"_72":125,"_74":75,"_38":126,"_17":73,"_78":24,"_80":127,"_82":51,"_83":-5,"_119":315,"_18":316},{"_36":112,"_13":113,"_66":114,"_68":-5,"_70":71,"_72":115,"_74":75,"_38":116,"_17":73,"_78":117,"_80":118,"_82":51,"_83":-5,"_119":313,"_18":314},[],[113],[],[123],[],[131,138],[310],[131],[],[19,65],[],[19,86],[],[19,93],[],[19,99,167],[],[19,99,175],[],[19,99,183],[303,304,305],[19,99],[302,306,307,308],[19],[],[191,199],[300],[191],["D",1784404330602],["D",1789472446807],{"_11":12,"_254":250},{"_11":12,"_247":248,"_249":250,"_213":214,"_251":252,"_253":51},{"_17":125,"_13":16,"_36":71,"_42":205,"_45":37,"_46":243,"_244":53,"_245":43,"_246":57,"_58":14,"_54":12},"ctx",{"_237":-5,"_273":379,"_380":381,"_382":383,"_384":51,"_385":51,"_386":51,"_387":75,"_388":-5,"_389":-7,"_390":-7,"_391":77,"_392":51,"_393":51,"_394":-5,"_395":51,"_396":51,"_397":51,"_398":-5},"ENV",{"_350":351,"_352":353,"_354":16,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378},"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"]