[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_288":289,"_290":291},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_38":-7,"_124":-5,"_19":125,"_126":127,"_128":129,"_130":131,"_132":133,"_21":134,"_135":-5,"_136":-5,"_137":24,"_138":139,"_140":84,"_141":-5,"_142":-5,"_143":144},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","warianoguerra","name","recursive-task-lists","branchName","main","path","frontend/index.html","project",{"_32":71,"_13":14,"_36":72,"_73":-5,"_74":24,"_75":76,"_77":76,"_78":79,"_80":-5,"_30":67,"_81":82,"_83":84,"_85":-5,"_86":-5,"_87":26,"_40":41,"_88":89,"_90":91,"_92":93,"_94":-5,"_95":96,"_97":96,"_98":99,"_100":99,"_101":99,"_102":96,"_103":96,"_52":104,"_105":106,"_107":108,"_109":24},"file",{"_62":63,"_13":64,"_65":21,"_66":24,"_70":-5},"isDirectory",false,"page",0,"history",[31],"hasNext","userId",{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_21":54,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60},"id","baca56b6-38b0-11f1-ae62-42b51c65c3df","branchId","e50aa8b4-38af-11f1-998b-42b51c65c3df","createdAt",["D",1776246712369],"version",14,"orgId","da006c09-d545-448c-bb31-95c5442dc967","parentId","b9ced052-38b0-11f1-9335-42b51c65c3df","incomingCommitId","aiChatMessageId","d7def2a6-c3b0-403a-bcfa-8b256e49fe4e","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_32":67,"_40":41,"_11":12,"_68":69},{"_62":63,"_13":64,"_65":21,"_66":24},"pull","merge","revert","multiple","commits",[61],{"_32":33,"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_21":54,"_55":-5,"_56":-5,"_57":-5},"fileId","bac0e41e-38b0-11f1-ae62-42b51c65c3df","index.html","fileType","deleted","0cf48beb-ea81-400d-a90f-f5ef34893e37","avatar","https://images.clerk.dev/oauth_github/img_2SqUJNgUP6SccC2YmLVUtvg49HJ.jpeg","deletedAtVersion","e509fd92-38af-11f1-998b-42b51c65c3df",["D",1776246353822],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","REST API for recursive task lists with SQLite & OAuth","imageUrl","pinnedFileId","e50f35d2-38af-11f1-998b-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_123":69},"org",{"_11":12,"_119":-5,"_68":69,"_30":67,"_120":121,"_122":24},"branch",{"_38":110,"_13":16,"_32":35,"_111":71,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":14,"_118":12},"isOwned",15,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_32":71,"_13":14,"_36":283,"_73":-5,"_74":24,"_75":76,"_77":76,"_78":79,"_80":-5,"_30":67,"_81":82,"_83":84,"_85":-5,"_86":-5,"_87":26,"_40":41,"_88":89,"_90":91,"_92":284,"_94":-5,"_95":96,"_97":96,"_98":99,"_100":99,"_101":99,"_102":96,"_103":96,"_52":285,"_105":286,"_107":287,"_109":24},"tree",[165,168,172,174,177,178],"files",[165,166,167,168,169,170,171,172,173,174,175,176,177,178],"counts",{"_154":26,"_155":156,"_157":26,"_158":159,"_160":161},"contents",[],{"_32":145,"_34":35,"_62":63,"_13":64,"_146":147,"_65":21,"_38":26,"_42":148,"_36":149,"_150":39,"_151":-5,"_17":152},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"bac0e356-38b0-11f1-ae62-42b51c65c3df","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","b23c25e2-38b0-11f1-b859-42b51c65c3df",["D",1776246712369],"branchVersion","label",[153,64],"frontend","pulls","branches",1,"forks","envVars",{"_162":156,"_164":26},"connections",{"_162":26,"_163":26},"count","unfilledCount","emptyCount",{"_32":278,"_13":269,"_62":263,"_42":-5,"_34":35,"_150":279,"_181":84,"_36":280,"_38":26,"_65":218,"_146":-5,"_66":24,"_151":-5,"_185":281,"_17":282},{"_32":270,"_13":271,"_62":272,"_42":263,"_34":35,"_150":273,"_181":84,"_36":274,"_38":26,"_65":202,"_146":275,"_66":24,"_151":-5,"_185":276,"_17":277},{"_32":260,"_13":261,"_62":262,"_42":263,"_34":35,"_150":264,"_181":84,"_36":265,"_38":26,"_65":202,"_146":266,"_66":24,"_151":-5,"_185":267,"_17":268},{"_32":255,"_13":153,"_62":148,"_42":-5,"_34":35,"_150":256,"_181":84,"_36":257,"_38":26,"_65":218,"_146":-5,"_66":24,"_151":-5,"_185":258,"_17":259},{"_32":247,"_13":248,"_62":249,"_42":148,"_34":35,"_150":250,"_181":84,"_36":251,"_38":26,"_65":202,"_146":252,"_66":24,"_151":-5,"_185":253,"_17":254},{"_32":239,"_13":240,"_62":241,"_42":148,"_34":35,"_150":242,"_181":84,"_36":243,"_38":26,"_65":202,"_146":244,"_66":24,"_151":-5,"_185":245,"_17":246},{"_32":145,"_13":64,"_62":63,"_42":148,"_34":35,"_150":39,"_181":84,"_36":236,"_38":26,"_65":21,"_146":147,"_66":24,"_151":-5,"_185":237,"_17":238},{"_32":231,"_13":230,"_62":224,"_42":-5,"_34":35,"_150":232,"_181":84,"_36":233,"_38":26,"_65":218,"_146":-5,"_66":24,"_151":-5,"_185":234,"_17":235},{"_32":221,"_13":222,"_62":223,"_42":224,"_34":35,"_150":225,"_181":84,"_36":226,"_38":26,"_65":202,"_146":227,"_66":24,"_151":-5,"_185":228,"_17":229},{"_32":215,"_13":206,"_62":199,"_42":-5,"_34":35,"_150":216,"_181":84,"_36":217,"_38":26,"_65":218,"_146":-5,"_66":24,"_151":-5,"_185":219,"_17":220},{"_32":207,"_13":208,"_62":209,"_42":199,"_34":35,"_150":210,"_181":84,"_36":211,"_38":26,"_65":202,"_146":212,"_66":24,"_151":-5,"_185":213,"_17":214},{"_32":196,"_13":197,"_62":198,"_42":199,"_34":35,"_150":200,"_181":84,"_36":201,"_38":26,"_65":202,"_146":203,"_66":24,"_151":-5,"_185":204,"_17":205},{"_32":188,"_13":189,"_62":190,"_42":-5,"_34":35,"_150":191,"_181":84,"_36":192,"_38":26,"_65":21,"_146":193,"_66":24,"_151":-5,"_185":194,"_17":195},{"_32":179,"_13":180,"_62":82,"_42":-5,"_34":35,"_150":110,"_181":84,"_36":182,"_38":156,"_65":183,"_146":184,"_66":24,"_151":-5,"_185":186,"_17":187},"c2c33c02-38b0-11f1-ae62-42b51c65c3df","main.ts","latest",["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",[],[180],"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",[],[189],"028d3c1c-38b0-11f1-9211-42b51c65c3df","tasks.ts","028d3cda-38b0-11f1-9211-42b51c65c3df","e7320204-38af-11f1-998b-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",[],[206,197],"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",[],[206,208],"e7320146-38af-11f1-998b-42b51c65c3df",4,["D",1776246357435],"directory",[175,176],[206],"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",[],[230,222],"middleware","e6ef8fbe-38af-11f1-97a2-42b51c65c3df",3,["D",1776246357000],[173],[230],["D",1776246712369],[],[153,64],"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",[],[153,240],"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",[],[153,248],"b23c2524-38b0-11f1-b859-42b51c65c3df",11,["D",1776246698081],[169,170,171],[153],"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",[],[269,261],"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",[],[269,271],"e6a83510-38af-11f1-97a2-42b51c65c3df",2,["D",1776246356532],[166,167],[269],["D",1776246353822],["D",1789497078049],{"_11":12,"_123":69},{"_11":12,"_119":-5,"_68":69,"_30":67,"_120":121,"_122":24},{"_38":110,"_13":16,"_32":35,"_111":71,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":14,"_118":12},"ctx",{"_52":-5,"_142":321,"_322":323,"_324":325,"_326":24,"_327":24,"_328":24,"_329":84,"_330":-5,"_331":-7,"_332":-7,"_333":26,"_334":24,"_335":24,"_336":-5,"_337":24,"_338":24,"_339":24,"_340":-5},"ENV",{"_292":293,"_294":295,"_296":16,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320},"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 · index.html