[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","dhvanil","name","untitled-139","branchName","main","version","path","","project",{"_33":62,"_13":14,"_45":63,"_64":-5,"_65":53,"_66":67,"_68":67,"_69":-5,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":44,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[57],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_18":56},"id","9adf7ff8-7f64-11f0-b8a1-0224a6c84d84","main.tsx","fileId","97c662fa-7f64-11f0-95aa-0224a6c84d84","parentId","branchId","97c3f592-7f64-11f0-95aa-0224a6c84d84","branchVersion",3,"latest",true,"createdAt",["D",1755873052016],2,"fileType","http","content","// @title todo-api\n// @description POST-based TODO API for AI agents (text-only). SQLite-backed. GET or POST /help.\n// Set this file's trigger to HTTP in Val Town.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { customAlphabet } from \"npm:nanoid\";\n\n// ---------- ID generation ----------\nconst nano6 = customAlphabet(\n \"23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz\",\n 6,\n);\nconst genId = (prefix: \"list\" | \"item\") => `${prefix}-${nano6()}`;\n\n// ---------- bootstrap schema ----------\nasync function ensureSchema() {\n await sqlite.batch([\n `PRAGMA foreign_keys = ON;`,\n `CREATE TABLE IF NOT EXISTS lists(\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL DEFAULT 'todo list',\n archived INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))\n );`,\n `CREATE TABLE IF NOT EXISTS items(\n id TEXT PRIMARY KEY,\n list_id TEXT NOT NULL REFERENCES lists(id) ON DELETE CASCADE,\n title TEXT NOT NULL,\n completed INTEGER NOT NULL DEFAULT 0,\n sort INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),\n completed_at TEXT\n );`,\n `CREATE INDEX IF NOT EXISTS idx_items_list ON items(list_id);`,\n `CREATE INDEX IF NOT EXISTS idx_items_list_completed ON items(list_id, completed);`,\n `CREATE INDEX IF NOT EXISTS idx_items_sort ON items(list_id, sort);`,\n ]);\n}\n\n// ---------- util ----------\nfunction textResponse(text: string, status = 200) {\n if (!text.endsWith(\"\\n\")) text += \"\\n\";\n return new Response(text, {\n status,\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n}\nfunction badRequest(msg: string) {\n return textResponse(`Bad Request: ${msg}`, 400);\n}\nfunction notFound(msg: string) {\n return textResponse(`Not Found: ${msg}`, 404);\n}\n\ntype ExecResult = {\n columns: string[];\n columnTypes: string[];\n rows: any[][];\n rowsAffected: number;\n lastInsertRowid: string | number | null;\n};\nfunction rowsToObjects(res: ExecResult): Record[] {\n return res.rows.map((row) =>\n Object.fromEntries(row.map((v, i) => [res.columns[i], v]))\n );\n}\nasync function q1(sql: string, args?: any): Promise {\n const res = (await sqlite.execute({ sql, args })) as ExecResult;\n if (!res.rows.length) return null;\n return rowsToObjects(res)[0] as T;\n}\nasync function qAll(sql: string, args?: any): Promise {\n const res = (await sqlite.execute({ sql, args })) as ExecResult;\n return rowsToObjects(res) as T[];\n}\n\nasync function nextSort(list_id: string): Promise {\n const row = await q1<{ next: number }>(\n `SELECT COALESCE(MAX(sort), 0) + 1 AS next FROM items WHERE list_id = :list_id`,\n { list_id },\n );\n return row?.next ?? 1;\n}\n\n// Accepts real newlines, \"\\n\" literal, or \"/n\" literal\nfunction parseNewlineList(input: unknown): string[] {\n if (typeof input !== \"string\") return [];\n let s = input.replace(/\\r/g, \"\");\n s = s.replace(/\\\\n/g, \"\\n\"); // literal \\n -> newline\n s = s.replace(/\\/n/g, \"\\n\"); // literal /n -> newline (lenient)\n return s\n .split(\"\\n\")\n .map((x) => x.trim())\n .filter(Boolean);\n}\n\nfunction renderListText(list: { id: string; title: string }, items: any[]) {\n const lines: string[] = [];\n const headerTitle = list.title || \"todo list\";\n lines.push(`${headerTitle} (${list.id})`);\n for (const it of items) {\n const box = it.completed ? \"☑\" : \"☐\";\n lines.push(` ${box} ${it.title} (${it.id})`);\n }\n return lines.join(\"\\n\");\n}\n\nasync function renderList(list_id: string) {\n const list = await q1<{ id: string; title: string }>(\n `SELECT id, title FROM lists WHERE id = :id`,\n { id: list_id },\n );\n if (!list) return null;\n const items = await qAll<{\n id: string;\n title: string;\n completed: number;\n sort: number;\n created_at: string;\n }>(\n `SELECT id, title, completed, sort, created_at\n FROM items\n WHERE list_id = :list_id\n ORDER BY sort ASC, created_at ASC`, // <-- stable order; completion does not affect position\n { list_id },\n );\n return renderListText(list, items);\n}\n\nasync function listSummaryText() {\n const rows = await qAll<{\n id: string;\n title: string;\n open_count: number;\n done_count: number;\n }>(\n `SELECT\n l.id,\n l.title,\n COALESCE(SUM(CASE WHEN i.completed = 0 THEN 1 ELSE 0 END), 0) AS open_count,\n COALESCE(SUM(CASE WHEN i.completed = 1 THEN 1 ELSE 0 END), 0) AS done_count\n FROM lists l\n LEFT JOIN items i ON i.list_id = l.id\n WHERE l.archived = 0\n GROUP BY l.id, l.title\n ORDER BY l.created_at DESC`,\n );\n if (rows.length === 0) return \"No lists yet.\";\n const out: string[] = [\"Lists:\"];\n for (const r of rows) {\n out.push(\n `- ${\n r.title || \"todo list\"\n } (${r.id}): ${r.open_count} open, ${r.done_count} done`,\n );\n }\n return out.join(\"\\n\");\n}\n\nasync function loadJSON(req: Request): Promise {\n const ct = (req.headers.get(\"content-type\") || \"\").toLowerCase();\n if (ct.includes(\"application/json\")) {\n try {\n return await req.json();\n } catch {\n return {};\n }\n }\n if (\n ct.includes(\"application/x-www-form-urlencoded\") ||\n ct.includes(\"multipart/form-data\")\n ) {\n const fd = await req.formData();\n const obj: Record = {};\n for (const [k, v] of fd.entries()) {\n if (obj[k] !== undefined) {\n const curr = obj[k];\n obj[k] = Array.isArray(curr) ? [...curr, v] : [curr, v];\n } else {\n obj[k] = v;\n }\n }\n return obj;\n }\n try {\n const t = await req.text();\n return JSON.parse(t);\n } catch {\n return {};\n }\n}\n\n// ---------- endpoint handlers (all POST, help also supports GET) ----------\nasync function listsCreate(body: any) {\n const title = (body?.title ?? \"todo list\").toString().trim() || \"todo list\";\n for (let i = 0; i < 5; i++) {\n const id = genId(\"list\");\n try {\n await sqlite.execute({\n sql: `INSERT INTO lists (id, title) VALUES (:id, :title)`,\n args: { id, title },\n });\n const text = await renderList(id);\n return textResponse(text!);\n } catch (e: any) {\n if (String(e?.message || \"\").toLowerCase().includes(\"unique\")) continue;\n throw e;\n }\n }\n return textResponse(\"Failed to create list (ID collision). Try again.\", 500);\n}\n\nasync function listsAdd(body: any) {\n const list_id = body?.list_id?.toString();\n if (!list_id) return badRequest(\"list_id is required\");\n const found = await q1<{ id: string }>(\n `SELECT id FROM lists WHERE id = :id`,\n { id: list_id },\n );\n if (!found) return notFound(`list ${list_id} does not exist`);\n\n // newline-separated titles string\n const titles = parseNewlineList(body?.items ?? body?.item ?? \"\");\n if (titles.length === 0) {\n return badRequest(\"Provide 'items' as a newline-separated string\");\n }\n\n let sortVal = await nextSort(list_id);\n const batch = [];\n for (const title of titles) {\n const id = genId(\"item\");\n batch.push({\n sql: `INSERT INTO items (id, list_id, title, completed, sort)\n VALUES (:id, :list_id, :title, 0, :sort)`,\n args: { id, list_id, title, sort: sortVal++ },\n });\n }\n await sqlite.batch(batch);\n const text = await renderList(list_id);\n return textResponse(text!);\n}\n\nasync function listsGet(body: any) {\n const list_id = body?.list_id?.toString();\n if (!list_id) return badRequest(\"list_id is required\");\n const text = await renderList(list_id);\n if (!text) return notFound(`list ${list_id} does not exist`);\n return textResponse(text);\n}\n\nasync function itemsCompleteOrUncomplete(body: any, completedValue: 0 | 1) {\n const list_id = body?.list_id?.toString();\n if (!list_id) return badRequest(\"list_id is required\");\n\n // newline-separated item IDs string\n const item_ids = parseNewlineList(body?.item_ids ?? body?.items ?? \"\");\n if (item_ids.length === 0) {\n return badRequest(\n \"item_ids must be a newline-separated string of item IDs\",\n );\n }\n\n const nowSql = `strftime('%Y-%m-%dT%H:%M:%fZ','now')`;\n const batch = item_ids.map((id: string) => ({\n sql: `UPDATE items\n SET completed = :completed,\n completed_at = CASE WHEN :completed = 1 THEN ${nowSql} ELSE NULL END\n WHERE id = :id AND list_id = :list_id`,\n args: { completed: completedValue, id, list_id },\n }));\n await sqlite.batch(batch);\n\n const text = await renderList(list_id);\n return textResponse(text!);\n}\n\nasync function itemsRename(body: any) {\n const item_id = body?.item_id?.toString();\n const title = body?.title?.toString();\n if (!item_id) return badRequest(\"item_id is required\");\n if (!title) return badRequest(\"title is required\");\n\n const item = await q1<{ id: string; list_id: string }>(\n `SELECT id, list_id FROM items WHERE id = :id`,\n { id: item_id },\n );\n if (!item) return notFound(`item ${item_id} does not exist`);\n\n await sqlite.execute({\n sql: `UPDATE items SET title = :title WHERE id = :id`,\n args: { title, id: item_id },\n });\n\n const text = await renderList(item.list_id);\n return textResponse(text!);\n}\n\nasync function itemsDelete(body: any) {\n const item_id = body?.item_id?.toString();\n if (!item_id) return badRequest(\"item_id is required\");\n\n const item = await q1<{ id: string; list_id: string }>(\n `SELECT id, list_id FROM items WHERE id = :id`,\n { id: item_id },\n );\n if (!item) return notFound(`item ${item_id} does not exist`);\n\n await sqlite.execute({\n sql: `DELETE FROM items WHERE id = :id`,\n args: { id: item_id },\n });\n\n const text = await renderList(item.list_id);\n return textResponse(text!);\n}\n\nasync function listsRename(body: any) {\n const list_id = body?.list_id?.toString();\n const title = body?.title?.toString();\n if (!list_id) return badRequest(\"list_id is required\");\n if (!title) return badRequest(\"title is required\");\n\n const found = await q1<{ id: string }>(\n `SELECT id FROM lists WHERE id = :id`,\n { id: list_id },\n );\n if (!found) return notFound(`list ${list_id} does not exist`);\n\n await sqlite.execute({\n sql: `UPDATE lists SET title = :title WHERE id = :id`,\n args: { title, id: list_id },\n });\n\n const text = await renderList(list_id);\n return textResponse(text!);\n}\n\nasync function listsList() {\n const text = await listSummaryText();\n return textResponse(text);\n}\n\nfunction helpText() {\n return `TODO API (text responses)\n\nHelp:\n GET or POST /help\n Body (for POST): {}\n -> This help text.\n\nEndpoints (POST):\n /v1/lists.create\n Body: { \"title\": \"My todos\" }\n -> Create a list. Returns rendered list.\n\n /v1/lists.add\n Body: { \"list_id\": \"list-xxxxxx\", \"items\": \"task A\\\\ntask B\\\\ntask C\" }\n (newline-separated titles; accepts real newlines, \"\\\\n\", or \"/n\")\n -> Add items (appended at the end). Returns rendered list.\n\n /v1/lists.get\n Body: { \"list_id\": \"list-xxxxxx\" }\n -> Returns rendered list.\n\n /v1/items.complete\n Body: { \"list_id\": \"list-xxxxxx\", \"item_ids\": \"item-aaa\\\\nitem-bbb\" }\n (newline-separated item IDs; accepts real newlines, \"\\\\n\", or \"/n\")\n -> Mark items completed. Returns rendered list.\n\n /v1/items.uncomplete\n Body: { \"list_id\": \"list-xxxxxx\", \"item_ids\": \"item-aaa\\\\nitem-bbb\" }\n (newline-separated item IDs)\n -> Mark items uncompleted. Returns rendered list.\n\n /v1/items.rename\n Body: { \"item_id\": \"item-aaaaaa\", \"title\": \"New title\" }\n -> Rename item. Returns rendered list.\n\n /v1/items.delete\n Body: { \"item_id\": \"item-aaaaaa\" }\n -> Delete item. Returns rendered list.\n\n /v1/lists.rename\n Body: { \"list_id\": \"list-xxxxxx\", \"title\": \"New List Name\" }\n -> Rename list. Returns rendered list.\n\n /v1/lists.list\n Body: {}\n -> Summary of all lists.\n\nRendered list format:\n todo list (list-{6charuuid})\n ☐ todo 1 (item-{6charuuid})\n ☑ done example (item-{6charuuid})\n\nNotes:\n- Order is stable: items keep their insertion order (by 'sort'); toggling complete does NOT reorder.\n- IDs are short, prefixed nanoids: list-XXXXXX and item-XXXXXX.\n- All outputs are text/plain for easy agent parsing.`;\n}\n\n// ---------- HTTP entry ----------\nexport default async function (req: Request): Promise {\n // Preflight for browsers\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n status: 204,\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"*\",\n \"Access-Control-Max-Age\": \"86400\",\n },\n });\n }\n\n await ensureSchema();\n\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/+$/, \"\");\n const body = await loadJSON(req);\n\n // POST-only for API (help also supports GET)\n if (req.method !== \"POST\") {\n if (req.method === \"GET\" && url.pathname === \"/help\") {\n return textResponse(helpText());\n }\n return textResponse(\n \"Method Not Allowed (use POST for API; GET or POST for /help). See /help.\",\n 405,\n );\n }\n\n try {\n switch (path) {\n case \"/help\":\n return textResponse(helpText());\n case \"/v1/lists.create\":\n return await listsCreate(body);\n case \"/v1/lists.add\":\n return await listsAdd(body);\n case \"/v1/lists.get\":\n return await listsGet(body);\n case \"/v1/items.complete\":\n return await itemsCompleteOrUncomplete(body, 1);\n case \"/v1/items.uncomplete\":\n return await itemsCompleteOrUncomplete(body, 0);\n case \"/v1/items.rename\":\n return await itemsRename(body);\n case \"/v1/items.delete\":\n return await itemsDelete(body);\n case \"/v1/lists.rename\":\n return await listsRename(body);\n case \"/v1/lists.list\":\n return await listsList();\n default:\n return textResponse(\"Unknown endpoint. Use GET or POST /help.\", 404);\n }\n } catch (err: any) {\n const msg = (err?.message ?? String(err)).slice(0, 1000);\n return textResponse(`Server Error: ${msg}`, 500);\n }\n}","deleted",false,"label","todotodo",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":58,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_59":60,"_18":61},["D",1755873052016],"children",[],[35],"97c3a498-7f64-11f0-95aa-0224a6c84d84",["D",1755873046808],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","32765ebe-d05f-4753-a823-a8be39b8f577","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","0cc0ecd3-bdff-490f-92b4-a6682e79cdae","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":62,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yb1RNUGY2SmR3Vkt3VmVtSTIwZXJlM3pqV1IifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":62,"_13":14,"_45":149,"_64":-5,"_65":53,"_66":67,"_68":67,"_69":-5,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":44,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":150,"_96":151,"_98":152,"_100":53},[146],"files",[146],"counts",{"_136":78,"_137":138,"_139":78,"_31":140,"_141":142},[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_18":135},[35],"pulls","branches",1,"forks",{"_143":78,"_145":78},"connections",{"_143":78,"_144":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":58,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_59":147,"_18":148},[],[35],["D",1755873046808],{"_11":12,"_115":111},{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_101":62,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_131":186,"_187":188,"_189":190,"_191":53,"_192":53,"_193":53,"_194":44,"_195":-5,"_196":-7,"_197":-7,"_198":78,"_199":53,"_200":53,"_201":-5,"_202":53,"_203":53,"_204":53,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":16,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Code