[{"_1":2,"_169":-5,"_170":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","ff2b4b5d46c0d41ac97a7ec389dfa57b1b567d3b","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_147":148,"_166":167,"_168":-5},"handle","dhvanil","name","untitled-3573","path","main.tsx","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":-5,"_116":32,"_14":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_146":20},"id","1c3d0372-7f65-11f0-9080-0224a6c84d84","createdAt",["D",1755873269062],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","32765ebe-d05f-4753-a823-a8be39b8f577","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","0cc0ecd3-bdff-490f-92b4-a6682e79cdae","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yb1RNUGY2SmR3Vkt3VmVtSTIwZXJlM3pqV1IifQ","org",{"_93":94,"_132":129,"_12":111},"avatar","branch",{"_135":136,"_95":43,"_101":137,"_138":102,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},"version",3,"1c3d6916-7f65-11f0-9080-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":149,"_95":98,"_150":151,"_152":-5,"_153":137,"_154":136,"_155":156,"_103":157,"_135":158,"_159":160,"_161":162,"_163":20,"_164":-5,"_97":165},"2098d9dc-7f65-11f0-9080-0224a6c84d84","fileId","1c3fd3ea-7f65-11f0-9080-0224a6c84d84","parentId","branchId","branchVersion","latest",true,["D",1755873276368],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","label",[98],"permalink","https://www.val.town/x/dhvanil/untitled-3573/code/main.tsx","extension","actionData","errors"]