[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10,"_11":12},"actionData","errors","root",{"_271":-5,"_274":275,"_276":277},"routes/shell",{"_40":41,"_270":-5,"_271":-5,"_272":273},"routes/repo",{"_33":-7,"_34":35,"_36":37,"_38":39,"_40":41,"_42":31,"_43":31,"_44":31,"_45":31,"_46":31,"_47":31,"_48":49,"_50":49,"_51":31,"_52":-7,"_53":-7,"_54":55,"_56":57,"_58":59,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68},"routes/repo.blob",{"_13":14,"_15":16,"_17":18,"_19":20,"_21":14,"_22":23,"_24":-5,"_25":26,"_27":28,"_28":29,"_30":31,"_32":14},"ref","cf89a0f2bb59cd56f584b4df17c24cdc406cc99e","path","services/channel/src/storage.ts","oid","65f01f77a293145678e3ca5105d6a00a4219402c","size",3141,"commit","mounts",[],"source","plain",{"_13":14,"_15":16},"kind","text","import type {\n\tSqliteDatabase,\n\tSqliteExecutor,\n\tSqliteValue,\n} from \"@earendil-works/pi-durable/storage/sqlite\";\n\n/** Workers SQL takes ArrayBuffers and safe-range numbers where pi passes byte arrays and bigints. */\nfunction bind(value: SqliteValue): unknown {\n\tif (value instanceof Uint8Array) return value.slice().buffer;\n\tif (typeof value === \"bigint\") return Number(value);\n\treturn value;\n}\n\nfunction row(raw: Record): T {\n\tfor (const [key, value] of Object.entries(raw)) {\n\t\tif (value instanceof ArrayBuffer) raw[key] = new Uint8Array(value);\n\t}\n\treturn raw as T;\n}\n\n/**\n * pi's portable SQLite core on a Durable Object's database. Workers SQL is synchronous and refuses\n * `BEGIN`, so transactions go through `storage.transaction`, which includes every `sql.exec` made\n * while its callback runs and rolls back when the callback rejects. Other work waits its turn.\n */\nexport class DurableSqlite implements SqliteDatabase {\n\t#storage: DurableObjectStorage;\n\t#tail: Promise = Promise.resolve();\n\n\tconstructor(storage: DurableObjectStorage) {\n\t\tthis.#storage = storage;\n\t}\n\n\t#query(sql: string, params: SqliteValue[]) {\n\t\treturn this.#storage.sql.exec(sql, ...params.map(bind));\n\t}\n\n\t#direct(): SqliteExecutor {\n\t\treturn {\n\t\t\texec: async (sql) => void this.#storage.sql.exec(sql),\n\t\t\trun: async (sql, ...params) => void this.#query(sql, params).toArray(),\n\t\t\tget: async (sql: string, ...params: SqliteValue[]) => {\n\t\t\t\tconst [first] = this.#query(sql, params).toArray();\n\t\t\t\treturn first && row(first);\n\t\t\t},\n\t\t\tall: async (sql: string, ...params: SqliteValue[]) =>\n\t\t\t\tthis.#query(sql, params).toArray().map((raw) => row(raw)),\n\t\t};\n\t}\n\n\t#serial(operation: () => Promise): Promise {\n\t\tconst result = this.#tail.then(operation);\n\t\tthis.#tail = result.catch(() => {});\n\t\treturn result;\n\t}\n\n\texec(sql: string): Promise {\n\t\treturn this.#serial(() => this.#direct().exec(sql));\n\t}\n\n\trun(sql: string, ...params: SqliteValue[]): Promise {\n\t\treturn this.#serial(() => this.#direct().run(sql, ...params));\n\t}\n\n\tget(sql: string, ...params: SqliteValue[]): Promise {\n\t\treturn this.#serial(() => this.#direct().get(sql, ...params));\n\t}\n\n\tall(sql: string, ...params: SqliteValue[]): Promise {\n\t\treturn this.#serial(() => this.#direct().all(sql, ...params));\n\t}\n\n\ttransaction(callback: (transaction: SqliteExecutor) => Promise): Promise {\n\t\treturn this.#serial(() => {\n\t\t\tlet active = true;\n\t\t\tconst direct = this.#direct();\n\t\t\tconst check = () => {\n\t\t\t\tif (!active) throw new Error(\"SQLite transaction handle is no longer active\");\n\t\t\t};\n\t\t\tconst handle: SqliteExecutor = {\n\t\t\t\texec: (sql) => (check(), direct.exec(sql)),\n\t\t\t\trun: (sql, ...params) => (check(), direct.run(sql, ...params)),\n\t\t\t\tget: (sql, ...params) => (check(), direct.get(sql, ...params)),\n\t\t\t\tall: (sql, ...params) => (check(), direct.all(sql, ...params)),\n\t\t\t};\n\t\t\treturn this.#storage.transaction(() => callback(handle)).finally(() => (active = false));\n\t\t});\n\t}\n\n\tasync close(): Promise {}\n}\n","editable",false,"branch","documentNavigation","repo","githubnext/ace2","repoId","938fe4cd-5320-4e4f-ac7c-87d4dad8490c","ownerId","org:89615882","site","nexthub","private","admin","settings","maintainer","triage","starred","stars",0,"watchers","watching","pinned","notify","views",[226,227,228,229,230,231,232,233,234,235,236,237,238],"navigation",{"_54":55,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193},"sources",[],"viewer","meta",{"_174":175,"_176":177,"_178":179,"_42":31,"_180":166,"_181":31,"_48":49,"_50":49},"branches",[81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173],"tags",[69,70,71,72,73,74,75,76,77,78,79,80],"cloneUrl","https://git.nexthub.sh/githubnext/ace2.git","desktop-canary-v0.0.10","desktop-canary-v0.0.11","desktop-canary-v0.0.12","desktop-canary-v0.0.13","desktop-canary-v0.0.14","desktop-canary-v0.0.15","desktop-canary-v0.0.16","desktop-canary-v0.0.18","desktop-canary-v0.0.21","desktop-canary-v0.0.7","desktop-canary-v0.0.8","desktop-canary-v0.0.9","amber-beacon/composer-effort","brisk-ember/github-avatars","brisk-grove/image-paste-91","calm-anchor/fix-streaming-draft-overlap","calm-grove/composer-agent-mode","cloud-pilot-ops/canary-0-0-17","cloud-pilot-ops/cloud-move","cloud-pilot-ops/cloud-pilot","codex/agentation-shortcut","codex/annotation-polish","codex/browser-pages","codex/canary-0-0-21","codex/canary-0.0.11","codex/channel-delete-close","codex/channel-watch-recovery","codex/clipboard-files-write","codex/composer-coordinate-check","codex/computer-use-validation","codex/desktop-actions","codex/desktop-app-search","codex/desktop-app-state","codex/desktop-availability","codex/desktop-click-variants","codex/desktop-clipboard","codex/desktop-clipboard-files","codex/desktop-clipboard-image","codex/desktop-clipboard-image-write","codex/desktop-clipboard-text","codex/desktop-drag","codex/desktop-keyboard","codex/desktop-launch","codex/desktop-locked-feedback","codex/desktop-menu-command","codex/desktop-menu-inventory","codex/desktop-minimize","codex/desktop-open","codex/desktop-pointer","codex/desktop-quit","codex/desktop-selection-keys","codex/desktop-tool-guidance","codex/desktop-tools-extraction","codex/desktop-window-close","codex/desktop-window-geometry","codex/desktop-windows","codex/dev-permission-identity","codex/durable-composer-drafts","codex/fix-message-clipping","codex/lane-base-96","codex/native-patch-prefix","codex/peekaboo","codex/peer-channel-messaging","codex/pixel-snapshot-authority","codex/publish-canary-0-0-21","codex/readme-security","codex/settings-refresh","codex/stale-click-refusal","codex/tab-renaming-api","codex/team-agent-access","codex/team-channel-sections","codex/team-dogfood-integration","codex/webkit-coordinate-window","codex/webkit-desktop-focus","deft-beacon/helper-isolation","deft-grove/align-avatar-byline","deft-grove/build-canary-0-0-18","deft-grove/canary-github-releases","deft-grove/ship-canary-0-0-18","deft-meadow/details-sidebar","fair-ember/canary-0-0-13","fair-ember/canary-0-0-14","fair-fjord/all-projects","feat/github-cache","feat/rebuild","fix/channel-credentials","glad-anchor/restore-message-queue","glad-ember/archive-inactive-channels","glad-fjord/project-identity","glad-orbit/channel-progress","glad-ridge/terminal-replay-input","hazy-anchor/github-row-actions","hazy-ember/channel-access-toggles","hazy-grove/all-projects-add-channel","local-project-setup/build-canary-0-0-20","local-project-setup/canary-0-0-20","local-project-setup/local-project-setup","main","mellow-ridge/canary-0-0-16","mellow-ridge/top-bar-drag-area","nimble-cedar/modal-top-offset","nimble-meadow/canary-0-0-15","remote-channel-load/build-canary-0-0-19","remote-channel-load/canary-0-0-19","remote-channel-load/fix-remote-channel-load","description","Ace: a collaborative coding environment on the team's own machines","owner","githubnext","section","","head","empty","pins",[208,209,210],"documents",{"_203":204,"_205":206},"code",{"_199":200,"_201":202},"automations",{"_196":197,"_198":-5},"delivery",{"_194":49,"_195":-5},"tag","9Rn62lcgXCFfpmCuooTjLxGyUf8","releases","applications","workflows",2,"deployments","commits",215,"changes",1,"counts",{"_207":206},"total",86,"issue",{"_211":201,"_213":224,"_15":201,"_215":225,"_52":217,"_218":31,"_219":217,"_220":202},{"_211":221,"_213":222,"_15":221,"_215":223,"_52":217,"_218":31,"_219":217,"_220":49},{"_211":212,"_213":214,"_15":212,"_215":216,"_52":217,"_218":31,"_219":217,"_220":206},"id","issues","name","Issues","filters",{},true,"saved","pinnable","count","tasks","Tasks",{},"Changes",{},{"_211":201,"_213":224,"_15":201,"_215":269,"_52":217,"_218":31,"_219":217},{"_211":221,"_213":222,"_15":221,"_215":268,"_52":217,"_218":31,"_219":217},{"_211":212,"_213":214,"_15":212,"_215":267,"_52":217,"_218":31,"_219":217},{"_211":264,"_213":265,"_15":264,"_215":266,"_52":31,"_218":31,"_219":217},{"_211":261,"_213":262,"_15":261,"_215":263,"_52":31,"_218":31,"_219":217},{"_211":196,"_213":259,"_15":188,"_215":260,"_52":31,"_218":31,"_219":217},{"_211":198,"_213":256,"_15":257,"_215":258,"_52":31,"_218":31,"_219":217},{"_211":194,"_213":254,"_15":194,"_215":255,"_52":31,"_218":31,"_219":217},{"_211":250,"_213":251,"_15":252,"_215":253,"_52":31,"_218":31,"_219":217},{"_211":184,"_213":248,"_15":184,"_215":249,"_52":31,"_218":31,"_219":31},{"_211":245,"_213":246,"_15":245,"_215":247,"_52":31,"_218":31,"_219":31},{"_211":242,"_213":243,"_15":242,"_215":244,"_52":31,"_218":31,"_219":31},{"_211":239,"_213":240,"_15":239,"_215":241,"_52":31,"_218":31,"_219":31},"decisions","Decisions",{},"changelog","Changelog",{},"roadmap","Roadmap",{},"Documents",{},"activity","Activity","insights",{},"Releases",{},"Deployments","automations/deployments",{},"Workflows",{},"discussions","Discussions",{},"goals","Goals",{},{},{},{},"groups","user","agents",[],"now",1794439900541,"sidebar","expanded"]