{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_546":547,"_548":549},"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",196,"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\tasync batch(statements: Array) {\n\t\t\tdatabase.exec(\"BEGIN IMMEDIATE\");\n\t\t\ttry {\n\t\t\t\tconst results = [];\n\t\t\t\tfor (const statement of statements) {\n\t\t\t\t\tresults.push(await execute(statement));\n\t\t\t\t}\n\t\t\t\tdatabase.exec(\"COMMIT\");\n\t\t\t\treturn results;\n\t\t\t} catch (error) {\n\t\t\t\tdatabase.exec(\"ROLLBACK\");\n\t\t\t\tthrow error;\n\t\t\t}\n\t\t},\n\t};\n}\n","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","createdAt",["D",1783711960293],"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":541,"_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":542,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":543,"_84":544,"_86":545,"_88":25},"tree",[315,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351],"files",[315,316,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],"counts",{"_305":63,"_306":208,"_307":63,"_308":309,"_310":311},"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":298,"_32":299,"_30":300,"_154":-5,"_41":42,"_40":301,"_156":59,"_38":302,"_13":63,"_33":303,"_35":-5,"_24":25,"_160":-5,"_27":304},{"_43":291,"_32":292,"_30":293,"_154":-5,"_41":42,"_40":294,"_156":59,"_38":295,"_13":63,"_33":20,"_35":296,"_24":25,"_160":-5,"_27":297},{"_43":285,"_32":286,"_30":287,"_154":-5,"_41":42,"_40":288,"_156":25,"_38":289,"_13":208,"_33":20,"_35":283,"_24":25,"_160":-5,"_27":290},{"_43":278,"_32":279,"_30":280,"_154":-5,"_41":42,"_40":281,"_156":25,"_38":282,"_13":208,"_33":20,"_35":283,"_24":25,"_160":-5,"_27":284},{"_43":271,"_32":272,"_30":273,"_154":-5,"_41":42,"_40":274,"_156":25,"_38":275,"_13":208,"_33":20,"_35":276,"_24":25,"_160":-5,"_27":277},{"_43":263,"_32":264,"_30":265,"_154":-5,"_41":42,"_40":266,"_156":25,"_38":267,"_13":268,"_33":20,"_35":269,"_24":25,"_160":-5,"_27":270},{"_43":256,"_32":257,"_30":258,"_154":-5,"_41":42,"_40":259,"_156":25,"_38":260,"_13":164,"_33":34,"_35":261,"_24":25,"_160":-5,"_27":262},{"_43":249,"_32":250,"_30":251,"_154":-5,"_41":42,"_40":252,"_156":25,"_38":253,"_13":164,"_33":34,"_35":254,"_24":25,"_160":-5,"_27":255},{"_43":241,"_32":242,"_30":243,"_154":-5,"_41":42,"_40":244,"_156":25,"_38":245,"_13":246,"_33":34,"_35":247,"_24":25,"_160":-5,"_27":248},{"_43":234,"_32":235,"_30":236,"_154":-5,"_41":42,"_40":237,"_156":25,"_38":238,"_13":208,"_33":34,"_35":239,"_24":25,"_160":-5,"_27":240},{"_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":25,"_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":25,"_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],"80ef53f6-f527-4cdf-ac75-0c667acc93b6",["D",1783711960293],2,[28],"cd8a9ea8-1579-4629-9a43-c9a3525477d5","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",30,["D",1783568883064],11,"export {\n\tcreateIssueTracker,\n\tdefault,\n\ttype IssueTrackerOptions,\n} from \"./app.tsx\";\n",[167],"b64f3437-f4bc-4279-9ad6-786ec6cac581","main.ts",162,["D",1783653141198],10,"http","import { createIssueTracker } from \"./mod.ts\";\n\n/**\n * This val's own issue tracker — manages THIS val's scoped SQLite database.\n *\n * To add issues to a DIFFERENT val, import the tracker into that val:\n *\n * import { createIssueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n * export default createIssueTracker({ owner: [\"nbbaier\"] });\n *\n * Because scoped SQLite is bound to the running val, the imported tracker\n * reads/writes the host val's database automatically — no per-val config needed.\n */\nexport default createIssueTracker({});\n",[175],"17e2256d-d27b-4705-aa51-8a95e016e3e4","layout.tsx","fd6015ee-7b48-11f1-bafe-1607ee4eb77e",107,["D",1783574315459],"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\n\nexport const Layout: FC<\n\tPropsWithChildren<{\n\t\ttitle: string;\n\t\tuser?: string | null;\n\t\tauth?: boolean;\n\t}>\n> = ({ title, user, auth = true, children }) => (\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t{title}\n\t\t\t

Diff · v196