Recursive Task Lists

Open the browser console to see API results.

\n \n\n\n",[],[124,134],"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",[],[124,142],"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",[],[124,150],"e6a83510-38af-11f1-97a2-42b51c65c3df","database","e6a835e2-38af-11f1-97a2-42b51c65c3df",2,["D",1776246356532],[164,165],[158],{"_35":174,"_13":175,"_38":176,"_40":159,"_42":43,"_44":177,"_46":47,"_48":178,"_17":50,"_51":52,"_53":179,"_55":56,"_57":-5,"_85":180,"_18":181},{"_35":166,"_13":167,"_38":168,"_40":159,"_42":43,"_44":169,"_46":47,"_48":170,"_17":50,"_51":52,"_53":171,"_55":56,"_57":-5,"_85":172,"_18":173},"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",[],[158,167],"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",[],[158,175],"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,"_238":234},"org",{"_11":12,"_232":-5,"_233":234,"_192":193,"_235":236,"_237":56},"branch",{"_17":80,"_13":16,"_35":43,"_224":182,"_225":-5,"_226":-5,"_227":-5,"_228":-5,"_229":-5,"_230":14,"_231":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",{"_35":182,"_13":14,"_48":314,"_184":-5,"_185":56,"_186":187,"_188":187,"_189":190,"_191":-5,"_192":193,"_194":79,"_195":47,"_196":-5,"_197":-5,"_198":50,"_199":200,"_201":202,"_203":204,"_205":315,"_207":-5,"_208":209,"_210":209,"_211":212,"_213":212,"_214":212,"_215":209,"_216":209,"_217":316,"_219":317,"_221":318,"_223":56},[272,275,279,281,284,285],"files",[272,273,274,275,276,277,278,279,280,281,282,283,284,285],"counts",{"_263":50,"_264":82,"_265":50,"_32":266,"_267":268},[259,260],{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":67,"_46":47,"_48":68,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":258},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":52,"_53":64,"_55":56,"_57":-5,"_18":262},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":261},[19,37],[19,60],"pulls","branches","forks",{"_269":82,"_271":50},"connections",{"_269":50,"_270":50},"count","unfilledCount","emptyCount",{"_35":157,"_13":158,"_38":159,"_40":-5,"_42":43,"_44":160,"_46":47,"_48":161,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_85":312,"_18":313},{"_35":174,"_13":175,"_38":176,"_40":159,"_42":43,"_44":177,"_46":47,"_48":178,"_17":50,"_51":52,"_53":179,"_55":56,"_57":-5,"_85":310,"_18":311},{"_35":166,"_13":167,"_38":168,"_40":159,"_42":43,"_44":169,"_46":47,"_48":170,"_17":50,"_51":52,"_53":171,"_55":56,"_57":-5,"_85":308,"_18":309},{"_35":123,"_13":124,"_38":125,"_40":-5,"_42":43,"_44":126,"_46":47,"_48":127,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_85":306,"_18":307},{"_35":149,"_13":150,"_38":151,"_40":125,"_42":43,"_44":152,"_46":47,"_48":153,"_17":50,"_51":52,"_53":154,"_55":56,"_57":-5,"_85":304,"_18":305},{"_35":141,"_13":142,"_38":143,"_40":125,"_42":43,"_44":144,"_46":47,"_48":145,"_17":50,"_51":52,"_53":146,"_55":56,"_57":-5,"_85":302,"_18":303},{"_35":133,"_13":134,"_38":135,"_40":125,"_42":43,"_44":136,"_46":47,"_48":137,"_17":50,"_51":24,"_53":138,"_55":56,"_57":-5,"_85":300,"_18":301},{"_35":107,"_13":108,"_38":109,"_40":-5,"_42":43,"_44":110,"_46":47,"_48":111,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_85":298,"_18":299},{"_35":115,"_13":116,"_38":117,"_40":109,"_42":43,"_44":118,"_46":47,"_48":119,"_17":50,"_51":52,"_53":120,"_55":56,"_57":-5,"_85":296,"_18":297},{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":67,"_46":47,"_48":96,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_85":294,"_18":295},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":104,"_17":50,"_51":52,"_53":64,"_55":56,"_57":-5,"_85":292,"_18":293},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":101,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_85":290,"_18":291},{"_35":88,"_13":89,"_38":90,"_40":-5,"_42":43,"_44":91,"_46":47,"_48":92,"_17":50,"_51":24,"_53":93,"_55":56,"_57":-5,"_85":288,"_18":289},{"_35":77,"_13":78,"_38":79,"_40":-5,"_42":43,"_44":80,"_46":47,"_48":81,"_17":82,"_51":83,"_53":84,"_55":56,"_57":-5,"_85":286,"_18":287},[],[78],[],[89],[],[19,37],[],[19,60],[282,283],[19],[],[108,116],[280],[108],[],[124,134],[],[124,142],[],[124,150],[276,277,278],[124],[],[158,167],[],[158,175],[273,274],[158],["D",1776246353822],["D",1789497078049],{"_11":12,"_238":234},{"_11":12,"_232":-5,"_233":234,"_192":193,"_235":236,"_237":56},{"_17":80,"_13":16,"_35":43,"_224":182,"_225":-5,"_226":-5,"_227":-5,"_228":-5,"_229":-5,"_230":14,"_231":12},"ctx",{"_217":-5,"_255":352,"_353":354,"_355":356,"_357":56,"_358":56,"_359":56,"_360":47,"_361":-5,"_362":-7,"_363":-7,"_364":50,"_365":56,"_366":56,"_367":-5,"_368":56,"_369":56,"_370":56,"_371":-5},"ENV",{"_323":324,"_325":326,"_327":16,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351},"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"]