[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_314":315,"_316":317},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_236":-5,"_20":237,"_22":238,"_239":240,"_241":242,"_26":243,"_24":244,"_245":-5,"_246":-5,"_247":55,"_248":249,"_250":46,"_251":-5,"_252":-5,"_253":254},"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","middleware","project",{"_34":179,"_13":14,"_47":180,"_181":-5,"_182":55,"_183":184,"_185":184,"_186":187,"_188":-5,"_189":190,"_191":71,"_192":46,"_193":-5,"_194":-5,"_195":49,"_196":197,"_198":199,"_200":201,"_202":203,"_204":-5,"_205":206,"_207":206,"_208":209,"_210":209,"_211":209,"_212":206,"_213":206,"_214":215,"_216":217,"_218":219,"_220":55},"tree",[63,64,65,66,67,68],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_18":62},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","f8dd2c18-38af-11f1-998b-42b51c65c3df","auth.ts","fileId","f8dd2cd6-38af-11f1-998b-42b51c65c3df","parentId","e6ef9086-38af-11f1-97a2-42b51c65c3df","branchId","e50aa8b4-38af-11f1-998b-42b51c65c3df","branchVersion",7,"latest",true,"createdAt",["D",1776246387032],0,"fileType","script","content","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","deleted",false,"label",[19,36],"e6ef8fbe-38af-11f1-97a2-42b51c65c3df",3,["D",1776246357000],"directory",[19],{"_34":154,"_13":155,"_37":156,"_39":-5,"_41":42,"_43":157,"_45":46,"_47":158,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":159,"_18":160},{"_34":120,"_13":121,"_37":122,"_39":-5,"_41":42,"_43":123,"_45":46,"_47":124,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":125,"_18":126},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":113,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":114,"_18":115},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":91,"_45":46,"_47":92,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":93,"_18":94},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":49,"_50":24,"_52":85,"_54":55,"_56":-5,"_77":86,"_18":87},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":74,"_50":75,"_52":76,"_54":55,"_56":-5,"_77":78,"_18":79},"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",[],[70],"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",[],[81],"e7320146-38af-11f1-998b-42b51c65c3df","routes","e7320204-38af-11f1-998b-42b51c65c3df",4,["D",1776246357435],[95,96],[89],{"_34":105,"_13":106,"_37":107,"_39":90,"_41":42,"_43":108,"_45":46,"_47":109,"_17":49,"_50":51,"_52":110,"_54":55,"_56":-5,"_77":111,"_18":112},{"_34":97,"_13":98,"_37":99,"_39":90,"_41":42,"_43":100,"_45":46,"_47":101,"_17":49,"_50":51,"_52":102,"_54":55,"_56":-5,"_77":103,"_18":104},"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",[],[89,98],"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",[],[89,106],["D",1776246357000],[116],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":117,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":118,"_18":119},["D",1776246387032],[],[19,36],"b23c2524-38b0-11f1-b859-42b51c65c3df","frontend","b23c25e2-38b0-11f1-b859-42b51c65c3df",11,["D",1776246698081],[127,128,129],[121],{"_34":146,"_13":147,"_37":148,"_39":122,"_41":42,"_43":149,"_45":46,"_47":150,"_17":49,"_50":51,"_52":151,"_54":55,"_56":-5,"_77":152,"_18":153},{"_34":138,"_13":139,"_37":140,"_39":122,"_41":42,"_43":141,"_45":46,"_47":142,"_17":49,"_50":51,"_52":143,"_54":55,"_56":-5,"_77":144,"_18":145},{"_34":130,"_13":131,"_37":132,"_39":122,"_41":42,"_43":133,"_45":46,"_47":134,"_17":49,"_50":24,"_52":135,"_54":55,"_56":-5,"_77":136,"_18":137},"bac0e356-38b0-11f1-ae62-42b51c65c3df","index.html","bac0e41e-38b0-11f1-ae62-42b51c65c3df",14,["D",1776246712369],"\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",[],[121,131],"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",[],[121,139],"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",[],[121,147],"e6a83510-38af-11f1-97a2-42b51c65c3df","database","e6a835e2-38af-11f1-97a2-42b51c65c3df",2,["D",1776246356532],[161,162],[155],{"_34":171,"_13":172,"_37":173,"_39":156,"_41":42,"_43":174,"_45":46,"_47":175,"_17":49,"_50":51,"_52":176,"_54":55,"_56":-5,"_77":177,"_18":178},{"_34":163,"_13":164,"_37":165,"_39":156,"_41":42,"_43":166,"_45":46,"_47":167,"_17":49,"_50":51,"_52":168,"_54":55,"_56":-5,"_77":169,"_18":170},"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",[],[155,164],"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",[],[155,172],"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,"_235":231},"org",{"_11":12,"_229":-5,"_230":231,"_189":190,"_232":233,"_234":55},"branch",{"_17":72,"_13":16,"_34":42,"_221":179,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":-5,"_227":14,"_228":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",{"_34":179,"_13":14,"_47":309,"_181":-5,"_182":55,"_183":184,"_185":184,"_186":187,"_188":-5,"_189":190,"_191":71,"_192":46,"_193":-5,"_194":-5,"_195":49,"_196":197,"_198":199,"_200":201,"_202":310,"_204":-5,"_205":206,"_207":206,"_208":209,"_210":209,"_211":209,"_212":206,"_213":206,"_214":311,"_216":312,"_218":313,"_220":55},[267,270,274,276,279,280],"files",[267,268,269,270,271,272,273,274,275,276,277,278,279,280],"counts",{"_258":49,"_259":74,"_260":49,"_32":261,"_262":263},[256],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_18":255},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":257},[19,36],"pulls","branches","forks",{"_264":74,"_266":49},"connections",{"_264":49,"_265":49},"count","unfilledCount","emptyCount",{"_34":154,"_13":155,"_37":156,"_39":-5,"_41":42,"_43":157,"_45":46,"_47":158,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":307,"_18":308},{"_34":171,"_13":172,"_37":173,"_39":156,"_41":42,"_43":174,"_45":46,"_47":175,"_17":49,"_50":51,"_52":176,"_54":55,"_56":-5,"_77":305,"_18":306},{"_34":163,"_13":164,"_37":165,"_39":156,"_41":42,"_43":166,"_45":46,"_47":167,"_17":49,"_50":51,"_52":168,"_54":55,"_56":-5,"_77":303,"_18":304},{"_34":120,"_13":121,"_37":122,"_39":-5,"_41":42,"_43":123,"_45":46,"_47":124,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":301,"_18":302},{"_34":146,"_13":147,"_37":148,"_39":122,"_41":42,"_43":149,"_45":46,"_47":150,"_17":49,"_50":51,"_52":151,"_54":55,"_56":-5,"_77":299,"_18":300},{"_34":138,"_13":139,"_37":140,"_39":122,"_41":42,"_43":141,"_45":46,"_47":142,"_17":49,"_50":51,"_52":143,"_54":55,"_56":-5,"_77":297,"_18":298},{"_34":130,"_13":131,"_37":132,"_39":122,"_41":42,"_43":133,"_45":46,"_47":134,"_17":49,"_50":24,"_52":135,"_54":55,"_56":-5,"_77":295,"_18":296},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":113,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":293,"_18":294},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":117,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":291,"_18":292},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":91,"_45":46,"_47":92,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_77":289,"_18":290},{"_34":105,"_13":106,"_37":107,"_39":90,"_41":42,"_43":108,"_45":46,"_47":109,"_17":49,"_50":51,"_52":110,"_54":55,"_56":-5,"_77":287,"_18":288},{"_34":97,"_13":98,"_37":99,"_39":90,"_41":42,"_43":100,"_45":46,"_47":101,"_17":49,"_50":51,"_52":102,"_54":55,"_56":-5,"_77":285,"_18":286},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":49,"_50":24,"_52":85,"_54":55,"_56":-5,"_77":283,"_18":284},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":74,"_50":75,"_52":76,"_54":55,"_56":-5,"_77":281,"_18":282},[],[70],[],[81],[],[89,98],[],[89,106],[277,278],[89],[],[19,36],[275],[19],[],[121,131],[],[121,139],[],[121,147],[271,272,273],[121],[],[155,164],[],[155,172],[268,269],[155],["D",1776246353822],["D",1789497078049],{"_11":12,"_235":231},{"_11":12,"_229":-5,"_230":231,"_189":190,"_232":233,"_234":55},{"_17":72,"_13":16,"_34":42,"_221":179,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":-5,"_227":14,"_228":12},"ctx",{"_214":-5,"_252":347,"_348":349,"_350":351,"_352":55,"_353":55,"_354":55,"_355":46,"_356":-5,"_357":-7,"_358":-7,"_359":49,"_360":55,"_361":55,"_362":-5,"_363":55,"_364":55,"_365":55,"_366":-5},"ENV",{"_318":319,"_320":321,"_322":16,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346},"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"]