[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"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-2473","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":44,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"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":-5,"_18":55},"id","1c2aceda-7f67-11f0-aca9-0224a6c84d84","main.tsx","fileId","0e395f30-7f67-11f0-b669-0224a6c84d84","parentId","branchId","0e372530-7f67-11f0-b669-0224a6c84d84","branchVersion",5,"latest",true,"createdAt",["D",1755874127929],4,"fileType","http","content","// @title todo-api\n// @description POST-only TODO API for AI agents. Pure text responses. SQLite-backed.\n// Set this file's trigger to HTTP in Val Town.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ---------- ID generation (no npm deps) ----------\nconst ALPHABET = \"23456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz\";\nfunction randomId(n: number) {\n const bytes = new Uint8Array(n);\n crypto.getRandomValues(bytes);\n let out = \"\";\n for (let i = 0; i < n; i++) out += ALPHABET[bytes[i] % ALPHABET.length];\n return out;\n}\nconst genId = (prefix: \"list\" | \"item\") => `${prefix}-${randomId(6)}`;\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(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: {\n \"content-type\": \"text/plain; charset=utf-8\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Cache-Control\": \"no-store\",\n },\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\n// NOTE: Order never changes on completion toggle.\n// We render by insertion order (sort asc, then created_at), ignoring completed.\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`,\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) ----------\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 (POST-only, text responses)\n\nEndpoints:\n POST /help\n Body: {}\n -> This help text.\n\n POST /v1/lists.create\n Body: { \"title\": \"My todos\" }\n -> Create a list. Returns rendered list.\n\n POST /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. Returns rendered list.\n\n POST /v1/lists.get\n Body: { \"list_id\": \"list-xxxxxx\" }\n -> Returns rendered list.\n\n POST /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 POST /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 POST /v1/items.rename\n Body: { \"item_id\": \"item-aaaaaa\", \"title\": \"New title\" }\n -> Rename item. Returns rendered list.\n\n POST /v1/items.delete\n Body: { \"item_id\": \"item-aaaaaa\" }\n -> Delete item. Returns rendered list.\n\n POST /v1/lists.rename\n Body: { \"list_id\": \"list-xxxxxx\", \"title\": \"New List Name\" }\n -> Rename list. Returns rendered list.\n\n POST /v1/lists.list\n Body: {}\n -> Summary of all lists.\n\nRendered list format (order never changes on completion):\n todo list (list-{6char})\n ☐ first task (item-{6char})\n ☑ finished task (item-{6char})\n\nNotes:\n- No auth. Keep list IDs private if needed.\n- IDs are short, prefixed random IDs.\n- All outputs are text/plain for easy agent parsing.\n- Order is stable by insertion: toggling completion does not move items.\n`;\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, GET\",\n \"Access-Control-Allow-Headers\": \"*\",\n \"Access-Control-Max-Age\": \"86400\",\n },\n });\n }\n\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/+$/, \"\");\n\n // Convenience GETs\n if (req.method === \"GET\") {\n if (path === \"/help\") return textResponse(helpText());\n if (path === \"/healthz\") return textResponse(\"ok\");\n return textResponse(\"Method Not Allowed (POST only). See /help.\", 405);\n }\n\n if (req.method !== \"POST\") {\n return textResponse(\"Method Not Allowed (POST only). See /help.\", 405);\n }\n\n try {\n await ensureSchema();\n const body = await loadJSON(req);\n\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 POST /help.\", 404);\n }\n } catch (err: any) {\n console.error(\"Handler error:\", err);\n const msg = (err?.message ?? String(err)).slice(0, 1000);\n return textResponse(`Server Error: ${msg}`, 500);\n }\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1755874127929],"children",[],[35],"0e36cefa-7f67-11f0-b669-0224a6c84d84",["D",1755874104523],"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,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yb1RNUGY2SmR3Vkt3VmVtSTIwZXJlM3pqV1IifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":44,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"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":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1755874104523],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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