[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_311":312,"_313":314},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_234":-5,"_20":235,"_22":236,"_237":238,"_239":240,"_26":241,"_24":242,"_243":-5,"_244":-5,"_245":70,"_246":247,"_248":64,"_249":-5,"_250":-5,"_251":252},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","warianoguerra","name","recursive-task-lists","branchName","main","version","path","frontend/index.html","project",{"_33":177,"_13":14,"_46":178,"_179":-5,"_180":70,"_181":182,"_183":182,"_184":185,"_186":-5,"_187":188,"_189":61,"_190":64,"_191":-5,"_192":-5,"_193":43,"_194":195,"_196":197,"_198":199,"_200":201,"_202":-5,"_203":204,"_205":204,"_206":207,"_208":207,"_209":207,"_210":204,"_211":204,"_212":213,"_214":215,"_216":217,"_218":70},"tree",[53,54,55,56,57,58],"file",{"_33":34,"_35":36,"_37":38,"_13":39,"_40":41,"_42":24,"_17":43,"_44":45,"_46":47,"_48":49,"_50":-5,"_18":51},"contents",[],"upstream","pull","ahead","behind","envVars","id","bac0e356-38b0-11f1-ae62-42b51c65c3df","branchId","e50aa8b4-38af-11f1-998b-42b51c65c3df","fileId","bac0e41e-38b0-11f1-ae62-42b51c65c3df","index.html","content","\n\n\n \n \n Recursive Task Lists\n\n\n

Recursive Task Lists

Open the browser console to see API results.

