[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_545":546,"_547":548},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",195,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","docs/issues/richer-data-model/certification.md","latestPath","fileId","1d471d5a-7c96-11f1-a281-1607ee4eb77e","name","certification.md","fileType","content","# Certification: richer-data-model remediation pass\n\nDate: 2026-07-10 Verdict: **certified complete** (independent recertification\naudit)\n\nAfter the five implementation tickets in `tickets.md` landed, a remediation pass\nran as five one-shot agent prompts (formerly in `agent-prompts/`, deleted after\nthis certification). What each fixed:\n\n1. **SQLite transaction contract** — `db.ts` drives every multi-statement write\n through `client.transaction(\"write\")` with explicit commit/rollback, never\n top-level `batch()`. The resolved adapter\n (`npm:@tursodatabase/serverless@1.2.3/compat`) was read at source and its\n top-level `batch()` confirmed broken for this purpose: it ignores the mode\n argument and drops bound args. Proven by tests: a batch-throwing client,\n forced mid-transaction failure rollback, and entity-ID (not event-ID) return\n values.\n2. **Comment UI** — the comment edit control is a `

` that round-trips\n   multiline markdown through the real Hono form routes; bodies render as\n   escaped JSX text with `whitespace-pre-wrap` (no HTML rendering). Control\n   visibility fixed via a maintainer-only `canModerateComments` prop on\n   `IssueDetailPage`: maintainers and the comment author see edit/delete\n   controls; a non-author issue creator does not. Server-side checks remain the\n   enforcement layer and the UI mirrors them exactly.\n3. **API/docs parity** — strict all-or-nothing validation for collection fields\n   (`label_ids`/`add`/`remove`/`assignees`: absent = empty operation,\n   present-but-malformed = 400); 400 for an invalid `status` filter; 404\n   existence guards on every mutation route; a small typed `HttpError`\n   (400/404/409) in `db.ts` replacing the old map-everything-to-409 handler;\n   `docs/issue-tracker-valtown.md` rewritten with complete response shapes, the\n   event-data grammar, the `{\"error\": \"...\"}` convention, a status-code table,\n   and exact per-route responses matching `api.ts` route-by-route.\n4. **Check policy** — Biome (tab-indented) is the canonical formatter, not\n   `deno fmt`; `.vt/` and `.claude/` excluded via `biome.json` `files.includes`;\n   canonical commands are the `deno.json` tasks `fmt` / `lint` / `typecheck` /\n   `test` / `check` (aggregate), documented in `README.md` and all passing.\n5. **Recertification** — independent audit rebuilt the requirement matrix for\n   all five tickets against the PRD, re-ran all checks (21/21 tests), compared\n   every API route against the convention doc (18 route/status combinations),\n   and repeated the stale-schema scan: no live use of priority, `in_progress`,\n   `description`, JSON-label storage, single-assignee storage, `*_by` columns,\n   or a stored comment `author` column (`Comment.author` is derived from\n   `comment.created` events via JOIN, per ADR 0003/0004). The only old- schema\n   references are the migration reader in `db.ts` and legacy-fixture SQL in\n   `db_test.ts`, by design.\n\n## Caveats\n\n- Nothing was deployed. The adapter-contract proof is static (reading the\n  resolved dependency's source), not a live round-trip against Val Town's scoped\n  SQLite. Live proof requires deploying and exercising one transactional write.\n- Known cosmetic quirk, out of scope: the HTML app's `onError` in `app.tsx`\n  renders every thrown error as a banner with HTTP status 409, including 404\n  `HttpError`s from the store. HTML routes check existence before mutating, so\n  it rarely triggers.\n","createdAt",["D",1783711960231],"branchVersion","branchId","b6817ee5-03f4-41f2-901e-1bb2efa16e9e","id","abe99189-4851-4aab-ae08-280f66283cac","val-issue-tracker",["D",1783563523910],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Per-val issue tracker — import into any val for scoped issues","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","d1d90306-7b3c-11f1-b527-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","abe9918948514aabae08280f66283cac","tursoHostname","abe9918948514aabae08280f66283cac-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",369,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":540,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":541,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":542,"_82":543,"_84":544,"_86":24},"tree",[318,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354],"files",[318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354],"counts",{"_308":61,"_309":166,"_310":61,"_311":312,"_313":314},"contents",[128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":301,"_31":302,"_29":303,"_152":-5,"_39":40,"_38":304,"_154":57,"_36":305,"_13":61,"_33":306,"_34":-5,"_23":24,"_159":-5,"_26":307},{"_41":294,"_31":295,"_29":296,"_152":-5,"_39":40,"_38":297,"_154":57,"_36":298,"_13":61,"_33":20,"_34":299,"_23":24,"_159":-5,"_26":300},{"_41":288,"_31":289,"_29":290,"_152":-5,"_39":40,"_38":291,"_154":24,"_36":292,"_13":166,"_33":20,"_34":286,"_23":24,"_159":-5,"_26":293},{"_41":281,"_31":282,"_29":283,"_152":-5,"_39":40,"_38":284,"_154":24,"_36":285,"_13":166,"_33":20,"_34":286,"_23":24,"_159":-5,"_26":287},{"_41":274,"_31":275,"_29":276,"_152":-5,"_39":40,"_38":277,"_154":24,"_36":278,"_13":166,"_33":20,"_34":279,"_23":24,"_159":-5,"_26":280},{"_41":266,"_31":267,"_29":268,"_152":-5,"_39":40,"_38":269,"_154":24,"_36":270,"_13":271,"_33":20,"_34":272,"_23":24,"_159":-5,"_26":273},{"_41":259,"_31":260,"_29":261,"_152":-5,"_39":40,"_38":262,"_154":24,"_36":263,"_13":190,"_33":157,"_34":264,"_23":24,"_159":-5,"_26":265},{"_41":252,"_31":253,"_29":254,"_152":-5,"_39":40,"_38":255,"_154":24,"_36":256,"_13":190,"_33":157,"_34":257,"_23":24,"_159":-5,"_26":258},{"_41":244,"_31":245,"_29":246,"_152":-5,"_39":40,"_38":247,"_154":24,"_36":248,"_13":249,"_33":157,"_34":250,"_23":24,"_159":-5,"_26":251},{"_41":237,"_31":238,"_29":239,"_152":-5,"_39":40,"_38":240,"_154":24,"_36":241,"_13":166,"_33":157,"_34":242,"_23":24,"_159":-5,"_26":243},{"_41":230,"_31":231,"_29":232,"_152":-5,"_39":40,"_38":233,"_154":24,"_36":234,"_13":166,"_33":20,"_34":235,"_23":24,"_159":-5,"_26":236},{"_41":222,"_31":223,"_29":224,"_152":-5,"_39":40,"_38":225,"_154":24,"_36":226,"_13":227,"_33":157,"_34":228,"_23":24,"_159":-5,"_26":229},{"_41":214,"_31":215,"_29":216,"_152":-5,"_39":40,"_38":217,"_154":24,"_36":218,"_13":219,"_33":157,"_34":220,"_23":24,"_159":-5,"_26":221},{"_41":207,"_31":208,"_29":209,"_152":-5,"_39":40,"_38":210,"_154":24,"_36":211,"_13":166,"_33":157,"_34":212,"_23":24,"_159":-5,"_26":213},{"_41":200,"_31":201,"_29":202,"_152":-5,"_39":40,"_38":203,"_154":24,"_36":204,"_13":190,"_33":20,"_34":205,"_23":24,"_159":-5,"_26":206},{"_41":193,"_31":194,"_29":195,"_152":-5,"_39":40,"_38":196,"_154":24,"_36":197,"_13":61,"_33":157,"_34":198,"_23":24,"_159":-5,"_26":199},{"_41":185,"_31":186,"_29":187,"_152":-5,"_39":40,"_38":188,"_154":24,"_36":189,"_13":190,"_33":157,"_34":191,"_23":24,"_159":-5,"_26":192},{"_41":177,"_31":178,"_29":55,"_152":-5,"_39":40,"_38":179,"_154":24,"_36":180,"_13":181,"_33":182,"_34":183,"_23":24,"_159":-5,"_26":184},{"_41":169,"_31":170,"_29":171,"_152":-5,"_39":40,"_38":172,"_154":24,"_36":173,"_13":174,"_33":157,"_34":175,"_23":24,"_159":-5,"_26":176},{"_41":161,"_31":162,"_29":163,"_152":-5,"_39":40,"_38":164,"_154":24,"_36":165,"_13":166,"_33":157,"_34":167,"_23":24,"_159":-5,"_26":168},{"_41":149,"_31":150,"_29":151,"_152":-5,"_39":40,"_38":153,"_154":24,"_36":155,"_13":156,"_33":157,"_34":158,"_23":24,"_159":-5,"_26":160},"6516dd91-8c76-4357-ab20-f54e296757c4","ui.tsx","fca19e20-7b48-11f1-8cf9-1607ee4eb77e","parentId",181,"latest",["D",1783653143543],31,"script","/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\nimport type { IssueStatus, Label, StateReason } from \"./db.ts\";\n\nexport const FIELD =\n\t\"bg-[#1f232c] border border-[#2a2f3a] rounded-md min-h-10 px-3.5 text-sm font-medium text-[#e6e9ef] focus:outline-none focus:border-[#6ea8fe]\";\nconst BUTTON =\n\t\"inline-flex items-center gap-1.5 rounded-md min-h-10 px-3.5 text-sm font-medium cursor-pointer no-underline\";\nconst VARIANTS = {\n\tsolid: \"bg-[#3d7bf0] border border-[#3d7bf0] text-white hover:brightness-110\",\n\tghost:\n\t\t\"bg-transparent border border-[#3d7bf0] text-[#e6e9ef] hover:brightness-110\",\n\tdanger:\n\t\t\"bg-transparent border border-[#f06e7b] text-[#f06e7b] hover:bg-[#f06e7b] hover:text-white\",\n} as const;\n\nexport const STATUS_LABELS: Record<IssueStatus, string> = {\n\topen: \"Open\",\n\tclosed: \"Closed\",\n};\nexport const STATE_REASON_LABELS: Record<Exclude<StateReason, null>, string> = {\n\tcompleted: \"Completed\",\n\tnot_planned: \"Not planned\",\n\tduplicate: \"Duplicate\",\n\treopened: \"Reopened\",\n};\n\nexport const Card: FC<PropsWithChildren<{ class?: string }>> = ({\n\tchildren,\n\tclass: cls,\n}) => (\n\t<div\n\t\tclass={`bg-[#181b22] border border-[#2a2f3a] rounded-lg p-4 mb-[18px] ${\n\t\t\tcls ?? \"\"\n\t\t}`}\n\t>\n\t\t{children}\n\t</div>\n);\n\nexport const Button: FC<\n\tPropsWithChildren<{\n\t\tvariant?: keyof typeof VARIANTS;\n\t\thref?: string;\n\t\ttype?: \"button\" | \"submit\";\n\t\tclass?: string;\n\t\tname?: string;\n\t\tvalue?: string;\n\t}>\n> = ({\n\tvariant = \"solid\",\n\thref,\n\ttype = \"button\",\n\tclass: cls,\n\tname,\n\tvalue,\n\tchildren,\n}) => {\n\tconst classes = `${BUTTON} ${VARIANTS[variant]} ${cls ?? \"\"}`;\n\treturn href ? (\n\t\t<a class={classes} href={href}>\n\t\t\t{children}\n\t\t</a>\n\t) : (\n\t\t<button class={classes} type={type} name={name} value={value}>\n\t\t\t{children}\n\t\t</button>\n\t);\n};\n\nexport const Select: FC<\n\tPropsWithChildren<{ name: string; id?: string; class?: string }>\n> = ({ name, id, class: cls, children }) => (\n\t<select id={id} name={name} class={`${FIELD} ${cls ?? \"\"}`}>\n\t\t{children}\n\t</select>\n);\n\nexport const Banner: FC<{ kind: \"ok\" | \"err\"; msg: string }> = ({\n\tkind,\n\tmsg,\n}) => (\n\t<div\n\t\tclass={`rounded-lg border px-3.5 py-2.5 mb-4 ${\n\t\t\tkind === \"err\"\n\t\t\t\t? \"bg-[#2a1a1e] border-[#f06e7b] text-[#f7b3bb]\"\n\t\t\t\t: \"bg-[#15261c] border-[#5fd08a] text-[#a8e6c1]\"\n\t\t}`}\n\t>\n\t\t{msg}\n\t</div>\n);\n\nexport const StatusBadge: FC<{ status: IssueStatus; reason?: StateReason }> = ({\n\tstatus,\n\treason,\n}) => (\n\t<span\n\t\tclass={`inline-block rounded-full px-2.5 py-0.5 text-xs font-medium text-white ${\n\t\t\tstatus === \"open\" ? \"bg-blue-500\" : \"bg-gray-500\"\n\t\t}`}\n\t>\n\t\t{STATUS_LABELS[status]}\n\t\t{reason ? ` · ${STATE_REASON_LABELS[reason]}` : \"\"}\n\t</span>\n);\n\nexport const LabelTag: FC<{ label: Label }> = ({ label }) => (\n\t<span\n\t\tclass=\"inline-block rounded-md border px-1.5 py-px text-[11px] mr-1\"\n\t\tstyle={`border-color:#${label.color};color:#${label.color}`}\n\t>\n\t\t{label.name}\n\t</span>\n);\n","label",[150],"11905e8c-5e99-417a-a9fb-76b83a02a16b","test_sqlite.ts","2bb2ce86-7c0d-11f1-9a68-1607ee4eb77e",185,["D",1783695440607],1,"import { DatabaseSync } from \"node:sqlite\";\n\nexport interface TestResultSet {\n\tcolumns: string[];\n\trows: Record<string, unknown>[];\n\trowsAffected: number;\n\tlastInsertRowid: bigint | undefined;\n}\n\nexport function createTestSqlite() {\n\tconst database = new DatabaseSync(\":memory:\");\n\tdatabase.exec(\"PRAGMA foreign_keys = ON\");\n\n\tconst execute = (\n\t\tstatement: string | { sql: string; args?: unknown[] },\n\t): Promise<TestResultSet> => {\n\t\ttry {\n\t\t\tconst sql = typeof statement === \"string\" ? statement : statement.sql;\n\t\t\tconst args = typeof statement === \"string\" ? [] : (statement.args ?? []);\n\t\t\tconst prepared = database.prepare(sql);\n\t\t\tif (/^\\s*(SELECT|PRAGMA|WITH)\\b/i.test(sql)) {\n\t\t\t\tconst rows = prepared.all(...(args as never[])) as Record<\n\t\t\t\t\tstring,\n\t\t\t\t\tunknown\n\t\t\t\t>[];\n\t\t\t\treturn Promise.resolve({\n\t\t\t\t\tcolumns: rows[0] ? Object.keys(rows[0]) : [],\n\t\t\t\t\trows,\n\t\t\t\t\trowsAffected: 0,\n\t\t\t\t\tlastInsertRowid: undefined,\n\t\t\t\t});\n\t\t\t}\n\t\t\tconst result = prepared.run(...(args as never[]));\n\t\t\treturn Promise.resolve({\n\t\t\t\tcolumns: [],\n\t\t\t\trows: [],\n\t\t\t\trowsAffected: Number(result.changes),\n\t\t\t\tlastInsertRowid: BigInt(result.lastInsertRowid),\n\t\t\t});\n\t\t} catch (error) {\n\t\t\treturn Promise.reject(error);\n\t\t}\n\t};\n\n\treturn {\n\t\tdatabase,\n\t\texecute,\n\t\tasync batch(statements: Array<string | { sql: string; args?: unknown[] }>) {\n\t\t\tdatabase.exec(\"BEGIN IMMEDIATE\");\n\t\t\ttry {\n\t\t\t\tconst results = [];\n\t\t\t\tfor (const statement of statements) {\n\t\t\t\t\tresults.push(await execute(statement));\n\t\t\t\t}\n\t\t\t\tdatabase.exec(\"COMMIT\");\n\t\t\t\treturn results;\n\t\t\t} catch (error) {\n\t\t\t\tdatabase.exec(\"ROLLBACK\");\n\t\t\t\tthrow error;\n\t\t\t}\n\t\t},\n\t};\n}\n",[162],"cd8a9ea8-1579-4629-9a43-c9a3525477d5","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",30,["D",1783568883064],11,"export {\n\tcreateIssueTracker,\n\tdefault,\n\ttype IssueTrackerOptions,\n} from \"./app.tsx\";\n",[170],"b64f3437-f4bc-4279-9ad6-786ec6cac581","main.ts",162,["D",1783653141198],10,"http","import { createIssueTracker } from \"./mod.ts\";\n\n/**\n * This val's own issue tracker — manages THIS val's scoped SQLite database.\n *\n * To add issues to a DIFFERENT val, import the tracker into that val:\n *\n *   import { createIssueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n *   export default createIssueTracker({ owner: [\"nbbaier\"] });\n *\n * Because scoped SQLite is bound to the running val, the imported tracker\n * reads/writes the host val's database automatically — no per-val config needed.\n */\nexport default createIssueTracker({});\n",[178],"17e2256d-d27b-4705-aa51-8a95e016e3e4","layout.tsx","fd6015ee-7b48-11f1-bafe-1607ee4eb77e",107,["D",1783574315459],2,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\n\nexport const Layout: FC<\n\tPropsWithChildren<{\n\t\ttitle: string;\n\t\tuser?: string | null;\n\t\tauth?: boolean;\n\t}>\n> = ({ title, user, auth = true, children }) => (\n\t<html lang=\"en\">\n\t\t<head>\n\t\t\t<meta charSet=\"utf-8\" />\n\t\t\t<meta name=\"viewport\" content=\"width=device-width,initial-scale=1\" />\n\t\t\t<title>{title}</title>\n\t\t\t<script src=\"https://cdn.twind.style\" crossorigin=\"anonymous\" />\n\t\t\t<script src=\"https://esm.town/v/std/catch\" />\n\t\t</head>\n\t\t<body class=\"m-0 bg-[#0f1115] text-[#e6e9ef] font-sans text-sm leading-relaxed\">\n\t\t\t<header class=\"flex items-center gap-3 px-5 py-3.5 border-b border-[#2a2f3a] bg-[#181b22]\">\n\t\t\t\t<h1 class=\"text-base m-0 font-semibold\">\n\t\t\t\t\t<a href=\"/\" class=\"text-[#e6e9ef] no-underline\">\n\t\t\t\t\t\t{title}\n\t\t\t\t\t</a>\n\t\t\t\t</h1>\n\t\t\t\t<span class=\"flex-1\" />\n\t\t\t\t<a\n\t\t\t\t\thref=\"/source\"\n\t\t\t\t\tclass=\"text-[#8b93a3] text-xs no-underline hover:underline\"\n\t\t\t\t>\n\t\t\t\t\tview source\n\t\t\t\t</a>\n\t\t\t\t{user ? (\n\t\t\t\t\t<>\n\t\t\t\t\t\t<span class=\"text-[#8b93a3] text-[13px]\">@{user}</span>\n\t\t\t\t\t\t<form method=\"post\" action=\"/auth/logout\" class=\"m-0\">\n\t\t\t\t\t\t\t<button\n\t\t\t\t\t\t\t\ttype=\"submit\"\n\t\t\t\t\t\t\t\tclass=\"bg-transparent border border-[#2a2f3a] text-[#e6e9ef] rounded-md px-3.5 py-2 font-medium cursor-pointer hover:brightness-110\"\n\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\tLog out\n\t\t\t\t\t\t\t</button>\n\t\t\t\t\t\t</form>\n\t\t\t\t\t</>\n\t\t\t\t) : auth ? (\n\t\t\t\t\t<a\n\t\t\t\t\t\thref=\"/auth/login\"\n\t\t\t\t\t\tclass=\"inline-flex items-center gap-1.5 bg-transparent border border-[#2a2f3a] text-[#e6e9ef] rounded-md px-3.5 py-2 font-medium no-underline hover:brightness-110\"\n\t\t\t\t\t>\n\t\t\t\t\t\tLog in\n\t\t\t\t\t</a>\n\t\t\t\t) : null}\n\t\t\t</header>\n\t\t\t<div class=\"max-w-[960px] mx-auto p-5\">{children}</div>\n\t\t</body>\n\t</html>\n);\n",[186],"b45beed6-dbbf-487d-b94f-41f63b89078e","env.ts","1d39134a-7c96-11f1-80af-1607ee4eb77e",194,["D",1783711960220],"const valTownApiKey = Deno.env.get(\"VAL_TOWN_API_KEY\");\nif (!valTownApiKey) {\n\tconsole.error(\"VAL_TOWN_API_KEY is not set\");\n}\n\nconsole.log(valTownApiKey);\n",[194],"c668e951-422b-4702-89c4-33781ee1022c","deno.json","0aa42a7a-7b43-11f1-9001-1607ee4eb77e",189,["D",1783695440613],"{\n\t\"compilerOptions\": {\n\t\t\"lib\": [\n\t\t\t\"dom\",\n\t\t\t\"dom.iterable\",\n\t\t\t\"dom.asynciterable\",\n\t\t\t\"deno.ns\",\n\t\t\t\"deno.unstable\"\n\t\t],\n\t\t\"noImplicitAny\": false,\n\t\t\"strict\": false,\n\t\t\"types\": [\"https://www.val.town/types/valtown.d.ts\"]\n\t},\n\t\"experimental\": {\n\t\t\"unstable-node-globals\": true,\n\t\t\"unstable-sloppy-imports\": true,\n\t\t\"unstable-temporal\": true,\n\t\t\"unstable-worker-options\": true\n\t},\n\t\"imports\": {\n\t\t\"-\": \"npm:-@0.0.1-security.1\",\n\t\t\"@biomejs/biome\": \"npm:@biomejs/biome@^2.5.3\",\n\t\t\"@std/assert\": \"jsr:@std/assert@^1.0.19\",\n\t\t\"@types/node\": \"npm:@types/node@^26.1.1\",\n\t\t\"hono\": \"npm:hono@^4.12.27\"\n\t},\n\t\"lint\": {\n\t\t\"include\": [\"*.ts\", \"*.tsx\"],\n\t\t\"rules\": {\n\t\t\t\"exclude\": [\"no-explicit-any\", \"no-import-prefix\"]\n\t\t}\n\t},\n\t\"lock\": false,\n\t\"nodeModulesDir\": \"auto\"\n}\n",[201],"cb54575b-d6fe-4dec-995c-1f182b29dfde","db_test.ts","2a3ea20a-7c0d-11f1-b256-1607ee4eb77e",191,["D",1783695440991],"import {\n\tassert,\n\tassertEquals,\n\tassertExists,\n\tassertRejects,\n} from \"jsr:@std/assert@1.0.19\";\nimport { createIssueStore } from \"./db.ts\";\nimport { createTestSqlite } from \"./test_sqlite.ts\";\n\nfunction createClock(start = 1_700_000_000_000) {\n\tlet value = start;\n\treturn {\n\t\tnow: () => value,\n\t\ttick: () => ++value,\n\t};\n}\n\nDeno.test(\"issue lifecycle auto-manages status and state reason\", async () => {\n\tconst client = createTestSqlite();\n\tclient.database.exec(\"PRAGMA foreign_keys = OFF\");\n\tconst store = createIssueStore(client, () => 1_700_000_000_000);\n\tawait store.initSchema();\n\tassertEquals(\n\t\tclient.database.prepare(\"PRAGMA foreign_keys\").get()?.foreign_keys,\n\t\t1,\n\t\t\"schema initialization must enable production foreign keys\",\n\t);\n\n\tconst id = await store.createIssue({\n\t\ttitle: \"Lifecycle\",\n\t\tbody: \"body\",\n\t\tactor: \"alice\",\n\t});\n\tassertEquals((await store.getIssue(id))?.state_reason, null);\n\n\tawait store.closeIssue(id, \"alice\", \"not_planned\");\n\tassertEquals(\n\t\t{\n\t\t\tstatus: (await store.getIssue(id))?.status,\n\t\t\tstate_reason: (await store.getIssue(id))?.state_reason,\n\t\t},\n\t\t{ status: \"closed\", state_reason: \"not_planned\" },\n\t);\n\n\tawait store.reopenIssue(id, \"alice\");\n\tassertEquals(\n\t\t{\n\t\t\tstatus: (await store.getIssue(id))?.status,\n\t\t\tstate_reason: (await store.getIssue(id))?.state_reason,\n\t\t},\n\t\t{ status: \"open\", state_reason: \"reopened\" },\n\t);\n\n\tlet rejected = false;\n\ttry {\n\t\tawait client.execute({\n\t\t\tsql: \"UPDATE issue_tracker_issues SET state_reason = 'completed' WHERE id = ?\",\n\t\t\targs: [id],\n\t\t});\n\t} catch {\n\t\trejected = true;\n\t}\n\tassertEquals(rejected, true, \"the schema must reject open + completed\");\n\n\tconst completedId = await store.createIssue({\n\t\ttitle: \"Default close\",\n\t\tactor: \"alice\",\n\t});\n\tawait store.closeIssue(completedId, \"alice\");\n\tassertEquals((await store.getIssue(completedId))?.state_reason, \"completed\");\n\tconst duplicateId = await store.createIssue({\n\t\ttitle: \"Duplicate\",\n\t\tactor: \"alice\",\n\t});\n\tawait store.closeIssue(duplicateId, \"alice\", \"duplicate\");\n\tassertEquals((await store.getIssue(duplicateId))?.state_reason, \"duplicate\");\n});\n\nDeno.test(\"issue lifecycle emits boundary snapshots and one delta per changed field\", async () => {\n\tconst client = createTestSqlite();\n\tconst clock = createClock();\n\tconst store = createIssueStore(client, clock.now);\n\tawait store.initSchema();\n\tconst id = await store.createIssue({\n\t\ttitle: \"Audit\",\n\t\tbody: \"first\",\n\t\tactor: \"alice\",\n\t});\n\tclock.tick();\n\tawait store.updateIssue(id, { title: \"Audited\", body: \"second\" }, \"bob\");\n\tclock.tick();\n\tawait store.closeIssue(id, \"carol\", \"not_planned\");\n\n\tconst events = await store.listEvents({ entity: \"issue\", entityId: id });\n\tassertEquals(\n\t\tevents.map((event) => event.event_type),\n\t\t[\n\t\t\t\"issue.created\",\n\t\t\t\"issue.updated\",\n\t\t\t\"issue.updated\",\n\t\t\t\"issue.updated\",\n\t\t\t\"issue.updated\",\n\t\t],\n\t);\n\tassertEquals(events[0].data, {\n\t\tid,\n\t\ttitle: \"Audit\",\n\t\tbody: \"first\",\n\t\tstatus: \"open\",\n\t\tstate_reason: null,\n\t\tcreated_at: 1_700_000_000_000,\n\t\tupdated_at: 1_700_000_000_000,\n\t});\n\tassertEquals(\n\t\tevents.slice(1).map((event) => event.data),\n\t\t[\n\t\t\t{ update_target: \"title\", from: \"Audit\", to: \"Audited\" },\n\t\t\t{ update_target: \"body\", from: \"first\", to: \"second\" },\n\t\t\t{ update_target: \"status\", from: \"open\", to: \"closed\" },\n\t\t\t{ update_target: \"state_reason\", from: null, to: \"not_planned\" },\n\t\t],\n\t);\n\tassertEquals(\n\t\tevents.slice(3).map((event) => [event.actor, event.event_timestamp]),\n\t\t[\n\t\t\t[\"carol\", 1_700_000_000_002],\n\t\t\t[\"carol\", 1_700_000_000_002],\n\t\t],\n\t);\n\n\tclock.tick();\n\tawait store.deleteIssue(id, \"dana\");\n\tconst deleted = (\n\t\tawait store.listEvents({ entity: \"issue\", entityId: id })\n\t).at(-1);\n\tassertExists(deleted);\n\tassertEquals(deleted.event_type, \"issue.deleted\");\n\tassertEquals(deleted.actor, \"dana\");\n\tassertEquals(Object.keys(deleted.data as object).sort(), [\n\t\t\"body\",\n\t\t\"created_at\",\n\t\t\"id\",\n\t\t\"state_reason\",\n\t\t\"status\",\n\t\t\"title\",\n\t\t\"updated_at\",\n\t]);\n\tawait assertRejects(\n\t\t() => client.execute(\"DELETE FROM issue_tracker_events WHERE id = 1\"),\n\t\t\"append-only\",\n\t);\n});\n\nDeno.test(\"labels are seeded once and relationship changes are audited and touch the issue\", async () => {\n\tconst client = createTestSqlite();\n\tconst clock = createClock();\n\tconst store = createIssueStore(client, clock.now);\n\tawait store.initSchema();\n\tconst defaults = await store.listLabels();\n\tassertEquals(\n\t\tdefaults.map((label) => label.name),\n\t\t[\"bug\", \"documentation\", \"duplicate\", \"enhancement\", \"question\"],\n\t);\n\n\tconst question = defaults.find((label) => label.name === \"question\");\n\tassertExists(question);\n\tconst seeded = await store.listEvents({\n\t\tentity: \"label\",\n\t\tentityId: question.id,\n\t});\n\tassertEquals(\n\t\t{ type: seeded[0].event_type, actor: seeded[0].actor },\n\t\t{ type: \"label.created\", actor: \"system\" },\n\t);\n\tassertEquals(seeded[0].data, {\n\t\tid: question.id,\n\t\tname: question.name,\n\t\tcolor: question.color,\n\t\tcreated_at: question.created_at,\n\t\tupdated_at: question.updated_at,\n\t});\n\tawait store.deleteLabel(question.id, \"alice\");\n\tconst deleted = (\n\t\tawait store.listEvents({\n\t\t\tentity: \"label\",\n\t\t\tentityId: question.id,\n\t\t})\n\t).at(-1);\n\tassertExists(deleted);\n\tassertEquals(\n\t\t{ type: deleted.event_type, actor: deleted.actor },\n\t\t{ type: \"label.deleted\", actor: \"alice\" },\n\t);\n\tassertEquals(deleted.data, {\n\t\tid: question.id,\n\t\tname: question.name,\n\t\tcolor: question.color,\n\t\tcreated_at: question.created_at,\n\t\tupdated_at: question.updated_at,\n\t});\n\tawait store.initSchema();\n\tassertEquals(\n\t\t(await store.listLabels()).some((label) => label.name === \"question\"),\n\t\tfalse,\n\t);\n\tconst enhancement = defaults.find((label) => label.name === \"enhancement\");\n\tassertExists(enhancement);\n\tclock.tick();\n\tawait store.updateLabel(\n\t\tenhancement.id,\n\t\t{ name: \"feature\", color: \"123456\" },\n\t\t\"alice\",\n\t);\n\tconst updatedLabel = await store.getLabel(enhancement.id);\n\tassertEquals(\n\t\t{ name: updatedLabel?.name, color: updatedLabel?.color },\n\t\t{ name: \"feature\", color: \"123456\" },\n\t);\n\tassertEquals(\n\t\t(await store.listEvents({ entity: \"label\", entityId: enhancement.id }))\n\t\t\t.slice(-2)\n\t\t\t.map((event) => event.data),\n\t\t[\n\t\t\t{ update_target: \"name\", from: \"enhancement\", to: \"feature\" },\n\t\t\t{ update_target: \"color\", from: \"a2eeef\", to: \"123456\" },\n\t\t],\n\t);\n\tawait assertRejects(\n\t\t() => store.createLabel({ name: \"unsafe\", color: \"red;\", actor: \"alice\" }),\n\t\t\"six hexadecimal\",\n\t);\n\n\tconst issueId = await store.createIssue({ title: \"Labels\", actor: \"alice\" });\n\tconst bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n\tassertExists(bug);\n\tconst createdIssue = await store.getIssue(issueId);\n\tassertExists(createdIssue);\n\tconst createdAt = createdIssue.updated_at;\n\tclock.tick();\n\tawait store.addLabel(issueId, bug.id, \"bob\");\n\tconst labeled = await store.getIssue(issueId);\n\tassertExists(labeled);\n\tassertEquals(\n\t\tlabeled.labels.map((label) => label.name),\n\t\t[\"bug\"],\n\t);\n\tassert(labeled.updated_at > createdAt, \"adding a label must touch the issue\");\n\tclock.tick();\n\tconst beforeRemovalIssue = await store.getIssue(issueId);\n\tassertExists(beforeRemovalIssue);\n\tconst beforeLabelRemoval = beforeRemovalIssue.updated_at;\n\tawait store.removeLabel(issueId, bug.id, \"bob\");\n\tconst afterRemoval = await store.getIssue(issueId);\n\tassertExists(afterRemoval);\n\tassertEquals(afterRemoval.labels, []);\n\tassert(\n\t\tafterRemoval.updated_at > beforeLabelRemoval,\n\t\t\"label removal must touch the issue\",\n\t);\n\tclock.tick();\n\tawait store.addLabel(issueId, bug.id, \"bob\");\n\tclock.tick();\n\tconst beforeDeleteIssue = await store.getIssue(issueId);\n\tassertExists(beforeDeleteIssue);\n\tconst beforeLabelDelete = beforeDeleteIssue.updated_at;\n\tawait store.deleteLabel(bug.id, \"carol\");\n\tconst afterDelete = await store.getIssue(issueId);\n\tassertExists(afterDelete);\n\tassertEquals(afterDelete.labels, []);\n\tassert(\n\t\tafterDelete.updated_at > beforeLabelDelete,\n\t\t\"deleting an in-use label must touch the issue\",\n\t);\n\n\tconst deltas = (\n\t\tawait store.listEvents({ entity: \"issue\", entityId: issueId })\n\t)\n\t\t.filter((event) => event.event_type === \"issue.updated\")\n\t\t.map((event) => event.data);\n\tassertEquals(deltas, [\n\t\t{ update_target: \"label\", from: null, to: \"bug\" },\n\t\t{ update_target: \"label\", from: \"bug\", to: null },\n\t\t{ update_target: \"label\", from: null, to: \"bug\" },\n\t\t{ update_target: \"label\", from: \"bug\", to: null },\n\t]);\n});\n\nDeno.test(\"assignees are a set and assigned-to-me queries the relationship\", async () => {\n\tconst client = createTestSqlite();\n\tconst clock = createClock();\n\tconst store = createIssueStore(client, clock.now);\n\tawait store.initSchema();\n\tconst first = await store.createIssue({ title: \"First\", actor: \"alice\" });\n\tconst second = await store.createIssue({ title: \"Second\", actor: \"alice\" });\n\tconst beforeAssignIssue = await store.getIssue(first);\n\tassertExists(beforeAssignIssue);\n\tconst beforeAssign = beforeAssignIssue.updated_at;\n\tclock.tick();\n\tawait store.addAssignee(first, \"alice\", \"maintainer\");\n\tconst afterAssign = await store.getIssue(first);\n\tassertExists(afterAssign);\n\tassert(\n\t\tafterAssign.updated_at > beforeAssign,\n\t\t\"assignment must touch the issue\",\n\t);\n\tawait store.addAssignee(first, \"bob\", \"maintainer\");\n\tawait store.addAssignee(second, \"bob\", \"maintainer\");\n\tconst assigned = await store.getIssue(first);\n\tassertExists(assigned);\n\tassertEquals(assigned.assignees, [\"alice\", \"bob\"]);\n\tassertEquals(\n\t\t(await store.listIssues({ assignee: \"alice\" })).map((issue) => issue.id),\n\t\t[first],\n\t);\n\tassertEquals(\n\t\t(await store.listIssues({ assignee: \"bob\" }))\n\t\t\t.map((issue) => issue.id)\n\t\t\t.sort(),\n\t\t[first, second],\n\t);\n\tclock.tick();\n\tconst beforeRemove = (await store.getIssue(first))?.updated_at ?? 0;\n\tawait store.removeAssignee(first, \"alice\", \"maintainer\");\n\tassert(\n\t\t(await store.getIssue(first))?.updated_at &&\n\t\t\t(await store.getIssue(first))?.updated_at > beforeRemove,\n\t\t\"unassignment must touch the issue\",\n\t);\n\tassertEquals(await store.listIssues({ assignee: \"alice\" }), []);\n\tconst deltas = (\n\t\tawait store.listEvents({ entity: \"issue\", entityId: first })\n\t).map((event) => event.data);\n\tassert(\n\t\tdeltas.some(\n\t\t\t(data) =>\n\t\t\t\tJSON.stringify(data) ===\n\t\t\t\tJSON.stringify({ update_target: \"assignee\", from: \"alice\", to: null }),\n\t\t),\n\t\t\"unassignment delta missing\",\n\t);\n});\n\nDeno.test(\"blocking relationships form a strict DAG and blocked state is derived\", async () => {\n\tconst client = createTestSqlite();\n\tconst clock = createClock();\n\tconst store = createIssueStore(client, clock.now);\n\tawait store.initSchema();\n\tconst a = await store.createIssue({ title: \"A\", actor: \"alice\" });\n\tconst b = await store.createIssue({ title: \"B\", actor: \"alice\" });\n\tconst c = await store.createIssue({ title: \"C\", actor: \"alice\" });\n\tconst d = await store.createIssue({ title: \"D\", actor: \"alice\" });\n\n\tawait assertRejects(\n\t\t() => store.addBlock(a, a, \"blocks\", \"alice\"),\n\t\t\"cannot block itself\",\n\t);\n\tconst beforeBlock = (await store.getIssue(a))?.updated_at ?? 0;\n\tclock.tick();\n\tawait store.addBlock(a, b, \"blocks\", \"alice\");\n\tconst afterBlockA = await store.getIssue(a);\n\tassertExists(afterBlockA);\n\tassert(\n\t\tafterBlockA.updated_at > beforeBlock,\n\t\t\"block addition must touch the acting issue\",\n\t);\n\tconst blockedB = await store.getIssue(b);\n\tassertExists(blockedB);\n\tassertEquals(blockedB.blocked, true);\n\tawait assertRejects(() => store.addBlock(b, a, \"blocks\", \"alice\"), \"cycle\");\n\tawait assertRejects(\n\t\t() =>\n\t\t\tclient.execute({\n\t\t\t\tsql: \"INSERT INTO issue_tracker_issue_blocks (blocker_id, blocked_id) VALUES (?, ?)\",\n\t\t\t\targs: [b, a],\n\t\t\t}),\n\t\t\"cycle\",\n\t);\n\tclock.tick();\n\tawait store.addBlock(b, c, \"blocks\", \"alice\");\n\tawait assertRejects(() => store.addBlock(c, a, \"blocks\", \"alice\"), \"cycle\");\n\n\tclock.tick();\n\tawait store.closeIssue(b, \"alice\", \"completed\");\n\tconst closedBlocked = await store.getIssue(b);\n\tassertExists(closedBlocked);\n\tassertEquals(\n\t\tclosedBlocked.blocked,\n\t\ttrue,\n\t\t\"blocked state must not prevent close\",\n\t);\n\tclock.tick();\n\tawait store.closeIssue(a, \"alice\", \"completed\");\n\tconst unblocked = await store.getIssue(b);\n\tassertExists(unblocked);\n\tassertEquals(unblocked.blocked, false);\n\tconst blockEvents = (\n\t\tawait store.listEvents({ entity: \"issue\", entityId: a })\n\t).filter(\n\t\t(event) =>\n\t\t\t(event.data as { update_target?: string }).update_target === \"blocks\",\n\t);\n\tassertEquals(blockEvents.length, 1, \"one block edge must emit one event\");\n\tassertEquals(blockEvents[0].data, {\n\t\tupdate_target: \"blocks\",\n\t\tfrom: null,\n\t\tto: b,\n\t});\n\tclock.tick();\n\tawait store.addBlock(d, c, \"blocked_by\", \"alice\");\n\tassertEquals(\n\t\t(await store.listEvents({ entity: \"issue\", entityId: d })).at(-1)?.data,\n\t\t{ update_target: \"blocked_by\", from: null, to: c },\n\t);\n\tclock.tick();\n\tconst beforeUnlinkIssue = await store.getIssue(d);\n\tassertExists(beforeUnlinkIssue);\n\tconst beforeUnlink = beforeUnlinkIssue.updated_at;\n\tawait store.removeBlock(d, c, \"blocked_by\", \"alice\");\n\tconst afterUnlink = await store.getIssue(d);\n\tassertExists(afterUnlink);\n\tassert(\n\t\tafterUnlink.updated_at > beforeUnlink,\n\t\t\"block removal must touch the acting issue\",\n\t);\n});\n\nDeno.test(\"comments are editable and deletable, with snapshots, deltas, and parent touches\", async () => {\n\tconst client = createTestSqlite();\n\tconst clock = createClock();\n\tconst store = createIssueStore(client, clock.now);\n\tawait store.initSchema();\n\tconst issueId = await store.createIssue({\n\t\ttitle: \"Comments\",\n\t\tactor: \"alice\",\n\t});\n\tconst initialIssue = await store.getIssue(issueId);\n\tassertExists(initialIssue);\n\tconst initialTouch = initialIssue.updated_at;\n\tclock.tick();\n\tconst commentId = await store.createComment({\n\t\tissueId,\n\t\tbody: \"first\",\n\t\tactor: \"bob\",\n\t});\n\tconst afterComment = await store.getIssue(issueId);\n\tassertExists(afterComment);\n\tassert(\n\t\tafterComment.updated_at > initialTouch,\n\t\t\"comment creation must touch parent\",\n\t);\n\tassertEquals((await store.listComments(issueId))[0].author, \"bob\");\n\tconst createdTouch = afterComment.updated_at;\n\tclock.tick();\n\tawait store.updateComment(commentId, \"edited\", \"carol\");\n\tassertEquals((await store.listComments(issueId))[0].body, \"edited\");\n\tconst afterEdit = await store.getIssue(issueId);\n\tassertExists(afterEdit);\n\tconst editedTouch = afterEdit.updated_at;\n\tassert(\n\t\teditedTouch > createdTouch,\n\t\t\"comment editing must touch the parent issue\",\n\t);\n\tclock.tick();\n\tawait store.deleteComment(commentId, \"dana\");\n\tconst afterDeleteComment = await store.getIssue(issueId);\n\tassertExists(afterDeleteComment);\n\tassert(\n\t\tafterDeleteComment.updated_at > editedTouch,\n\t\t\"comment deletion must touch the parent issue\",\n\t);\n\tassertEquals(await store.listComments(issueId), []);\n\tconst events = await store.listEvents({\n\t\tentity: \"comment\",\n\t\tentityId: commentId,\n\t});\n\tassertEquals(\n\t\tevents.map((event) => event.event_type),\n\t\t[\"comment.created\", \"comment.updated\", \"comment.deleted\"],\n\t);\n\tassertEquals(events[1].data, {\n\t\tupdate_target: \"body\",\n\t\tfrom: \"first\",\n\t\tto: \"edited\",\n\t});\n\tassertEquals((events[2].data as { body: string }).body, \"edited\");\n\n\tclock.tick();\n\tconst cascadedId = await store.createComment({\n\t\tissueId,\n\t\tbody: \"cascade\",\n\t\tactor: \"erin\",\n\t});\n\tconst otherId = await store.createIssue({ title: \"Other\", actor: \"erin\" });\n\tconst bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n\tassertExists(bug);\n\tawait store.addLabel(issueId, bug.id, \"erin\");\n\tawait store.addAssignee(issueId, \"erin\", \"erin\");\n\tawait store.addBlock(issueId, otherId, \"blocks\", \"erin\");\n\tclock.tick();\n\tawait store.deleteIssue(issueId, \"maintainer\");\n\tassertEquals(\n\t\t(await store.listEvents({ entity: \"comment\", entityId: cascadedId })).at(-1)\n\t\t\t?.event_type,\n\t\t\"comment.deleted\",\n\t);\n\tconst deletionDeltas = (\n\t\tawait store.listEvents({\n\t\t\tentity: \"issue\",\n\t\t\tentityId: issueId,\n\t\t})\n\t)\n\t\t.filter((event) => event.event_type === \"issue.updated\")\n\t\t.map((event) => event.data);\n\tfor (const expected of [\n\t\t{ update_target: \"label\", from: \"bug\", to: null },\n\t\t{ update_target: \"assignee\", from: \"erin\", to: null },\n\t\t{ update_target: \"blocks\", from: otherId, to: null },\n\t]) {\n\t\tassert(\n\t\t\tdeletionDeltas.some(\n\t\t\t\t(data) => JSON.stringify(data) === JSON.stringify(expected),\n\t\t\t),\n\t\t\t`issue deletion delta missing: ${JSON.stringify(expected)}`,\n\t\t);\n\t}\n});\n\nDeno.test(\"old-schema migration is lossless and idempotent\", async () => {\n\tconst client = createTestSqlite();\n\tclient.database.exec(`\n\t\tCREATE TABLE issue_tracker_issues (\n\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\ttitle TEXT NOT NULL,\n\t\t\tdescription TEXT DEFAULT '',\n\t\t\tstatus TEXT DEFAULT 'open',\n\t\t\tpriority TEXT DEFAULT 'normal',\n\t\t\tlabels TEXT DEFAULT '[]',\n\t\t\tassignee TEXT,\n\t\t\tcreated_by TEXT NOT NULL,\n\t\t\tcreated_at INTEGER NOT NULL,\n\t\t\tupdated_at INTEGER NOT NULL\n\t\t);\n\t\tCREATE TABLE issue_tracker_comments (\n\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\tissue_id INTEGER NOT NULL,\n\t\t\tbody TEXT NOT NULL,\n\t\t\tauthor TEXT NOT NULL,\n\t\t\tcreated_at INTEGER NOT NULL,\n\t\t\tFOREIGN KEY (issue_id) REFERENCES issue_tracker_issues(id) ON DELETE CASCADE\n\t\t);\n\t\tINSERT INTO issue_tracker_issues VALUES\n\t\t\t(1, 'Working', 'legacy body', 'in_progress', 'urgent', '[\"bug\",\"custom\"]', '@alice', 'owner', 100, 200),\n\t\t\t(2, 'Done', '', 'closed', 'low', '[]', NULL, 'owner', 110, 210);\n\t\tINSERT INTO issue_tracker_comments VALUES (7, 1, 'legacy comment', 'commenter', 150);\n\t`);\n\tconst clock = createClock(1_800_000_000_000);\n\tconst store = createIssueStore(client, clock.now);\n\tawait store.initSchema();\n\n\tconst first = await store.getIssue(1);\n\tassertExists(first);\n\tassertEquals(\n\t\t{\n\t\t\tbody: first.body,\n\t\t\tstatus: first.status,\n\t\t\tstate_reason: first.state_reason,\n\t\t\tlabels: first.labels.map((label) => label.name),\n\t\t\tassignees: first.assignees,\n\t\t\tcreator: first.creator,\n\t\t},\n\t\t{\n\t\t\tbody: \"legacy body\",\n\t\t\tstatus: \"open\",\n\t\t\tstate_reason: null,\n\t\t\tlabels: [\"bug\", \"custom\"],\n\t\t\tassignees: [\"alice\"],\n\t\t\tcreator: \"owner\",\n\t\t},\n\t);\n\tconst second = await store.getIssue(2);\n\tassertExists(second);\n\tassertEquals(second.state_reason, \"completed\");\n\tassertEquals((await store.listComments(1))[0], {\n\t\tid: 7,\n\t\tissue_id: 1,\n\t\tbody: \"legacy comment\",\n\t\tcreated_at: 150,\n\t\tupdated_at: 150,\n\t\tauthor: \"commenter\",\n\t});\n\tassertEquals(\n\t\t(await store.listEvents({ entity: \"issue\", entityId: 1 }))[0].event_type,\n\t\t\"issue.created\",\n\t);\n\tassertEquals(\n\t\t(await store.listEvents({ entity: \"comment\", entityId: 7 }))[0].event_type,\n\t\t\"comment.created\",\n\t);\n\n\tconst eventCount = (await store.listEvents()).length;\n\tconst labels = (await store.listLabels()).map((label) => label.name);\n\tawait store.initSchema();\n\tassertEquals((await store.listEvents()).length, eventCount);\n\tassertEquals(\n\t\t(await store.listLabels()).map((label) => label.name),\n\t\tlabels,\n\t);\n\tconst columns = client.database\n\t\t.prepare(\"PRAGMA table_info(issue_tracker_issues)\")\n\t\t.all()\n\t\t.map((row) => String(row.name));\n\tassertEquals(columns, [\n\t\t\"id\",\n\t\t\"title\",\n\t\t\"body\",\n\t\t\"status\",\n\t\t\"state_reason\",\n\t\t\"created_at\",\n\t\t\"updated_at\",\n\t]);\n\tassertEquals(\n\t\tclient.database\n\t\t\t.prepare(\"SELECT name FROM sqlite_master WHERE name LIKE '%_legacy'\")\n\t\t\t.all(),\n\t\t[],\n\t);\n});\n\nDeno.test(\"old-schema migration resumes after the issue table was already renamed\", async () => {\n\tconst client = createTestSqlite();\n\tclient.database.exec(`\n    CREATE TABLE issue_tracker_issues (\n      id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL,\n      description TEXT, status TEXT, priority TEXT, labels TEXT,\n      assignee TEXT, created_by TEXT, created_at INTEGER, updated_at INTEGER\n    );\n    CREATE TABLE issue_tracker_comments (\n      id INTEGER PRIMARY KEY AUTOINCREMENT, issue_id INTEGER NOT NULL,\n      body TEXT NOT NULL, author TEXT NOT NULL, created_at INTEGER NOT NULL\n    );\n    INSERT INTO issue_tracker_issues VALUES\n      (1, 'Interrupted', 'body', 'open', 'normal', '[]', NULL, 'owner', 1, 2);\n    INSERT INTO issue_tracker_comments VALUES (1, 1, 'still here', 'alice', 2);\n    ALTER TABLE issue_tracker_issues RENAME TO issue_tracker_issues_legacy;\n  `);\n\tconst store = createIssueStore(client);\n\tawait store.initSchema();\n\tassertEquals((await store.getIssue(1))?.body, \"body\");\n\tassertEquals((await store.listComments(1))[0].author, \"alice\");\n\tawait store.initSchema();\n\tassertEquals((await store.listComments(1)).length, 1);\n});\n",[208],"b6a6d68f-7ce6-45cd-8fa6-d0898e377dd9","db.ts","8f4470ca-7b3c-11f1-b527-1607ee4eb77e",179,["D",1783653143400],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const ISSUE_STATUSES = [\"open\", \"closed\"] as const;\nexport const CLOSED_STATE_REASONS = [\n\t\"completed\",\n\t\"not_planned\",\n\t\"duplicate\",\n] as const;\nexport type IssueStatus = (typeof ISSUE_STATUSES)[number];\nexport type ClosedStateReason = (typeof CLOSED_STATE_REASONS)[number];\nexport type StateReason = ClosedStateReason | \"reopened\" | null;\n\nexport interface Label {\n\tid: number;\n\tname: string;\n\tcolor: string;\n\tcreated_at: number;\n\tupdated_at: number;\n}\n\nexport interface IssueReference {\n\tid: number;\n\ttitle: string;\n\tstatus: IssueStatus;\n\tstate_reason: StateReason;\n}\n\nexport interface Issue extends IssueReference {\n\tbody: string;\n\tcreated_at: number;\n\tupdated_at: number;\n\tcreator: string | null;\n\tlabels: Label[];\n\tassignees: string[];\n\tblockers: IssueReference[];\n\tblocks: IssueReference[];\n\tblocked: boolean;\n}\n\nexport interface Comment {\n\tid: number;\n\tissue_id: number;\n\tbody: string;\n\tcreated_at: number;\n\tupdated_at: number;\n\tauthor: string | null;\n}\n\nexport type EventType =\n\t| \"issue.created\"\n\t| \"issue.updated\"\n\t| \"issue.deleted\"\n\t| \"comment.created\"\n\t| \"comment.updated\"\n\t| \"comment.deleted\"\n\t| \"label.created\"\n\t| \"label.updated\"\n\t| \"label.deleted\";\n\nexport interface TrackerEvent {\n\tid: number;\n\tevent_type: EventType;\n\tentity_id: number;\n\tactor: string;\n\tdata: unknown;\n\tevent_timestamp: number;\n}\n\ntype SqlValue = null | string | number | bigint | boolean | Uint8Array;\ntype Statement = string | { sql: string; args?: SqlValue[] };\nexport interface SqliteClient {\n\texecute(statement: Statement): Promise<{\n\t\trows: Record<string, unknown>[];\n\t\trowsAffected: number;\n\t\tlastInsertRowid?: bigint;\n\t}>;\n\tbatch(\n\t\tstatements: Statement[],\n\t\tmode?: \"write\" | \"read\" | \"deferred\",\n\t): Promise<\n\t\tArray<{\n\t\t\trows: Record<string, unknown>[];\n\t\t\trowsAffected: number;\n\t\t\tlastInsertRowid?: bigint;\n\t\t}>\n\t>;\n}\n\nconst TABLES = {\n\tissues: \"issue_tracker_issues\",\n\tcomments: \"issue_tracker_comments\",\n\tlabels: \"issue_tracker_labels\",\n\tissueLabels: \"issue_tracker_issue_labels\",\n\tassignees: \"issue_tracker_issue_assignees\",\n\tblocks: \"issue_tracker_issue_blocks\",\n\tevents: \"issue_tracker_events\",\n} as const;\n\nexport const DEFAULT_LABELS = [\n\t{ name: \"bug\", color: \"d73a4a\" },\n\t{ name: \"enhancement\", color: \"a2eeef\" },\n\t{ name: \"documentation\", color: \"0075ca\" },\n\t{ name: \"question\", color: \"d876e3\" },\n\t{ name: \"duplicate\", color: \"cfd3d7\" },\n] as const;\n\nfunction number(value: unknown): number {\n\treturn Number(value);\n}\n\nfunction parseJson(value: unknown): unknown {\n\tif (typeof value !== \"string\") return value;\n\ttry {\n\t\treturn JSON.parse(value);\n\t} catch {\n\t\treturn null;\n\t}\n}\n\nfunction normalizeColor(color: string): string {\n\tconst normalized = color.replace(/^#/, \"\").toLowerCase();\n\tif (!/^[0-9a-f]{6}$/.test(normalized)) {\n\t\tthrow new Error(\"Label color must be exactly six hexadecimal characters.\");\n\t}\n\treturn normalized;\n}\n\nfunction labelSnapshot(label: Label) {\n\treturn {\n\t\tid: label.id,\n\t\tname: label.name,\n\t\tcolor: label.color,\n\t\tcreated_at: label.created_at,\n\t\tupdated_at: label.updated_at,\n\t};\n}\n\nfunction commentSnapshot(comment: Omit<Comment, \"author\">) {\n\treturn {\n\t\tid: comment.id,\n\t\tissue_id: comment.issue_id,\n\t\tbody: comment.body,\n\t\tcreated_at: comment.created_at,\n\t\tupdated_at: comment.updated_at,\n\t};\n}\n\nexport function createIssueStore(\n\tclient: SqliteClient,\n\tnow: () => number = Date.now,\n) {\n\tasync function tableExists(name: string): Promise<boolean> {\n\t\tconst result = await client.execute({\n\t\t\tsql: \"SELECT 1 AS found FROM sqlite_master WHERE type = 'table' AND name = ?\",\n\t\t\targs: [name],\n\t\t});\n\t\treturn result.rows.length > 0;\n\t}\n\n\tasync function tableColumns(name: string): Promise<string[]> {\n\t\tif (!(await tableExists(name))) return [];\n\t\tconst result = await client.execute(`PRAGMA table_info(${name})`);\n\t\treturn result.rows.map((row) => String(row.name));\n\t}\n\n\tasync function createFinalTables(): Promise<void> {\n\t\tconst labelsAreNew = !(await tableExists(TABLES.labels));\n\t\tconst statements: Statement[] = [\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.issues} (\n\t\t\t\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\t\t\t\ttitle TEXT NOT NULL,\n\t\t\t\t\t\tbody TEXT NOT NULL DEFAULT '',\n\t\t\t\t\t\tstatus TEXT NOT NULL DEFAULT 'open' CHECK (status IN ('open', 'closed')),\n\t\t\t\t\t\tstate_reason TEXT CHECK (\n\t\t\t\t\t\t\t(status = 'open' AND (state_reason IS NULL OR state_reason = 'reopened')) OR\n\t\t\t\t\t\t\t(status = 'closed' AND state_reason IN ('completed', 'not_planned', 'duplicate'))\n\t\t\t\t\t\t),\n\t\t\t\t\t\tcreated_at INTEGER NOT NULL,\n\t\t\t\t\t\tupdated_at INTEGER NOT NULL\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.comments} (\n\t\t\t\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\t\t\t\tissue_id INTEGER NOT NULL,\n\t\t\t\t\t\tbody TEXT NOT NULL,\n\t\t\t\t\t\tcreated_at INTEGER NOT NULL,\n\t\t\t\t\t\tupdated_at INTEGER NOT NULL,\n\t\t\t\t\t\tFOREIGN KEY (issue_id) REFERENCES ${TABLES.issues}(id) ON DELETE CASCADE\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.labels} (\n\t\t\t\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\t\t\t\tname TEXT NOT NULL UNIQUE,\n\t\t\t\t\t\tcolor TEXT NOT NULL CHECK (length(color) = 6 AND color NOT GLOB '*[^0-9A-Fa-f]*'),\n\t\t\t\t\t\tcreated_at INTEGER NOT NULL,\n\t\t\t\t\t\tupdated_at INTEGER NOT NULL\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.issueLabels} (\n\t\t\t\t\t\tissue_id INTEGER NOT NULL,\n\t\t\t\t\t\tlabel_id INTEGER NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY (issue_id, label_id),\n\t\t\t\t\t\tFOREIGN KEY (issue_id) REFERENCES ${TABLES.issues}(id) ON DELETE CASCADE,\n\t\t\t\t\t\tFOREIGN KEY (label_id) REFERENCES ${TABLES.labels}(id) ON DELETE CASCADE\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.assignees} (\n\t\t\t\t\t\tissue_id INTEGER NOT NULL,\n\t\t\t\t\t\tuser_handle TEXT NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY (issue_id, user_handle),\n\t\t\t\t\t\tFOREIGN KEY (issue_id) REFERENCES ${TABLES.issues}(id) ON DELETE CASCADE\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.blocks} (\n\t\t\t\t\t\tblocker_id INTEGER NOT NULL,\n\t\t\t\t\t\tblocked_id INTEGER NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY (blocker_id, blocked_id),\n\t\t\t\t\t\tCHECK (blocker_id != blocked_id),\n\t\t\t\t\t\tFOREIGN KEY (blocker_id) REFERENCES ${TABLES.issues}(id) ON DELETE CASCADE,\n\t\t\t\t\t\tFOREIGN KEY (blocked_id) REFERENCES ${TABLES.issues}(id) ON DELETE CASCADE\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TABLE IF NOT EXISTS ${TABLES.events} (\n\t\t\t\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\t\t\t\tevent_type TEXT NOT NULL CHECK (event_type IN (\n\t\t\t\t\t\t\t'issue.created', 'issue.updated', 'issue.deleted',\n\t\t\t\t\t\t\t'comment.created', 'comment.updated', 'comment.deleted',\n\t\t\t\t\t\t\t'label.created', 'label.updated', 'label.deleted'\n\t\t\t\t\t\t)),\n\t\t\t\t\t\tentity_id INTEGER NOT NULL,\n\t\t\t\t\t\tactor TEXT NOT NULL,\n\t\t\t\t\t\tdata TEXT NOT NULL CHECK (json_valid(data)),\n\t\t\t\t\t\tevent_timestamp INTEGER NOT NULL\n\t\t\t\t\t)`,\n\t\t\t},\n\t\t\t`CREATE INDEX IF NOT EXISTS idx_${TABLES.issues}_status ON ${TABLES.issues}(status)`,\n\t\t\t`CREATE INDEX IF NOT EXISTS idx_${TABLES.comments}_issue ON ${TABLES.comments}(issue_id)`,\n\t\t\t`CREATE INDEX IF NOT EXISTS idx_${TABLES.assignees}_user ON ${TABLES.assignees}(user_handle)`,\n\t\t\t`CREATE INDEX IF NOT EXISTS idx_${TABLES.blocks}_blocked ON ${TABLES.blocks}(blocked_id)`,\n\t\t\t`CREATE INDEX IF NOT EXISTS idx_${TABLES.events}_entity ON ${TABLES.events}(event_type, entity_id, id)`,\n\t\t\t{\n\t\t\t\tsql: `CREATE TRIGGER IF NOT EXISTS issue_tracker_blocks_no_cycles\n            BEFORE INSERT ON ${TABLES.blocks}\n            BEGIN\n              SELECT CASE WHEN NEW.blocker_id = NEW.blocked_id OR EXISTS (\n                WITH RECURSIVE reachable(id) AS (\n                  SELECT blocked_id FROM ${TABLES.blocks} WHERE blocker_id = NEW.blocked_id\n                  UNION\n                  SELECT edge.blocked_id FROM ${TABLES.blocks} edge\n                  JOIN reachable ON edge.blocker_id = reachable.id\n                ) SELECT 1 FROM reachable WHERE id = NEW.blocker_id\n              ) THEN RAISE(ABORT, 'blocking relationship would create a cycle') END;\n            END`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TRIGGER IF NOT EXISTS issue_tracker_events_no_update\n\t\t\t\t\t\tBEFORE UPDATE ON ${TABLES.events}\n\t\t\t\t\t\tBEGIN SELECT RAISE(ABORT, 'issue tracker events are append-only'); END`,\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `CREATE TRIGGER IF NOT EXISTS issue_tracker_events_no_delete\n\t\t\t\t\t\tBEFORE DELETE ON ${TABLES.events}\n\t\t\t\t\t\tBEGIN SELECT RAISE(ABORT, 'issue tracker events are append-only'); END`,\n\t\t\t},\n\t\t];\n\t\tif (labelsAreNew) {\n\t\t\tconst timestamp = now();\n\t\t\tfor (const label of DEFAULT_LABELS) {\n\t\t\t\tstatements.push(\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT OR IGNORE INTO ${TABLES.labels} (name, color, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n\t\t\t\t\t\targs: [label.name, label.color, timestamp, timestamp],\n\t\t\t\t\t},\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t              SELECT 'label.created', label.id, 'system', json_object(\n\t                'id', label.id, 'name', label.name, 'color', label.color,\n\t                'created_at', label.created_at, 'updated_at', label.updated_at\n\t              ), ? FROM ${TABLES.labels} label\n\t              WHERE label.name = ? AND NOT EXISTS (\n\t                SELECT 1 FROM ${TABLES.events}\n\t                WHERE event_type = 'label.created' AND entity_id = label.id\n\t              )`,\n\t\t\t\t\t\targs: [timestamp, label.name],\n\t\t\t\t\t},\n\t\t\t\t);\n\t\t\t}\n\t\t}\n\t\tawait client.batch(statements, \"write\");\n\t}\n\n\tasync function emitCreatedLabel(\n\t\tname: string,\n\t\tcolor: string,\n\t\tactor: string,\n\t\ttimestamp: number,\n\t): Promise<number> {\n\t\tconst results = await client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.labels} (name, color, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n\t\t\t\t\targs: [name, color, timestamp, timestamp],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\tSELECT 'label.created', id, ?, json_object(\n\t\t\t\t\t\t\t'id', id, 'name', name, 'color', color,\n\t\t\t\t\t\t\t'created_at', created_at, 'updated_at', updated_at\n\t\t\t\t\t\t), ? FROM ${TABLES.labels} WHERE id = last_insert_rowid()`,\n\t\t\t\t\targs: [actor, timestamp],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t\treturn number(results[0].lastInsertRowid);\n\t}\n\n\tasync function migrateLegacyRows(): Promise<void> {\n\t\tconst legacyIssues = \"issue_tracker_issues_legacy\";\n\t\tif (!(await tableExists(legacyIssues))) return;\n\t\tconst issueRows = (await client.execute(`SELECT * FROM ${legacyIssues}`))\n\t\t\t.rows;\n\t\tconst legacyComments = \"issue_tracker_comments_legacy\";\n\t\tconst commentRows = (await tableExists(legacyComments))\n\t\t\t? (await client.execute(`SELECT * FROM ${legacyComments}`)).rows\n\t\t\t: [];\n\t\tconst timestamp = now();\n\t\tconst statements: Statement[] = [];\n\n\t\tfor (const row of issueRows) {\n\t\t\tconst id = number(row.id);\n\t\t\tconst status: IssueStatus = row.status === \"closed\" ? \"closed\" : \"open\";\n\t\t\tconst stateReason: StateReason = status === \"closed\" ? \"completed\" : null;\n\t\t\tconst createdAt = number(row.created_at);\n\t\t\tconst updatedAt = number(row.updated_at);\n\t\t\tconst snapshot = {\n\t\t\t\tid,\n\t\t\t\ttitle: String(row.title),\n\t\t\t\tbody: String(row.description ?? \"\"),\n\t\t\t\tstatus,\n\t\t\t\tstate_reason: stateReason,\n\t\t\t\tcreated_at: createdAt,\n\t\t\t\tupdated_at: updatedAt,\n\t\t\t};\n\t\t\tconst actor = String(row.created_by ?? \"migration\");\n\t\t\tstatements.push(\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT OR IGNORE INTO ${TABLES.issues}\n\t\t\t\t\t\t(id, title, body, status, state_reason, created_at, updated_at)\n\t\t\t\t\t\tVALUES (?, ?, ?, ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tid,\n\t\t\t\t\t\tsnapshot.title,\n\t\t\t\t\t\tsnapshot.body,\n\t\t\t\t\t\tstatus,\n\t\t\t\t\t\tstateReason,\n\t\t\t\t\t\tcreatedAt,\n\t\t\t\t\t\tupdatedAt,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\tSELECT 'issue.created', ?, ?, ?, ?\n\t\t\t\t\t\tWHERE NOT EXISTS (SELECT 1 FROM ${TABLES.events} WHERE event_type = 'issue.created' AND entity_id = ?)`,\n\t\t\t\t\targs: [id, actor, JSON.stringify(snapshot), createdAt, id],\n\t\t\t\t},\n\t\t\t);\n\n\t\t\tlet legacyLabels: string[] = [];\n\t\t\ttry {\n\t\t\t\tconst parsed = JSON.parse(String(row.labels ?? \"[]\"));\n\t\t\t\tif (Array.isArray(parsed)) {\n\t\t\t\t\tlegacyLabels = parsed.filter((item) => typeof item === \"string\");\n\t\t\t\t}\n\t\t\t} catch {\n\t\t\t\tlegacyLabels = [];\n\t\t\t}\n\t\t\tfor (const name of legacyLabels) {\n\t\t\t\tconst color =\n\t\t\t\t\tDEFAULT_LABELS.find((label) => label.name === name)?.color ??\n\t\t\t\t\t\"8b949e\";\n\t\t\t\tstatements.push(\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT OR IGNORE INTO ${TABLES.labels} (name, color, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n\t\t\t\t\t\targs: [name, color, timestamp, timestamp],\n\t\t\t\t\t},\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\t\tSELECT 'label.created', id, 'migration', json_object(\n\t\t\t\t\t\t\t\t'id', id, 'name', name, 'color', color,\n\t\t\t\t\t\t\t\t'created_at', created_at, 'updated_at', updated_at\n\t\t\t\t\t\t\t), ? FROM ${TABLES.labels} label\n\t\t\t\t\t\t\tWHERE name = ? AND NOT EXISTS (\n\t\t\t\t\t\t\t\tSELECT 1 FROM ${TABLES.events} WHERE event_type = 'label.created' AND entity_id = label.id\n\t\t\t\t\t\t\t)`,\n\t\t\t\t\t\targs: [timestamp, name],\n\t\t\t\t\t},\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT OR IGNORE INTO ${TABLES.issueLabels} (issue_id, label_id)\n\t\t\t\t\t\t\tSELECT ?, id FROM ${TABLES.labels} WHERE name = ?`,\n\t\t\t\t\t\targs: [id, name],\n\t\t\t\t\t},\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\t\tSELECT 'issue.updated', ?, ?, ?, ? WHERE NOT EXISTS (\n\t\t\t\t\t\t\t\tSELECT 1 FROM ${TABLES.events} WHERE event_type = 'issue.updated' AND entity_id = ? AND data = ?\n\t\t\t\t\t\t\t)`,\n\t\t\t\t\t\targs: [\n\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\tactor,\n\t\t\t\t\t\t\tJSON.stringify({ update_target: \"label\", from: null, to: name }),\n\t\t\t\t\t\t\tupdatedAt,\n\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\tJSON.stringify({ update_target: \"label\", from: null, to: name }),\n\t\t\t\t\t\t],\n\t\t\t\t\t},\n\t\t\t\t);\n\t\t\t}\n\n\t\t\tconst assignee =\n\t\t\t\ttypeof row.assignee === \"string\"\n\t\t\t\t\t? row.assignee.trim().replace(/^@/, \"\")\n\t\t\t\t\t: \"\";\n\t\t\tif (assignee) {\n\t\t\t\tconst data = JSON.stringify({\n\t\t\t\t\tupdate_target: \"assignee\",\n\t\t\t\t\tfrom: null,\n\t\t\t\t\tto: assignee,\n\t\t\t\t});\n\t\t\t\tstatements.push(\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT OR IGNORE INTO ${TABLES.assignees} (issue_id, user_handle) VALUES (?, ?)`,\n\t\t\t\t\t\targs: [id, assignee],\n\t\t\t\t\t},\n\t\t\t\t\t{\n\t\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\t\tSELECT 'issue.updated', ?, ?, ?, ? WHERE NOT EXISTS (\n\t\t\t\t\t\t\t\tSELECT 1 FROM ${TABLES.events} WHERE event_type = 'issue.updated' AND entity_id = ? AND data = ?\n\t\t\t\t\t\t\t)`,\n\t\t\t\t\t\targs: [id, actor, data, updatedAt, id, data],\n\t\t\t\t\t},\n\t\t\t\t);\n\t\t\t}\n\t\t}\n\n\t\tfor (const row of commentRows) {\n\t\t\tconst id = number(row.id);\n\t\t\tconst issueId = number(row.issue_id);\n\t\t\tconst createdAt = number(row.created_at);\n\t\t\tconst snapshot = {\n\t\t\t\tid,\n\t\t\t\tissue_id: issueId,\n\t\t\t\tbody: String(row.body),\n\t\t\t\tcreated_at: createdAt,\n\t\t\t\tupdated_at: createdAt,\n\t\t\t};\n\t\t\tstatements.push(\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT OR IGNORE INTO ${TABLES.comments}\n\t\t\t\t\t\t(id, issue_id, body, created_at, updated_at) VALUES (?, ?, ?, ?, ?)`,\n\t\t\t\t\targs: [id, issueId, snapshot.body, createdAt, createdAt],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\tSELECT 'comment.created', ?, ?, ?, ? WHERE NOT EXISTS (\n\t\t\t\t\t\t\tSELECT 1 FROM ${TABLES.events} WHERE event_type = 'comment.created' AND entity_id = ?\n\t\t\t\t\t\t)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tid,\n\t\t\t\t\t\tString(row.author ?? \"migration\"),\n\t\t\t\t\t\tJSON.stringify(snapshot),\n\t\t\t\t\t\tcreatedAt,\n\t\t\t\t\t\tid,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t);\n\t\t}\n\t\tstatements.push(\n\t\t\t`DROP TABLE IF EXISTS ${legacyComments}`,\n\t\t\t`DROP TABLE ${legacyIssues}`,\n\t\t);\n\t\tawait client.batch(statements, \"write\");\n\t}\n\n\tasync function initSchema(): Promise<void> {\n\t\tawait client.execute(\"PRAGMA foreign_keys = ON\");\n\t\tif (!(await tableExists(TABLES.issues)) && (await tableExists(\"issues\"))) {\n\t\t\tawait client.execute(`ALTER TABLE issues RENAME TO ${TABLES.issues}`);\n\t\t}\n\t\tif (\n\t\t\t!(await tableExists(TABLES.comments)) &&\n\t\t\t(await tableExists(\"comments\"))\n\t\t) {\n\t\t\tawait client.execute(`ALTER TABLE comments RENAME TO ${TABLES.comments}`);\n\t\t}\n\n\t\tconst columns = await tableColumns(TABLES.issues);\n\t\tif (\n\t\t\tcolumns.includes(\"description\") &&\n\t\t\t!(await tableExists(\"issue_tracker_issues_legacy\"))\n\t\t) {\n\t\t\tawait client.execute(\n\t\t\t\t`ALTER TABLE ${TABLES.issues} RENAME TO issue_tracker_issues_legacy`,\n\t\t\t);\n\t\t\tif (await tableExists(TABLES.comments)) {\n\t\t\t\tawait client.execute(\n\t\t\t\t\t`ALTER TABLE ${TABLES.comments} RENAME TO issue_tracker_comments_legacy`,\n\t\t\t\t);\n\t\t\t}\n\t\t}\n\n\t\tif (\n\t\t\t(await tableExists(\"issue_tracker_issues_legacy\")) &&\n\t\t\t!(await tableExists(\"issue_tracker_comments_legacy\")) &&\n\t\t\t(await tableColumns(TABLES.comments)).includes(\"author\")\n\t\t) {\n\t\t\tawait client.execute(\n\t\t\t\t`ALTER TABLE ${TABLES.comments} RENAME TO issue_tracker_comments_legacy`,\n\t\t\t);\n\t\t}\n\n\t\tawait createFinalTables();\n\t\tawait migrateLegacyRows();\n\t}\n\n\tasync function getBaseIssue(id: number) {\n\t\tconst result = await client.execute({\n\t\t\tsql: `SELECT * FROM ${TABLES.issues} WHERE id = ?`,\n\t\t\targs: [id],\n\t\t});\n\t\tconst row = result.rows[0];\n\t\tif (!row) return null;\n\t\treturn {\n\t\t\tid: number(row.id),\n\t\t\ttitle: String(row.title),\n\t\t\tbody: String(row.body),\n\t\t\tstatus: row.status as IssueStatus,\n\t\t\tstate_reason: (row.state_reason ?? null) as StateReason,\n\t\t\tcreated_at: number(row.created_at),\n\t\t\tupdated_at: number(row.updated_at),\n\t\t};\n\t}\n\n\tasync function getIssue(id: number): Promise<Issue | null> {\n\t\tconst issue = await getBaseIssue(id);\n\t\tif (!issue) return null;\n\t\tconst [labelRows, assigneeRows, blockerRows, blocksRows, creatorRows] =\n\t\t\tawait Promise.all([\n\t\t\t\tclient.execute({\n\t\t\t\t\tsql: `SELECT label.* FROM ${TABLES.labels} label\n\t\t\t\t\tJOIN ${TABLES.issueLabels} link ON link.label_id = label.id\n\t\t\t\t\tWHERE link.issue_id = ? ORDER BY label.name`,\n\t\t\t\t\targs: [id],\n\t\t\t\t}),\n\t\t\t\tclient.execute({\n\t\t\t\t\tsql: `SELECT user_handle FROM ${TABLES.assignees} WHERE issue_id = ? ORDER BY user_handle`,\n\t\t\t\t\targs: [id],\n\t\t\t\t}),\n\t\t\t\tclient.execute({\n\t\t\t\t\tsql: `SELECT issue.id, issue.title, issue.status, issue.state_reason\n\t\t\t\t\tFROM ${TABLES.blocks} edge JOIN ${TABLES.issues} issue ON issue.id = edge.blocker_id\n\t\t\t\t\tWHERE edge.blocked_id = ? ORDER BY issue.id`,\n\t\t\t\t\targs: [id],\n\t\t\t\t}),\n\t\t\t\tclient.execute({\n\t\t\t\t\tsql: `SELECT issue.id, issue.title, issue.status, issue.state_reason\n\t\t\t\t\tFROM ${TABLES.blocks} edge JOIN ${TABLES.issues} issue ON issue.id = edge.blocked_id\n\t\t\t\t\tWHERE edge.blocker_id = ? ORDER BY issue.id`,\n\t\t\t\t\targs: [id],\n\t\t\t\t}),\n\t\t\t\tclient.execute({\n\t\t\t\t\tsql: `SELECT actor FROM ${TABLES.events}\n\t\t\t\t\tWHERE event_type = 'issue.created' AND entity_id = ? ORDER BY id LIMIT 1`,\n\t\t\t\t\targs: [id],\n\t\t\t\t}),\n\t\t\t]);\n\t\tconst labels: Label[] = labelRows.rows.map((row) => ({\n\t\t\tid: number(row.id),\n\t\t\tname: String(row.name),\n\t\t\tcolor: String(row.color),\n\t\t\tcreated_at: number(row.created_at),\n\t\t\tupdated_at: number(row.updated_at),\n\t\t}));\n\t\tconst toReference = (row: Record<string, unknown>): IssueReference => ({\n\t\t\tid: number(row.id),\n\t\t\ttitle: String(row.title),\n\t\t\tstatus: row.status as IssueStatus,\n\t\t\tstate_reason: (row.state_reason ?? null) as StateReason,\n\t\t});\n\t\tconst blockers = blockerRows.rows.map(toReference);\n\t\treturn {\n\t\t\t...issue,\n\t\t\tcreator: creatorRows.rows[0] ? String(creatorRows.rows[0].actor) : null,\n\t\t\tlabels,\n\t\t\tassignees: assigneeRows.rows.map((row) => String(row.user_handle)),\n\t\t\tblockers,\n\t\t\tblocks: blocksRows.rows.map(toReference),\n\t\t\tblocked: blockers.some((blocker) => blocker.status === \"open\"),\n\t\t};\n\t}\n\n\tasync function listIssues(\n\t\topts: {\n\t\t\tstatus?: IssueStatus;\n\t\t\tlabel?: string;\n\t\t\tassignee?: string;\n\t\t\tsearch?: string;\n\t\t} = {},\n\t): Promise<Issue[]> {\n\t\tlet sql = `SELECT issue.id FROM ${TABLES.issues} issue`;\n\t\tconst conditions: string[] = [];\n\t\tconst args: SqlValue[] = [];\n\t\tif (opts.status) {\n\t\t\tconditions.push(\"issue.status = ?\");\n\t\t\targs.push(opts.status);\n\t\t}\n\t\tif (opts.label) {\n\t\t\tconditions.push(\n\t\t\t\t`EXISTS (SELECT 1 FROM ${TABLES.issueLabels} il JOIN ${TABLES.labels} l ON l.id = il.label_id WHERE il.issue_id = issue.id AND l.name = ?)`,\n\t\t\t);\n\t\t\targs.push(opts.label);\n\t\t}\n\t\tif (opts.assignee) {\n\t\t\tconditions.push(\n\t\t\t\t`EXISTS (SELECT 1 FROM ${TABLES.assignees} ia WHERE ia.issue_id = issue.id AND ia.user_handle = ?)`,\n\t\t\t);\n\t\t\targs.push(opts.assignee);\n\t\t}\n\t\tif (opts.search) {\n\t\t\tconditions.push(\"(issue.title LIKE ? OR issue.body LIKE ?)\");\n\t\t\targs.push(`%${opts.search}%`, `%${opts.search}%`);\n\t\t}\n\t\tif (conditions.length) sql += ` WHERE ${conditions.join(\" AND \")}`;\n\t\tsql += \" ORDER BY issue.updated_at DESC, issue.id DESC\";\n\t\tconst result = await client.execute({ sql, args });\n\t\treturn (\n\t\t\tawait Promise.all(result.rows.map((row) => getIssue(number(row.id))))\n\t\t).filter((issue): issue is Issue => issue !== null);\n\t}\n\n\tasync function createIssue(data: {\n\t\ttitle: string;\n\t\tbody?: string;\n\t\tactor: string;\n\t}): Promise<number> {\n\t\tconst timestamp = now();\n\t\tconst results = await client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.issues} (title, body, status, state_reason, created_at, updated_at)\n\t\t\t\t\t\tVALUES (?, ?, 'open', NULL, ?, ?)`,\n\t\t\t\t\targs: [data.title, data.body ?? \"\", timestamp, timestamp],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\tSELECT 'issue.created', id, ?, json_object(\n\t\t\t\t\t\t\t'id', id, 'title', title, 'body', body, 'status', status,\n\t\t\t\t\t\t\t'state_reason', state_reason, 'created_at', created_at, 'updated_at', updated_at\n\t\t\t\t\t\t), ? FROM ${TABLES.issues} WHERE id = last_insert_rowid()`,\n\t\t\t\t\targs: [data.actor, timestamp],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t\treturn number(results[0].lastInsertRowid);\n\t}\n\n\tasync function updateIssue(\n\t\tid: number,\n\t\tdata: Partial<{ title: string; body: string }>,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst existing = await getBaseIssue(id);\n\t\tif (!existing) throw new Error(`Issue #${id} not found.`);\n\t\tconst changes = ([\"title\", \"body\"] as const)\n\t\t\t.filter(\n\t\t\t\t(field) => data[field] !== undefined && data[field] !== existing[field],\n\t\t\t)\n\t\t\t.map((field) => ({\n\t\t\t\tfield,\n\t\t\t\tfrom: existing[field],\n\t\t\t\tto: data[field] as string,\n\t\t\t}));\n\t\tif (!changes.length) return;\n\t\tconst timestamp = now();\n\t\tconst statements: Statement[] = [\n\t\t\t{\n\t\t\t\tsql: `UPDATE ${TABLES.issues} SET ${changes\n\t\t\t\t\t.map((change) => `${change.field} = ?`)\n\t\t\t\t\t.join(\", \")}, updated_at = ? WHERE id = ?`,\n\t\t\t\targs: [...changes.map((change) => change.to), timestamp, id],\n\t\t\t},\n\t\t\t...changes.map(\n\t\t\t\t(change): Statement => ({\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tid,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: change.field,\n\t\t\t\t\t\t\tfrom: change.from,\n\t\t\t\t\t\t\tto: change.to,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t}),\n\t\t\t),\n\t\t];\n\t\tawait client.batch(statements, \"write\");\n\t}\n\n\tasync function setLifecycle(\n\t\tid: number,\n\t\tactor: string,\n\t\tstatus: IssueStatus,\n\t\tstateReason: StateReason,\n\t): Promise<void> {\n\t\tconst existing = await getBaseIssue(id);\n\t\tif (!existing) throw new Error(`Issue #${id} not found.`);\n\t\tif (existing.status === status && existing.state_reason === stateReason) {\n\t\t\treturn;\n\t\t}\n\t\tconst timestamp = now();\n\t\tconst statements: Statement[] = [\n\t\t\t{\n\t\t\t\tsql: `UPDATE ${TABLES.issues} SET status = ?, state_reason = ?, updated_at = ? WHERE id = ?`,\n\t\t\t\targs: [status, stateReason, timestamp, id],\n\t\t\t},\n\t\t];\n\t\tif (existing.status !== status) {\n\t\t\tstatements.push({\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\targs: [\n\t\t\t\t\tid,\n\t\t\t\t\tactor,\n\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\tupdate_target: \"status\",\n\t\t\t\t\t\tfrom: existing.status,\n\t\t\t\t\t\tto: status,\n\t\t\t\t\t}),\n\t\t\t\t\ttimestamp,\n\t\t\t\t],\n\t\t\t});\n\t\t}\n\t\tif (existing.state_reason !== stateReason) {\n\t\t\tstatements.push({\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\targs: [\n\t\t\t\t\tid,\n\t\t\t\t\tactor,\n\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\tupdate_target: \"state_reason\",\n\t\t\t\t\t\tfrom: existing.state_reason,\n\t\t\t\t\t\tto: stateReason,\n\t\t\t\t\t}),\n\t\t\t\t\ttimestamp,\n\t\t\t\t],\n\t\t\t});\n\t\t}\n\t\tawait client.batch(statements, \"write\");\n\t}\n\n\tasync function closeIssue(\n\t\tid: number,\n\t\tactor: string,\n\t\treason: ClosedStateReason = \"completed\",\n\t) {\n\t\tif (!CLOSED_STATE_REASONS.includes(reason)) {\n\t\t\tthrow new Error(\"Invalid close reason.\");\n\t\t}\n\t\tawait setLifecycle(id, actor, \"closed\", reason);\n\t}\n\n\tasync function reopenIssue(id: number, actor: string) {\n\t\tawait setLifecycle(id, actor, \"open\", \"reopened\");\n\t}\n\n\tasync function deleteIssue(id: number, actor: string): Promise<void> {\n\t\tconst timestamp = now();\n\t\tconst statements: Statement[] = [\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'issue.updated', ?, ?, json_object(\n            'update_target', 'label', 'from', label.name, 'to', NULL\n          ), ? FROM ${TABLES.issueLabels} link\n          JOIN ${TABLES.labels} label ON label.id = link.label_id\n          WHERE link.issue_id = ?`,\n\t\t\t\targs: [id, actor, timestamp, id],\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'issue.updated', ?, ?, json_object(\n            'update_target', 'assignee', 'from', user_handle, 'to', NULL\n          ), ? FROM ${TABLES.assignees} WHERE issue_id = ?`,\n\t\t\t\targs: [id, actor, timestamp, id],\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'issue.updated', ?, ?, json_object(\n            'update_target', 'blocks', 'from', blocked_id, 'to', NULL\n          ), ? FROM ${TABLES.blocks} WHERE blocker_id = ?`,\n\t\t\t\targs: [id, actor, timestamp, id],\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'issue.updated', ?, ?, json_object(\n            'update_target', 'blocked_by', 'from', blocker_id, 'to', NULL\n          ), ? FROM ${TABLES.blocks} WHERE blocked_id = ?`,\n\t\t\t\targs: [id, actor, timestamp, id],\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'comment.deleted', id, ?, json_object(\n            'id', id, 'issue_id', issue_id, 'body', body,\n            'created_at', created_at, 'updated_at', updated_at\n          ), ? FROM ${TABLES.comments} WHERE issue_id = ?`,\n\t\t\t\targs: [actor, timestamp, id],\n\t\t\t},\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'issue.deleted', id, ?, json_object(\n            'id', id, 'title', title, 'body', body, 'status', status,\n            'state_reason', state_reason, 'created_at', created_at, 'updated_at', updated_at\n          ), ? FROM ${TABLES.issues} WHERE id = ?`,\n\t\t\t\targs: [actor, timestamp, id],\n\t\t\t},\n\t\t\t{ sql: `DELETE FROM ${TABLES.issues} WHERE id = ?`, args: [id] },\n\t\t];\n\t\tawait client.batch(statements, \"write\");\n\t}\n\n\tasync function listLabels(): Promise<Label[]> {\n\t\tconst result = await client.execute(\n\t\t\t`SELECT * FROM ${TABLES.labels} ORDER BY name`,\n\t\t);\n\t\treturn result.rows.map((row) => ({\n\t\t\tid: number(row.id),\n\t\t\tname: String(row.name),\n\t\t\tcolor: String(row.color),\n\t\t\tcreated_at: number(row.created_at),\n\t\t\tupdated_at: number(row.updated_at),\n\t\t}));\n\t}\n\n\tasync function getLabel(id: number): Promise<Label | null> {\n\t\tconst result = await client.execute({\n\t\t\tsql: `SELECT * FROM ${TABLES.labels} WHERE id = ?`,\n\t\t\targs: [id],\n\t\t});\n\t\tconst row = result.rows[0];\n\t\treturn row\n\t\t\t? {\n\t\t\t\t\tid: number(row.id),\n\t\t\t\t\tname: String(row.name),\n\t\t\t\t\tcolor: String(row.color),\n\t\t\t\t\tcreated_at: number(row.created_at),\n\t\t\t\t\tupdated_at: number(row.updated_at),\n\t\t\t\t}\n\t\t\t: null;\n\t}\n\n\tasync function createLabel(data: {\n\t\tname: string;\n\t\tcolor: string;\n\t\tactor: string;\n\t}): Promise<number> {\n\t\treturn await emitCreatedLabel(\n\t\t\tdata.name,\n\t\t\tnormalizeColor(data.color),\n\t\t\tdata.actor,\n\t\t\tnow(),\n\t\t);\n\t}\n\n\tasync function updateLabel(\n\t\tid: number,\n\t\tdata: Partial<{ name: string; color: string }>,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst existing = await getLabel(id);\n\t\tif (!existing) throw new Error(`Label #${id} not found.`);\n\t\tif (data.color !== undefined) data.color = normalizeColor(data.color);\n\t\tconst changes = ([\"name\", \"color\"] as const)\n\t\t\t.filter(\n\t\t\t\t(field) => data[field] !== undefined && data[field] !== existing[field],\n\t\t\t)\n\t\t\t.map((field) => ({\n\t\t\t\tfield,\n\t\t\t\tfrom: existing[field],\n\t\t\t\tto: data[field] as string,\n\t\t\t}));\n\t\tif (!changes.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.labels} SET ${changes\n\t\t\t\t\t\t.map((change) => `${change.field} = ?`)\n\t\t\t\t\t\t.join(\", \")}, updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [...changes.map((change) => change.to), timestamp, id],\n\t\t\t\t},\n\t\t\t\t...changes.map(\n\t\t\t\t\t(change): Statement => ({\n\t\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('label.updated', ?, ?, ?, ?)`,\n\t\t\t\t\t\targs: [\n\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\tactor,\n\t\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\t\tupdate_target: change.field,\n\t\t\t\t\t\t\t\tfrom: change.from,\n\t\t\t\t\t\t\t\tto: change.to,\n\t\t\t\t\t\t\t}),\n\t\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t\t],\n\t\t\t\t\t}),\n\t\t\t\t),\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function deleteLabel(id: number, actor: string): Promise<void> {\n\t\tconst label = await getLabel(id);\n\t\tif (!label) return;\n\t\tconst links = await client.execute({\n\t\t\tsql: `SELECT issue_id FROM ${TABLES.issueLabels} WHERE label_id = ?`,\n\t\t\targs: [id],\n\t\t});\n\t\tconst timestamp = now();\n\t\tconst statements: Statement[] = [\n\t\t\t{\n\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('label.deleted', ?, ?, ?, ?)`,\n\t\t\t\targs: [id, actor, JSON.stringify(labelSnapshot(label)), timestamp],\n\t\t\t},\n\t\t];\n\t\tfor (const row of links.rows) {\n\t\t\tconst issueId = number(row.issue_id);\n\t\t\tstatements.push(\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: \"label\",\n\t\t\t\t\t\t\tfrom: label.name,\n\t\t\t\t\t\t\tto: null,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t);\n\t\t}\n\t\tstatements.push({\n\t\t\tsql: `DELETE FROM ${TABLES.labels} WHERE id = ?`,\n\t\t\targs: [id],\n\t\t});\n\t\tawait client.batch(statements, \"write\");\n\t}\n\n\tasync function addLabel(\n\t\tissueId: number,\n\t\tlabelId: number,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst label = await getLabel(labelId);\n\t\tif (!label) throw new Error(`Label #${labelId} not found.`);\n\t\tconst existing = await client.execute({\n\t\t\tsql: `SELECT 1 FROM ${TABLES.issueLabels} WHERE issue_id = ? AND label_id = ?`,\n\t\t\targs: [issueId, labelId],\n\t\t});\n\t\tif (existing.rows.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.issueLabels} (issue_id, label_id) VALUES (?, ?)`,\n\t\t\t\t\targs: [issueId, labelId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: \"label\",\n\t\t\t\t\t\t\tfrom: null,\n\t\t\t\t\t\t\tto: label.name,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function removeLabel(\n\t\tissueId: number,\n\t\tlabelId: number,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst label = await getLabel(labelId);\n\t\tif (!label) return;\n\t\tconst existing = await client.execute({\n\t\t\tsql: `SELECT 1 FROM ${TABLES.issueLabels} WHERE issue_id = ? AND label_id = ?`,\n\t\t\targs: [issueId, labelId],\n\t\t});\n\t\tif (!existing.rows.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `DELETE FROM ${TABLES.issueLabels} WHERE issue_id = ? AND label_id = ?`,\n\t\t\t\t\targs: [issueId, labelId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: \"label\",\n\t\t\t\t\t\t\tfrom: label.name,\n\t\t\t\t\t\t\tto: null,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function addAssignee(\n\t\tissueId: number,\n\t\thandle: string,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst existing = await client.execute({\n\t\t\tsql: `SELECT 1 FROM ${TABLES.assignees} WHERE issue_id = ? AND user_handle = ?`,\n\t\t\targs: [issueId, handle],\n\t\t});\n\t\tif (existing.rows.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.assignees} (issue_id, user_handle) VALUES (?, ?)`,\n\t\t\t\t\targs: [issueId, handle],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: \"assignee\",\n\t\t\t\t\t\t\tfrom: null,\n\t\t\t\t\t\t\tto: handle,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function removeAssignee(\n\t\tissueId: number,\n\t\thandle: string,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst existing = await client.execute({\n\t\t\tsql: `SELECT 1 FROM ${TABLES.assignees} WHERE issue_id = ? AND user_handle = ?`,\n\t\t\targs: [issueId, handle],\n\t\t});\n\t\tif (!existing.rows.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `DELETE FROM ${TABLES.assignees} WHERE issue_id = ? AND user_handle = ?`,\n\t\t\t\t\targs: [issueId, handle],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: \"assignee\",\n\t\t\t\t\t\t\tfrom: handle,\n\t\t\t\t\t\t\tto: null,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function addBlock(\n\t\tissueId: number,\n\t\totherIssueId: number,\n\t\tdirection: \"blocks\" | \"blocked_by\",\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst blockerId = direction === \"blocks\" ? issueId : otherIssueId;\n\t\tconst blockedId = direction === \"blocks\" ? otherIssueId : issueId;\n\t\tif (blockerId === blockedId) {\n\t\t\tthrow new Error(\"An issue cannot block itself.\");\n\t\t}\n\t\tif (!(await getBaseIssue(blockerId)) || !(await getBaseIssue(blockedId))) {\n\t\t\tthrow new Error(\"Issue not found.\");\n\t\t}\n\t\tconst cycle = await client.execute({\n\t\t\tsql: `WITH RECURSIVE reachable(id) AS (\n\t\t\t\tSELECT blocked_id FROM ${TABLES.blocks} WHERE blocker_id = ?\n\t\t\t\tUNION\n\t\t\t\tSELECT edge.blocked_id FROM ${TABLES.blocks} edge JOIN reachable ON edge.blocker_id = reachable.id\n\t\t\t) SELECT 1 FROM reachable WHERE id = ? LIMIT 1`,\n\t\t\targs: [blockedId, blockerId],\n\t\t});\n\t\tif (cycle.rows.length) {\n\t\t\tthrow new Error(\"Blocking relationship would create a cycle.\");\n\t\t}\n\t\tconst existing = await client.execute({\n\t\t\tsql: `SELECT 1 FROM ${TABLES.blocks} WHERE blocker_id = ? AND blocked_id = ?`,\n\t\t\targs: [blockerId, blockedId],\n\t\t});\n\t\tif (existing.rows.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.blocks} (blocker_id, blocked_id) VALUES (?, ?)`,\n\t\t\t\t\targs: [blockerId, blockedId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: direction,\n\t\t\t\t\t\t\tfrom: null,\n\t\t\t\t\t\t\tto: otherIssueId,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function removeBlock(\n\t\tissueId: number,\n\t\totherIssueId: number,\n\t\tdirection: \"blocks\" | \"blocked_by\",\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst blockerId = direction === \"blocks\" ? issueId : otherIssueId;\n\t\tconst blockedId = direction === \"blocks\" ? otherIssueId : issueId;\n\t\tconst existing = await client.execute({\n\t\t\tsql: `SELECT 1 FROM ${TABLES.blocks} WHERE blocker_id = ? AND blocked_id = ?`,\n\t\t\targs: [blockerId, blockedId],\n\t\t});\n\t\tif (!existing.rows.length) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `DELETE FROM ${TABLES.blocks} WHERE blocker_id = ? AND blocked_id = ?`,\n\t\t\t\t\targs: [blockerId, blockedId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, issueId],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tissueId,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: direction,\n\t\t\t\t\t\t\tfrom: otherIssueId,\n\t\t\t\t\t\t\tto: null,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function listComments(issueId: number): Promise<Comment[]> {\n\t\tconst result = await client.execute({\n\t\t\tsql: `SELECT comment.*, event.actor AS author FROM ${TABLES.comments} comment\n\t\t\t\tLEFT JOIN ${TABLES.events} event ON event.event_type = 'comment.created' AND event.entity_id = comment.id\n\t\t\t\tWHERE comment.issue_id = ? ORDER BY comment.created_at, comment.id`,\n\t\t\targs: [issueId],\n\t\t});\n\t\treturn result.rows.map((row) => ({\n\t\t\tid: number(row.id),\n\t\t\tissue_id: number(row.issue_id),\n\t\t\tbody: String(row.body),\n\t\t\tcreated_at: number(row.created_at),\n\t\t\tupdated_at: number(row.updated_at),\n\t\t\tauthor: row.author == null ? null : String(row.author),\n\t\t}));\n\t}\n\n\tasync function getComment(id: number): Promise<Comment | null> {\n\t\tconst result = await client.execute({\n\t\t\tsql: `SELECT comment.*, event.actor AS author FROM ${TABLES.comments} comment\n        LEFT JOIN ${TABLES.events} event ON event.event_type = 'comment.created' AND event.entity_id = comment.id\n        WHERE comment.id = ? ORDER BY event.id LIMIT 1`,\n\t\t\targs: [id],\n\t\t});\n\t\tconst row = result.rows[0];\n\t\treturn row\n\t\t\t? {\n\t\t\t\t\tid: number(row.id),\n\t\t\t\t\tissue_id: number(row.issue_id),\n\t\t\t\t\tbody: String(row.body),\n\t\t\t\t\tcreated_at: number(row.created_at),\n\t\t\t\t\tupdated_at: number(row.updated_at),\n\t\t\t\t\tauthor: row.author == null ? null : String(row.author),\n\t\t\t\t}\n\t\t\t: null;\n\t}\n\n\tasync function createComment(data: {\n\t\tissueId: number;\n\t\tbody: string;\n\t\tactor: string;\n\t}): Promise<number> {\n\t\tif (!(await getBaseIssue(data.issueId))) {\n\t\t\tthrow new Error(`Issue #${data.issueId} not found.`);\n\t\t}\n\t\tconst timestamp = now();\n\t\tconst results = await client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.comments} (issue_id, body, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n\t\t\t\t\targs: [data.issueId, data.body, timestamp, timestamp],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp)\n\t\t\t\t\t\tSELECT 'comment.created', id, ?, json_object('id', id, 'issue_id', issue_id, 'body', body, 'created_at', created_at, 'updated_at', updated_at), ?\n\t\t\t\t\t\tFROM ${TABLES.comments} WHERE id = last_insert_rowid()`,\n\t\t\t\t\targs: [data.actor, timestamp],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, data.issueId],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t\treturn number(results[0].lastInsertRowid);\n\t}\n\n\tasync function updateComment(\n\t\tid: number,\n\t\tbody: string,\n\t\tactor: string,\n\t): Promise<void> {\n\t\tconst result = await client.execute({\n\t\t\tsql: `SELECT * FROM ${TABLES.comments} WHERE id = ?`,\n\t\t\targs: [id],\n\t\t});\n\t\tconst row = result.rows[0];\n\t\tif (!row) throw new Error(`Comment #${id} not found.`);\n\t\tif (String(row.body) === body) return;\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.comments} SET body = ?, updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [body, timestamp, id],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, number(row.issue_id)],\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('comment.updated', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tid,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify({\n\t\t\t\t\t\t\tupdate_target: \"body\",\n\t\t\t\t\t\t\tfrom: String(row.body),\n\t\t\t\t\t\t\tto: body,\n\t\t\t\t\t\t}),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function deleteComment(id: number, actor: string): Promise<void> {\n\t\tconst result = await client.execute({\n\t\t\tsql: `SELECT * FROM ${TABLES.comments} WHERE id = ?`,\n\t\t\targs: [id],\n\t\t});\n\t\tconst row = result.rows[0];\n\t\tif (!row) return;\n\t\tconst comment = {\n\t\t\tid: number(row.id),\n\t\t\tissue_id: number(row.issue_id),\n\t\t\tbody: String(row.body),\n\t\t\tcreated_at: number(row.created_at),\n\t\t\tupdated_at: number(row.updated_at),\n\t\t};\n\t\tconst timestamp = now();\n\t\tawait client.batch(\n\t\t\t[\n\t\t\t\t{\n\t\t\t\t\tsql: `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('comment.deleted', ?, ?, ?, ?)`,\n\t\t\t\t\targs: [\n\t\t\t\t\t\tid,\n\t\t\t\t\t\tactor,\n\t\t\t\t\t\tJSON.stringify(commentSnapshot(comment)),\n\t\t\t\t\t\ttimestamp,\n\t\t\t\t\t],\n\t\t\t\t},\n\t\t\t\t{ sql: `DELETE FROM ${TABLES.comments} WHERE id = ?`, args: [id] },\n\t\t\t\t{\n\t\t\t\t\tsql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n\t\t\t\t\targs: [timestamp, comment.issue_id],\n\t\t\t\t},\n\t\t\t],\n\t\t\t\"write\",\n\t\t);\n\t}\n\n\tasync function listEvents(\n\t\topts: { entity?: \"issue\" | \"comment\" | \"label\"; entityId?: number } = {},\n\t): Promise<TrackerEvent[]> {\n\t\tlet sql = `SELECT * FROM ${TABLES.events}`;\n\t\tconst conditions: string[] = [];\n\t\tconst args: SqlValue[] = [];\n\t\tif (opts.entity) {\n\t\t\tconditions.push(\"event_type LIKE ?\");\n\t\t\targs.push(`${opts.entity}.%`);\n\t\t}\n\t\tif (opts.entityId !== undefined) {\n\t\t\tconditions.push(\"entity_id = ?\");\n\t\t\targs.push(opts.entityId);\n\t\t}\n\t\tif (conditions.length) sql += ` WHERE ${conditions.join(\" AND \")}`;\n\t\tsql += \" ORDER BY id\";\n\t\tconst result = await client.execute({ sql, args });\n\t\treturn result.rows.map((row) => ({\n\t\t\tid: number(row.id),\n\t\t\tevent_type: row.event_type as EventType,\n\t\t\tentity_id: number(row.entity_id),\n\t\t\tactor: String(row.actor),\n\t\t\tdata: parseJson(row.data),\n\t\t\tevent_timestamp: number(row.event_timestamp),\n\t\t}));\n\t}\n\n\treturn {\n\t\tinitSchema,\n\t\tlistIssues,\n\t\tgetIssue,\n\t\tcreateIssue,\n\t\tupdateIssue,\n\t\tcloseIssue,\n\t\treopenIssue,\n\t\tdeleteIssue,\n\t\tlistLabels,\n\t\tgetLabel,\n\t\tcreateLabel,\n\t\tupdateLabel,\n\t\tdeleteLabel,\n\t\taddLabel,\n\t\tremoveLabel,\n\t\taddAssignee,\n\t\tremoveAssignee,\n\t\taddBlock,\n\t\tremoveBlock,\n\t\tlistComments,\n\t\tgetComment,\n\t\tcreateComment,\n\t\tupdateComment,\n\t\tdeleteComment,\n\t\tlistEvents,\n\t};\n}\n\nexport type IssueStore = ReturnType<typeof createIssueStore>;\nexport const defaultIssueStore = createIssueStore(\n\tsqlite as unknown as SqliteClient,\n);\n\nexport const initSchema = defaultIssueStore.initSchema;\nexport const listIssues = defaultIssueStore.listIssues;\nexport const getIssue = defaultIssueStore.getIssue;\nexport const createIssue = defaultIssueStore.createIssue;\nexport const updateIssue = defaultIssueStore.updateIssue;\nexport const closeIssue = defaultIssueStore.closeIssue;\nexport const reopenIssue = defaultIssueStore.reopenIssue;\nexport const deleteIssue = defaultIssueStore.deleteIssue;\nexport const listLabels = defaultIssueStore.listLabels;\nexport const getLabel = defaultIssueStore.getLabel;\nexport const createLabel = defaultIssueStore.createLabel;\nexport const updateLabel = defaultIssueStore.updateLabel;\nexport const deleteLabel = defaultIssueStore.deleteLabel;\nexport const addLabel = defaultIssueStore.addLabel;\nexport const removeLabel = defaultIssueStore.removeLabel;\nexport const addAssignee = defaultIssueStore.addAssignee;\nexport const removeAssignee = defaultIssueStore.removeAssignee;\nexport const addBlock = defaultIssueStore.addBlock;\nexport const removeBlock = defaultIssueStore.removeBlock;\nexport const listComments = defaultIssueStore.listComments;\nexport const getComment = defaultIssueStore.getComment;\nexport const createComment = defaultIssueStore.createComment;\nexport const updateComment = defaultIssueStore.updateComment;\nexport const deleteComment = defaultIssueStore.deleteComment;\nexport const listEvents = defaultIssueStore.listEvents;\n",[215],"88dbf4b7-6d73-4502-aa77-2c908d462f78","components.tsx","bc7095f6-7b3c-11f1-9afb-1607ee4eb77e",178,["D",1783653143312],44,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC } from \"npm:hono@4.6.14/jsx\";\nimport type { Comment, Issue, Label } from \"./db.ts\";\nimport { Layout } from \"./layout.tsx\";\nimport {\n\tBanner,\n\tButton,\n\tCard,\n\tFIELD,\n\tLabelTag,\n\tSelect,\n\tStatusBadge,\n} from \"./ui.tsx\";\n\nconst TH =\n\t\"text-left px-2.5 py-2.5 border-b border-[#2a2f3a] text-[#8b93a3] font-medium text-xs uppercase\";\nconst TD = \"text-left px-2.5 py-2.5 border-b border-[#2a2f3a] align-top\";\nfunction date(timestamp: number) {\n\treturn new Date(timestamp).toLocaleString(\"en-US\", {\n\t\tdateStyle: \"medium\",\n\t\ttimeStyle: \"short\",\n\t});\n}\n\nexport const IssueListPage: FC<{\n\ttitle: string;\n\tuser: string | null;\n\tcanCreate: boolean;\n\tauth?: boolean;\n\tissues: Issue[];\n\tfilters: { status?: string; assignee?: string; search?: string };\n}> = ({ title, user, canCreate, auth = true, issues, filters }) => (\n\t<Layout title={title} user={user} auth={auth}>\n\t\t<div class=\"flex gap-4 mb-4\">\n\t\t\t<Card class=\"text-center\">\n\t\t\t\t<strong class=\"text-2xl text-blue-500\">\n\t\t\t\t\t{issues.filter((issue) => issue.status === \"open\").length}\n\t\t\t\t</strong>\n\t\t\t\t<div class=\"text-xs text-[#8b93a3]\">Open</div>\n\t\t\t</Card>\n\t\t\t<Card class=\"text-center\">\n\t\t\t\t<strong class=\"text-2xl text-gray-500\">\n\t\t\t\t\t{issues.filter((issue) => issue.status === \"closed\").length}\n\t\t\t\t</strong>\n\t\t\t\t<div class=\"text-xs text-[#8b93a3]\">Closed</div>\n\t\t\t</Card>\n\t\t</div>\n\t\t<Card>\n\t\t\t<form method=\"get\" action=\"/\" class=\"flex gap-2 mb-4 flex-wrap\">\n\t\t\t\t<Select name=\"status\">\n\t\t\t\t\t<option value=\"\">All statuses</option>\n\t\t\t\t\t<option value=\"open\" selected={filters.status === \"open\"}>\n\t\t\t\t\t\tOpen\n\t\t\t\t\t</option>\n\t\t\t\t\t<option value=\"closed\" selected={filters.status === \"closed\"}>\n\t\t\t\t\t\tClosed\n\t\t\t\t\t</option>\n\t\t\t\t</Select>\n\t\t\t\t<input\n\t\t\t\t\tname=\"assignee\"\n\t\t\t\t\tvalue={filters.assignee ?? \"\"}\n\t\t\t\t\tplaceholder=\"Assignee\"\n\t\t\t\t\tclass={FIELD}\n\t\t\t\t/>\n\t\t\t\t<input\n\t\t\t\t\ttype=\"search\"\n\t\t\t\t\tname=\"search\"\n\t\t\t\t\tvalue={filters.search ?? \"\"}\n\t\t\t\t\tplaceholder=\"Search title or body…\"\n\t\t\t\t\tclass={`${FIELD} flex-1`}\n\t\t\t\t/>\n\t\t\t\t<Button type=\"submit\" variant=\"ghost\">\n\t\t\t\t\tFilter\n\t\t\t\t</Button>\n\t\t\t</form>\n\t\t\t{issues.length ? (\n\t\t\t\t<table class=\"w-full border-collapse\">\n\t\t\t\t\t<thead>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th class={TH}>#</th>\n\t\t\t\t\t\t\t<th class={TH}>Title</th>\n\t\t\t\t\t\t\t<th class={TH}>Status</th>\n\t\t\t\t\t\t\t<th class={TH}>Assignees</th>\n\t\t\t\t\t\t\t<th class={TH}>Updated</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</thead>\n\t\t\t\t\t<tbody>\n\t\t\t\t\t\t{issues.map((issue) => (\n\t\t\t\t\t\t\t<tr key={issue.id}>\n\t\t\t\t\t\t\t\t<td class={TD}>{issue.id}</td>\n\t\t\t\t\t\t\t\t<td class={TD}>\n\t\t\t\t\t\t\t\t\t<a class=\"text-[#6ea8fe]\" href={`/issue/${issue.id}`}>\n\t\t\t\t\t\t\t\t\t\t{issue.title}\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t\t{issue.blocked ? (\n\t\t\t\t\t\t\t\t\t\t<span class=\"ml-2 text-amber-400 text-xs\">Blocked</span>\n\t\t\t\t\t\t\t\t\t) : null}\n\t\t\t\t\t\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t{issue.labels.map((label) => (\n\t\t\t\t\t\t\t\t\t\t\t<LabelTag key={label.id} label={label} />\n\t\t\t\t\t\t\t\t\t\t))}\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td class={TD}>\n\t\t\t\t\t\t\t\t\t<StatusBadge\n\t\t\t\t\t\t\t\t\t\tstatus={issue.status}\n\t\t\t\t\t\t\t\t\t\treason={issue.state_reason}\n\t\t\t\t\t\t\t\t\t/>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td class={TD}>\n\t\t\t\t\t\t\t\t\t{issue.assignees.map((handle) => `@${handle}`).join(\", \") ||\n\t\t\t\t\t\t\t\t\t\t\"—\"}\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td class={TD}>{date(issue.updated_at)}</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t))}\n\t\t\t\t\t</tbody>\n\t\t\t\t</table>\n\t\t\t) : (\n\t\t\t\t<p class=\"text-[#8b93a3]\">No issues found.</p>\n\t\t\t)}\n\t\t</Card>\n\t\t<div class=\"flex gap-2 justify-end\">\n\t\t\t{canCreate ? <Button href=\"/new\">+ New Issue</Button> : null}\n\t\t\t<Button href=\"/labels\" variant=\"ghost\">\n\t\t\t\tLabels\n\t\t\t</Button>\n\t\t</div>\n\t</Layout>\n);\n\nexport const NewIssuePage: FC<{\n\ttitle: string;\n\tuser: string | null;\n\tlabels: Label[];\n\tauth?: boolean;\n\terror?: string;\n}> = ({ title, user, labels, auth = true, error }) => (\n\t<Layout title={`${title} — New Issue`} user={user} auth={auth}>\n\t\t<a href=\"/\" class=\"text-[#8b93a3]\">\n\t\t\t← all issues\n\t\t</a>\n\t\t<Card class=\"mt-3\">\n\t\t\t<h2>Create Issue</h2>\n\t\t\t{error ? <Banner kind=\"err\" msg={error} /> : null}\n\t\t\t<form method=\"post\" action=\"/new\" class=\"grid gap-3\">\n\t\t\t\t<input name=\"title\" placeholder=\"Title\" required class={FIELD} />\n\t\t\t\t<textarea\n\t\t\t\t\tname=\"body\"\n\t\t\t\t\tplaceholder=\"Describe the issue…\"\n\t\t\t\t\tclass={`${FIELD} min-h-[160px] py-3`}\n\t\t\t\t/>\n\t\t\t\t<fieldset>\n\t\t\t\t\t<legend class=\"text-xs text-[#8b93a3]\">Labels</legend>\n\t\t\t\t\t<div class=\"flex gap-3 flex-wrap\">\n\t\t\t\t\t\t{labels.map((label) => (\n\t\t\t\t\t\t\t<label key={label.id}>\n\t\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"label_id\" value={label.id} />{\" \"}\n\t\t\t\t\t\t\t\t<LabelTag label={label} />\n\t\t\t\t\t\t\t</label>\n\t\t\t\t\t\t))}\n\t\t\t\t\t</div>\n\t\t\t\t</fieldset>\n\t\t\t\t<label class=\"text-xs text-[#8b93a3]\">\n\t\t\t\t\tAssignees (comma-separated)\n\t\t\t\t\t<input\n\t\t\t\t\t\tname=\"assignees\"\n\t\t\t\t\t\tplaceholder=\"alice, bob\"\n\t\t\t\t\t\tclass={`${FIELD} w-full mt-1`}\n\t\t\t\t\t/>\n\t\t\t\t</label>\n\t\t\t\t<div class=\"flex gap-2\">\n\t\t\t\t\t<Button type=\"submit\">Create Issue</Button>\n\t\t\t\t\t<Button href=\"/\" variant=\"ghost\">\n\t\t\t\t\t\tCancel\n\t\t\t\t\t</Button>\n\t\t\t\t</div>\n\t\t\t</form>\n\t\t</Card>\n\t</Layout>\n);\n\nfunction CommentCard({\n\tcomment,\n\tcanManage,\n}: {\n\tcomment: Comment;\n\tcanManage: boolean;\n}) {\n\treturn (\n\t\t<div class=\"bg-[#1f232c] border border-[#2a2f3a] rounded-lg p-3 mb-2\">\n\t\t\t<div class=\"text-xs text-[#8b93a3]\">\n\t\t\t\t@{comment.author ?? \"unknown\"} · {date(comment.created_at)}\n\t\t\t\t{comment.updated_at !== comment.created_at ? \" · edited\" : \"\"}\n\t\t\t</div>\n\t\t\t<div class=\"whitespace-pre-wrap my-2\">{comment.body}</div>\n\t\t\t{canManage ? (\n\t\t\t\t<details>\n\t\t\t\t\t<summary class=\"cursor-pointer text-xs text-[#6ea8fe]\">\n\t\t\t\t\t\tEdit comment\n\t\t\t\t\t</summary>\n\t\t\t\t\t<form\n\t\t\t\t\t\tmethod=\"post\"\n\t\t\t\t\t\taction={`/comment/${comment.id}/edit`}\n\t\t\t\t\t\tclass=\"flex gap-2 mt-2\"\n\t\t\t\t\t>\n\t\t\t\t\t\t<input name=\"body\" value={comment.body} class={`${FIELD} flex-1`} />\n\t\t\t\t\t\t<Button type=\"submit\" variant=\"ghost\">\n\t\t\t\t\t\t\tSave\n\t\t\t\t\t\t</Button>\n\t\t\t\t\t</form>\n\t\t\t\t\t<form\n\t\t\t\t\t\tmethod=\"post\"\n\t\t\t\t\t\taction={`/comment/${comment.id}/delete`}\n\t\t\t\t\t\tclass=\"mt-2\"\n\t\t\t\t\t>\n\t\t\t\t\t\t<Button type=\"submit\" variant=\"danger\">\n\t\t\t\t\t\t\tDelete\n\t\t\t\t\t\t</Button>\n\t\t\t\t\t</form>\n\t\t\t\t</details>\n\t\t\t) : null}\n\t\t</div>\n\t);\n}\n\nexport const IssueDetailPage: FC<{\n\ttitle: string;\n\tuser: string | null;\n\tcanManage: boolean;\n\tcanDelete: boolean;\n\tauth?: boolean;\n\tissue: Issue;\n\tcomments: Comment[];\n\tlabels: Label[];\n}> = ({\n\ttitle,\n\tuser,\n\tcanManage,\n\tcanDelete,\n\tauth = true,\n\tissue,\n\tcomments,\n\tlabels,\n}) => (\n\t<Layout title={`${title} — #${issue.id}`} user={user} auth={auth}>\n\t\t<a href=\"/\" class=\"text-[#8b93a3]\">\n\t\t\t← all issues\n\t\t</a>\n\t\t<Card class=\"mt-3\">\n\t\t\t<h2>\n\t\t\t\t<span class=\"text-[#8b93a3]\">#{issue.id}</span> {issue.title}\n\t\t\t</h2>\n\t\t\t<div class=\"flex gap-3 flex-wrap\">\n\t\t\t\t<StatusBadge status={issue.status} reason={issue.state_reason} />\n\t\t\t\t{issue.blocked ? <span class=\"text-amber-400\">Blocked</span> : null}\n\t\t\t\t<span class=\"text-[#8b93a3]\">\n\t\t\t\t\tOpened by @{issue.creator ?? \"unknown\"}\n\t\t\t\t</span>\n\t\t\t</div>\n\t\t\t<div class=\"mt-2\">\n\t\t\t\t{issue.labels.map((label) => (\n\t\t\t\t\t<LabelTag key={label.id} label={label} />\n\t\t\t\t))}\n\t\t\t</div>\n\t\t\t<div class=\"mt-4 whitespace-pre-wrap\">{issue.body}</div>\n\t\t\t<p class=\"text-[#8b93a3]\">\n\t\t\t\tAssignees:{\" \"}\n\t\t\t\t{issue.assignees.map((handle) => `@${handle}`).join(\", \") || \"none\"}\n\t\t\t</p>\n\t\t\t<p class=\"text-[#8b93a3]\">\n\t\t\t\tBlocked by:{\" \"}\n\t\t\t\t{issue.blockers.map((item) => (\n\t\t\t\t\t<a\n\t\t\t\t\t\tkey={item.id}\n\t\t\t\t\t\tclass=\"text-[#6ea8fe] mr-2\"\n\t\t\t\t\t\thref={`/issue/${item.id}`}\n\t\t\t\t\t>\n\t\t\t\t\t\t#{item.id}\n\t\t\t\t\t</a>\n\t\t\t\t))}\n\t\t\t\t{issue.blockers.length ? \"\" : \"none\"}\n\t\t\t</p>\n\t\t\t<p class=\"text-[#8b93a3]\">\n\t\t\t\tBlocks:{\" \"}\n\t\t\t\t{issue.blocks.map((item) => (\n\t\t\t\t\t<a\n\t\t\t\t\t\tkey={item.id}\n\t\t\t\t\t\tclass=\"text-[#6ea8fe] mr-2\"\n\t\t\t\t\t\thref={`/issue/${item.id}`}\n\t\t\t\t\t>\n\t\t\t\t\t\t#{item.id}\n\t\t\t\t\t</a>\n\t\t\t\t))}\n\t\t\t\t{issue.blocks.length ? \"\" : \"none\"}\n\t\t\t</p>\n\t\t\t{canManage ? (\n\t\t\t\t<div class=\"flex gap-2 flex-wrap\">\n\t\t\t\t\t<Button href={`/issue/${issue.id}/edit`}>Edit</Button>\n\t\t\t\t\t{issue.status === \"open\" ? (\n\t\t\t\t\t\t<form\n\t\t\t\t\t\t\tmethod=\"post\"\n\t\t\t\t\t\t\taction={`/issue/${issue.id}/close`}\n\t\t\t\t\t\t\tclass=\"flex gap-2\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t<Select name=\"reason\">\n\t\t\t\t\t\t\t\t<option value=\"completed\">Completed</option>\n\t\t\t\t\t\t\t\t<option value=\"not_planned\">Not planned</option>\n\t\t\t\t\t\t\t\t<option value=\"duplicate\">Duplicate</option>\n\t\t\t\t\t\t\t</Select>\n\t\t\t\t\t\t\t<Button type=\"submit\">Close</Button>\n\t\t\t\t\t\t</form>\n\t\t\t\t\t) : (\n\t\t\t\t\t\t<form method=\"post\" action={`/issue/${issue.id}/reopen`}>\n\t\t\t\t\t\t\t<Button type=\"submit\">Reopen</Button>\n\t\t\t\t\t\t</form>\n\t\t\t\t\t)}\n\t\t\t\t\t{canDelete ? (\n\t\t\t\t\t\t<form method=\"post\" action={`/issue/${issue.id}/delete`}>\n\t\t\t\t\t\t\t<Button type=\"submit\" variant=\"danger\">\n\t\t\t\t\t\t\t\tDelete\n\t\t\t\t\t\t\t</Button>\n\t\t\t\t\t\t</form>\n\t\t\t\t\t) : null}\n\t\t\t\t</div>\n\t\t\t) : null}\n\t\t</Card>\n\t\t{canManage ? (\n\t\t\t<Card>\n\t\t\t\t<h3>Relationships</h3>\n\t\t\t\t<form\n\t\t\t\t\tmethod=\"post\"\n\t\t\t\t\taction={`/issue/${issue.id}/label`}\n\t\t\t\t\tclass=\"flex gap-2 mb-2\"\n\t\t\t\t>\n\t\t\t\t\t<Select name=\"label_id\">\n\t\t\t\t\t\t{labels.map((label) => (\n\t\t\t\t\t\t\t<option key={label.id} value={label.id}>\n\t\t\t\t\t\t\t\t{label.name}\n\t\t\t\t\t\t\t</option>\n\t\t\t\t\t\t))}\n\t\t\t\t\t</Select>\n\t\t\t\t\t<Select name=\"action\">\n\t\t\t\t\t\t<option value=\"add\">Add label</option>\n\t\t\t\t\t\t<option value=\"remove\">Remove label</option>\n\t\t\t\t\t</Select>\n\t\t\t\t\t<Button type=\"submit\" variant=\"ghost\">\n\t\t\t\t\t\tApply\n\t\t\t\t\t</Button>\n\t\t\t\t</form>\n\t\t\t\t<form\n\t\t\t\t\tmethod=\"post\"\n\t\t\t\t\taction={`/issue/${issue.id}/assignee`}\n\t\t\t\t\tclass=\"flex gap-2 mb-2\"\n\t\t\t\t>\n\t\t\t\t\t<input name=\"handle\" placeholder=\"Val Town handle\" class={FIELD} />\n\t\t\t\t\t<Select name=\"action\">\n\t\t\t\t\t\t<option value=\"add\">Assign</option>\n\t\t\t\t\t\t<option value=\"remove\">Unassign</option>\n\t\t\t\t\t</Select>\n\t\t\t\t\t<Button type=\"submit\" variant=\"ghost\">\n\t\t\t\t\t\tApply\n\t\t\t\t\t</Button>\n\t\t\t\t</form>\n\t\t\t\t<form\n\t\t\t\t\tmethod=\"post\"\n\t\t\t\t\taction={`/issue/${issue.id}/block`}\n\t\t\t\t\tclass=\"flex gap-2\"\n\t\t\t\t>\n\t\t\t\t\t<input\n\t\t\t\t\t\tname=\"other_id\"\n\t\t\t\t\t\ttype=\"number\"\n\t\t\t\t\t\tmin=\"1\"\n\t\t\t\t\t\tplaceholder=\"Issue #\"\n\t\t\t\t\t\tclass={FIELD}\n\t\t\t\t\t/>\n\t\t\t\t\t<Select name=\"direction\">\n\t\t\t\t\t\t<option value=\"blocks\">This issue blocks #</option>\n\t\t\t\t\t\t<option value=\"blocked_by\">This issue is blocked by #</option>\n\t\t\t\t\t</Select>\n\t\t\t\t\t<Select name=\"action\">\n\t\t\t\t\t\t<option value=\"add\">Add</option>\n\t\t\t\t\t\t<option value=\"remove\">Remove</option>\n\t\t\t\t\t</Select>\n\t\t\t\t\t<Button type=\"submit\" variant=\"ghost\">\n\t\t\t\t\t\tApply\n\t\t\t\t\t</Button>\n\t\t\t\t</form>\n\t\t\t</Card>\n\t\t) : null}\n\t\t<Card>\n\t\t\t<h3>Comments ({comments.length})</h3>\n\t\t\t{comments.map((comment) => (\n\t\t\t\t<CommentCard\n\t\t\t\t\tkey={comment.id}\n\t\t\t\t\tcomment={comment}\n\t\t\t\t\tcanManage={canManage || user === comment.author}\n\t\t\t\t/>\n\t\t\t))}\n\t\t\t{user || !auth ? (\n\t\t\t\t<form method=\"post\" action={`/issue/${issue.id}/comment`}>\n\t\t\t\t\t<textarea\n\t\t\t\t\t\tname=\"body\"\n\t\t\t\t\t\trequired\n\t\t\t\t\t\tplaceholder=\"Add a comment…\"\n\t\t\t\t\t\tclass={`${FIELD} w-full min-h-[100px] py-3`}\n\t\t\t\t\t/>\n\t\t\t\t\t<Button type=\"submit\" class=\"mt-2\">\n\t\t\t\t\t\tComment\n\t\t\t\t\t</Button>\n\t\t\t\t</form>\n\t\t\t) : (\n\t\t\t\t<p>\n\t\t\t\t\t<a href=\"/auth/login\">Log in</a> to comment.\n\t\t\t\t</p>\n\t\t\t)}\n\t\t</Card>\n\t</Layout>\n);\n\nexport const EditIssuePage: FC<{\n\ttitle: string;\n\tuser: string | null;\n\tissue: Issue;\n\tauth?: boolean;\n\terror?: string;\n}> = ({ title, user, issue, auth = true, error }) => (\n\t<Layout title={`${title} — Edit #${issue.id}`} user={user} auth={auth}>\n\t\t<a href={`/issue/${issue.id}`} class=\"text-[#8b93a3]\">\n\t\t\t← back\n\t\t</a>\n\t\t<Card class=\"mt-3\">\n\t\t\t{error ? <Banner kind=\"err\" msg={error} /> : null}\n\t\t\t<form method=\"post\" action={`/issue/${issue.id}/edit`} class=\"grid gap-3\">\n\t\t\t\t<input name=\"title\" value={issue.title} required class={FIELD} />\n\t\t\t\t<textarea name=\"body\" class={`${FIELD} min-h-[160px] py-3`}>\n\t\t\t\t\t{issue.body}\n\t\t\t\t

\n\t\t\t\t\n\t\t\t\n\t\t\n\t\n);\n\nexport const LabelsPage: FC<{\n\ttitle: string;\n\tuser: string | null;\n\tlabels: Label[];\n\tcanManage: boolean;\n\tauth?: boolean;\n}> = ({ title, user, labels, canManage, auth = true }) => (\n\t\n\t\t\n\t\t\t← all issues\n\t\t\n\t\t\n\t\t\t

Labels

\n\t\t\t{labels.map((label) => (\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t{canManage ? (\n\t\t\t\t\t\t<>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tSave\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tDelete\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t) : null}\n\t\t\t\t\n\t\t\t))}\n\t\t\t{canManage ? (\n\t\t\t\t\n\t\t\t) : null}\n\t\t\n\t\n);\n",[223],"a7306a63-8b30-48aa-a289-298500d468d0","biome.json","0aaccfd6-7b43-11f1-a761-1607ee4eb77e",188,["D",1783695441586],"{\n\t\"$schema\": \"https://biomejs.dev/schemas/2.5.3/schema.json\",\n\t\"vcs\": {\n\t\t\"enabled\": false,\n\t\t\"clientKind\": \"git\",\n\t\t\"useIgnoreFile\": false\n\t},\n\t\"files\": {\n\t\t\"ignoreUnknown\": false\n\t},\n\t\"formatter\": {\n\t\t\"enabled\": true,\n\t\t\"indentStyle\": \"tab\"\n\t},\n\t\"linter\": {\n\t\t\"enabled\": true,\n\t\t\"rules\": {\n\t\t\t\"preset\": \"recommended\"\n\t\t}\n\t},\n\t\"javascript\": {\n\t\t\"formatter\": {\n\t\t\t\"quoteStyle\": \"double\"\n\t\t}\n\t},\n\t\"assist\": {\n\t\t\"enabled\": true,\n\t\t\"actions\": {\n\t\t\t\"source\": {\n\t\t\t\t\"organizeImports\": \"on\"\n\t\t\t}\n\t\t}\n\t}\n}\n",[231],"e7d0392b-3423-45c5-ae3f-d228306b279e","app_test.tsx","2a576934-7c0d-11f1-b9ff-1607ee4eb77e",187,["D",1783695441284],"/** @jsxImportSource npm:hono@4.6.14/jsx */\n\nimport { assert, assertExists } from \"jsr:@std/assert@1.0.19\";\nimport { createIssueTracker } from \"./app.tsx\";\nimport { createIssueStore } from \"./db.ts\";\nimport { createTestSqlite } from \"./test_sqlite.ts\";\n\nDeno.test(\"HTML forms drive create, lifecycle, labels, assignees, blocks, and comments\", async () => {\n\tconst store = createIssueStore(createTestSqlite());\n\tawait store.initSchema();\n\tconst bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n\tassertExists(bug);\n\tconst fetch = createIssueTracker(\n\t\t{\n\t\t\tauth: false,\n\t\t\ttitle: \"Test Tracker\",\n\t\t\tapiKey: \"secret\",\n\t\t},\n\t\tstore,\n\t);\n\tconst form = async (path: string, values: Array<[string, string]>) => {\n\t\tconst body = new URLSearchParams();\n\t\tfor (const [key, value] of values) body.append(key, value);\n\t\treturn await fetch(\n\t\t\tnew Request(`http://local${path}`, { method: \"POST\", body }),\n\t\t);\n\t};\n\n\tconst created = await form(\"/new\", [\n\t\t[\"title\", \"First\"],\n\t\t[\"body\", \"body\"],\n\t\t[\"label_id\", String(bug.id)],\n\t\t[\"assignees\", \"alice\"],\n\t]);\n\tconst firstId = Number(created.headers.get(\"location\")?.split(\"/\").at(-1));\n\tassert(Number.isInteger(firstId), \"create must redirect to the issue\");\n\tconst second = await form(\"/new\", [[\"title\", \"Second\"]]);\n\tconst secondId = Number(second.headers.get(\"location\")?.split(\"/\").at(-1));\n\n\tawait form(`/issue/${firstId}/close`, [[\"reason\", \"not_planned\"]]);\n\tlet html = await (\n\t\tawait fetch(new Request(`http://local/issue/${firstId}`))\n\t).text();\n\tassert(html.includes(\"Not planned\"), \"close reason must render\");\n\tawait form(`/issue/${firstId}/reopen`, []);\n\tawait form(`/issue/${firstId}/assignee`, [\n\t\t[\"handle\", \"bob\"],\n\t\t[\"action\", \"add\"],\n\t]);\n\tawait form(`/issue/${firstId}/block`, [\n\t\t[\"other_id\", String(secondId)],\n\t\t[\"direction\", \"blocks\"],\n\t\t[\"action\", \"add\"],\n\t]);\n\tawait form(`/issue/${firstId}/comment`, [[\"body\", \"UI comment\"]]);\n\tconst commentId = (await store.listComments(firstId))[0].id;\n\tawait form(`/comment/${commentId}/edit`, [[\"body\", \"Edited UI comment\"]]);\n\thtml = await (\n\t\tawait fetch(new Request(`http://local/issue/${firstId}`))\n\t).text();\n\tassert(html.includes(\"Reopened\"), \"reopen reason must render\");\n\tassert(html.includes(\"bug\"), \"selected label must render\");\n\tassert(\n\t\thtml.includes(\"@alice\") && html.includes(\"@bob\"),\n\t\t\"multiple assignees must render\",\n\t);\n\tassert(html.includes(`>#${secondId}<`), \"block relationship must render\");\n\tassert(html.includes(\"Edited UI comment\"), \"edited comment must render\");\n\tawait form(`/comment/${commentId}/delete`, []);\n\thtml = await (\n\t\tawait fetch(new Request(`http://local/issue/${firstId}`))\n\t).text();\n\tassert(!html.includes(\"Edited UI comment\"), \"deleted comment must disappear\");\n});\n",[238],"e03716ec-fd23-470e-b868-7a5750c2acb7","app.tsx","fc916b18-7b48-11f1-b573-1607ee4eb77e",186,["D",1783695440608],9,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport {\n\tgetOAuthUserData,\n\toauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { type Context, Hono } from \"npm:hono@4.6.14\";\nimport { createApi } from \"./api.ts\";\nimport {\n\tEditIssuePage,\n\tIssueDetailPage,\n\tIssueListPage,\n\tLabelsPage,\n\tNewIssuePage,\n} from \"./components.tsx\";\nimport {\n\tCLOSED_STATE_REASONS,\n\ttype ClosedStateReason,\n\tdefaultIssueStore,\n\tISSUE_STATUSES,\n\ttype Issue,\n\ttype IssueStatus,\n\ttype IssueStore,\n} from \"./db.ts\";\nimport { Layout } from \"./layout.tsx\";\nimport { Banner } from \"./ui.tsx\";\n\nexport interface IssueTrackerOptions {\n\tmaintainers?: string[];\n\t/** @deprecated Use maintainers. */\n\towner?: string[];\n\tdefaultRole?: \"contributor\" | \"viewer\";\n\tauth?: boolean;\n\ttitle?: string;\n\tapiKey?: string;\n}\n\ntype Role = \"viewer\" | \"contributor\" | \"maintainer\";\ntype Env = { Variables: { user: string; role: Role } };\n\nfunction runtimeVal() {\n\ttry {\n\t\treturn parseVal();\n\t} catch {\n\t\treturn {\n\t\t\tusername: \"local\",\n\t\t\tname: \"issue-tracker\",\n\t\t\tlinks: { self: { val: \"https://www.val.town/\" } },\n\t\t};\n\t}\n}\n\nfunction handles(value: FormDataEntryValue | null): string[] {\n\treturn String(value ?? \"\")\n\t\t.split(\",\")\n\t\t.map((handle) => handle.trim().replace(/^@/, \"\"))\n\t\t.filter(Boolean);\n}\n\nexport function createIssueTracker(\n\toptions: IssueTrackerOptions = {},\n\tstore: IssueStore = defaultIssueStore,\n) {\n\tconst val = runtimeVal();\n\tconst auth = options.auth !== false;\n\tconst title = options.title ?? `Issues · ${val.username}/${val.name}`;\n\tconst maintainers = new Set([\n\t\tval.username,\n\t\t...(options.maintainers ?? []),\n\t\t...(options.owner ?? []),\n\t]);\n\tconst defaultRole: Role = options.defaultRole ?? \"contributor\";\n\tconst apiKey = options.apiKey ?? Deno.env.get(\"ISSUE_TRACKER_API_KEY\");\n\tconst app = new Hono();\n\tapp.onError((error, c) =>\n\t\tc.html(\n\t\t\t\n\t\t\t\t\n\t\t\t,\n\t\t\t409,\n\t\t),\n\t);\n\tapp.route(\"/api\", createApi(apiKey, store));\n\n\tapp.use(\"*\", async (c, next) => {\n\t\tawait store.initSchema();\n\t\tif (auth) {\n\t\t\tconst session = await getOAuthUserData(c.req.raw);\n\t\t\tif (session?.user) {\n\t\t\t\tconst username = session.user.username ?? \"\";\n\t\t\t\tc.set(\"user\", username);\n\t\t\t\tc.set(\"role\", maintainers.has(username) ? \"maintainer\" : defaultRole);\n\t\t\t} else c.set(\"role\", \"viewer\");\n\t\t} else {\n\t\t\tc.set(\"user\", \"anonymous\");\n\t\t\tc.set(\"role\", \"maintainer\");\n\t\t}\n\t\tawait next();\n\t});\n\n\tasync function forbidden(c: Context, message: string) {\n\t\treturn await c.html(\n\t\t\t\n\t\t\t\t\n\t\t\t,\n\t\t\t403,\n\t\t);\n\t}\n\n\tfunction contributor(c: Context): string | Response {\n\t\tconst role = c.get(\"role\") ?? \"viewer\";\n\t\tif (role === \"viewer\") return c.redirect(\"/auth/login\");\n\t\treturn c.get(\"user\") ?? \"anonymous\";\n\t}\n\n\tasync function maintainer(c: Context): Promise {\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\treturn c.get(\"role\") === \"maintainer\"\n\t\t\t? actor\n\t\t\t: await forbidden(c, \"Only a maintainer can perform this action.\");\n\t}\n\n\tasync function manager(\n\t\tc: Context,\n\t\tissue: Issue,\n\t): Promise {\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\treturn c.get(\"role\") === \"maintainer\" || actor === issue.creator\n\t\t\t? actor\n\t\t\t: await forbidden(\n\t\t\t\t\tc,\n\t\t\t\t\t\"Only the issue's creator or a maintainer can perform this action.\",\n\t\t\t\t);\n\t}\n\n\tasync function issueFor(c: Context): Promise {\n\t\tconst id = Number(c.req.param(\"id\"));\n\t\tif (!Number.isInteger(id)) return c.redirect(\"/\");\n\t\tconst issue = await store.getIssue(id);\n\t\treturn (\n\t\t\tissue ??\n\t\t\tc.html(\n\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t,\n\t\t\t\t404,\n\t\t\t)\n\t\t);\n\t}\n\n\tapp.get(\"/source\", (c) => c.redirect(val.links.self.val));\n\n\tapp.get(\"/\", async (c) => {\n\t\tconst status = c.req.query(\"status\");\n\t\tconst assignee = c.req.query(\"assignee\");\n\t\tconst search = c.req.query(\"search\");\n\t\tconst issues = await store.listIssues({\n\t\t\tstatus: ISSUE_STATUSES.includes(status as IssueStatus)\n\t\t\t\t? (status as IssueStatus)\n\t\t\t\t: undefined,\n\t\t\tassignee: assignee?.replace(/^@/, \"\") || undefined,\n\t\t\tsearch: search || undefined,\n\t\t});\n\t\treturn c.html(\n\t\t\t,\n\t\t);\n\t});\n\n\tapp.get(\"/new\", async (c) => {\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\treturn c.html(\n\t\t\t,\n\t\t);\n\t});\n\n\tapp.post(\"/new\", async (c) => {\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst form = await c.req.formData();\n\t\tconst issueTitle = String(form.get(\"title\") ?? \"\").trim();\n\t\tif (!issueTitle) {\n\t\t\treturn c.html(\n\t\t\t\t,\n\t\t\t\t400,\n\t\t\t);\n\t\t}\n\t\tconst id = await store.createIssue({\n\t\t\ttitle: issueTitle,\n\t\t\tbody: String(form.get(\"body\") ?? \"\"),\n\t\t\tactor,\n\t\t});\n\t\tfor (const value of form.getAll(\"label_id\")) {\n\t\t\tconst labelId = Number(value);\n\t\t\tif (Number.isInteger(labelId)) await store.addLabel(id, labelId, actor);\n\t\t}\n\t\tfor (const handle of handles(form.get(\"assignees\"))) {\n\t\t\tawait store.addAssignee(id, handle, actor);\n\t\t}\n\t\treturn c.redirect(`/issue/${id}`);\n\t});\n\n\tapp.get(\"/issue/:id\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst user = c.get(\"user\") ?? null;\n\t\tconst canManage =\n\t\t\tc.get(\"role\") === \"maintainer\" ||\n\t\t\t(c.get(\"role\") === \"contributor\" && user === issue.creator);\n\t\treturn c.html(\n\t\t\t,\n\t\t);\n\t});\n\n\tapp.get(\"/issue/:id/edit\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\treturn c.html(\n\t\t\t,\n\t\t);\n\t});\n\n\tapp.post(\"/issue/:id/edit\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst form = await c.req.formData();\n\t\tconst issueTitle = String(form.get(\"title\") ?? \"\").trim();\n\t\tif (!issueTitle) {\n\t\t\treturn c.html(\n\t\t\t\t,\n\t\t\t\t400,\n\t\t\t);\n\t\t}\n\t\tawait store.updateIssue(\n\t\t\tissue.id,\n\t\t\t{\n\t\t\t\ttitle: issueTitle,\n\t\t\t\tbody: String(form.get(\"body\") ?? \"\"),\n\t\t\t},\n\t\t\tactor,\n\t\t);\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/issue/:id/close\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst reason = String(\n\t\t\t(await c.req.formData()).get(\"reason\") ?? \"completed\",\n\t\t);\n\t\tif (!CLOSED_STATE_REASONS.includes(reason as ClosedStateReason)) {\n\t\t\tthrow new Error(\"Invalid close reason.\");\n\t\t}\n\t\tawait store.closeIssue(issue.id, actor, reason as ClosedStateReason);\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/issue/:id/reopen\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\tawait store.reopenIssue(issue.id, actor);\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/issue/:id/label\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst form = await c.req.formData();\n\t\tconst labelId = Number(form.get(\"label_id\"));\n\t\tif (form.get(\"action\") === \"remove\") {\n\t\t\tawait store.removeLabel(issue.id, labelId, actor);\n\t\t} else await store.addLabel(issue.id, labelId, actor);\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/issue/:id/assignee\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst form = await c.req.formData();\n\t\tconst handle = String(form.get(\"handle\") ?? \"\")\n\t\t\t.trim()\n\t\t\t.replace(/^@/, \"\");\n\t\tif (handle) {\n\t\t\tif (form.get(\"action\") === \"remove\") {\n\t\t\t\tawait store.removeAssignee(issue.id, handle, actor);\n\t\t\t} else await store.addAssignee(issue.id, handle, actor);\n\t\t}\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/issue/:id/block\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = await manager(c, issue);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst form = await c.req.formData();\n\t\tconst otherId = Number(form.get(\"other_id\"));\n\t\tconst direction =\n\t\t\tform.get(\"direction\") === \"blocked_by\" ? \"blocked_by\" : \"blocks\";\n\t\tif (form.get(\"action\") === \"remove\") {\n\t\t\tawait store.removeBlock(issue.id, otherId, direction, actor);\n\t\t} else await store.addBlock(issue.id, otherId, direction, actor);\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/issue/:id/comment\", async (c) => {\n\t\tconst issue = await issueFor(c);\n\t\tif (issue instanceof Response) return issue;\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst body = String((await c.req.formData()).get(\"body\") ?? \"\");\n\t\tif (body.trim()) {\n\t\t\tawait store.createComment({ issueId: issue.id, body, actor });\n\t\t}\n\t\treturn c.redirect(`/issue/${issue.id}`);\n\t});\n\n\tapp.post(\"/comment/:commentId/edit\", async (c) => {\n\t\tconst id = Number(c.req.param(\"commentId\"));\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst comment = await store.getComment(id);\n\t\tif (!comment) return c.redirect(\"/\");\n\t\tif (c.get(\"role\") !== \"maintainer\" && actor !== comment.author) {\n\t\t\treturn await forbidden(\n\t\t\t\tc,\n\t\t\t\t\"Only the comment's author or a maintainer can perform this action.\",\n\t\t\t);\n\t\t}\n\t\tconst body = String((await c.req.formData()).get(\"body\") ?? \"\");\n\t\tif (body.trim()) await store.updateComment(id, body, actor);\n\t\treturn c.redirect(c.req.header(\"Referer\") ?? \"/\");\n\t});\n\n\tapp.post(\"/comment/:commentId/delete\", async (c) => {\n\t\tconst actor = contributor(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst id = Number(c.req.param(\"commentId\"));\n\t\tconst comment = await store.getComment(id);\n\t\tif (!comment) return c.redirect(\"/\");\n\t\tif (c.get(\"role\") !== \"maintainer\" && actor !== comment.author) {\n\t\t\treturn await forbidden(\n\t\t\t\tc,\n\t\t\t\t\"Only the comment's author or a maintainer can perform this action.\",\n\t\t\t);\n\t\t}\n\t\tawait store.deleteComment(id, actor);\n\t\treturn c.redirect(c.req.header(\"Referer\") ?? \"/\");\n\t});\n\n\tapp.post(\"/issue/:id/delete\", async (c) => {\n\t\tconst actor = await maintainer(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tawait store.deleteIssue(Number(c.req.param(\"id\")), actor);\n\t\treturn c.redirect(\"/\");\n\t});\n\n\tapp.get(\"/labels\", async (c) =>\n\t\tc.html(\n\t\t\t,\n\t\t),\n\t);\n\tapp.post(\"/labels\", async (c) => {\n\t\tconst actor = await maintainer(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst form = await c.req.formData();\n\t\tawait store.createLabel({\n\t\t\tname: String(form.get(\"name\") ?? \"\").trim(),\n\t\t\tcolor: String(form.get(\"color\") ?? \"\")\n\t\t\t\t.trim()\n\t\t\t\t.replace(/^#/, \"\"),\n\t\t\tactor,\n\t\t});\n\t\treturn c.redirect(\"/labels\");\n\t});\n\tapp.post(\"/labels/:id\", async (c) => {\n\t\tconst actor = await maintainer(c);\n\t\tif (actor instanceof Response) return actor;\n\t\tconst id = Number(c.req.param(\"id\"));\n\t\tconst form = await c.req.formData();\n\t\tif (form.get(\"action\") === \"delete\") await store.deleteLabel(id, actor);\n\t\telse {\n\t\t\tawait store.updateLabel(\n\t\t\t\tid,\n\t\t\t\t{\n\t\t\t\t\tname: String(form.get(\"name\") ?? \"\").trim(),\n\t\t\t\t\tcolor: String(form.get(\"color\") ?? \"\")\n\t\t\t\t\t\t.trim()\n\t\t\t\t\t\t.replace(/^#/, \"\"),\n\t\t\t\t},\n\t\t\t\tactor,\n\t\t\t);\n\t\t}\n\t\treturn c.redirect(\"/labels\");\n\t});\n\n\treturn auth ? oauthMiddleware(app.fetch) : app.fetch;\n}\n\nexport default createIssueTracker;\n",[245],"a0fc019a-4e40-4936-83f9-5f0f33129a27","api_test.ts","2c47603c-7c0d-11f1-9ca3-1607ee4eb77e",193,["D",1783695484073],"import { assertEquals } from \"jsr:@std/assert@1.0.19\";\nimport { createApi } from \"./api.ts\";\nimport { createIssueStore } from \"./db.ts\";\nimport { createTestSqlite } from \"./test_sqlite.ts\";\n\nDeno.test(\"JSON API drives lifecycle, labels, assignees, blocks, and comments\", async () => {\n\tconst store = createIssueStore(createTestSqlite());\n\tconst api = createApi(\"secret\", store);\n\tconst request = async (path: string, method = \"GET\", body?: unknown) => {\n\t\tconst response = await api.request(path, {\n\t\t\tmethod,\n\t\t\theaders: body\n\t\t\t\t? { Authorization: \"Bearer secret\", \"Content-Type\": \"application/json\" }\n\t\t\t\t: undefined,\n\t\t\tbody: body ? JSON.stringify(body) : undefined,\n\t\t});\n\t\treturn { status: response.status, json: await response.json() };\n\t};\n\n\tconst labels = (await request(\"/labels\")).json as Array<{\n\t\tid: number;\n\t\tname: string;\n\t}>;\n\tconst bugId = labels.find((label) => label.name === \"bug\")?.id ?? 0;\n\tconst first = await request(\"/issues\", \"POST\", {\n\t\ttitle: \"First\",\n\t\tbody: \" body\\n\",\n\t\tlabel_ids: [bugId],\n\t\tassignees: [\"alice\"],\n\t\tactor: \"owner\",\n\t});\n\tassertEquals(first.status, 201);\n\tassertEquals((first.json as { body: string }).body, \" body\\n\");\n\tassertEquals((first.json as { labels: unknown[] }).labels.length, 1);\n\tassertEquals((first.json as { assignees: string[] }).assignees, [\"alice\"]);\n\tconst firstId = (first.json as { id: number }).id;\n\tconst second = await request(\"/issues\", \"POST\", {\n\t\ttitle: \"Second\",\n\t\tactor: \"owner\",\n\t});\n\tconst secondId = (second.json as { id: number }).id;\n\n\tconst closed = await request(`/issues/${firstId}/close`, \"POST\", {\n\t\treason: \"not_planned\",\n\t\tactor: \"owner\",\n\t});\n\tassertEquals(\n\t\t{\n\t\t\tstatus: (closed.json as { status: string }).status,\n\t\t\tstate_reason: (closed.json as { state_reason: string }).state_reason,\n\t\t},\n\t\t{ status: \"closed\", state_reason: \"not_planned\" },\n\t);\n\tconst reopened = await request(`/issues/${firstId}/reopen`, \"POST\", {\n\t\tactor: \"owner\",\n\t});\n\tassertEquals(\n\t\t{\n\t\t\tstatus: (reopened.json as { status: string }).status,\n\t\t\tstate_reason: (reopened.json as { state_reason: string }).state_reason,\n\t\t},\n\t\t{ status: \"open\", state_reason: \"reopened\" },\n\t);\n\tassertEquals(\n\t\t(\n\t\t\tawait request(`/issues/${firstId}/close`, \"POST\", {\n\t\t\t\treason: \"typo\",\n\t\t\t\tactor: \"owner\",\n\t\t\t})\n\t\t).status,\n\t\t400,\n\t);\n\n\tawait request(`/issues/${firstId}/labels`, \"POST\", {\n\t\tremove: [bugId],\n\t\tactor: \"owner\",\n\t});\n\tawait request(`/issues/${firstId}/assignees`, \"POST\", {\n\t\tadd: [\"bob\"],\n\t\tremove: [\"alice\"],\n\t\tactor: \"owner\",\n\t});\n\tawait request(`/issues/${firstId}/blocks`, \"POST\", {\n\t\tadd: [secondId],\n\t\tactor: \"owner\",\n\t});\n\tconst comment = await request(`/issues/${firstId}/comments`, \"POST\", {\n\t\tbody: \" note\\n\",\n\t\tactor: \"owner\",\n\t});\n\tassertEquals(comment.status, 201);\n\tconst commentId = (comment.json as { id: number }).id;\n\tawait request(`/comments/${commentId}`, \"PATCH\", {\n\t\tbody: \" edited note\\n\",\n\t\tactor: \"owner\",\n\t});\n\tconst fetched = await request(`/issues/${firstId}`);\n\tassertEquals((fetched.json as { labels: unknown[] }).labels, []);\n\tassertEquals((fetched.json as { assignees: string[] }).assignees, [\"bob\"]);\n\tassertEquals(\n\t\t(fetched.json as { blocks: Array<{ id: number }> }).blocks[0].id,\n\t\tsecondId,\n\t);\n\tassertEquals(\n\t\t(fetched.json as { comments: Array<{ body: string }> }).comments[0].body,\n\t\t\" edited note\\n\",\n\t);\n\tawait request(`/comments/${commentId}`, \"DELETE\", { actor: \"owner\" });\n\tassertEquals(\n\t\t((await request(`/issues/${firstId}`)).json as { comments: unknown[] })\n\t\t\t.comments,\n\t\t[],\n\t);\n});",[253],"07ecd735-7833-460c-9f61-b6d76bdbf2f6","api.ts","4e80ef48-7be4-11f1-9a45-1607ee4eb77e",190,["D",1783695440622],"/**\n * Agent-facing JSON API. Reads are public; writes require the configured\n * bearer token. Actors are Val Town handles carried only by event records.\n */\nimport { Hono } from \"npm:hono@4.6.14\";\nimport {\n\tCLOSED_STATE_REASONS,\n\ttype ClosedStateReason,\n\tdefaultIssueStore,\n\tISSUE_STATUSES,\n\ttype IssueStatus,\n\ttype IssueStore,\n} from \"./db.ts\";\n\n// biome-ignore lint/suspicious/noExplicitAny: request JSON is validated field by field\ntype Body = Record;\ntype ApiEnv = { Variables: { actor: string; body: Body } };\n\nfunction stringField(body: Body, key: string): string | undefined {\n\treturn typeof body[key] === \"string\" ? body[key].trim() : undefined;\n}\n\nfunction rawStringField(body: Body, key: string): string | undefined {\n\treturn typeof body[key] === \"string\" ? body[key] : undefined;\n}\n\nfunction stringArrayField(body: Body, key: string): string[] {\n\treturn Array.isArray(body[key])\n\t\t? body[key]\n\t\t\t\t.filter((value: unknown): value is string => typeof value === \"string\")\n\t\t\t\t.map((value: string) => value.trim().replace(/^@/, \"\"))\n\t\t\t\t.filter(Boolean)\n\t\t: [];\n}\n\nfunction numberArrayField(body: Body, key: string): number[] {\n\treturn Array.isArray(body[key])\n\t\t? body[key]\n\t\t\t\t.map((value: unknown) => Number(value))\n\t\t\t\t.filter((value: number) => Number.isInteger(value) && value > 0)\n\t\t: [];\n}\n\nfunction idParam(value: string): number | null {\n\tconst id = Number(value);\n\treturn Number.isInteger(id) && id > 0 ? id : null;\n}\n\nexport function createApi(\n\tapiKey: string | undefined,\n\tstore: IssueStore = defaultIssueStore,\n) {\n\tconst api = new Hono();\n\n\tapi.onError((error, c) => c.json({ error: error.message }, 409));\n\tapi.use(\"*\", async (_c, next) => {\n\t\tawait store.initSchema();\n\t\tawait next();\n\t});\n\tapi.use(\"*\", async (c, next) => {\n\t\tif (c.req.method === \"GET\") return await next();\n\t\tif (!apiKey) {\n\t\t\treturn c.json(\n\t\t\t\t{\n\t\t\t\t\terror: \"API writes are disabled: ISSUE_TRACKER_API_KEY is not set.\",\n\t\t\t\t},\n\t\t\t\t403,\n\t\t\t);\n\t\t}\n\t\tconst token = (c.req.header(\"Authorization\") ?? \"\").replace(\n\t\t\t/^Bearer\\s+/i,\n\t\t\t\"\",\n\t\t);\n\t\tif (token !== apiKey) {\n\t\t\treturn c.json({ error: \"Invalid or missing API key.\" }, 401);\n\t\t}\n\t\tconst body: Body = await c.req.json().catch(() => ({}));\n\t\tc.set(\"body\", body);\n\t\tc.set(\"actor\", stringField(body, \"actor\") || \"agent\");\n\t\tawait next();\n\t});\n\n\tapi.get(\"/issues\", async (c) => {\n\t\tconst status = c.req.query(\"status\");\n\t\treturn c.json(\n\t\t\tawait store.listIssues({\n\t\t\t\tstatus: ISSUE_STATUSES.includes(status as IssueStatus)\n\t\t\t\t\t? (status as IssueStatus)\n\t\t\t\t\t: undefined,\n\t\t\t\tlabel: c.req.query(\"label\") || undefined,\n\t\t\t\tassignee: c.req.query(\"assignee\")?.replace(/^@/, \"\") || undefined,\n\t\t\t\tsearch: c.req.query(\"search\") || undefined,\n\t\t\t}),\n\t\t);\n\t});\n\n\tapi.post(\"/issues\", async (c) => {\n\t\tconst body = c.get(\"body\");\n\t\tconst title = stringField(body, \"title\");\n\t\tif (!title) return c.json({ error: \"title is required.\" }, 400);\n\t\tconst labelIds = numberArrayField(body, \"label_ids\");\n\t\tfor (const labelId of labelIds) {\n\t\t\tif (!(await store.getLabel(labelId))) {\n\t\t\t\treturn c.json({ error: `Label #${labelId} not found.` }, 400);\n\t\t\t}\n\t\t}\n\t\tconst id = await store.createIssue({\n\t\t\ttitle,\n\t\t\tbody: rawStringField(body, \"body\") ?? \"\",\n\t\t\tactor: c.get(\"actor\"),\n\t\t});\n\t\tfor (const labelId of labelIds) {\n\t\t\tawait store.addLabel(id, labelId, c.get(\"actor\"));\n\t\t}\n\t\tfor (const handle of stringArrayField(body, \"assignees\")) {\n\t\t\tawait store.addAssignee(id, handle, c.get(\"actor\"));\n\t\t}\n\t\treturn c.json(await store.getIssue(id), 201);\n\t});\n\n\tapi.get(\"/issues/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tconst issue = await store.getIssue(id);\n\t\tif (!issue) return c.json({ error: `Issue #${id} not found.` }, 404);\n\t\treturn c.json({ ...issue, comments: await store.listComments(id) });\n\t});\n\n\tapi.patch(\"/issues/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tif (!(await store.getIssue(id))) {\n\t\t\treturn c.json({ error: `Issue #${id} not found.` }, 404);\n\t\t}\n\t\tconst body = c.get(\"body\");\n\t\tawait store.updateIssue(\n\t\t\tid,\n\t\t\t{\n\t\t\t\t...(stringField(body, \"title\") !== undefined\n\t\t\t\t\t? { title: stringField(body, \"title\") }\n\t\t\t\t\t: {}),\n\t\t\t\t...(rawStringField(body, \"body\") !== undefined\n\t\t\t\t\t? { body: rawStringField(body, \"body\") }\n\t\t\t\t\t: {}),\n\t\t\t},\n\t\t\tc.get(\"actor\"),\n\t\t);\n\t\treturn c.json(await store.getIssue(id));\n\t});\n\n\tapi.delete(\"/issues/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tawait store.deleteIssue(id, c.get(\"actor\"));\n\t\treturn c.json({ deleted: id });\n\t});\n\n\tapi.post(\"/issues/:id/close\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tif (!(await store.getIssue(id))) {\n\t\t\treturn c.json({ error: `Issue #${id} not found.` }, 404);\n\t\t}\n\t\tconst body = c.get(\"body\");\n\t\tif (\n\t\t\tbody.reason !== undefined &&\n\t\t\t!CLOSED_STATE_REASONS.includes(body.reason)\n\t\t) {\n\t\t\treturn c.json({ error: \"invalid close reason\" }, 400);\n\t\t}\n\t\tconst reason: ClosedStateReason = body.reason ?? \"completed\";\n\t\tconst comment = rawStringField(body, \"comment\");\n\t\tif (comment?.trim()) {\n\t\t\tawait store.createComment({\n\t\t\t\tissueId: id,\n\t\t\t\tbody: comment,\n\t\t\t\tactor: c.get(\"actor\"),\n\t\t\t});\n\t\t}\n\t\tawait store.closeIssue(id, c.get(\"actor\"), reason);\n\t\treturn c.json(await store.getIssue(id));\n\t});\n\n\tapi.post(\"/issues/:id/reopen\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tif (!(await store.getIssue(id))) {\n\t\t\treturn c.json({ error: `Issue #${id} not found.` }, 404);\n\t\t}\n\t\tawait store.reopenIssue(id, c.get(\"actor\"));\n\t\treturn c.json(await store.getIssue(id));\n\t});\n\n\tapi.post(\"/issues/:id/labels\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tconst body = c.get(\"body\");\n\t\tfor (const labelId of numberArrayField(body, \"remove\")) {\n\t\t\tawait store.removeLabel(id, labelId, c.get(\"actor\"));\n\t\t}\n\t\tfor (const labelId of numberArrayField(body, \"add\")) {\n\t\t\tawait store.addLabel(id, labelId, c.get(\"actor\"));\n\t\t}\n\t\treturn c.json(await store.getIssue(id));\n\t});\n\n\tapi.post(\"/issues/:id/assignees\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tconst body = c.get(\"body\");\n\t\tfor (const handle of stringArrayField(body, \"remove\")) {\n\t\t\tawait store.removeAssignee(id, handle, c.get(\"actor\"));\n\t\t}\n\t\tfor (const handle of stringArrayField(body, \"add\")) {\n\t\t\tawait store.addAssignee(id, handle, c.get(\"actor\"));\n\t\t}\n\t\treturn c.json(await store.getIssue(id));\n\t});\n\n\tfor (const [path, direction] of [\n\t\t[\"blocks\", \"blocks\"],\n\t\t[\"blocked-by\", \"blocked_by\"],\n\t] as const) {\n\t\tapi.post(`/issues/:id/${path}`, async (c) => {\n\t\t\tconst id = idParam(c.req.param(\"id\"));\n\t\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\t\tconst body = c.get(\"body\");\n\t\t\tfor (const otherId of numberArrayField(body, \"remove\")) {\n\t\t\t\tawait store.removeBlock(id, otherId, direction, c.get(\"actor\"));\n\t\t\t}\n\t\t\tfor (const otherId of numberArrayField(body, \"add\")) {\n\t\t\t\tawait store.addBlock(id, otherId, direction, c.get(\"actor\"));\n\t\t\t}\n\t\t\treturn c.json(await store.getIssue(id));\n\t\t});\n\t}\n\n\tapi.post(\"/issues/:id/comments\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tif (!(await store.getIssue(id))) {\n\t\t\treturn c.json({ error: `Issue #${id} not found.` }, 404);\n\t\t}\n\t\tconst body = rawStringField(c.get(\"body\"), \"body\");\n\t\tif (!body?.trim()) return c.json({ error: \"body is required.\" }, 400);\n\t\tconst commentId = await store.createComment({\n\t\t\tissueId: id,\n\t\t\tbody,\n\t\t\tactor: c.get(\"actor\"),\n\t\t});\n\t\treturn c.json(\n\t\t\t(await store.listComments(id)).find(\n\t\t\t\t(comment) => comment.id === commentId,\n\t\t\t),\n\t\t\t201,\n\t\t);\n\t});\n\n\tapi.patch(\"/comments/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tconst body = rawStringField(c.get(\"body\"), \"body\");\n\t\tif (!body?.trim()) return c.json({ error: \"body is required.\" }, 400);\n\t\tawait store.updateComment(id, body, c.get(\"actor\"));\n\t\treturn c.json({ updated: id });\n\t});\n\n\tapi.delete(\"/comments/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tawait store.deleteComment(id, c.get(\"actor\"));\n\t\treturn c.json({ deleted: id });\n\t});\n\n\tapi.get(\"/issues/:id/events\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\treturn c.json(await store.listEvents({ entity: \"issue\", entityId: id }));\n\t});\n\n\tapi.get(\"/labels\", async (c) => c.json(await store.listLabels()));\n\tapi.post(\"/labels\", async (c) => {\n\t\tconst body = c.get(\"body\");\n\t\tconst name = stringField(body, \"name\");\n\t\tconst color = stringField(body, \"color\");\n\t\tif (!name || !color) {\n\t\t\treturn c.json({ error: \"name and color are required.\" }, 400);\n\t\t}\n\t\tconst id = await store.createLabel({\n\t\t\tname,\n\t\t\tcolor: color.replace(/^#/, \"\"),\n\t\t\tactor: c.get(\"actor\"),\n\t\t});\n\t\treturn c.json(await store.getLabel(id), 201);\n\t});\n\tapi.patch(\"/labels/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tconst body = c.get(\"body\");\n\t\tawait store.updateLabel(\n\t\t\tid,\n\t\t\t{\n\t\t\t\t...(stringField(body, \"name\") !== undefined\n\t\t\t\t\t? { name: stringField(body, \"name\") }\n\t\t\t\t\t: {}),\n\t\t\t\t...(stringField(body, \"color\") !== undefined\n\t\t\t\t\t? { color: stringField(body, \"color\")?.replace(/^#/, \"\") }\n\t\t\t\t\t: {}),\n\t\t\t},\n\t\t\tc.get(\"actor\"),\n\t\t);\n\t\treturn c.json(await store.getLabel(id));\n\t});\n\tapi.delete(\"/labels/:id\", async (c) => {\n\t\tconst id = idParam(c.req.param(\"id\"));\n\t\tif (!id) return c.json({ error: \"invalid id\" }, 400);\n\t\tawait store.deleteLabel(id, c.get(\"actor\"));\n\t\treturn c.json({ deleted: id });\n\t});\n\n\treturn api;\n}\n",[260],"74c4fa0b-cb42-4cee-bf67-c9ecfd6c0577","README.md","dae70d12-7b3c-11f1-b278-1607ee4eb77e",176,["D",1783653143043],17,"# val-issue-tracker\n\nA lightweight GitHub-flavoured issue tracker for Val Town's scoped SQLite\n(`std/sqlite/main.ts`). It is a drop-in Hono app: imports execute against the\nhost val's database, and all tables use the `issue_tracker_*` prefix.\n\n```ts\nimport { createIssueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n\nexport default createIssueTracker({\n maintainers: [\"afriend\"],\n apiKey: Deno.env.get(\"ISSUE_TRACKER_API_KEY\"),\n});\n```\n\nThe running val's owner is always a maintainer. Public reads, Val Town OAuth,\nand the visible `/source` redirect remain built in.\n\n## Options\n\n| Option | Meaning |\n| ------------- | --------------------------------------------------------------------- |\n| `maintainers` | Additional Val Town handles with maintainer access |\n| `owner` | Deprecated alias for `maintainers` |\n| `defaultRole` | `contributor` (default) or `viewer` for other logged-in users |\n| `auth` | Val Town OAuth when `true` (default); fully open tracker when `false` |\n| `title` | Header and browser title |\n| `apiKey` | Bearer token for JSON writes; defaults to `ISSUE_TRACKER_API_KEY` |\n\nWith auth enabled, viewers can read; contributors can create/comment and manage\nissues they created; maintainers can manage all issues, labels, and deletions.\n\n## Data model\n\n- Issues have `title`, markdown-text `body`, `open`/`closed` status, and an\n auto-managed `state_reason`.\n- Labels are curated name/colour entities and are applied through a join table.\n- Assignees are a set of Val Town handles.\n- Blocking edges form a strict DAG; `blocked` is derived from open blockers.\n- Comments are editable entities.\n- An append-only events table is the sole provenance/history source. Live\n entities retain current state and timestamps only; relationship rows are bare\n tuples.\n- Fresh installs seed `bug`, `enhancement`, `documentation`, `question`, and\n `duplicate` exactly once.\n\nSchema initialization is idempotent and runs on requests. It also migrates the\nold tracker schema: `description → body`, priority removal,\n`in_progress → open`, JSON labels and single assignee lifted into joins, and\nsynthetic creation events.\n\n## JSON API\n\nReads under `/api` are public. Writes require `Authorization: Bearer `.\nThe main operations are:\n\n| Method and path | Purpose |\n| ---------------------------------- | ----------------------------------------------------- |\n| `GET/POST /api/issues` | List/filter or create issues |\n| `GET/PATCH/DELETE /api/issues/:id` | Read, edit, or hard-delete an issue |\n| `POST /api/issues/:id/close` | Close with `completed`, `not_planned`, or `duplicate` |\n| `POST /api/issues/:id/reopen` | Reopen |\n| `POST /api/issues/:id/labels` | Apply/remove label IDs |\n| `POST /api/issues/:id/assignees` | Assign/unassign handles |\n| `POST /api/issues/:id/blocks` | Add/remove issues this issue blocks |\n| `POST /api/issues/:id/blocked-by` | Add/remove blockers |\n| `POST /api/issues/:id/comments` | Comment |\n| `PATCH/DELETE /api/comments/:id` | Edit/delete a comment |\n| `GET/POST /api/labels` | List/create labels |\n| `PATCH/DELETE /api/labels/:id` | Edit/delete a label |\n\nSee [docs/issue-tracker-valtown.md](./docs/issue-tracker-valtown.md) for the\nexact request and response convention.\n\n## Development\n\n```bash\nVAL_TOWN_API_KEY=test deno test \\\n --allow-env=VAL_TOWN_API_KEY \\\n --allow-import=esm.town,www.val.town,esm.sh\n\nVAL_TOWN_API_KEY=test deno check \\\n --allow-import=esm.town,www.val.town,esm.sh \\\n main.ts mod.ts api.ts app.tsx components.tsx ui.tsx layout.tsx db.ts\n\ndeno fmt --check\n```\n\nThe focused test suite uses Deno's SQLite-compatible in-memory driver; it never\nwrites a database file.\n\n## Files\n\n- `db.ts` — schema, migration, domain operations, and default Val Town store.\n- `api.ts` — bearer-authenticated Hono JSON API.\n- `app.tsx` — OAuth/permissions and HTML form routes.\n- `components.tsx`, `ui.tsx`, `layout.tsx` — server-rendered Hono TSX.\n- `mod.ts` — reusable public entry point.\n- `main.ts` — this val's own consumer.\n",[267],"4b5bc25e-37dd-4bde-b7e5-7ac709b87c19","CONTEXT.md","eee9abe2-7bf2-11f1-803f-1607ee4eb77e",163,["D",1783653141344],"# Context — Val Issue Tracker\n\nA GitHub-flavored issue tracker, designed as a **drop-in library**: it is\nimported into any Val Town project and uses that host val's scoped SQLite\ndatabase. Table names are prefixed (`issue_tracker_*`) to avoid colliding with\nthe host's tables.\n\n## Glossary\n\n### Issue\n\nThe core unit of work. Has a title, a markdown **body** (renamed from\n`description` to match Comment and GitHub — one word, \"body\", for \"the markdown\nprose of this thing\"), a status, and metadata (creator, timestamps). Modeled\nafter a GitHub issue.\n\n### Body\n\nThe markdown prose of an Issue or a Comment. Stored as plain `TEXT`; \"it is\nmarkdown\" is a rendering contract, not a storage concern (see docs/backlog.md).\n\n### Status\n\nAn issue's lifecycle state. Exactly two values: **`open`** and **`closed`**.\nThere is no `in_progress` (removed). This mirrors GitHub, where \"not planned\" is\n_not_ a third state — see State Reason.\n\n### State Reason\n\nA nullable qualifier explaining _why_ an issue holds its current status,\nmirroring GitHub's `state_reason`. Values: `completed`, `not_planned`,\n`duplicate` (pair with `closed`), `reopened` (pairs with `open`), or `null`.\nThis is what distinguishes \"closed because done\" from \"closed because\nabandoned\". It is **auto-managed**, never set freely: creating leaves it `null`;\nclosing sets the chosen reason (`completed` default); reopening forces\n`reopened` (which distinguishes a reopened issue from a never-closed one). Valid\npairings — `open` with `null`/`reopened`, `closed` with\n`completed`/`not_planned`/`duplicate` — are guarded by a SQLite `CHECK`\nconstraint.\n\n### User (identity)\n\nAny actor — creator, comment author, assignee — is a **Val Town user**. There is\nno local users table; anyone who can make changes is logged in via Val Town\nauth. Identity is carried as the Val Town **handle** (username), not a stable id\n— renames are rare and human-readable handles need no lookup. Handles should\neventually render as links to the user's Val Town profile (see docs/backlog.md).\n\n### Assignee\n\nThe Val Town user(s) responsible for an issue. Multi-valued (a set), not single\n— an issue may have zero or more assignees. An assignee is _not_ an entity, just\na link between an issue and an existing Val Town user, stored as a bare join\ntuple (`issue_tracker_issue_assignees(issue_id, user_handle)`). Who assigned\nwhom, and when, lives in the events log — not on the row.\n\n### Comment\n\nA markdown note attached to an issue. An entity — editable, and keeps\n`created_at` + `updated_at` columns. Who authored/edited it is _not_ a column;\nthe actor is derived from the events log (the old `author` column is gone). See\nADR 0003 and ADR 0004.\n\n### Entity vs Link\n\nAn **entity** (Issue, Comment, Label) is user-authored and editable. It keeps\n`created_at` + `updated_at` as denormalized columns (needed for hot-path listing\nand \"last activity\" sorting); the **actor** behind each create/update (`*_by`)\nis _not_ stored — it is derived from the events log. A **link** (the assignee\nand block join rows) is a **bare relationship tuple** — `(issue_id, label_id)`,\n`(issue_id,\nuser_handle)`, `(blocker_id, blocked_id)` — with no audit columns at\nall; its full provenance lives in events. See ADR 0003 (amended) and ADR 0004.\n\n### Label\n\nA reusable, curated tag — a first-class entity with a unique `name` and a\n`color`, living in `issue_tracker_labels`. Applied to issues via a join\n(`issue_tracker_issue_labels`); applying means picking an existing label, not\ntyping free-form text. Deleting a label is allowed even when in use — the join\nrows cascade away and the tagged issues simply lose that label. A default set\n(`bug`, `enhancement`, `documentation`, `question`, `duplicate`) is seeded\n**once, when the labels table is first created** — never re-seeded, so user\ndeletions survive (see ADR 0001).\n\n### Blocking relationship\n\nA directed dependency between two issues in the same tracker: \"A blocks B\" means\nB depends on A. Stored as one directed edge in\n`issue_tracker_issue_blocks(blocker_id,\nblocked_id)`; \"blocks\" and \"blocked by\"\nare the same edge read from opposite ends. The block graph is a strict DAG:\n**any** edge that would create a cycle is rejected — self-edges, direct\nreciprocals (A↔B), and longer loops (A→B→C→A) alike. This is stricter than\nGitHub (which permits longer cycles) and is enforced with a reachability check\non insert (see ADR 0002).\n\n### Touch (updated_at)\n\nMutating an issue's associations — adding/removing a label, an assignee, or a\nblock edge, or adding a comment — updates that issue's `updated_at`, exactly as\nediting the issue itself does. `updated_at` reflects \"last activity on this\nissue\", not just edits to its own columns.\n\n### Blocked (derived)\n\nAn issue is _blocked_ iff at least one of its blockers is still `open`. This is\nnever stored — it is computed from the edges and the blockers' status, so\nclosing a blocker automatically unblocks its dependents. Blocked-ness is\ninformational: it does **not** prevent an issue from being closed.\n\n### Event\n\nAn append-only record of one change, in a single polymorphic table\n(`issue_tracker_events`): `id`, `event_type`, `entity_id`, `actor`, `data`,\n`event_timestamp`. `event_type` is `.` where entity ∈ {issue,\ncomment, label} and verb ∈ {created, updated, deleted}. The events log is the\n**source of truth for provenance and history**; live tables hold only current\nstate. Grammar:\n\n- **Boundary events snapshot full state.** `*.created` → the entity's full\n initial state; `*.deleted` → its full final state (so a hard-deleted row\n leaves a complete tombstone).\n- **`*.updated` carries a field delta:** `{ update_target, from, to }`.\n Associations are modelled as `issue.updated` with `update_target` ∈ {label,\n assignee, blocks, blocked_by} and `from`/`to` using **`null ↔ value`** (null→X\n = added, X→null = removed). A block edge writes **one** event, on the acting\n issue.\n\nOne event per changed field: closing an issue emits two events (`status` and\n`state_reason`), sharing one actor and timestamp. See ADR 0004.\n\n### Actor\n\nThe Val Town handle that performed a change, stored on each event. This is the\nonly place actor/provenance lives — entities and links do not carry `*_by`\ncolumns.\n\n## Removed / rejected\n\n- **Priority** — removed entirely. Faithful to GitHub, which has no first-class\n priority field (labels/Projects only).\n- **`in_progress` status** — removed; existing rows migrate to `open`.\n",[275],"97a698fa-af29-4782-923e-6567950652da","CLAUDE.md","eec4ed34-7bf2-11f1-9665-1607ee4eb77e",182,["D",1783653143490],"\n\n# Agent instructions — val-issue-tracker\n\n## Agent skills\n\n### Issue tracker\n\nLocal markdown under `docs/issues//` — issues/PRDs as files, no\nexternal PRs. See `docs/agents/issue-tracker.md`.\n\n### Triage labels\n\nFive canonical roles, default strings (`needs-triage`, `needs-info`,\n`ready-for-agent`, `ready-for-human`, `wontfix`). See\n`docs/agents/triage-labels.md`.\n\n### Domain docs\n\nSingle-context — root `CONTEXT.md` + `docs/adr/` (0001–0004). See\n`docs/agents/domain.md`.\n",[282],"2962acd1-da54-4800-a90a-07becc787602","AGENTS.md","eeb653e6-7bf2-11f1-9665-1607ee4eb77e",177,["D",1783653143220],[289],"054476e7-04a7-4b95-9e68-3276cca56df3",".vtignore","0a9d3ac6-7b43-11f1-a110-1607ee4eb77e",23,["D",1783566329616],".git\n.vscode\n.cursor\n.claude\n.DS_Store\nnode_modules\nvendor",[295],"a4f232e2-8ab1-4a5e-9634-5b86a0a15abd","docs","4e6ce2e6-7be4-11f1-9a45-1607ee4eb77e",128,["D",1783635592340],"directory",[302],"pulls","branches","forks","envVars",{"_315":61,"_317":61},"connections",{"_315":61,"_316":61},"count","unfilledCount","emptyCount",{"_41":301,"_31":302,"_29":303,"_152":-5,"_39":40,"_38":304,"_154":57,"_36":537,"_13":61,"_33":306,"_34":-5,"_23":24,"_159":-5,"_356":538,"_26":539},{"_41":532,"_31":507,"_29":501,"_152":303,"_39":40,"_38":533,"_154":57,"_36":534,"_13":61,"_33":306,"_34":-5,"_23":24,"_159":-5,"_356":535,"_26":536},{"_41":524,"_31":525,"_29":526,"_152":501,"_39":40,"_38":527,"_154":57,"_36":528,"_13":166,"_33":20,"_34":529,"_23":24,"_159":-5,"_356":530,"_26":531},{"_41":516,"_31":517,"_29":518,"_152":501,"_39":40,"_38":519,"_154":57,"_36":520,"_13":166,"_33":20,"_34":521,"_23":24,"_159":-5,"_356":522,"_26":523},{"_41":508,"_31":509,"_29":510,"_152":501,"_39":40,"_38":511,"_154":57,"_36":512,"_13":166,"_33":20,"_34":513,"_23":24,"_159":-5,"_356":514,"_26":515},{"_41":498,"_31":499,"_29":500,"_152":501,"_39":40,"_38":502,"_154":57,"_36":503,"_13":166,"_33":20,"_34":504,"_23":24,"_159":-5,"_356":505,"_26":506},{"_41":493,"_31":476,"_29":470,"_152":303,"_39":40,"_38":494,"_154":57,"_36":495,"_13":61,"_33":306,"_34":-5,"_23":24,"_159":-5,"_356":496,"_26":497},{"_41":485,"_31":486,"_29":487,"_152":470,"_39":40,"_38":488,"_154":57,"_36":489,"_13":166,"_33":20,"_34":490,"_23":24,"_159":-5,"_356":491,"_26":492},{"_41":477,"_31":478,"_29":479,"_152":470,"_39":40,"_38":480,"_154":24,"_36":481,"_13":166,"_33":20,"_34":482,"_23":24,"_159":-5,"_356":483,"_26":484},{"_41":467,"_31":468,"_29":469,"_152":470,"_39":40,"_38":471,"_154":57,"_36":472,"_13":166,"_33":20,"_34":473,"_23":24,"_159":-5,"_356":474,"_26":475},{"_41":462,"_31":442,"_29":457,"_152":303,"_39":40,"_38":463,"_154":57,"_36":464,"_13":61,"_33":306,"_34":-5,"_23":24,"_159":-5,"_356":465,"_26":466},{"_41":456,"_31":443,"_29":435,"_152":457,"_39":40,"_38":458,"_154":57,"_36":459,"_13":61,"_33":306,"_34":-5,"_23":24,"_159":-5,"_356":460,"_26":461},{"_41":448,"_31":449,"_29":450,"_152":435,"_39":40,"_38":451,"_154":24,"_36":452,"_13":438,"_33":20,"_34":453,"_23":24,"_159":-5,"_356":454,"_26":455},{"_41":444,"_31":32,"_29":30,"_152":435,"_39":40,"_38":14,"_154":24,"_36":445,"_13":61,"_33":20,"_34":35,"_23":24,"_159":-5,"_356":446,"_26":447},{"_41":432,"_31":433,"_29":434,"_152":435,"_39":40,"_38":436,"_154":24,"_36":437,"_13":438,"_33":20,"_34":439,"_23":24,"_159":-5,"_356":440,"_26":441},{"_41":424,"_31":425,"_29":426,"_152":303,"_39":40,"_38":427,"_154":24,"_36":428,"_13":166,"_33":20,"_34":429,"_23":24,"_159":-5,"_356":430,"_26":431},{"_41":416,"_31":417,"_29":418,"_152":303,"_39":40,"_38":419,"_154":24,"_36":420,"_13":166,"_33":20,"_34":421,"_23":24,"_159":-5,"_356":422,"_26":423},{"_41":294,"_31":295,"_29":296,"_152":-5,"_39":40,"_38":297,"_154":57,"_36":413,"_13":61,"_33":20,"_34":299,"_23":24,"_159":-5,"_356":414,"_26":415},{"_41":288,"_31":289,"_29":290,"_152":-5,"_39":40,"_38":291,"_154":24,"_36":410,"_13":166,"_33":20,"_34":286,"_23":24,"_159":-5,"_356":411,"_26":412},{"_41":281,"_31":282,"_29":283,"_152":-5,"_39":40,"_38":284,"_154":24,"_36":407,"_13":166,"_33":20,"_34":286,"_23":24,"_159":-5,"_356":408,"_26":409},{"_41":274,"_31":275,"_29":276,"_152":-5,"_39":40,"_38":277,"_154":24,"_36":404,"_13":166,"_33":20,"_34":279,"_23":24,"_159":-5,"_356":405,"_26":406},{"_41":266,"_31":267,"_29":268,"_152":-5,"_39":40,"_38":269,"_154":24,"_36":401,"_13":271,"_33":20,"_34":272,"_23":24,"_159":-5,"_356":402,"_26":403},{"_41":259,"_31":260,"_29":261,"_152":-5,"_39":40,"_38":262,"_154":24,"_36":398,"_13":190,"_33":157,"_34":264,"_23":24,"_159":-5,"_356":399,"_26":400},{"_41":252,"_31":253,"_29":254,"_152":-5,"_39":40,"_38":255,"_154":24,"_36":395,"_13":190,"_33":157,"_34":257,"_23":24,"_159":-5,"_356":396,"_26":397},{"_41":244,"_31":245,"_29":246,"_152":-5,"_39":40,"_38":247,"_154":24,"_36":392,"_13":249,"_33":157,"_34":250,"_23":24,"_159":-5,"_356":393,"_26":394},{"_41":237,"_31":238,"_29":239,"_152":-5,"_39":40,"_38":240,"_154":24,"_36":389,"_13":166,"_33":157,"_34":242,"_23":24,"_159":-5,"_356":390,"_26":391},{"_41":230,"_31":231,"_29":232,"_152":-5,"_39":40,"_38":233,"_154":24,"_36":386,"_13":166,"_33":20,"_34":235,"_23":24,"_159":-5,"_356":387,"_26":388},{"_41":222,"_31":223,"_29":224,"_152":-5,"_39":40,"_38":225,"_154":24,"_36":383,"_13":227,"_33":157,"_34":228,"_23":24,"_159":-5,"_356":384,"_26":385},{"_41":214,"_31":215,"_29":216,"_152":-5,"_39":40,"_38":217,"_154":24,"_36":380,"_13":219,"_33":157,"_34":220,"_23":24,"_159":-5,"_356":381,"_26":382},{"_41":207,"_31":208,"_29":209,"_152":-5,"_39":40,"_38":210,"_154":24,"_36":377,"_13":166,"_33":157,"_34":212,"_23":24,"_159":-5,"_356":378,"_26":379},{"_41":200,"_31":201,"_29":202,"_152":-5,"_39":40,"_38":203,"_154":24,"_36":374,"_13":190,"_33":20,"_34":205,"_23":24,"_159":-5,"_356":375,"_26":376},{"_41":193,"_31":194,"_29":195,"_152":-5,"_39":40,"_38":196,"_154":24,"_36":371,"_13":61,"_33":157,"_34":198,"_23":24,"_159":-5,"_356":372,"_26":373},{"_41":185,"_31":186,"_29":187,"_152":-5,"_39":40,"_38":188,"_154":24,"_36":368,"_13":190,"_33":157,"_34":191,"_23":24,"_159":-5,"_356":369,"_26":370},{"_41":177,"_31":178,"_29":55,"_152":-5,"_39":40,"_38":179,"_154":24,"_36":365,"_13":181,"_33":182,"_34":183,"_23":24,"_159":-5,"_356":366,"_26":367},{"_41":169,"_31":170,"_29":171,"_152":-5,"_39":40,"_38":172,"_154":24,"_36":362,"_13":174,"_33":157,"_34":175,"_23":24,"_159":-5,"_356":363,"_26":364},{"_41":161,"_31":162,"_29":163,"_152":-5,"_39":40,"_38":164,"_154":24,"_36":359,"_13":166,"_33":157,"_34":167,"_23":24,"_159":-5,"_356":360,"_26":361},{"_41":149,"_31":150,"_29":151,"_152":-5,"_39":40,"_38":153,"_154":24,"_36":355,"_13":156,"_33":157,"_34":158,"_23":24,"_159":-5,"_356":357,"_26":358},["D",1783653143543],"children",[],[150],["D",1783695440607],[],[162],["D",1783568883064],[],[170],["D",1783653141198],[],[178],["D",1783574315459],[],[186],["D",1783711960220],[],[194],["D",1783695440613],[],[201],["D",1783695440991],[],[208],["D",1783653143400],[],[215],["D",1783653143312],[],[223],["D",1783695441586],[],[231],["D",1783695441284],[],[238],["D",1783695440608],[],[245],["D",1783695484073],[],[253],["D",1783695440622],[],[260],["D",1783653143043],[],[267],["D",1783653141344],[],[275],["D",1783653143490],[],[282],["D",1783653143220],[],[289],["D",1783566329616],[],[295],"2e1ff68b-4ecf-4a77-b4fc-3aea84f4b6ab","issue-tracker-valtown.md","4e874dca-7be4-11f1-973a-1607ee4eb77e",172,["D",1783653142598],"# Issue tracker: val-issue-tracker (JSON API)\n\nUse the tracker's JSON API for agent and script operations; do not scrape HTML.\n\n**Tracker URL**: `` (for example `https://username-myval.web.val.run`)\n\n**Auth**: reads are public. Writes require\n`Authorization: Bearer `. Each write may include `actor`,\na Val Town handle; omitted actors default to `agent`. Actor provenance is stored\nonly in the append-only events log.\n\n## Issue shape\n\nIssues use GitHub-flavoured vocabulary:\n\n- `body`, not `description`; bodies are stored as markdown text but rendered as\n text.\n- `status` is exactly `open` or `closed`.\n- `state_reason` is `null` or `reopened` for open issues, and `completed`,\n `not_planned`, or `duplicate` for closed issues.\n- `labels` is an array of curated Label objects (`id`, `name`, `color`,\n timestamps).\n- `assignees` is an array of Val Town handles.\n- `blockers` and `blocks` are issue-reference arrays; `blocked` is derived from\n whether any blocker is open.\n- `creator` is derived from the issue's creation event. There are no actor\n columns on live entity or relationship tables.\n\n## Endpoints\n\n| Method and path | Body / query | Result |\n| --------------------------------- | -------------------------------------------------------------------------- | ---------------------------------------------------- |\n| `GET /api/issues` | `?status=&label=&assignee=&search=` | List enriched issues |\n| `POST /api/issues` | `{title, body?, label_ids?: number[], assignees?: string[], actor?}` | Create an open issue |\n| `GET /api/issues/:id` | — | Issue plus `comments` |\n| `PATCH /api/issues/:id` | `{title?, body?, actor?}` | Edit scalar fields |\n| `DELETE /api/issues/:id` | `{actor?}` | Hard-delete with tombstone event |\n| `POST /api/issues/:id/close` | `{reason?: \"completed\" \\| \"not_planned\" \\| \"duplicate\", comment?, actor?}` | Close; reason defaults to `completed` |\n| `POST /api/issues/:id/reopen` | `{actor?}` | Reopen with `state_reason: \"reopened\"` |\n| `POST /api/issues/:id/labels` | `{add?: number[], remove?: number[], actor?}` | Apply/remove curated label IDs |\n| `POST /api/issues/:id/assignees` | `{add?: string[], remove?: string[], actor?}` | Assign/unassign handles |\n| `POST /api/issues/:id/blocks` | `{add?: number[], remove?: number[], actor?}` | Make this issue block/unblock issue IDs |\n| `POST /api/issues/:id/blocked-by` | `{add?: number[], remove?: number[], actor?}` | Add/remove this issue's blockers |\n| `POST /api/issues/:id/comments` | `{body, actor?}` | Create a comment |\n| `PATCH /api/comments/:id` | `{body, actor?}` | Edit a comment |\n| `DELETE /api/comments/:id` | `{actor?}` | Hard-delete a comment with tombstone event |\n| `GET /api/issues/:id/events` | — | Issue events in append order |\n| `GET /api/labels` | — | List curated labels |\n| `POST /api/labels` | `{name, color, actor?}` | Create a label (`color` is hex, with or without `#`) |\n| `PATCH /api/labels/:id` | `{name?, color?, actor?}` | Rename/recolour a label |\n| `DELETE /api/labels/:id` | `{actor?}` | Delete a label and remove its applications |\n\nBlocking edges must form a strict DAG. Self-edges, reciprocal edges, and longer\ncycles return `409`. Closing a blocked issue is allowed.\n\n## Triage labels\n\nLabels are curated entities, not free-text arrays. Before applying workflow\nlabels such as `needs-triage`, create each one once with `POST /api/labels`,\nretain its ID, then send that ID to the issue-label endpoint. The product's\nfresh-install defaults are `bug`, `enhancement`, `documentation`, `question`,\nand `duplicate`.\n\n## curl examples\n\n```bash\nTRACKER=https://your-handle-your-val.web.val.run\nKEY=...\n\n# Discover label IDs\ncurl -s \"$TRACKER/api/labels\"\n\n# Create with curated labels and multiple assignees\ncurl -s -X POST \"$TRACKER/api/issues\" \\\n -H \"Authorization: Bearer $KEY\" -H \"Content-Type: application/json\" \\\n -d '{\"title\":\"Fix flaky test\",\"body\":\"Observed in CI\",\"label_ids\":[1],\"assignees\":[\"alice\"],\"actor\":\"alice\"}'\n\n# Close as deliberately not planned\ncurl -s -X POST \"$TRACKER/api/issues/12/close\" \\\n -H \"Authorization: Bearer $KEY\" -H \"Content-Type: application/json\" \\\n -d '{\"reason\":\"not_planned\",\"comment\":\"Superseded by #15.\",\"actor\":\"alice\"}'\n\n# Reopen\ncurl -s -X POST \"$TRACKER/api/issues/12/reopen\" \\\n -H \"Authorization: Bearer $KEY\" -H \"Content-Type: application/json\" \\\n -d '{\"actor\":\"alice\"}'\n\n# Declare that #12 blocks #15\ncurl -s -X POST \"$TRACKER/api/issues/12/blocks\" \\\n -H \"Authorization: Bearer $KEY\" -H \"Content-Type: application/json\" \\\n -d '{\"add\":[15],\"actor\":\"alice\"}'\n```\n",[],[302,417],"209f927c-480f-4f66-8f57-ecc131f50714","backlog.md","eea1bf8a-7bf2-11f1-975e-1607ee4eb77e",173,["D",1783653142692],"# Backlog — deferred wants\n\nThings wanted eventually, not now. Not commitments; parking lot.\n\n- **Clickable user handles.** Wherever a user handle is displayed (creator,\n comment author, assignee), render it as a link to that user's Val Town\n profile. Purely a rendering concern — the data model just stores the handle.\n (See [[User]] in CONTEXT.md.)\n- **Markdown rendering.** Issue bodies and comment bodies are stored as\n markdown; rendering them to HTML is a later concern.\n",[],[302,425],"0f39a161-6c79-4dab-9fbc-d3a2a3ec0bc0","tickets.md","eeb0130a-7bf2-11f1-8022-1607ee4eb77e","ee67d8e2-7bf2-11f1-b0f6-1607ee4eb77e",175,["D",1783653142898],3,"# Tickets: Richer data model for val-issue-tracker\n\nTracer-bullet tickets implementing the richer data model. Source spec:\n`docs/issues/richer-data-model/PRD.md`. Governed by `CONTEXT.md` + ADRs\n0001–0004.\n\nAll tickets are `ready-for-agent` — agent-grabbable by construction.\n\n## Implementation checklist\n\n- [x] Ticket 1 — core schema reshape and issue lifecycle\n- [x] Ticket 2 — append-only events and lifecycle provenance\n- [x] Ticket 3 — labels, assignees, blocking, comments, events, and touch rules\n- [x] Ticket 4 — idempotent old-schema migration\n- [x] Ticket 5 — final JSON API convention, consumer cleanup, and verification\n\nWork the **frontier**: any ticket whose blockers are all done. Order here is\ndependency order (blockers first): 1 → 2 → 3 → then 4 and 5 in parallel.\n\n> Migration caveat: tickets 1–3 are correct against _fresh_ databases. The ~3\n> existing deployments are only safe to run once ticket 4 (migration) lands,\n> since `initSchema` runs against live data every request. Deploy the set at the\n> end.\n\n## 1. Core schema reshape + issue lifecycle\n\nStatus: ready-for-agent\n\n**What to build:** Fresh-install issue schema on the new model — priority\nremoved entirely; `status` collapses to `open`/`closed`; a nullable\n`state_reason` (`completed`/`not_planned`/`duplicate`/`reopened`) guarded by a\n`CHECK` constraint against status; the issue body field renamed from\n`description` to `body`. The create / close / reopen operations auto-manage\n`state_reason` (create → null; close → chosen reason, default `completed`;\nreopen → `reopened`). The JSON API and HTML UI are reconciled to the new `Issue`\nshape, and the schema knowledge those two consumers currently duplicate\n(status/priority constants, label parse/serialize) is pulled into the\ndata-access layer as a prefactor so later tickets change one place. No migration\nof existing data in this ticket. _Demoable: create an issue, close it as\nnot_planned, reopen it — through both the API and the UI._\n\n**Blocked by:** None — can start immediately.\n\n## 2. Events log foundation + issue lifecycle events\n\nStatus: ready-for-agent\n\n**What to build:** The single append-only events table (`id`, `event_type`,\n`entity_id`, `actor`, `data`, `event_timestamp`) and the emit helper, wired into\nthe issue lifecycle from ticket 1. `*.created` and `*.deleted` carry full state\nsnapshots; `*.updated` carries `{ update_target, from, to }`. One event per\nchanged field, so closing emits two events (`status` and `state_reason`) sharing\nan actor and timestamp. _Demoable: close an issue and observe two events with\nthe acting handle and correct payloads._\n\n**Blocked by:** 1\n\n## 3. Associations: labels + assignees + blocking\n\nStatus: ready-for-agent\n\n**What to build:** All three issue relationships, end-to-end (schema +\noperations + API\n\n- UI + events + touch rule):\n\n* **Labels** — a curated Label entity (`name`, `color`), applied via a bare\n issue↔label join; a default set (`bug`, `enhancement`, `documentation`,\n `question`, `duplicate`) seeded exactly once at table creation and never\n re-seeded; apply/remove; label rename/recolour/delete (deleting an in-use\n label cascades its join rows away).\n* **Assignees** — a set of Val Town users via a bare issue↔handle join;\n add/remove; an \"assigned to me\" query.\n* **Blocking** — a directed `blocker → blocked` edge stored once; insert\n rejected if the target can already reach the source (strict DAG — self,\n reciprocal, and longer cycles all refused); remove; \"blocked\" derived (blocked\n while any blocker is still open) and never stored, and never gating close.\n\nEvery mutation emits its events — label ops as `label.*` plus `issue.updated`\nwith `update_target: label` using `null ↔ value`; assignee and block changes as\n`issue.updated` with `update_target` ∈ {assignee, blocks, blocked_by},\n`null ↔ value`; a block edge writes one event on the acting issue. Every\nassociation change also touches the parent issue's `updated_at`.\n\n_(Largest ticket — if it overflows a single context window at execution time,\nsplit back into labels / assignees / blocking, each blocked by 1 and 2.)_\n\n**Blocked by:** 1, 2\n\n## 4. Migration for existing deployments\n\nStatus: ready-for-agent\n\n**What to build:** One idempotent migration routine (living in the schema-init\npath, safe to run every request) that brings the ~3 existing deployments onto\nthe final schema: remap any `in_progress` issue to `open`; drop priority; expose\nthe old `description` as `body`; lift each existing JSON `labels` array into the\nLabel entities and issue↔label join (creating labels as needed); move any\nexisting single `assignee` into the assignee join; and backfill a synthetic\n`*.created` event (and any required state) for existing rows so no entity is\nleft without provenance. Running it twice is a no-op.\n\n**Blocked by:** 1, 2, 3\n\n## 5. Rewrite JSON API convention doc + final cleanup\n\nStatus: ready-for-agent\n\n**What to build:** Rewrite `docs/issue-tracker-valtown.md` to the new schema and\nendpoint surface (no priority, two statuses, `state_reason` on close/reopen, and\nthe label / assignee / block operations), replacing the outdated convention it\ndocuments today. Remove any remaining old-schema constants or dead code paths in\nthe consumers. Done last so the doc describes the final API exactly once.\n\n**Blocked by:** 3\n",[],[302,442,443,433],"issues","richer-data-model","1da2fc19-c168-4db0-ace9-4a383b4d3b42",["D",1783711960231],[],[302,442,443,32],"85c72af1-cc92-4979-a7a5-bac2e38e7689","PRD.md","eebd1596-7bf2-11f1-ab8e-1607ee4eb77e",174,["D",1783653142818],"# Spec: Richer data model for val-issue-tracker\n\nStatus: ready-for-agent\n\n> Synthesised from a grilling + domain-modeling session. Vocabulary follows\n> `CONTEXT.md`; decisions are governed by ADRs 0001–0004. This is a breaking\n> schema change to the tracker's own data model, plus the migration to get the\n> ~3 existing deployments onto it.\n\n## Problem Statement\n\nThe tracker's current data model carries fields the maintainer doesn't use and\ncan't represent the relationships they actually want. Priority is dead weight.\nStatus has a middle `in_progress` state that isn't wanted, yet there's no way to\nsay _why_ something was closed (done vs. abandoned). Labels are a JSON-array\nstring matched with `LIKE`, so they can't have colour, be renamed in one place,\nor be queried cleanly. There's no way to express that one issue blocks another.\nThere is no history: once a label is removed or an assignee dropped, the fact\nthat it was ever there is gone, and there's no record of who changed what. The\nmaintainer wants a GitHub-flavoured model that captures these relationships and\na full audit trail.\n\n## Solution\n\nReshape the tracker's schema to mirror GitHub's issue model where it earns its\nkeep, and add first-class structure for the things the maintainer actually uses:\n\n- Drop priority entirely and collapse status to `open` / `closed`, with a\n nullable `state_reason` (`completed` / `not_planned` / `duplicate` /\n `reopened`) carrying the nuance — so \"closed as done\" and \"closed as not\n planned\" are distinguishable.\n- Promote labels from a JSON string to curated **Label** entities (name +\n colour), applied to issues through a join, seeded with a small default set on\n first install.\n- Make assignees a _set_ of Val Town users via a join, instead of a single\n string.\n- Add directed **blocking relationships** between issues, kept as a strict DAG,\n with \"blocked\" derived (an issue is blocked while any blocker is still open).\n- Record every change in a single append-only **events** log — the source of\n truth for provenance (\"who did what, when\") and full state history, from which\n auditability is derived. Live tables hold only current state.\n- Treat issue and comment bodies as markdown (a rendering contract; no storage\n change).\n\nIdentity throughout is the Val Town handle — there is no local users table.\n\n## User Stories\n\n1. As a maintainer, I want priority removed from issues, so that the model\n reflects that I never triage by priority.\n2. As a maintainer, I want status to be exactly `open` or `closed`, so that\n there is no unwanted intermediate state to maintain.\n3. As a maintainer, I want to close an issue as `completed`, so that I can\n record that the work was actually done.\n4. As a maintainer, I want to close an issue as `not_planned`, so that I can\n record that I abandoned it rather than finished it.\n5. As a maintainer, I want to close an issue as `duplicate`, so that I can\n record that it was already tracked elsewhere.\n6. As a maintainer, I want reopening an issue to mark its reason as `reopened`,\n so that a reopened issue is distinguishable from one that was never closed.\n7. As a maintainer, I want the system to refuse an incoherent status/reason pair\n (e.g. open + completed), so that the data can never represent an impossible\n state.\n8. As a maintainer, I want `state_reason` to be set automatically by the\n close/reopen/create actions, so that I can't forget to keep it consistent\n with status.\n9. As a maintainer, I want labels to be real entities with names and colours, so\n that I can see and manage a consistent taxonomy.\n10. As a maintainer, I want to apply an existing label to an issue by picking\n it, so that typos can't spawn phantom labels.\n11. As a maintainer, I want to remove a label from an issue, so that the tag set\n stays accurate.\n12. As a maintainer, I want a fresh install to come with a default set of labels\n (`bug`, `enhancement`, `documentation`, `question`, `duplicate`), so that\n the tracker is usable immediately.\n13. As a maintainer, I want labels I delete to stay deleted across restarts, so\n that the default set doesn't resurrect itself on the next request.\n14. As a maintainer, I want to delete a label that is currently applied to\n issues, so that retiring a tag just removes it everywhere.\n15. As a maintainer, I want to rename or recolour a label in one place, so that\n every issue carrying it updates at once.\n16. As a maintainer, I want an issue to have zero or more assignees, so that\n more than one Val Town user can own it.\n17. As a maintainer, I want to add and remove assignees on an issue, so that\n ownership can change over time.\n18. As a maintainer, I want to ask \"what is assigned to me?\", so that I can find\n my work without scanning every issue.\n19. As a maintainer, I want to declare that one issue blocks another, so that I\n can express dependencies.\n20. As a maintainer, I want to view an issue's blockers and the issues it\n blocks, so that I understand its dependency context from either direction.\n21. As a maintainer, I want an issue to show as blocked while any of its\n blockers is still open, so that blocked-ness is always accurate without my\n maintaining a flag.\n22. As a maintainer, I want closing a blocker to automatically unblock its\n dependents, so that the state stays correct for free.\n23. As a maintainer, I want to still be able to close a blocked issue, so that\n being blocked is informational and never traps me.\n24. As a maintainer, I want the system to reject an issue blocking itself, so\n that nonsensical edges can't exist.\n25. As a maintainer, I want the system to reject any edge that would create a\n cycle (direct or longer), so that the dependency graph stays a coherent DAG.\n26. As a maintainer, I want to remove a blocking relationship, so that I can\n correct a dependency I no longer want.\n27. As a maintainer, I want issue and comment bodies treated as markdown, so\n that formatting is preserved for later rendering.\n28. As a maintainer, I want to edit an issue's title and body, so that I can\n correct or refine it after creation.\n29. As a maintainer, I want to edit a comment, so that I can fix mistakes in my\n notes.\n30. As a maintainer, I want to delete a comment, so that I can remove notes that\n no longer belong.\n31. As an auditor, I want every create, update, and delete recorded as an event\n with the actor and timestamp, so that I can reconstruct who changed what and\n when.\n32. As an auditor, I want each field change recorded with its before and after\n value, so that I can see the full history of an issue's state.\n33. As an auditor, I want label applications, assignments, and block edges\n recorded as events, so that removals are visible even though the\n current-state row is gone.\n34. As an auditor, I want a deleted entity's final state captured in its\n deletion event, so that a hard delete still leaves a complete record of what\n was lost.\n35. As an auditor, I want a created entity's initial state captured in its\n creation event, so that history can be replayed forward from a\n self-contained starting point.\n36. As an auditor, I want to reconstruct an entity's state at any past point, so\n that I can answer \"what did this look like last week?\".\n37. As a host-val developer, I want the tracker to keep using prefixed table\n names in my scoped database, so that it never collides with my own tables.\n38. As a host-val developer, I want a friendly sequential issue number, so that\n I can refer to issues as `#N` without an extra opaque id.\n39. As an existing deployment owner, I want my current issues migrated onto the\n new schema, so that I lose no data when upgrading.\n40. As an existing deployment owner, I want any `in_progress` issue moved to\n `open` during migration, so that no issue is stranded in a removed state.\n41. As an existing deployment owner, I want my current JSON labels lifted into\n the new label and join tables, so that existing tags survive the change.\n42. As an existing deployment owner, I want existing rows to get a synthetic\n creation event on migration, so that no entity is left with no provenance.\n43. As an agent, I want the JSON API to reflect the new schema (no priority, two\n statuses, `state_reason`, label/assignee/block operations), so that\n non-interactive callers drive the new model correctly.\n44. As an agent, I want the API convention doc updated to the new schema, so\n that I'm not working from the outdated contract.\n45. As a maintainer, I want any change to an issue's labels, assignees, blocks,\n or comments to bump the issue's `updated_at`, so that \"last activity\"\n sorting reflects all activity, not just edits to the issue's own fields.\n\n## Implementation Decisions\n\n**Modules.** The single seam of change is the data-access layer (`db.ts`):\ntypes, schema creation/migration, and all query functions. The Hono JSON API and\nthe HTML UI are consumers that will be updated to match — both currently\nduplicate schema knowledge (status/priority constants, label parse/serialize)\nthat must be reconciled to the new model. The library's public entry point and\ntable-prefixing convention are unchanged.\n\n**Removed fields.** Priority is removed entirely (column, type, filters,\ncreate/update paths) — faithful to GitHub, which has no first-class priority.\nThe `in_progress` status is removed.\n\n**Status + state_reason.** `status` is `open` | `closed`. A nullable\n`state_reason` holds `completed` / `not_planned` / `duplicate` (with `closed`)\nor `reopened` (with `open`), or `null`. It is auto-managed: create → `null`;\nclose → chosen reason (`completed` default); reopen → `reopened`. A `CHECK`\nconstraint enforces the valid pairings so an incoherent row is impossible. (ADR\ncontext: mirrors GitHub; \"not planned\" is not a third state.)\n\n**Body.** The issue's `description` is renamed to `body` so Issue and Comment\nshare one term, matching GitHub. Bodies remain `TEXT`; markdown is a rendering\ncontract, not a storage change.\n\n**Labels (ADR 0001).** A **Label** is a curated entity: `id`, unique `name`,\n`color`. Applied via an issue↔label join (bare tuple), cascade-deleting both\nsides; deleting an in-use label is allowed and simply removes the join rows. A\ndefault set (`bug`, `enhancement`, `documentation`, `question`, `duplicate`) is\nseeded **exactly once, at the moment the labels table is first created**, never\nre-seeded — so user deletions survive. Labels are editable (rename/recolour in\none place).\n\n**Assignees.** Multi-valued set of Val Town users, stored as a bare\nissue↔user-handle join tuple. No local users table; identity is the handle.\nSupports \"assigned to me\" queries in both directions.\n\n**Blocking (ADR 0002).** A directed edge `blocker → blocked`, stored once with a\nunique pair constraint and cascade on issue delete. \"Blocks\" and \"blocked by\"\nare the same edge read from opposite ends. The graph is a **strict DAG**: on\ninsert, reject if the target can already reach the source (reachability check\nvia recursive query), which covers self-edges, direct reciprocals, and longer\ncycles alike — deliberately stricter than GitHub. \"Blocked\" is **derived, never\nstored**: an issue is blocked iff any blocker is still `open`; blocked-ness is\ninformational and does not prevent closing.\n\n**Audit + provenance (ADR 0003 as amended, ADR 0004).** Entities (Issue,\nComment, Label) keep only `created_at` + `updated_at` columns (for hot-path\nlisting / \"last activity\" sorting). There are **no `*_by` columns anywhere**;\nactor/provenance lives solely in the events log. Link rows carry no audit\ncolumns. Every entity is editable, including comments (the old comment `author`\ncolumn is gone; the author is derived from the `comment.created` event).\n\n**Events log (ADR 0004).** One append-only, polymorphic table with roughly this\nshape:\n\n| column | meaning |\n| ----------------- | --------------------------------------------------------------------------------------- |\n| `id` | ordering key |\n| `event_type` | `.`, entity ∈ {issue, comment, label}, verb ∈ {created, updated, deleted} |\n| `entity_id` | id of the affected entity |\n| `actor` | Val Town handle that performed the change |\n| `data` | JSON payload (shape depends on verb) |\n| `event_timestamp` | when it happened |\n\nGrammar — _boundary events snapshot, updates carry deltas_:\n\n- `*.created` → full initial-state snapshot.\n- `*.deleted` → full final-state snapshot (entities are hard-deleted; the event\n is the tombstone — soft-delete was considered and rejected).\n- `*.updated` → `{ update_target, from, to }`.\n- Associations (label apply/remove, assign/unassign, block add/remove) are\n modelled as `issue.updated` events with `update_target` ∈ {`label`,\n `assignee`, `blocks`, `blocked_by`} and `from`/`to` using **`null ↔ value`**\n (null→X = added, X→null = removed). No separate verb or link entity type.\n- One event per changed field: closing emits two events (`status` and\n `state_reason`) sharing one actor and timestamp; a \"closed as not planned\"\n timeline line is a read-time grouping by (actor, timestamp).\n- A block edge writes **one** event, on the acting issue; the reverse \"blocked\n by\" view is derived by querying events whose `to` references the issue.\n\n**Identity / numbering.** Issues keep the autoincrement `id` as their friendly\n`#N` — no separate opaque id, since a single scoped database per host makes `id`\na clean per-tracker counter and there are no PRs competing for the sequence.\n\n**Touch rule.** Mutating an issue's labels, assignees, block edges, or comments\nbumps that issue's `updated_at` (in addition to emitting an event).\n\n**Migration.** This is a breaking change against ~3 existing deployments (this\nval + two test vals). Migration must: rename `description` → `body`; drop\n`priority`; remap any `in_progress` issue to `open`; lift each existing JSON\n`labels` array into the new label entities (creating labels as needed) and\nissue↔label join rows; move any existing single `assignee` into the assignee\njoin; and backfill a synthetic `*.created` event (and any needed state) for\nexisting rows so nothing is left provenance-less. Migration runs within the\nexisting idempotent schema-init path and must be safe to run repeatedly.\n\n**API + docs.** The JSON API is updated to the new model: no `priority`, two\nstatuses, `state_reason` on close/reopen, and label / assignee / block\noperations. The convention doc `docs/issue-tracker-valtown.md` is rewritten to\nthe new schema (it currently documents the old one) as part of this work.\n\n## Testing Decisions\n\n**Seam.** A single new seam: the exported functions of the data-access layer\n(`db.ts`). There is no existing test suite, so this is the first — no prior art\nto mirror; establish the pattern here. Tests run against a scoped SQLite\ndatabase and exercise the exported functions directly, with no HTTP or UI in the\nloop.\n\n**What makes a good test here.** Assert _external behaviour_ of the data layer —\nthe observable outcomes of calling its functions — not internal implementation\n(not specific SQL, indexes, or private helpers). A good test states a domain\nrule and checks it holds.\n\n**Behaviours to cover:**\n\n- Status/reason: create leaves reason null; each close reason sets status closed\n with the right reason; reopen sets `reopened`; the `CHECK` constraint rejects\n an incoherent pair.\n- Labels: default set seeded on first creation; deletions survive a re-init\n (seed-once); applying/removing labels; deleting an in-use label removes its\n join rows.\n- Assignees: add/remove; \"assigned to me\" returns the right issues.\n- Blocking: self-edge rejected; direct reciprocal rejected; longer cycle\n rejected; a valid edge accepted; \"blocked\" derived from open blockers; closing\n a blocker unblocks dependents; a blocked issue can still be closed.\n- Events: create/update/delete emit events with correct type, actor, and payload\n grammar (created/deleted snapshots, update deltas, association `null ↔ value`,\n one-event-per- field on close, single event on block add); deleted-entity\n snapshot is complete.\n- Touch: association and comment changes bump the parent issue's `updated_at`.\n- Migration: from a seeded old-schema database, `in_progress` → `open`, JSON\n labels lifted into tables, `description` readable as `body`, and existing rows\n gain creation events; running migration twice is a no-op.\n\n## Out of Scope\n\n- Rendering markdown to HTML, and rendering the events log as a UI activity\n timeline (data supports both; presentation is deferred — see\n `docs/backlog.md`).\n- Turning user handles into clickable profile links (backlog).\n- Reintroducing priority or an `in_progress` state in any form.\n- A local users table or any identity beyond the Val Town handle.\n- Soft delete / restore (explicitly rejected in favour of hard delete +\n tombstone event).\n- Retention or pruning of the append-only events log.\n- Topological \"what should I work on next\" ordering (the strict DAG keeps the\n door open for it later, but it is not built here).\n- Black-box tests at the HTTP/API layer (single `db.ts` seam only, by decision).\n\n## Further Notes\n\n- Governing decisions live in ADRs 0001–0004 and the glossary in `CONTEXT.md`;\n use that vocabulary in issue titles, tests, and code.\n- Deferred wants are tracked in `docs/backlog.md`.\n- The stale `docs/issue-tracker-valtown.md` is intentionally left untouched\n until this work rewrites it, so nothing points agents at the new schema before\n it exists.\n",[],[302,442,443,449],"09a12ef3-b79f-45bc-b0d7-6c7e712da8e8","ee584d8c-7bf2-11f1-8d5b-1607ee4eb77e",138,["D",1783641873720],[330,331,332],[302,442,443],"087701f2-85c7-4143-bf9c-c982c16aabc3",137,["D",1783641873603],[329],[302,442],"333d9aaa-e7b2-4eb4-b3d6-a187292833b3","triage-labels.md","ee979b04-7bf2-11f1-ab8e-1607ee4eb77e","ee3720da-7bf2-11f1-8964-1607ee4eb77e",170,["D",1783653142340],"# Triage Labels\n\nThe skills speak in terms of five canonical triage roles. This file maps those\nroles to the actual label strings used in this repo's issue tracker.\n\n| Label in mattpocock/skills | Label in our tracker | Meaning |\n| -------------------------- | -------------------- | ---------------------------------------- |\n| `needs-triage` | `needs-triage` | Maintainer needs to evaluate this issue |\n| `needs-info` | `needs-info` | Waiting on reporter for more information |\n| `ready-for-agent` | `ready-for-agent` | Fully specified, ready for an AFK agent |\n| `ready-for-human` | `ready-for-human` | Requires human implementation |\n| `wontfix` | `wontfix` | Will not be actioned |\n\nWhen a skill mentions a role (e.g. \"apply the AFK-ready triage label\"), use the\ncorresponding label string from this table.\n\n> Note: these five are the **skills' workflow** labels applied to `docs/issues/`\n> tickets. They are a different axis from the issue-tracker _product's_ labels\n> (`bug`, `enhancement`, `documentation`, `question`, `duplicate`) defined in\n> `CONTEXT.md`. Don't conflate the two.\n\nEdit the right-hand column to match whatever vocabulary you actually use.\n",[],[302,476,468],"agents","82f10ed3-774a-43fd-9359-15b8c0e73a99","issue-tracker.md","eea668c8-7bf2-11f1-8b8f-1607ee4eb77e",171,["D",1783653142513],"# Issue tracker: Local Markdown\n\nIssues and PRDs for this repo live as markdown files in `docs/issues/`.\n\n## Conventions\n\n- One feature per directory: `docs/issues//`\n- The PRD is `docs/issues//PRD.md`\n- Implementation issues are `docs/issues//issues/-.md`,\n numbered from `01`\n- Triage state is recorded as a `Status:` line near the top of each issue file\n (see `triage-labels.md` for the role strings)\n- Comments and conversation history append to the bottom of the file under a\n `## Comments` heading\n\n## When a skill says \"publish to the issue tracker\"\n\nCreate a new file under `docs/issues//` (creating the directory if\nneeded).\n\n## When a skill says \"fetch the relevant ticket\"\n\nRead the file at the referenced path. The user will normally pass the path or\nthe issue number directly.\n\n## Wayfinding operations\n\nUsed by `/wayfinder`. The **map** is a file with one **child** file per ticket.\n\n- **Map**: `docs/issues//map.md` — the Notes / Decisions-so-far / Fog\n body.\n- **Child ticket**: `docs/issues//issues/NN-.md`, numbered from\n `01`, with the question in the body. A `Type:` line records the ticket type\n (`research`/`prototype`/`grilling`/`task`); a `Status:` line records\n `claimed`/`resolved`.\n- **Blocking**: a `Blocked by: NN, NN` line near the top. A ticket is unblocked\n when every file it lists is `resolved`.\n- **Frontier**: scan `docs/issues//issues/` for files that are open,\n unblocked, and unclaimed; first by number wins.\n- **Claim**: set `Status: claimed` and save before any work.\n- **Resolve**: append the answer under an `## Answer` heading, set\n `Status: resolved`, then append a context pointer (gist + link) to the map's\n Decisions-so-far in `map.md`.\n",[],[302,476,478],"761446ff-c75d-4331-83d4-ae4f43707105","domain.md","ee8a62a4-7bf2-11f1-9482-1607ee4eb77e",169,["D",1783653142230],"# Domain Docs\n\nHow the engineering skills should consume this repo's domain documentation when\nexploring the codebase.\n\n## Before exploring, read these\n\n- **`CONTEXT.md`** at the repo root, or\n- **`CONTEXT-MAP.md`** at the repo root if it exists — it points at one\n `CONTEXT.md` per context. Read each one relevant to the topic.\n- **`docs/adr/`** — read ADRs that touch the area you're about to work in. In\n multi-context repos, also check `src//docs/adr/` for context-scoped\n decisions.\n\nIf any of these files don't exist, **proceed silently**. Don't flag their\nabsence; don't suggest creating them upfront. The `/domain-modeling` skill\n(reached via `/grill-with-docs` and `/improve-codebase-architecture`) creates\nthem lazily when terms or decisions actually get resolved.\n\n## File structure\n\nThis repo is **single-context**: one root `CONTEXT.md` + `docs/adr/`.\n\n```\n/\n├── CONTEXT.md\n├── docs/adr/\n│ ├── 0001-seed-default-labels-once.md\n│ ├── 0002-blocking-graph-integrity.md\n│ ├── 0003-audit-columns-and-editability.md\n│ └── 0004-append-only-events-log.md\n└── ...\n```\n\n(For reference, a multi-context repo would instead have a `CONTEXT-MAP.md` at\nthe root pointing at per-context `CONTEXT.md` files under `src//`, each\nwith its own `docs/adr/`.)\n\n## Use the glossary's vocabulary\n\nWhen your output names a domain concept (in an issue title, a refactor proposal,\na hypothesis, a test name), use the term as defined in `CONTEXT.md`. Don't drift\nto synonyms the glossary explicitly avoids.\n\nIf the concept you need isn't in the glossary yet, that's a signal — either\nyou're inventing language the project doesn't use (reconsider) or there's a real\ngap (note it for `/domain-modeling`).\n\n## Flag ADR conflicts\n\nIf your output contradicts an existing ADR, surface it explicitly rather than\nsilently overriding:\n\n> _Contradicts ADR-0002 (blocking graph is a strict DAG) — but worth reopening\n> because…_\n",[],[302,476,486],"8a26a61d-d596-4a29-9050-a96215f95442",136,["D",1783641873401],[325,326,327],[302,476],"31c02dd3-aedd-4960-bc34-e9b9c5426093","0004-append-only-events-log.md","ee7eb5c6-7bf2-11f1-8930-1607ee4eb77e","ee2551f2-7bf2-11f1-a4f1-1607ee4eb77e",168,["D",1783653142026],"# 0004 — Single append-only events log as source of truth for history\n\n## Status\n\nAccepted\n\n## Context\n\nAudit columns (ADR 0003) record only the _last_ writer of a row — they cannot\nanswer \"what happened to this issue over time,\" and crucially cannot recover\ninformation that a mutation _removed_ (a label unapplied, an assignee dropped, a\nblock edge deleted). We want both an audit trail and full state history, and\noptionally a GitHub-style activity timeline later.\n\n## Decision\n\nAdd one append-only, polymorphic table:\n\n```\nissue_tracker_events(\n id INTEGER PK,\n event_type TEXT, -- \".\"\n entity_id INTEGER, -- id of the issue/comment/label\n actor TEXT, -- Val Town handle who did it\n data TEXT, -- JSON, shape depends on verb\n event_timestamp INTEGER\n)\n```\n\n- **Entities**: `issue`, `comment`, `label`. **Verbs**: `created`, `updated`,\n `deleted`.\n- **Grammar** — _boundary events snapshot, updates carry deltas_:\n - `*.created` → full initial-state snapshot in `data`.\n - `*.deleted` → full final-state snapshot in `data` (entities are\n **hard-deleted**; the event is the tombstone — see ADR 0003 amendment /\n soft-delete rejected).\n - `*.updated` → `{ update_target, from, to }`.\n- **Associations have no entity type of their own.** Applying/removing a label,\n assigning/unassigning a user, and adding/removing a block edge are modelled as\n `issue.updated` events with `update_target` ∈ {`label`, `assignee`, `blocks`,\n `blocked_by`} and `from`/`to` using **`null ↔ value`** (null→X = added, X→null\n = removed). This reuses the scalar-edit grammar; no new verb, no link entity\n type.\n- **One event per changed field.** Closing emits two events (`status`\n open→closed and `state_reason` null→reason) sharing one\n `actor`/`event_timestamp`; reopen likewise. Rendering \"closed as not planned\"\n as a single timeline line is a read-time grouping by (actor, timestamp).\n- **Block edges write one event, on the acting issue** (ADR 0002 / Q17); the\n reverse \"blocked by\" view is derived by querying events whose `to` references\n the issue.\n\n## Consequences\n\n- The log is the single source of truth for provenance and history; live tables\n hold only current state. Every entity create/update/delete and every\n association change **must** emit an event, or provenance is lost.\n- Full state at any past time is reconstructable: start from the `created`\n snapshot, replay `updated` deltas forward.\n- Removals are captured (the whole point) — a `label_removed`-style fact\n survives as an `issue.updated` with `to: null`, and deleted entities leave a\n snapshot tombstone.\n- Whether the log is surfaced in the UI (activity timeline) is deferred; the\n data supports it either way. Auditability is derived, not a stored view.\n- The table grows unboundedly (append-only); pruning/retention is a future\n concern.\n",[],[302,507,499],"adr","26aa1419-2852-4924-b2b1-f3eb9e4adc9e","0003-audit-columns-and-editability.md","ee76ee18-7bf2-11f1-8022-1607ee4eb77e",166,["D",1783653141647],"# 0003 — Audit columns and universal editability\n\n## Status\n\nAccepted — **partially superseded by ADR 0004** (see amendment at end). The\n_editability_ decision stands in full; the `*_by` columns and the link\ncreation-pair were removed once the events log (ADR 0004) became the source of\ntruth for provenance.\n\n## Context\n\nWe want to know who created and last changed every piece of user-authored data,\nand we want a uniform convention rather than ad-hoc timestamps per table. Today\nit is inconsistent: issues have `created_by`/`created_at`/`updated_at` but no\n`updated_by`; comments have only `author` + `created_at` and no edit operation\nat all.\n\n## Decision\n\nTwo rules, applied across the whole schema:\n\n1. **Entities carry all four audit columns**: `created_at`, `created_by`,\n `updated_at`, `updated_by`. Entities are the things a user authors and can\n later change — **Issue**, **Comment**, **Label**. Consequently, _every entity\n is editable_ (there is an update operation for each), including comments.\n `created_by`/`updated_by` hold Val Town handles.\n\n2. **Join / link rows carry only the creation pair**: `created_at` +\n `created_by` (surfaced with intent-revealing names, e.g.\n `assigned_at`/`assigned_by` on assignees, `linked_at`/`linked_by` on block\n edges). Links are immutable — a user _adds_ or _removes_ them, never _edits_\n one — so `updated_at`/`updated_by` would be meaningless.\n\nNaming: the Comment's `author` column is renamed **`created_by`** so the\nconvention is uniform (the author _is_ the creator).\n\n## Consequences\n\n- Comment editing becomes a real, supported operation (mirrors GitHub).\n- Every table's provenance is queryable in a uniform way; no per-table special\n cases.\n- `updated_at` combines with the \"touch\" rule (see CONTEXT.md): association\n changes bump the parent issue's `updated_at` too.\n- Slightly more columns and write-path bookkeeping everywhere — accepted for the\n auditability and uniformity it buys.\n\n## Amendment (superseded in part by ADR 0004)\n\nOnce the append-only events log (ADR 0004) was adopted, it became the source of\ntruth for _who_ did _what_ and _when_. That makes the `*_by` columns redundant —\nactor is derivable as the latest event for an entity. We therefore revised this\ndecision:\n\n- **Entities keep only `created_at` + `updated_at`** as denormalized columns —\n they drive hot-path listing and \"last activity\" sorting, which would otherwise\n require a `MAX(event_timestamp)` aggregate over the log on every render.\n- **`created_by` / `updated_by` columns are dropped.** The actor is derived from\n the events log, which is already loaded on the only screen that needs it (an\n entity's detail/timeline view).\n- **Link rows carry no audit columns at all** — assignees and block edges become\n bare relationship tuples; their provenance lives entirely in events.\n\nWhat stands unchanged from the original decision: **every entity (Issue,\nComment, Label) is editable**, including comments, and the Comment's old\n`author` column is gone (its creator is derived from the `comment.created`\nevent).\n",[],[302,507,509],"bf1eb092-9651-471a-b7da-df0287561a70","0002-blocking-graph-integrity.md","eedbe340-7bf2-11f1-a9f4-1607ee4eb77e",183,["D",1783653141615],"# 0002 — Blocking graph is a strict DAG (reject all cycles)\n\n## Status\n\nAccepted\n\n## Context\n\nIssues can block each other, forming a directed graph stored as edges in\n`issue_tracker_issue_blocks(blocker_id, blocked_id)` (edge direction: blocker →\nblocked). Such a graph can contain degenerate or cyclic edges:\n\n- **Self-edge** — A blocks A.\n- **Direct reciprocal** — A blocks B and B blocks A.\n- **Longer cycle** — A blocks B, B blocks C, C blocks A.\n\nGitHub, empirically, rejects self-edges and direct reciprocals but _allows_\nlonger cycles like A→B→C→A (verified against its GraphQL `blockedBy`/`blocking`\nAPI). We deliberately do **not** follow GitHub here.\n\n## Decision\n\nEnforce a strict DAG — reject **any** edge that would create a cycle. All three\ncases above collapse into one rule, checked on insert of edge\n`blocker → blocked`:\n\n> Reject if `blocked` can already reach `blocker` by following block-edges —\n> i.e. a path `blocked → … → blocker` already exists (a self-edge is the\n> degenerate `blocked == blocker` case).\n\nImplemented as a reachability query (SQLite `WITH RECURSIVE`) run in the\ndatabase on each insert. `UNIQUE(blocker_id, blocked_id)` additionally prevents\nduplicate edges.\n\n## Rationale\n\nA cycle in a dependency graph is logically incoherent: a loop of issues that can\nnever be satisfied in dependency order. Keeping the graph a strict DAG also\npreserves the option to add topological \"what's workable now\" ordering later\nwithout retrofitting cycle detection.\n\n## Consequences\n\n- Every edge insert pays for one reachability traversal. For a\n personal/small-team tracker's graph size this is negligible, and it runs\n entirely in SQLite.\n- The block graph is guaranteed acyclic, so downstream features may safely\n assume a topological order exists.\n- This is stricter than GitHub; anyone porting expectations from GitHub should\n know that A→B→C→A is refused here.\n",[],[302,507,517],"610774cf-6c90-4bf8-91cb-2b82abfa3ecc","0001-seed-default-labels-once.md","ee84afa8-7bf2-11f1-8022-1607ee4eb77e",167,["D",1783653141936],"# 0001 — Seed default labels once, at table creation only\n\n## Status\n\nAccepted\n\n## Context\n\nThe tracker is a drop-in library: `initSchema()` is idempotent and runs on\n**every request** to guarantee the host val's tables exist. We also want to ship\na curated set of default labels (`bug`, `enhancement`, `documentation`,\n`question`, `duplicate`), and labels are user-deletable.\n\nThese two facts collide. If defaults are inserted \"when missing\" inside the\nper-request `initSchema()`, then any default a user deliberately deletes will\nreappear on the very next request — deletion would be impossible for default\nlabels.\n\n## Decision\n\nSeed the default labels **exactly once, in the branch that creates the\n`issue_tracker_labels` table** (i.e. only when it did not previously exist).\nOnce the table exists, `initSchema()` never touches label _rows_ again. After\ncreation the label set belongs entirely to the user: deletes and edits are\npermanent.\n\n## Consequences\n\n- Default labels behave like a starting kit, not enforced state — users can\n prune or rename any of them and the changes stick.\n- The \"table was just created\" signal must be detected explicitly (e.g. check\n existence before `CREATE TABLE`, or seed only when a freshly created table is\n empty on first creation), since `CREATE TABLE IF NOT EXISTS` alone doesn't\n tell us whether it already had data.\n- A host that wants the defaults back after deleting them must re-add them\n manually; there is intentionally no auto-heal.\n",[],[302,507,525],"12a719bc-c079-4db1-bbdb-e6251ba56110",135,["D",1783641873285],[320,321,322,323],[302,507],["D",1783635592340],[319,324,328,333,334],[302],["D",1783563523910],["D",1789525245864],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_125":578,"_579":580,"_581":582,"_583":24,"_584":24,"_585":24,"_586":57,"_587":-5,"_588":-7,"_589":-7,"_590":61,"_591":24,"_592":24,"_593":-5,"_594":24,"_595":24,"_596":24,"_597":-5},"ENV",{"_549":550,"_551":552,"_553":88,"_554":555,"_556":557,"_558":559,"_560":561,"_562":563,"_564":565,"_566":567,"_568":569,"_570":571,"_572":573,"_574":575,"_576":577},"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"]

Diff · v195