{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",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",220,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","test_sqlite.ts","latestPath","fileId","2bb2ce86-7c0d-11f1-9a68-1607ee4eb77e","name","fileType","script","content","import { DatabaseSync } from \"node:sqlite\";\n\nexport interface TestResultSet {\n\tcolumns: string[];\n\trows: Record[];\n\trowsAffected: number;\n\tlastInsertRowid: bigint | undefined;\n}\n\nexport function createTestSqlite() {\n\tconst database = new DatabaseSync(\":memory:\");\n\tdatabase.exec(\"PRAGMA foreign_keys = ON\");\n\n\tconst execute = (\n\t\tstatement: string | { sql: string; args?: unknown[] },\n\t): Promise => {\n\t\ttry {\n\t\t\tconst sql = typeof statement === \"string\" ? statement : statement.sql;\n\t\t\tconst args = typeof statement === \"string\" ? [] : (statement.args ?? []);\n\t\t\tconst prepared = database.prepare(sql);\n\t\t\tif (/^\\s*(SELECT|PRAGMA|WITH)\\b/i.test(sql)) {\n\t\t\t\tconst rows = prepared.all(...(args as never[])) as Record<\n\t\t\t\t\tstring,\n\t\t\t\t\tunknown\n\t\t\t\t>[];\n\t\t\t\treturn Promise.resolve({\n\t\t\t\t\tcolumns: rows[0] ? Object.keys(rows[0]) : [],\n\t\t\t\t\trows,\n\t\t\t\t\trowsAffected: 0,\n\t\t\t\t\tlastInsertRowid: undefined,\n\t\t\t\t});\n\t\t\t}\n\t\t\tconst result = prepared.run(...(args as never[]));\n\t\t\treturn Promise.resolve({\n\t\t\t\tcolumns: [],\n\t\t\t\trows: [],\n\t\t\t\trowsAffected: Number(result.changes),\n\t\t\t\tlastInsertRowid: BigInt(result.lastInsertRowid),\n\t\t\t});\n\t\t} catch (error) {\n\t\t\treturn Promise.reject(error);\n\t\t}\n\t};\n\n\treturn {\n\t\tdatabase,\n\t\texecute,\n\t\t/**\n\t\t * Mirror the libsql `transaction(\"write\")` contract on top of node:sqlite:\n\t\t * `BEGIN IMMEDIATE` opens an exclusive write transaction, statements run\n\t\t * sequentially on the single in-memory connection, and `commit`/`rollback`\n\t\t * close it. This is the same atomic-write contract `db.ts` drives in\n\t\t * production, so the store tests exercise the real transaction path.\n\t\t */\n\t\ttransaction(_mode?: \"write\" | \"read\" | \"deferred\") {\n\t\t\tdatabase.exec(\"BEGIN IMMEDIATE\");\n\t\t\tlet settled = false;\n\t\t\tconst finish = (verb: \"COMMIT\" | \"ROLLBACK\") => {\n\t\t\t\tif (settled) return Promise.resolve();\n\t\t\t\tsettled = true;\n\t\t\t\tdatabase.exec(verb);\n\t\t\t\treturn Promise.resolve();\n\t\t\t};\n\t\t\treturn Promise.resolve({\n\t\t\t\texecute,\n\t\t\t\tcommit: () => finish(\"COMMIT\"),\n\t\t\t\trollback: () => finish(\"ROLLBACK\"),\n\t\t\t});\n\t\t},\n\t};\n}\n","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","createdAt",["D",1784052697980],"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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"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",{"_43":44,"_32":45,"_38":542,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":543,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":544,"_84":545,"_86":546,"_88":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":63,"_308":284,"_309":63,"_310":311,"_312":313},"contents",[130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":300,"_32":301,"_30":302,"_154":-5,"_41":42,"_40":303,"_156":59,"_38":304,"_13":63,"_33":305,"_35":-5,"_24":25,"_160":-5,"_27":306},{"_43":293,"_32":294,"_30":295,"_154":-5,"_41":42,"_40":296,"_156":59,"_38":297,"_13":63,"_33":20,"_35":298,"_24":25,"_160":-5,"_27":299},{"_43":287,"_32":288,"_30":289,"_154":-5,"_41":42,"_40":290,"_156":25,"_38":291,"_13":284,"_33":20,"_35":285,"_24":25,"_160":-5,"_27":292},{"_43":279,"_32":280,"_30":281,"_154":-5,"_41":42,"_40":282,"_156":25,"_38":283,"_13":284,"_33":20,"_35":285,"_24":25,"_160":-5,"_27":286},{"_43":272,"_32":273,"_30":274,"_154":-5,"_41":42,"_40":275,"_156":25,"_38":276,"_13":164,"_33":20,"_35":277,"_24":25,"_160":-5,"_27":278},{"_43":264,"_32":265,"_30":266,"_154":-5,"_41":42,"_40":267,"_156":25,"_38":268,"_13":269,"_33":20,"_35":270,"_24":25,"_160":-5,"_27":271},{"_43":257,"_32":258,"_30":259,"_154":-5,"_41":42,"_40":260,"_156":25,"_38":261,"_13":164,"_33":34,"_35":262,"_24":25,"_160":-5,"_27":263},{"_43":250,"_32":251,"_30":252,"_154":-5,"_41":42,"_40":253,"_156":25,"_38":254,"_13":164,"_33":34,"_35":255,"_24":25,"_160":-5,"_27":256},{"_43":242,"_32":243,"_30":244,"_154":-5,"_41":42,"_40":245,"_156":25,"_38":246,"_13":247,"_33":34,"_35":248,"_24":25,"_160":-5,"_27":249},{"_43":234,"_32":235,"_30":236,"_154":-5,"_41":42,"_40":237,"_156":25,"_38":238,"_13":239,"_33":34,"_35":240,"_24":25,"_160":-5,"_27":241},{"_43":227,"_32":228,"_30":229,"_154":-5,"_41":42,"_40":230,"_156":25,"_38":231,"_13":208,"_33":20,"_35":232,"_24":25,"_160":-5,"_27":233},{"_43":219,"_32":220,"_30":221,"_154":-5,"_41":42,"_40":222,"_156":25,"_38":223,"_13":224,"_33":34,"_35":225,"_24":25,"_160":-5,"_27":226},{"_43":211,"_32":212,"_30":213,"_154":-5,"_41":42,"_40":214,"_156":25,"_38":215,"_13":216,"_33":34,"_35":217,"_24":25,"_160":-5,"_27":218},{"_43":203,"_32":204,"_30":205,"_154":-5,"_41":42,"_40":206,"_156":25,"_38":207,"_13":208,"_33":34,"_35":209,"_24":25,"_160":-5,"_27":210},{"_43":196,"_32":197,"_30":198,"_154":-5,"_41":42,"_40":199,"_156":25,"_38":200,"_13":164,"_33":20,"_35":201,"_24":25,"_160":-5,"_27":202},{"_43":189,"_32":190,"_30":191,"_154":-5,"_41":42,"_40":192,"_156":25,"_38":193,"_13":63,"_33":34,"_35":194,"_24":25,"_160":-5,"_27":195},{"_43":182,"_32":183,"_30":184,"_154":-5,"_41":42,"_40":185,"_156":25,"_38":186,"_13":164,"_33":34,"_35":187,"_24":25,"_160":-5,"_27":188},{"_43":174,"_32":175,"_30":57,"_154":-5,"_41":42,"_40":176,"_156":59,"_38":177,"_13":178,"_33":179,"_35":180,"_24":25,"_160":-5,"_27":181},{"_43":166,"_32":167,"_30":168,"_154":-5,"_41":42,"_40":169,"_156":25,"_38":170,"_13":171,"_33":34,"_35":172,"_24":25,"_160":-5,"_27":173},{"_43":162,"_32":28,"_30":31,"_154":-5,"_41":42,"_40":14,"_156":59,"_38":163,"_13":164,"_33":34,"_35":37,"_24":25,"_160":-5,"_27":165},{"_43":151,"_32":152,"_30":153,"_154":-5,"_41":42,"_40":155,"_156":25,"_38":157,"_13":158,"_33":34,"_35":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,"/** @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",[152],"06a3a637-e081-4666-a2b1-479fa57ef458",["D",1784052697980],3,[28],"96303bcb-4828-4fb5-88b0-b396e9bbddbe","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",216,["D",1783790091154],12,"export {\n\tdefault,\n\ttype IssueTrackerOptions,\n\tissueTracker,\n} from \"./app.tsx\";\n",[167],"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",[175],"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 · v220