` 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** — repository reality uses Deno's built-in formatter via\n   `deno.json`; `.vt/` and `.claude/` are excluded from formatting; canonical\n   commands are the `deno.json` tasks `fmt` / `lint` / `typecheck` / `test` /\n   `check`; README Development documents the same commands, and `check` uses the\n   non-mutating `deno fmt --check` gate.\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",[257,258,172,145],"pulls","branches","forks","envVars",{"_283":26,"_285":26},"connections",{"_283":26,"_284":26},"count","unfilledCount","emptyCount",{"_44":911,"_13":902,"_73":896,"_54":-5,"_46":47,"_250":912,"_252":24,"_48":913,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":914,"_17":915},{"_44":903,"_13":904,"_73":905,"_54":896,"_46":47,"_250":906,"_252":24,"_48":907,"_50":26,"_76":21,"_254":908,"_77":30,"_255":-5,"_367":909,"_17":910},{"_44":893,"_13":894,"_73":895,"_54":896,"_46":47,"_250":897,"_252":24,"_48":898,"_50":273,"_76":21,"_254":899,"_77":30,"_255":-5,"_367":900,"_17":901},{"_44":888,"_13":257,"_73":628,"_54":-5,"_46":47,"_250":889,"_252":24,"_48":890,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":891,"_17":892},{"_44":883,"_13":858,"_73":852,"_54":628,"_46":47,"_250":884,"_252":24,"_48":885,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":886,"_17":887},{"_44":875,"_13":876,"_73":877,"_54":852,"_46":47,"_250":878,"_252":24,"_48":879,"_50":273,"_76":21,"_254":880,"_77":30,"_255":-5,"_367":881,"_17":882},{"_44":867,"_13":868,"_73":869,"_54":852,"_46":47,"_250":870,"_252":24,"_48":871,"_50":273,"_76":21,"_254":872,"_77":30,"_255":-5,"_367":873,"_17":874},{"_44":859,"_13":860,"_73":861,"_54":852,"_46":47,"_250":862,"_252":24,"_48":863,"_50":273,"_76":21,"_254":864,"_77":30,"_255":-5,"_367":865,"_17":866},{"_44":849,"_13":850,"_73":851,"_54":852,"_46":47,"_250":853,"_252":24,"_48":854,"_50":273,"_76":21,"_254":855,"_77":30,"_255":-5,"_367":856,"_17":857},{"_44":844,"_13":819,"_73":813,"_54":628,"_46":47,"_250":845,"_252":24,"_48":846,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":847,"_17":848},{"_44":836,"_13":837,"_73":838,"_54":813,"_46":47,"_250":839,"_252":24,"_48":840,"_50":273,"_76":21,"_254":841,"_77":30,"_255":-5,"_367":842,"_17":843},{"_44":828,"_13":829,"_73":830,"_54":813,"_46":47,"_250":831,"_252":24,"_48":832,"_50":273,"_76":21,"_254":833,"_77":30,"_255":-5,"_367":834,"_17":835},{"_44":820,"_13":821,"_73":822,"_54":813,"_46":47,"_250":823,"_252":24,"_48":824,"_50":383,"_76":21,"_254":825,"_77":30,"_255":-5,"_367":826,"_17":827},{"_44":810,"_13":811,"_73":812,"_54":813,"_46":47,"_250":814,"_252":24,"_48":815,"_50":273,"_76":21,"_254":816,"_77":30,"_255":-5,"_367":817,"_17":818},{"_44":805,"_13":258,"_73":249,"_54":628,"_46":47,"_250":806,"_252":24,"_48":807,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":808,"_17":809},{"_44":800,"_13":737,"_73":731,"_54":249,"_46":47,"_250":801,"_252":24,"_48":802,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":803,"_17":804},{"_44":795,"_13":258,"_73":741,"_54":731,"_46":47,"_250":796,"_252":24,"_48":797,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":798,"_17":799},{"_44":787,"_13":788,"_73":789,"_54":741,"_46":47,"_250":790,"_252":24,"_48":791,"_50":383,"_76":21,"_254":792,"_77":30,"_255":-5,"_367":793,"_17":794},{"_44":779,"_13":780,"_73":781,"_54":741,"_46":47,"_250":782,"_252":24,"_48":783,"_50":383,"_76":21,"_254":784,"_77":30,"_255":-5,"_367":785,"_17":786},{"_44":771,"_13":772,"_73":773,"_54":741,"_46":47,"_250":774,"_252":24,"_48":775,"_50":400,"_76":21,"_254":776,"_77":30,"_255":-5,"_367":777,"_17":778},{"_44":763,"_13":764,"_73":765,"_54":741,"_46":47,"_250":766,"_252":24,"_48":767,"_50":383,"_76":21,"_254":768,"_77":30,"_255":-5,"_367":769,"_17":770},{"_44":755,"_13":756,"_73":757,"_54":741,"_46":47,"_250":758,"_252":24,"_48":759,"_50":273,"_76":21,"_254":760,"_77":30,"_255":-5,"_367":761,"_17":762},{"_44":747,"_13":748,"_73":749,"_54":741,"_46":47,"_250":750,"_252":24,"_48":751,"_50":383,"_76":21,"_254":752,"_77":30,"_255":-5,"_367":753,"_17":754},{"_44":738,"_13":739,"_73":740,"_54":741,"_46":47,"_250":742,"_252":24,"_48":743,"_50":400,"_76":21,"_254":744,"_77":30,"_255":-5,"_367":745,"_17":746},{"_44":729,"_13":170,"_73":730,"_54":731,"_46":47,"_250":732,"_252":24,"_48":733,"_50":400,"_76":21,"_254":734,"_77":30,"_255":-5,"_367":735,"_17":736},{"_44":248,"_13":172,"_73":171,"_54":249,"_46":47,"_250":251,"_252":24,"_48":726,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":727,"_17":728},{"_44":271,"_13":145,"_73":144,"_54":171,"_46":47,"_250":148,"_252":24,"_48":723,"_50":273,"_76":21,"_254":274,"_77":30,"_255":-5,"_367":724,"_17":725},{"_44":267,"_13":170,"_73":89,"_54":171,"_46":47,"_250":164,"_252":24,"_48":720,"_50":264,"_76":21,"_254":269,"_77":30,"_255":-5,"_367":721,"_17":722},{"_44":262,"_13":75,"_73":74,"_54":171,"_46":47,"_250":156,"_252":24,"_48":717,"_50":264,"_76":21,"_254":265,"_77":30,"_255":-5,"_367":718,"_17":719},{"_44":712,"_13":650,"_73":644,"_54":249,"_46":47,"_250":713,"_252":24,"_48":714,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":715,"_17":716},{"_44":707,"_13":258,"_73":654,"_54":644,"_46":47,"_250":708,"_252":24,"_48":709,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":710,"_17":711},{"_44":699,"_13":700,"_73":701,"_54":654,"_46":47,"_250":702,"_252":24,"_48":703,"_50":273,"_76":21,"_254":704,"_77":30,"_255":-5,"_367":705,"_17":706},{"_44":691,"_13":692,"_73":693,"_54":654,"_46":47,"_250":694,"_252":24,"_48":695,"_50":273,"_76":21,"_254":696,"_77":30,"_255":-5,"_367":697,"_17":698},{"_44":683,"_13":684,"_73":685,"_54":654,"_46":47,"_250":686,"_252":24,"_48":687,"_50":273,"_76":21,"_254":688,"_77":30,"_255":-5,"_367":689,"_17":690},{"_44":675,"_13":676,"_73":677,"_54":654,"_46":47,"_250":678,"_252":24,"_48":679,"_50":273,"_76":21,"_254":680,"_77":30,"_255":-5,"_367":681,"_17":682},{"_44":667,"_13":668,"_73":669,"_54":654,"_46":47,"_250":670,"_252":24,"_48":671,"_50":273,"_76":21,"_254":672,"_77":30,"_255":-5,"_367":673,"_17":674},{"_44":659,"_13":660,"_73":661,"_54":654,"_46":47,"_250":662,"_252":24,"_48":663,"_50":273,"_76":21,"_254":664,"_77":30,"_255":-5,"_367":665,"_17":666},{"_44":651,"_13":652,"_73":653,"_54":654,"_46":47,"_250":213,"_252":24,"_48":655,"_50":26,"_76":21,"_254":656,"_77":30,"_255":-5,"_367":657,"_17":658},{"_44":642,"_13":170,"_73":643,"_54":644,"_46":47,"_250":645,"_252":24,"_48":646,"_50":26,"_76":21,"_254":647,"_77":30,"_255":-5,"_367":648,"_17":649},{"_44":634,"_13":635,"_73":636,"_54":628,"_46":47,"_250":637,"_252":24,"_48":638,"_50":453,"_76":21,"_254":639,"_77":30,"_255":-5,"_367":640,"_17":641},{"_44":625,"_13":626,"_73":627,"_54":628,"_46":47,"_250":629,"_252":24,"_48":630,"_50":383,"_76":21,"_254":631,"_77":30,"_255":-5,"_367":632,"_17":633},{"_44":620,"_13":579,"_73":573,"_54":-5,"_46":47,"_250":621,"_252":24,"_48":622,"_50":26,"_76":173,"_254":-5,"_77":30,"_255":-5,"_367":623,"_17":624},{"_44":612,"_13":613,"_73":614,"_54":573,"_46":47,"_250":615,"_252":24,"_48":616,"_50":26,"_76":21,"_254":617,"_77":30,"_255":-5,"_367":618,"_17":619},{"_44":604,"_13":605,"_73":606,"_54":573,"_46":47,"_250":607,"_252":24,"_48":608,"_50":26,"_76":21,"_254":609,"_77":30,"_255":-5,"_367":610,"_17":611},{"_44":596,"_13":597,"_73":598,"_54":573,"_46":47,"_250":599,"_252":24,"_48":600,"_50":26,"_76":21,"_254":601,"_77":30,"_255":-5,"_367":602,"_17":603},{"_44":588,"_13":589,"_73":590,"_54":573,"_46":47,"_250":591,"_252":24,"_48":592,"_50":26,"_76":21,"_254":593,"_77":30,"_255":-5,"_367":594,"_17":595},{"_44":580,"_13":581,"_73":582,"_54":573,"_46":47,"_250":583,"_252":24,"_48":584,"_50":26,"_76":21,"_254":585,"_77":30,"_255":-5,"_367":586,"_17":587},{"_44":570,"_13":571,"_73":572,"_54":573,"_46":47,"_250":574,"_252":24,"_48":575,"_50":26,"_76":21,"_254":576,"_77":30,"_255":-5,"_367":577,"_17":578},{"_44":562,"_13":563,"_73":564,"_54":-5,"_46":47,"_250":565,"_252":24,"_48":566,"_50":26,"_76":21,"_254":567,"_77":30,"_255":-5,"_367":568,"_17":569},{"_44":555,"_13":556,"_73":557,"_54":-5,"_46":47,"_250":558,"_252":24,"_48":559,"_50":264,"_76":21,"_254":552,"_77":30,"_255":-5,"_367":560,"_17":561},{"_44":547,"_13":548,"_73":549,"_54":-5,"_46":47,"_250":550,"_252":24,"_48":551,"_50":264,"_76":21,"_254":552,"_77":30,"_255":-5,"_367":553,"_17":554},{"_44":539,"_13":540,"_73":541,"_54":-5,"_46":47,"_250":542,"_252":24,"_48":543,"_50":264,"_76":21,"_254":544,"_77":30,"_255":-5,"_367":545,"_17":546},{"_44":531,"_13":532,"_73":533,"_54":-5,"_46":47,"_250":534,"_252":24,"_48":535,"_50":383,"_76":21,"_254":536,"_77":30,"_255":-5,"_367":537,"_17":538},{"_44":523,"_13":524,"_73":525,"_54":-5,"_46":47,"_250":526,"_252":24,"_48":527,"_50":26,"_76":21,"_254":528,"_77":30,"_255":-5,"_367":529,"_17":530},{"_44":515,"_13":516,"_73":517,"_54":-5,"_46":47,"_250":518,"_252":24,"_48":519,"_50":495,"_76":21,"_254":520,"_77":30,"_255":-5,"_367":521,"_17":522},{"_44":507,"_13":508,"_73":509,"_54":-5,"_46":47,"_250":510,"_252":24,"_48":511,"_50":453,"_76":365,"_254":512,"_77":30,"_255":-5,"_367":513,"_17":514},{"_44":499,"_13":500,"_73":501,"_54":-5,"_46":47,"_250":502,"_252":24,"_48":503,"_50":453,"_76":365,"_254":504,"_77":30,"_255":-5,"_367":505,"_17":506},{"_44":490,"_13":491,"_73":492,"_54":-5,"_46":47,"_250":493,"_252":24,"_48":494,"_50":495,"_76":365,"_254":496,"_77":30,"_255":-5,"_367":497,"_17":498},{"_44":482,"_13":483,"_73":484,"_54":-5,"_46":47,"_250":485,"_252":24,"_48":486,"_50":409,"_76":365,"_254":487,"_77":30,"_255":-5,"_367":488,"_17":489},{"_44":473,"_13":474,"_73":475,"_54":-5,"_46":47,"_250":476,"_252":24,"_48":477,"_50":478,"_76":365,"_254":479,"_77":30,"_255":-5,"_367":480,"_17":481},{"_44":465,"_13":466,"_73":467,"_54":-5,"_46":47,"_250":468,"_252":24,"_48":469,"_50":26,"_76":365,"_254":470,"_77":30,"_255":-5,"_367":471,"_17":472},{"_44":457,"_13":458,"_73":459,"_54":-5,"_46":47,"_250":460,"_252":24,"_48":461,"_50":427,"_76":365,"_254":462,"_77":30,"_255":-5,"_367":463,"_17":464},{"_44":448,"_13":449,"_73":450,"_54":-5,"_46":47,"_250":451,"_252":24,"_48":452,"_50":453,"_76":365,"_254":454,"_77":30,"_255":-5,"_367":455,"_17":456},{"_44":439,"_13":440,"_73":441,"_54":-5,"_46":47,"_250":442,"_252":24,"_48":443,"_50":444,"_76":21,"_254":445,"_77":30,"_255":-5,"_367":446,"_17":447},{"_44":431,"_13":432,"_73":433,"_54":-5,"_46":47,"_250":434,"_252":24,"_48":435,"_50":26,"_76":365,"_254":436,"_77":30,"_255":-5,"_367":437,"_17":438},{"_44":422,"_13":423,"_73":424,"_54":-5,"_46":47,"_250":425,"_252":24,"_48":426,"_50":427,"_76":365,"_254":428,"_77":30,"_255":-5,"_367":429,"_17":430},{"_44":413,"_13":414,"_73":186,"_54":-5,"_46":47,"_250":415,"_252":24,"_48":416,"_50":417,"_76":418,"_254":419,"_77":30,"_255":-5,"_367":420,"_17":421},{"_44":404,"_13":405,"_73":406,"_54":-5,"_46":47,"_250":407,"_252":24,"_48":408,"_50":409,"_76":365,"_254":410,"_77":30,"_255":-5,"_367":411,"_17":412},{"_44":395,"_13":396,"_73":397,"_54":-5,"_46":47,"_250":398,"_252":24,"_48":399,"_50":400,"_76":365,"_254":401,"_77":30,"_255":-5,"_367":402,"_17":403},{"_44":387,"_13":388,"_73":389,"_54":-5,"_46":47,"_250":390,"_252":24,"_48":391,"_50":26,"_76":365,"_254":392,"_77":30,"_255":-5,"_367":393,"_17":394},{"_44":378,"_13":379,"_73":380,"_54":-5,"_46":47,"_250":381,"_252":24,"_48":382,"_50":383,"_76":365,"_254":384,"_77":30,"_255":-5,"_367":385,"_17":386},{"_44":370,"_13":371,"_73":372,"_54":-5,"_46":47,"_250":373,"_252":24,"_48":374,"_50":26,"_76":365,"_254":375,"_77":30,"_255":-5,"_367":376,"_17":377},{"_44":359,"_13":360,"_73":361,"_54":-5,"_46":47,"_250":362,"_252":24,"_48":363,"_50":364,"_76":365,"_254":366,"_77":30,"_255":-5,"_367":368,"_17":369},"bd8da8f8-25d3-4370-9e5e-a52f69a92883","ui.tsx","fca19e20-7b48-11f1-8cf9-1607ee4eb77e",364,["D",1784091866485],36,"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\";\nimport {\n  adaptLabelColor,\n  LABEL_CHIP_ATTR,\n  labelChipStyle,\n  T,\n} from \"./theme.ts\";\n\nexport const FIELD =\n  `bg-[${T.surface}] border border-[${T.border}] rounded-md h-8 px-3.5 text-sm font-medium text-[${T.text}] focus:outline-none focus:border-[${T.link}]`;\nconst BUTTON =\n  \"inline-flex items-center gap-1.5 rounded-md h-8 px-3.5 text-sm font-medium cursor-pointer no-underline\";\nconst VARIANTS = {\n  solid:\n    `bg-[${T.accent}] border border-[${T.accent}] text-[${T.accentInk}] hover:brightness-110`,\n  ghost:\n    `bg-transparent border border-[${T.accent}] text-[${T.text}] hover:brightness-110`,\n  danger:\n    `bg-transparent border border-[${T.danger}] text-[${T.danger}] hover:bg-[${T.danger}] hover:text-[${T.dangerInk}]`,\n} as const;\n\nexport const STATUS_LABELS: Record<IssueStatus, string> = {\n  open: \"Open\",\n  closed: \"Closed\",\n};\nexport const STATE_REASON_LABELS: Record<Exclude<StateReason, null>, string> = {\n  completed: \"Completed\",\n  not_planned: \"Not planned\",\n  duplicate: \"Duplicate\",\n  reopened: \"Reopened\",\n};\n\nexport const Card: FC<PropsWithChildren<{ class?: string }>> = ({\n  children,\n  class: cls,\n}) => (\n  <div\n    class={`bg-[${T.panel}] border border-[${T.border}] rounded-lg p-4 mb-[18px] ${\n      cls ?? \"\"\n    }`}\n  >\n    {children}\n  </div>\n);\n\nexport const Button: FC<\n  PropsWithChildren<{\n    variant?: keyof typeof VARIANTS;\n    href?: string;\n    type?: \"button\" | \"submit\";\n    class?: string;\n    name?: string;\n    value?: string;\n    form?: string;\n  }>\n> = ({\n  variant = \"solid\",\n  href,\n  type = \"button\",\n  class: cls,\n  name,\n  value,\n  form,\n  children,\n}) => {\n  const classes = `${BUTTON} ${VARIANTS[variant]} ${cls ?? \"\"}`;\n  return href\n    ? (\n      <a class={classes} href={href}>\n        {children}\n      </a>\n    )\n    : (\n      <button\n        class={classes}\n        type={type}\n        name={name}\n        value={value}\n        form={form}\n      >\n        {children}\n      </button>\n    );\n};\n\nexport const Select: FC<\n  PropsWithChildren<{ name: string; id?: string; class?: string }>\n> = ({ name, id, class: cls, children }) => (\n  <select id={id} name={name} class={`${FIELD} ${cls ?? \"\"}`}>\n    {children}\n  </select>\n);\n\nexport const Banner: FC<{ kind: \"ok\" | \"err\"; msg: string }> = ({\n  kind,\n  msg,\n}) => (\n  <div\n    class={`rounded-lg border px-3.5 py-2.5 mb-4 ${\n      kind === \"err\"\n        ? `bg-[${T.bannerErrBg}] border-[${T.danger}] text-[${T.danger}]`\n        : `bg-[${T.bannerOkBg}] border-[${T.stateOpen}] text-[${T.stateOpen}]`\n    }`}\n  >\n    {msg}\n  </div>\n);\n\nexport const StatusBadge: FC<{ status: IssueStatus; reason?: StateReason }> = ({\n  status,\n  reason,\n}) => (\n  <span\n    class={`inline-block rounded-full px-2.5 py-0.5 text-xs font-medium ${\n      status === \"open\"\n        ? `bg-[${T.accent}] text-[${T.accentInk}]`\n        : `bg-[${T.border}] text-[${T.text}]`\n    }`}\n  >\n    {STATUS_LABELS[status]}\n    {reason ? ` · ${STATE_REASON_LABELS[reason]}` : \"\"}\n  </span>\n);\n\nexport const LabelTag: FC<{ label: Label }> = ({ label }) => (\n  <span\n    {...{ [LABEL_CHIP_ATTR]: \"\" }}\n    class=\"inline-block rounded-md border px-1.5 py-px text-[11px] mr-1\"\n    style={labelChipStyle(adaptLabelColor(label.color))}\n  >\n    {label.name}\n  </span>\n);\n","children",[],[360],"47ddee41-3a79-4b55-846e-57c64446692d","theme_test.ts","a65d7e0a-800a-11f1-bec8-1607ee4eb77e",357,["D",1784091865144],"import { assert, assertEquals, assertMatch } from \"jsr:@std/assert@1.0.19\";\nimport {\n  adaptLabelColor,\n  INK_FILL_PAIRS,\n  renderSchemeStylesheet,\n  SCHEMES,\n  T,\n} from \"./theme.ts\";\n\nfunction hexToRgb(hex: string): [number, number, number] {\n  const n = Number.parseInt(hex.replace(/^#/, \"\"), 16);\n  return [(n >> 16) & 255, (n >> 8) & 255, n & 255];\n}\n\nfunction srgbToLinear(c: number): number {\n  const v = c / 255;\n  return v <= 0.04045 ? v / 12.92 : ((v + 0.055) / 1.055) ** 2.4;\n}\n\nfunction relativeLuminance(hex: string): number {\n  const [r, g, b] = hexToRgb(hex).map(srgbToLinear);\n  return 0.2126 * r + 0.7152 * g + 0.0722 * b;\n}\n\nfunction contrastRatio(hexA: string, hexB: string): number {\n  const a = relativeLuminance(hexA);\n  const b = relativeLuminance(hexB);\n  const [hi, lo] = a > b ? [a, b] : [b, a];\n  return (hi + 0.05) / (lo + 0.05);\n}\n\nfunction hueOf(hex: string): number | null {\n  const [r, g, b] = hexToRgb(hex).map((v) => v / 255);\n  const max = Math.max(r, g, b), min = Math.min(r, g, b);\n  if (max - min < 1e-3) return null; // achromatic — hue undefined\n  let h: number;\n  if (max === r) h = ((g - b) / (max - min)) % 6;\n  else if (max === g) h = (b - r) / (max - min) + 2;\n  else h = (r - g) / (max - min) + 4;\n  h *= 60;\n  return h < 0 ? h + 360 : h;\n}\n\nDeno.test(\"every ink/fill pair clears 4.5:1 in both schemes\", () => {\n  for (const [ink, fill] of INK_FILL_PAIRS) {\n    for (const scheme of [\"light\", \"dark\"] as const) {\n      const ratio = contrastRatio(SCHEMES[ink][scheme], SCHEMES[fill][scheme]);\n      assert(\n        ratio >= 4.5,\n        `${ink} on ${fill} (${scheme}) is ${ratio.toFixed(2)}:1, below 4.5:1`,\n      );\n    }\n  }\n});\n\nDeno.test(\"both schemes define every variable — neither omits one\", () => {\n  for (const key of Object.keys(SCHEMES) as Array<keyof typeof SCHEMES>) {\n    const value = SCHEMES[key];\n    assert(typeof value.light === \"string\" && value.light.length > 0);\n    assert(typeof value.dark === \"string\" && value.dark.length > 0);\n  }\n});\n\nDeno.test(\"T's values are typed CSS variable references, not hex literals\", () => {\n  for (const key of Object.keys(SCHEMES) as Array<keyof typeof SCHEMES>) {\n    assertMatch(T[key], /^color:var\$--[a-z-]+\$$/);\n  }\n});\n\nDeno.test(\"renderSchemeStylesheet emits a :root block and a dark media block\", () => {\n  const css = renderSchemeStylesheet();\n  assertMatch(css, /^:root\\{/);\n  assertMatch(css, /@media \$prefers-color-scheme:dark\$\\{:root\\{/);\n  for (const key of Object.keys(SCHEMES) as Array<keyof typeof SCHEMES>) {\n    const varName = key.replace(/[A-Z]/g, (m) => `-${m.toLowerCase()}`);\n    assertMatch(css, new RegExp(`--${varName}:${SCHEMES[key].light}`));\n    assertMatch(css, new RegExp(`--${varName}:${SCHEMES[key].dark}`));\n  }\n});\n\nconst ADVERSARIAL_LABEL_COLORS = [\n  \"d73a4a\", // bug (seeded)\n  \"a2eeef\", // enhancement (seeded) — the 1.31:1-on-white defect\n  \"0075ca\", // documentation (seeded) — the 4.40:1-on-dark defect\n  \"d876e3\", // question (seeded)\n  \"cfd3d7\", // duplicate (seeded)\n  \"fefefe\", // near-white\n  \"010101\", // near-black\n  \"ff0000\", // fully saturated\n  \"808080\", // achromatic\n];\n\nDeno.test(\"adaptLabelColor clears 4.5:1 against both canvases\", () => {\n  for (const hex of ADVERSARIAL_LABEL_COLORS) {\n    const { light, dark } = adaptLabelColor(hex);\n    const onWhite = contrastRatio(light, \"#ffffff\");\n    const onBlack = contrastRatio(dark, \"#000000\");\n    assert(\n      onWhite >= 4.5,\n      `#${hex} adapted for light (${light}) is ${\n        onWhite.toFixed(2)\n      }:1 on white`,\n    );\n    assert(\n      onBlack >= 4.5,\n      `#${hex} adapted for dark (${dark}) is ${onBlack.toFixed(2)}:1 on black`,\n    );\n  }\n});\n\nDeno.test(\"adaptLabelColor preserves hue\", () => {\n  for (const hex of ADVERSARIAL_LABEL_COLORS) {\n    const sourceHue = hueOf(`#${hex}`);\n    const { light, dark } = adaptLabelColor(hex);\n    if (sourceHue === null) continue; // achromatic input has no hue to preserve\n    for (const adapted of [light, dark]) {\n      const adaptedHue = hueOf(adapted);\n      if (adaptedHue === null) continue; // gamut clamp pushed chroma to ~0\n      const delta = Math.min(\n        Math.abs(adaptedHue - sourceHue),\n        360 - Math.abs(adaptedHue - sourceHue),\n      );\n      assert(\n        delta < 5,\n        `#${hex} hue ${sourceHue.toFixed(1)} drifted to ${\n          adaptedHue.toFixed(1)\n        } (${adapted})`,\n      );\n    }\n  }\n});\n\nDeno.test(\"adaptLabelColor is idempotent and deterministic\", () => {\n  for (const hex of ADVERSARIAL_LABEL_COLORS) {\n    const first = adaptLabelColor(hex);\n    const second = adaptLabelColor(hex);\n    assertEquals(first, second);\n\n    const reapplied = {\n      light: adaptLabelColor(first.light.replace(\"#\", \"\")).light,\n      dark: adaptLabelColor(first.dark.replace(\"#\", \"\")).dark,\n    };\n    assertEquals(reapplied, first);\n  }\n});\n\nDeno.test(\"adaptLabelColor accepts hex with or without a leading #\", () => {\n  assertEquals(adaptLabelColor(\"d73a4a\"), adaptLabelColor(\"#d73a4a\"));\n});\n",[],[371],"76ace744-e98a-42fa-99b1-de1b591cfac8","theme.ts","743531d4-7fba-11f1-b433-1607ee4eb77e",359,["D",1784091865898],2,"/**\n * Single source of truth for the recurring palette values used across\n * layout.tsx, ui.tsx, and components.tsx. Presentation-only — no local\n * imports, so importing this file can never create a cycle.\n *\n * `T`'s values are typed CSS variable references, not hex literals. The\n * `color:` type hint is mandatory: Twind infers the CSS property from the\n * *shape* of an arbitrary value, and a bare `var()` is misparsed as the\n * wrong property with no error (`text-[var(--ink)]` compiles to\n * `font-size: var(--ink)`). `text-[color:var(--ink)]` compiles correctly.\n *\n * `SCHEMES` carries the light/dark hex each variable resolves to. The\n * layout shell renders these into a `<style>` block; the contrast tests in\n * theme_test.ts assert directly against this table, not against rendered\n * output.\n *\n * Only colors that genuinely recur 2+ times across those files live here.\n * The `*Ink` tokens are the exception to the 2+ rule: ink is bound to the\n * fill it sits on, so it belongs next to that fill even at one use. Change\n * a fill here and its ink must be re-checked against the 4.5:1 floor.\n *\n * Under dual-scheme there is no such thing as a one-off tint: a color with\n * no scheme pair is a defect. The sole exception is user-authored Label\n * color, handled by `adaptLabelColor` below — the stored hex stays the\n * source of truth and is never rewritten.\n */\n\n/**\n * The Twind config the layout shell installs in the browser (via the CDN's\n * `twind.install()`) — `darkMode: 'media'` per ticket 02, plus Val Town's\n * own faces as the `font-sans`/`font-mono` stacks so existing call sites\n * (`font-sans` on the body) pick them up with no change. `css_test.ts`\n * imports this same object so Seam B compiles through the identical config\n * the browser runs, not a drifted copy.\n */\nexport const TWIND_CONFIG = {\n  darkMode: \"media\",\n  theme: {\n    extend: {\n      fontFamily: {\n        sans: [\"IBM Plex Sans\", \"-apple-system\", \"sans-serif\"],\n        mono: [\"iA Writer Mono\", \"ui-monospace\", \"Menlo\", \"monospace\"],\n      },\n    },\n  },\n} as const;\n\n/** Val Town's own faces (SIL OFL), CDN-loaded. Each stylesheet sets\n * `font-display: swap`, so text stays visible on the fallback stack while\n * these load — and stays legible via that same fallback if they never do. */\nexport const FONT_STYLESHEETS = [\n  \"https://cdn.jsdelivr.net/npm/@fontsource/ibm-plex-sans@5.2.8/latin.css\",\n  \"https://cdn.jsdelivr.net/npm/@fontsource/ia-writer-mono@5.2.5/latin-400.css\",\n] as const;\n\ntype SchemeValue = { light: string; dark: string };\n\nexport const SCHEMES = {\n  /** Page background. */\n  bg: { light: \"#ffffff\", dark: \"#000000\" },\n  /** Header / card background. Canvas, not tinted — DESIGN.md's panel. */\n  panel: { light: \"#ffffff\", dark: \"#000000\" },\n  /** Inputs, table rows, nested surfaces. DESIGN.md's \"sunken\". */\n  surface: { light: \"#f1f5f9\", dark: \"#0f172b\" },\n  /** Borders and dividers. DESIGN.md's \"rule\". */\n  border: { light: \"#e2e8f0\", dark: \"#314158\" },\n  /** Primary text. DESIGN.md's \"ink\". */\n  text: { light: \"#000000\", dark: \"#ffffff\" },\n  /** Secondary / muted text. */\n  muted: { light: \"#45556c\", dark: \"#90a1b9\" },\n  /** Links. DESIGN.md's \"signal\". */\n  link: { light: \"#0069a8\", dark: \"#00bcff\" },\n  /** Primary accent (solid buttons). DESIGN.md's \"signal\". */\n  accent: { light: \"#0069a8\", dark: \"#00bcff\" },\n  /** Text on an `accent` fill. White on light signal, black on dark signal —\n   * the required dark-mode inversion. */\n  accentInk: { light: \"#ffffff\", dark: \"#000000\" },\n  /** Danger / destructive actions. DESIGN.md's \"state-danger\". */\n  danger: { light: \"#c10007\", dark: \"#ff6467\" },\n  /** Text on a `danger` fill. Same inversion as `accentInk`. */\n  dangerInk: { light: \"#ffffff\", dark: \"#000000\" },\n  /** Open-state icon. DESIGN.md's \"state-open\". */\n  stateOpen: { light: \"#007a55\", dark: \"#00d492\" },\n  /** Success Banner fill. A low-chroma tint of `stateOpen`'s hue. */\n  bannerOkBg: { light: \"#f0fdf4\", dark: \"#052e16\" },\n  /** Error Banner fill. A low-chroma tint of `danger`'s hue. */\n  bannerErrBg: { light: \"#fef2f2\", dark: \"#450a0a\" },\n} as const satisfies Record<string, SchemeValue>;\n\ntype SchemeKey = keyof typeof SCHEMES;\n\nfunction cssVarName(key: string): string {\n  return `--${key.replace(/[A-Z]/g, (m) => `-${m.toLowerCase()}`)}`;\n}\n\nfunction typedVarRef(key: string): string {\n  return `color:var(${cssVarName(key)})`;\n}\n\nexport const T = Object.fromEntries(\n  (Object.keys(SCHEMES) as SchemeKey[]).map((key) => [key, typedVarRef(key)]),\n) as Record<SchemeKey, string>;\n\n/**\n * Ink/fill pairs that must clear the 4.5:1 contrast floor, in both schemes.\n * Exported so theme_test.ts can assert over the real pairing without\n * duplicating the list.\n */\nexport const INK_FILL_PAIRS: ReadonlyArray<[SchemeKey, SchemeKey]> = [\n  [\"text\", \"bg\"],\n  [\"muted\", \"bg\"],\n  [\"link\", \"bg\"],\n  [\"text\", \"surface\"],\n  [\"muted\", \"surface\"],\n  [\"text\", \"border\"],\n  [\"accentInk\", \"accent\"],\n  [\"dangerInk\", \"danger\"],\n  [\"stateOpen\", \"bg\"],\n  [\"stateOpen\", \"bannerOkBg\"],\n  [\"danger\", \"bannerErrBg\"],\n  [\"danger\", \"bg\"],\n];\n\n/** Attribute hook for a Label chip's computed colors. Deliberately not a\n * `class`, so Seam B's \"every class is a real Twind utility\" guard stays\n * meaningful — this selector is matched by the rule below, not by Twind. */\nexport const LABEL_CHIP_ATTR = \"data-label-chip\";\n\nexport function renderSchemeStylesheet(): string {\n  const keys = Object.keys(SCHEMES) as SchemeKey[];\n  const rule = (scheme: \"light\" | \"dark\") =>\n    keys.map((key) => `${cssVarName(key)}:${SCHEMES[key][scheme]}`).join(\";\");\n  const labelChipRule = (scheme: \"light\" | \"dark\") =>\n    `[${LABEL_CHIP_ATTR}]{color:var(--label-${scheme});border-color:var(--label-${scheme})}`;\n  return (\n    `:root{${rule(\"light\")}}${labelChipRule(\"light\")}` +\n    `@media (prefers-color-scheme:dark){:root{${rule(\"dark\")}}${\n      labelChipRule(\"dark\")\n    }}`\n  );\n}\n\n/**\n * Inline style carrying both per-scheme adapted colors as custom\n * properties. The global `[data-label-chip]` rule above selects between\n * them by `prefers-color-scheme`, so the chip stays zero-JS: no per-label\n * stylesheet, nothing computed client-side.\n */\nexport function labelChipStyle(\n  colors: { light: string; dark: string },\n): string {\n  return `--label-light:${colors.light};--label-dark:${colors.dark}`;\n}\n\n// ---------------------------------------------------------------------------\n// Label color legibility adaptation. ADR 0001 (\"Seed default labels once\")\n// establishes that initSchema() never touches Label rows after the table is\n// created — the Label set belongs entirely to the user from then on. A\n// migration that rewrote stored colors to fix contrast would violate that\n// boundary, so legibility is computed at render instead of touching storage.\n// ---------------------------------------------------------------------------\n\nconst CONTRAST_FLOOR = 4.5;\n\nfunction hexToRgb(hex: string): [number, number, number] {\n  const n = Number.parseInt(hex.replace(/^#/, \"\"), 16);\n  return [(n >> 16) & 255, (n >> 8) & 255, n & 255];\n}\n\nfunction rgbToHex([r, g, b]: [number, number, number]): string {\n  const c = (v: number) =>\n    Math.round(Math.min(255, Math.max(0, v))).toString(16).padStart(2, \"0\");\n  return `#${c(r)}${c(g)}${c(b)}`;\n}\n\nfunction srgbToLinear(c: number): number {\n  const v = c / 255;\n  return v <= 0.04045 ? v / 12.92 : ((v + 0.055) / 1.055) ** 2.4;\n}\n\nfunction linearToSrgb(v: number): number {\n  const c = v <= 0.0031308 ? v * 12.92 : 1.055 * v ** (1 / 2.4) - 0.055;\n  return c * 255;\n}\n\nfunction relativeLuminance(hex: string): number {\n  const [r, g, b] = hexToRgb(hex).map(srgbToLinear);\n  return 0.2126 * r + 0.7152 * g + 0.0722 * b;\n}\n\nfunction contrastRatio(hexA: string, hexB: string): number {\n  const a = relativeLuminance(hexA);\n  const b = relativeLuminance(hexB);\n  const [hi, lo] = a > b ? [a, b] : [b, a];\n  return (hi + 0.05) / (lo + 0.05);\n}\n\nfunction linearRgbToOklab(\n  [r, g, b]: [number, number, number],\n): [number, number, number] {\n  const l = 0.4122214708 * r + 0.5363325363 * g + 0.0514459929 * b;\n  const m = 0.2119034982 * r + 0.6806995451 * g + 0.1073969566 * b;\n  const s = 0.0883024619 * r + 0.2817188376 * g + 0.6299787005 * b;\n  const l_ = Math.cbrt(l), m_ = Math.cbrt(m), s_ = Math.cbrt(s);\n  return [\n    0.2104542553 * l_ + 0.7936177850 * m_ - 0.0040720468 * s_,\n    1.9779984951 * l_ - 2.4285922050 * m_ + 0.4505937099 * s_,\n    0.0259040371 * l_ + 0.7827717662 * m_ - 0.8086757660 * s_,\n  ];\n}\n\nfunction oklabToLinearRgb(\n  [L, a, b]: [number, number, number],\n): [number, number, number] {\n  const l_ = L + 0.3963377774 * a + 0.2158037573 * b;\n  const m_ = L - 0.1055613458 * a - 0.0638541728 * b;\n  const s_ = L - 0.0894841775 * a - 1.2914855480 * b;\n  const l = l_ ** 3, m = m_ ** 3, s = s_ ** 3;\n  return [\n    4.0767416621 * l - 3.3077115913 * m + 0.2309699292 * s,\n    -1.2684380046 * l + 2.6097574011 * m - 0.3413193965 * s,\n    -0.0041960863 * l - 0.7034186147 * m + 1.7076147010 * s,\n  ];\n}\n\ntype Oklch = { l: number; c: number; h: number };\n\nfunction hexToOklch(hex: string): Oklch {\n  const rgb = hexToRgb(hex).map(srgbToLinear) as [number, number, number];\n  const [l, a, b] = linearRgbToOklab(rgb);\n  return { l, c: Math.sqrt(a * a + b * b), h: Math.atan2(b, a) };\n}\n\n/** Converts OKLCH back to an sRGB hex, reducing chroma until in gamut. */\nfunction oklchToHex(l: number, c: number, h: number): string {\n  let chroma = c;\n  const toRgbLinear = (): [number, number, number] =>\n    oklabToLinearRgb([l, chroma * Math.cos(h), chroma * Math.sin(h)]);\n  let rgbLinear = toRgbLinear();\n  let iterations = 0;\n  const inGamut = (v: number[]) => v.every((x) => x >= -1e-4 && x <= 1 + 1e-4);\n  while (!inGamut(rgbLinear) && iterations < 40) {\n    chroma *= 0.95;\n    rgbLinear = toRgbLinear();\n    iterations++;\n  }\n  const rgb = rgbLinear.map((v) => linearToSrgb(Math.min(1, Math.max(0, v))));\n  return rgbToHex(rgb as [number, number, number]);\n}\n\n/**\n * Adapts a stored Label hex so it clears the 4.5:1 contrast floor against\n * a canvas, preserving hue and chroma (gamut-clamping chroma only if the\n * sRGB round trip requires it). Lightness is binary-searched toward the\n * canvas's opposite end; a color that already clears the floor is returned\n * unchanged (gamut-clamped only). Pure, deterministic, and idempotent —\n * applying it to its own output returns the same value.\n */\nfunction adaptForCanvas(hex: string, canvas: \"#ffffff\" | \"#000000\"): string {\n  const { l, c, h } = hexToOklch(hex);\n  const contrastAt = (candidate: number) =>\n    contrastRatio(oklchToHex(candidate, c, h), canvas);\n\n  if (contrastAt(l) >= CONTRAST_FLOOR) return oklchToHex(l, c, h);\n\n  // Against a black canvas, lighten (search upward, converge to the lowest\n  // passing L). Against a white canvas, darken (search downward, converge\n  // to the highest passing L).\n  const lighten = canvas === \"#000000\";\n  let lo = lighten ? l : 0;\n  let hi = lighten ? 1 : l;\n  for (let i = 0; i < 40; i++) {\n    const mid = (lo + hi) / 2;\n    if (contrastAt(mid) >= CONTRAST_FLOOR) {\n      if (lighten) hi = mid;\n      else lo = mid;\n    } else {\n      if (lighten) lo = mid;\n      else hi = mid;\n    }\n  }\n  return oklchToHex(lighten ? hi : lo, c, h);\n}\n\n/**\n * Computes the per-scheme adapted colors for a stored Label hex. The chip\n * carries both as inline custom properties (`--label-light`/`--label-dark`);\n * a single global rule in the rendered stylesheet selects between them by\n * `prefers-color-scheme`, so this stays zero-JS.\n */\nexport function adaptLabelColor(\n  storedHex: string,\n): { light: string; dark: string } {\n  const hex = storedHex.startsWith(\"#\") ? storedHex : `#${storedHex}`;\n  return {\n    light: adaptForCanvas(hex, \"#ffffff\"),\n    dark: adaptForCanvas(hex, \"#000000\"),\n  };\n}\n",[],[379],"c3b6b759-a45b-43a6-b028-4ca444f74f46","test_twind.ts","a5f0602c-800a-11f1-83eb-1607ee4eb77e",348,["D",1784091864692],"import { stringify, twind, virtual } from \"https://esm.sh/@twind/core@1.1.3\";\nimport presetAutoprefix from \"https://esm.sh/@twind/preset-autoprefix@1.0.7\";\nimport presetTailwind from \"https://esm.sh/@twind/preset-tailwind@1.1.4\";\nimport { TWIND_CONFIG } from \"./theme.ts\";\n\n/**\n * Seam B: compiles harvested class names through the same Twind the\n * browser runs (via the CDN's own presets), so tests assert on the CSS\n * actually emitted rather than on a list of constants a test author\n * remembered to include. Reused across tickets 02/03/05.\n */\n\n/** Every distinct token from every `class=\"...\"` attribute in `html`. */\nexport function harvestClasses(html: string): string[] {\n  const classes = new Set<string>();\n  for (const match of html.matchAll(/class=\"([^\"]*)\"/g)) {\n    for (const token of match[1].split(/\\s+/)) {\n      if (token) classes.add(token);\n    }\n  }\n  return [...classes];\n}\n\n/** Compiles `classes` through Twind and returns the emitted stylesheet. */\nexport function compileTwind(classes: string[]): string {\n  const sheet = virtual();\n  const tw = twind(\n    { presets: [presetAutoprefix(), presetTailwind()], ...TWIND_CONFIG },\n    sheet,\n  );\n  for (const className of classes) tw(className);\n  return stringify(sheet.target);\n}\n\n/** True if `css` (from `compileTwind`) contains a rule for `className`. */\nexport function emitsRule(css: string, className: string): boolean {\n  const selector = `.${className.replace(/([^a-zA-Z0-9_-])/g, \"\\\\$1\")}`;\n  let from = 0;\n  for (let index = css.indexOf(selector, from); index !== -1;) {\n    const nextChar = css[index + selector.length];\n    if (nextChar === undefined || /[{:,.\\s]/.test(nextChar)) return true;\n    from = index + 1;\n    index = css.indexOf(selector, from);\n  }\n  return false;\n}\n",[],[388],"06a3a637-e081-4666-a2b1-479fa57ef458","test_sqlite.ts","2bb2ce86-7c0d-11f1-9a68-1607ee4eb77e",220,["D",1784052697980],3,"import { DatabaseSync } from \"node:sqlite\";\n\nexport interface TestResultSet {\n  columns: string[];\n  rows: Record<string, unknown>[];\n  rowsAffected: number;\n  lastInsertRowid: bigint | undefined;\n}\n\nexport function createTestSqlite() {\n  const database = new DatabaseSync(\":memory:\");\n  database.exec(\"PRAGMA foreign_keys = ON\");\n\n  const execute = (\n    statement: string | { sql: string; args?: unknown[] },\n  ): Promise<TestResultSet> => {\n    try {\n      const sql = typeof statement === \"string\" ? statement : statement.sql;\n      const args = typeof statement === \"string\" ? [] : (statement.args ?? []);\n      const prepared = database.prepare(sql);\n      if (/^\\s*(SELECT|PRAGMA|WITH)\\b/i.test(sql)) {\n        const rows = prepared.all(...(args as never[])) as Record<\n          string,\n          unknown\n        >[];\n        return Promise.resolve({\n          columns: rows[0] ? Object.keys(rows[0]) : [],\n          rows,\n          rowsAffected: 0,\n          lastInsertRowid: undefined,\n        });\n      }\n      const result = prepared.run(...(args as never[]));\n      return Promise.resolve({\n        columns: [],\n        rows: [],\n        rowsAffected: Number(result.changes),\n        lastInsertRowid: BigInt(result.lastInsertRowid),\n      });\n    } catch (error) {\n      return Promise.reject(error);\n    }\n  };\n\n  return {\n    database,\n    execute,\n    /**\n     * Mirror the libsql `transaction(\"write\")` contract on top of node:sqlite:\n     * `BEGIN IMMEDIATE` opens an exclusive write transaction, statements run\n     * sequentially on the single in-memory connection, and `commit`/`rollback`\n     * close it. This is the same atomic-write contract `db.ts` drives in\n     * production, so the store tests exercise the real transaction path.\n     */\n    transaction(_mode?: \"write\" | \"read\" | \"deferred\") {\n      database.exec(\"BEGIN IMMEDIATE\");\n      let settled = false;\n      const finish = (verb: \"COMMIT\" | \"ROLLBACK\") => {\n        if (settled) return Promise.resolve();\n        settled = true;\n        database.exec(verb);\n        return Promise.resolve();\n      };\n      return Promise.resolve({\n        execute,\n        commit: () => finish(\"COMMIT\"),\n        rollback: () => finish(\"ROLLBACK\"),\n      });\n    },\n  };\n}\n",[],[396],"8d2480e3-0dfc-4ba9-ba40-4da9d6b62915","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",224,["D",1784052697990],13,"export { default, issueTracker, type IssueTrackerOptions } from \"./app.tsx\";\n",[],[405],"b7ee6e4d-e03e-49f9-b6a3-e9b3852a593e","main.ts",214,["D",1783790091112],11,"http","import { issueTracker } 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 { issueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n *   export default issueTracker({ 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 issueTracker({});\n",[],[414],"c030ce40-54c3-4df5-a6b2-c563732ea74e","layout.tsx","fd6015ee-7b48-11f1-bafe-1607ee4eb77e",360,["D",1784091865363],8,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\nimport {\n  FONT_STYLESHEETS,\n  renderSchemeStylesheet,\n  T,\n  TWIND_CONFIG,\n} from \"./theme.ts\";\n\nconst TAB =\n  `inline-flex items-center px-3 py-1.5 border-b-2 border-transparent text-sm no-underline`;\nconst TAB_ACTIVE = `text-[${T.text}] font-semibold border-[${T.accent}]`;\nconst TAB_IDLE = `text-[${T.muted}] hover:text-[${T.text}]`;\n\n/** Small avatar + handle chip for the top bar's right edge. */\nconst UserChip: FC<{ user: string }> = ({ user }) => (\n  <span class=\"flex items-center gap-2\">\n    <span\n      class={`w-6 h-6 rounded-full bg-[${T.border}] text-[${T.text}] text-xs flex items-center justify-center uppercase`}\n    >\n      {user.charAt(0) || \"?\"}\n    </span>\n    <span class={`text-[${T.muted}] text-[13px]`}>@{user || \"?\"}</span>\n  </span>\n);\n\nexport const Layout: FC<\n  PropsWithChildren<{\n    title: string;\n    user?: string | null;\n    auth?: boolean;\n    /** Login location supplied by the owning auth surface, when available. */\n    login?: string | null;\n    /** Mount prefix for internal links; \"\" standalone. /auth/* stays\n     * origin-level in both modes, so those links never take it. */\n    base?: string;\n    /** Which top-bar tab is the current surface. */\n    active?: \"issues\" | \"labels\";\n  }>\n> = ({\n  title,\n  user,\n  auth = true,\n  login,\n  base = \"\",\n  active,\n  children,\n}) => {\n  const signedIn = user !== null && user !== undefined;\n  const loginHref = login === undefined ? (auth ? \"/auth/login\" : null) : login;\n  const chip = signedIn ? <UserChip user={user} /> : null;\n  const logoutForm = (\n    <form method=\"post\" action=\"/auth/logout\" class=\"m-0\">\n      <button\n        type=\"submit\"\n        class={`inline-flex items-center bg-transparent border border-[${T.border}] text-[${T.text}] rounded-md px-3.5 h-8 font-medium cursor-pointer hover:brightness-110`}\n      >\n        Log out\n      </button>\n    </form>\n  );\n  const loginLink = loginHref\n    ? (\n      <a\n        href={loginHref}\n        class={`inline-flex items-center gap-1.5 bg-transparent border border-[${T.border}] text-[${T.text}] rounded-md px-3.5 h-8 font-medium no-underline hover:brightness-110`}\n      >\n        Log in\n      </a>\n    )\n    : null;\n\n  return (\n    <html lang=\"en\">\n      <head>\n        <meta charSet=\"utf-8\" />\n        <meta name=\"viewport\" content=\"width=device-width,initial-scale=1\" />\n        <title>{title}</title>\n        {FONT_STYLESHEETS.map((href) => (\n          <link key={href} rel=\"stylesheet\" href={href} />\n        ))}\n        <script src=\"https://cdn.twind.style\" crossorigin=\"anonymous\" />\n        <script\n          dangerouslySetInnerHTML={{\n            __html: `twind.install(${JSON.stringify(TWIND_CONFIG)});`,\n          }}\n        />\n        <style dangerouslySetInnerHTML={{ __html: renderSchemeStylesheet() }} />\n        <script src=\"https://esm.town/v/std/catch\" />\n      </head>\n      <body\n        class={`m-0 bg-[${T.bg}] text-[${T.text}] font-sans text-sm leading-relaxed`}\n      >\n        <header\n          class={`flex items-center gap-3 px-5 h-16 border-b border-[${T.border}] bg-[${T.panel}]`}\n        >\n          <nav class=\"flex items-center gap-1\">\n            <a\n              href={`${base}/`}\n              aria-current={active === \"issues\" ? \"page\" : undefined}\n              class={`${TAB} ${active === \"issues\" ? TAB_ACTIVE : TAB_IDLE}`}\n            >\n              Issues\n            </a>\n            <a\n              href={`${base}/labels`}\n              aria-current={active === \"labels\" ? \"page\" : undefined}\n              class={`${TAB} ${active === \"labels\" ? TAB_ACTIVE : TAB_IDLE}`}\n            >\n              Labels\n            </a>\n          </nav>\n          <span class=\"flex-1\" />\n          <a\n            href={`${base}/source`}\n            class={`text-[${T.muted}] text-xs no-underline hover:underline`}\n          >\n            view source\n          </a>\n          {chip}\n          {auth && signedIn ? logoutForm : auth ? loginLink : null}\n        </header>\n        <div class=\"max-w-[960px] mx-auto p-5\">{children}</div>\n      </body>\n    </html>\n  );\n};\n",[],[423],"e8f3483a-493a-4d4d-88b3-603627c75927","issue_query.ts","e4f0cd0a-7fdf-11f1-9d3e-1607ee4eb77e",293,["D",1784073501961],"import { ISSUE_STATUSES, type IssueStatus } from \"./db.ts\";\n\nexport type IssueQueryTokenKind =\n  | \"status\"\n  | \"assignee\"\n  | \"label\"\n  | \"author\"\n  | \"is\";\n\nexport type ParsedIssueQuery = {\n  query: string;\n  status: IssueStatus;\n  assignee?: string;\n  search?: string;\n  label?: string;\n  author?: string;\n  blocked?: boolean;\n};\n\nfunction decodeTokenValue(value: string): string {\n  try {\n    return decodeURIComponent(value);\n  } catch {\n    return value;\n  }\n}\n\nfunction normalizeHandle(value: string) {\n  return value.trim().replace(/^@/, \"\");\n}\n\nfunction tokenParts(token: string) {\n  const separator = token.indexOf(\":\");\n  if (separator < 1 || separator === token.length - 1) return null;\n  return {\n    kind: token.slice(0, separator).toLowerCase(),\n    value: decodeTokenValue(token.slice(separator + 1)).trim(),\n  };\n}\n\nexport function issueQueryToken(kind: IssueQueryTokenKind, value: string) {\n  return `${kind}:${encodeURIComponent(value)}`;\n}\n\nexport function queryWithIssueToken(\n  query: string,\n  kind: \"status\" | \"author\" | \"label\" | \"is\",\n  value: string,\n  prependIfMissing = false,\n) {\n  const replacement = issueQueryToken(kind, value);\n  const tokens = query.trim().split(/\\s+/).filter(Boolean);\n  let replaced = false;\n  const next = tokens.flatMap((token) => {\n    const parts = tokenParts(token);\n    const matches = kind === \"is\"\n      ? parts?.kind === \"is\" &&\n        (parts.value === \"blocked\" || parts.value === \"unblocked\")\n      : parts?.kind === kind;\n    if (!matches) return [token];\n    if (replaced) return [];\n    replaced = true;\n    return [replacement];\n  });\n  if (!replaced) {\n    if (prependIfMissing) next.unshift(replacement);\n    else next.push(replacement);\n  }\n  return next.join(\" \");\n}\n\nexport function parseIssueQuery(query: string): ParsedIssueQuery {\n  const tokens = query.trim().split(/\\s+/).filter(Boolean);\n  let status: IssueStatus = \"open\";\n  let assignee: string | undefined;\n  let label: string | undefined;\n  let author: string | undefined;\n  let blocked: boolean | undefined;\n  const freeText: string[] = [];\n\n  for (const token of tokens) {\n    const parts = tokenParts(token);\n    if (!parts?.value) {\n      freeText.push(token);\n      continue;\n    }\n    const { kind, value } = parts;\n    if (kind === \"status\" && ISSUE_STATUSES.includes(value as IssueStatus)) {\n      status = value as IssueStatus;\n    } else if (kind === \"assignee\") {\n      assignee = normalizeHandle(value) || undefined;\n    } else if (kind === \"label\") {\n      label = value;\n    } else if (kind === \"author\") {\n      author = normalizeHandle(value) || undefined;\n    } else if (kind === \"is\" && value === \"blocked\") {\n      blocked = true;\n    } else if (kind === \"is\" && value === \"unblocked\") {\n      blocked = false;\n    } else {\n      freeText.push(token);\n    }\n  }\n\n  return {\n    query: query.trim(),\n    status,\n    assignee,\n    label,\n    author,\n    blocked,\n    search: freeText.join(\" \") || undefined,\n  };\n}\n",[],[432],"53af2174-8384-487f-9b62-c0bb1d54c541","deno.json","0aa42a7a-7b43-11f1-9001-1607ee4eb77e",347,["D",1784091864629],9,"{\n  \"compilerOptions\": {\n    \"lib\": [\n      \"dom\",\n      \"dom.iterable\",\n      \"dom.asynciterable\",\n      \"deno.ns\",\n      \"deno.unstable\"\n    ],\n    \"noImplicitAny\": false,\n    \"strict\": false,\n    \"types\": [\"https://www.val.town/types/valtown.d.ts\"]\n  },\n  \"experimental\": {\n    \"unstable-node-globals\": true,\n    \"unstable-sloppy-imports\": true,\n    \"unstable-temporal\": true,\n    \"unstable-worker-options\": true\n  },\n  \"imports\": {\n    \"-\": \"npm:-@0.0.1-security.1\",\n    \"@std/assert\": \"jsr:@std/assert@^1.0.19\",\n    \"@types/node\": \"npm:@types/node@^26.1.1\",\n    \"hono\": \"npm:hono@^4.12.27\"\n  },\n  \"lint\": {\n    \"include\": [\"*.ts\", \"*.tsx\"],\n    \"rules\": {\n      \"exclude\": [\"no-explicit-any\", \"no-import-prefix\"]\n    }\n  },\n  \"lock\": false,\n  \"fmt\": {\n    \"exclude\": [\".vt/\", \".claude/\", \".impeccable/\"]\n  },\n  \"nodeModulesDir\": \"auto\",\n  \"tasks\": {\n    \"fmt\": \"deno fmt\",\n    \"lint\": \"deno lint\",\n    \"typecheck\": \"VAL_TOWN_API_KEY=test deno check --allow-import=esm.town,www.val.town,esm.sh,jsr.io main.ts mod.ts api.ts app.tsx components.tsx issue_query.ts ui.tsx layout.tsx theme.ts db.ts api_test.ts app_test.tsx db_test.ts theme_test.ts test_twind.ts css_test.ts\",\n    \"test\": \"VAL_TOWN_API_KEY=test deno test --allow-env=VAL_TOWN_API_KEY --allow-import=esm.town,www.val.town,esm.sh,jsr.io\",\n    \"check\": \"deno fmt --check && deno task lint && deno task typecheck && deno task test\"\n  }\n}\n",[],[440],"0dbf1004-3cf3-414b-b763-07e47315f2bb","db_test.ts","2a3ea20a-7c0d-11f1-b256-1607ee4eb77e",309,["D",1784074131149],5,"import {\n  assert,\n  assertEquals,\n  assertExists,\n  assertRejects,\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  let value = start;\n  return {\n    now: () => value,\n    tick: () => ++value,\n  };\n}\n\nDeno.test(\"issue lifecycle auto-manages status and state reason\", async () => {\n  const client = createTestSqlite();\n  client.database.exec(\"PRAGMA foreign_keys = OFF\");\n  const store = createIssueStore(client, () => 1_700_000_000_000);\n  await store.initSchema();\n  assertEquals(\n    client.database.prepare(\"PRAGMA foreign_keys\").get()?.foreign_keys,\n    1,\n    \"schema initialization must enable production foreign keys\",\n  );\n\n  const id = await store.createIssue({\n    title: \"Lifecycle\",\n    body: \"body\",\n    actor: \"alice\",\n  });\n  assertEquals((await store.getIssue(id))?.state_reason, null);\n\n  await store.closeIssue(id, \"alice\", \"not_planned\");\n  assertEquals(\n    {\n      status: (await store.getIssue(id))?.status,\n      state_reason: (await store.getIssue(id))?.state_reason,\n    },\n    { status: \"closed\", state_reason: \"not_planned\" },\n  );\n\n  await store.reopenIssue(id, \"alice\");\n  assertEquals(\n    {\n      status: (await store.getIssue(id))?.status,\n      state_reason: (await store.getIssue(id))?.state_reason,\n    },\n    { status: \"open\", state_reason: \"reopened\" },\n  );\n\n  let rejected = false;\n  try {\n    await client.execute({\n      sql:\n        \"UPDATE issue_tracker_issues SET state_reason = 'completed' WHERE id = ?\",\n      args: [id],\n    });\n  } catch {\n    rejected = true;\n  }\n  assertEquals(rejected, true, \"the schema must reject open + completed\");\n\n  const completedId = await store.createIssue({\n    title: \"Default close\",\n    actor: \"alice\",\n  });\n  await store.closeIssue(completedId, \"alice\");\n  assertEquals((await store.getIssue(completedId))?.state_reason, \"completed\");\n  const duplicateId = await store.createIssue({\n    title: \"Duplicate\",\n    actor: \"alice\",\n  });\n  await store.closeIssue(duplicateId, \"alice\", \"duplicate\");\n  assertEquals((await store.getIssue(duplicateId))?.state_reason, \"duplicate\");\n});\n\nDeno.test(\"issue lifecycle emits boundary snapshots and one delta per changed field\", async () => {\n  const client = createTestSqlite();\n  const clock = createClock();\n  const store = createIssueStore(client, clock.now);\n  await store.initSchema();\n  const id = await store.createIssue({\n    title: \"Audit\",\n    body: \"first\",\n    actor: \"alice\",\n  });\n  clock.tick();\n  await store.updateIssue(id, { title: \"Audited\", body: \"second\" }, \"bob\");\n  clock.tick();\n  await store.closeIssue(id, \"carol\", \"not_planned\");\n\n  const events = await store.listEvents({ entity: \"issue\", entityId: id });\n  assertEquals(\n    events.map((event) => event.event_type),\n    [\n      \"issue.created\",\n      \"issue.updated\",\n      \"issue.updated\",\n      \"issue.updated\",\n      \"issue.updated\",\n    ],\n  );\n  assertEquals(events[0].data, {\n    id,\n    title: \"Audit\",\n    body: \"first\",\n    status: \"open\",\n    state_reason: null,\n    created_at: 1_700_000_000_000,\n    updated_at: 1_700_000_000_000,\n  });\n  assertEquals(\n    events.slice(1).map((event) => event.data),\n    [\n      { update_target: \"title\", from: \"Audit\", to: \"Audited\" },\n      { update_target: \"body\", from: \"first\", to: \"second\" },\n      { update_target: \"status\", from: \"open\", to: \"closed\" },\n      { update_target: \"state_reason\", from: null, to: \"not_planned\" },\n    ],\n  );\n  assertEquals(\n    events.slice(3).map((event) => [event.actor, event.event_timestamp]),\n    [\n      [\"carol\", 1_700_000_000_002],\n      [\"carol\", 1_700_000_000_002],\n    ],\n  );\n\n  clock.tick();\n  await store.deleteIssue(id, \"dana\");\n  const deleted = (\n    await store.listEvents({ entity: \"issue\", entityId: id })\n  ).at(-1);\n  assertExists(deleted);\n  assertEquals(deleted.event_type, \"issue.deleted\");\n  assertEquals(deleted.actor, \"dana\");\n  assertEquals(Object.keys(deleted.data as object).sort(), [\n    \"body\",\n    \"created_at\",\n    \"id\",\n    \"state_reason\",\n    \"status\",\n    \"title\",\n    \"updated_at\",\n  ]);\n  await assertRejects(\n    () => client.execute(\"DELETE FROM issue_tracker_events WHERE id = 1\"),\n    \"append-only\",\n  );\n});\n\nDeno.test(\"labels are seeded once and relationship changes are audited and touch the issue\", async () => {\n  const client = createTestSqlite();\n  const clock = createClock();\n  const store = createIssueStore(client, clock.now);\n  await store.initSchema();\n  const defaults = await store.listLabels();\n  assertEquals(\n    defaults.map((label) => label.name),\n    [\"bug\", \"documentation\", \"duplicate\", \"enhancement\", \"question\"],\n  );\n\n  const question = defaults.find((label) => label.name === \"question\");\n  assertExists(question);\n  const seeded = await store.listEvents({\n    entity: \"label\",\n    entityId: question.id,\n  });\n  assertEquals(\n    { type: seeded[0].event_type, actor: seeded[0].actor },\n    { type: \"label.created\", actor: \"system\" },\n  );\n  assertEquals(seeded[0].data, {\n    id: question.id,\n    name: question.name,\n    color: question.color,\n    created_at: question.created_at,\n    updated_at: question.updated_at,\n  });\n  await store.deleteLabel(question.id, \"alice\");\n  const deleted = (\n    await store.listEvents({\n      entity: \"label\",\n      entityId: question.id,\n    })\n  ).at(-1);\n  assertExists(deleted);\n  assertEquals(\n    { type: deleted.event_type, actor: deleted.actor },\n    { type: \"label.deleted\", actor: \"alice\" },\n  );\n  assertEquals(deleted.data, {\n    id: question.id,\n    name: question.name,\n    color: question.color,\n    created_at: question.created_at,\n    updated_at: question.updated_at,\n  });\n  await store.initSchema();\n  assertEquals(\n    (await store.listLabels()).some((label) => label.name === \"question\"),\n    false,\n  );\n  const enhancement = defaults.find((label) => label.name === \"enhancement\");\n  assertExists(enhancement);\n  clock.tick();\n  await store.updateLabel(\n    enhancement.id,\n    { name: \"feature\", color: \"123456\" },\n    \"alice\",\n  );\n  const updatedLabel = await store.getLabel(enhancement.id);\n  assertEquals(\n    { name: updatedLabel?.name, color: updatedLabel?.color },\n    { name: \"feature\", color: \"123456\" },\n  );\n  assertEquals(\n    (await store.listEvents({ entity: \"label\", entityId: enhancement.id }))\n      .slice(-2)\n      .map((event) => event.data),\n    [\n      { update_target: \"name\", from: \"enhancement\", to: \"feature\" },\n      { update_target: \"color\", from: \"a2eeef\", to: \"123456\" },\n    ],\n  );\n  await assertRejects(\n    () => store.createLabel({ name: \"unsafe\", color: \"red;\", actor: \"alice\" }),\n    \"six hexadecimal\",\n  );\n\n  const issueId = await store.createIssue({ title: \"Labels\", actor: \"alice\" });\n  const bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n  assertExists(bug);\n  const createdIssue = await store.getIssue(issueId);\n  assertExists(createdIssue);\n  const createdAt = createdIssue.updated_at;\n  clock.tick();\n  await store.addLabel(issueId, bug.id, \"bob\");\n  const labeled = await store.getIssue(issueId);\n  assertExists(labeled);\n  assertEquals(\n    labeled.labels.map((label) => label.name),\n    [\"bug\"],\n  );\n  assert(labeled.updated_at > createdAt, \"adding a label must touch the issue\");\n  clock.tick();\n  const beforeRemovalIssue = await store.getIssue(issueId);\n  assertExists(beforeRemovalIssue);\n  const beforeLabelRemoval = beforeRemovalIssue.updated_at;\n  await store.removeLabel(issueId, bug.id, \"bob\");\n  const afterRemoval = await store.getIssue(issueId);\n  assertExists(afterRemoval);\n  assertEquals(afterRemoval.labels, []);\n  assert(\n    afterRemoval.updated_at > beforeLabelRemoval,\n    \"label removal must touch the issue\",\n  );\n  clock.tick();\n  await store.addLabel(issueId, bug.id, \"bob\");\n  clock.tick();\n  const beforeDeleteIssue = await store.getIssue(issueId);\n  assertExists(beforeDeleteIssue);\n  const beforeLabelDelete = beforeDeleteIssue.updated_at;\n  await store.deleteLabel(bug.id, \"carol\");\n  const afterDelete = await store.getIssue(issueId);\n  assertExists(afterDelete);\n  assertEquals(afterDelete.labels, []);\n  assert(\n    afterDelete.updated_at > beforeLabelDelete,\n    \"deleting an in-use label must touch the issue\",\n  );\n\n  const deltas = (\n    await store.listEvents({ entity: \"issue\", entityId: issueId })\n  )\n    .filter((event) => event.event_type === \"issue.updated\")\n    .map((event) => event.data);\n  assertEquals(deltas, [\n    { update_target: \"label\", from: null, to: \"bug\" },\n    { update_target: \"label\", from: \"bug\", to: null },\n    { update_target: \"label\", from: null, to: \"bug\" },\n    { update_target: \"label\", from: \"bug\", to: null },\n  ]);\n});\n\nDeno.test(\"assignees are a set and assigned-to-me queries the relationship\", async () => {\n  const client = createTestSqlite();\n  const clock = createClock();\n  const store = createIssueStore(client, clock.now);\n  await store.initSchema();\n  const first = await store.createIssue({ title: \"First\", actor: \"alice\" });\n  const second = await store.createIssue({ title: \"Second\", actor: \"alice\" });\n  const beforeAssignIssue = await store.getIssue(first);\n  assertExists(beforeAssignIssue);\n  const beforeAssign = beforeAssignIssue.updated_at;\n  clock.tick();\n  await store.addAssignee(first, \"alice\", \"maintainer\");\n  const afterAssign = await store.getIssue(first);\n  assertExists(afterAssign);\n  assert(\n    afterAssign.updated_at > beforeAssign,\n    \"assignment must touch the issue\",\n  );\n  await store.addAssignee(first, \"bob\", \"maintainer\");\n  await store.addAssignee(second, \"bob\", \"maintainer\");\n  const assigned = await store.getIssue(first);\n  assertExists(assigned);\n  assertEquals(assigned.assignees, [\"alice\", \"bob\"]);\n  assertEquals(\n    (await store.listIssues({ assignee: \"alice\" })).map((issue) => issue.id),\n    [first],\n  );\n  assertEquals(\n    (await store.listIssues({ assignee: \"bob\" }))\n      .map((issue) => issue.id)\n      .sort(),\n    [first, second],\n  );\n  clock.tick();\n  const beforeRemove = (await store.getIssue(first))?.updated_at ?? 0;\n  await store.removeAssignee(first, \"alice\", \"maintainer\");\n  assert(\n    (await store.getIssue(first))?.updated_at &&\n      (await store.getIssue(first))?.updated_at > beforeRemove,\n    \"unassignment must touch the issue\",\n  );\n  assertEquals(await store.listIssues({ assignee: \"alice\" }), []);\n  const deltas = (\n    await store.listEvents({ entity: \"issue\", entityId: first })\n  ).map((event) => event.data);\n  assert(\n    deltas.some(\n      (data) =>\n        JSON.stringify(data) ===\n          JSON.stringify({\n            update_target: \"assignee\",\n            from: \"alice\",\n            to: null,\n          }),\n    ),\n    \"unassignment delta missing\",\n  );\n});\n\nDeno.test(\"blocking relationships form a strict DAG and blocked state is derived\", async () => {\n  const client = createTestSqlite();\n  const clock = createClock();\n  const store = createIssueStore(client, clock.now);\n  await store.initSchema();\n  const a = await store.createIssue({ title: \"A\", actor: \"alice\" });\n  const b = await store.createIssue({ title: \"B\", actor: \"alice\" });\n  const c = await store.createIssue({ title: \"C\", actor: \"alice\" });\n  const d = await store.createIssue({ title: \"D\", actor: \"alice\" });\n\n  await assertRejects(\n    () => store.addBlock(a, a, \"blocks\", \"alice\"),\n    \"cannot block itself\",\n  );\n  const beforeBlock = (await store.getIssue(a))?.updated_at ?? 0;\n  clock.tick();\n  await store.addBlock(a, b, \"blocks\", \"alice\");\n  const afterBlockA = await store.getIssue(a);\n  assertExists(afterBlockA);\n  assert(\n    afterBlockA.updated_at > beforeBlock,\n    \"block addition must touch the acting issue\",\n  );\n  const blockedB = await store.getIssue(b);\n  assertExists(blockedB);\n  assertEquals(blockedB.blocked, true);\n  await assertRejects(() => store.addBlock(b, a, \"blocks\", \"alice\"), \"cycle\");\n  await assertRejects(\n    () =>\n      client.execute({\n        sql:\n          \"INSERT INTO issue_tracker_issue_blocks (blocker_id, blocked_id) VALUES (?, ?)\",\n        args: [b, a],\n      }),\n    \"cycle\",\n  );\n  clock.tick();\n  await store.addBlock(b, c, \"blocks\", \"alice\");\n  await assertRejects(() => store.addBlock(c, a, \"blocks\", \"alice\"), \"cycle\");\n\n  clock.tick();\n  await store.closeIssue(b, \"alice\", \"completed\");\n  const closedBlocked = await store.getIssue(b);\n  assertExists(closedBlocked);\n  assertEquals(\n    closedBlocked.blocked,\n    true,\n    \"blocked state must not prevent close\",\n  );\n  clock.tick();\n  await store.closeIssue(a, \"alice\", \"completed\");\n  const unblocked = await store.getIssue(b);\n  assertExists(unblocked);\n  assertEquals(unblocked.blocked, false);\n  const blockEvents = (\n    await store.listEvents({ entity: \"issue\", entityId: a })\n  ).filter(\n    (event) =>\n      (event.data as { update_target?: string }).update_target === \"blocks\",\n  );\n  assertEquals(blockEvents.length, 1, \"one block edge must emit one event\");\n  assertEquals(blockEvents[0].data, {\n    update_target: \"blocks\",\n    from: null,\n    to: b,\n  });\n  clock.tick();\n  await store.addBlock(d, c, \"blocked_by\", \"alice\");\n  assertEquals(\n    (await store.listEvents({ entity: \"issue\", entityId: d })).at(-1)?.data,\n    { update_target: \"blocked_by\", from: null, to: c },\n  );\n  clock.tick();\n  const beforeUnlinkIssue = await store.getIssue(d);\n  assertExists(beforeUnlinkIssue);\n  const beforeUnlink = beforeUnlinkIssue.updated_at;\n  await store.removeBlock(d, c, \"blocked_by\", \"alice\");\n  const afterUnlink = await store.getIssue(d);\n  assertExists(afterUnlink);\n  assert(\n    afterUnlink.updated_at > beforeUnlink,\n    \"block removal must touch the acting issue\",\n  );\n});\n\nDeno.test(\"comments are editable and deletable, with snapshots, deltas, and parent touches\", async () => {\n  const client = createTestSqlite();\n  const clock = createClock();\n  const store = createIssueStore(client, clock.now);\n  await store.initSchema();\n  const issueId = await store.createIssue({\n    title: \"Comments\",\n    actor: \"alice\",\n  });\n  const initialIssue = await store.getIssue(issueId);\n  assertExists(initialIssue);\n  const initialTouch = initialIssue.updated_at;\n  clock.tick();\n  const commentId = await store.createComment({\n    issueId,\n    body: \"first\",\n    actor: \"bob\",\n  });\n  const afterComment = await store.getIssue(issueId);\n  assertExists(afterComment);\n  assert(\n    afterComment.updated_at > initialTouch,\n    \"comment creation must touch parent\",\n  );\n  assertEquals((await store.listComments(issueId))[0].author, \"bob\");\n  const createdTouch = afterComment.updated_at;\n  clock.tick();\n  await store.updateComment(commentId, \"edited\", \"carol\");\n  assertEquals((await store.listComments(issueId))[0].body, \"edited\");\n  const afterEdit = await store.getIssue(issueId);\n  assertExists(afterEdit);\n  const editedTouch = afterEdit.updated_at;\n  assert(\n    editedTouch > createdTouch,\n    \"comment editing must touch the parent issue\",\n  );\n  clock.tick();\n  await store.deleteComment(commentId, \"dana\");\n  const afterDeleteComment = await store.getIssue(issueId);\n  assertExists(afterDeleteComment);\n  assert(\n    afterDeleteComment.updated_at > editedTouch,\n    \"comment deletion must touch the parent issue\",\n  );\n  assertEquals(await store.listComments(issueId), []);\n  const events = await store.listEvents({\n    entity: \"comment\",\n    entityId: commentId,\n  });\n  assertEquals(\n    events.map((event) => event.event_type),\n    [\"comment.created\", \"comment.updated\", \"comment.deleted\"],\n  );\n  assertEquals(events[1].data, {\n    update_target: \"body\",\n    from: \"first\",\n    to: \"edited\",\n  });\n  assertEquals((events[2].data as { body: string }).body, \"edited\");\n\n  clock.tick();\n  const cascadedId = await store.createComment({\n    issueId,\n    body: \"cascade\",\n    actor: \"erin\",\n  });\n  const otherId = await store.createIssue({ title: \"Other\", actor: \"erin\" });\n  const bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n  assertExists(bug);\n  await store.addLabel(issueId, bug.id, \"erin\");\n  await store.addAssignee(issueId, \"erin\", \"erin\");\n  await store.addBlock(issueId, otherId, \"blocks\", \"erin\");\n  clock.tick();\n  await store.deleteIssue(issueId, \"maintainer\");\n  assertEquals(\n    (await store.listEvents({ entity: \"comment\", entityId: cascadedId })).at(-1)\n      ?.event_type,\n    \"comment.deleted\",\n  );\n  const deletionDeltas = (\n    await store.listEvents({\n      entity: \"issue\",\n      entityId: issueId,\n    })\n  )\n    .filter((event) => event.event_type === \"issue.updated\")\n    .map((event) => event.data);\n  for (\n    const expected of [\n      { update_target: \"label\", from: \"bug\", to: null },\n      { update_target: \"assignee\", from: \"erin\", to: null },\n      { update_target: \"blocks\", from: otherId, to: null },\n    ]\n  ) {\n    assert(\n      deletionDeltas.some(\n        (data) => JSON.stringify(data) === JSON.stringify(expected),\n      ),\n      `issue deletion delta missing: ${JSON.stringify(expected)}`,\n    );\n  }\n});\n\nDeno.test(\"old-schema migration is lossless and idempotent\", async () => {\n  const client = createTestSqlite();\n  client.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  const clock = createClock(1_800_000_000_000);\n  const store = createIssueStore(client, clock.now);\n  await store.initSchema();\n\n  const first = await store.getIssue(1);\n  assertExists(first);\n  assertEquals(\n    {\n      body: first.body,\n      status: first.status,\n      state_reason: first.state_reason,\n      labels: first.labels.map((label) => label.name),\n      assignees: first.assignees,\n      creator: first.creator,\n    },\n    {\n      body: \"legacy body\",\n      status: \"open\",\n      state_reason: null,\n      labels: [\"bug\", \"custom\"],\n      assignees: [\"alice\"],\n      creator: \"owner\",\n    },\n  );\n  const second = await store.getIssue(2);\n  assertExists(second);\n  assertEquals(second.state_reason, \"completed\");\n  assertEquals((await store.listComments(1))[0], {\n    id: 7,\n    issue_id: 1,\n    body: \"legacy comment\",\n    created_at: 150,\n    updated_at: 150,\n    author: \"commenter\",\n  });\n  assertEquals(\n    (await store.listEvents({ entity: \"issue\", entityId: 1 }))[0].event_type,\n    \"issue.created\",\n  );\n  assertEquals(\n    (await store.listEvents({ entity: \"comment\", entityId: 7 }))[0].event_type,\n    \"comment.created\",\n  );\n\n  const eventCount = (await store.listEvents()).length;\n  const labels = (await store.listLabels()).map((label) => label.name);\n  await store.initSchema();\n  assertEquals((await store.listEvents()).length, eventCount);\n  assertEquals(\n    (await store.listLabels()).map((label) => label.name),\n    labels,\n  );\n  const columns = client.database\n    .prepare(\"PRAGMA table_info(issue_tracker_issues)\")\n    .all()\n    .map((row) => String(row.name));\n  assertEquals(columns, [\n    \"id\",\n    \"title\",\n    \"body\",\n    \"status\",\n    \"state_reason\",\n    \"created_at\",\n    \"updated_at\",\n  ]);\n  assertEquals(\n    client.database\n      .prepare(\"SELECT name FROM sqlite_master WHERE name LIKE '%_legacy'\")\n      .all(),\n    [],\n  );\n});\n\nDeno.test(\"old-schema migration resumes after the issue table was already renamed\", async () => {\n  const client = createTestSqlite();\n  client.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  const store = createIssueStore(client);\n  await store.initSchema();\n  assertEquals((await store.getIssue(1))?.body, \"body\");\n  assertEquals((await store.listComments(1))[0].author, \"alice\");\n  await store.initSchema();\n  assertEquals((await store.listComments(1)).length, 1);\n});\n\nDeno.test(\"store drives writes through transactions, never top-level batch\", async () => {\n  const base = createTestSqlite();\n  // A client whose top-level `batch` throws: if `db.ts` still depended on it,\n  // every multi-statement write below would fail.\n  const client = {\n    database: base.database,\n    execute: base.execute,\n    transaction: base.transaction,\n    batch() {\n      throw new Error(\"top-level batch must never be called\");\n    },\n  };\n  const store = createIssueStore(client, createClock().now);\n  await store.initSchema();\n\n  const issueId = await store.createIssue({\n    title: \"No batch\",\n    body: \"b\",\n    actor: \"alice\",\n  });\n  await store.updateIssue(issueId, { title: \"Renamed\" }, \"bob\");\n  const bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n  assertExists(bug);\n  await store.addLabel(issueId, bug.id, \"bob\");\n  await store.addAssignee(issueId, \"carol\", \"bob\");\n  const otherId = await store.createIssue({ title: \"Other\", actor: \"alice\" });\n  await store.addBlock(issueId, otherId, \"blocks\", \"bob\");\n  const commentId = await store.createComment({\n    issueId,\n    body: \"hi\",\n    actor: \"bob\",\n  });\n  await store.updateComment(commentId, \"edited\", \"bob\");\n  await store.closeIssue(issueId, \"bob\", \"completed\");\n  await store.reopenIssue(issueId, \"bob\");\n  const labelId = await store.createLabel({\n    name: \"extra\",\n    color: \"aabbcc\",\n    actor: \"bob\",\n  });\n  await store.updateLabel(labelId, { name: \"extra2\" }, \"bob\");\n  await store.removeLabel(issueId, bug.id, \"bob\");\n  await store.deleteLabel(labelId, \"bob\");\n  await store.deleteComment(commentId, \"bob\");\n  await store.deleteIssue(issueId, \"bob\");\n\n  // Everything above succeeded without the throwing batch ever firing.\n  assertEquals(\n    (await store.listIssues()).map((issue) => issue.id),\n    [otherId],\n  );\n});\n\nDeno.test(\"a forced event-insert failure rolls back the entity mutation\", async () => {\n  const base = createTestSqlite();\n  await createIssueStore(base, createClock().now).initSchema();\n\n  // Same in-memory database, but every event insert inside a transaction fails.\n  const faulty = createIssueStore(\n    {\n      execute: base.execute,\n      async transaction(mode?: \"write\" | \"read\" | \"deferred\") {\n        const tx = await base.transaction(mode);\n        return {\n          execute(statement: string | { sql: string; args?: unknown[] }) {\n            const sql = typeof statement === \"string\"\n              ? statement\n              : statement.sql;\n            if (/INSERT INTO issue_tracker_events/i.test(sql)) {\n              return Promise.reject(new Error(\"forced event insert failure\"));\n            }\n            return tx.execute(statement);\n          },\n          commit: () => tx.commit(),\n          rollback: () => tx.rollback(),\n        };\n      },\n    },\n    createClock().now,\n  );\n\n  await assertRejects(\n    () => faulty.createIssue({ title: \"Doomed\", actor: \"alice\" }),\n    Error,\n    \"forced event insert failure\",\n  );\n  // The issue INSERT that preceded the failing event insert must be rolled back.\n  assertEquals(\n    Number(\n      base.database\n        .prepare(\"SELECT COUNT(*) AS n FROM issue_tracker_issues\")\n        .get()?.n,\n    ),\n    0,\n  );\n  assertEquals(\n    Number(\n      base.database\n        .prepare(\n          \"SELECT COUNT(*) AS n FROM issue_tracker_events WHERE event_type = 'issue.created'\",\n        )\n        .get()?.n,\n    ),\n    0,\n  );\n});\n\nDeno.test(\"createIssue and createLabel return the entity id, not an event id\", async () => {\n  const client = createTestSqlite();\n  const store = createIssueStore(client, createClock().now);\n  await store.initSchema();\n\n  // Accumulate many event rows so the events table's rowid diverges sharply\n  // from the entity rowids. A broken aggregate batch would surface an event id.\n  for (let i = 0; i < 5; i++) {\n    const seedId = await store.createIssue({ title: `Seed ${i}`, actor: \"al\" });\n    await store.updateIssue(seedId, { body: `body ${i}` }, \"al\");\n    await store.createComment({ issueId: seedId, body: \"c\", actor: \"al\" });\n  }\n\n  const issueId = await store.createIssue({ title: \"Fresh\", actor: \"al\" });\n  const issue = await store.getIssue(issueId);\n  assertExists(issue);\n  assertEquals(issue.title, \"Fresh\");\n  const maxEventIdAfterIssue = Math.max(\n    ...(await store.listEvents()).map((event) => event.id),\n  );\n  assert(\n    issueId < maxEventIdAfterIssue,\n    \"createIssue returned an event id instead of the issue id\",\n  );\n\n  const labelId = await store.createLabel({\n    name: \"triage\",\n    color: \"abcdef\",\n    actor: \"al\",\n  });\n  const label = await store.getLabel(labelId);\n  assertExists(label);\n  assertEquals(label.name, \"triage\");\n  const maxEventIdAfterLabel = Math.max(\n    ...(await store.listEvents()).map((event) => event.id),\n  );\n  assert(\n    labelId < maxEventIdAfterLabel,\n    \"createLabel returned an event id instead of the label id\",\n  );\n});\n\nDeno.test(\"aggregate issue creation rolls back when a requested label is stale\", async () => {\n  const client = createTestSqlite();\n  const store = createIssueStore(client, createClock().now);\n  await store.initSchema();\n\n  await assertRejects(\n    () =>\n      store.createIssueAggregate({\n        title: \"Must not survive\",\n        actor: \"alice\",\n        labelIds: [999_999],\n        assignees: [\"bob\"],\n      }),\n    Error,\n    \"Label #999999 not found.\",\n  );\n  assertEquals(await store.listIssues(), []);\n  assertEquals(await store.listEvents({ entity: \"issue\" }), []);\n});\n\nDeno.test(\"aggregate issue creation preserves event order and provenance\", async () => {\n  const clock = createClock();\n  const store = createIssueStore(createTestSqlite(), clock.now);\n  await store.initSchema();\n  const bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n  assertExists(bug);\n\n  const id = await store.createIssueAggregate({\n    title: \"Atomic issue\",\n    body: \"body\",\n    actor: \"alice\",\n    labelIds: [bug.id],\n    assignees: [\"bob\"],\n  });\n  const issue = await store.getIssue(id);\n  assertExists(issue);\n  assertEquals(issue.labels.map((label) => label.name), [\"bug\"]);\n  assertEquals(issue.assignees, [\"bob\"]);\n  const events = await store.listEvents({ entity: \"issue\", entityId: id });\n  assertEquals(\n    events.map((event) => [event.event_type, event.actor]),\n    [\n      [\"issue.created\", \"alice\"],\n      [\"issue.updated\", \"alice\"],\n      [\"issue.updated\", \"alice\"],\n    ],\n  );\n  assertEquals(\n    events.slice(1).map((event) => event.data),\n    [\n      { update_target: \"label\", from: null, to: \"bug\" },\n      { update_target: \"assignee\", from: null, to: \"bob\" },\n    ],\n  );\n  assertEquals(new Set(events.map((event) => event.event_timestamp)).size, 1);\n  assertEquals(issue.updated_at, events[0].event_timestamp);\n});\n\nDeno.test(\"aggregate issue creation rolls back labels and events after a later failure\", async () => {\n  const base = createTestSqlite();\n  const seedStore = createIssueStore(base, createClock().now);\n  await seedStore.initSchema();\n  const bug = (await seedStore.listLabels()).find((label) =>\n    label.name === \"bug\"\n  );\n  assertExists(bug);\n\n  const faulty = createIssueStore(\n    {\n      execute: base.execute,\n      async transaction(mode?: \"write\" | \"read\" | \"deferred\") {\n        const tx = await base.transaction(mode);\n        return {\n          execute(statement: string | { sql: string; args?: unknown[] }) {\n            const sql = typeof statement === \"string\"\n              ? statement\n              : statement.sql;\n            if (/INSERT INTO issue_tracker_issue_assignees/i.test(sql)) {\n              return Promise.reject(\n                new Error(\"forced assignee insert failure\"),\n              );\n            }\n            return tx.execute(statement);\n          },\n          commit: () => tx.commit(),\n          rollback: () => tx.rollback(),\n        };\n      },\n    },\n    createClock().now,\n  );\n\n  await assertRejects(\n    () =>\n      faulty.createIssueAggregate({\n        title: \"Partially assembled\",\n        actor: \"alice\",\n        labelIds: [bug.id],\n        assignees: [\"bob\"],\n      }),\n    Error,\n    \"forced assignee insert failure\",\n  );\n  assertEquals(await seedStore.listIssues(), []);\n  assertEquals(await seedStore.listEvents({ entity: \"issue\" }), []);\n  assertEquals(\n    Number(\n      base.database.prepare(\n        \"SELECT COUNT(*) AS n FROM issue_tracker_issue_labels\",\n      ).get()?.n,\n    ),\n    0,\n  );\n});\n\nDeno.test(\"list row projection uses a bounded query count\", async () => {\n  const base = createTestSqlite();\n  let queryCount = 0;\n  const store = createIssueStore({\n    execute(statement) {\n      queryCount++;\n      return base.execute(statement);\n    },\n    transaction: (mode) => base.transaction(mode),\n  });\n  await store.initSchema();\n  const bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n  assertExists(bug);\n  for (let index = 0; index < 8; index++) {\n    const id = await store.createIssue({\n      title: `Issue ${index}`,\n      actor: \"al\",\n    });\n    await store.addLabel(id, bug.id, \"al\");\n    await store.addAssignee(id, \"al\", \"al\");\n    await store.createComment({ issueId: id, body: \"comment\", actor: \"al\" });\n  }\n\n  queryCount = 0;\n  const rows = await store.listIssueRows();\n  assertEquals(rows.length, 8);\n  assert(rows.every((row) => row.commentCount === 1));\n  assert(rows.every((row) => row.labels[0]?.name === \"bug\"));\n  assertEquals(\n    queryCount,\n    6,\n    \"list rows must use a fixed base + association + comment projection\",\n  );\n});\n\nDeno.test(\"label summaries count open issues in one query\", async () => {\n  const base = createTestSqlite();\n  let queryCount = 0;\n  const store = createIssueStore({\n    execute(statement) {\n      queryCount++;\n      return base.execute(statement);\n    },\n    transaction: (mode) => base.transaction(mode),\n  });\n  await store.initSchema();\n  const labels = await store.listLabels();\n  const bug = labels.find((label) => label.name === \"bug\");\n  const question = labels.find((label) => label.name === \"question\");\n  assertExists(bug);\n  assertExists(question);\n\n  const open = await store.createIssue({ title: \"Open bug\", actor: \"al\" });\n  await store.addLabel(open, bug.id, \"al\");\n  const closed = await store.createIssue({ title: \"Closed bug\", actor: \"al\" });\n  await store.addLabel(closed, bug.id, \"al\");\n  await store.addLabel(closed, question.id, \"al\");\n  await store.closeIssue(closed, \"al\");\n\n  queryCount = 0;\n  const summaries = await store.listLabelSummaries();\n  assertEquals(\n    summaries.map((label) => [label.name, label.openIssueCount]),\n    [\n      [\"bug\", 1],\n      [\"documentation\", 0],\n      [\"duplicate\", 0],\n      [\"enhancement\", 0],\n      [\"question\", 0],\n    ],\n    \"closed issues must not count toward a label's open-issue count\",\n  );\n  assertEquals(\n    queryCount,\n    1,\n    \"open-issue counts must come from a render-time join, not in-memory aggregation\",\n  );\n\n  assertEquals(\n    (await store.listLabelSummaries({ search: \"UG\" })).map((label) =>\n      label.name\n    ),\n    [\"bug\"],\n    \"search filters by name, case-insensitively, in the query\",\n  );\n  assertEquals(await store.listLabelSummaries({ search: \"%\" }), []);\n});\n",[],[449],"7b119f85-200c-4072-84ea-c353d8eab4d1","db.ts","8f4470ca-7b3c-11f1-b527-1607ee4eb77e",313,["D",1784074131521],"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  \"completed\",\n  \"not_planned\",\n  \"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 type HttpErrorStatus = 400 | 404 | 409;\n\n/** A domain error carrying the HTTP status the JSON API should map it to. */\nexport class HttpError extends Error {\n  readonly status: HttpErrorStatus;\n  constructor(status: HttpErrorStatus, message: string) {\n    super(message);\n    this.name = \"HttpError\";\n    this.status = status;\n  }\n}\n\nexport interface Label {\n  id: number;\n  name: string;\n  color: string;\n  created_at: number;\n  updated_at: number;\n}\n\n/** A label plus the number of open issues carrying it, for the labels page. */\nexport type LabelSummary = Label & { openIssueCount: number };\n\nexport interface IssueReference {\n  id: number;\n  title: string;\n  status: IssueStatus;\n  state_reason: StateReason;\n}\n\nexport interface Issue extends IssueReference {\n  body: string;\n  created_at: number;\n  updated_at: number;\n  creator: string | null;\n  labels: Label[];\n  assignees: string[];\n  blockers: IssueReference[];\n  blocks: IssueReference[];\n  blocked: boolean;\n}\n\nexport type IssueListRow = Issue & { commentCount: number };\n\nexport interface Comment {\n  id: number;\n  issue_id: number;\n  body: string;\n  created_at: number;\n  updated_at: number;\n  author: string | null;\n}\n\nexport type EventType =\n  | \"issue.created\"\n  | \"issue.updated\"\n  | \"issue.deleted\"\n  | \"comment.created\"\n  | \"comment.updated\"\n  | \"comment.deleted\"\n  | \"label.created\"\n  | \"label.updated\"\n  | \"label.deleted\";\n\nexport interface TrackerEvent {\n  id: number;\n  event_type: EventType;\n  entity_id: number;\n  actor: string;\n  data: unknown;\n  event_timestamp: number;\n}\n\ntype SqlValue = null | string | number | bigint | boolean | Uint8Array;\ntype Statement = string | { sql: string; args?: SqlValue[] };\n\nexport interface ExecuteResult {\n  rows: Record<string, unknown>[];\n  rowsAffected: number;\n  lastInsertRowid?: bigint;\n}\n\n/**\n * The subset of the libsql `Transaction` contract `db.ts` relies on. A\n * transaction shares one connection, so sequential `execute` calls see each\n * other's writes (including `last_insert_rowid()`) and are isolated until\n * `commit`. `rollback` discards every buffered statement.\n */\nexport interface SqliteTransaction {\n  execute(statement: Statement): Promise<ExecuteResult>;\n  commit(): Promise<void>;\n  rollback(): Promise<void>;\n}\n\nexport interface SqliteClient {\n  execute(statement: Statement): Promise<ExecuteResult>;\n  transaction(mode?: \"write\" | \"read\" | \"deferred\"): Promise<SqliteTransaction>;\n}\n\nconst TABLES = {\n  issues: \"issue_tracker_issues\",\n  comments: \"issue_tracker_comments\",\n  labels: \"issue_tracker_labels\",\n  issueLabels: \"issue_tracker_issue_labels\",\n  assignees: \"issue_tracker_issue_assignees\",\n  blocks: \"issue_tracker_issue_blocks\",\n  events: \"issue_tracker_events\",\n} as const;\n\nexport const DEFAULT_LABELS = [\n  { name: \"bug\", color: \"d73a4a\" },\n  { name: \"enhancement\", color: \"a2eeef\" },\n  { name: \"documentation\", color: \"0075ca\" },\n  { name: \"question\", color: \"d876e3\" },\n  { name: \"duplicate\", color: \"cfd3d7\" },\n] as const;\n\nfunction number(value: unknown): number {\n  return Number(value);\n}\n\nfunction toLabel(row: Record<string, unknown>): Label {\n  return {\n    id: number(row.id),\n    name: String(row.name),\n    color: String(row.color),\n    created_at: number(row.created_at),\n    updated_at: number(row.updated_at),\n  };\n}\n\n/**\n * A substring pattern for `LIKE ? ESCAPE '\\'`, with the caller's own `%` and\n * `_` escaped so they match themselves instead of acting as wildcards.\n */\nfunction containsPattern(search: string): string {\n  return `%${search.replace(/[\\\\%_]/g, \"\\\\$&\")}%`;\n}\n\nfunction parseJson(value: unknown): unknown {\n  if (typeof value !== \"string\") return value;\n  try {\n    return JSON.parse(value);\n  } catch {\n    return null;\n  }\n}\n\nfunction normalizeColor(color: string): string {\n  const normalized = color.replace(/^#/, \"\").toLowerCase();\n  if (!/^[0-9a-f]{6}$/.test(normalized)) {\n    throw new HttpError(\n      400,\n      \"Label color must be exactly six hexadecimal characters.\",\n    );\n  }\n  return normalized;\n}\n\nfunction labelSnapshot(label: Label) {\n  return {\n    id: label.id,\n    name: label.name,\n    color: label.color,\n    created_at: label.created_at,\n    updated_at: label.updated_at,\n  };\n}\n\nfunction commentSnapshot(comment: Omit<Comment, \"author\">) {\n  return {\n    id: comment.id,\n    issue_id: comment.issue_id,\n    body: comment.body,\n    created_at: comment.created_at,\n    updated_at: comment.updated_at,\n  };\n}\n\nexport function createIssueStore(\n  client: SqliteClient,\n  now: () => number = Date.now,\n) {\n  /**\n   * Run every statement inside a single atomic `\"write\"` transaction, mirroring\n   * the guarantee `sqlite.batch(stmts, \"write\")` was assumed to provide but\n   * never did for the resolved adapter. Statements execute sequentially on one\n   * connection, so parameterized args, `last_insert_rowid()`, and one result\n   * per statement are preserved. Any failure rolls the whole batch back and\n   * rethrows the original error; success commits.\n   */\n  async function withWriteTransaction<T>(\n    operation: (transaction: SqliteTransaction) => Promise<T>,\n  ): Promise<T> {\n    const transaction = await client.transaction(\"write\");\n    try {\n      const result = await operation(transaction);\n      await transaction.commit();\n      return result;\n    } catch (error) {\n      try {\n        await transaction.rollback();\n      } catch {\n        // Preserve the original failure; a rollback error must not mask it.\n      }\n      throw error;\n    }\n  }\n\n  async function atomicWrite(\n    statements: Statement[],\n  ): Promise<ExecuteResult[]> {\n    return await withWriteTransaction(async (transaction) => {\n      const results: ExecuteResult[] = [];\n      for (const statement of statements) {\n        results.push(await transaction.execute(statement));\n      }\n      return results;\n    });\n  }\n\n  async function tableExists(name: string): Promise<boolean> {\n    const result = await client.execute({\n      sql:\n        \"SELECT 1 AS found FROM sqlite_master WHERE type = 'table' AND name = ?\",\n      args: [name],\n    });\n    return result.rows.length > 0;\n  }\n\n  async function tableColumns(name: string): Promise<string[]> {\n    if (!(await tableExists(name))) return [];\n    const result = await client.execute(`PRAGMA table_info(${name})`);\n    return result.rows.map((row) => String(row.name));\n  }\n\n  async function createFinalTables(): Promise<void> {\n    const labelsAreNew = !(await tableExists(TABLES.labels));\n    const statements: Statement[] = [\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      `CREATE INDEX IF NOT EXISTS idx_${TABLES.issues}_status ON ${TABLES.issues}(status)`,\n      `CREATE INDEX IF NOT EXISTS idx_${TABLES.comments}_issue ON ${TABLES.comments}(issue_id)`,\n      `CREATE INDEX IF NOT EXISTS idx_${TABLES.assignees}_user ON ${TABLES.assignees}(user_handle)`,\n      `CREATE INDEX IF NOT EXISTS idx_${TABLES.blocks}_blocked ON ${TABLES.blocks}(blocked_id)`,\n      `CREATE INDEX IF NOT EXISTS idx_${TABLES.events}_entity ON ${TABLES.events}(event_type, entity_id, id)`,\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n      {\n        sql: `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      },\n    ];\n    if (labelsAreNew) {\n      const timestamp = now();\n      for (const label of DEFAULT_LABELS) {\n        statements.push(\n          {\n            sql:\n              `INSERT OR IGNORE INTO ${TABLES.labels} (name, color, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n            args: [label.name, label.color, timestamp, timestamp],\n          },\n          {\n            sql:\n              `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            args: [timestamp, label.name],\n          },\n        );\n      }\n    }\n    await atomicWrite(statements);\n  }\n\n  async function emitCreatedLabel(\n    name: string,\n    color: string,\n    actor: string,\n    timestamp: number,\n  ): Promise<number> {\n    const results = await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.labels} (name, color, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n        args: [name, color, timestamp, timestamp],\n      },\n      {\n        sql:\n          `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        args: [actor, timestamp],\n      },\n    ]);\n    return number(results[0].lastInsertRowid);\n  }\n\n  async function migrateLegacyRows(): Promise<void> {\n    const legacyIssues = \"issue_tracker_issues_legacy\";\n    if (!(await tableExists(legacyIssues))) return;\n    const issueRows = (await client.execute(`SELECT * FROM ${legacyIssues}`))\n      .rows;\n    const legacyComments = \"issue_tracker_comments_legacy\";\n    const commentRows = (await tableExists(legacyComments))\n      ? (await client.execute(`SELECT * FROM ${legacyComments}`)).rows\n      : [];\n    const timestamp = now();\n    const statements: Statement[] = [];\n\n    for (const row of issueRows) {\n      const id = number(row.id);\n      const status: IssueStatus = row.status === \"closed\" ? \"closed\" : \"open\";\n      const stateReason: StateReason = status === \"closed\" ? \"completed\" : null;\n      const createdAt = number(row.created_at);\n      const updatedAt = number(row.updated_at);\n      const snapshot = {\n        id,\n        title: String(row.title),\n        body: String(row.description ?? \"\"),\n        status,\n        state_reason: stateReason,\n        created_at: createdAt,\n        updated_at: updatedAt,\n      };\n      const actor = String(row.created_by ?? \"migration\");\n      statements.push(\n        {\n          sql: `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          args: [\n            id,\n            snapshot.title,\n            snapshot.body,\n            status,\n            stateReason,\n            createdAt,\n            updatedAt,\n          ],\n        },\n        {\n          sql:\n            `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          args: [id, actor, JSON.stringify(snapshot), createdAt, id],\n        },\n      );\n\n      let legacyLabels: string[] = [];\n      try {\n        const parsed = JSON.parse(String(row.labels ?? \"[]\"));\n        if (Array.isArray(parsed)) {\n          legacyLabels = parsed.filter((item) => typeof item === \"string\");\n        }\n      } catch {\n        legacyLabels = [];\n      }\n      for (const name of legacyLabels) {\n        const color = DEFAULT_LABELS.find((label) =>\n          label.name === name\n        )?.color ??\n          \"8b949e\";\n        statements.push(\n          {\n            sql:\n              `INSERT OR IGNORE INTO ${TABLES.labels} (name, color, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n            args: [name, color, timestamp, timestamp],\n          },\n          {\n            sql:\n              `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            args: [timestamp, name],\n          },\n          {\n            sql:\n              `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            args: [id, name],\n          },\n          {\n            sql:\n              `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            args: [\n              id,\n              actor,\n              JSON.stringify({ update_target: \"label\", from: null, to: name }),\n              updatedAt,\n              id,\n              JSON.stringify({ update_target: \"label\", from: null, to: name }),\n            ],\n          },\n        );\n      }\n\n      const assignee = typeof row.assignee === \"string\"\n        ? row.assignee.trim().replace(/^@/, \"\")\n        : \"\";\n      if (assignee) {\n        const data = JSON.stringify({\n          update_target: \"assignee\",\n          from: null,\n          to: assignee,\n        });\n        statements.push(\n          {\n            sql:\n              `INSERT OR IGNORE INTO ${TABLES.assignees} (issue_id, user_handle) VALUES (?, ?)`,\n            args: [id, assignee],\n          },\n          {\n            sql:\n              `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            args: [id, actor, data, updatedAt, id, data],\n          },\n        );\n      }\n    }\n\n    for (const row of commentRows) {\n      const id = number(row.id);\n      const issueId = number(row.issue_id);\n      const createdAt = number(row.created_at);\n      const snapshot = {\n        id,\n        issue_id: issueId,\n        body: String(row.body),\n        created_at: createdAt,\n        updated_at: createdAt,\n      };\n      statements.push(\n        {\n          sql: `INSERT OR IGNORE INTO ${TABLES.comments}\n\t\t\t\t\t\t(id, issue_id, body, created_at, updated_at) VALUES (?, ?, ?, ?, ?)`,\n          args: [id, issueId, snapshot.body, createdAt, createdAt],\n        },\n        {\n          sql:\n            `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          args: [\n            id,\n            String(row.author ?? \"migration\"),\n            JSON.stringify(snapshot),\n            createdAt,\n            id,\n          ],\n        },\n      );\n    }\n    statements.push(\n      `DROP TABLE IF EXISTS ${legacyComments}`,\n      `DROP TABLE ${legacyIssues}`,\n    );\n    await atomicWrite(statements);\n  }\n\n  async function initSchema(): Promise<void> {\n    await client.execute(\"PRAGMA foreign_keys = ON\");\n    if (!(await tableExists(TABLES.issues)) && (await tableExists(\"issues\"))) {\n      await client.execute(`ALTER TABLE issues RENAME TO ${TABLES.issues}`);\n    }\n    if (\n      !(await tableExists(TABLES.comments)) &&\n      (await tableExists(\"comments\"))\n    ) {\n      await client.execute(`ALTER TABLE comments RENAME TO ${TABLES.comments}`);\n    }\n\n    const columns = await tableColumns(TABLES.issues);\n    if (\n      columns.includes(\"description\") &&\n      !(await tableExists(\"issue_tracker_issues_legacy\"))\n    ) {\n      await client.execute(\n        `ALTER TABLE ${TABLES.issues} RENAME TO issue_tracker_issues_legacy`,\n      );\n      if (await tableExists(TABLES.comments)) {\n        await client.execute(\n          `ALTER TABLE ${TABLES.comments} RENAME TO issue_tracker_comments_legacy`,\n        );\n      }\n    }\n\n    if (\n      (await tableExists(\"issue_tracker_issues_legacy\")) &&\n      !(await tableExists(\"issue_tracker_comments_legacy\")) &&\n      (await tableColumns(TABLES.comments)).includes(\"author\")\n    ) {\n      await client.execute(\n        `ALTER TABLE ${TABLES.comments} RENAME TO issue_tracker_comments_legacy`,\n      );\n    }\n\n    await createFinalTables();\n    await migrateLegacyRows();\n  }\n\n  async function getBaseIssue(id: number) {\n    const result = await client.execute({\n      sql: `SELECT * FROM ${TABLES.issues} WHERE id = ?`,\n      args: [id],\n    });\n    const row = result.rows[0];\n    if (!row) return null;\n    return {\n      id: number(row.id),\n      title: String(row.title),\n      body: String(row.body),\n      status: row.status as IssueStatus,\n      state_reason: (row.state_reason ?? null) as StateReason,\n      created_at: number(row.created_at),\n      updated_at: number(row.updated_at),\n    };\n  }\n\n  async function getIssue(id: number): Promise<Issue | null> {\n    const issue = await getBaseIssue(id);\n    if (!issue) return null;\n    const [labelRows, assigneeRows, blockerRows, blocksRows, creatorRows] =\n      await Promise.all([\n        client.execute({\n          sql: `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          args: [id],\n        }),\n        client.execute({\n          sql:\n            `SELECT user_handle FROM ${TABLES.assignees} WHERE issue_id = ? ORDER BY user_handle`,\n          args: [id],\n        }),\n        client.execute({\n          sql: `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          args: [id],\n        }),\n        client.execute({\n          sql: `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          args: [id],\n        }),\n        client.execute({\n          sql: `SELECT actor FROM ${TABLES.events}\n\t\t\t\t\tWHERE event_type = 'issue.created' AND entity_id = ? ORDER BY id LIMIT 1`,\n          args: [id],\n        }),\n      ]);\n    const labels: Label[] = labelRows.rows.map(toLabel);\n    const toReference = (row: Record<string, unknown>): IssueReference => ({\n      id: number(row.id),\n      title: String(row.title),\n      status: row.status as IssueStatus,\n      state_reason: (row.state_reason ?? null) as StateReason,\n    });\n    const blockers = blockerRows.rows.map(toReference);\n    return {\n      ...issue,\n      creator: creatorRows.rows[0] ? String(creatorRows.rows[0].actor) : null,\n      labels,\n      assignees: assigneeRows.rows.map((row) => String(row.user_handle)),\n      blockers,\n      blocks: blocksRows.rows.map(toReference),\n      blocked: blockers.some((blocker) => blocker.status === \"open\"),\n    };\n  }\n\n  async function listIssues(\n    opts: {\n      status?: IssueStatus;\n      label?: string;\n      assignee?: string;\n      search?: string;\n    } = {},\n  ): Promise<Issue[]> {\n    let sql = `SELECT issue.*,\n      (SELECT actor FROM ${TABLES.events}\n       WHERE event_type = 'issue.created' AND entity_id = issue.id\n       ORDER BY id LIMIT 1) AS creator\n      FROM ${TABLES.issues} issue`;\n    const conditions: string[] = [];\n    const args: SqlValue[] = [];\n    if (opts.status) {\n      conditions.push(\"issue.status = ?\");\n      args.push(opts.status);\n    }\n    if (opts.label) {\n      conditions.push(\n        `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      );\n      args.push(opts.label);\n    }\n    if (opts.assignee) {\n      conditions.push(\n        `EXISTS (SELECT 1 FROM ${TABLES.assignees} ia WHERE ia.issue_id = issue.id AND ia.user_handle = ?)`,\n      );\n      args.push(opts.assignee);\n    }\n    if (opts.search) {\n      conditions.push(\"(issue.title LIKE ? OR issue.body LIKE ?)\");\n      args.push(`%${opts.search}%`, `%${opts.search}%`);\n    }\n    if (conditions.length) sql += ` WHERE ${conditions.join(\" AND \")}`;\n    sql += \" ORDER BY issue.updated_at DESC, issue.id DESC\";\n    const result = await client.execute({ sql, args });\n    if (!result.rows.length) return [];\n\n    const ids = result.rows.map((row) => number(row.id));\n    const placeholders = ids.map(() => \"?\").join(\", \");\n    const [labelRows, assigneeRows, blockerRows, blocksRows] = await Promise\n      .all([\n        client.execute({\n          sql: `SELECT link.issue_id, label.* FROM ${TABLES.issueLabels} link\n          JOIN ${TABLES.labels} label ON label.id = link.label_id\n          WHERE link.issue_id IN (${placeholders}) ORDER BY label.name`,\n          args: ids,\n        }),\n        client.execute({\n          sql: `SELECT issue_id, user_handle FROM ${TABLES.assignees}\n          WHERE issue_id IN (${placeholders}) ORDER BY user_handle`,\n          args: ids,\n        }),\n        client.execute({\n          sql: `SELECT edge.blocked_id AS issue_id, issue.id, issue.title,\n          issue.status, issue.state_reason\n          FROM ${TABLES.blocks} edge\n          JOIN ${TABLES.issues} issue ON issue.id = edge.blocker_id\n          WHERE edge.blocked_id IN (${placeholders}) ORDER BY issue.id`,\n          args: ids,\n        }),\n        client.execute({\n          sql: `SELECT edge.blocker_id AS issue_id, issue.id, issue.title,\n          issue.status, issue.state_reason\n          FROM ${TABLES.blocks} edge\n          JOIN ${TABLES.issues} issue ON issue.id = edge.blocked_id\n          WHERE edge.blocker_id IN (${placeholders}) ORDER BY issue.id`,\n          args: ids,\n        }),\n      ]);\n\n    const labels = new Map<number, Label[]>();\n    for (const row of labelRows.rows) {\n      const issueLabels = labels.get(number(row.issue_id)) ?? [];\n      issueLabels.push(toLabel(row));\n      labels.set(number(row.issue_id), issueLabels);\n    }\n    const assignees = new Map<number, string[]>();\n    for (const row of assigneeRows.rows) {\n      const issueAssignees = assignees.get(number(row.issue_id)) ?? [];\n      issueAssignees.push(String(row.user_handle));\n      assignees.set(number(row.issue_id), issueAssignees);\n    }\n    const toReference = (row: Record<string, unknown>): IssueReference => ({\n      id: number(row.id),\n      title: String(row.title),\n      status: row.status as IssueStatus,\n      state_reason: (row.state_reason ?? null) as StateReason,\n    });\n    const groupReferences = (rows: Record<string, unknown>[]) => {\n      const grouped = new Map<number, IssueReference[]>();\n      for (const row of rows) {\n        const references = grouped.get(number(row.issue_id)) ?? [];\n        references.push(toReference(row));\n        grouped.set(number(row.issue_id), references);\n      }\n      return grouped;\n    };\n    const blockers = groupReferences(blockerRows.rows);\n    const blocks = groupReferences(blocksRows.rows);\n\n    return result.rows.map((row) => {\n      const id = number(row.id);\n      const issueBlockers = blockers.get(id) ?? [];\n      return {\n        id,\n        title: String(row.title),\n        body: String(row.body),\n        status: row.status as IssueStatus,\n        state_reason: (row.state_reason ?? null) as StateReason,\n        created_at: number(row.created_at),\n        updated_at: number(row.updated_at),\n        creator: row.creator === null || row.creator === undefined\n          ? null\n          : String(row.creator),\n        labels: labels.get(id) ?? [],\n        assignees: assignees.get(id) ?? [],\n        blockers: issueBlockers,\n        blocks: blocks.get(id) ?? [],\n        blocked: issueBlockers.some((blocker) => blocker.status === \"open\"),\n      };\n    });\n  }\n\n  async function listIssueRows(\n    opts: {\n      status?: IssueStatus;\n      label?: string;\n      assignee?: string;\n      search?: string;\n    } = {},\n  ): Promise<IssueListRow[]> {\n    const issues = await listIssues(opts);\n    if (!issues.length) return [];\n    const ids = issues.map((issue) => issue.id);\n    const result = await client.execute({\n      sql: `SELECT issue_id, COUNT(*) AS comment_count FROM ${TABLES.comments}\n        WHERE issue_id IN (${ids.map(() => \"?\").join(\", \")})\n        GROUP BY issue_id`,\n      args: ids,\n    });\n    const counts = new Map(\n      result.rows.map((row) => [\n        number(row.issue_id),\n        number(row.comment_count),\n      ]),\n    );\n    return issues.map((issue) => ({\n      ...issue,\n      commentCount: counts.get(issue.id) ?? 0,\n    }));\n  }\n\n  async function listIssueAuthors(): Promise<string[]> {\n    const result = await client.execute(\n      `SELECT DISTINCT actor FROM ${TABLES.events}\n       WHERE event_type = 'issue.created' ORDER BY actor`,\n    );\n    return result.rows.map((row) => String(row.actor));\n  }\n\n  async function createIssue(data: {\n    title: string;\n    body?: string;\n    actor: string;\n  }): Promise<number> {\n    const timestamp = now();\n    const results = await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.issues} (title, body, status, state_reason, created_at, updated_at)\n\t\t\t\t\t\tVALUES (?, ?, 'open', NULL, ?, ?)`,\n        args: [data.title, data.body ?? \"\", timestamp, timestamp],\n      },\n      {\n        sql:\n          `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        args: [data.actor, timestamp],\n      },\n    ]);\n    return number(results[0].lastInsertRowid);\n  }\n\n  async function createIssueAggregate(data: {\n    title: string;\n    body?: string;\n    actor: string;\n    labelIds?: number[];\n    assignees?: string[];\n  }): Promise<number> {\n    const timestamp = now();\n    const labelIds = [...new Set(data.labelIds ?? [])];\n    const assignees = [...new Set(data.assignees ?? [])];\n    return await withWriteTransaction(async (transaction) => {\n      const created = await transaction.execute({\n        sql: `INSERT INTO ${TABLES.issues}\n          (title, body, status, state_reason, created_at, updated_at)\n          VALUES (?, ?, 'open', NULL, ?, ?)`,\n        args: [data.title, data.body ?? \"\", timestamp, timestamp],\n      });\n      const id = number(created.lastInsertRowid);\n      await transaction.execute({\n        sql: `INSERT INTO ${TABLES.events}\n          (event_type, entity_id, actor, data, event_timestamp)\n          SELECT 'issue.created', id, ?, json_object(\n            'id', id, 'title', title, 'body', body, 'status', status,\n            'state_reason', state_reason, 'created_at', created_at,\n            'updated_at', updated_at\n          ), ? FROM ${TABLES.issues} WHERE id = ?`,\n        args: [data.actor, timestamp, id],\n      });\n\n      for (const labelId of labelIds) {\n        const labelResult = await transaction.execute({\n          sql: `SELECT name FROM ${TABLES.labels} WHERE id = ?`,\n          args: [labelId],\n        });\n        const label = labelResult.rows[0];\n        if (!label) throw new HttpError(404, `Label #${labelId} not found.`);\n        await transaction.execute({\n          sql: `INSERT INTO ${TABLES.issueLabels} (issue_id, label_id)\n            VALUES (?, ?)`,\n          args: [id, labelId],\n        });\n        await transaction.execute({\n          sql: `INSERT INTO ${TABLES.events}\n            (event_type, entity_id, actor, data, event_timestamp)\n            VALUES ('issue.updated', ?, ?, ?, ?)`,\n          args: [\n            id,\n            data.actor,\n            JSON.stringify({\n              update_target: \"label\",\n              from: null,\n              to: String(label.name),\n            }),\n            timestamp,\n          ],\n        });\n      }\n      for (const handle of assignees) {\n        await transaction.execute({\n          sql: `INSERT INTO ${TABLES.assignees} (issue_id, user_handle)\n            VALUES (?, ?)`,\n          args: [id, handle],\n        });\n        await transaction.execute({\n          sql: `INSERT INTO ${TABLES.events}\n            (event_type, entity_id, actor, data, event_timestamp)\n            VALUES ('issue.updated', ?, ?, ?, ?)`,\n          args: [\n            id,\n            data.actor,\n            JSON.stringify({\n              update_target: \"assignee\",\n              from: null,\n              to: handle,\n            }),\n            timestamp,\n          ],\n        });\n      }\n      return id;\n    });\n  }\n\n  async function updateIssue(\n    id: number,\n    data: Partial<{ title: string; body: string }>,\n    actor: string,\n  ): Promise<void> {\n    const existing = await getBaseIssue(id);\n    if (!existing) throw new HttpError(404, `Issue #${id} not found.`);\n    const changes = ([\"title\", \"body\"] as const)\n      .filter(\n        (field) => data[field] !== undefined && data[field] !== existing[field],\n      )\n      .map((field) => ({\n        field,\n        from: existing[field],\n        to: data[field] as string,\n      }));\n    if (!changes.length) return;\n    const timestamp = now();\n    const statements: Statement[] = [\n      {\n        sql: `UPDATE ${TABLES.issues} SET ${\n          changes\n            .map((change) => `${change.field} = ?`)\n            .join(\", \")\n        }, updated_at = ? WHERE id = ?`,\n        args: [...changes.map((change) => change.to), timestamp, id],\n      },\n      ...changes.map(\n        (change): Statement => ({\n          sql:\n            `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n          args: [\n            id,\n            actor,\n            JSON.stringify({\n              update_target: change.field,\n              from: change.from,\n              to: change.to,\n            }),\n            timestamp,\n          ],\n        }),\n      ),\n    ];\n    await atomicWrite(statements);\n  }\n\n  async function setLifecycle(\n    id: number,\n    actor: string,\n    status: IssueStatus,\n    stateReason: StateReason,\n  ): Promise<void> {\n    const existing = await getBaseIssue(id);\n    if (!existing) throw new HttpError(404, `Issue #${id} not found.`);\n    if (existing.status === status && existing.state_reason === stateReason) {\n      return;\n    }\n    const timestamp = now();\n    const statements: Statement[] = [\n      {\n        sql:\n          `UPDATE ${TABLES.issues} SET status = ?, state_reason = ?, updated_at = ? WHERE id = ?`,\n        args: [status, stateReason, timestamp, id],\n      },\n    ];\n    if (existing.status !== status) {\n      statements.push({\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          id,\n          actor,\n          JSON.stringify({\n            update_target: \"status\",\n            from: existing.status,\n            to: status,\n          }),\n          timestamp,\n        ],\n      });\n    }\n    if (existing.state_reason !== stateReason) {\n      statements.push({\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          id,\n          actor,\n          JSON.stringify({\n            update_target: \"state_reason\",\n            from: existing.state_reason,\n            to: stateReason,\n          }),\n          timestamp,\n        ],\n      });\n    }\n    await atomicWrite(statements);\n  }\n\n  async function closeIssue(\n    id: number,\n    actor: string,\n    reason: ClosedStateReason = \"completed\",\n  ) {\n    if (!CLOSED_STATE_REASONS.includes(reason)) {\n      throw new HttpError(400, \"Invalid close reason.\");\n    }\n    await setLifecycle(id, actor, \"closed\", reason);\n  }\n\n  async function reopenIssue(id: number, actor: string) {\n    await setLifecycle(id, actor, \"open\", \"reopened\");\n  }\n\n  async function deleteIssue(id: number, actor: string): Promise<void> {\n    if (!(await getBaseIssue(id))) {\n      throw new HttpError(404, `Issue #${id} not found.`);\n    }\n    const timestamp = now();\n    const statements: Statement[] = [\n      {\n        sql:\n          `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        args: [id, actor, timestamp, id],\n      },\n      {\n        sql:\n          `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        args: [id, actor, timestamp, id],\n      },\n      {\n        sql:\n          `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        args: [id, actor, timestamp, id],\n      },\n      {\n        sql:\n          `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        args: [id, actor, timestamp, id],\n      },\n      {\n        sql:\n          `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        args: [actor, timestamp, id],\n      },\n      {\n        sql:\n          `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        args: [actor, timestamp, id],\n      },\n      { sql: `DELETE FROM ${TABLES.issues} WHERE id = ?`, args: [id] },\n    ];\n    await atomicWrite(statements);\n  }\n\n  async function listLabels(): Promise<Label[]> {\n    const result = await client.execute(\n      `SELECT * FROM ${TABLES.labels} ORDER BY name`,\n    );\n    return result.rows.map(toLabel);\n  }\n\n  async function listLabelSummaries(\n    opts: { search?: string } = {},\n  ): Promise<LabelSummary[]> {\n    let sql = `SELECT label.*, COUNT(issue.id) AS open_issue_count\n      FROM ${TABLES.labels} label\n      LEFT JOIN ${TABLES.issueLabels} link ON link.label_id = label.id\n      LEFT JOIN ${TABLES.issues} issue\n        ON issue.id = link.issue_id AND issue.status = 'open'`;\n    const args: SqlValue[] = [];\n    if (opts.search) {\n      sql += ` WHERE label.name LIKE ? ESCAPE '\\\\'`;\n      args.push(containsPattern(opts.search));\n    }\n    sql += \" GROUP BY label.id ORDER BY label.name\";\n    const result = await client.execute({ sql, args });\n    return result.rows.map((row) => ({\n      ...toLabel(row),\n      openIssueCount: number(row.open_issue_count),\n    }));\n  }\n\n  async function getLabel(id: number): Promise<Label | null> {\n    const result = await client.execute({\n      sql: `SELECT * FROM ${TABLES.labels} WHERE id = ?`,\n      args: [id],\n    });\n    const row = result.rows[0];\n    return row ? toLabel(row) : null;\n  }\n\n  async function findLabelByName(name: string): Promise<Label | null> {\n    const result = await client.execute({\n      sql: `SELECT * FROM ${TABLES.labels} WHERE name = ?`,\n      args: [name],\n    });\n    const row = result.rows[0];\n    return row ? toLabel(row) : null;\n  }\n\n  async function createLabel(data: {\n    name: string;\n    color: string;\n    actor: string;\n  }): Promise<number> {\n    const color = normalizeColor(data.color);\n    if (await findLabelByName(data.name)) {\n      throw new HttpError(409, `Label name \"${data.name}\" is already in use.`);\n    }\n    return await emitCreatedLabel(data.name, color, data.actor, now());\n  }\n\n  async function updateLabel(\n    id: number,\n    data: Partial<{ name: string; color: string }>,\n    actor: string,\n  ): Promise<void> {\n    const existing = await getLabel(id);\n    if (!existing) throw new HttpError(404, `Label #${id} not found.`);\n    if (data.color !== undefined) data.color = normalizeColor(data.color);\n    if (data.name !== undefined && data.name !== existing.name) {\n      const conflict = await findLabelByName(data.name);\n      if (conflict && conflict.id !== id) {\n        throw new HttpError(\n          409,\n          `Label name \"${data.name}\" is already in use.`,\n        );\n      }\n    }\n    const changes = ([\"name\", \"color\"] as const)\n      .filter(\n        (field) => data[field] !== undefined && data[field] !== existing[field],\n      )\n      .map((field) => ({\n        field,\n        from: existing[field],\n        to: data[field] as string,\n      }));\n    if (!changes.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql: `UPDATE ${TABLES.labels} SET ${\n          changes\n            .map((change) => `${change.field} = ?`)\n            .join(\", \")\n        }, updated_at = ? WHERE id = ?`,\n        args: [...changes.map((change) => change.to), timestamp, id],\n      },\n      ...changes.map(\n        (change): Statement => ({\n          sql:\n            `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('label.updated', ?, ?, ?, ?)`,\n          args: [\n            id,\n            actor,\n            JSON.stringify({\n              update_target: change.field,\n              from: change.from,\n              to: change.to,\n            }),\n            timestamp,\n          ],\n        }),\n      ),\n    ]);\n  }\n\n  async function deleteLabel(id: number, actor: string): Promise<void> {\n    const label = await getLabel(id);\n    if (!label) throw new HttpError(404, `Label #${id} not found.`);\n    const links = await client.execute({\n      sql: `SELECT issue_id FROM ${TABLES.issueLabels} WHERE label_id = ?`,\n      args: [id],\n    });\n    const timestamp = now();\n    const statements: Statement[] = [\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('label.deleted', ?, ?, ?, ?)`,\n        args: [id, actor, JSON.stringify(labelSnapshot(label)), timestamp],\n      },\n    ];\n    for (const row of links.rows) {\n      const issueId = number(row.issue_id);\n      statements.push(\n        {\n          sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n          args: [timestamp, issueId],\n        },\n        {\n          sql:\n            `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n          args: [\n            issueId,\n            actor,\n            JSON.stringify({\n              update_target: \"label\",\n              from: label.name,\n              to: null,\n            }),\n            timestamp,\n          ],\n        },\n      );\n    }\n    statements.push({\n      sql: `DELETE FROM ${TABLES.labels} WHERE id = ?`,\n      args: [id],\n    });\n    await atomicWrite(statements);\n  }\n\n  async function addLabel(\n    issueId: number,\n    labelId: number,\n    actor: string,\n  ): Promise<void> {\n    if (!(await getBaseIssue(issueId))) {\n      throw new HttpError(404, `Issue #${issueId} not found.`);\n    }\n    const label = await getLabel(labelId);\n    if (!label) throw new HttpError(404, `Label #${labelId} not found.`);\n    const existing = await client.execute({\n      sql:\n        `SELECT 1 FROM ${TABLES.issueLabels} WHERE issue_id = ? AND label_id = ?`,\n      args: [issueId, labelId],\n    });\n    if (existing.rows.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.issueLabels} (issue_id, label_id) VALUES (?, ?)`,\n        args: [issueId, labelId],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, issueId],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          issueId,\n          actor,\n          JSON.stringify({\n            update_target: \"label\",\n            from: null,\n            to: label.name,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function removeLabel(\n    issueId: number,\n    labelId: number,\n    actor: string,\n  ): Promise<void> {\n    if (!(await getBaseIssue(issueId))) {\n      throw new HttpError(404, `Issue #${issueId} not found.`);\n    }\n    const label = await getLabel(labelId);\n    if (!label) throw new HttpError(404, `Label #${labelId} not found.`);\n    const existing = await client.execute({\n      sql:\n        `SELECT 1 FROM ${TABLES.issueLabels} WHERE issue_id = ? AND label_id = ?`,\n      args: [issueId, labelId],\n    });\n    if (!existing.rows.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `DELETE FROM ${TABLES.issueLabels} WHERE issue_id = ? AND label_id = ?`,\n        args: [issueId, labelId],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, issueId],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          issueId,\n          actor,\n          JSON.stringify({\n            update_target: \"label\",\n            from: label.name,\n            to: null,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function addAssignee(\n    issueId: number,\n    handle: string,\n    actor: string,\n  ): Promise<void> {\n    if (!(await getBaseIssue(issueId))) {\n      throw new HttpError(404, `Issue #${issueId} not found.`);\n    }\n    const existing = await client.execute({\n      sql:\n        `SELECT 1 FROM ${TABLES.assignees} WHERE issue_id = ? AND user_handle = ?`,\n      args: [issueId, handle],\n    });\n    if (existing.rows.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.assignees} (issue_id, user_handle) VALUES (?, ?)`,\n        args: [issueId, handle],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, issueId],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          issueId,\n          actor,\n          JSON.stringify({\n            update_target: \"assignee\",\n            from: null,\n            to: handle,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function removeAssignee(\n    issueId: number,\n    handle: string,\n    actor: string,\n  ): Promise<void> {\n    if (!(await getBaseIssue(issueId))) {\n      throw new HttpError(404, `Issue #${issueId} not found.`);\n    }\n    const existing = await client.execute({\n      sql:\n        `SELECT 1 FROM ${TABLES.assignees} WHERE issue_id = ? AND user_handle = ?`,\n      args: [issueId, handle],\n    });\n    if (!existing.rows.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `DELETE FROM ${TABLES.assignees} WHERE issue_id = ? AND user_handle = ?`,\n        args: [issueId, handle],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, issueId],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          issueId,\n          actor,\n          JSON.stringify({\n            update_target: \"assignee\",\n            from: handle,\n            to: null,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function addBlock(\n    issueId: number,\n    otherIssueId: number,\n    direction: \"blocks\" | \"blocked_by\",\n    actor: string,\n  ): Promise<void> {\n    const blockerId = direction === \"blocks\" ? issueId : otherIssueId;\n    const blockedId = direction === \"blocks\" ? otherIssueId : issueId;\n    if (blockerId === blockedId) {\n      throw new HttpError(409, \"An issue cannot block itself.\");\n    }\n    if (!(await getBaseIssue(blockerId)) || !(await getBaseIssue(blockedId))) {\n      throw new HttpError(404, \"Issue not found.\");\n    }\n    const cycle = await client.execute({\n      sql: `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      args: [blockedId, blockerId],\n    });\n    if (cycle.rows.length) {\n      throw new HttpError(409, \"Blocking relationship would create a cycle.\");\n    }\n    const existing = await client.execute({\n      sql:\n        `SELECT 1 FROM ${TABLES.blocks} WHERE blocker_id = ? AND blocked_id = ?`,\n      args: [blockerId, blockedId],\n    });\n    if (existing.rows.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.blocks} (blocker_id, blocked_id) VALUES (?, ?)`,\n        args: [blockerId, blockedId],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, issueId],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          issueId,\n          actor,\n          JSON.stringify({\n            update_target: direction,\n            from: null,\n            to: otherIssueId,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function removeBlock(\n    issueId: number,\n    otherIssueId: number,\n    direction: \"blocks\" | \"blocked_by\",\n    actor: string,\n  ): Promise<void> {\n    const blockerId = direction === \"blocks\" ? issueId : otherIssueId;\n    const blockedId = direction === \"blocks\" ? otherIssueId : issueId;\n    if (!(await getBaseIssue(blockerId)) || !(await getBaseIssue(blockedId))) {\n      throw new HttpError(404, \"Issue not found.\");\n    }\n    const existing = await client.execute({\n      sql:\n        `SELECT 1 FROM ${TABLES.blocks} WHERE blocker_id = ? AND blocked_id = ?`,\n      args: [blockerId, blockedId],\n    });\n    if (!existing.rows.length) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `DELETE FROM ${TABLES.blocks} WHERE blocker_id = ? AND blocked_id = ?`,\n        args: [blockerId, blockedId],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, issueId],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('issue.updated', ?, ?, ?, ?)`,\n        args: [\n          issueId,\n          actor,\n          JSON.stringify({\n            update_target: direction,\n            from: otherIssueId,\n            to: null,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function listComments(issueId: number): Promise<Comment[]> {\n    const result = await client.execute({\n      sql:\n        `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      args: [issueId],\n    });\n    return result.rows.map((row) => ({\n      id: number(row.id),\n      issue_id: number(row.issue_id),\n      body: String(row.body),\n      created_at: number(row.created_at),\n      updated_at: number(row.updated_at),\n      author: row.author == null ? null : String(row.author),\n    }));\n  }\n\n  async function getComment(id: number): Promise<Comment | null> {\n    const result = await client.execute({\n      sql:\n        `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      args: [id],\n    });\n    const row = result.rows[0];\n    return row\n      ? {\n        id: number(row.id),\n        issue_id: number(row.issue_id),\n        body: String(row.body),\n        created_at: number(row.created_at),\n        updated_at: number(row.updated_at),\n        author: row.author == null ? null : String(row.author),\n      }\n      : null;\n  }\n\n  async function createComment(data: {\n    issueId: number;\n    body: string;\n    actor: string;\n  }): Promise<number> {\n    if (!(await getBaseIssue(data.issueId))) {\n      throw new HttpError(404, `Issue #${data.issueId} not found.`);\n    }\n    const timestamp = now();\n    const results = await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.comments} (issue_id, body, created_at, updated_at) VALUES (?, ?, ?, ?)`,\n        args: [data.issueId, data.body, timestamp, timestamp],\n      },\n      {\n        sql:\n          `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        args: [data.actor, timestamp],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, data.issueId],\n      },\n    ]);\n    return number(results[0].lastInsertRowid);\n  }\n\n  async function updateComment(\n    id: number,\n    body: string,\n    actor: string,\n  ): Promise<void> {\n    const result = await client.execute({\n      sql: `SELECT * FROM ${TABLES.comments} WHERE id = ?`,\n      args: [id],\n    });\n    const row = result.rows[0];\n    if (!row) throw new HttpError(404, `Comment #${id} not found.`);\n    if (String(row.body) === body) return;\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `UPDATE ${TABLES.comments} SET body = ?, updated_at = ? WHERE id = ?`,\n        args: [body, timestamp, id],\n      },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, number(row.issue_id)],\n      },\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('comment.updated', ?, ?, ?, ?)`,\n        args: [\n          id,\n          actor,\n          JSON.stringify({\n            update_target: \"body\",\n            from: String(row.body),\n            to: body,\n          }),\n          timestamp,\n        ],\n      },\n    ]);\n  }\n\n  async function deleteComment(id: number, actor: string): Promise<void> {\n    const result = await client.execute({\n      sql: `SELECT * FROM ${TABLES.comments} WHERE id = ?`,\n      args: [id],\n    });\n    const row = result.rows[0];\n    if (!row) throw new HttpError(404, `Comment #${id} not found.`);\n    const comment = {\n      id: number(row.id),\n      issue_id: number(row.issue_id),\n      body: String(row.body),\n      created_at: number(row.created_at),\n      updated_at: number(row.updated_at),\n    };\n    const timestamp = now();\n    await atomicWrite([\n      {\n        sql:\n          `INSERT INTO ${TABLES.events} (event_type, entity_id, actor, data, event_timestamp) VALUES ('comment.deleted', ?, ?, ?, ?)`,\n        args: [id, actor, JSON.stringify(commentSnapshot(comment)), timestamp],\n      },\n      { sql: `DELETE FROM ${TABLES.comments} WHERE id = ?`, args: [id] },\n      {\n        sql: `UPDATE ${TABLES.issues} SET updated_at = ? WHERE id = ?`,\n        args: [timestamp, comment.issue_id],\n      },\n    ]);\n  }\n\n  async function listEvents(\n    opts: { entity?: \"issue\" | \"comment\" | \"label\"; entityId?: number } = {},\n  ): Promise<TrackerEvent[]> {\n    let sql = `SELECT * FROM ${TABLES.events}`;\n    const conditions: string[] = [];\n    const args: SqlValue[] = [];\n    if (opts.entity) {\n      conditions.push(\"event_type LIKE ?\");\n      args.push(`${opts.entity}.%`);\n    }\n    if (opts.entityId !== undefined) {\n      conditions.push(\"entity_id = ?\");\n      args.push(opts.entityId);\n    }\n    if (conditions.length) sql += ` WHERE ${conditions.join(\" AND \")}`;\n    sql += \" ORDER BY id\";\n    const result = await client.execute({ sql, args });\n    return result.rows.map((row) => ({\n      id: number(row.id),\n      event_type: row.event_type as EventType,\n      entity_id: number(row.entity_id),\n      actor: String(row.actor),\n      data: parseJson(row.data),\n      event_timestamp: number(row.event_timestamp),\n    }));\n  }\n\n  return {\n    initSchema,\n    listIssues,\n    listIssueRows,\n    listIssueAuthors,\n    getIssue,\n    createIssue,\n    createIssueAggregate,\n    updateIssue,\n    closeIssue,\n    reopenIssue,\n    deleteIssue,\n    listLabels,\n    listLabelSummaries,\n    getLabel,\n    createLabel,\n    updateLabel,\n    deleteLabel,\n    addLabel,\n    removeLabel,\n    addAssignee,\n    removeAssignee,\n    addBlock,\n    removeBlock,\n    listComments,\n    getComment,\n    createComment,\n    updateComment,\n    deleteComment,\n    listEvents,\n  };\n}\n\nexport type IssueStore = ReturnType<typeof createIssueStore>;\nexport const defaultIssueStore = createIssueStore(\n  sqlite as unknown as SqliteClient,\n);\n\nexport const initSchema = defaultIssueStore.initSchema;\nexport const listIssues = defaultIssueStore.listIssues;\nexport const listIssueRows = defaultIssueStore.listIssueRows;\nexport const listIssueAuthors = defaultIssueStore.listIssueAuthors;\nexport const getIssue = defaultIssueStore.getIssue;\nexport const createIssue = defaultIssueStore.createIssue;\nexport const createIssueAggregate = defaultIssueStore.createIssueAggregate;\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 listLabelSummaries = defaultIssueStore.listLabelSummaries;\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",[],[458],"f0b2eb54-7384-4c91-830a-b9910c7997b1","css_test.ts","a612847c-800a-11f1-86f5-1607ee4eb77e",351,["D",1784091864832],"import { assert, assertEquals, assertExists } from \"jsr:@std/assert@1.0.19\";\nimport { issueTracker } from \"./app.tsx\";\nimport { createIssueStore } from \"./db.ts\";\nimport { createTestSqlite } from \"./test_sqlite.ts\";\nimport { compileTwind, emitsRule, harvestClasses } from \"./test_twind.ts\";\nimport { FONT_STYLESHEETS, LABEL_CHIP_ATTR, SCHEMES } from \"./theme.ts\";\n\nfunction cssVarName(key: string): string {\n  return `--${key.replace(/[A-Z]/g, (m) => `-${m.toLowerCase()}`)}`;\n}\n\n/** Renders every page shape the app produces, including a Labeled issue. */\nasync function renderAllPages(): Promise<string[]> {\n  const store = createIssueStore(createTestSqlite());\n  await store.initSchema();\n  const bug = (await store.listLabels()).find((label) => label.name === \"bug\");\n  assertExists(bug);\n  const fetch = issueTracker(\n    { auth: false, title: \"Test Tracker\", apiKey: \"secret\" },\n    store,\n  );\n  const form = async (path: string, values: Array<[string, string]>) => {\n    const body = new URLSearchParams();\n    for (const [key, value] of values) body.append(key, value);\n    return await fetch(\n      new Request(`http://local${path}`, { method: \"POST\", body }),\n    );\n  };\n  const created = await form(\"/new\", [\n    [\"title\", \"First\"],\n    [\"body\", \"body\"],\n    [\"label_id\", String(bug.id)],\n  ]);\n  const id = Number(created.headers.get(\"location\")?.split(\"/\").at(-1));\n\n  const get = async (path: string) =>\n    await (await fetch(new Request(`http://local${path}`))).text();\n\n  return [\n    await get(\"/\"),\n    await get(`/issue/${id}`),\n    await get(\"/labels\"),\n    await get(\"/new\"),\n  ];\n}\n\nDeno.test(\"Seam B: rendered pages compile through Twind with no dropped utilities\", async () => {\n  const html = (await renderAllPages()).join(\"\\n\");\n  const classes = harvestClasses(html);\n  const css = compileTwind(classes);\n  const dropped = classes.filter((className) => !emitsRule(css, className));\n  assertEquals(\n    dropped,\n    [],\n    `utilities silently dropped by Twind (emit no rule): ${dropped.join(\", \")}`,\n  );\n});\n\nDeno.test(\"Seam B: no color token compiles to a non-color CSS property\", async () => {\n  const html = (await renderAllPages()).join(\"\\n\");\n  const classes = harvestClasses(html);\n  const css = compileTwind(classes);\n  const colorProperty = /^(-webkit-)?(color|.*-color|fill|stroke)$/;\n  for (const key of Object.keys(SCHEMES)) {\n    const varName = cssVarName(key);\n    const usages = [\n      ...css.matchAll(\n        new RegExp(`([a-zA-Z-]+):[^;{}]*var\\\$${varName}\\\$`, \"g\"),\n      ),\n    ];\n    for (const [, property] of usages) {\n      assert(\n        colorProperty.test(property),\n        `var(${varName}) compiled onto non-color property \"${property}\" — ` +\n          `the bare-var() misparse trap (e.g. font-size:var(--x))`,\n      );\n    }\n  }\n});\n\nDeno.test(\"Seam B: every button and input has a real, working 32px height mechanism\", async () => {\n  const html = (await renderAllPages()).join(\"\\n\");\n  const classes = harvestClasses(html);\n  assert(\n    !classes.includes(\"min-h-10\"),\n    \"min-h-10 is dead in this Twind build and must not be emitted\",\n  );\n  const heightClasses = classes.filter((c) => c === \"h-8\");\n  assert(heightClasses.length > 0, \"no control uses the h-8 height mechanism\");\n  const css = compileTwind(heightClasses);\n  assert(\n    emitsRule(css, \"h-8\") && css.includes(\".h-8{height:2rem}\"),\n    \"h-8 must compile to a real height:2rem (32px) rule\",\n  );\n});\n\nDeno.test(\"Seam B: rendering a page with Labels emits both custom properties per chip\", async () => {\n  const [issueList] = await renderAllPages();\n  const chipAttr = new RegExp(\n    `${LABEL_CHIP_ATTR}=\"\" [^>]*style=\"([^\"]*)\"|style=\"([^\"]*)\"[^>]*${LABEL_CHIP_ATTR}=\"\"`,\n  );\n  const match = issueList.match(chipAttr);\n  assert(match, \"no Label chip with the label-chip attribute hook found\");\n  const style = match[1] ?? match[2] ?? \"\";\n  assert(style.includes(\"--label-light:#\"), \"chip is missing --label-light\");\n  assert(style.includes(\"--label-dark:#\"), \"chip is missing --label-dark\");\n\n  assert(\n    issueList.includes(`[${LABEL_CHIP_ATTR}]{color:var(--label-light)`),\n    \"global light-scheme label-chip rule missing from the rendered stylesheet\",\n  );\n  assert(\n    issueList.includes(`[${LABEL_CHIP_ATTR}]{color:var(--label-dark)`),\n    \"global dark-scheme label-chip rule missing from the rendered stylesheet\",\n  );\n});\n\nDeno.test(\"Seam B: IBM Plex Sans and iA Writer Mono load with a working fallback stack\", async () => {\n  const [issueList] = await renderAllPages();\n  for (const href of FONT_STYLESHEETS) {\n    assert(\n      issueList.includes(`href=\"${href}\"`),\n      `font stylesheet not linked: ${href}`,\n    );\n  }\n  const classes = harvestClasses(issueList);\n  assert(classes.includes(\"font-sans\"), \"body does not use font-sans\");\n  const css = compileTwind([\"font-sans\"]);\n  assert(\n    css.includes(\n      \".font-sans{font-family:IBM Plex Sans,-apple-system,sans-serif}\",\n    ),\n    \"font-sans must compile to IBM Plex Sans with a system-font fallback\",\n  );\n});\n\nDeno.test(\"Seam B: both scheme blocks are present and every variable resolves\", async () => {\n  const [html] = await renderAllPages();\n  assert(html.includes(\":root{\"), \"missing :root (light) scheme block\");\n  assert(\n    html.includes(\"@media (prefers-color-scheme:dark){:root{\"),\n    \"missing dark scheme media block\",\n  );\n  const root = html.match(/:root\\{([^}]*)\\}/)?.[1] ?? \"\";\n  const dark =\n    html.match(/@media \$prefers-color-scheme:dark\$\\{:root\\{([^}]*)\\}/)\n      ?.[1] ?? \"\";\n  for (const key of Object.keys(SCHEMES)) {\n    const varName = cssVarName(key);\n    assert(root.includes(`${varName}:`), `${varName} missing from :root block`);\n    assert(dark.includes(`${varName}:`), `${varName} missing from dark block`);\n  }\n});\n",[],[466],"91483087-def5-4859-96b8-7bf0ba26c8aa","components.tsx","bc7095f6-7b3c-11f1-9afb-1607ee4eb77e",365,["D",1784091865415],59,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC } from \"npm:hono@4.6.14/jsx\";\nimport type { Comment, Issue, Label, LabelSummary } from \"./db.ts\";\nimport { queryWithIssueToken } from \"./issue_query.ts\";\nimport { Layout } from \"./layout.tsx\";\nimport { T } from \"./theme.ts\";\nimport {\n  Banner,\n  Button,\n  Card,\n  FIELD,\n  LabelTag,\n  Select,\n  StatusBadge,\n} from \"./ui.tsx\";\n\n// Layout `active` tab map — every page component below sets this on its\n// <Layout active=\"...\"> call so the shared top bar highlights the right tab.\n// Each page belongs to exactly one surface, so the value is set locally\n// per component rather than derived from the route:\n//   \"issues\" -> IssueListPage, NewIssuePage, IssueDetailPage, EditIssuePage\n//   \"labels\" -> LabelsPage\n// Adding a new page? Set `active` on its <Layout> call and update this list.\nfunction relativeTime(timestamp: number) {\n  const seconds = Math.max(0, Math.floor((Date.now() - timestamp) / 1000));\n  if (seconds < 60) return \"just now\";\n  const minutes = Math.floor(seconds / 60);\n  if (minutes < 60) return `${minutes}m ago`;\n  const hours = Math.floor(minutes / 60);\n  if (hours < 24) return `${hours}h ago`;\n  const days = Math.floor(hours / 24);\n  if (days < 7) return `${days}d ago`;\n  const weeks = Math.floor(days / 7);\n  if (weeks < 5) return `${weeks}w ago`;\n  const months = Math.floor(days / 30);\n  if (months < 12) return `${months}mo ago`;\n  return `${Math.floor(days / 365)}y ago`;\n}\n\nfunction listHref(base: string, query: string) {\n  return `${base}/?${new URLSearchParams({ q: query })}`;\n}\n\nfunction queryWithStatus(query: string, status: \"open\" | \"closed\") {\n  return queryWithIssueToken(query, \"status\", status, true);\n}\n\nfunction FilterOption({\n  base,\n  query,\n  kind,\n  value,\n  children,\n}: {\n  base: string;\n  query: string;\n  kind: \"author\" | \"label\" | \"is\";\n  value: string;\n  children: unknown;\n}) {\n  return (\n    <form method=\"get\" action={`${base}/`}>\n      <input\n        type=\"hidden\"\n        name=\"q\"\n        value={queryWithIssueToken(query, kind, value)}\n      />\n      <button\n        type=\"submit\"\n        class={`block w-full text-left px-3 py-2 text-sm text-[${T.text}] hover:bg-[${T.surface}] cursor-pointer bg-transparent border-0`}\n      >\n        {children}\n      </button>\n    </form>\n  );\n}\n\nfunction FilterDisclosure({\n  label,\n  children,\n}: {\n  label: string;\n  children: unknown;\n}) {\n  return (\n    <details class=\"relative\">\n      <summary\n        class={`cursor-pointer list-none rounded-md border border-[${T.border}] px-3 py-1.5 text-xs text-[${T.muted}] hover:text-[${T.text}]`}\n      >\n        {label}\n      </summary>\n      <div\n        class={`absolute right-0 z-10 mt-1 min-w-[10rem] overflow-hidden rounded-md border border-[${T.border}] bg-[${T.panel}] shadow-lg`}\n      >\n        {children}\n      </div>\n    </details>\n  );\n}\n\nexport const IssueListPage: FC<{\n  title: string;\n  user: string | null;\n  canCreate: boolean;\n  auth?: boolean;\n  login?: string | null;\n  base?: string;\n  issues: Array<Issue & { commentCount: number }>;\n  authors: string[];\n  labels: Label[];\n  filters: {\n    query: string;\n    status: \"open\" | \"closed\";\n    openCount: number;\n    closedCount: number;\n  };\n}> = ({\n  title,\n  user,\n  canCreate,\n  auth = true,\n  login,\n  base = \"\",\n  issues,\n  authors,\n  labels,\n  filters,\n}) => (\n  <Layout\n    title={title}\n    user={user}\n    auth={auth}\n    login={login}\n    base={base}\n    active=\"issues\"\n  >\n    <div class=\"flex gap-2 mb-4\">\n      <form\n        method=\"get\"\n        action={`${base}/`}\n        class=\"flex gap-2 flex-1 items-start\"\n      >\n        <div class=\"flex-1\">\n          <input\n            type=\"search\"\n            name=\"q\"\n            value={filters.query}\n            placeholder=\"Search title and body, or use status:open…\"\n            aria-describedby=\"issue-search-help\"\n            class={`${FIELD} w-full`}\n          />\n          <p id=\"issue-search-help\" class={`mt-1 text-xs text-[${T.muted}]`}>\n            Multi-word labels encode spaces: label:good%20first%20issue\n          </p>\n        </div>\n        <Button type=\"submit\" variant=\"ghost\">Search</Button>\n      </form>\n      {canCreate ? <Button href={`${base}/new`}>+ New Issue</Button> : null}\n    </div>\n    <Card class=\"p-0 overflow-hidden\">\n      <div\n        class={`flex gap-4 items-center p-3 border-b border-[${T.border}]`}\n      >\n        <a\n          href={listHref(base, queryWithStatus(filters.query, \"open\"))}\n          aria-current={filters.status === \"open\" ? \"page\" : undefined}\n          class={`inline-flex items-center gap-2 no-underline font-medium ${\n            filters.status === \"open\" ? `text-[${T.text}]` : `text-[${T.muted}]`\n          }`}\n        >\n          <span aria-hidden=\"true\">●</span>\n          Open\n          <span\n            class={`rounded-full px-2 py-0.5 text-xs bg-[${T.surface}]`}\n          >\n            {filters.openCount}\n          </span>\n        </a>\n        <a\n          href={listHref(base, queryWithStatus(filters.query, \"closed\"))}\n          aria-current={filters.status === \"closed\" ? \"page\" : undefined}\n          class={`inline-flex items-center gap-2 no-underline font-medium ${\n            filters.status === \"closed\"\n              ? `text-[${T.text}]`\n              : `text-[${T.muted}]`\n          }`}\n        >\n          <span aria-hidden=\"true\">○</span>\n          Closed\n          <span\n            class={`rounded-full px-2 py-0.5 text-xs bg-[${T.surface}]`}\n          >\n            {filters.closedCount}\n          </span>\n        </a>\n        <span class=\"flex-1\" />\n        <div class=\"flex gap-2 items-center\">\n          <FilterDisclosure label=\"Author\">\n            {authors.length\n              ? authors.map((author) => (\n                <FilterOption\n                  key={author}\n                  base={base}\n                  query={filters.query}\n                  kind=\"author\"\n                  value={author}\n                >\n                  @{author}\n                </FilterOption>\n              ))\n              : (\n                <span class={`block px-3 py-2 text-xs text-[${T.muted}]`}>\n                  No authors\n                </span>\n              )}\n          </FilterDisclosure>\n          <FilterDisclosure label=\"Labels\">\n            {labels.length\n              ? labels.map((label) => (\n                <FilterOption\n                  key={label.id}\n                  base={base}\n                  query={filters.query}\n                  kind=\"label\"\n                  value={label.name}\n                >\n                  <LabelTag label={label} />\n                </FilterOption>\n              ))\n              : (\n                <span class={`block px-3 py-2 text-xs text-[${T.muted}]`}>\n                  No labels\n                </span>\n              )}\n          </FilterDisclosure>\n          <FilterDisclosure label=\"Blocked / Unblocked\">\n            <FilterOption\n              base={base}\n              query={filters.query}\n              kind=\"is\"\n              value=\"blocked\"\n            >\n              Blocked\n            </FilterOption>\n            <FilterOption\n              base={base}\n              query={filters.query}\n              kind=\"is\"\n              value=\"unblocked\"\n            >\n              Unblocked\n            </FilterOption>\n          </FilterDisclosure>\n        </div>\n      </div>\n      {issues.length\n        ? (\n          <div>\n            {issues.map((issue) => (\n              <article\n                key={issue.id}\n                class={`flex gap-3 p-4 border-b border-[${T.border}] last:border-b-0`}\n              >\n                <span\n                  aria-label={issue.status === \"open\" ? \"Open\" : \"Closed\"}\n                  title={issue.status === \"open\" ? \"Open\" : \"Closed\"}\n                  class={`text-lg leading-5 ${\n                    issue.status === \"open\"\n                      ? `text-[${T.stateOpen}]`\n                      : `text-[${T.muted}]`\n                  }`}\n                >\n                  {issue.status === \"open\" ? \"●\" : \"○\"}\n                </span>\n                <div class=\"min-w-0 flex-1\">\n                  <div class=\"flex gap-2 items-center flex-wrap\">\n                    <a\n                      class={`font-semibold text-[${T.link}] no-underline hover:underline`}\n                      href={`${base}/issue/${issue.id}`}\n                    >\n                      {issue.title}\n                    </a>\n                    {issue.blocked\n                      ? (\n                        <span\n                          class={`rounded-full border border-[${T.danger}] text-[${T.danger}] px-2 py-0.5 text-xs`}\n                        >\n                          Blocked\n                        </span>\n                      )\n                      : null}\n                  </div>\n                  <div class={`text-xs text-[${T.muted}] mt-1`}>\n                    #{issue.id} · @{issue.creator ?? \"unknown\"} opened{\" \"}\n                    {relativeTime(issue.created_at)} · Updated{\" \"}\n                    {relativeTime(issue.updated_at)}\n                  </div>\n                  {issue.labels.length\n                    ? (\n                      <div class=\"mt-2\">\n                        {issue.labels.map((label) => (\n                          <LabelTag key={label.id} label={label} />\n                        ))}\n                      </div>\n                    )\n                    : null}\n                </div>\n                {issue.commentCount > 0\n                  ? (\n                    <span\n                      class={`text-xs text-[${T.muted}] whitespace-nowrap self-start`}\n                      aria-label={`${issue.commentCount} ${\n                        issue.commentCount === 1 ? \"comment\" : \"comments\"\n                      }`}\n                    >\n                      {issue.commentCount}{\" \"}\n                      {issue.commentCount === 1 ? \"comment\" : \"comments\"}\n                    </span>\n                  )\n                  : null}\n              </article>\n            ))}\n          </div>\n        )\n        : <p class={`p-4 text-[${T.muted}]`}>No issues found.</p>}\n    </Card>\n  </Layout>\n);\n\nfunction IssueEditor({ body }: { body: string }) {\n  return (\n    <>\n      <div\n        class={`border border-[${T.border}] rounded-lg overflow-hidden bg-[${T.panel}]`}\n      >\n        <div\n          role=\"tablist\"\n          aria-label=\"Issue body editor\"\n          class={`flex items-center gap-5 px-3 pt-2 border-b border-[${T.border}]`}\n        >\n          <span\n            role=\"tab\"\n            aria-selected=\"true\"\n            class={`border-b-2 border-[${T.accent}] px-1 pb-2 text-sm font-semibold`}\n          >\n            Write\n          </span>\n          <span\n            role=\"tab\"\n            aria-disabled=\"true\"\n            title=\"Preview activates when markdown rendering ships\"\n            class={`px-1 pb-2 text-sm text-[${T.muted}]`}\n          >\n            Preview <span class=\"text-xs\">(roadmap)</span>\n          </span>\n          <span class=\"flex-1\" />\n          <span class={`text-[${T.muted}] text-xs`} aria-hidden=\"true\">\n            Aa\n          </span>\n        </div>\n        <textarea\n          id=\"body\"\n          name=\"body\"\n          aria-label=\"Description\"\n          placeholder=\"Type your description here (markdown)\"\n          class={`${FIELD} min-h-[280px] w-full rounded-none border-0 py-3 resize-y focus:border-0`}\n        >\n          {body}\n

