[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_324":325,"_326":327},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_242":-5,"_20":243,"_22":244,"_245":246,"_247":248,"_26":249,"_24":250,"_251":-5,"_252":-5,"_253":56,"_254":255,"_256":48,"_257":-5,"_258":-5,"_259":260},"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":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","warianoguerra","name","recursive-task-lists","branchName","main","version","path","frontend","project",{"_36":185,"_13":14,"_49":186,"_187":-5,"_188":56,"_189":190,"_191":190,"_192":193,"_194":-5,"_195":196,"_197":87,"_198":48,"_199":-5,"_200":-5,"_201":51,"_202":203,"_204":205,"_206":207,"_208":209,"_210":-5,"_211":212,"_213":212,"_214":215,"_216":215,"_217":215,"_218":212,"_219":212,"_220":221,"_222":223,"_224":225,"_226":56},"tree",[79,80,81,82,83,84],"file",{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":76,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_18":78},"contents",[33,34,35],"upstream","pull","ahead","behind","envVars",{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":71,"_17":51,"_52":64,"_53":72,"_55":56,"_57":-5,"_18":73},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":63,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_18":66},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_18":58},"id","bac0e356-38b0-11f1-ae62-42b51c65c3df","index.html","fileId","bac0e41e-38b0-11f1-ae62-42b51c65c3df","parentId","b23c25e2-38b0-11f1-b859-42b51c65c3df","branchId","e50aa8b4-38af-11f1-998b-42b51c65c3df","branchVersion",14,"latest",true,"createdAt",["D",1776246712369],0,"fileType","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","deleted",false,"label",[19,38],"b9c9be8c-38b0-11f1-9335-42b51c65c3df","app.js","b9c9bf5e-38b0-11f1-9335-42b51c65c3df",13,["D",1776246710728],"script","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",[19,60],"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",[19,68],"b23c2524-38b0-11f1-b859-42b51c65c3df",11,["D",1776246698081],"directory",[19],{"_36":160,"_13":161,"_39":162,"_41":-5,"_43":44,"_45":163,"_47":48,"_49":164,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":165,"_18":166},{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":145,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":146,"_18":147},{"_36":129,"_13":130,"_39":131,"_41":-5,"_43":44,"_45":132,"_47":48,"_49":133,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":134,"_18":135},{"_36":104,"_13":105,"_39":106,"_41":-5,"_43":44,"_45":107,"_47":48,"_49":108,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":109,"_18":110},{"_36":96,"_13":97,"_39":98,"_41":-5,"_43":44,"_45":99,"_47":48,"_49":100,"_17":51,"_52":24,"_53":101,"_55":56,"_57":-5,"_93":102,"_18":103},{"_36":85,"_13":86,"_39":87,"_41":-5,"_43":44,"_45":88,"_47":48,"_49":89,"_17":90,"_52":91,"_53":92,"_55":56,"_57":-5,"_93":94,"_18":95},"c2c33c02-38b0-11f1-ae62-42b51c65c3df","main.ts","e50f35d2-38af-11f1-998b-42b51c65c3df",15,["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","children",[],[86],"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",[],[97],"e7320146-38af-11f1-998b-42b51c65c3df","routes","e7320204-38af-11f1-998b-42b51c65c3df",4,["D",1776246357435],[111,112],[105],{"_36":121,"_13":122,"_39":123,"_41":106,"_43":44,"_45":124,"_47":48,"_49":125,"_17":51,"_52":64,"_53":126,"_55":56,"_57":-5,"_93":127,"_18":128},{"_36":113,"_13":114,"_39":115,"_41":106,"_43":44,"_45":116,"_47":48,"_49":117,"_17":51,"_52":64,"_53":118,"_55":56,"_57":-5,"_93":119,"_18":120},"028d3c1c-38b0-11f1-9211-42b51c65c3df","tasks.ts","028d3cda-38b0-11f1-9211-42b51c65c3df",9,["D",1776246403332],"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",[],[105,114],"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",[],[105,122],"e6ef8fbe-38af-11f1-97a2-42b51c65c3df","middleware","e6ef9086-38af-11f1-97a2-42b51c65c3df",3,["D",1776246357000],[136],[130],{"_36":137,"_13":138,"_39":139,"_41":131,"_43":44,"_45":140,"_47":48,"_49":141,"_17":51,"_52":64,"_53":142,"_55":56,"_57":-5,"_93":143,"_18":144},"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",[],[130,138],["D",1776246698081],[148,149,150],[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":157,"_17":51,"_52":64,"_53":72,"_55":56,"_57":-5,"_93":158,"_18":159},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":154,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_93":155,"_18":156},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":151,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_93":152,"_18":153},["D",1776246712369],[],[19,38],["D",1776246710728],[],[19,60],["D",1776246706468],[],[19,68],"e6a83510-38af-11f1-97a2-42b51c65c3df","database","e6a835e2-38af-11f1-97a2-42b51c65c3df",2,["D",1776246356532],[167,168],[161],{"_36":177,"_13":178,"_39":179,"_41":162,"_43":44,"_45":180,"_47":48,"_49":181,"_17":51,"_52":64,"_53":182,"_55":56,"_57":-5,"_93":183,"_18":184},{"_36":169,"_13":170,"_39":171,"_41":162,"_43":44,"_45":172,"_47":48,"_49":173,"_17":51,"_52":64,"_53":174,"_55":56,"_57":-5,"_93":175,"_18":176},"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",[],[161,170],"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",[],[161,178],"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,"_241":237},"org",{"_11":12,"_235":-5,"_236":237,"_195":196,"_238":239,"_240":56},"branch",{"_17":88,"_13":16,"_36":44,"_227":185,"_228":-5,"_229":-5,"_230":-5,"_231":-5,"_232":-5,"_233":14,"_234":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",{"_36":185,"_13":14,"_49":319,"_187":-5,"_188":56,"_189":190,"_191":190,"_192":193,"_194":-5,"_195":196,"_197":87,"_198":48,"_199":-5,"_200":-5,"_201":51,"_202":203,"_204":205,"_206":207,"_208":320,"_210":-5,"_211":212,"_213":212,"_214":215,"_216":215,"_217":215,"_218":212,"_219":212,"_220":321,"_222":322,"_224":323,"_226":56},[277,280,284,286,289,290],"files",[277,278,279,280,281,282,283,284,285,286,287,288,289,290],"counts",{"_268":51,"_269":90,"_270":51,"_32":271,"_272":273},[262,263,264],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":76,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_18":261},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":71,"_17":51,"_52":64,"_53":72,"_55":56,"_57":-5,"_18":267},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":63,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_18":266},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_18":265},[19,38],[19,60],[19,68],"pulls","branches","forks",{"_274":90,"_276":51},"connections",{"_274":51,"_275":51},"count","unfilledCount","emptyCount",{"_36":160,"_13":161,"_39":162,"_41":-5,"_43":44,"_45":163,"_47":48,"_49":164,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":317,"_18":318},{"_36":177,"_13":178,"_39":179,"_41":162,"_43":44,"_45":180,"_47":48,"_49":181,"_17":51,"_52":64,"_53":182,"_55":56,"_57":-5,"_93":315,"_18":316},{"_36":169,"_13":170,"_39":171,"_41":162,"_43":44,"_45":172,"_47":48,"_49":173,"_17":51,"_52":64,"_53":174,"_55":56,"_57":-5,"_93":313,"_18":314},{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":145,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":311,"_18":312},{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":157,"_17":51,"_52":64,"_53":72,"_55":56,"_57":-5,"_93":309,"_18":310},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":154,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_93":307,"_18":308},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":151,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_93":305,"_18":306},{"_36":129,"_13":130,"_39":131,"_41":-5,"_43":44,"_45":132,"_47":48,"_49":133,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":303,"_18":304},{"_36":137,"_13":138,"_39":139,"_41":131,"_43":44,"_45":140,"_47":48,"_49":141,"_17":51,"_52":64,"_53":142,"_55":56,"_57":-5,"_93":301,"_18":302},{"_36":104,"_13":105,"_39":106,"_41":-5,"_43":44,"_45":107,"_47":48,"_49":108,"_17":51,"_52":77,"_53":-5,"_55":56,"_57":-5,"_93":299,"_18":300},{"_36":121,"_13":122,"_39":123,"_41":106,"_43":44,"_45":124,"_47":48,"_49":125,"_17":51,"_52":64,"_53":126,"_55":56,"_57":-5,"_93":297,"_18":298},{"_36":113,"_13":114,"_39":115,"_41":106,"_43":44,"_45":116,"_47":48,"_49":117,"_17":51,"_52":64,"_53":118,"_55":56,"_57":-5,"_93":295,"_18":296},{"_36":96,"_13":97,"_39":98,"_41":-5,"_43":44,"_45":99,"_47":48,"_49":100,"_17":51,"_52":24,"_53":101,"_55":56,"_57":-5,"_93":293,"_18":294},{"_36":85,"_13":86,"_39":87,"_41":-5,"_43":44,"_45":88,"_47":48,"_49":89,"_17":90,"_52":91,"_53":92,"_55":56,"_57":-5,"_93":291,"_18":292},[],[86],[],[97],[],[105,114],[],[105,122],[287,288],[105],[],[130,138],[285],[130],[],[19,38],[],[19,60],[],[19,68],[281,282,283],[19],[],[161,170],[],[161,178],[278,279],[161],["D",1776246353822],["D",1789497078049],{"_11":12,"_241":237},{"_11":12,"_235":-5,"_236":237,"_195":196,"_238":239,"_240":56},{"_17":88,"_13":16,"_36":44,"_227":185,"_228":-5,"_229":-5,"_230":-5,"_231":-5,"_232":-5,"_233":14,"_234":12},"ctx",{"_220":-5,"_258":357,"_358":359,"_360":361,"_362":56,"_363":56,"_364":56,"_365":48,"_366":-5,"_367":-7,"_368":-7,"_369":51,"_370":56,"_371":56,"_372":-5,"_373":56,"_374":56,"_375":56,"_376":-5},"ENV",{"_328":329,"_330":331,"_332":16,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356},"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"]