Recursive Task Lists

Open the browser console to see API results.

\n \n\n\n",[],[159,232],"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",[],[159,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",[],[159,248],["D",1776246698081],[183,184,185],[159],"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",[],[165,259],"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",[],[165,267],["D",1776246356532],[180,181],[165],["D",1776246353822],["D",1789497078049],{"_11":12,"_91":87},{"_11":12,"_85":-5,"_86":87,"_45":46,"_88":89,"_90":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_80":-5,"_81":-5,"_82":-5,"_83":14,"_84":12},"ctx",{"_73":-5,"_113":315,"_316":317,"_318":319,"_320":38,"_321":38,"_322":38,"_323":50,"_324":-5,"_325":-7,"_326":-7,"_327":54,"_328":38,"_329":38,"_330":-5,"_331":38,"_332":38,"_333":38,"_334":-5},"ENV",{"_286":287,"_288":289,"_290":26,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314},"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"]

Branches1

Branches
1