{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_547":548,"_549":550},"routes/_app.x.$handle.$name",{"_99":98,"_32":44,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",227,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","dae70d12-7b3c-11f1-b278-1607ee4eb77e","name","fileType","content","# val-issue-tracker\n\nA lightweight GitHub-flavoured issue tracker for Val Town's scoped SQLite\n(`std/sqlite/main.ts`) — issues, labels, assignees, blocking edges, comments,\nand a bearer-authenticated JSON API. A drop-in Hono app: imports execute\nagainst the host val's database, and all tables use the `issue_tracker_*`\nprefix.\n\nIt is an [`integrations`](https://esm.town/v/nbbaier/integrations/mod.ts)\ncontract integration, so `issueTracker()` returns a **callable Integration**:\nthe same value works both as a standalone HTTP val and mounted under a router\nalongside other integrations.\n\n## Standalone: this val's own tracker\n\n`main.ts` mounts the tracker for **this** val's scoped database — the tracker\n*is* the val's HTTP export and runs its own OAuth. Visit the val's endpoint and\nlog in.\n\nScoped SQLite is bound to whichever val's runtime is **executing** the code, not\nto where the source lives. So importing the tracker into another val makes it\nread and write **that** val's database automatically — no tokens, no registry:\n\n```ts\nimport { issueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n\nexport default issueTracker({\n\tmaintainers: [\"afriend\"],\n\tapiKey: Deno.env.get(\"ISSUE_TRACKER_API_KEY\"),\n});\n```\n\nThe running val's owner is always a maintainer. Public reads, Val Town OAuth,\nand the visible `/source` redirect remain built in.\n\n## Routed: mounted alongside other integrations\n\nRegister it with a `createRouter` and it mounts under `/issues/`, sharing one\nOAuth gate with every other integration:\n\n```ts\nimport { createRouter } from \"https://esm.town/v/nbbaier/integrations/mod.ts\";\nimport { issueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n\nexport default createRouter({\n\tintegrations: [issueTracker({})],\n});\n```\n\nThe router owns **authentication**; the tracker's role model remains its own\n**authorization** layer, resolved from the router-provided user. A null user —\nthe ungated router's anonymous visitor — becomes a read-only viewer rather than\nbeing redirected to a login that doesn't exist. The bearer-token JSON API keeps\nits own gate, which stacks behind the router's when the router has one.\n\n### Options\n\n| Option | Meaning |\n| ------------- | --------------------------------------------------------------------- |\n| `maintainers` | Additional Val Town handles with maintainer access |\n| `owner` | Deprecated alias for `maintainers` |\n| `defaultRole` | `contributor` (default) or `viewer` for other logged-in users |\n| `auth` | Val Town OAuth when `true` (default); fully open tracker when `false` |\n| `title` | Header and browser title |\n| `apiKey` | Bearer token for JSON writes; defaults to `ISSUE_TRACKER_API_KEY` |\n\nWith auth enabled, viewers can read; contributors can create/comment and manage\nissues they created; maintainers can manage all issues, labels, and deletions.\n\n### Requirement when `auth` is on\n\nThe OAuth gate — this val's own when standalone, the router's when routed —\nneeds an `OAUTH_STATE_ENCRYPTION_KEY` env var (any random 32-byte hex string) to\nencrypt session cookies. Generate one with `openssl rand -hex 32`. The\nintegration declares it as `requiredEnv`, so a router's directory page badges it\nwhen unset.\n\n## Data model\n\n- Issues have `title`, markdown-text `body`, `open`/`closed` status, and an\n auto-managed `state_reason`.\n- Labels are curated name/colour entities and are applied through a join table.\n- Assignees are a set of Val Town handles.\n- Blocking edges form a strict DAG; `blocked` is derived from open blockers.\n- Comments are editable entities.\n- An append-only events table is the sole provenance/history source. Live\n entities retain current state and timestamps only; relationship rows are bare\n tuples.\n- Fresh installs seed `bug`, `enhancement`, `documentation`, `question`, and\n `duplicate` exactly once.\n\nSchema initialization is idempotent and runs on requests. It also migrates the\nold tracker schema: `description → body`, priority removal,\n`in_progress → open`, JSON labels and single assignee lifted into joins, and\nsynthetic creation events.\n\n## JSON API\n\nReads under `/api` are public. Writes require `Authorization: Bearer `.\nThe main operations are:\n\n| Method and path | Purpose |\n| ---------------------------------- | ----------------------------------------------------- |\n| `GET/POST /api/issues` | List/filter or create issues |\n| `GET/PATCH/DELETE /api/issues/:id` | Read, edit, or hard-delete an issue |\n| `POST /api/issues/:id/close` | Close with `completed`, `not_planned`, or `duplicate` |\n| `POST /api/issues/:id/reopen` | Reopen |\n| `POST /api/issues/:id/labels` | Apply/remove label IDs |\n| `POST /api/issues/:id/assignees` | Assign/unassign handles |\n| `POST /api/issues/:id/blocks` | Add/remove issues this issue blocks |\n| `POST /api/issues/:id/blocked-by` | Add/remove blockers |\n| `POST /api/issues/:id/comments` | Comment |\n| `PATCH/DELETE /api/comments/:id` | Edit/delete a comment |\n| `GET/POST /api/labels` | List/create labels |\n| `PATCH/DELETE /api/labels/:id` | Edit/delete a label |\n\nReads are public; writes are `401` without a valid bearer token and `403` if no\ntoken is configured at all. Requests are validated strictly: malformed IDs,\nfilters, or collection fields (`label_ids`, `add`/`remove`, `assignees`) return\n`400`; a missing issue, comment, or label returns `404`; a blocking cycle or\nduplicate label name returns `409`. Errors are always `{\"error\": \"...\"}`. See\n[docs/issue-tracker-valtown.md](./docs/issue-tracker-valtown.md) for the exact\nrequest and response shapes, the event-data grammar, and the full status-code\ntable.\n\n## Development\n\nBiome (tab-indented, per `biome.json`) is the canonical formatter — not\n`deno fmt`. Local Val Town and Claude Code state (`.vt/`, `.claude/`) is\nexcluded from formatting and lint checks.\n\n```bash\ndeno task fmt # biome check . --write (format + apply safe fixes)\ndeno task lint # deno lint\ndeno task typecheck # deno check across source and test files\ndeno task test # deno test\ndeno task check # runs all four in sequence\n```\n\nThe focused test suite uses Deno's SQLite-compatible in-memory driver; it never\nwrites a database file.\n\n## Files\n\n- `db.ts` — schema, migration, domain operations, and default Val Town store.\n- `api.ts` — bearer-authenticated Hono JSON API.\n- `app.tsx` — OAuth/permissions and HTML form routes.\n- `components.tsx`, `ui.tsx`, `layout.tsx` — server-rendered Hono TSX.\n- `mod.ts` — reusable public entry point.\n- `main.ts` — this val's own consumer.\n","# val-issue-tracker\n\nA lightweight GitHub-flavoured issue tracker for Val Town's scoped SQLite\n(`std/sqlite/main.ts`) — issues, labels, assignees, blocking edges, comments,\nand a bearer-authenticated JSON API. A drop-in Hono app: imports execute against\nthe host val's database, and all tables use the `issue_tracker_*` prefix.\n\nIt is an [`integrations`](https://esm.town/v/nbbaier/integrations/mod.ts)\ncontract integration, so `issueTracker()` returns a **callable Integration**:\nthe same value works both as a standalone HTTP val and mounted under a router\nalongside other integrations.\n\n## Standalone: this val's own tracker\n\n`main.ts` mounts the tracker for **this** val's scoped database — the tracker\n_is_ the val's HTTP export and runs its own OAuth. Visit the val's endpoint and\nlog in.\n\nScoped SQLite is bound to whichever val's runtime is **executing** the code, not\nto where the source lives. So importing the tracker into another val makes it\nread and write **that** val's database automatically — no tokens, no registry:\n\n```ts\nimport { issueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n\nexport default issueTracker({\n maintainers: [\"afriend\"],\n apiKey: Deno.env.get(\"ISSUE_TRACKER_API_KEY\"),\n});\n```\n\nThe running val's owner is always a maintainer. Public reads, Val Town OAuth,\nand the visible `/source` redirect remain built in.\n\n## Routed: mounted alongside other integrations\n\nRegister it with a `createRouter` and it mounts under `/issues/`, sharing one\nOAuth gate with every other integration:\n\n```ts\nimport { createRouter } from \"https://esm.town/v/nbbaier/integrations/mod.ts\";\nimport { issueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n\nexport default createRouter({\n integrations: [issueTracker({})],\n});\n```\n\nThe router owns **authentication**; the tracker's role model remains its own\n**authorization** layer, resolved from the router-provided user. A null user —\nthe ungated router's anonymous visitor — becomes a read-only viewer rather than\nbeing redirected to a login that doesn't exist. The bearer-token JSON API keeps\nits own gate, which stacks behind the router's when the router has one.\n\n### Options\n\n| Option | Meaning |\n| ------------- | --------------------------------------------------------------------- |\n| `maintainers` | Additional Val Town handles with maintainer access |\n| `owner` | Deprecated alias for `maintainers` |\n| `defaultRole` | `contributor` (default) or `viewer` for other logged-in users |\n| `auth` | Val Town OAuth when `true` (default); fully open tracker when `false` |\n| `title` | Header and browser title |\n| `apiKey` | Bearer token for JSON writes; defaults to `ISSUE_TRACKER_API_KEY` |\n\nWith auth enabled, viewers can read; contributors can create/comment and manage\nissues they created; maintainers can manage all issues, labels, and deletions.\n\n### Requirement when `auth` is on\n\nThe OAuth gate — this val's own when standalone, the router's when routed —\nneeds an `OAUTH_STATE_ENCRYPTION_KEY` env var (any random 32-byte hex string) to\nencrypt session cookies. Generate one with `openssl rand -hex 32`. The\nintegration declares it as `requiredEnv`, so a router's directory page badges it\nwhen unset.\n\n## Data model\n\n- Issues have `title`, markdown-text `body`, `open`/`closed` status, and an\n auto-managed `state_reason`.\n- Labels are curated name/colour entities and are applied through a join table.\n- Assignees are a set of Val Town handles.\n- Blocking edges form a strict DAG; `blocked` is derived from open blockers.\n- Comments are editable entities.\n- An append-only events table is the sole provenance/history source. Live\n entities retain current state and timestamps only; relationship rows are bare\n tuples.\n- Fresh installs seed `bug`, `enhancement`, `documentation`, `question`, and\n `duplicate` exactly once.\n\nSchema initialization is idempotent and runs on requests. It also migrates the\nold tracker schema: `description → body`, priority removal,\n`in_progress → open`, JSON labels and single assignee lifted into joins, and\nsynthetic creation events.\n\n## JSON API\n\nReads under `/api` are public. Writes require `Authorization: Bearer `.\nThe main operations are:\n\n| Method and path | Purpose |\n| ---------------------------------- | ----------------------------------------------------- |\n| `GET/POST /api/issues` | List/filter or create issues |\n| `GET/PATCH/DELETE /api/issues/:id` | Read, edit, or hard-delete an issue |\n| `POST /api/issues/:id/close` | Close with `completed`, `not_planned`, or `duplicate` |\n| `POST /api/issues/:id/reopen` | Reopen |\n| `POST /api/issues/:id/labels` | Apply/remove label IDs |\n| `POST /api/issues/:id/assignees` | Assign/unassign handles |\n| `POST /api/issues/:id/blocks` | Add/remove issues this issue blocks |\n| `POST /api/issues/:id/blocked-by` | Add/remove blockers |\n| `POST /api/issues/:id/comments` | Comment |\n| `PATCH/DELETE /api/comments/:id` | Edit/delete a comment |\n| `GET/POST /api/labels` | List/create labels |\n| `PATCH/DELETE /api/labels/:id` | Edit/delete a label |\n\nReads are public; writes are `401` without a valid bearer token and `403` if no\ntoken is configured at all. Requests are validated strictly: malformed IDs,\nfilters, or collection fields (`label_ids`, `add`/`remove`, `assignees`) return\n`400`; a missing issue, comment, or label returns `404`; a blocking cycle or\nduplicate label name returns `409`. Errors are always `{\"error\": \"...\"}`. See\n[docs/issue-tracker-valtown.md](./docs/issue-tracker-valtown.md) for the exact\nrequest and response shapes, the event-data grammar, and the full status-code\ntable.\n\n## Development\n\nBiome (tab-indented, per `biome.json`) is the canonical formatter — not\n`deno fmt`. Local Val Town and Claude Code state (`.vt/`, `.claude/`) is\nexcluded from formatting and lint checks.\n\n```bash\ndeno task fmt # biome check . --write (format + apply safe fixes)\ndeno task lint # deno lint\ndeno task typecheck # deno check across source and test files\ndeno task test # deno test\ndeno task check # runs all four in sequence\n```\n\nThe focused test suite uses Deno's SQLite-compatible in-memory driver; it never\nwrites a database file.\n\n## Files\n\n- `db.ts` — schema, migration, domain operations, and default Val Town store.\n- `api.ts` — bearer-authenticated Hono JSON API.\n- `app.tsx` — OAuth/permissions and HTML form routes.\n- `components.tsx`, `ui.tsx`, `layout.tsx` — server-rendered Hono TSX.\n- `mod.ts` — reusable public entry point.\n- `main.ts` — this val's own consumer.\n","createdAt",["D",1784052698291],"branchVersion","branchId","b6817ee5-03f4-41f2-901e-1bb2efa16e9e","id","abe99189-4851-4aab-ae08-280f66283cac","val-issue-tracker",["D",1783563523910],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Per-val issue tracker — import into any val for scoped issues","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","d1d90306-7b3c-11f1-b527-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","abe9918948514aabae08280f66283cac","tursoHostname","abe9918948514aabae08280f66283cac-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",369,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":542,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":543,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":544,"_83":545,"_85":546,"_87":25},"tree",[317,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353],"files",[317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353],"counts",{"_307":62,"_308":284,"_309":62,"_310":311,"_312":313},"contents",[129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":300,"_32":301,"_30":302,"_153":-5,"_40":41,"_39":303,"_155":58,"_37":304,"_13":62,"_33":305,"_34":-5,"_24":25,"_160":-5,"_27":306},{"_42":293,"_32":294,"_30":295,"_153":-5,"_40":41,"_39":296,"_155":58,"_37":297,"_13":62,"_33":20,"_34":298,"_24":25,"_160":-5,"_27":299},{"_42":287,"_32":288,"_30":289,"_153":-5,"_40":41,"_39":290,"_155":25,"_37":291,"_13":284,"_33":20,"_34":285,"_24":25,"_160":-5,"_27":292},{"_42":279,"_32":280,"_30":281,"_153":-5,"_40":41,"_39":282,"_155":25,"_37":283,"_13":284,"_33":20,"_34":285,"_24":25,"_160":-5,"_27":286},{"_42":272,"_32":273,"_30":274,"_153":-5,"_40":41,"_39":275,"_155":58,"_37":276,"_13":243,"_33":20,"_34":277,"_24":25,"_160":-5,"_27":278},{"_42":268,"_32":28,"_30":31,"_153":-5,"_40":41,"_39":14,"_155":25,"_37":269,"_13":270,"_33":20,"_34":36,"_24":25,"_160":-5,"_27":271},{"_42":261,"_32":262,"_30":263,"_153":-5,"_40":41,"_39":264,"_155":25,"_37":265,"_13":243,"_33":158,"_34":266,"_24":25,"_160":-5,"_27":267},{"_42":254,"_32":255,"_30":256,"_153":-5,"_40":41,"_39":257,"_155":25,"_37":258,"_13":243,"_33":158,"_34":259,"_24":25,"_160":-5,"_27":260},{"_42":246,"_32":247,"_30":248,"_153":-5,"_40":41,"_39":249,"_155":25,"_37":250,"_13":251,"_33":158,"_34":252,"_24":25,"_160":-5,"_27":253},{"_42":238,"_32":239,"_30":240,"_153":-5,"_40":41,"_39":241,"_155":25,"_37":242,"_13":243,"_33":158,"_34":244,"_24":25,"_160":-5,"_27":245},{"_42":230,"_32":231,"_30":232,"_153":-5,"_40":41,"_39":233,"_155":25,"_37":234,"_13":235,"_33":20,"_34":236,"_24":25,"_160":-5,"_27":237},{"_42":222,"_32":223,"_30":224,"_153":-5,"_40":41,"_39":225,"_155":25,"_37":226,"_13":227,"_33":158,"_34":228,"_24":25,"_160":-5,"_27":229},{"_42":214,"_32":215,"_30":216,"_153":-5,"_40":41,"_39":217,"_155":25,"_37":218,"_13":219,"_33":158,"_34":220,"_24":25,"_160":-5,"_27":221},{"_42":207,"_32":208,"_30":209,"_153":-5,"_40":41,"_39":210,"_155":25,"_37":211,"_13":167,"_33":158,"_34":212,"_24":25,"_160":-5,"_27":213},{"_42":200,"_32":201,"_30":202,"_153":-5,"_40":41,"_39":203,"_155":25,"_37":204,"_13":167,"_33":20,"_34":205,"_24":25,"_160":-5,"_27":206},{"_42":193,"_32":194,"_30":195,"_153":-5,"_40":41,"_39":196,"_155":25,"_37":197,"_13":62,"_33":158,"_34":198,"_24":25,"_160":-5,"_27":199},{"_42":186,"_32":187,"_30":188,"_153":-5,"_40":41,"_39":189,"_155":25,"_37":190,"_13":167,"_33":158,"_34":191,"_24":25,"_160":-5,"_27":192},{"_42":178,"_32":179,"_30":56,"_153":-5,"_40":41,"_39":180,"_155":58,"_37":181,"_13":182,"_33":183,"_34":184,"_24":25,"_160":-5,"_27":185},{"_42":170,"_32":171,"_30":172,"_153":-5,"_40":41,"_39":173,"_155":58,"_37":174,"_13":175,"_33":158,"_34":176,"_24":25,"_160":-5,"_27":177},{"_42":162,"_32":163,"_30":164,"_153":-5,"_40":41,"_39":165,"_155":58,"_37":166,"_13":167,"_33":158,"_34":168,"_24":25,"_160":-5,"_27":169},{"_42":150,"_32":151,"_30":152,"_153":-5,"_40":41,"_39":154,"_155":25,"_37":156,"_13":157,"_33":158,"_34":159,"_24":25,"_160":-5,"_27":161},"6516dd91-8c76-4357-ab20-f54e296757c4","ui.tsx","fca19e20-7b48-11f1-8cf9-1607ee4eb77e","parentId",181,"latest",["D",1783653143543],31,"script","/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\nimport type { IssueStatus, Label, StateReason } from \"./db.ts\";\n\nexport const FIELD =\n\t\"bg-[#1f232c] border border-[#2a2f3a] rounded-md min-h-10 px-3.5 text-sm font-medium text-[#e6e9ef] focus:outline-none focus:border-[#6ea8fe]\";\nconst BUTTON =\n\t\"inline-flex items-center gap-1.5 rounded-md min-h-10 px-3.5 text-sm font-medium cursor-pointer no-underline\";\nconst VARIANTS = {\n\tsolid: \"bg-[#3d7bf0] border border-[#3d7bf0] text-white hover:brightness-110\",\n\tghost:\n\t\t\"bg-transparent border border-[#3d7bf0] text-[#e6e9ef] hover:brightness-110\",\n\tdanger:\n\t\t\"bg-transparent border border-[#f06e7b] text-[#f06e7b] hover:bg-[#f06e7b] hover:text-white\",\n} as const;\n\nexport const STATUS_LABELS: Record = {\n\topen: \"Open\",\n\tclosed: \"Closed\",\n};\nexport const STATE_REASON_LABELS: Record, string> = {\n\tcompleted: \"Completed\",\n\tnot_planned: \"Not planned\",\n\tduplicate: \"Duplicate\",\n\treopened: \"Reopened\",\n};\n\nexport const Card: FC> = ({\n\tchildren,\n\tclass: cls,\n}) => (\n\t\n\t\t{children}\n\t\n);\n\nexport const Button: FC<\n\tPropsWithChildren<{\n\t\tvariant?: keyof typeof VARIANTS;\n\t\thref?: string;\n\t\ttype?: \"button\" | \"submit\";\n\t\tclass?: string;\n\t\tname?: string;\n\t\tvalue?: string;\n\t}>\n> = ({\n\tvariant = \"solid\",\n\thref,\n\ttype = \"button\",\n\tclass: cls,\n\tname,\n\tvalue,\n\tchildren,\n}) => {\n\tconst classes = `${BUTTON} ${VARIANTS[variant]} ${cls ?? \"\"}`;\n\treturn href ? (\n\t\t\n\t\t\t{children}\n\t\t\n\t) : (\n\t\t\n\t);\n};\n\nexport const Select: FC<\n\tPropsWithChildren<{ name: string; id?: string; class?: string }>\n> = ({ name, id, class: cls, children }) => (\n\t\n);\n\nexport const Banner: FC<{ kind: \"ok\" | \"err\"; msg: string }> = ({\n\tkind,\n\tmsg,\n}) => (\n\t\n\t\t{msg}\n\t\n);\n\nexport const StatusBadge: FC<{ status: IssueStatus; reason?: StateReason }> = ({\n\tstatus,\n\treason,\n}) => (\n\t\n\t\t{STATUS_LABELS[status]}\n\t\t{reason ? ` · ${STATE_REASON_LABELS[reason]}` : \"\"}\n\t\n);\n\nexport const LabelTag: FC<{ label: Label }> = ({ label }) => (\n\t\n\t\t{label.name}\n\t\n);\n","label",[151],"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[];\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 => {\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",[163],"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",[171],"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",[179],"580b2311-b91a-46b7-8873-5534506f1784","layout.tsx","fd6015ee-7b48-11f1-bafe-1607ee4eb77e",211,["D",1783785765724],"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\n\nexport const Layout: FC<\n\tPropsWithChildren<{\n\t\ttitle: string;\n\t\tuser?: string | null;\n\t\tauth?: boolean;\n\t\t/** Mount prefix for internal links; \"\" standalone. /auth/* stays\n\t\t * origin-level in both modes, so those links never take it. */\n\t\tbase?: string;\n\t}>\n> = ({ title, user, auth = true, base = \"\", children }) => (\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t{title}\n\t\t\t

Diff · v227