Recursive Task Lists

Open the browser console to see API results.

\n \n\n\n",[18,91],"b9c9be8c-38b0-11f1-9335-42b51c65c3df",["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",[18,82],"b73bcc96-38b0-11f1-87f1-42b51c65c3df",["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",[18,67],"pulls","branches",1,"forks","envVars",{"_199":193,"_201":26},"connections",{"_199":26,"_200":26},"count","unfilledCount","emptyCount",{"_35":300,"_13":291,"_65":285,"_45":-5,"_37":38,"_171":301,"_179":24,"_39":302,"_41":26,"_68":93,"_169":-5,"_70":30,"_173":-5,"_221":303,"_17":304},{"_35":292,"_13":293,"_65":294,"_45":285,"_37":38,"_171":295,"_179":24,"_39":296,"_41":26,"_68":69,"_169":297,"_70":30,"_173":-5,"_221":298,"_17":299},{"_35":282,"_13":283,"_65":284,"_45":285,"_37":38,"_171":286,"_179":24,"_39":287,"_41":26,"_68":69,"_169":288,"_70":30,"_173":-5,"_221":289,"_17":290},{"_35":168,"_13":18,"_65":92,"_45":-5,"_37":38,"_171":172,"_179":24,"_39":279,"_41":26,"_68":93,"_169":-5,"_70":30,"_173":-5,"_221":280,"_17":281},{"_35":187,"_13":67,"_65":66,"_45":92,"_37":38,"_171":42,"_179":24,"_39":276,"_41":26,"_68":69,"_169":189,"_70":30,"_173":-5,"_221":277,"_17":278},{"_35":183,"_13":82,"_65":81,"_45":92,"_37":38,"_171":76,"_179":24,"_39":273,"_41":26,"_68":69,"_169":185,"_70":30,"_173":-5,"_221":274,"_17":275},{"_35":178,"_13":91,"_65":90,"_45":92,"_37":38,"_171":85,"_179":24,"_39":270,"_41":26,"_68":21,"_169":181,"_70":30,"_173":-5,"_221":271,"_17":272},{"_35":265,"_13":264,"_65":258,"_45":-5,"_37":38,"_171":266,"_179":24,"_39":267,"_41":26,"_68":93,"_169":-5,"_70":30,"_173":-5,"_221":268,"_17":269},{"_35":255,"_13":256,"_65":257,"_45":258,"_37":38,"_171":259,"_179":24,"_39":260,"_41":26,"_68":69,"_169":261,"_70":30,"_173":-5,"_221":262,"_17":263},{"_35":250,"_13":241,"_65":235,"_45":-5,"_37":38,"_171":251,"_179":24,"_39":252,"_41":26,"_68":93,"_169":-5,"_70":30,"_173":-5,"_221":253,"_17":254},{"_35":242,"_13":243,"_65":244,"_45":235,"_37":38,"_171":245,"_179":24,"_39":246,"_41":26,"_68":69,"_169":247,"_70":30,"_173":-5,"_221":248,"_17":249},{"_35":232,"_13":233,"_65":234,"_45":235,"_37":38,"_171":236,"_179":24,"_39":237,"_41":26,"_68":69,"_169":238,"_70":30,"_173":-5,"_221":239,"_17":240},{"_35":224,"_13":225,"_65":226,"_45":-5,"_37":38,"_171":227,"_179":24,"_39":228,"_41":26,"_68":21,"_169":229,"_70":30,"_173":-5,"_221":230,"_17":231},{"_35":216,"_13":217,"_65":106,"_45":-5,"_37":38,"_171":133,"_179":24,"_39":218,"_41":193,"_68":219,"_169":220,"_70":30,"_173":-5,"_221":222,"_17":223},"c2c33c02-38b0-11f1-ae62-42b51c65c3df","main.ts",["D",1776246725803],"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",[],[217],"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",[],[225],"028d3c1c-38b0-11f1-9211-42b51c65c3df","tasks.ts","028d3cda-38b0-11f1-9211-42b51c65c3df","e7320204-38af-11f1-998b-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",[],[241,233],"routes","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",[],[241,243],"e7320146-38af-11f1-998b-42b51c65c3df",4,["D",1776246357435],[212,213],[241],"f8dd2c18-38af-11f1-998b-42b51c65c3df","auth.ts","f8dd2cd6-38af-11f1-998b-42b51c65c3df","e6ef9086-38af-11f1-97a2-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",[],[264,256],"middleware","e6ef8fbe-38af-11f1-97a2-42b51c65c3df",3,["D",1776246357000],[210],[264],["D",1776246712369],[],[18,91],["D",1776246710728],[],[18,82],["D",1776246706468],[],[18,67],["D",1776246698081],[206,207,208],[18],"f4462f10-38af-11f1-895a-42b51c65c3df","queries.ts","f4462ff6-38af-11f1-895a-42b51c65c3df","e6a835e2-38af-11f1-97a2-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",[],[291,283],"database","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",[],[291,293],"e6a83510-38af-11f1-97a2-42b51c65c3df",2,["D",1776246356532],[203,204],[291],["D",1776246353822],["D",1789497078049],{"_11":12,"_146":73},{"_11":12,"_142":-5,"_72":73,"_31":71,"_143":144,"_145":30},{"_41":133,"_13":16,"_35":38,"_134":95,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":14,"_141":12},"ctx",{"_55":-5,"_165":343,"_344":345,"_346":347,"_348":30,"_349":30,"_350":30,"_351":24,"_352":-5,"_353":-7,"_354":-7,"_355":26,"_356":30,"_357":30,"_358":-5,"_359":30,"_360":30,"_361":30,"_362":-5},"ENV",{"_314":315,"_316":317,"_318":16,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342},"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"]

History · frontend