\n \n\n\n","fileType",0,"parentId","b23c25e2-38b0-11f1-b859-42b51c65c3df","createdAt",["D",1776246712369],"branchVersion",14,"label",[52,39],"frontend",{"_33":152,"_13":153,"_37":154,"_44":-5,"_35":36,"_48":155,"_63":64,"_46":156,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":157,"_18":158},{"_33":125,"_13":52,"_37":45,"_44":-5,"_35":36,"_48":126,"_63":64,"_46":127,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":128,"_18":129},{"_33":109,"_13":110,"_37":111,"_44":-5,"_35":36,"_48":112,"_63":64,"_46":113,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":114,"_18":115},{"_33":82,"_13":83,"_37":84,"_44":-5,"_35":36,"_48":85,"_63":64,"_46":86,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":88,"_18":89},{"_33":74,"_13":75,"_37":76,"_44":-5,"_35":36,"_48":77,"_63":64,"_46":78,"_17":43,"_42":24,"_40":79,"_69":70,"_50":-5,"_71":80,"_18":81},{"_33":59,"_13":60,"_37":61,"_44":-5,"_35":36,"_48":62,"_63":64,"_46":65,"_17":66,"_42":67,"_40":68,"_69":70,"_50":-5,"_71":72,"_18":73},"c2c33c02-38b0-11f1-ae62-42b51c65c3df","main.ts","e50f35d2-38af-11f1-998b-42b51c65c3df",15,"latest",true,["D",1776246725803],1,"http","import { Hono } from \"npm:hono\";\nimport { oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { authMiddleware } from \"./middleware/auth.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { taskListRoutes } from \"./routes/task-lists.ts\";\nimport { taskRoutes } from \"./routes/tasks.ts\";\n\nconst app = new Hono();\n\napp.onError((err) => Promise.reject(err));\n\n// Run migrations on first request\nlet migrated = false;\napp.use(\"*\", async (c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n await next();\n});\n\n// Serve frontend\napp.get(\"/\", (c) => serveFile(\"frontend/index.html\", import.meta.url));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\napp.get(\"/docs\", (c) => c.json({\n endpoints: {\n \"GET /api/task-lists\": \"List all task lists\",\n \"POST /api/task-lists\": \"Create a task list { title, description? }\",\n \"GET /api/task-lists/:id\": \"Get a task list with all tasks (recursive)\",\n \"PUT /api/task-lists/:id\": \"Update a task list { title?, description? }\",\n \"DELETE /api/task-lists/:id\": \"Delete a task list and all its tasks\",\n \"POST /api/task-lists/:listId/tasks\": \"Create a task { title, description?, parent_task_id? }\",\n \"GET /api/tasks/:id\": \"Get a task with subtasks (recursive)\",\n \"PUT /api/tasks/:id\": \"Update a task { title?, description?, done? }\",\n \"DELETE /api/tasks/:id\": \"Delete a task and all subtasks\",\n \"POST /api/tasks/:id/subtasks\": \"Add a subtask { title, description? }\",\n },\n auth: \"All /api/* endpoints require Val Town OAuth. Visit /auth/login to authenticate.\",\n}));\n\n// Protect all API routes - owner only\napp.use(\"/api/*\", authMiddleware);\n\n// Mount routes\napp.route(\"/api\", taskListRoutes);\napp.route(\"/api\", taskRoutes);\n\nexport default oauthMiddleware(app.fetch);\n","deleted",false,"children",[],[60],"17d1fda6-38b0-11f1-bddd-42b51c65c3df","README.md","17d1fe5a-38b0-11f1-bddd-42b51c65c3df",10,["D",1776246439014],"# Recursive Task Lists API\n\nA REST API for managing recursive task lists, built on Val Town with per-val SQLite and owner-only OAuth authentication.\n\n## Authentication\n\nAll `/api/*` endpoints are protected. Only the val owner can access them.\n\n1. Visit `/auth/login` to authenticate via Val Town OAuth\n2. After login, your session cookie is set automatically\n3. All subsequent API requests use that cookie\n\nUnauthenticated requests return `401`. Non-owner users get `403`.\n\n## Endpoints\n\n### Task Lists\n\n| Method | Path | Description |\n|--------|------|-------------|\n| `GET` | `/api/task-lists` | List all task lists |\n| `POST` | `/api/task-lists` | Create a task list |\n| `GET` | `/api/task-lists/:id` | Get a task list with full recursive task tree |\n| `PUT` | `/api/task-lists/:id` | Update title/description |\n| `DELETE` | `/api/task-lists/:id` | Delete a list and all its tasks |\n\n### Tasks\n\n| Method | Path | Description |\n|--------|------|-------------|\n| `POST` | `/api/task-lists/:listId/tasks` | Create a top-level task (or nested via `parent_task_id`) |\n| `GET` | `/api/tasks/:id` | Get a task with its subtask tree |\n| `PUT` | `/api/tasks/:id` | Update title, description, or mark done |\n| `DELETE` | `/api/tasks/:id` | Delete a task and all subtasks |\n| `POST` | `/api/tasks/:id/subtasks` | Add a subtask to a task |\n\n## Data Model\n\n```mermaid\nerDiagram\n task_lists {\n int id PK\n text title\n text description\n text created_at\n text updated_at\n }\n tasks {\n int id PK\n int task_list_id FK\n int parent_task_id FK \"nullable, self-ref\"\n text title\n text description\n int done \"0 or 1\"\n text created_at\n text updated_at\n }\n task_lists ||--o{ tasks : contains\n tasks ||--o{ tasks : subtasks\n```\n\n## Example Usage\n\n```bash\n# Create a task list\ncurl -X POST /api/task-lists \\\n -H \"Content-Type: application/json\" \\\n -d '{\"title\": \"My Project\", \"description\": \"Things to do\"}'\n\n# Add a task\ncurl -X POST /api/task-lists/1/tasks \\\n -H \"Content-Type: application/json\" \\\n -d '{\"title\": \"Setup environment\"}'\n\n# Add a subtask\ncurl -X POST /api/tasks/1/subtasks \\\n -H \"Content-Type: application/json\" \\\n -d '{\"title\": \"Install dependencies\"}'\n\n# Mark task as done\ncurl -X PUT /api/tasks/1 \\\n -H \"Content-Type: application/json\" \\\n -d '{\"done\": true}'\n\n# Get full tree\ncurl /api/task-lists/1\n```\n\n## Project Structure\n\n```\nmain.ts # Hono HTTP entrypoint + OAuth wrapper\nmiddleware/auth.ts # Owner-only auth middleware\ndatabase/migrations.ts # SQLite schema\ndatabase/queries.ts # All DB operations + recursive tree builder\nroutes/task-lists.ts # Task list CRUD routes\nroutes/tasks.ts # Task CRUD + subtask routes\n```\n",[],[75],"e7320146-38af-11f1-998b-42b51c65c3df","routes","e7320204-38af-11f1-998b-42b51c65c3df",4,["D",1776246357435],"directory",[90,91],[83],{"_33":101,"_13":102,"_37":103,"_44":84,"_35":36,"_48":104,"_63":64,"_46":105,"_17":43,"_42":97,"_40":106,"_69":70,"_50":-5,"_71":107,"_18":108},{"_33":92,"_13":93,"_37":94,"_44":84,"_35":36,"_48":95,"_63":64,"_46":96,"_17":43,"_42":97,"_40":98,"_69":70,"_50":-5,"_71":99,"_18":100},"028d3c1c-38b0-11f1-9211-42b51c65c3df","tasks.ts","028d3cda-38b0-11f1-9211-42b51c65c3df",9,["D",1776246403332],"script","import { Hono } from \"npm:hono\";\nimport {\n getTaskById,\n updateTask,\n deleteTask,\n createTask,\n getTasksByListId,\n buildTaskTree,\n} from \"../database/queries.ts\";\n\nexport const taskRoutes = new Hono();\n\n// Get a task with its subtask tree\ntaskRoutes.get(\"/tasks/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (isNaN(id)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const task = await getTaskById(id);\n if (!task) return c.json({ error: \"Task not found\" }, 404);\n\n // Build subtree for this task\n const allTasks = await getTasksByListId(task.task_list_id as number);\n const tree = buildTaskTree(allTasks as any, id);\n\n return c.json({\n ...task,\n done: !!(task as any).done,\n subtasks: tree,\n });\n});\n\n// Update a task (title, description, done)\ntaskRoutes.put(\"/tasks/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (isNaN(id)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const existing = await getTaskById(id);\n if (!existing) return c.json({ error: \"Task not found\" }, 404);\n\n const body = await c.req.json();\n const updated = await updateTask(id, {\n title: body.title,\n description: body.description,\n done: body.done,\n });\n\n if (updated) {\n (updated as any).done = !!(updated as any).done;\n }\n\n return c.json(updated);\n});\n\n// Delete a task and all its subtasks\ntaskRoutes.delete(\"/tasks/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (isNaN(id)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const deleted = await deleteTask(id);\n if (!deleted) return c.json({ error: \"Task not found\" }, 404);\n\n return c.json({ ok: true });\n});\n\n// Add a subtask to a task\ntaskRoutes.post(\"/tasks/:id/subtasks\", async (c) => {\n const parentId = Number(c.req.param(\"id\"));\n if (isNaN(parentId)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const parent = await getTaskById(parentId);\n if (!parent) return c.json({ error: \"Parent task not found\" }, 404);\n\n const body = await c.req.json();\n const { title, description } = body;\n\n if (!title || typeof title !== \"string\") {\n return c.json({ error: \"title is required and must be a string\" }, 400);\n }\n\n const task = await createTask(\n parent.task_list_id as number,\n title,\n description ?? \"\",\n parentId,\n );\n return c.json(task, 201);\n});\n",[],[83,93],"fde0b5c2-38af-11f1-9211-42b51c65c3df","task-lists.ts","fde0b6a8-38af-11f1-9211-42b51c65c3df",8,["D",1776246395490],"import { Hono } from \"npm:hono\";\nimport {\n getAllTaskLists,\n getTaskListById,\n createTaskList,\n updateTaskList,\n deleteTaskList,\n getTasksByListId,\n buildTaskTree,\n createTask,\n} from \"../database/queries.ts\";\n\nexport const taskListRoutes = new Hono();\n\n// List all task lists\ntaskListRoutes.get(\"/task-lists\", async (c) => {\n const lists = await getAllTaskLists();\n return c.json(lists);\n});\n\n// Get a single task list with recursive task tree\ntaskListRoutes.get(\"/task-lists/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (isNaN(id)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const list = await getTaskListById(id);\n if (!list) return c.json({ error: \"Task list not found\" }, 404);\n\n const tasks = await getTasksByListId(id);\n const tree = buildTaskTree(tasks as any);\n\n return c.json({ ...list, tasks: tree });\n});\n\n// Create a task list\ntaskListRoutes.post(\"/task-lists\", async (c) => {\n const body = await c.req.json();\n const { title, description } = body;\n\n if (!title || typeof title !== \"string\") {\n return c.json({ error: \"title is required and must be a string\" }, 400);\n }\n\n const list = await createTaskList(title, description ?? \"\");\n return c.json(list, 201);\n});\n\n// Update a task list\ntaskListRoutes.put(\"/task-lists/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (isNaN(id)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const existing = await getTaskListById(id);\n if (!existing) return c.json({ error: \"Task list not found\" }, 404);\n\n const body = await c.req.json();\n const updated = await updateTaskList(id, {\n title: body.title,\n description: body.description,\n });\n\n return c.json(updated);\n});\n\n// Delete a task list\ntaskListRoutes.delete(\"/task-lists/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n if (isNaN(id)) return c.json({ error: \"Invalid ID\" }, 400);\n\n const deleted = await deleteTaskList(id);\n if (!deleted) return c.json({ error: \"Task list not found\" }, 404);\n\n return c.json({ ok: true });\n});\n\n// Create a task in a list\ntaskListRoutes.post(\"/task-lists/:listId/tasks\", async (c) => {\n const listId = Number(c.req.param(\"listId\"));\n if (isNaN(listId)) return c.json({ error: \"Invalid list ID\" }, 400);\n\n const list = await getTaskListById(listId);\n if (!list) return c.json({ error: \"Task list not found\" }, 404);\n\n const body = await c.req.json();\n const { title, description, parent_task_id } = body;\n\n if (!title || typeof title !== \"string\") {\n return c.json({ error: \"title is required and must be a string\" }, 400);\n }\n\n const task = await createTask(listId, title, description ?? \"\", parent_task_id ?? null);\n return c.json(task, 201);\n});\n",[],[83,102],"e6ef8fbe-38af-11f1-97a2-42b51c65c3df","middleware","e6ef9086-38af-11f1-97a2-42b51c65c3df",3,["D",1776246357000],[116],[110],{"_33":117,"_13":118,"_37":119,"_44":111,"_35":36,"_48":120,"_63":64,"_46":121,"_17":43,"_42":97,"_40":122,"_69":70,"_50":-5,"_71":123,"_18":124},"f8dd2c18-38af-11f1-998b-42b51c65c3df","auth.ts","f8dd2cd6-38af-11f1-998b-42b51c65c3df",7,["D",1776246387032],"import { createMiddleware } from \"npm:hono/factory\";\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n/**\n * Auth middleware that restricts API access to the val owner only.\n * Uses Val Town OAuth to identify the user, then checks if they\n * belong to the org that owns this val (i.e., the val owner).\n */\nexport const authMiddleware = createMiddleware(async (c, next) => {\n const session = await getOAuthUserData(c.req.raw);\n\n if (!session) {\n return c.json(\n { error: \"Unauthorized. Visit /auth/login to authenticate with Val Town.\" },\n 401,\n );\n }\n\n // Only allow the org member (val owner) to access the API\n if (!session.isOrgMember) {\n return c.json(\n { error: \"Forbidden. Only the owner of this val can access this API.\" },\n 403,\n );\n }\n\n // Attach user info to context for downstream handlers\n c.set(\"user\", session.user);\n await next();\n});\n",[],[110,118],"b23c2524-38b0-11f1-b859-42b51c65c3df",11,["D",1776246698081],[130,131,132],[52],{"_33":144,"_13":145,"_37":146,"_44":45,"_35":36,"_48":147,"_63":64,"_46":148,"_17":43,"_42":97,"_40":149,"_69":70,"_50":-5,"_71":150,"_18":151},{"_33":136,"_13":137,"_37":138,"_44":45,"_35":36,"_48":139,"_63":64,"_46":140,"_17":43,"_42":97,"_40":141,"_69":70,"_50":-5,"_71":142,"_18":143},{"_33":34,"_13":39,"_37":38,"_44":45,"_35":36,"_48":49,"_63":64,"_46":133,"_17":43,"_42":24,"_40":41,"_69":70,"_50":-5,"_71":134,"_18":135},["D",1776246712369],[],[52,39],"b9c9be8c-38b0-11f1-9335-42b51c65c3df","app.js","b9c9bf5e-38b0-11f1-9335-42b51c65c3df",13,["D",1776246710728],"import { getTaskLists, getTaskList } from \"./api.js\";\n\nasync function main() {\n console.log(\"=== Recursive Task Lists ===\");\n\n try {\n const lists = await getTaskLists();\n console.log(\"Task Lists:\", lists);\n\n for (const list of lists) {\n const full = await getTaskList(list.id);\n console.log(`Task List #${list.id} \"${list.title}\":`, full);\n }\n\n if (lists.length === 0) {\n console.log(\"No task lists found. Use the API to create one.\");\n }\n } catch (err) {\n if (err.message.includes(\"Unauthorized\")) {\n console.error(\"Not authenticated. Redirecting to login...\");\n document.getElementById(\"app\").innerHTML =\n '

Not authenticated. Log in with Val Town

';\n } else {\n console.error(\"Error:\", err.message);\n }\n }\n}\n\nmain();\n",[],[52,137],"b73bcc96-38b0-11f1-87f1-42b51c65c3df","api.js","b73bcd36-38b0-11f1-87f1-42b51c65c3df",12,["D",1776246706468],"const BASE = \"/api\";\n\nasync function request(path, options = {}) {\n const res = await fetch(`${BASE}${path}`, {\n headers: { \"Content-Type\": \"application/json\", ...options.headers },\n ...options,\n });\n if (!res.ok) {\n const err = await res.json().catch(() => ({ error: res.statusText }));\n throw new Error(err.error || `HTTP ${res.status}`);\n }\n return res.json();\n}\n\n// ── Task Lists ──\n\nexport function getTaskLists() {\n return request(\"/task-lists\");\n}\n\nexport function getTaskList(id) {\n return request(`/task-lists/${id}`);\n}\n\nexport function createTaskList(title, description = \"\") {\n return request(\"/task-lists\", {\n method: \"POST\",\n body: JSON.stringify({ title, description }),\n });\n}\n\nexport function updateTaskList(id, fields) {\n return request(`/task-lists/${id}`, {\n method: \"PUT\",\n body: JSON.stringify(fields),\n });\n}\n\nexport function deleteTaskList(id) {\n return request(`/task-lists/${id}`, { method: \"DELETE\" });\n}\n\n// ── Tasks ──\n\nexport function createTask(listId, title, description = \"\", parentTaskId = null) {\n return request(`/task-lists/${listId}/tasks`, {\n method: \"POST\",\n body: JSON.stringify({ title, description, parent_task_id: parentTaskId }),\n });\n}\n\nexport function getTask(id) {\n return request(`/tasks/${id}`);\n}\n\nexport function updateTask(id, fields) {\n return request(`/tasks/${id}`, {\n method: \"PUT\",\n body: JSON.stringify(fields),\n });\n}\n\nexport function deleteTask(id) {\n return request(`/tasks/${id}`, { method: \"DELETE\" });\n}\n\nexport function addSubtask(parentId, title, description = \"\") {\n return request(`/tasks/${parentId}/subtasks`, {\n method: \"POST\",\n body: JSON.stringify({ title, description }),\n });\n}\n",[],[52,145],"e6a83510-38af-11f1-97a2-42b51c65c3df","database","e6a835e2-38af-11f1-97a2-42b51c65c3df",2,["D",1776246356532],[159,160],[153],{"_33":169,"_13":170,"_37":171,"_44":154,"_35":36,"_48":172,"_63":64,"_46":173,"_17":43,"_42":97,"_40":174,"_69":70,"_50":-5,"_71":175,"_18":176},{"_33":161,"_13":162,"_37":163,"_44":154,"_35":36,"_48":164,"_63":64,"_46":165,"_17":43,"_42":97,"_40":166,"_69":70,"_50":-5,"_71":167,"_18":168},"f4462f10-38af-11f1-895a-42b51c65c3df","queries.ts","f4462ff6-38af-11f1-895a-42b51c65c3df",6,["D",1776246379314],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ── Task Lists ──\n\nexport async function getAllTaskLists() {\n const result = await sqlite.execute(\"SELECT * FROM task_lists ORDER BY created_at DESC\");\n return result.rows;\n}\n\nexport async function getTaskListById(id: number) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM task_lists WHERE id = ?\",\n args: [id],\n });\n return result.rows[0] ?? null;\n}\n\nexport async function createTaskList(title: string, description = \"\") {\n const result = await sqlite.execute({\n sql: \"INSERT INTO task_lists (title, description) VALUES (?, ?) RETURNING *\",\n args: [title, description],\n });\n return result.rows[0];\n}\n\nexport async function updateTaskList(id: number, fields: { title?: string; description?: string }) {\n const sets: string[] = [];\n const args: unknown[] = [];\n\n if (fields.title !== undefined) {\n sets.push(\"title = ?\");\n args.push(fields.title);\n }\n if (fields.description !== undefined) {\n sets.push(\"description = ?\");\n args.push(fields.description);\n }\n if (sets.length === 0) return getTaskListById(id);\n\n sets.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n const result = await sqlite.execute({\n sql: `UPDATE task_lists SET ${sets.join(\", \")} WHERE id = ? RETURNING *`,\n args,\n });\n return result.rows[0] ?? null;\n}\n\nexport async function deleteTaskList(id: number) {\n // Delete all tasks first (cascade may not work with all SQLite builds)\n await sqlite.execute({ sql: \"DELETE FROM tasks WHERE task_list_id = ?\", args: [id] });\n const result = await sqlite.execute({\n sql: \"DELETE FROM task_lists WHERE id = ?\",\n args: [id],\n });\n return result.rowsAffected > 0;\n}\n\n// ── Tasks ──\n\nexport async function getTasksByListId(listId: number) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE task_list_id = ? ORDER BY created_at ASC\",\n args: [listId],\n });\n return result.rows;\n}\n\nexport async function getTaskById(id: number) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM tasks WHERE id = ?\",\n args: [id],\n });\n return result.rows[0] ?? null;\n}\n\nexport async function createTask(\n taskListId: number,\n title: string,\n description = \"\",\n parentTaskId: number | null = null,\n) {\n const result = await sqlite.execute({\n sql: \"INSERT INTO tasks (task_list_id, title, description, parent_task_id) VALUES (?, ?, ?, ?) RETURNING *\",\n args: [taskListId, title, description, parentTaskId],\n });\n return result.rows[0];\n}\n\nexport async function updateTask(id: number, fields: { title?: string; description?: string; done?: boolean }) {\n const sets: string[] = [];\n const args: unknown[] = [];\n\n if (fields.title !== undefined) {\n sets.push(\"title = ?\");\n args.push(fields.title);\n }\n if (fields.description !== undefined) {\n sets.push(\"description = ?\");\n args.push(fields.description);\n }\n if (fields.done !== undefined) {\n sets.push(\"done = ?\");\n args.push(fields.done ? 1 : 0);\n }\n if (sets.length === 0) return getTaskById(id);\n\n sets.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n const result = await sqlite.execute({\n sql: `UPDATE tasks SET ${sets.join(\", \")} WHERE id = ? RETURNING *`,\n args,\n });\n return result.rows[0] ?? null;\n}\n\nexport async function deleteTask(id: number) {\n // Recursively delete subtasks first\n await deleteSubtasks(id);\n const result = await sqlite.execute({\n sql: \"DELETE FROM tasks WHERE id = ?\",\n args: [id],\n });\n return result.rowsAffected > 0;\n}\n\nasync function deleteSubtasks(parentId: number) {\n const children = await sqlite.execute({\n sql: \"SELECT id FROM tasks WHERE parent_task_id = ?\",\n args: [parentId],\n });\n for (const child of children.rows) {\n await deleteSubtasks(child.id as number);\n await sqlite.execute({ sql: \"DELETE FROM tasks WHERE id = ?\", args: [child.id as number] });\n }\n}\n\n// ── Tree builder ──\n\ninterface TaskRow {\n id: number;\n task_list_id: number;\n parent_task_id: number | null;\n title: string;\n description: string;\n done: number;\n created_at: string;\n updated_at: string;\n}\n\nexport interface TaskTree {\n id: number;\n task_list_id: number;\n parent_task_id: number | null;\n title: string;\n description: string;\n done: boolean;\n created_at: string;\n updated_at: string;\n subtasks: TaskTree[];\n}\n\nexport function buildTaskTree(tasks: TaskRow[], parentId: number | null = null): TaskTree[] {\n return tasks\n .filter((t) => t.parent_task_id === parentId)\n .map((t) => ({\n id: t.id,\n task_list_id: t.task_list_id,\n parent_task_id: t.parent_task_id,\n title: t.title,\n description: t.description,\n done: !!t.done,\n created_at: t.created_at,\n updated_at: t.updated_at,\n subtasks: buildTaskTree(tasks, t.id),\n }));\n}\n",[],[153,162],"eb1dc9e8-38af-11f1-bba5-42b51c65c3df","migrations.ts","eb1dca88-38af-11f1-bba5-42b51c65c3df",5,["D",1776246364004],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS task_lists (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS tasks (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n task_list_id INTEGER NOT NULL,\n parent_task_id INTEGER DEFAULT NULL,\n title TEXT NOT NULL,\n description TEXT DEFAULT '',\n done INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (task_list_id) REFERENCES task_lists(id) ON DELETE CASCADE,\n FOREIGN KEY (parent_task_id) REFERENCES tasks(id) ON DELETE CASCADE\n )`,\n },\n {\n sql: `CREATE INDEX IF NOT EXISTS idx_tasks_list ON tasks(task_list_id)`,\n },\n {\n sql: `CREATE INDEX IF NOT EXISTS idx_tasks_parent ON tasks(parent_task_id)`,\n },\n ]);\n}\n",[],[153,170],"e509fd92-38af-11f1-998b-42b51c65c3df",["D",1776246353822],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","REST API for recursive task lists with SQLite & OAuth","imageUrl","userId","0cf48beb-ea81-400d-a90f-f5ef34893e37","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","da006c09-d545-448c-bb31-95c5442dc967","tursoName","e509fd9238af11f1998b42b51c65c3df","tursoHostname","e509fd9238af11f1998b42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_233":229},"org",{"_11":12,"_227":-5,"_228":229,"_187":188,"_230":231,"_232":70},"branch",{"_17":62,"_13":16,"_33":36,"_219":177,"_220":-5,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":14,"_226":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2SqUJNgUP6SccC2YmLVUtvg49HJ.jpeg","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":177,"_13":14,"_46":306,"_179":-5,"_180":70,"_181":182,"_183":182,"_184":185,"_186":-5,"_187":188,"_189":61,"_190":64,"_191":-5,"_192":-5,"_193":43,"_194":195,"_196":197,"_198":199,"_200":307,"_202":-5,"_203":204,"_205":204,"_206":207,"_208":207,"_209":207,"_210":204,"_211":204,"_212":308,"_214":309,"_216":310,"_218":70},[264,267,271,273,276,277],"files",[264,265,266,267,268,269,270,271,272,273,274,275,276,277],"counts",{"_255":43,"_256":66,"_257":43,"_32":258,"_259":260},[],{"_33":34,"_35":36,"_37":38,"_13":39,"_40":41,"_42":24,"_17":43,"_44":45,"_46":253,"_48":49,"_50":-5,"_18":254},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1776246712369],[52,39],"pulls","branches","forks",{"_261":66,"_263":43},"connections",{"_261":43,"_262":43},"count","unfilledCount","emptyCount",{"_33":152,"_13":153,"_37":154,"_44":-5,"_35":36,"_48":155,"_63":64,"_46":156,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":304,"_18":305},{"_33":169,"_13":170,"_37":171,"_44":154,"_35":36,"_48":172,"_63":64,"_46":173,"_17":43,"_42":97,"_40":174,"_69":70,"_50":-5,"_71":302,"_18":303},{"_33":161,"_13":162,"_37":163,"_44":154,"_35":36,"_48":164,"_63":64,"_46":165,"_17":43,"_42":97,"_40":166,"_69":70,"_50":-5,"_71":300,"_18":301},{"_33":125,"_13":52,"_37":45,"_44":-5,"_35":36,"_48":126,"_63":64,"_46":127,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":298,"_18":299},{"_33":144,"_13":145,"_37":146,"_44":45,"_35":36,"_48":147,"_63":64,"_46":148,"_17":43,"_42":97,"_40":149,"_69":70,"_50":-5,"_71":296,"_18":297},{"_33":136,"_13":137,"_37":138,"_44":45,"_35":36,"_48":139,"_63":64,"_46":140,"_17":43,"_42":97,"_40":141,"_69":70,"_50":-5,"_71":294,"_18":295},{"_33":34,"_13":39,"_37":38,"_44":45,"_35":36,"_48":49,"_63":64,"_46":133,"_17":43,"_42":24,"_40":41,"_69":70,"_50":-5,"_71":292,"_18":293},{"_33":109,"_13":110,"_37":111,"_44":-5,"_35":36,"_48":112,"_63":64,"_46":113,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":290,"_18":291},{"_33":117,"_13":118,"_37":119,"_44":111,"_35":36,"_48":120,"_63":64,"_46":121,"_17":43,"_42":97,"_40":122,"_69":70,"_50":-5,"_71":288,"_18":289},{"_33":82,"_13":83,"_37":84,"_44":-5,"_35":36,"_48":85,"_63":64,"_46":86,"_17":43,"_42":87,"_40":-5,"_69":70,"_50":-5,"_71":286,"_18":287},{"_33":101,"_13":102,"_37":103,"_44":84,"_35":36,"_48":104,"_63":64,"_46":105,"_17":43,"_42":97,"_40":106,"_69":70,"_50":-5,"_71":284,"_18":285},{"_33":92,"_13":93,"_37":94,"_44":84,"_35":36,"_48":95,"_63":64,"_46":96,"_17":43,"_42":97,"_40":98,"_69":70,"_50":-5,"_71":282,"_18":283},{"_33":74,"_13":75,"_37":76,"_44":-5,"_35":36,"_48":77,"_63":64,"_46":78,"_17":43,"_42":24,"_40":79,"_69":70,"_50":-5,"_71":280,"_18":281},{"_33":59,"_13":60,"_37":61,"_44":-5,"_35":36,"_48":62,"_63":64,"_46":65,"_17":66,"_42":67,"_40":68,"_69":70,"_50":-5,"_71":278,"_18":279},[],[60],[],[75],[],[83,93],[],[83,102],[274,275],[83],[],[110,118],[272],[110],[],[52,39],[],[52,137],[],[52,145],[268,269,270],[52],[],[153,162],[],[153,170],[265,266],[153],["D",1776246353822],["D",1789497078049],{"_11":12,"_233":229},{"_11":12,"_227":-5,"_228":229,"_187":188,"_230":231,"_232":70},{"_17":62,"_13":16,"_33":36,"_219":177,"_220":-5,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":14,"_226":12},"ctx",{"_212":-5,"_250":344,"_345":346,"_347":348,"_349":70,"_350":70,"_351":70,"_352":64,"_353":-5,"_354":-7,"_355":-7,"_356":43,"_357":70,"_358":70,"_359":-5,"_360":70,"_361":70,"_362":70,"_363":-5},"ENV",{"_315":316,"_317":318,"_319":16,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343},"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"]