[{"_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",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":25,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":37,"_35":36,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","0e395f30-7f67-11f0-b669-0224a6c84d84","name","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}","script","createdAt",["D",1755874124705],"branchVersion","branchId","0e372530-7f67-11f0-b669-0224a6c84d84","id","0e36cefa-7f67-11f0-b669-0224a6c84d84","untitled-2473",["D",1755874104523],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","32765ebe-d05f-4753-a823-a8be39b8f577","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0cc0ecd3-bdff-490f-92b4-a6682e79cdae","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",5,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dhvanil","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yb1RNUGY2SmR3Vkt3VmVtSTIwZXJlM3pqV1IifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":150,"_79":151,"_81":152,"_83":25},"tree",[144],"files",[144],"counts",{"_133":61,"_134":135,"_136":61,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":37,"_35":36,"_24":25,"_131":-5,"_27":132},"1a3eb30c-7f67-11f0-ab36-0224a6c84d84","parentId","latest",["D",1755874124705],3,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":61,"_143":61},"connections",{"_141":61,"_142":61},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":37,"_35":36,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1755874124705],"children",[],[28],["D",1755874104523],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":57,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":85,"_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"]

Diff · v4