\n \n

\n Bodies are plain markdown. Preview activates once markdown rendering\n ships; file attachments are not supported.\n

\n \n );\n}\n\nfunction IssueMetadataSidebar({\n labels,\n selectedLabelIds,\n assignees,\n user,\n assignSelf,\n}: {\n labels: Label[];\n selectedLabelIds: number[];\n assignees: string;\n user: string | null;\n assignSelf: boolean;\n}) {\n const selectedLabels = labels.filter((label) =>\n selectedLabelIds.includes(label.id)\n );\n const selectedAssignees = assignees\n .split(\",\")\n .map((handle) => handle.trim().replace(/^@/, \"\"))\n .filter(Boolean);\n\n return (\n

Assignees

\n \n ⚙\n \n

\n {selectedAssignees.length || assignSelf && user\n ? (\n

\n {selectedAssignees.map((handle) => (\n \n @{handle}\n \n ))}\n {assignSelf && user && !selectedAssignees.includes(user)\n ? (\n \n @{user}\n \n )\n : null}\n

\n )\n :

No one assigned.

}\n

\n \n ⚙ Manage assignees\n \n

\n \n Handles (comma-separated)\n \n \n {user\n ? (\n \n \n Assign yourself (@{user})\n \n )\n : null}\n

\n Handles are Val Town usernames and are not validated.\n

\n\n

Labels

\n \n ⚙\n \n

\n {selectedLabels.length\n ? (\n

\n {selectedLabels.map((label) => (\n \n ))}\n

\n )\n :

No labels selected.

}\n

\n \n ⚙ Manage labels\n \n \n \n {labels.map((label) => (\n \n \n \n \n ))}\n \n

\n );\n}\n\nexport const NewIssuePage: FC<{\n title: string;\n user: string | null;\n labels: Label[];\n auth?: boolean;\n login?: string | null;\n base?: string;\n error?: string;\n initialTitle?: string;\n initialBody?: string;\n selectedLabelIds?: number[];\n assignees?: string;\n assignSelf?: boolean;\n createMore?: boolean;\n}> = ({\n title,\n user,\n labels,\n auth = true,\n login,\n base = \"\",\n error,\n initialTitle = \"\",\n initialBody = \"\",\n selectedLabelIds = [],\n assignees = \"\",\n assignSelf = false,\n createMore = false,\n}) => (\n \n

\n \n +\n \n

Create new issue

\n Start a focused discussion with a title, description, and optional\n triage metadata.\n

\n {error ? : null}\n

\n \n Add a title *\n \n \n

\n \n Add a description\n \n

\n \n

\n \n \n \n Create more\n \n \n \n \n \n \n);\n\nfunction CommentCard({\n comment,\n user,\n canModerateComments,\n base = \"\",\n}: {\n comment: Comment;\n user: string | null;\n canModerateComments: boolean;\n base?: string;\n}) {\n const canManage = canModerateComments || user === comment.author;\n return (\n \n

\n @{comment.author ?? \"unknown\"} commented{\" \"}\n {relativeTime(comment.created_at)}\n {comment.updated_at !== comment.created_at ? \" · edited\" : \"\"}\n

{comment.body}

\n {canManage\n ? (\n

\n \n ⋯ Comment actions\n \n

Edit comment

\n \n \n {comment.body}\n \n \n \n \n \n \n

\n )\n : null}\n

\n );\n}\n\nfunction IssueBodyCard({\n issue,\n bodyEdited,\n creatorIsMaintainer,\n}: {\n issue: Issue;\n bodyEdited: boolean;\n creatorIsMaintainer: boolean;\n}) {\n return (\n \n

\n \n {(issue.creator ?? \"?\").charAt(0)}\n \n \n @{issue.creator ?? \"unknown\"} opened {relativeTime(issue.created_at)}\n {bodyEdited ? \" · edited\" : \"\"}\n \n {creatorIsMaintainer\n ? (\n \n Maintainer\n \n )\n : null}\n

\n {issue.body || No description.}\n

\n \n );\n}\n\nfunction GearDisclosure({\n label,\n children,\n}: {\n label: string;\n children: unknown;\n}) {\n return (\n

\n \n ⚙ Manage\n \n

{children}

\n );\n}\n\nexport const IssueDetailPage: FC<{\n title: string;\n user: string | null;\n canManage: boolean;\n canDelete: boolean;\n canModerateComments: boolean;\n canComment?: boolean;\n auth?: boolean;\n login?: string | null;\n base?: string;\n issue: Issue;\n comments: Comment[];\n labels: Label[];\n bodyEdited?: boolean;\n creatorIsMaintainer?: boolean;\n}> = ({\n title,\n user,\n canManage,\n canDelete,\n canModerateComments,\n canComment,\n auth = true,\n login,\n base = \"\",\n issue,\n comments,\n labels,\n bodyEdited = false,\n creatorIsMaintainer = false,\n}) => (\n \n

\n {issue.title} #{issue.id}\n

\n {canManage\n ? (\n \n ✎\n \n )\n : null}\n

\n \n {issue.blocked\n ? (\n \n Blocked\n \n )\n : null}\n

\n \n

\n Comments ({comments.length})\n

\n {comments.map((comment) => (\n \n ))}\n {(canComment ?? (user !== null || !auth))\n ? (\n \n \n Write\n \n Preview (roadmap)\n \n

\n \n \n \n

\n {canManage\n ? issue.status === \"open\"\n ? (\n \n \n \n \n )\n : (\n \n \n \n )\n : null}\n \n

\n \n )\n : (\n

\n Comments are read-only.\n {auth && !user && login !== null\n ? (\n <>\n Log in to comment.\n \n )\n : null}\n

\n )}\n \n \n {canManage\n ? (\n

\n \n

Issue management

Assignees

\n \n \n \n \n \n \n \n

\n {issue.assignees.map((handle) => `@${handle}`).join(\", \") ||\n \"none\"}\n

Labels

\n \n \n \n \n \n \n \n

\n {issue.labels.length\n ? issue.labels.map((label) => (\n \n ))\n : none}\n

Relationships

\n \n \n \n \n \n \n \n \n

\n Blocked by:{\" \"}\n {issue.blockers.map((item) => (\n \n \n #{item.id}\n \n ({item.status})\n \n ))}\n {issue.blockers.length ? \"\" : \"none\"}\n

\n Blocks:{\" \"}\n {issue.blocks.map((item) => (\n \n \n #{item.id}\n \n ({item.status})\n \n ))}\n {issue.blocks.length ? \"\" : \"none\"}\n

\n {canDelete\n ? (\n

\n \n \n \n

Maintainer only.

\n )\n : null}\n \n

\n )\n : null}\n \n \n);\n\nexport const EditIssuePage: FC<{\n title: string;\n user: string | null;\n issue: Issue;\n auth?: boolean;\n login?: string | null;\n base?: string;\n error?: string;\n}> = ({ title, user, issue, auth = true, login, base = \"\", error }) => (\n \n

\n \n ✎\n \n

Edit issue #{issue.id}

\n Update the title or markdown body. Issue metadata stays on the issue\n page.\n

\n {error ? : null}\n \n \n Add a title *\n \n \n

\n \n Add a description\n \n

\n \n

\n \n \n \n \n \n \n);\n\nconst LABEL_PREVIEW_SCRIPT = `\n(() => {\n const root = document.querySelector(\"[data-label-create]\");\n if (!root) return;\n const name = root.querySelector(\"[data-label-name]\");\n const color = root.querySelector(\"[data-label-color]\");\n const preview = root.querySelector(\"[data-label-preview]\");\n const hex = root.querySelector(\"[data-label-hex]\");\n if (!name || !color || !preview || !hex) return;\n const update = () => {\n const value = color.value || \"#d73a4a\";\n preview.textContent = name.value.trim() || \"New label\";\n preview.style.borderColor = value;\n preview.style.color = value;\n hex.textContent = value;\n };\n name.addEventListener(\"input\", update);\n color.addEventListener(\"input\", update);\n update();\n})();\n`;\n\nfunction PreviewLabel({ name, color }: { name: string; color: string }) {\n return (\n \n {name || \"New label\"}\n \n );\n}\n\nexport const LabelsPage: FC<{\n title: string;\n user: string | null;\n labels: LabelSummary[];\n search?: string;\n canManage: boolean;\n auth?: boolean;\n login?: string | null;\n base?: string;\n}> = ({\n title,\n user,\n labels,\n search = \"\",\n canManage,\n auth = true,\n login,\n base = \"\",\n}) => {\n const defaultColor = \"#d73a4a\";\n return (\n \n

Labels

\n Curated tags used to organize and triage issues.\n

\n {canManage\n ? (\n

\n \n + New label\n \n \n

New label

\n Preview updates as you edit the name and color.\n

\n \n

\n \n \n Name\n \n \n \n Color\n \n \n \n {defaultColor}\n \n \n \n

\n \n

\n \n )\n : null}\n \n

\n \n \n \n {search\n ? \n : null}\n \n \n \n All labels\n \n {labels.length} {labels.length === 1 ? \"label\" : \"labels\"}\n \n \n {labels.length\n ? (\n

\n {labels.map((label) => (\n \n

\n \n \n #{label.color}\n \n

\n {label.openIssueCount} open{\" \"}\n {label.openIssueCount === 1 ? \"issue\" : \"issues\"}\n

\n {canManage\n ? (\n

\n \n ⋯\n \n \n \n \n \n Name\n \n \n \n Color\n \n \n \n #{label.color}\n \n \n \n \n \n \n

\n Deleting removes this label from{\" \"}\n {label.openIssueCount} open{\" \"}\n {label.openIssueCount === 1 ? \"issue\" : \"issues\"}.\n

\n \n \n Delete label\n \n \n

\n \n \n )\n : null}\n \n ))}\n \n )\n : (\n

\n {search ? `No labels match “${search}”.` : \"No labels yet.\"}\n

\n )}\n \n {canManage\n ? \n \n\n",[],[579,605],"0624324c-15a1-4656-b4f5-0e2e312f15c2","flow.svg","b35d6c26-7fb7-11f1-851e-1607ee4eb77e",241,["D",1784056238995],"\n",[],[579,613],"bc026218-6b7e-4cdc-a0ed-1e2a98ae1732",236,["D",1784056238376],[328,329,330,331,332,333],[579],"a7d6b8dd-1925-4e52-8b1a-7519e5abc73e","issue-tracker-valtown.md","4e874dca-7be4-11f1-973a-1607ee4eb77e","4e6ce2e6-7be4-11f1-9a45-1607ee4eb77e",199,["D",1783711960586],"# 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## Response shapes\n\nEvery response is JSON. Successful responses are either a single object, an\narray, or a small acknowledgement object (`{\"deleted\": id}` /\n`{\"updated\": id}`); error responses always have the shape:\n\n```json\n{ \"error\": \"human-readable message\" }\n```\n\n### Label\n\n```ts\n{\n id: number;\n name: string;\n color: string; // six lowercase hex characters, no leading \"#\"\n created_at: number; // ms since epoch\n updated_at: number;\n}\n```\n\n### IssueReference\n\nThe compact shape used inside `blockers` and `blocks`.\n\n```ts\n{\n id: number;\n title: string;\n status: \"open\" | \"closed\";\n state_reason: \"completed\" | \"not_planned\" | \"duplicate\" | \"reopened\" | null;\n}\n```\n\n### Issue\n\n```ts\n{\n id: number;\n title: string;\n body: string; // markdown, verbatim (not trimmed)\n status: \"open\" | \"closed\";\n state_reason: \"completed\" | \"not_planned\" | \"duplicate\" | \"reopened\" | null;\n created_at: number;\n updated_at: number; // last activity: own edits, comments, or association changes\n creator: string | null; // Val Town handle, derived from the issue's creation event\n labels: Label[];\n assignees: string[]; // Val Town handles, no \"@\" prefix\n blockers: IssueReference[];\n blocks: IssueReference[];\n blocked: boolean; // true iff at least one blocker is still \"open\"\n}\n```\n\n`GET /api/issues/:id` returns an `Issue` plus a `comments` field\n(`comments: Comment[]`); no other endpoint includes `comments`.\n\n### Comment\n\n```ts\n{\n id: number;\n issue_id: number;\n body: string; // markdown, verbatim\n created_at: number;\n updated_at: number;\n author: string | null; // Val Town handle, derived from the comment's creation event\n}\n```\n\n### Event\n\n```ts\n{\n id: number;\n event_type:\n | \"issue.created\" | \"issue.updated\" | \"issue.deleted\"\n | \"comment.created\" | \"comment.updated\" | \"comment.deleted\"\n | \"label.created\" | \"label.updated\" | \"label.deleted\";\n entity_id: number; // the issue/comment/label id the event is about\n actor: string;\n data: unknown; // grammar below\n event_timestamp: number;\n}\n```\n\n`GET /api/issues/:id/events` returns `Event[]` in append order.\n\n## Event data grammar\n\nEvents are the source of truth for provenance and history; live tables hold only\ncurrent state.\n\n- **Boundary events (`*.created`, `*.deleted`) snapshot full state.** The `data`\n field is the entity's complete state at that moment — a hard-deleted row\n leaves a full tombstone:\n - `issue.created` / `issue.deleted` data:\n `{id, title, body, status, state_reason, created_at, updated_at}`\n - `comment.created` / `comment.deleted` data:\n `{id, issue_id, body, created_at, updated_at}` (no `author` — that is always\n derived from the surrounding event, never stored in the payload)\n - `label.created` / `label.deleted` data:\n `{id, name, color, created_at, updated_at}`\n- **`*.updated` events carry a single field delta:**\n `{update_target, from, to}`.\n - For `issue.updated`, `update_target` is one of `title`, `body`, `status`,\n `state_reason`, `label`, `assignee`, `blocks`, `blocked_by`. Associations\n (`label`, `assignee`, `blocks`, `blocked_by`) use **`null ↔ value`**\n (`from: null` = added, `to: null` = removed). A block edge writes exactly\n one event, on the acting issue (the one named in the endpoint path).\n - For `comment.updated`, `update_target` is `\"body\"`.\n - For `label.updated`, `update_target` is `\"name\"` or `\"color\"`.\n - One event per changed field: closing an issue with a new reason emits two\n `issue.updated` events (`status` and `state_reason`), sharing one actor and\n timestamp.\n\n## Status codes\n\n| Status | Meaning |\n| ------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |\n| `200` | Read succeeded, or a mutation applied and the endpoint returns the resulting state. |\n| `201` | An issue, comment, or label was created. |\n| `400` | The request is malformed: invalid `:id`, invalid `status` filter, invalid close `reason`, invalid label `color`, a missing required scalar field (`title`; `name`/`color`; comment `body`), or a collection field (`label_ids`, `add`, `remove`, `assignees`) that isn't shaped as required — see below. |\n| `401` | A write was attempted with a missing or incorrect bearer token. |\n| `403` | A write was attempted but `ISSUE_TRACKER_API_KEY` isn't configured, so writes are disabled entirely. |\n| `404` | The issue, comment, or label named by `:id` — or referenced by an ID inside `label_ids`/`add`/`remove` — does not exist. |\n| `409` | The write conflicts with an existing invariant: a blocking edge would create a cycle (including a self-edge), or a label `name` collides with an existing label. |\n\n## Strict collection validation\n\n`label_ids`, and the `add`/`remove` fields on the labels and blocks/blocked-by\nendpoints, are validated as a whole, not filtered element by element:\n\n- **Absent** — treated as an empty operation (no IDs added or removed).\n- **Present** — must be an array where every element is a positive integer\n (`Number.isInteger(x) && x > 0`). Any other shape (not an array, a\n non-integer, zero, a negative number, a string, etc.) rejects the entire\n request with `400`; nothing is applied.\n- Each ID that passes shape validation must still reference an existing label or\n issue, or the request fails with `404`.\n\n`assignees`, and the `add`/`remove` fields on the assignees endpoint, follow the\nsame absent-is-empty / present-is-all-or-nothing rule, but for handles:\n\n- **Present** — must be an array of non-empty strings after trimming and\n stripping a leading `@`. Any other shape rejects the request with `400`.\n- Handles are not entities (no lookup table), so there is no `404` for an\n unrecognized assignee — any well-shaped handle is accepted.\n\n## Endpoints\n\n| Method and path | Body / query | Success |\n| --------------------------------- | -------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ |\n| `GET /api/issues` | `?status=open\\|closed&label=&assignee=&search=` | `200` `Issue[]`. `400` if `status` is present and not `open`/`closed`. |\n| `POST /api/issues` | `{title, body?, label_ids?: number[], assignees?: string[], actor?}` | `201` `Issue`. `400` missing `title` or malformed `label_ids`/`assignees`. `404` if a `label_ids` entry doesn't exist. |\n| `GET /api/issues/:id` | — | `200` `Issue & {comments: Comment[]}`. `400` invalid id. `404` missing issue. |\n| `PATCH /api/issues/:id` | `{title?, body?, actor?}` | `200` updated `Issue`. `400` invalid id. `404` missing issue. |\n| `DELETE /api/issues/:id` | `{actor?}` | `200` `{deleted: id}`. `400` invalid id. `404` missing issue. |\n| `POST /api/issues/:id/close` | `{reason?: \"completed\" \\| \"not_planned\" \\| \"duplicate\", comment?, actor?}` | `200` updated `Issue`; reason defaults to `completed`. `400` invalid id/reason. `404` missing issue. |\n| `POST /api/issues/:id/reopen` | `{actor?}` | `200` updated `Issue` with `state_reason: \"reopened\"`. `400` invalid id. `404` missing issue. |\n| `POST /api/issues/:id/labels` | `{add?: number[], remove?: number[], actor?}` | `200` updated `Issue`. `400` invalid id or malformed `add`/`remove`. `404` missing issue or a missing label id. |\n| `POST /api/issues/:id/assignees` | `{add?: string[], remove?: string[], actor?}` | `200` updated `Issue`. `400` invalid id or malformed `add`/`remove`. `404` missing issue. |\n| `POST /api/issues/:id/blocks` | `{add?: number[], remove?: number[], actor?}` | `200` updated `Issue`. `400` invalid id or malformed `add`/`remove`. `404` missing issue or referenced issue id. `409` cycle or self-edge. |\n| `POST /api/issues/:id/blocked-by` | `{add?: number[], remove?: number[], actor?}` | Same as `/blocks`, opposite edge direction. |\n| `POST /api/issues/:id/comments` | `{body, actor?}` | `201` `Comment`. `400` invalid id or missing `body`. `404` missing issue. |\n| `PATCH /api/comments/:id` | `{body, actor?}` | `200` `{updated: id}`. `400` invalid id or missing `body`. `404` missing comment. |\n| `DELETE /api/comments/:id` | `{actor?}` | `200` `{deleted: id}`. `400` invalid id. `404` missing comment. |\n| `GET /api/issues/:id/events` | — | `200` `Event[]` in append order. `400` invalid id. `404` missing issue. |\n| `GET /api/labels` | — | `200` `Label[]`. |\n| `POST /api/labels` | `{name, color, actor?}` | `201` `Label` (`color` is hex, with or without `#`). `400` missing `name`/`color` or invalid `color`. `409` `name` already in use. |\n| `PATCH /api/labels/:id` | `{name?, color?, actor?}` | `200` updated `Label`. `400` invalid id or `color`. `404` missing label. `409` renaming to an in-use `name`. |\n| `DELETE /api/labels/:id` | `{actor?}` | `200` `{deleted: id}`. `400` invalid id. `404` missing label. |\n\nAll write routes additionally return `401` for a missing/incorrect bearer token,\nand `403` if `ISSUE_TRACKER_API_KEY` is unset — checked before any body or id\nvalidation.\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",[],[257,626],"44bf1ff5-2ddc-48a7-ba48-5648cd000374","backlog.md","eea1bf8a-7bf2-11f1-975e-1607ee4eb77e",368,["D",1784092022503],"# 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- **`DESIGN.md` component conformance.** The follow-on to\n `docs/issues/valtown-native-ui/spec.md`, which specced the foundation\n (palette, fonts, dual-scheme — landed) and defers the component-level Named\n Rules to here: The Machine Facts Rule (mono for issue numbers, handles,\n timestamps), The Hairline Rule and The No-Card Rule (one panel of hairline\n rows), The One Bold Rule and issue-row anatomy, The Badge Containment Rule,\n the status pill as a tinted pair, and hover along the `sky` ramp. Each needs\n visual judgment rather than measurement, which is why it wasn't in the\n foundation spec. Unblocked now that the foundation spec has landed — the\n tokens are in place.\n- **Visible focus ring.** Tracked as\n `docs/issues/valtown-native-ui/issues/07-focus-ring.md` — a real PRD\n requirement (user stories 23–24) that fell out of the foundation spec's ticket\n breakdown. Unlike the conformance items above this is measurable, not a\n judgment call, so it's its own `ready-for-agent` ticket rather than parked\n here.\n",[],[257,635],"3a3e928d-1e27-45cf-832b-40731eacf89d","911c9a22-8004-11f1-821c-1607ee4eb77e","9102e5be-8004-11f1-8a46-1607ee4eb77e",331,["D",1784089252790],"# PRD: Val Town-native UI foundation\n\nStatus: ready-for-agent\n\n`DESIGN.md` is the normative target for this work; its YAML frontmatter carries\nthe tokens. `PRODUCT.md` carries the strategy. This spec covers the\n**foundation** of that migration — the layer whose correctness is decidable by\nmeasurement. Purely aesthetic conformance to the component-level Named Rules is\nexplicitly deferred (see Out of Scope).\n\nThis supersedes the \"Migrate the UI to `DESIGN.md`\" entry in `docs/backlog.md`.\nThat entry estimated the work as \"mostly `theme.ts` and `layout.tsx`\". That\nestimate is wrong, and the reason is the core of this spec: flipping the canvas\nbreaks colors that no token controls.\n\n## Problem Statement\n\nThe tracker wears a generic dark-SaaS costume — blue-charcoal surfaces\n(`#0f1115`), a bare system font stack, and a saturated blue accent. `PRODUCT.md`\nnames this exact combination as an anti-reference and as \"the specific thing\nthat makes this UI 'not look good'\". It is also a dark-only surface, so a\ntracker mounted in a light Val Town host renders as a dark island in a light\npage — which contradicts the \"it embeds politely\" principle directly. A guest\nthat ignores its host's color scheme is a rude guest.\n\nUnderneath the cosmetic problem sit measurable defects the maintainer cannot see\nbut does feel:\n\n- Four of the five seeded Labels are **illegible on a light canvas**. The Label\n chip paints the stored color as text on a transparent fill, which works\n against black and fails against white. `enhancement` (`a2eeef`) measures\n 1.31:1 on white; `duplicate` (`cfd3d7`) 1.51:1; `question` (`d876e3`) 2.76:1.\n Separately, `documentation` (`0075ca`) already fails **today** at 4.40:1 on\n the current dark canvas.\n- The open/closed **state icon** — the single most-scanned signal in the list —\n is hardcoded to a color that measures 1.74:1 on white. It disappears.\n- The Banner hardcodes dark-only tints, so on a light canvas it renders as a\n near-black island.\n- Every button and input has **no height mechanism at all**. The code says\n `min-h-10`, intending 40px, but the project's Twind build predates Tailwind's\n numeric `min-h-*` scale and emits no rule for it. Controls are sized by\n line-height alone (~20–24px), far under the 44px touch-target floor. The 40px\n everyone believes is there has never existed.\n\nThe last four are not migration risks. They are live defects, and three of them\nare invisible until the canvas flips.\n\n## Solution\n\nMigrate the tracker's visual foundation to the Val Town-native system already\ndocumented in `DESIGN.md`: an achromatic canvas (true white / true black),\nstructure carried by slate hairlines, the stock `sky` ramp as the only accent,\nIBM Plex Sans for interface text with iA Writer Mono for machine facts, and\n**dual-scheme rendering driven by `prefers-color-scheme`** so the tracker\nfollows whatever its host val is showing.\n\nThe migration is made cheap by one discovery: because every palette token feeds\na color slot and none appear in a `style` attribute, the palette module's\n**values** can change from hex literals to typed CSS variable references while\nevery one of its ~107 call sites stays byte-identical. The scheme switch then\nlives in one generated stylesheet block rather than in a `dark:` variant at\nevery call site.\n\nColors that no token controls — the Banner tints, the state icon, the status\npill, and user-authored Label colors — are brought under the token system or\nmade scheme-aware at render time. Label color is handled without touching stored\ndata: the stored hex remains the source of truth, and legibility is achieved by\nadapting lightness per scheme at render.\n\nEverything stays server-rendered and works with zero client-side JavaScript.\n\n## User Stories\n\n1. As a maintainer triaging in a light Val Town host, I want the tracker to\n render light, so that it does not sit in my page as a dark island.\n2. As a maintainer triaging in a dark Val Town host, I want the tracker to\n render dark, so that it continues to match its surroundings as it does today.\n3. As a maintainer whose host follows the OS scheme, I want the tracker to\n follow it too, so that I never configure the tracker's appearance separately.\n4. As a Val Town developer mounting the tracker, I want it to look like it\n belongs to the platform, so that it reads as native chrome rather than a\n third-party widget competing with my val.\n5. As a Val Town developer, I want the tracker to inherit the platform's own\n typographic identity, so that it does not announce itself as foreign.\n6. As a maintainer scanning the list, I want the interface set in IBM Plex Sans\n rather than a system stack, so that the UI reads as precise rather than\n generic.\n7. As a maintainer, I want the fonts to load without a flash of unstyled or\n invisible text, so that scanning is not interrupted on every navigation.\n8. As a maintainer on a slow or offline connection, I want the interface to stay\n fully legible if the webfonts never arrive, so that the tracker degrades to a\n sane fallback rather than breaking.\n9. As a maintainer scanning the list, I want the open/closed state icon to be\n clearly visible in both schemes, so that I can tell an Issue's Status at a\n glance — the thing the list exists for.\n10. As a maintainer scanning the list, I want every Label chip legible in both\n schemes, so that I can spot triage signal without opening an Issue.\n11. As a user who authored a Label color, I want my color to remain recognizably\n my color in both schemes, so that the chip still reads as the one I chose.\n12. As a user who authored a Label color, I want my stored color left untouched,\n so that switching schemes never silently rewrites my data.\n13. As a maintainer, I want the `documentation` Label to be legible on the dark\n canvas, so that a defect that exists today is fixed rather than carried\n forward.\n14. As a maintainer, I want a Label whose color is near-white to stay visible on\n a white canvas, so that no Label can be rendered invisible by its own color.\n15. As a maintainer, I want a Label whose color is near-black to stay visible on\n a black canvas, so that the same guarantee holds symmetrically.\n16. As a maintainer receiving a success or error Banner, I want it legible and\n correctly tinted in both schemes, so that feedback never renders as a dark\n block on a light page.\n17. As a maintainer, I want the Status pill legible in both schemes, so that\n lifecycle state never rides on an off-brand saturated fill.\n18. As a maintainer, I want state to be conveyed by icon or text as well as\n color, so that Status never rides on color alone.\n19. As a maintainer clicking a primary action, I want its label readable against\n its fill, so that the button is not the least legible element on the page.\n20. As a maintainer hovering a destructive action, I want its label readable\n against the hover fill, so that the most dangerous control is not the least\n legible.\n21. As a maintainer on a touch device, I want buttons and inputs large enough to\n tap reliably, so that I am not fighting 20px targets.\n22. As a maintainer, I want controls to have a real, working height mechanism,\n so that the intended control height is what actually renders.\n23. As a keyboard user, I want a visible focus ring on every interactive element\n in both schemes, so that the zero-JS form-driven flow stays navigable.\n24. As a keyboard user, I want the focus ring to be visible against both the\n white and black canvas, so that focus is never lost against its background.\n25. As a maintainer reading body and meta text, I want it comfortably readable\n in both schemes, so that scanning density does not cost legibility.\n26. As a developer changing a palette value, I want to change it in exactly one\n place, so that the palette stays a single source of truth.\n27. As a developer changing a fill color, I want the obligation to re-check its\n ink contrast to be visible at the point of change, so that I cannot\n introduce an unreadable pairing without noticing.\n28. As a developer, I want a test to fail if a color utility silently compiles\n to the wrong CSS property, so that the class of bug that made `min-h-10`\n dead cannot recur silently.\n29. As a developer, I want a test to fail if any palette pair drops below its\n contrast floor, so that contrast is enforced rather than audited.\n30. As a developer, I want a test to fail if a scheme leaves any variable\n undefined, so that one scheme cannot silently render with missing colors.\n31. As a developer, I want the migration to leave every call site untouched, so\n that the diff is reviewable and the risk is concentrated in one module.\n32. As an agent working the tracker through the JSON API, I want no API or\n schema change, so that this migration is invisible to me.\n33. As a maintainer, I want the existing routes, role model, storage, and API\n untouched, so that a visual migration cannot break behavior.\n34. As a maintainer, I want the tracker to remain fully functional with zero\n client-side JavaScript, so that the PRD-level zero-JS contract survives.\n\n## Implementation Decisions\n\n### The palette module becomes typed CSS variable references\n\nThe palette module keeps its current key names and gains a second export. Its\n`T` values change from hex literals to **typed** CSS variable references; a new\nexport carries the per-scheme hex tables that the layout shell renders into a\nstylesheet block and that the contrast test asserts over.\n\nBecause every call site interpolates `T.x` inside a Twind arbitrary-value\nbracket (`text-[${T.text}]`), and no token appears in a `style` attribute, all\ncall sites remain byte-identical. Verified against the real class strings: the\nsix prefixes tokens feed are `bg`, `border`, `focus:border`, `hover:bg`,\n`hover:text`, and `text` — all color slots.\n\n### The `color:` type hint is mandatory and non-obvious\n\nThis came out of a prototype and encodes the decision more precisely than prose\ncan. Twind infers the CSS property from the _shape_ of an arbitrary value. A\nbare `var()` is untyped, so it guesses wrong — **silently**, with no error:\n\n```\ntext-[var(--ink)] -> font-size: var(--ink) WRONG\nbg-[var(--canvas)] -> background-image: var(--canvas) WRONG\nborder-[var(--rule)] -> border-width: var(--rule) WRONG\n\ntext-[color:var(--ink)] -> color: var(--ink) correct\nbg-[color:var(--canvas)] -> background-color: var(--canvas) correct\nborder-[color:var(--rule)] -> border-color: var(--rule) correct\n```\n\nSo token values must embed the hint (`text: \"color:var(--ink)\"`), not just the\n`var()`. Confirmed to hold through `hover:` and `focus:` variants and the ring\ncolor. Anyone attempting this without the hint will conclude CSS variables are\nincompatible with Twind and fall back to doubling every call site with `dark:`\nvariants — which is the expensive, wrong path.\n\n### Dual-scheme lives in one generated stylesheet block\n\nThe layout shell renders a `

History · richer-data-model