\\n>

⚙️ Run configuration

\\n> \\n> **Configuration used**: Organization UI\\n> \\n> **Review profile**: ASSERTIVE\\n> \\n> **Plan**: Pro\\n> \\n> **Run ID**: `b3ec4376-a595-45ec-9e8d-6f3ac3d44ca0`\\n> \\n>

\\n> \\n>

\\n>

📥 Commits

\\n> \\n> Reviewing files that changed from the base of the PR and between 5cc15a168cedb86bbb9a361bf1b3e37ffef470bc and 52168984fe3fa3ddb963587bbaeffbccf3d04939.\\n> \\n>

\\n> \\n>

\\n>

📒 Files selected for processing (10)

\\n> \\n> * `CHANGELOG.md`\\n> * `package.json`\\n> * `src/core/sqlite-db.ts`\\n> * `src/core/undo-history.ts`\\n> * `src/databaseModel.ts`\\n> * `src/editorController.ts`\\n> * `src/workerFactory.ts`\\n> * `tests/unit/databaseModel.test.ts`\\n> * `tests/unit/editorController.test.ts`\\n> * `tests/unit/workerFactory_browser.test.ts`\\n> \\n>

\\n> \\n> ```ascii\\n> _________________________________________________\\n> < SNAFU: Situation Normal, All Faults Understood. >\\n> -------------------------------------------------\\n> \\\\\\n> \\\\ \\\\\\n> \\\\ /\\\\\\n> ( )\\n> .( o ).\\n> ```\\n\\n\\n\\n\\n\\n

\\n

✨ Finishing Touches

\\n\\n

\\n

📝 Generate docstrings

\\n\\n- [ ] Create stacked PR\\n- [ ] Commit on current branch\\n\\n

\\n

🧪 Generate unit tests (beta)

\\n\\n- [ ] Create PR with unit tests\\n- [ ] Commit unit tests in branch `feat/web-edit-support`\\n\\n

\\n\\n

\\n\\n\\n\\n\\n---\\n\\nThanks for using [CodeRabbit](https://coderabbit.ai?utm_source=oss&utm_medium=github&utm_campaign=zknpr/SQLite-Explorer&utm_content=424)! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.\\n\\n

\\n

❤️ Share

\\n\\n- [X](https://twitter.com/intent/tweet?text=I%20just%20used%20%40coderabbitai%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20the%20proprietary%20code.%20Check%20it%20out%3A&url=https%3A//coderabbit.ai)\\n- [Mastodon](https://mastodon.social/share?text=I%20just%20used%20%40coderabbitai%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20the%20proprietary%20code.%20Check%20it%20out%3A%20https%3A%2F%2Fcoderabbit.ai)\\n- [Reddit](https://www.reddit.com/submit?title=Great%20tool%20for%20code%20review%20-%20CodeRabbit&text=I%20just%20used%20CodeRabbit%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20proprietary%20code.%20Check%20it%20out%3A%20https%3A//coderabbit.ai)\\n- [LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fcoderabbit.ai&mini=true&title=Great%20tool%20for%20code%20review%20-%20CodeRabbit&summary=I%20just%20used%20CodeRabbit%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20proprietary%20code)\\n\\n

\\n\\n\\n_{Comment `@coderabbitai help` to get the list of available commands and usage tips.}\\n\\n\",\"path\":null,\"side\":null,\"line\":null}{\"type\":\"pull_request_comment\",\"body\":\"## Code Review\\n\\nThis pull request enables database editing in VS Code for Web (vscode.dev / github.dev) by allowing write mode in the browser extension host and preventing silent data loss on save failures. It updates `SupportsWriteMode` to include the browser extension host, ensures the modification tracker checkpoint is only created after successful persistence, and adds comprehensive unit tests to verify these behaviors. There are no review comments, so no feedback is provided.\",\"path\":null,\"side\":null,\"line\":null}{\"type\":\"pull_request_comment\",\"body\":\"**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Preserve WAL contents when saving web databases**\\n\\nWhen a database opened from github.dev has a companion `-wal` file, `loadDatabaseFiles()` reads that WAL, but the WASM engine initialization never applies `walContent`; after this change the browser provider is writable and this line overwrites only the main database URI with the serialized in-memory DB. In that scenario, committed pages that existed only in the WAL are dropped (and the stale `-wal` may still remain), so saving an edited WAL-mode repository database can lose or corrupt existing data. Please checkpoint/merge the WAL or reject WAL-backed files before enabling write/save.\\n\\nUseful? React with 👍 / 👎.\",\"path\":\"src/databaseModel.ts\",\"side\":\"RIGHT\",\"line\":365}{\"type\":\"pull_request_comment\",\"body\":\"**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Implement WASM replay before enabling web writes**\\n\\nWith browser write mode enabled here, every web edit uses the in-process WASM facade, but that facade currently wires `applyModifications`, `undoModification`, `redoModification`, and `discardModifications` as no-ops in `createInProcessWasmDatabaseConnection`. In vscode.dev this means Undo/Revert and hot-exit backup restore can mark the custom document state as handled while leaving the in-memory database unchanged, so users can save edits they thought were undone or lose recovered unsaved changes. Please either implement those modification operations for the browser WASM path or keep the web provider read-only until they work.\\n\\nUseful? React with 👍 / 👎.\",\"path\":\"src/databaseModel.ts\",\"side\":\"RIGHT\",\"line\":56}{\"type\":\"pull_request_comment\",\"body\":\"**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Avoid checkpointing edits made during an in-flight save**\\n\\nBecause the checkpoint is now created after the async filesystem write, any edit that arrives after `serializeDatabase()` has produced `binaryContent` but before `writeFile()` resolves is included in `timeline.length` and marked clean here even though those bytes were not part of the file that was just saved. This is especially plausible on slow web filesystem writes or with multiple editor panes, and it can silently drop the later edit on close/reload; snapshot the checkpoint position at serialization time (and only commit that snapshot after success) or block edits while saving.\\n\\nUseful? React with 👍 / 👎.\",\"path\":\"src/databaseModel.ts\",\"side\":\"RIGHT\",\"line\":null}{\"type\":\"pull_request_comment\",\"body\":\"\\n### 💡 Codex Review\\n\\nHere are some automated review suggestions for this pull request.\\n\\n**Reviewed commit:** `a1cde57272`\\n \\n\\n

ℹ️ About Codex in GitHub

\\n
\\n\\n[Your team has set up Codex to review pull requests in this repo](https://chatgpt.com/codex/cloud/settings/general). Reviews are triggered when you\\n- Open a pull request for review\\n- Mark a draft as ready\\n- Comment \\\"@codex review\\\".\\n\\nIf Codex has suggestions, it will comment; otherwise it will react with 👍.\\n\\n\\n\\n\\nCodex can also answer questions or update the PR. Try commenting \\\"@codex address that feedback\\\".\\n \\n

\",\"path\":null,\"side\":null,\"line\":null}","text_elements",[],{"_475":1040,"_456":457,"_477":463},{"_478":1041,"_480":-5,"_41":-5,"_481":-5,"_94":320,"_90":483},[1042],{"_45":1036,"_90":1043},"input_text",{"_475":1045,"_456":457,"_477":463},{"_478":1046,"_480":-5,"_41":-5,"_481":-5,"_94":320,"_90":483},[1047],{"_45":1048,"_90":1043},"\n /workspace/SQLite-Explorer\n bash\n 2026-06-01\n Etc/UTC\n",{"_475":1050,"_456":457,"_477":463},{"_478":1051,"_480":-5,"_41":-5,"_481":-5,"_94":1052,"_90":483},[1053,1054],"developer",{"_45":1056,"_90":1043},{"_45":1055,"_90":1043},"\n## Skills\nA skill is a set of local instructions to follow that is stored in a `SKILL.md` file. Below is the list of skills that can be used. Each entry includes a name, description, and file path so you can open the source for full instructions when using a specific skill.\n### Available skills\n- imagegen: Generate or edit raster images when the task benefits from AI-created bitmap visuals such as photos, illustrations, textures, sprites, mockups, or transparent-background cutouts. Use when Codex should create a brand-new image, transform an existing image, or derive visual variants from references, and the output should be a bitmap asset rather than repo-native code or vector. Do not use when the task is better handled by editing existing SVG/vector/code-native assets, extending an established icon or logo system, or building the visual directly in HTML/CSS/canvas. (file: /opt/codex/skills/.system/imagegen/SKILL.md)\n- openai-docs: Use when the user asks how to build with OpenAI products or APIs and needs up-to-date official documentation with citations, help choosing the latest model for a use case, or model upgrade and prompt-upgrade guidance; prioritize OpenAI docs MCP tools, use bundled references only as helper context, and restrict any fallback browsing to official OpenAI domains. (file: /opt/codex/skills/.system/openai-docs/SKILL.md)\n- plugin-creator: Create and scaffold plugin directories for Codex with a required `.codex-plugin/plugin.json`, optional plugin folders/files, and baseline placeholders you can edit before publishing or testing. Use when Codex needs to create a new local plugin, add optional plugin structure, or generate or update repo-root `.agents/plugins/marketplace.json` entries for plugin ordering and availability metadata. (file: /opt/codex/skills/.system/plugin-creator/SKILL.md)\n- skill-creator: Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Codex's capabilities with specialized knowledge, workflows, or tool integrations. (file: /opt/codex/skills/.system/skill-creator/SKILL.md)\n- skill-installer: Install Codex skills into $CODEX_HOME/skills from a curated list or a GitHub repo path. Use when a user asks to list installable skills, install a curated skill, or install a skill from another repo (including private repos). (file: /opt/codex/skills/.system/skill-installer/SKILL.md)\n### How to use skills\n- Discovery: The list above is the skills available in this session (name + description + file path). Skill bodies live on disk at the listed paths.\n- Trigger rules: If the user names a skill (with `$SkillName` or plain text) OR the task clearly matches a skill's description shown above, you must use that skill for that turn. Multiple mentions mean use them all. Do not carry skills across turns unless re-mentioned.\n- Missing/blocked: If a named skill isn't in the list or the path can't be read, say so briefly and continue with the best fallback.\n- How to use a skill (progressive disclosure):\n 1) After deciding to use a skill, open its `SKILL.md`. Read only enough to follow the workflow.\n 2) When `SKILL.md` references relative paths (e.g., `scripts/foo.py`), resolve them relative to the skill directory listed above first, and only consider other paths if needed.\n 3) If `SKILL.md` points to extra folders such as `references/`, load only the specific files needed for the request; don't bulk-load everything.\n 4) If `scripts/` exist, prefer running or patching them instead of retyping large code blocks.\n 5) If `assets/` or templates exist, reuse them instead of recreating from scratch.\n- Coordination and sequencing:\n - If multiple skills apply, choose the minimal set that covers the request and state the order you'll use them.\n - Announce which skill(s) you're using and why (one short line). If you skip an obvious skill, say why.\n- Context hygiene:\n - Keep context small: summarize long sections instead of pasting them; only load extra files when needed.\n - Avoid deep reference-chasing: prefer opening only files directly linked from `SKILL.md` unless you're blocked.\n - When variants exist (frameworks, providers, domains), pick only the relevant reference file(s) and note that choice.\n- Safety and fallback: If a skill can't be applied cleanly (missing files, unclear instructions), state the issue, pick the next-best approach, and continue.\n","\nFilesystem sandboxing defines which files can be read or written. `sandbox_mode` is `danger-full-access`: No filesystem sandboxing - all commands are permitted. Network access is enabled.\nApproval policy is currently never. Do not provide the `sandbox_permissions` for any reason, commands will be rejected.\n","turn/started",{"_456":457,"_85":1059},{"_101":-5,"_41":463,"_464":1060,"_466":467,"_468":1061},[],"inProgress",{"_468":1063,"_456":457},{"_1064":1065,"_90":1066},"activeFlags",[],"active","thread/started",{"_1069":1070},"thread",{"_1071":-5,"_1072":-5,"_1073":1074,"_1075":467,"_518":519,"_1076":15,"_1077":-5,"_1078":-5,"_41":457,"_1079":1080,"_179":-5,"_159":1081,"_1082":197,"_523":1083,"_468":1084,"_75":1085,"_1086":467},"agentNickname","agentRole","cliVersion","0.124.0","createdAt","ephemeral","forkedFromId","gitInfo","modelProvider","openai","/opt/codex/sessions/2026/06/01/rollout-2026-06-01T10-15-16-019e82ae-39d4-7db2-906f-a82834142af9.jsonl","preview","vscode",{"_90":472},[],"updatedAt",[],"messages",[1090],{"_41":1091,"_1092":1093,"_1094":1095,"_1096":1095,"_478":1097,"_468":1098,"_480":-5,"_1099":31,"_1100":1101,"_1102":1103,"_1104":-5},"3005d51c-7ccc-4956-9423-d3faaf87c98b","author",{"_94":320,"_179":-5,"_1100":1113},"create_time",1780308915.804559,"update_time",{"_1109":45,"_1110":1111},"finished_successfully","weight","metadata",{"_1105":1106},"recipient","all","channel","l1239dk1",{"_1107":1108},"inline_comments",[],"content_type","parts",[1112],"## All 3 P1 data-integrity findings fixed (pushed in 5216898)\n\nThanks @codex — all three were real and confirmed in code; web editing was not safe to ship without them. Fixed each:\n\n### ✅ P1-A — WAL pages dropped on save\nsql.js opens only the main DB image and can't merge a separate `-wal`, so saving a WAL-mode database would overwrite the main file and drop committed WAL pages. **Fix:** when `walContent` is non-empty, the browser connection opens **read-only** (`readOnlyMode = forceReadOnly || hasActiveWal`) — viewable, not silently corruptible. Chose the conservative guard over attempting an unsafe in-memory merge.\n\n### ✅ P1-B — undo/redo/revert/hot-exit were no-ops\nThe in-process facade wired `applyModifications`/`undoModification`/`redoModification`/`flushChanges`/`discardModifications` as `async () => {}`. **Fix:** `createWorkerEndpoint()` now exposes these, and the facade delegates to the already-implemented `WasmDatabaseEngine` methods (no reimplementation).\n\n### ✅ P1-C — checkpoint raced an in-flight save\n`createCheckpoint()` ran after the async `writeFile`, marking clean any edit that arrived during the write. **Fix:** `ModificationTracker` gains `getCurrentPosition()` / `createCheckpointAt(pos)`; `save()` snapshots the position right after `serializeDatabase()` and commits only that snapshot after a successful write. The position is absolute (accounts for front-eviction during the write).\n\n### Tests + verification\n+3 tests, each **revert-proof-verified** (fails when its fix is undone): WAL-read-only, undo-delegation, save-race-stays-dirty. `tsc --noEmit` clean · `npm test` **341/341** · build worker-free, exports `activate`. Desktop path unchanged.\n\n⚠️ Still pending: a real edit→save→reload round-trip in published vscode.dev before this is called done.\nfeat(web): enable database editing in VS Code for Web (1.5.0)\n\n## Summary\n\nEnables **editing SQLite databases in VS Code for Web** (vscode.dev / github.dev). The web build was read-only since v1.0.0 — any edit reported \"Document is read-only\". That restriction was a conservative original choice from when the web engine path was unreliable; now that the in-process WASM engine works in the web extension host (1.3.9, verified), web editing is feasible.\n\n## Changes\n\n- **`editorController.ts`** — provider gate: drop the `!VSCODE_BROWSER_EXT` term from `enableReadWrite`, relying on `SupportsWriteMode` (now web-aware). The browser host gets the read-write `DatabaseEditorProvider` (whose `isReadOnly` is `false`), so `hostBridge.isReadOnly` no longer blocks edits. Desktop logic unchanged.\n- **`databaseModel.ts`** — `SupportsWriteMode = IsLocalMode || IsRemoteWorkspaceMode || IsBrowserExtensionHost`. `save()` persists web edits by `serializeDatabase()` → `workspace.fs.writeFile(uri, …)` (the WASM/non-`file://` branch, which github.dev supports).\n\n## Safety (the part that matters for data-writing)\n\n- `createCheckpoint()` (marks the undo tracker \"saved\") now runs **only after** a successful write, in every branch. Previously it ran *before* the write.\n- The web write is wrapped: a rejected write (e.g. read-only web FS provider) throws a clear **\"Failed to save database\"** and **leaves the modification tracker uncommitted** — so edits are preserved for retry/backup instead of being silently marked saved and lost.\n\n## Tests (+4, 338/338)\n\n- Browser-mode selects the read-write provider.\n- `SupportsWriteMode` allows the browser host.\n- `save()` serializes + `writeFile`s for a non-`file://` uri.\n- **`save: keeps failed non-file WASM writes uncommitted for backup and retry`** — the data-loss safeguard; **revert-proof-verified** (fails if the checkpoint reorder is undone).\n\n## ⚠️ Not yet verified end-to-end in real vscode.dev\n\nUnit tests prove the mechanism (provider selection, serialize+writeFile, failure-preservation), but **not** that a real edit round-trips on github.dev's filesystem. That requires publishing. Plan: publish 1.5.0, edit a cell in vscode.dev, save, reload, confirm the change persisted — before calling this done.\n\nBuild OK (`extension-browser.js` exports `activate`, worker-free) · `tsc --noEmit` clean · `npm test` 338/338.\n[vc]: #6znyuZUdZpalJH5WN1Dkhh2XkpVLuLHFAamVfeozS7c=:eyJpc01vbm9yZXBvIjp0cnVlLCJ0eXBlIjoiZ2l0aHViIiwicHJvamVjdHMiOlt7Im5hbWUiOiJzcS1saXRlLWV4cGxvcmVyIiwicHJvamVjdElkIjoicHJqX2VGbk8xeUFJaVFkMG4xVjI2Q0lwbkU3RWJiZXciLCJpbnNwZWN0b3JVcmwiOiJodHRwczovL3ZlcmNlbC5jb20vemtucHJzLXByb2plY3RzLWZkMDdiZmU0L3NxLWxpdGUtZXhwbG9yZXIvRG1IZ1Nxc2ZlZXd4NjkycmtIVDZuVjNrbWczVSIsInByZXZpZXdVcmwiOiJzcS1saXRlLWV4cGxvcmVyLWdpdC1mZWF0LXdlYi1lLTQ2NmJkMy16a25wcnMtcHJvamVjdHMtZmQwN2JmZTQudmVyY2VsLmFwcCIsIm5leHRDb21taXRTdGF0dXMiOiJQRU5ESU5HIiwibGl2ZUZlZWRiYWNrIjp7InJlc29sdmVkIjowLCJ1bnJlc29sdmVkIjowLCJ0b3RhbCI6MCwibGluayI6InNxLWxpdGUtZXhwbG9yZXItZ2l0LWZlYXQtd2ViLWUtNDY2YmQzLXprbnBycy1wcm9qZWN0cy1mZDA3YmZlNC52ZXJjZWwuYXBwIn0sInJvb3REaXJlY3RvcnkiOiJ3ZWJzaXRlIn1dfQ==\nThe latest updates on your projects. Learn more about [Vercel for GitHub](https://vercel.link/github-learn-more).\n\n| Project | Deployment | Actions | Updated (UTC) |\n| :--- | :----- | :------ | :------ |\n| [sq-lite-explorer](https://vercel.com/zknprs-projects-fd07bfe4/sq-lite-explorer) | ![Building](https://vercel.com/static/status/building.svg) [Building](https://vercel.com/zknprs-projects-fd07bfe4/sq-lite-explorer/DmHgSqsfeewx692rkHT6nV3kmg3U) | [Preview](https://sq-lite-explorer-git-feat-web-e-466bd3-zknprs-projects-fd07bfe4.vercel.app), [Comment](https://vercel.live/open-feedback/sq-lite-explorer-git-feat-web-e-466bd3-zknprs-projects-fd07bfe4.vercel.app?via=pr-comment-feedback-link) | Jun 1, 2026 10:14am |\n\n\n\n\n\n> [!NOTE]\n> Currently processing new changes in this PR. This may take a few minutes, please wait...\n> \n>

\n>

⚙️ Run configuration

\n> \n> **Configuration used**: Organization UI\n> \n> **Review profile**: ASSERTIVE\n> \n> **Plan**: Pro\n> \n> **Run ID**: `b3ec4376-a595-45ec-9e8d-6f3ac3d44ca0`\n> \n>

\n> \n>

\n>

📥 Commits

\n> \n> Reviewing files that changed from the base of the PR and between 5cc15a168cedb86bbb9a361bf1b3e37ffef470bc and 52168984fe3fa3ddb963587bbaeffbccf3d04939.\n> \n>

\n> \n>

\n>

📒 Files selected for processing (10)

\n> \n> * `CHANGELOG.md`\n> * `package.json`\n> * `src/core/sqlite-db.ts`\n> * `src/core/undo-history.ts`\n> * `src/databaseModel.ts`\n> * `src/editorController.ts`\n> * `src/workerFactory.ts`\n> * `tests/unit/databaseModel.test.ts`\n> * `tests/unit/editorController.test.ts`\n> * `tests/unit/workerFactory_browser.test.ts`\n> \n>

\n> \n> ```ascii\n> _________________________________________________\n> < SNAFU: Situation Normal, All Faults Understood. >\n> -------------------------------------------------\n> \\\n> \\ \\\n> \\ /\\\n> ( )\n> .( o ).\n> ```\n\n\n\n\n\n

✨ Finishing Touches

\n\n

📝 Generate docstrings

\n\n- [ ] Create stacked PR\n- [ ] Commit on current branch\n\n

🧪 Generate unit tests (beta)

\n\n- [ ] Create PR with unit tests\n- [ ] Commit unit tests in branch `feat/web-edit-support`\n\n

\n\n

\n\n\n\n\n---\n\nThanks for using [CodeRabbit](https://coderabbit.ai?utm_source=oss&utm_medium=github&utm_campaign=zknpr/SQLite-Explorer&utm_content=424)! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.\n\n

❤️ Share

\n\n- [X](https://twitter.com/intent/tweet?text=I%20just%20used%20%40coderabbitai%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20the%20proprietary%20code.%20Check%20it%20out%3A&url=https%3A//coderabbit.ai)\n- [Mastodon](https://mastodon.social/share?text=I%20just%20used%20%40coderabbitai%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20the%20proprietary%20code.%20Check%20it%20out%3A%20https%3A%2F%2Fcoderabbit.ai)\n- [Reddit](https://www.reddit.com/submit?title=Great%20tool%20for%20code%20review%20-%20CodeRabbit&text=I%20just%20used%20CodeRabbit%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20proprietary%20code.%20Check%20it%20out%3A%20https%3A//coderabbit.ai)\n- [LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fcoderabbit.ai&mini=true&title=Great%20tool%20for%20code%20review%20-%20CodeRabbit&summary=I%20just%20used%20CodeRabbit%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20proprietary%20code)\n\n

\n\n\n_{Comment `@coderabbitai help` to get the list of available commands and usage tips.}\n\n\n## Code Review\n\nThis pull request enables database editing in VS Code for Web (vscode.dev / github.dev) by allowing write mode in the browser extension host and preventing silent data loss on save failures. It updates `SupportsWriteMode` to include the browser extension host, ensures the modification tracker checkpoint is only created after successful persistence, and adds comprehensive unit tests to verify these behaviors. There are no review comments, so no feedback is provided.\n**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Preserve WAL contents when saving web databases**\n\nWhen a database opened from github.dev has a companion `-wal` file, `loadDatabaseFiles()` reads that WAL, but the WASM engine initialization never applies `walContent`; after this change the browser provider is writable and this line overwrites only the main database URI with the serialized in-memory DB. In that scenario, committed pages that existed only in the WAL are dropped (and the stale `-wal` may still remain), so saving an edited WAL-mode repository database can lose or corrupt existing data. Please checkpoint/merge the WAL or reject WAL-backed files before enabling write/save.\n\nUseful? React with 👍 / 👎.\n**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Implement WASM replay before enabling web writes**\n\nWith browser write mode enabled here, every web edit uses the in-process WASM facade, but that facade currently wires `applyModifications`, `undoModification`, `redoModification`, and `discardModifications` as no-ops in `createInProcessWasmDatabaseConnection`. In vscode.dev this means Undo/Revert and hot-exit backup restore can mark the custom document state as handled while leaving the in-memory database unchanged, so users can save edits they thought were undone or lose recovered unsaved changes. Please either implement those modification operations for the browser WASM path or keep the web provider read-only until they work.\n\nUseful? React with 👍 / 👎.\n**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Avoid checkpointing edits made during an in-flight save**\n\nBecause the checkpoint is now created after the async filesystem write, any edit that arrives after `serializeDatabase()` has produced `binaryContent` but before `writeFile()` resolves is included in `timeline.length` and marked clean here even though those bytes were not part of the file that was just saved. This is especially plausible on slow web filesystem writes or with multiple editor panes, and it can silently drop the later edit on close/reload; snapshot the checkpoint position at serialization time (and only commit that snapshot after success) or block edits while saving.\n\nUseful? React with 👍 / 👎.\n\n### 💡 Codex Review\n\nHere are some automated review suggestions for this pull request.\n\n**Reviewed commit:** `a1cde57272`\n \n\n

ℹ️ About Codex in GitHub

\n
\n\n[Your team has set up Codex to review pull requests in this repo](https://chatgpt.com/codex/cloud/settings/general). Reviews are triggered when you\n- Open a pull request for review\n- Mark a draft as ready\n- Comment \"@codex review\".\n\nIf Codex has suggestions, it will comment; otherwise it will react with 👍.\n\n\n\n\nCodex can also answer questions or update the PR. Try commenting \"@codex address that feedback\".\n \n

",{},"created",1780309097.7331583,"Completing the task","event_type","info",{"_90":483,"_94":91,"_478":2805},{"_90":1121,"_1122":1123},"partial_repo_snapshot","files",[1124,1125,1126,1127,1128,1129],{"_159":2436,"_1131":-5,"_1132":2437,"_1134":-5},{"_159":2259,"_1131":-5,"_1132":2260,"_1134":-5},{"_159":1942,"_1131":-5,"_1132":1943,"_1134":-5},{"_159":1704,"_1131":-5,"_1132":1705,"_1134":-5},{"_159":1534,"_1131":-5,"_1132":1535,"_1134":-5},{"_159":1130,"_1131":-5,"_1132":1133,"_1134":-5},"tests/unit/databaseModel.test.ts","contents","line_range_contents",[1135],"missing_reason",{"_1136":1014,"_1137":1138,"_478":1139,"_1140":57},"line_range_start","line_range_end",725,[1141,1142,1143,1144,1145,1146,1147,1148,1149,197,1150,1151,197,1152,1153,1154,1155,1156,1157,1158,1159,197,1160,1161,1162,1163,197,1164,1165,1166,1167,1168,1158,1169,1170,1158,1171,1172,197,1173,1174,1175,1176,1177,1178,197,1179,1180,197,1181,1182,1183,1184,1185,1186,197,1187,1188,1189,1190,1191,197,1192,1193,1194,1195,1196,1197,1198,1194,1195,1196,1199,1200,1194,1195,1196,197,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1207,1208,1209,1212,1213,1207,1208,1209,1158,1214,1215,197,1216,1217,1218,1219,1220,197,1221,1222,1223,1224,197,1225,1226,1227,1228,1196,197,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1214,197,1240,1241,1242,1243,1158,1244,1214,197,1245,1246,1226,1227,1228,1196,1214,197,1247,1248,1249,1250,1251,1252,1253,1254,197,1255,1256,1257,1258,1259,1238,1239,197,1260,1261,1158,197,1262,1263,1264,1265,1266,1238,1196,197,1267,1268,1269,1172,197,1270,1271,1272,1214,197,1273,1274,1275,1214,197,1276,1277,1278,1214,197,1279,1280,1281,1282,1283,1214,197,1284,1285,1286,1287,1214,1215,197,197,197,197,1288,1289,197,1245,1290,1230,1291,1292,1293,1238,1196,197,1231,1232,1233,1234,1235,1236,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1238,1239,197,1308,1309,1214,197,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1239,1321,1172,197,1322,1323,1324,1313,1314,1315,1316,1325,1326,1320,1239,1172,197,1327,1328,1329,1330,1331,1332,1333,1239,197,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1172,197,1344,1345,1346,1347,1348,1349,1350,1351,1238,1239,197,1352,197,1353,197,1354,1355,197,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1362,1366,1367,197,1368,1369,1370,1371,1372,1373,1374,1238,1239,197,1201,1375,197,1376,1377,1378,1379,1204,1380,1381,1158,1214,197,1382,1345,1346,1347,1348,1349,1350,1351,1238,1239,197,1352,197,1355,197,1356,1357,1358,1359,1383,1362,1363,1364,1365,1362,1366,1367,197,1368,1369,1370,1371,1372,1373,1374,1238,1239,197,1201,1384,197,1376,1378,1379,1204,1380,1381,1158,1214,197,1385,1386,1387,1355,197,1346,1347,1388,1389,1390,1391,1238,1239,197,1392,197,1356,1357,1358,1363,1364,1393,1394,1362,1366,1367,197,1201,1384,197,1395,1379,1204,1380,1158,1214,197,1396,1386,1397,197,1346,1347,1398,1239,197,1392,1399,1400,1401,1402,1403,1404,1405,1406,1407,1196,197,1356,1357,1358,1363,1408,1409,1410,1411,1362,1366,1367,197,1201,1412,1413,1414,1415,197,1416,197,1417,1418,1419,1420,1421,1204,1380,1158,1214,197,1422,1386,1423,1424,1425,1426,1196,1427,1428,1196,197,1429,1430,1431,1432,1403,1404,1405,1433,1434,1239,1435,1436,1437,1432,1403,1438,1405,1439,1440,1239,1441,197,1346,1347,1442,1443,1444,1238,1239,197,1392,1445,197,1356,1357,1358,1363,1393,1446,1447,1448,1362,1366,1367,197,1201,1449,1450,197,1451,1452,1453,197,1454,197,1455,1204,1380,1158,1214,1215,197,197,1456,1457,1458,1459,1460,197,1245,1461,1462,197,1463,1464,1465,1466,1209,1467,1239,197,1468,1469,1330,1470,1471,1239,197,1472,1473,1239,197,1230,1231,1232,1233,1234,1235,1236,1474,1475,1476,1477,1478,1301,1479,1296,1480,1481,1482,1483,1484,1485,1486,1410,1238,1239,197,1214,197,1487,1488,1489,1214,197,1490,1491,1492,1493,1494,1238,1239,197,1495,1496,1497,197,1498,1499,197,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1410,1510,1158,197,1511,1512,1513,1196,197,1399,1514,1515,1516,1517,1196,197,1518,197,1519,197,1520,1214,197,1521,1491,1492,1522,1494,1238,1239,197,1497,1498,1499,197,1523,1501,1502,1524,1504,1525,1507,1526,1527,1410,1510,1158,197,1528,1511,1512,1513,1529,1196,197,1399,1514,1515,1516,1517,1196,197,1530,197,1531,1532,197,1533,1214,1215],"contains_end_of_file","import './vscode_mock_setup';","import { describe, it, before, after, beforeEach, afterEach } from 'node:test';","import assert from 'node:assert';","import path from 'node:path';","import fs from 'node:fs';","import Module from 'node:module';","import esbuild from 'esbuild';","import { mockVscode } from './mocks/vscode';","import { ModificationTracker } from '../../src/core/undo-history';","const databaseModelPath = path.resolve(__dirname, '../../src/databaseModel.ts');","const databaseModelSource = fs.readFileSync(databaseModelPath, 'utf8');","function loadBrowserDatabaseModel() {"," const jsCode = esbuild.transformSync(databaseModelSource, {"," loader: 'ts',"," format: 'cjs',"," define: {"," 'import.meta.env.VSCODE_BROWSER_EXT': 'true'"," }"," }).code;"," const scriptModule = new Module(databaseModelPath, module as unknown as Module);"," scriptModule.filename = databaseModelPath;"," scriptModule.paths = (Module as unknown as { _nodeModulePaths(dirname: string): string[] })"," ._nodeModulePaths(path.dirname(databaseModelPath));"," const originalRequire = Module.prototype.require;"," Module.prototype.require = function(request: string) {"," if (request === 'vscode') return mockVscode;"," if (request.endsWith('workerFactory')) {"," return { createDatabaseConnection: async () => ({}) };"," if (request.endsWith('main')) {"," return { GlobalOutputChannel: null };"," return originalRequire.call(this, request);"," };"," try {"," (scriptModule as unknown as { _compile(code: string, filename: string): void })"," ._compile(jsCode, databaseModelPath);"," } finally {"," Module.prototype.require = originalRequire;"," }"," return scriptModule.exports as typeof import('../../src/databaseModel');","}","// Setup environment definitions that match VS Code ExtensionKind","(mockVscode as any).ExtensionKind = { Workspace: 2, UI: 1 };","mockVscode.env.remoteName = 'remote';","(mockVscode as any).extensions = {"," getExtension: () => ({ extensionKind: 2 })","};","describe('SupportsWriteMode', () => {"," it('allows the browser extension host even when remoteName is set and the extension is UI-kind', () => {"," const originalRemoteName = mockVscode.env.remoteName;"," const originalExtensionKind = (mockVscode as any).ExtensionKind;"," const originalExtensions = (mockVscode as any).extensions;"," Object.defineProperty(mockVscode, 'ExtensionKind', {"," value: { Workspace: 2, UI: 1 },"," writable: true,"," configurable: true"," });"," Object.defineProperty(mockVscode.env, 'remoteName', {"," value: 'github',"," Object.defineProperty(mockVscode, 'extensions', {"," value: { getExtension: () => ({ extensionKind: 1 }) },"," try {"," const { SupportsWriteMode } = loadBrowserDatabaseModel();"," assert.strictEqual(SupportsWriteMode, true);"," } finally {"," Object.defineProperty(mockVscode, 'ExtensionKind', {"," value: originalExtensionKind,"," writable: true,"," configurable: true"," });"," Object.defineProperty(mockVscode.env, 'remoteName', {"," value: originalRemoteName,"," Object.defineProperty(mockVscode, 'extensions', {"," value: originalExtensions,"," });","});","describe('isAutoCommitEnabled', () => {"," let originalGetConfiguration: any;"," let configMap: Map;"," let originalGetExtension: any;"," let originalRemoteName: any;"," before(async () => {"," originalGetConfiguration = mockVscode.workspace.getConfiguration;"," originalGetExtension = (mockVscode as any).extensions?.getExtension;"," originalRemoteName = mockVscode.env.remoteName;"," configMap = new Map();"," mockVscode.workspace.getConfiguration = () => ({"," get: (key: string, defaultVal: any) => configMap.has(key) ? configMap.get(key) : defaultVal,"," update: () => Promise.resolve()"," // Mock workerFactory so it doesn't load threadPool and crash due to import.meta.env inside node test runner"," const moduleCache = require('module')._cache;"," const workerFactoryPath = require.resolve('../../src/workerFactory');"," moduleCache[workerFactoryPath] = {"," id: workerFactoryPath,"," filename: workerFactoryPath,"," loaded: true,"," exports: {"," createDatabaseConnection: () => {}"," }"," };"," after(() => {"," mockVscode.workspace.getConfiguration = originalGetConfiguration;"," if ((mockVscode as any).extensions) {"," (mockVscode as any).extensions.getExtension = originalGetExtension;"," mockVscode.env.remoteName = originalRemoteName;"," beforeEach(() => {"," configMap.clear();"," const setupEnvironmentAndTest = async ("," configValue: string | undefined,"," remoteName: string | undefined,"," extensionKind: number | undefined,"," expected: boolean"," ) => {"," // Mock environment BEFORE loading module, so IsRemoteWorkspaceMode is calculated correctly"," mockVscode.env.remoteName = remoteName as string;"," // Ensure getExtension always returns what we specify"," (mockVscode as any).extensions = {"," getExtension: () => {"," // Return an object that has extensionKind property"," return extensionKind !== undefined ? { extensionKind } : undefined;"," if (configValue !== undefined) {"," configMap.set('instantCommit', configValue);"," // Clear module cache for databaseModel.ts and any other src modules (excluding mocks)"," // to re-evaluate the IsRemoteWorkspaceMode constant"," Object.keys(require('module')._cache).forEach(key => {"," if (key.includes('src/') && !key.includes('workerFactory')) {"," delete require('module')._cache[key];"," // Force a re-require of databaseModel"," const { isAutoCommitEnabled } = require('../../src/databaseModel');"," assert.strictEqual(isAutoCommitEnabled(), expected);"," it('should be true if instantCommit is always, regardless of environment', async () => {"," await setupEnvironmentAndTest('always', undefined, undefined, true);"," await setupEnvironmentAndTest('always', 'ssh-remote', 2 /* Workspace */, true);"," it('should be false if instantCommit is never, regardless of environment', async () => {"," await setupEnvironmentAndTest('never', undefined, undefined, false);"," await setupEnvironmentAndTest('never', 'ssh-remote', 2 /* Workspace */, false);"," it('should be true if instantCommit is remote-only and IsRemoteWorkspaceMode is true', async () => {"," // IsRemoteWorkspaceMode requires both remoteName and ExtensionKind.Workspace"," await setupEnvironmentAndTest('remote-only', 'ssh-remote', 2 /* Workspace */, true);"," it('should be false if instantCommit is remote-only and IsRemoteWorkspaceMode is false', async () => {"," // Not remote (no remoteName)"," await setupEnvironmentAndTest('remote-only', undefined, 2 /* Workspace */, false);"," // Remote but extension is not Workspace kind (e.g., UI kind)"," await setupEnvironmentAndTest('remote-only', 'ssh-remote', 1 /* UI */, false);"," it('should be false by default if instantCommit is not set (defaults to never)', async () => {"," // Set configMap to return undefined for 'instantCommit' (by omitting it from configMap)"," // IsRemoteWorkspaceMode is true, but config defaults to 'never'"," await setupEnvironmentAndTest(undefined, 'ssh-remote', 2 /* Workspace */, false);","describe('DatabaseDocument save/saveAs fallback', () => {"," let DatabaseDocument: any;"," // Clear module cache to ensure we get a fresh instance that uses our mocked workerFactory"," Object.keys(moduleCache).forEach(key => {"," if (key.includes('src/') && !key.includes('workerFactory') && !key.includes('mocks')) {"," delete moduleCache[key];"," createDatabaseConnection: async () => ({"," establishConnection: async () => ({"," databaseOps: {"," engineKind: Promise.resolve('wasm'),"," writeToFile: async () => { throw new Error('Simulated write failure'); },"," serializeDatabase: async () => new Uint8Array([1, 2, 3]),"," applyModifications: async () => {}"," },"," isReadOnly: false"," }),"," workerMethods: {"," [Symbol.dispose]: () => {}"," }"," })"," const dbModel = require('../../src/databaseModel');"," DatabaseDocument = dbModel.DatabaseDocument;"," const createUri = (scheme: string, path: string) => {"," const uri = {"," scheme,"," authority: '',"," path: path,"," query: '',"," fragment: '',"," fsPath: scheme === 'file' ? path : '',"," with: (changes: { path?: string }) => createUri(scheme, changes.path ?? path),"," toString: () => `${scheme}://${path}`,"," toJSON: () => ({})"," return uri;"," const createFileUri = (path: string) => {"," return {"," scheme: 'file',"," fsPath: path,"," with: () => ({}),"," const createDocBypassingFactory = (dbOps: any, uri: any = createFileUri('/test/db.sqlite')) => {"," const mockViewerProvider = {"," reporter: {},"," isVerified: true,"," context: { extensionUri: createFileUri('/ext') },"," forceReadOnly: false,"," outputChannel: undefined"," return new (DatabaseDocument as any)("," mockViewerProvider,"," uri,"," null, // tracker"," false, // autoCommitEnabled"," { databaseOps: dbOps, isReadOnly: false },"," { [Symbol.dispose]: () => {} }, // workerMethods"," async () => {}, // establishConnection"," {} // reporter"," );"," it('saveAs: falls back to buffer transfer when writeToFile fails for file URI', async () => {"," let serialized = false;"," const dbOps = {"," engineKind: Promise.resolve('wasm'),"," writeToFile: async () => { throw new Error('Simulated write failure'); },"," serializeDatabase: async () => {"," serialized = true;"," return new Uint8Array([1, 2, 3]);"," const doc = createDocBypassingFactory(dbOps);"," const targetUri = createFileUri('/test/target.sqlite');"," let statCalled = false;"," let writeFileCalled = false;"," const originalFs = mockVscode.workspace.fs;"," mockVscode.workspace.fs = {"," ...originalFs,"," stat: async () => {"," statCalled = true;"," return { size: 100 }; // Less than getFileSizeLimit()"," },"," writeFile: async (uri: any, content: any) => {"," writeFileCalled = true;"," assert.deepStrictEqual(content, new Uint8Array([1, 2, 3]));"," readFile: async () => new Uint8Array([])"," } as any;"," const originalConsoleWarn = console.warn;"," let consoleWarnCalled = false;"," console.warn = (msg: string, err: any) => {"," if (msg && msg.includes('Direct write failed')) {"," consoleWarnCalled = true;"," } else {"," originalConsoleWarn(msg, err);"," await doc.saveAs(targetUri, undefined);"," assert.strictEqual(consoleWarnCalled, true, 'console.warn should be called');"," assert.strictEqual(statCalled, true, 'fs.stat should be called');"," assert.strictEqual(serialized, true, 'serializeDatabase should be called');"," assert.strictEqual(writeFileCalled, true, 'fs.writeFile should be called');"," mockVscode.workspace.fs = originalFs;"," console.warn = originalConsoleWarn;"," it('save: falls back to buffer transfer when writeToFile fails for file URI', async () => {"," return { size: 100 };"," await doc.save();"," it('save: serializes and writes WASM database content for non-file URI', async () => {"," const sourceUri = createUri('vscode-vfs', '/github/user/repo/test.db');"," let serializedName: string | undefined;"," writeToFile: async () => { throw new Error('writeToFile should not be called for non-file URIs'); },"," serializeDatabase: async (name: string) => {"," serializedName = name;"," return new Uint8Array([4, 5, 6]);"," const doc = createDocBypassingFactory(dbOps, sourceUri);"," assert.strictEqual(uri, sourceUri);"," assert.deepStrictEqual(content, new Uint8Array([4, 5, 6]));"," assert.strictEqual(serializedName, 'test.db');"," it('save: keeps failed non-file WASM writes uncommitted for backup and retry', async () => {"," let backupContent: Uint8Array | undefined;"," serializeDatabase: async () => new Uint8Array([7, 8, 9])"," doc.recordModification({"," label: 'Update Cell',"," description: 'Update items.name',"," modificationType: 'cell_update',"," targetTable: 'items',"," targetRowId: 1,"," targetColumn: 'name',"," newValue: 'after',"," priorValue: 'before'"," if (uri.toString() === sourceUri.toString()) {"," throw new Error('NoPermissions: read-only filesystem');"," }"," backupContent = content;"," await assert.rejects("," () => doc.save(),"," /NoPermissions: read-only filesystem/"," );"," await doc.backup(createUri('vscode-userdata', '/backups/test.db'), undefined);"," assert.ok(backupContent, 'backup should be written after failed save');"," const restored = ModificationTracker.deserialize(backupContent);"," const uncommitted = restored.getUncommittedEntries();"," assert.strictEqual(uncommitted.length, 1);"," assert.strictEqual(uncommitted[0].label, 'Update Cell');"," it('save: does not checkpoint edits recorded while writeFile is still pending', async () => {"," let resolveWrite: () => void = () => {};"," let markWriteStarted: () => void = () => {};"," const writeMayFinish = new Promise(resolve => {"," resolveWrite = resolve;"," const writeStarted = new Promise(resolve => {"," markWriteStarted = resolve;"," const firstModification = {"," label: 'First Update',"," description: 'Update first item',"," modificationType: 'cell_update' as const,"," priorValue: 'before',"," newValue: 'after'"," const concurrentModification = {"," label: 'Concurrent Update',"," description: 'Update concurrent item',"," targetRowId: 2,"," priorValue: 'old',"," newValue: 'new'"," let discardedModifications: unknown[] | undefined;"," serializeDatabase: async () => new Uint8Array([7, 8, 9]),"," discardModifications: async (mods: unknown[]) => {"," discardedModifications = mods;"," doc.recordModification(firstModification);"," assert.deepStrictEqual(content, new Uint8Array([7, 8, 9]));"," markWriteStarted();"," await writeMayFinish;"," const savePromise = doc.save();"," await writeStarted;"," doc.recordModification(concurrentModification);"," resolveWrite();"," await savePromise;"," await doc.revert(undefined);"," assert.deepStrictEqual(discardedModifications, [concurrentModification]);","describe('DatabaseDocument undo/redo error handling', () => {"," let mockViewerProvider: any;"," let mockOpenContext: any;"," let originalShowErrorMessage: any;"," let originalL10n: any;"," originalShowErrorMessage = mockVscode.window.showErrorMessage;"," originalL10n = mockVscode.l10n.t;"," mockVscode.l10n.t = (key: string, ...args: any[]) => {"," let res = key;"," args.forEach((arg, i) => {"," res = res.replace(`{${i}}`, String(arg));"," return res;"," mockViewerProvider = {"," reporter: undefined,"," context: { extensionUri: mockVscode.Uri.parse('file:///ext') },"," forceReadOnly: false"," mockOpenContext = {"," backupId: undefined"," createDatabaseConnection: () => {"," return Promise.resolve({"," workerMethods: {"," open: () => Promise.resolve({ isReadOnly: false, bufferInfo: {} }),"," exec: () => Promise.resolve(),"," establishConnection: () => Promise.resolve({ isReadOnly: false }),"," undoModification: () => Promise.resolve(),"," redoModification: () => Promise.resolve(),"," close: () => Promise.resolve(),"," getSchema: () => Promise.resolve([]),"," query: () => Promise.resolve([])"," }"," });"," afterEach(() => {"," mockVscode.window.showErrorMessage = originalShowErrorMessage;"," mockVscode.l10n.t = originalL10n;"," it('should show error message when undoModification fails', async () => {"," let errorMessageShown = false;"," mockVscode.window.showErrorMessage = async (msg?: string) => {"," if (msg?.includes('Test Undo Error')) {"," errorMessageShown = true;"," // We clear module cache of databaseModel so it uses the mocked workerFactory"," delete require('module')._cache[require.resolve('../../src/databaseModel')];"," const { DatabaseDocument } = require('../../src/databaseModel');"," const uri = mockVscode.Uri.parse('file:///test.db');"," const doc = await DatabaseDocument.create(mockViewerProvider, uri, mockOpenContext);"," // Mock database operations to throw error on undo"," const dbOps = doc.databaseOperations;"," if(dbOps) {"," dbOps.undoModification = () => Promise.reject(new Error(\"Test Undo Error\"));"," } else {"," // force override via any"," (doc as any).connectionState = {"," databaseOps: {"," undoModification: () => Promise.reject(new Error(\"Test Undo Error\")),"," redoModification: () => Promise.resolve()"," };"," let undoAction: (() => Promise) | undefined;"," doc.onDidChange((modification: any) => {"," undoAction = modification.undo;"," label: 'Test Mod',"," action: 'Test Mod Action',"," sql: [],"," inverseSql: []"," assert.ok(undoAction, 'Undo action should be emitted');"," await undoAction();"," assert.strictEqual(errorMessageShown, true, 'Error message should be shown for failed undo');"," it('should show error message when redoModification fails', async () => {"," if (msg?.includes('Test Redo Error')) {"," // Mock database operations to throw error on redo"," dbOps.redoModification = () => Promise.reject(new Error(\"Test Redo Error\"));"," (doc as any).connectionState = {"," undoModification: () => Promise.resolve(),"," redoModification: () => Promise.reject(new Error(\"Test Redo Error\"))"," let redoAction: (() => Promise) | undefined;"," redoAction = modification.redo;"," assert.ok(redoAction, 'Redo action should be emitted');"," await undoAction!();"," await redoAction();"," assert.strictEqual(errorMessageShown, true, 'Error message should be shown for failed redo');","tests/unit/workerFactory_browser.test.ts",[1536],{"_1136":1014,"_1137":1537,"_478":1538,"_1140":57},304,[1141,197,1539,1143,1144,1145,1146,1147,1148,1540,197,1541,1542,197,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1180,197,1556,1557,1558,1559,1560,1561,1178,1562,197,1563,1564,1565,1566,197,1567,1568,1569,1570,1571,1572,1573,1178,1574,1571,1575,1576,1577,1578,1579,1158,1573,1178,1580,1571,1581,1582,1583,1584,1158,1573,1178,1585,1571,1586,1587,1573,1178,1588,1589,1178,1590,1591,197,1592,1593,1594,1595,1596,1597,197,1598,1599,1591,1180,197,1600,1601,1602,1603,197,1604,1605,1606,1607,1608,1609,1610,1584,1611,1612,1584,1613,1158,1614,1615,1616,1214,1617,197,1618,1619,1620,1621,1622,197,1623,1624,1625,1626,1614,1627,1628,1629,1630,1614,1631,1632,1633,1614,1634,1635,1614,1636,1172,197,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,197,1649,1650,197,1651,1652,1653,1654,197,1655,1656,1657,1658,197,1659,1660,1661,1617,197,1662,1602,1663,1603,1619,197,1604,1605,1606,1607,1608,1609,1664,1584,1611,1612,1584,1613,1158,1614,1615,1616,1214,197,1623,1624,1625,1665,1614,1627,1628,1666,1667,1668,1636,1172,197,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,197,1649,1650,197,1669,1670,1671,1617,197,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1172,1683,197,1623,1684,1627,1628,1685,1686,1687,1688,1614,1689,1690,1691,1614,1692,1690,1693,1614,1694,1687,1695,1614,1696,1686,1687,1697,1614,1666,1667,1668,1636,1172,197,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,197,1649,1650,197,1698,1699,1700,1701,1702,197,1703,1617,1215],"import { describe, it, beforeEach } from 'node:test';","import type { CellUpdate, CellValue, DatabaseInitConfig, ModificationEntry } from '../../src/core/types';","const workerFactoryPath = path.resolve(__dirname, '../../src/workerFactory.ts');","const workerFactorySource = fs.readFileSync(workerFactoryPath, 'utf8');","interface FakeEndpoint {"," initializeDatabase(filename: string, config: DatabaseInitConfig): Promise<{ isReadOnly: boolean }>;"," runQuery(sql: string, params?: CellValue[]): Promise;"," exportDatabase(name: string): Promise;"," applyModifications?(mods: ModificationEntry[], signal?: AbortSignal): Promise;"," undoModification?(mod: ModificationEntry): Promise;"," redoModification?(mod: ModificationEntry): Promise;"," flushChanges?(signal?: AbortSignal): Promise;"," discardModifications?(mods: ModificationEntry[], signal?: AbortSignal): Promise;"," updateCell(table: string, rowId: string | number, column: string, value: CellValue): Promise;"," insertRow(table: string, data: Record): Promise;"," updateCellBatch(table: string, updates: CellUpdate[]): Promise;"," ping(): Promise;","function loadBrowserWorkerFactory(endpoint: FakeEndpoint) {"," const jsCode = esbuild.transformSync(workerFactorySource, {"," loader: 'ts',"," format: 'cjs',"," define: {"," 'import.meta.env.VSCODE_BROWSER_EXT': 'true'"," }).code;"," const scriptModule = new Module(workerFactoryPath, module as unknown as Module);"," scriptModule.filename = workerFactoryPath;"," scriptModule.paths = (Module as unknown as { _nodeModulePaths(dirname: string): string[] })"," ._nodeModulePaths(path.dirname(workerFactoryPath));"," const originalRequire = Module.prototype.require;"," Module.prototype.require = function(request: string) {"," if (request === 'vscode') return mockVscode;"," if (request.endsWith('core/sqlite-db')) {"," return {"," createWorkerEndpoint: () => endpoint"," };"," if (request.endsWith('core/rpc')) {"," connectWorkerPort: () => {"," throw new Error('Browser mode must not create an RPC worker proxy');"," },"," Transfer: class Transfer {"," constructor(public readonly value: T, public readonly transferables: Transferable[]) {}"," if (request.endsWith('platform/threadPool')) {"," Worker: class Worker {"," constructor() {"," throw new Error('Browser mode must not construct a worker');"," }"," if (request.endsWith('config')) {"," getMaximumFileSizeBytes: () => 0,"," getQueryTimeout: () => 5000"," if (request.endsWith('main')) {"," return { GlobalOutputChannel: null };"," return originalRequire.call(this, request);"," };"," try {"," (scriptModule as unknown as { _compile(code: string, filename: string): void })"," ._compile(jsCode, workerFactoryPath);"," } finally {"," Module.prototype.require = originalRequire;"," }"," return scriptModule.exports as {"," createDatabaseConnection: typeof import('../../src/workerFactory').createDatabaseConnection;","describe('workerFactory browser WASM connection', () => {"," beforeEach(() => {"," const dbContent = new Uint8Array([1, 2, 3]);"," const wasmContent = new Uint8Array([4, 5, 6]);"," Object.defineProperty(mockVscode.workspace, 'fs', {"," value: {"," stat: async () => ({ size: dbContent.byteLength }),"," readFile: async (uri: { path?: string; fsPath?: string }) => {"," const pathValue = uri.path ?? uri.fsPath ?? '';"," if (pathValue.endsWith('-wal')) {"," throw new Error('No WAL file');"," if (pathValue.endsWith('sqlite3.wasm')) {"," return wasmContent;"," return dbContent;"," },"," writable: true,"," configurable: true"," });"," it('uses an in-process endpoint and passes raw Uint8Array values directly', async () => {"," let initConfig: DatabaseInitConfig | undefined;"," let updateCellValue: CellValue | undefined;"," let insertRowValue: CellValue | undefined;"," let updateBatchValue: CellValue | undefined;"," const endpoint: FakeEndpoint = {"," initializeDatabase: async (_filename, config) => {"," initConfig = config;"," return { isReadOnly: false };"," runQuery: async () => [],"," exportDatabase: async () => new Uint8Array(),"," updateCell: async (_table, _rowId, _column, value) => {"," updateCellValue = value;"," insertRow: async (_table, data) => {"," insertRowValue = data.blob;"," return 1;"," updateCellBatch: async (_table, updates) => {"," updateBatchValue = updates[0].value;"," ping: async () => true"," const workerFactory = loadBrowserWorkerFactory(endpoint);"," const extensionUri = { scheme: 'vscode-vfs', fsPath: '/ext', path: '/ext' } as any;"," const fileUri = {"," scheme: 'vscode-vfs',"," fsPath: '/workspace/test.db',"," path: '/workspace/test.db',"," with: ({ path: nextPath }: { path: string }) => ({"," scheme: 'vscode-vfs',"," fsPath: nextPath,"," path: nextPath"," })"," } as any;"," const bundle = await workerFactory.createDatabaseConnection(extensionUri, null as any);"," const connection = await bundle.establishConnection(fileUri, 'test.db');"," assert.strictEqual(initConfig?.content?.byteLength, 3);"," assert.strictEqual(initConfig?.walContent, null);"," assert.strictEqual(initConfig?.wasmBinary?.byteLength, 3);"," assert.strictEqual(connection.isReadOnly, false);"," const blobValue = new Uint8Array([9, 8, 7]);"," await connection.databaseOps.updateCell('items', 1, 'blob', blobValue);"," await connection.databaseOps.insertRow('items', { blob: blobValue });"," await connection.databaseOps.updateCellBatch('items', [{ rowId: 1, column: 'blob', value: blobValue }]);"," assert.strictEqual(updateCellValue, blobValue);"," assert.strictEqual(insertRowValue, blobValue);"," assert.strictEqual(updateBatchValue, blobValue);"," it('opens browser WAL databases read-only instead of silently writing without WAL pages', async () => {"," const walContent = new Uint8Array([9, 9, 9]);"," return walContent;"," return { isReadOnly: config.readOnlyMode ?? false };"," updateCell: async () => {},"," insertRow: async () => 1,"," updateCellBatch: async () => {},"," assert.strictEqual(initConfig?.walContent, walContent);"," assert.strictEqual(initConfig?.readOnlyMode, true);"," assert.strictEqual(connection.isReadOnly, true);"," it('delegates in-process modification operations through the endpoint', async () => {"," const calls: string[] = [];"," const mod = {"," label: 'Update',"," description: 'Update item',"," modificationType: 'cell_update' as const,"," targetTable: 'items',"," targetRowId: 1,"," targetColumn: 'name',"," priorValue: 'before',"," newValue: 'after'"," const abortController = new AbortController();"," initializeDatabase: async () => ({ isReadOnly: false }),"," applyModifications: async (mods, signal) => {"," assert.deepStrictEqual(mods, [mod]);"," assert.strictEqual(signal, abortController.signal);"," calls.push('apply');"," undoModification: async (entry) => {"," assert.strictEqual(entry, mod);"," calls.push('undo');"," redoModification: async (entry) => {"," calls.push('redo');"," flushChanges: async (signal) => {"," calls.push('flush');"," discardModifications: async (mods, signal) => {"," calls.push('discard');"," await connection.databaseOps.applyModifications([mod], abortController.signal);"," await connection.databaseOps.undoModification(mod);"," await connection.databaseOps.redoModification(mod);"," await connection.databaseOps.flushChanges(abortController.signal);"," await connection.databaseOps.discardModifications([mod], abortController.signal);"," assert.deepStrictEqual(calls, ['apply', 'undo', 'redo', 'flush', 'discard']);","src/core/undo-history.ts",[1706],{"_1136":1014,"_1137":1707,"_478":1708,"_1140":57},381,[1709,1710,1711,1712,1713,1714,197,1715,197,1716,1717,1716,197,1709,1718,1719,1711,1720,1721,1722,1714,1723,1724,1725,1726,1727,1728,1729,1730,1597,1731,1180,197,1709,1732,1733,1714,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1158,1746,1747,1178,1597,1731,1180,197,1709,1748,1711,1749,1750,1714,1751,1752,1753,1754,197,1755,1756,197,1757,1758,1178,197,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1747,1770,197,1771,1762,197,1772,1773,1774,1158,1741,1775,1776,1777,1778,1779,1584,1158,1747,1178,1597,1780,1180,197,1716,1781,1716,197,1709,1782,1714,1783,1784,1785,1786,1787,1788,1789,1790,1791,1180,197,1716,1792,1716,197,1709,1793,1711,1794,1795,1796,1711,1797,1714,1798,1799,1800,1801,1802,197,1803,1804,197,1805,1806,1807,1808,197,1809,1810,1811,1812,1813,1814,1815,1816,1817,1597,197,1809,1818,1811,1819,1820,1811,1821,1814,1822,1823,1824,197,1825,1826,1827,197,1828,1829,1830,197,1831,1832,1833,1834,197,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1747,197,1845,1846,197,1847,1848,1747,197,1849,1850,1851,1178,1597,197,1809,1852,1811,1853,1814,1854,1855,1856,197,1857,1858,1859,1860,1178,1861,1597,197,1809,1862,1811,1863,1814,1864,1865,1866,197,1857,1867,1868,1869,1178,1861,1597,197,1809,1870,1811,1871,1814,1872,1873,1597,197,1809,1874,1814,1875,1876,1597,197,1809,1877,1811,1878,1879,1814,1880,1881,1597,197,1809,1882,1811,1883,1884,1814,1885,1886,1887,1597,197,1809,1888,1811,1889,1814,1890,1891,1597,197,1809,1892,1893,1814,1894,1895,1896,1897,1898,197,1899,1900,1178,1597,197,1809,1901,1902,1811,1903,1814,1904,1905,1906,1907,1172,1908,1909,1910,1597,197,1809,1911,1912,1811,1913,1914,1915,1916,1814,1917,1918,1919,1920,1921,1922,1923,1924,197,1925,1926,1927,197,1928,1929,1930,197,1931,1597,197,1809,1932,1814,1933,1934,1597,197,1809,1935,1814,1936,1937,1597,197,1809,1938,1814,1939,1940,1597,1180,197,1716,1941,1716],"/**"," * Modification Tracker Module"," *"," * Tracks database modifications for undo/redo functionality."," * Supports serialization for VS Code hot exit backup."," */","import type { LabeledModification } from './types';","// ============================================================================","// JSON Serialization Helpers for Binary Data"," * JSON replacer function that handles Uint8Array serialization."," * Converts Uint8Array to a special object format that can be restored."," * IMPORTANT: Standard JSON.stringify corrupts Uint8Array by converting it"," * to an object like {\"0\": 1, \"1\": 2, ...} which loses the type information."," * This replacer preserves the binary data as base64.","function binaryReplacer(_key: string, value: unknown): unknown {"," if (value instanceof Uint8Array) {"," // Convert to base64 with a type marker for restoration"," // Use Buffer in Node.js environment for efficiency"," const base64 = typeof Buffer !== 'undefined'"," ? Buffer.from(value).toString('base64')"," : btoa(String.fromCharCode(...value));"," return { __type: 'Uint8Array', data: base64 };"," return value;"," * JSON reviver function that restores Uint8Array from serialized format."," * Converts the special object format back to Uint8Array.","function binaryReviver(_key: string, value: unknown): unknown {"," if (value && typeof value === 'object' && '__type' in value) {"," const typed = value as { __type: string; data: string };"," if (typed.__type === 'Uint8Array' && typeof typed.data === 'string') {"," // Restore from base64"," if (typeof Buffer !== 'undefined') {"," return new Uint8Array(Buffer.from(typed.data, 'base64'));"," } else {"," const binary = atob(typed.data);"," const bytes = new Uint8Array(binary.length);"," for (let i = 0; i < binary.length; i++) {"," bytes[i] = binary.charCodeAt(i);"," return bytes;"," }"," * Estimate memory size of a value in bytes."," * Counts primitive sizes and structural overhead."," * Handles circular references by tracking seen objects.","function calculateSize(value: unknown): number {"," const seen = new Set();"," const stack = [value];"," let size = 0;"," while (stack.length > 0) {"," const current = stack.pop();"," if (current === null || current === undefined) {"," continue;"," if (typeof current === 'boolean') {"," size += 4;"," } else if (typeof current === 'number') {"," size += 8;"," } else if (typeof current === 'string') {"," size += current.length * 2;"," } else if (current instanceof Uint8Array) {"," size += current.byteLength;"," } else if (typeof current === 'object') {"," if (seen.has(current)) {"," continue;"," seen.add(current);"," // Overhead for object/array"," if (Array.isArray(current)) {"," for (const item of current) {"," stack.push(item);"," // Plain object"," for (const key in current) {"," if (Object.prototype.hasOwnProperty.call(current, key)) {"," size += key.length * 2;"," stack.push((current as Record)[key]);"," return size;","// Tracker State"," * Internal state for tracking modification history.","interface TrackerState {"," /** All recorded modifications */"," timeline: T[];"," /** Modifications that were undone (for redo) */"," futureStack: T[];"," /** Index marking the saved state */"," checkpointIndex: number;"," /** Maximum entries to retain */"," maxEntries: number;","// Modification Tracker Implementation"," * Tracks database modifications with undo/redo support."," * The tracker maintains a timeline of modifications that can be"," * navigated backward (undo) and forward (redo). When a new modification"," * is added after undo operations, the redo history is discarded."," * @typeParam T - Modification entry type with label","export class ModificationTracker {"," private timeline: T[] = [];"," private timelineSizes: number[] = [];"," /** Number of entries that were evicted from the front of the retained timeline. */"," private timelineOffset: number = 0;"," private futureStack: T[] = [];"," private futureStackSizes: number[] = [];"," private checkpointIndex: number = 0;"," private maxEntries: number;"," private maxMemory: number;"," private currentSize: number = 0;"," /**"," * Create a new modification tracker."," *"," * @param maxEntries - Maximum number of modifications to track"," * @param maxMemory - Maximum memory usage in bytes (default 50MB)"," */"," constructor(maxEntries: number = 100, maxMemory: number = 50 * 1024 * 1024) {"," this.maxEntries = maxEntries;"," this.maxMemory = maxMemory;"," * Record a new modification."," * Discards any future modifications (redo history) since"," * we're creating a new timeline branch."," * @param entry - Modification to record"," record(entry: T): void {"," // Calculate size of new entry"," const entrySize = calculateSize(entry);"," // Subtract size of redo history that we are about to discard"," const redoSize = this.futureStackSizes.reduce((a, b) => a + b, 0);"," this.currentSize -= redoSize;"," // Discard redo history"," this.futureStack = [];"," this.futureStackSizes = [];"," // Add new entry"," this.timeline.push(entry);"," this.timelineSizes.push(entrySize);"," this.currentSize += entrySize;"," // Enforce capacity and memory limits"," // We remove oldest entries until we are within BOTH limits"," while ("," (this.timeline.length > 0) &&"," (this.timeline.length > this.maxEntries || this.currentSize > this.maxMemory)"," ) {"," // Don't remove the just-added entry if it's the only one, to preserve ability to undo at least one step if possible."," // However, if strict memory limit is required, we might need to, but let's be practical."," if (this.timeline.length === 1) {"," break;"," const removedEntrySize = this.timelineSizes.shift();"," this.timeline.shift();"," if (removedEntrySize !== undefined) {"," this.currentSize -= removedEntrySize;"," // Adjust checkpoint index since we shifted the array"," this.checkpointIndex = Math.max(0, this.checkpointIndex - 1);"," this.timelineOffset++;"," * Step backward in timeline (undo)."," * @returns The modification that was undone, or undefined if at beginning"," stepBack(): T | undefined {"," const entry = this.timeline.pop();"," const size = this.timelineSizes.pop();"," if (entry) {"," this.futureStack.push(entry);"," this.futureStackSizes.push(size || 0);"," // currentSize doesn't change as entry just moves from timeline to futureStack"," return entry;"," * Step forward in timeline (redo)."," * @returns The modification to reapply, or undefined if at end"," stepForward(): T | undefined {"," const entry = this.futureStack.pop();"," const size = this.futureStackSizes.pop();"," this.timeline.push(entry);"," this.timelineSizes.push(size || 0);"," // currentSize doesn't change as entry just moves from futureStack to timeline"," * Check if there are uncommitted modifications."," * @returns True if timeline differs from checkpoint"," hasUncommittedChanges(): boolean {"," return this.timeline.length !== this.checkpointIndex;"," * Mark current position as checkpoint (saved state)."," async createCheckpoint(): Promise {"," this.checkpointIndex = this.timeline.length;"," * Return the absolute timeline position after the latest retained entry."," * This position is stable across later front-eviction because it includes the"," * count of entries already removed from the retained timeline."," getCurrentPosition(): number {"," return this.timelineOffset + this.timeline.length;"," * Mark a previously captured absolute timeline position as the saved state."," * The position is translated back into the retained timeline, clamped when"," * old entries were evicted or when callers provide a future position."," async createCheckpointAt(position: number): Promise {"," const relativePosition = position - this.timelineOffset;"," this.checkpointIndex = Math.max(0, Math.min(this.timeline.length, relativePosition));"," * Get all modifications since last checkpoint."," * @returns Array of uncommitted modifications"," getUncommittedEntries(): T[] {"," return this.timeline.slice(this.checkpointIndex);"," * Rollback to the last checkpoint."," * Moves uncommitted modifications to redo stack."," rollbackToCheckpoint(): void {"," const uncommittedCount = this.timeline.length - this.checkpointIndex;"," if (uncommittedCount > 0) {"," const uncommitted = this.timeline.splice(this.checkpointIndex);"," const uncommittedSizes = this.timelineSizes.splice(this.checkpointIndex);"," this.futureStack.push(...uncommitted.reverse());"," this.futureStackSizes.push(...uncommittedSizes.reverse());"," * Serialize tracker state for backup."," * Uses custom JSON replacer to properly handle Uint8Array binary data."," * @returns Binary representation of state"," serialize(): Uint8Array {"," const payload = {"," timeline: this.timeline,"," checkpointIndex: this.checkpointIndex"," // Use binaryReplacer to properly serialize Uint8Array values"," const jsonStr = JSON.stringify(payload, binaryReplacer);"," return new TextEncoder().encode(jsonStr);"," * Restore tracker from serialized state."," * Uses custom JSON reviver to properly restore Uint8Array binary data."," * @param data - Previously serialized state"," * @param maxEntries - Maximum capacity"," * @param maxMemory - Maximum memory usage in bytes"," * @returns Restored tracker"," static deserialize("," data: Uint8Array,"," maxEntries: number = 100,"," maxMemory?: number"," ): ModificationTracker {"," const jsonStr = new TextDecoder().decode(data);"," // Use binaryReviver to properly restore Uint8Array values"," const payload = JSON.parse(jsonStr, binaryReviver);"," const tracker = new ModificationTracker(maxEntries, maxMemory);"," tracker.timeline = payload.timeline || [];"," tracker.checkpointIndex = payload.checkpointIndex || 0;"," // Recalculate sizes"," tracker.timelineSizes = tracker.timeline.map(calculateSize);"," tracker.currentSize = tracker.timelineSizes.reduce((a, b) => a + b, 0);"," return tracker;"," * Get total number of modifications in timeline."," get entryCount(): number {"," return this.timeline.length;"," * Check if undo is available."," get canStepBack(): boolean {"," return this.timeline.length > 0;"," * Check if redo is available."," get canStepForward(): boolean {"," return this.futureStack.length > 0;","// Compatibility Aliases","src/databaseModel.ts",[1944],{"_1136":1014,"_1137":1945,"_478":1946,"_1140":57},515,[1709,1947,1711,1948,1949,1714,197,1950,1951,197,1952,197,1953,1954,1955,1956,1957,1958,197,1959,1960,1961,197,1962,1963,1964,197,1716,1965,1716,197,1709,1966,1714,1967,197,1716,1968,1716,197,1969,1970,197,1971,1972,197,1973,1974,197,1975,1976,1977,1978,197,1979,1980,197,1716,1981,1716,197,1982,1983,197,1984,1985,197,1709,1986,1714,1987,1988,1989,1990,1180,197,1709,1991,1714,1992,1988,1993,1180,197,1716,1994,1716,197,1709,1995,1711,1996,1997,1998,1999,2000,2001,1714,2002,2003,2004,197,1809,2005,1814,2006,2007,2008,2009,2010,2011,2012,2013,197,2014,2015,197,2016,2017,197,2018,2019,197,2020,2021,2022,2023,2024,2025,2026,2027,2028,197,2029,2030,2031,2032,2033,2034,2035,1178,197,2036,2037,2038,2039,2040,2041,2042,2043,2035,197,2044,2045,2046,2047,2048,1343,2049,2050,2051,2052,2053,2054,2055,2056,2057,1584,1343,2058,1747,1178,197,2059,2060,2022,2061,2062,2063,2064,2065,2066,2026,1597,197,2067,2068,2069,1597,197,2070,2071,2072,197,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,1597,197,2088,2089,2090,2091,197,2092,2093,2092,197,2094,2095,197,2096,2097,197,2098,2099,2100,2101,2102,2103,2104,2105,197,2092,2106,2092,197,2107,2108,2109,2110,2111,2112,1597,197,2092,2113,2092,197,1809,2114,1814,2115,2116,2117,197,2118,2119,197,2120,2121,2122,2123,2124,2125,2126,1158,1201,2127,2128,2129,2130,2131,2132,1158,1614,2133,2134,2135,2136,2126,1158,1201,2137,2128,2129,2130,2138,2139,1158,1747,1214,197,2140,1597,197,1809,2141,1814,2142,2143,2144,1597,197,2092,2145,2092,197,2146,2147,2148,2149,1178,1591,197,1809,2150,1811,2151,2152,1811,2153,1814,2154,2155,197,2156,2157,2158,2159,2160,2044,2161,2049,2162,2163,2164,1747,2165,2166,1178,197,2167,2168,2169,1201,2170,2171,2126,2130,2172,2173,1158,1178,197,2174,2175,2176,2177,2178,2179,1173,2180,2181,2182,2183,1178,2184,2185,2186,2187,2188,1597,197,1809,2189,1814,2190,2155,197,2191,1201,2192,2193,2126,2130,2194,1158,1178,197,2195,2196,2197,1178,197,2174,2175,2198,1597,197,1809,2199,1814,2200,2155,2201,2202,2203,2204,2205,2026,2144,2140,1597,197,2092,2206,2092,197,2207,1173,2208,2209,2210,1504,2211,1158,1747,2181,2212,2213,2214,2215,1178,1597,197,2216,2217,2218,1597,197,2219,2220,2221,1597,197,2222,2223,2224,1597,197,2092,2225,2092,197,2226,2227,1597,197,2228,2229,1597,197,2230,2231,2232,1597,197,1809,2233,1814,2234,2235,197,2236,2237,2238,2239,2035,2240,2241,2242,1573,2243,1178,197,2244,1597,197,2092,2245,2092,197,2246,2247,2248,2249,2250,2251,197,2252,2253,2254,1201,2255,2256,2257,2258,1158,1747,1172,1597,1180]," * Database Document Model"," * Represents a SQLite database as a VS Code CustomDocument."," * Handles document lifecycle, modification tracking, and persistence.","import type { TelemetryReporter } from '@vscode/extension-telemetry';","import type { DatabaseViewerProvider } from './editorController';","import * as vsc from 'vscode';","import { ConfigurationSection, FullExtensionId } from './config';","import { Disposable } from './lifecycle';","import { cancelTokenToAbortSignal, getUriParts, generateDatabaseDocumentKey } from './helpers';","import { HostBridge } from './hostBridge';","import { DatabaseConnectionBundle } from './connectionTypes';","import { DocumentRegistry } from './documentRegistry';","import { createDatabaseConnection } from './workerFactory';","import { getMaximumFileSizeBytes } from './config';","import { GlobalOutputChannel } from './main';","import { ModificationTracker } from './core/undo-history';","import type { LabeledModification, DatabaseOperations } from './core/types';","import { LoggingDatabaseOperations } from './loggingDatabaseOperations';","// Types"," * Modification entry with display label.","export type DocumentModification = LabeledModification;","// Environment Detection","/** Reference to the running extension */","const CurrentExtension = vsc.extensions.getExtension(FullExtensionId);","/** Running on local machine (not remote) */","const IsLocalMode = !vsc.env.remoteName;","/** Running inside the browser extension host used by VS Code for Web */","const IsBrowserExtensionHost = !!import.meta.env?.VSCODE_BROWSER_EXT;","/** Running on remote with workspace extension */","export const IsRemoteWorkspaceMode ="," !!vsc.env.remoteName &&"," CurrentExtension?.extensionKind === vsc.ExtensionKind.Workspace;","/** Editor supports read-write operations */","export const SupportsWriteMode = IsLocalMode || IsRemoteWorkspaceMode || IsBrowserExtensionHost;","// Configuration","/** Maximum modifications to track */","const MODIFICATION_LIMIT = 100;","/** Default maximum memory for undo history (50MB) */","const DEFAULT_MAX_UNDO_MEMORY = 50 * 1024 * 1024;"," * Get auto-commit setting from configuration.","export function isAutoCommitEnabled(): boolean {"," const config = vsc.workspace.getConfiguration(ConfigurationSection);"," const setting = config.get('instantCommit', 'never');"," return setting === 'always' || (setting === 'remote-only' && IsRemoteWorkspaceMode);"," * Get maximum undo memory from configuration.","function getMaxUndoMemory(): number {"," return config.get('maxUndoMemory', DEFAULT_MAX_UNDO_MEMORY);","// Document Class"," * Database document implementation."," * Implements VS Code's CustomDocument for SQLite databases."," * Manages:"," * - Database connection lifecycle"," * - Modification tracking and undo/redo"," * - Save, save-as, and revert operations"," * - Hot exit backup/restore","export class DatabaseDocument extends Disposable implements vsc.CustomDocument {"," /** Unique document key for registry lookup */"," readonly #documentKey: Promise;"," * Factory method to create a DatabaseDocument."," static async create("," viewerProvider: DatabaseViewerProvider,"," fileUri: vsc.Uri,"," openContext: vsc.CustomDocumentOpenContext,"," cancellation?: vsc.CancellationToken"," ): Promise {"," const { reporter, isVerified, context: { extensionUri } } = viewerProvider;"," let { forceReadOnly } = viewerProvider;"," // Use WebAssembly-based worker for database operations"," const connectionFactory = createDatabaseConnection;"," const { filename } = getUriParts(fileUri);"," const autoCommit = isAutoCommitEnabled();"," let connectionBundle: DatabaseConnectionBundle;"," let databaseOps: DatabaseOperations;"," connectionBundle = await connectionFactory(extensionUri, reporter);"," const result = await connectionBundle.establishConnection("," fileUri,"," filename,"," forceReadOnly,"," autoCommit"," );"," databaseOps = result.databaseOps;"," forceReadOnly = result.isReadOnly;"," // Wrap with logger if output channel is available"," if (viewerProvider.outputChannel) {"," databaseOps = new LoggingDatabaseOperations("," databaseOps,"," filename,"," viewerProvider.outputChannel"," );"," // Restore modification history from backup"," let tracker: ModificationTracker | null = null;"," if (typeof openContext.backupId === 'string' && !autoCommit) {"," const backupUri = vsc.Uri.parse(openContext.backupId);"," const backupData = await vsc.workspace.fs.readFile(backupUri);"," tracker = ModificationTracker.deserialize("," backupData,"," MODIFICATION_LIMIT"," try {"," // Replay uncommitted modifications"," await databaseOps.applyModifications("," tracker.getUncommittedEntries(),"," cancelTokenToAbortSignal(cancellation)"," } catch (err) {"," const errorMsg = err instanceof Error ? err.message : vsc.l10n.t('Unknown error');"," await vsc.window.showErrorMessage("," vsc.l10n.t('[{0}] occurred while applying unsaved changes', errorMsg),"," {"," modal: true,"," detail: vsc.l10n.t("," 'The document was restored from backup, but changes could not be applied. Opening in read-only mode.'"," )"," forceReadOnly = true;"," return new DatabaseDocument("," viewerProvider,"," tracker,"," autoCommit,"," { databaseOps, isReadOnly: forceReadOnly },"," connectionBundle.workerMethods,"," connectionBundle.establishConnection.bind(connectionBundle),"," reporter"," /** Get configured max file size */"," getFileSizeLimit(): number {"," return getMaximumFileSizeBytes();"," // Private state"," readonly #modificationTracker: ModificationTracker;"," readonly #hostBridge: HostBridge;"," private constructor("," readonly viewerProvider: DatabaseViewerProvider,"," readonly uri: vsc.Uri,"," tracker: ModificationTracker | null,"," public autoCommitEnabled: boolean,"," private connectionState: { databaseOps: DatabaseOperations; isReadOnly?: boolean },"," private readonly workerMethods: DatabaseConnectionBundle['workerMethods'],"," private readonly establishConnection: DatabaseConnectionBundle['establishConnection'],"," private readonly reporter?: TelemetryReporter"," ) {"," super();"," this.#modificationTracker = tracker ?? new ModificationTracker(MODIFICATION_LIMIT, getMaxUndoMemory());"," this.#hostBridge = new HostBridge(viewerProvider, this);"," this.#documentKey = generateDatabaseDocumentKey(this.uri);"," this.#documentKey.then(key => DocumentRegistry.set(key, this));"," // Public accessors"," get fileParts() { return getUriParts(this.uri); }"," get hostBridge() { return this.#hostBridge; }"," get documentKey() { return this.#documentKey; }"," // ============================================================================"," // Event Emitters"," readonly #disposeEmitter = this._register(new vsc.EventEmitter());"," readonly onDidDispose = this.#disposeEmitter.event;"," readonly #contentChangeEmitter = this._register(new vsc.EventEmitter<{}>());"," readonly onDidChangeContent = this.#contentChangeEmitter.event;"," readonly #modificationEmitter = this._register("," new vsc.EventEmitter<{"," readonly label: string;"," undo(): void | Promise;"," redo(): void | Promise;"," }>()"," );"," readonly onDidChange = this.#modificationEmitter.event;"," // Lifecycle"," async dispose(): Promise {"," const key = await this.#documentKey;"," DocumentRegistry.delete(key);"," this.workerMethods[Symbol.dispose]();"," super.dispose();"," this.#disposeEmitter.fire();"," // Modification Tracking"," * Record a modification for undo/redo tracking."," recordModification(modification: DocumentModification): void {"," const tracker = this.#modificationTracker;"," tracker.record(modification);"," // Ensure future stack is cleared so we don't have stale redo actions"," // This is handled by tracker.record, but explicit check in emitter helps"," this.#modificationEmitter.fire({"," label: modification.label,"," undo: async () => {"," const undoneEntry = tracker.stepBack();"," if (!undoneEntry) {"," console.warn('[Undo] No entry found in tracker');"," return;"," await this.databaseOperations.undoModification(undoneEntry);"," this.#contentChangeEmitter.fire({});"," this.#autoSaveIfNeeded();"," } catch (e) {"," console.error('[Undo] Failed:', e);"," vsc.window.showErrorMessage(vsc.l10n.t('Undo failed: {0}', e instanceof Error ? e.message : String(e)));"," redo: async () => {"," const redoneEntry = tracker.stepForward();"," if (!redoneEntry) {"," console.warn('[Redo] No entry found in tracker');"," await this.databaseOperations.redoModification(redoneEntry);"," console.error('[Redo] Failed:', e);"," vsc.window.showErrorMessage(vsc.l10n.t('Redo failed: {0}', e instanceof Error ? e.message : String(e)));"," this.#autoSaveIfNeeded();"," * Record a modification from external source."," recordExternalModification(modification: DocumentModification): void {"," this.recordModification(modification);"," this.#contentChangeEmitter.fire({});"," // Persistence"," /** Verify document is writable */"," ensureWritable = async (): Promise => {"," if (this.isReadOnlyMode) {"," throw new Error(vsc.l10n.t('Document is read-only'));"," * Save document to disk."," * For native SQLite engine: changes are already persisted to disk via SQLite's"," * auto-commit, so we just need to create a checkpoint for undo/redo tracking."," * For WASM engine: we need to serialize the in-memory database and write to disk."," async save(cancellation?: vsc.CancellationToken): Promise {"," await this.ensureWritable();"," // Check if using native engine - changes are already on disk"," const engineKind = await this.databaseOperations.engineKind;"," if (engineKind === 'native') {"," // Native SQLite writes directly to file - no export needed"," // Just ensure WAL is checkpointed for consistency"," await this.databaseOperations.executeQuery('PRAGMA wal_checkpoint(PASSIVE)');"," // Ignore checkpoint errors - database may not be using WAL mode"," // Log at debug level for troubleshooting if needed"," GlobalOutputChannel?.appendLine(`[WAL checkpoint skipped] ${err instanceof Error ? err.message : String(err)}`);"," await this.#modificationTracker.createCheckpoint();"," return;"," // Export in-memory database to file (WASM engine only)"," // We always do this for WASM, regardless of auto-commit setting, because WASM is in-memory."," if (this.uri.scheme === 'file') {"," await this.databaseOperations.writeToFile(this.uri.fsPath);"," await this.#modificationTracker.createCheckpoint();"," // Fallback if direct write fails"," console.warn('Direct write failed, falling back to buffer transfer', e);"," const { filename } = this.fileParts;"," const binaryContent = await this.databaseOperations.serializeDatabase(filename);"," // Capture the tracker position immediately after serialization. The bytes"," // below represent edits up to this position only; edits recorded while the"," // asynchronous workspace write is pending must remain dirty."," const serializedCheckpoint = this.#modificationTracker.getCurrentPosition();"," await vsc.workspace.fs.writeFile(this.uri, binaryContent);"," } catch (err) {"," const message = err instanceof Error ? err.message : String(err);"," throw new Error(`Failed to save database: ${message}`);"," // Only mark the tracker clean after bytes are persisted. If a web filesystem"," // rejects writeFile, the edit history remains uncommitted for backup/retry."," // The saved checkpoint is limited to the serialized snapshot so concurrent"," // edits are not acknowledged before their bytes reach storage."," await this.#modificationTracker.createCheckpointAt(serializedCheckpoint);"," * Save document to new location."," async saveAs(targetUri: vsc.Uri, cancellation: vsc.CancellationToken): Promise {"," if (targetUri.scheme === 'file') {"," // Use optimized write/vacuum if available"," await this.databaseOperations.writeToFile(targetUri.fsPath);"," console.warn('Direct write failed, falling back to buffer transfer', e);"," const fileStat = await vsc.workspace.fs.stat(this.uri);"," if (fileStat.size > this.getFileSizeLimit()) {"," throw new Error(vsc.l10n.t('Database too large for copy operation'));"," await vsc.workspace.fs.writeFile(targetUri, binaryContent);"," * Revert to last saved state."," async revert(cancellation: vsc.CancellationToken): Promise {"," const uncommitted = this.#modificationTracker.getUncommittedEntries();"," this.#modificationTracker.rollbackToCheckpoint();"," await this.databaseOperations.discardModifications("," uncommitted,"," cancelTokenToAbortSignal(cancellation)"," // Auto-save"," async #autoSaveIfNeeded(): Promise {"," if (this.autoCommitEnabled) {"," if (this.#hasActiveViewer) {"," await this.triggerSave();"," this.#savePending = true;"," // Record auto-save failures in the output channel for debugging instead of showing a UI error"," const errorMessage = err instanceof Error ? err.message : String(err);"," GlobalOutputChannel?.appendLine(`[Auto-save failed] ${errorMessage}`);"," console.error('[Auto-save failed]', err);"," #hasActiveViewer = false;"," set hasActiveViewer(value: boolean) {"," this.#hasActiveViewer = value;"," #savePending = false;"," get hasPendingSave(): boolean {"," return this.#savePending;"," async triggerSave(): Promise {"," this.#savePending = false;"," await vsc.commands.executeCommand('workbench.action.files.save');"," // Database Access"," get databaseOperations(): DatabaseOperations {"," return this.connectionState.databaseOps;"," get isReadOnlyMode(): boolean {"," return this.connectionState.isReadOnly ?? false;"," get cellEditBehavior(): string {"," const config = vsc.workspace.getConfiguration(ConfigurationSection);"," return config.get('doubleClickBehavior', 'inline');"," * Reload database from disk."," async reloadFromDisk(): Promise {"," const currentOps = this.databaseOperations;"," if ((await currentOps.engineKind) === 'wasm') {"," const result = await this.establishConnection("," this.uri,"," this.fileParts.filename"," this.connectionState = {"," databaseOps: result.databaseOps,"," isReadOnly: result.isReadOnly"," return result.databaseOps;"," return currentOps;"," // Backup (Hot Exit)"," async backup("," destination: vsc.Uri,"," _cancellation: vsc.CancellationToken"," ): Promise {"," const serializedState = this.#modificationTracker.serialize();"," await vsc.workspace.fs.writeFile(destination, serializedState);"," return {"," id: destination.toString(),"," delete: async () => {"," await vsc.workspace.fs.delete(destination);"," } catch (err) {"," // Ignore errors during backup deletion (e.g. file already deleted)"," GlobalOutputChannel?.appendLine(`[Backup deletion failed] ${err instanceof Error ? err.message : String(err)}`);","src/core/sqlite-db.ts",[2261],{"_1136":1014,"_1137":2262,"_478":2263,"_1140":57},284,[1709,2264,1711,2265,2266,2267,2268,1711,2269,2270,1714,197,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,197,2291,2292,197,1716,2293,1716,197,1709,2294,1711,2295,2296,1714,2297,2298,2299,2300,2301,197,2302,2303,2304,2305,2306,2307,1597,197,2308,197,2309,2310,2311,197,2312,2313,2044,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,1584,2324,2325,1747,1597,197,2326,2327,2328,197,2329,2330,2331,197,2332,197,2333,2334,2335,2336,2337,2338,1597,197,2339,197,2340,2341,2342,1591,1180,197,1716,2343,1716,197,1709,2344,1711,2345,2346,1714,2347,2348,197,2349,2350,2351,1597,197,2340,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,1747,197,2366,2367,197,2368,2369,1571,2242,1573,2370,197,2352,2371,2354,2372,2373,2374,2358,2375,2376,2370,197,2352,2377,2354,2378,2379,2358,2380,2381,2370,197,2382,2383,2384,2385,2370,197,2386,2387,2370,197,2388,2389,2370,197,2390,2391,2370,197,2392,2393,2370,197,2394,2395,2370,197,2396,2397,2370,197,2398,2399,2370,197,2400,2401,2370,197,2402,2403,2370,197,2404,2405,2370,197,2406,2407,2370,197,2408,2409,2370,197,2410,2411,2370,197,2412,2413,2370,197,2414,2415,2370,197,2416,2417,2370,197,2418,2419,2370,197,2420,2421,2370,197,2422,2423,2370,197,2424,2425,2426,2370,197,2427,2428,2370,197,2352,2429,2354,2430,2431,2432,2433,2358,2434,2364,2365,2435,1747,1178,1591,1180]," * SQLite Database Engine Module"," * Slim public surface for the WASM engine. The implementation lives in"," * src/core/engine/wasm/WasmDatabaseEngine.ts; this file owns the factory"," * (createDatabaseEngine) and the worker-side endpoint that wires the"," * RPC dispatcher to the engine instance."," * WasmDatabaseEngine is re-exported so existing imports"," * (`import { WasmDatabaseEngine } from '.../core/sqlite-db'`) keep working.","import type {"," CellValue,"," RecordId,"," QueryResultSet,"," DatabaseInitConfig,"," DatabaseInitResult,"," CellUpdate,"," TableQueryOptions,"," TableCountOptions,"," SchemaSnapshot,"," ColumnMetadata,"," ColumnDefinition,"," ModificationEntry","} from './types';","import { getNodeFs } from './platform/fs';","import {"," WasmDatabaseEngine,"," type WasmDatabaseInstance,"," type WasmEngineModule","} from './engine/wasm/WasmDatabaseEngine';","export { WasmDatabaseEngine } from './engine/wasm/WasmDatabaseEngine';","export { getNodeFs } from './platform/fs';","// Database Factory"," * Initialize the sql.js engine and create a database instance."," * @param config - Initialization configuration"," * @returns Database operations handle and read-only flag","export async function createDatabaseEngine("," config: DatabaseInitConfig","): Promise {"," // Dynamically load sql.js module"," const loadEngine = (await import('sql.js')).default;"," // Configure WASM loading"," const engineConfig: Record = {};"," if (config.wasmBinary && config.wasmBinary.byteLength > 0) {"," engineConfig.wasmBinary = config.wasmBinary;"," } else if (config.resourceMap?.['sqlite3.wasm']) {"," engineConfig.locateFile = () => config.resourceMap!['sqlite3.wasm'];"," const SqlJsModule = await loadEngine(engineConfig) as unknown as WasmEngineModule;"," // Create database instance"," let wasmInstance: WasmDatabaseInstance;"," let buffer = config.content;"," // If content is missing but filePath is provided, read from disk (Node.js only)"," if (!buffer && config.filePath) {"," // Dynamic require to avoid bundling fs in browser builds"," // In actual build, this code path only runs in Node worker"," const fs = getNodeFs();"," if (fs) {"," // Validate size"," const stats = await fs.promises.stat(config.filePath);"," if (config.maxSize > 0 && stats.size > config.maxSize) {"," throw new Error('File too large');"," }"," buffer = await fs.promises.readFile(config.filePath);"," } catch (e) {"," console.error('Failed to read file in worker:', e);"," if (buffer && buffer.byteLength > 0) {"," // Open existing database from binary"," // Avoid creating an intermediate copy"," const data = (buffer.buffer && buffer.byteLength === buffer.buffer.byteLength)"," ? new Uint8Array(buffer.buffer, buffer.byteOffset, buffer.byteLength)"," : buffer;"," wasmInstance = new SqlJsModule.Database(data);"," // Help GC"," buffer = null;"," config.content = null;"," } else {"," // Create new empty database"," wasmInstance = new SqlJsModule.Database();"," const engine = new WasmDatabaseEngine(wasmInstance, config.queryTimeout);"," return {"," operations: engine,"," isReadOnly: config.readOnlyMode ?? false","// Worker Entry Point"," * Create a handler object for worker-side database operations."," * This factory creates an object with methods that can be exposed"," * to the extension host via the IPC module.","export function createWorkerEndpoint() {"," let activeEngine: WasmDatabaseEngine | null = null;"," function requireEngine(): WasmDatabaseEngine {"," if (!activeEngine) throw new Error('No database initialized');"," return activeEngine;"," /**"," * Initialize a database from binary content."," *"," * @param filename - Display name for the database"," * @param config - Initialization configuration"," * @returns Database handle and read-only status"," */"," async initializeDatabase("," filename: string,"," config: DatabaseInitConfig"," ): Promise {"," // Shutdown existing engine if present"," if (activeEngine) {"," activeEngine.shutdown();"," const result = await createDatabaseEngine(config);"," activeEngine = result.operations as WasmDatabaseEngine;"," // Return value is primarily used for isReadOnly flag."," // The actual database operations are accessed via the worker endpoint methods below."," },"," * Execute a query on the active database."," * @param sql - SQL statement"," * @param params - Bound parameters"," * @returns Query result sets"," async runQuery(sql: string, params?: CellValue[]): Promise {"," return requireEngine().executeQuery(sql, params);"," * Export the active database to binary."," * @param name - Database name"," * @returns Binary content"," async exportDatabase(name: string): Promise {"," return requireEngine().serializeDatabase(name);"," // Expose undo/history operations for the browser in-process facade, which"," // calls this endpoint directly instead of going through worker RPC."," async applyModifications(mods: ModificationEntry[], signal?: AbortSignal): Promise {"," return requireEngine().applyModifications(mods, signal);"," async undoModification(mod: ModificationEntry): Promise {"," return requireEngine().undoModification(mod);"," async redoModification(mod: ModificationEntry): Promise {"," return requireEngine().redoModification(mod);"," async flushChanges(signal?: AbortSignal): Promise {"," return requireEngine().flushChanges(signal);"," async discardModifications(mods: ModificationEntry[], signal?: AbortSignal): Promise {"," return requireEngine().discardModifications(mods, signal);"," async updateCell(table: string, rowId: RecordId, column: string, value: CellValue): Promise {"," return requireEngine().updateCell(table, rowId, column, value);"," async insertRow(table: string, data: Record): Promise {"," return requireEngine().insertRow(table, data);"," async insertRowBatch(table: string, rows: Record[]): Promise {"," return requireEngine().insertRowBatch(table, rows);"," async deleteRows(table: string, rowIds: RecordId[]): Promise {"," return requireEngine().deleteRows(table, rowIds);"," async deleteColumns(table: string, columns: string[], dropDependentIndexes?: string[]): Promise {"," return requireEngine().deleteColumns(table, columns, dropDependentIndexes);"," async findDependentIndexes(table: string, columns: string[]): Promise {"," return requireEngine().findDependentIndexes(table, columns);"," async createTable(table: string, columns: ColumnDefinition[]): Promise {"," return requireEngine().createTable(table, columns);"," async updateCellBatch(table: string, updates: CellUpdate[]): Promise {"," return requireEngine().updateCellBatch(table, updates);"," async addColumn(table: string, column: string, type: string, defaultValue?: string): Promise {"," return requireEngine().addColumn(table, column, type, defaultValue);"," async fetchTableData(table: string, options: TableQueryOptions): Promise {"," return requireEngine().fetchTableData(table, options);"," async fetchTableCount(table: string, options: TableCountOptions): Promise {"," return requireEngine().fetchTableCount(table, options);"," async fetchSchema(): Promise {"," return requireEngine().fetchSchema();"," async getTableInfo(table: string): Promise {"," return requireEngine().getTableInfo(table);"," async getPragmas(): Promise> {"," return requireEngine().getPragmas();"," async setPragma(pragma: string, value: CellValue): Promise {"," return requireEngine().setPragma(pragma, value);"," async ping(): Promise {"," if (!activeEngine) return false;"," return activeEngine.ping();"," async writeToFile(path: string): Promise {"," return requireEngine().writeToFile(path);"," * Release the active engine and its underlying sql.js WASM heap."," * Safe to call when no database is active (no-op) and idempotent. The"," * in-process browser connection wires this to its bundle's [Symbol.dispose]"," * so closing a database frees the WASM instance instead of leaking it; the"," * Node worker path tears down the whole worker thread instead."," dispose(): void {"," activeEngine = null;","src/workerFactory.ts",[2438],{"_1136":1014,"_1137":2439,"_478":2440,"_1140":57},542,[1709,2441,1711,2442,2443,1711,2444,2445,2446,1714,197,1950,197,1952,2447,197,2448,1961,2271,2272,2274,2449,2450,2275,2276,2277,2282,2278,2279,2280,2451,2452,197,2453,2454,2455,2456,197,2457,2458,2459,2460,2461,197,2462,2463,1592,2464,2465,2466,2467,1597,1180,197,1716,2468,1716,197,1709,2469,1714,2470,2471,2472,2473,2474,2475,1546,1552,1553,2476,2477,2478,2479,2480,1554,2481,2482,2483,2484,2485,2486,2487,1555,2488,1180,197,1716,2489,1716,197,1709,2490,1711,2491,2492,1711,2493,2494,2495,2496,1711,2497,2498,2499,1714,2500,2501,2502,2503,2504,2505,2506,2507,2044,2508,2509,197,2510,2511,2512,2513,2514,197,1323,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2322,2525,1238,1584,1239,2049,2526,1747,1178,1597,197,2527,2528,2529,1180,197,1709,2530,1711,2531,2532,2533,1711,2497,2498,2499,1714,2534,2501,2502,2503,2535,2536,1597,197,2537,1180,197,1709,2538,1711,2539,2540,2541,2542,2543,2544,2545,2546,1714,2547,2548,2503,2549,197,2340,2550,2551,2552,2553,2554,2555,2556,2370,197,2352,2557,2354,2558,2559,2358,2560,2561,2562,2563,2564,1840,2565,2566,2567,2568,2569,2570,2571,2572,2573,197,2574,2575,2576,2577,197,2578,2579,2580,2581,2582,2583,2584,2585,1573,197,2586,197,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,1573,197,1571,2636,2637,1573,1178,1591,1180,197,1709,2638,1711,2639,2640,1714,2641,2548,2503,2642,2643,2644,197,2645,2646,2647,2648,2649,2650,2651,2652,2653,1178,1591,197,2654,2655,2656,2657,2658,1504,2659,1158,1614,2660,2661,2662,2663,1747,2370,2664,2665,2104,197,2666,2667,2668,1591,197,2340,2550,2669,2670,2370,197,2352,2671,2354,2672,2673,2674,2675,2357,2358,2560,2561,2562,2563,2564,1840,2044,2676,2677,2678,2679,2680,197,2681,2682,2683,197,2684,2685,2686,2687,2688,2689,1373,2690,1238,1504,2691,1158,197,2692,2693,2694,197,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,1239,197,2705,2706,2707,2708,2709,1158,2710,2711,1158,2712,2713,1158,197,2714,2715,2716,1343,197,2717,2718,2719,2720,2721,2722,1584,2723,1239,197,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,1238,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2742,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,1239,197,1323,2778,2779,1239,2049,2780,2781,2782,1747,1178,1591,1180,197,1716,2783,1716,197,1709,2784,1711,2785,2786,1714,2787,2788,2789,2790,2791,2792,1597,197,2793,197,2794,2795,2796,2797,1597,197,2798,2799,197,2800,2801,2802,2803,2804,1180]," * Worker Thread Factory Module"," * Creates and configures Worker threads for database operations."," * Provides the bridge between extension host and worker thread."," * Supports two backends:"," * - Native: txiki-js with native SQLite (faster, desktop only)"," * - WASM: sql.js WebAssembly (works everywhere, including browser)","import path from 'path';","import { connectWorkerPort, Transfer } from './core/rpc';"," ModificationEntry,"," DatabaseOperations,"," ColumnMetadata","} from './core/types';","import { Worker } from './platform/threadPool';","import type { DatabaseConnectionBundle } from './connectionTypes';","import { getMaximumFileSizeBytes, getQueryTimeout } from './config';","import { createWorkerEndpoint } from './core/sqlite-db';","// Native worker support (only in Node.js environment)","let nativeSupport: {"," isNativeAvailable: (path: string) => Promise;"," createNativeDatabaseConnection: typeof import('./nativeWorker').createNativeDatabaseConnection;","} | null = null;","// Dynamically import native worker in Node.js environment","if (!import.meta.env?.VSCODE_BROWSER_EXT) {"," // Use dynamic import for native worker"," nativeSupport = require('./nativeWorker');"," } catch {"," // Native worker not available","// Worker Interface Types"," * Methods exposed by the database worker.","interface WorkerMethods {"," initializeDatabase("," filename: string,"," config: DatabaseInitConfig"," ): Promise;"," runQuery(sql: string, params?: CellValue[]): Promise;"," insertRowBatch(table: string, rows: Record[]): Promise;"," deleteRows(table: string, rowIds: (string | number)[]): Promise;"," deleteColumns(table: string, columns: string[], dropDependentIndexes?: string[]): Promise;"," findDependentIndexes(table: string, columns: string[]): Promise;"," createTable(table: string, columns: ColumnDefinition[]): Promise;"," addColumn(table: string, column: string, type: string, defaultValue?: string): Promise;"," fetchTableData(table: string, options: TableQueryOptions): Promise;"," fetchTableCount(table: string, options: TableCountOptions): Promise;"," fetchSchema(): Promise;"," getTableInfo(table: string): Promise;"," getPragmas(): Promise>;"," setPragma(pragma: string, value: CellValue): Promise;"," writeToFile(path: string): Promise;","// Worker Factory"," * Create a database connection bundle."," * Attempts to use native SQLite (txiki-js) for better performance."," * Falls back to sql.js (WebAssembly) when native is unavailable or fails."," * IMPORTANT: The fallback to WASM happens at bundle creation time. If native"," * backend creation succeeds but file open fails later (e.g., due to macOS"," * sandboxing), we wrap the native bundle to catch those errors and create"," * a hybrid that can fall back at connection time."," * @param extensionUri - Extension installation directory URI"," * @param _reporter - Optional telemetry reporter"," * @returns Connection bundle with worker methods","export async function createDatabaseConnection("," extensionUri: vsc.Uri,"," _reporter?: TelemetryReporter","): Promise {"," // Try native SQLite first (desktop Node.js only)"," if (!import.meta.env?.VSCODE_BROWSER_EXT && nativeSupport) {"," const extensionPath = extensionUri.fsPath;"," if (await nativeSupport.isNativeAvailable(extensionPath)) {"," GlobalOutputChannel?.appendLine('[SQLite Explorer] Using native SQLite backend');"," const nativeBundle = await nativeSupport.createNativeDatabaseConnection(extensionUri, _reporter);"," // Wrap the native bundle to provide fallback to WASM if file open fails"," // This handles cases where native SQLite can't access a specific file"," // (e.g., macOS sandboxing, permission issues, file locked)"," const wasmBundlePromise = createWasmDatabaseConnection(extensionUri, _reporter);"," let wasmBundle: DatabaseConnectionBundle | null = null;"," workerMethods: nativeBundle.workerMethods,"," async establishConnection(fileUri, displayName, forceReadOnly, autoCommit) {"," try {"," // Try native first"," return await nativeBundle.establishConnection(fileUri, displayName, forceReadOnly, autoCommit);"," } catch (nativeErr) {"," // Native failed - fall back to WASM"," GlobalOutputChannel?.appendLine(`[SQLite Explorer] Native file open failed, falling back to WASM: ${nativeErr instanceof Error ? nativeErr.message : String(nativeErr)}`);"," if (!wasmBundle) {"," wasmBundle = await wasmBundlePromise;"," return wasmBundle.establishConnection(fileUri, displayName, forceReadOnly, autoCommit);"," GlobalOutputChannel?.appendLine(`[SQLite Explorer] Native SQLite failed, falling back to WASM: ${err instanceof Error ? err.message : String(err)}`);"," // Fall back to WASM (sql.js)"," GlobalOutputChannel?.appendLine('[SQLite Explorer] Using WebAssembly SQLite backend');"," return createWasmDatabaseConnection(extensionUri, _reporter);"," * Create a database connection using sql.js (WebAssembly)."," * Browser VS Code runs sql.js in-process to avoid CSP-blocked workers."," * Desktop VS Code keeps sql.js in a worker thread to avoid blocking the"," * extension host during database operations.","async function createWasmDatabaseConnection("," if (import.meta.env?.VSCODE_BROWSER_EXT === true) {"," return createInProcessWasmDatabaseConnection(extensionUri);"," return createWorkerBackedWasmDatabaseConnection(extensionUri);"," * Create a browser-safe WASM database connection."," * VS Code Web enforces Trusted Types (require-trusted-types-for 'script') on the"," * browser extension host with a fixed trusted-types policy allowlist, so"," * `new Worker(blobUrl)` with a plain string URL is blocked (\"This document"," * requires 'TrustedScriptURL' assignment\") and the worker never starts. (The CSP"," * does allow worker-src 'self' blob:; the blocker is Trusted Types, not"," * worker-src. WebAssembly instantiation is permitted.) This bundle therefore runs"," * the sql.js endpoint directly in the extension host and lets thrown"," * initialization/query errors reject the original operation.","async function createInProcessWasmDatabaseConnection("," extensionUri: vsc.Uri"," const endpoint = createWorkerEndpoint();"," workerMethods: {"," ...endpoint,"," // Free the in-process sql.js WASM heap when the document is disposed."," // Unlike the Node worker path (which terminates the whole thread), the"," // browser engine lives in the extension host, so closing a database must"," // explicitly shut the engine down or its WASM memory leaks until reload."," [Symbol.dispose]: () => { endpoint.dispose(); }"," * Establish a database connection in the browser extension host."," * The browser path must read binary content through VS Code's workspace"," * filesystem because local file paths are not available in vscode.dev."," async establishConnection("," fileUri: vsc.Uri,"," displayName: string,"," forceReadOnly?: boolean,"," autoCommit?: boolean"," // Browser mode always reads database bytes through the VS Code filesystem."," // There is no file-path fast path because the web extension host cannot"," // access local disk paths directly."," const [dbContent, walContent] = await loadDatabaseFiles(fileUri);"," const hasActiveWal = !!walContent && walContent.byteLength > 0;"," // sql.js opens one main database image and cannot merge a separate WAL"," // file, so browser editing is disabled when committed WAL pages may be"," // absent from the main database bytes that save() would later overwrite."," const readOnlyMode = (forceReadOnly ?? false) || hasActiveWal;"," // Preload sql.js WASM bytes from the extension assets directory so"," // WebAssembly instantiation does not depend on worker-relative URLs."," const wasmUri = vsc.Uri.joinPath(extensionUri, 'assets', 'sqlite3.wasm');"," const wasmContent = await vsc.workspace.fs.readFile(wasmUri);"," const initConfig: DatabaseInitConfig = {"," content: dbContent,"," walContent,"," maxSize: getMaximumFileSizeBytes(),"," resourceMap: {},"," wasmBinary: wasmContent,"," readOnlyMode,"," queryTimeout: getQueryTimeout()"," const result = await endpoint.initializeDatabase(displayName, initConfig);"," const operationsFacade: DatabaseOperations = {"," engineKind: Promise.resolve('wasm'),"," executeQuery: (sql: string, params?: CellValue[]) =>"," endpoint.runQuery(sql, params),"," serializeDatabase: (name: string) => endpoint.exportDatabase(name),"," applyModifications: (mods: ModificationEntry[], signal?: AbortSignal) =>"," endpoint.applyModifications(mods, signal),"," undoModification: (mod: ModificationEntry) =>"," endpoint.undoModification(mod),"," redoModification: (mod: ModificationEntry) =>"," endpoint.redoModification(mod),"," flushChanges: (signal?: AbortSignal) =>"," endpoint.flushChanges(signal),"," discardModifications: (mods: ModificationEntry[], signal?: AbortSignal) =>"," endpoint.discardModifications(mods, signal),"," updateCell: (table: string, rowId: string | number, column: string, value: CellValue) =>"," endpoint.updateCell(table, rowId, column, value),"," insertRow: (table: string, data: Record) =>"," endpoint.insertRow(table, data),"," insertRowBatch: (table: string, rows: Record[]) =>"," endpoint.insertRowBatch(table, rows),"," deleteRows: (table: string, rowIds: (string | number)[]) =>"," endpoint.deleteRows(table, rowIds),"," deleteColumns: (table: string, columns: string[], dropDependentIndexes?: string[]) =>"," endpoint.deleteColumns(table, columns, dropDependentIndexes),"," findDependentIndexes: (table: string, columns: string[]) =>"," endpoint.findDependentIndexes(table, columns),"," createTable: (table: string, columns: ColumnDefinition[]) =>"," endpoint.createTable(table, columns),"," updateCellBatch: (table: string, updates: CellUpdate[]) =>"," endpoint.updateCellBatch(table, updates),"," addColumn: (table: string, column: string, type: string, defaultValue?: string) =>"," endpoint.addColumn(table, column, type, defaultValue),"," fetchTableData: (table: string, options: TableQueryOptions) =>"," endpoint.fetchTableData(table, options),"," fetchTableCount: (table: string, options: TableCountOptions) =>"," endpoint.fetchTableCount(table, options),"," fetchSchema: () =>"," endpoint.fetchSchema(),"," getTableInfo: (table: string) =>"," endpoint.getTableInfo(table),"," getPragmas: () =>"," endpoint.getPragmas(),"," setPragma: (pragma: string, value: CellValue) =>"," endpoint.setPragma(pragma, value),"," ping: () =>"," endpoint.ping(),"," writeToFile: (path: string) =>"," endpoint.writeToFile(path)"," databaseOps: operationsFacade,"," isReadOnly: result.isReadOnly ?? false"," * Create a Node.js WASM database connection backed by worker_threads."," * Desktop VS Code is not constrained by the browser extension host CSP, so it"," * keeps the existing worker/RPC path to avoid blocking the extension host.","async function createWorkerBackedWasmDatabaseConnection("," // Node.js environment: use file path directly"," const workerScriptPath = path.resolve(__dirname, './worker.cjs');"," const workerThread: InstanceType = new Worker(workerScriptPath);"," // Create IPC proxy for Node.js worker communication"," // Route worker log messages to the VS Code output channel for visibility."," // Falls back to console if no output channel is available (e.g., during tests)."," const logHandler = (level: 'log' | 'warn' | 'error', args: unknown[]) => {"," const text = args.map(a => typeof a === 'string' ? a : JSON.stringify(a)).join(' ');"," if (GlobalOutputChannel) {"," GlobalOutputChannel.appendLine(`[Worker/${level}] ${text}`);"," } else {"," console[level]('[Worker]', ...args);"," const workerProxy = connectWorkerPort("," {"," postMessage: (data: unknown, transfer?: Transferable[]) => {"," if (transfer) {"," workerThread.postMessage(data, transfer);"," workerThread.postMessage(data);"," on: (event: 'message', handler: (data: unknown) => void) => {"," // Node.js worker_threads uses .on() with direct message payloads."," (workerThread as unknown as { on(event: string, handler: (data: unknown) => void): void })"," .on(event, handler);"," ['initializeDatabase', 'runQuery', 'exportDatabase', 'updateCell', 'insertRow', 'insertRowBatch', 'deleteRows', 'deleteColumns', 'findDependentIndexes', 'createTable', 'updateCellBatch', 'addColumn', 'fetchTableData', 'fetchTableCount', 'fetchSchema', 'getTableInfo', 'getPragmas', 'setPragma', 'ping', 'writeToFile'],"," logHandler"," // Termination handler"," const terminateWorker = () => {"," workerThread.terminate();"," ...workerProxy,"," [Symbol.dispose]: terminateWorker"," * Establish a database connection through the worker."," * @param fileUri - Database file URI"," * @param displayName - Filename for display"," * @param forceReadOnly - Open in read-only mode"," * @param autoCommit - Commit changes immediately"," // Read database and WAL files"," // Optimization: If running in Node and file is local, pass path to worker instead of reading content here"," // This avoids blocking the extension host and transferring large buffers"," const isNode = !import.meta.env?.VSCODE_BROWSER_EXT;"," const isLocal = fileUri.scheme === 'file';"," let dbContent: Uint8Array | null = null;"," let walContent: Uint8Array | null = null;"," let filePath: string | undefined;"," if (isNode && isLocal) {"," // Check size limit first"," const maxSize = getMaximumFileSizeBytes();"," const fileStat = await vsc.workspace.fs.stat(fileUri);"," if (maxSize !== 0 && fileStat.size > maxSize) {"," throw new Error(`File size (${(fileStat.size / (1024 * 1024)).toFixed(2)} MB) exceeds the maximum allowed size (${(maxSize / (1024 * 1024)).toFixed(2)} MB). Configure 'sqliteExplorer.maxFileSize' to increase the limit.`);"," filePath = fileUri.fsPath;"," [dbContent, walContent] = await loadDatabaseFiles(fileUri);"," // Load WASM binary from assets directory"," const wasmUri = vsc.Uri.joinPath(extensionUri, 'assets', 'sqlite3.wasm');"," const wasmContent = await vsc.workspace.fs.readFile(wasmUri);"," // Initialize database configuration"," const initConfig: DatabaseInitConfig = {"," content: dbContent,"," filePath,"," walContent,"," maxSize: getMaximumFileSizeBytes(),"," resourceMap: {},"," wasmBinary: wasmContent,"," readOnlyMode: forceReadOnly ?? false,"," queryTimeout: getQueryTimeout()"," // Initialize database in worker"," // Use Transfer wrapper to zero-copy transfer the array buffers"," const transferables: Transferable[] = [];"," if (initConfig.content && initConfig.content.buffer) {"," transferables.push(initConfig.content.buffer);"," if (initConfig.walContent && initConfig.walContent.buffer) {"," transferables.push(initConfig.walContent.buffer);"," if (initConfig.wasmBinary && initConfig.wasmBinary.buffer) {"," transferables.push(initConfig.wasmBinary.buffer);"," const result = await workerProxy.initializeDatabase("," displayName,"," new Transfer(initConfig, transferables) as unknown as DatabaseInitConfig"," // Create operations facade that routes to worker"," // Helper: Wrap Uint8Array values in Transfer for zero-copy transfer to worker"," // This significantly improves performance for blob operations by avoiding buffer copying"," const wrapForTransfer = (value: CellValue): CellValue => {"," if (value instanceof Uint8Array && value.buffer) {"," return new Transfer(value, [value.buffer]) as unknown as CellValue;"," return value;"," const operationsFacade: DatabaseOperations = {"," engineKind: Promise.resolve('wasm'),"," executeQuery: (sql: string, params?: CellValue[]) =>"," workerProxy.runQuery(sql, params),"," serializeDatabase: (name: string) => workerProxy.exportDatabase(name),"," applyModifications: async () => {},"," undoModification: async () => {},"," redoModification: async () => {},"," flushChanges: async () => {},"," discardModifications: async () => {},"," updateCell: (table: string, rowId: string | number, column: string, value: CellValue) =>"," workerProxy.updateCell(table, rowId, column, wrapForTransfer(value)),"," insertRow: (table: string, data: Record) => {"," // Wrap any Uint8Array values in the data object for zero-copy transfer"," const wrappedData: Record = {};"," for (const key of Object.keys(data)) {"," wrappedData[key] = wrapForTransfer(data[key]);"," return workerProxy.insertRow(table, wrappedData);"," },"," insertRowBatch: (table: string, rows: Record[]) =>"," workerProxy.insertRowBatch(table, rows),"," deleteRows: (table: string, rowIds: (string | number)[]) =>"," workerProxy.deleteRows(table, rowIds),"," deleteColumns: (table: string, columns: string[], dropDependentIndexes?: string[]) =>"," workerProxy.deleteColumns(table, columns, dropDependentIndexes),"," findDependentIndexes: (table: string, columns: string[]) =>"," workerProxy.findDependentIndexes(table, columns),"," createTable: (table: string, columns: ColumnDefinition[]) =>"," workerProxy.createTable(table, columns),"," updateCellBatch: (table: string, updates: CellUpdate[]) => {"," // Wrap any Uint8Array values in updates for zero-copy transfer"," const wrappedUpdates = updates.map(u => ({"," ...u,"," value: wrapForTransfer(u.value)"," }));"," return workerProxy.updateCellBatch(table, wrappedUpdates);"," addColumn: (table: string, column: string, type: string, defaultValue?: string) =>"," workerProxy.addColumn(table, column, type, defaultValue),"," fetchTableData: (table: string, options: TableQueryOptions) =>"," workerProxy.fetchTableData(table, options),"," fetchTableCount: (table: string, options: TableCountOptions) =>"," workerProxy.fetchTableCount(table, options),"," fetchSchema: () =>"," workerProxy.fetchSchema(),"," getTableInfo: (table: string) =>"," workerProxy.getTableInfo(table),"," getPragmas: () =>"," workerProxy.getPragmas(),"," setPragma: (pragma: string, value: CellValue) =>"," workerProxy.setPragma(pragma, value),"," ping: () =>"," workerProxy.ping(),"," writeToFile: (path: string) =>"," workerProxy.writeToFile(path)"," databaseOps: operationsFacade,"," isReadOnly: result.isReadOnly ?? false"," // Terminate worker on connection failure to prevent leak"," terminateWorker();"," throw err;","// File Loading"," * Load database file and optional WAL file."," * @param uri - Database file URI"," * @returns Tuple of [database content, WAL content]","async function loadDatabaseFiles("," uri: vsc.Uri","): Promise<[Uint8Array | null, Uint8Array | null]> {"," // Untitled documents start empty"," if (uri.scheme === 'untitled') {"," return [new Uint8Array(), null];"," const maxSize = getMaximumFileSizeBytes();"," // Check file size"," const fileStat = await Promise.resolve(vsc.workspace.fs.stat(uri)).catch(() => ({ size: 0 }));"," if (maxSize !== 0 && fileStat.size > maxSize) {"," throw new Error(`File size (${(fileStat.size / (1024 * 1024)).toFixed(2)} MB) exceeds the maximum allowed size (${(maxSize / (1024 * 1024)).toFixed(2)} MB). Configure 'sqliteExplorer.maxFileSize' to increase the limit.`);"," // Construct WAL file URI"," const walUri = uri.with({ path: uri.path + '-wal' });"," // Read both files concurrently"," return Promise.all(["," vsc.workspace.fs.readFile(uri),"," Promise.resolve(vsc.workspace.fs.readFile(walUri)).catch(() => null)"," ]);",[2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822],{"_1109":45,"_45":2846},{"_1109":2824,"_159":2436,"_1136":2844,"_1137":2845},{"_1109":45,"_45":2843},{"_1109":2824,"_159":2436,"_1136":2841,"_1137":2842},{"_1109":45,"_45":2827},{"_1109":2824,"_159":2259,"_1136":2839,"_1137":2840},{"_1109":45,"_45":2838},{"_1109":2824,"_159":1942,"_1136":2836,"_1137":2837},{"_1109":45,"_45":2835},{"_1109":2824,"_159":1704,"_1136":2833,"_1137":2834},{"_1109":45,"_45":2832},{"_1109":2824,"_159":1534,"_1136":2830,"_1137":2831},{"_1109":45,"_45":2827},{"_1109":2824,"_159":1534,"_1136":2828,"_1137":2829},{"_1109":45,"_45":2827},{"_1109":2824,"_159":1130,"_1136":2825,"_1137":2826},{"_1109":45,"_45":2823},"\n\n**Testing / Checks**\n\n* ✅ `npm test`\n* ✅ `npx tsc --noEmit`\n* ✅ `npm run build`\n* ✅ `node - <<'NODE'\nconst fs=require('fs');\nconst p='out/extension-browser.js';\nconst text=fs.readFileSync(p,'utf8');\nconsole.log(text.includes('exports.activate') || text.includes('activate:') || /activate/.test(text));\nconsole.log(text.includes('new Worker('));\nNODE`\n* ✅ `git status --short --branch`\n* ⚠️ `manual vscode.dev edit → save → reload round-trip` — not run because this environment cannot publish/install the extension into real `vscode.dev`; that remains the external verification item noted in the trigger.","repo_file_citation",559,565," ",296,303,196,232,"\n* The added tests directly exercise WAL read-only behavior, in-process modification delegation, and the in-flight save race. ",276,286," The tracker supports that with `createCheckpointAt(position)`, translating the absolute position safely after front eviction. ",358,374,"\n* P1-C is covered by snapshotting the modification-tracker position immediately after serialization and checkpointing only that captured position after `writeFile` succeeds. ",178,198,240,254,"\n* P1-B is covered for the browser in-process WASM path: the operations facade now delegates apply/undo/redo/flush/discard calls through the endpoint, and the endpoint delegates those methods to `WasmDatabaseEngine`. ",216,235,"### Review Result\n\n* Verified the latest PR head already contains the three P1 data-integrity fixes described in the trigger, so I did **not** make additional code changes, commit, or open a new PR.\n* P1-A is covered by forcing browser WASM connections read-only when a companion WAL has content, while still passing `walContent` into initialization. ",{"_90":320,"_41":82,"_94":320,"_2849":2850,"_2851":2852,"_2853":2854,"_130":-5,"_117":2855},[81],"input_items",[2873,2874,2875,2876,2877,2878,2879,2880,2881],"external_post_config",{"_2856":2857,"_259":194,"_2858":300,"_270":-5,"_2859":253,"_2860":-5,"_2861":2862,"_2863":2864,"_2865":-5,"_2866":-5,"_2867":2868,"_2869":15,"_2870":57,"_2871":52,"_2872":15},"user_model_slug","slug",1780308906.692632,"installation_id",132708093,"pr_number","repo_id","review_trigger","comment_id",4591636854,"comment_type","issue","pr_write_guard_token","pending_pr_reaction_id","pending_comment_reaction_id",364003873,"comment_if_no_findings","comment_on_error","share_url","is_parallel_review",{"_90":483,"_94":320,"_478":2898},{"_307":308,"_309":310,"_2895":314,"_2896":127,"_316":-5,"_90":2897},{"_90":2882,"_309":2894,"_159":-5,"_2884":-5,"_2885":-5},{"_90":2882,"_309":2893,"_159":-5,"_2884":-5,"_2885":-5},{"_90":2882,"_309":2892,"_159":-5,"_2884":-5,"_2885":-5},{"_90":2882,"_309":2890,"_159":1942,"_2884":2887,"_2885":2891},{"_90":2882,"_309":2888,"_159":1942,"_2884":2887,"_2885":2889},{"_90":2882,"_309":2886,"_159":1942,"_2884":2887,"_2885":-5},{"_90":2882,"_309":2883,"_159":-5,"_2884":-5,"_2885":-5},"pull_request_comment","\n### 💡 Codex Review\n\nHere are some automated review suggestions for this pull request.\n\n**Reviewed commit:** `a1cde57272`\n \n\n

ℹ️ About Codex in GitHub

","side","line","**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Avoid checkpointing edits made during an in-flight save**\n\nBecause the checkpoint is now created after the async filesystem write, any edit that arrives after `serializeDatabase()` has produced `binaryContent` but before `writeFile()` resolves is included in `timeline.length` and marked clean here even though those bytes were not part of the file that was just saved. This is especially plausible on slow web filesystem writes or with multiple editor panes, and it can silently drop the later edit on close/reload; snapshot the checkpoint position at serialization time (and only commit that snapshot after success) or block edits while saving.\n\nUseful? React with 👍 / 👎.","RIGHT","**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Implement WASM replay before enabling web writes**\n\nWith browser write mode enabled here, every web edit uses the in-process WASM facade, but that facade currently wires `applyModifications`, `undoModification`, `redoModification`, and `discardModifications` as no-ops in `createInProcessWasmDatabaseConnection`. In vscode.dev this means Undo/Revert and hot-exit backup restore can mark the custom document state as handled while leaving the in-memory database unchanged, so users can save edits they thought were undone or lose recovered unsaved changes. Please either implement those modification operations for the browser WASM path or keep the web provider read-only until they work.\n\nUseful? React with 👍 / 👎.",56,"**_{_{![P1 Badge](https://img.shields.io/badge/P1-orange?style=flat)}} Preserve WAL contents when saving web databases**\n\nWhen a database opened from github.dev has a companion `-wal` file, `loadDatabaseFiles()` reads that WAL, but the WASM engine initialization never applies `walContent`; after this change the browser provider is writable and this line overwrites only the main database URI with the serialized in-memory DB. In that scenario, committed pages that existed only in the WAL are dropped (and the stale `-wal` may still remain), so saving an edited WAL-mode repository database can lose or corrupt existing data. Please checkpoint/merge the WAL or reject WAL-backed files before enabling write/save.\n\nUseful? React with 👍 / 👎.",365,"## Code Review\n\nThis pull request enables database editing in VS Code for Web (vscode.dev / github.dev) by allowing write mode in the browser extension host and preventing silent data loss on save failures. It updates `SupportsWriteMode` to include the browser extension host, ensures the modification tracker checkpoint is only created after successful persistence, and adds comprehensive unit tests to verify these behaviors. There are no review comments, so no feedback is provided.","\n\n\n> [!NOTE]\n> Currently processing new changes in this PR. This may take a few minutes, please wait...\n> \n>

\n>

⚙️ Run configuration

\n> \n> **Configuration used**: Organization UI\n> \n> **Review profile**: ASSERTIVE\n> \n> **Plan**: Pro\n> \n> **Run ID**: `b3ec4376-a595-45ec-9e8d-6f3ac3d44ca0`\n> \n>

\n> \n>

\n>

📥 Commits

\n> \n> Reviewing files that changed from the base of the PR and between 5cc15a168cedb86bbb9a361bf1b3e37ffef470bc and 52168984fe3fa3ddb963587bbaeffbccf3d04939.\n> \n>

\n> \n>

\n>

📒 Files selected for processing (10)

✨ Finishing Touches

\n\n

📝 Generate docstrings

\n\n- [ ] Create stacked PR\n- [ ] Commit on current branch\n\n

🧪 Generate unit tests (beta)

\n\n- [ ] Create PR with unit tests\n- [ ] Commit unit tests in branch `feat/web-edit-support`\n\n

\n\n

❤️ Share

\n\n\n_{Comment `@coderabbitai help` to get the list of available commands and usage tips.}\n\n","[vc]: #6znyuZUdZpalJH5WN1Dkhh2XkpVLuLHFAamVfeozS7c=:eyJpc01vbm9yZXBvIjp0cnVlLCJ0eXBlIjoiZ2l0aHViIiwicHJvamVjdHMiOlt7Im5hbWUiOiJzcS1saXRlLWV4cGxvcmVyIiwicHJvamVjdElkIjoicHJqX2VGbk8xeUFJaVFkMG4xVjI2Q0lwbkU3RWJiZXciLCJpbnNwZWN0b3JVcmwiOiJodHRwczovL3ZlcmNlbC5jb20vemtucHJzLXByb2plY3RzLWZkMDdiZmU0L3NxLWxpdGUtZXhwbG9yZXIvRG1IZ1Nxc2ZlZXd4NjkycmtIVDZuVjNrbWczVSIsInByZXZpZXdVcmwiOiJzcS1saXRlLWV4cGxvcmVyLWdpdC1mZWF0LXdlYi1lLTQ2NmJkMy16a25wcnMtcHJvamVjdHMtZmQwN2JmZTQudmVyY2VsLmFwcCIsIm5leHRDb21taXRTdGF0dXMiOiJQRU5ESU5HIiwibGl2ZUZlZWRiYWNrIjp7InJlc29sdmVkIjowLCJ1bnJlc29sdmVkIjowLCJ0b3RhbCI6MCwibGluayI6InNxLWxpdGUtZXhwbG9yZXItZ2l0LWZlYXQtd2ViLWUtNDY2YmQzLXprbnBycy1wcm9qZWN0cy1mZDA3YmZlNC52ZXJjZWwuYXBwIn0sInJvb3REaXJlY3RvcnkiOiJ3ZWJzaXRlIn1dfQ==\nThe latest updates on your projects. Learn more about [Vercel for GitHub](https://vercel.link/github-learn-more).\n\n| Project | Deployment | Actions | Updated (UTC) |\n| :--- | :----- | :------ | :------ |\n| [sq-lite-explorer](https://vercel.com/zknprs-projects-fd07bfe4/sq-lite-explorer) | ![Building](https://vercel.com/static/status/building.svg) [Building](https://vercel.com/zknprs-projects-fd07bfe4/sq-lite-explorer/DmHgSqsfeewx692rkHT6nV3kmg3U) | [Preview](https://sq-lite-explorer-git-feat-web-e-466bd3-zknprs-projects-fd07bfe4.vercel.app), [Comment](https://vercel.live/open-feedback/sq-lite-explorer-git-feat-web-e-466bd3-zknprs-projects-fd07bfe4.vercel.app?via=pr-comment-feedback-link) | Jun 1, 2026 10:14am |\n\n","base_ref","head_ref","pull_request_info",[2899],{"_1109":45,"_45":2900},"## All 3 P1 data-integrity findings fixed (pushed in 5216898)\n\nThanks @codex — all three were real and confirmed in code; web editing was not safe to ship without them. Fixed each:\n\n### ✅ P1-A — WAL pages dropped on save\nsql.js opens only the main DB image and can't merge a separate `-wal`, so saving a WAL-mode database would overwrite the main file and drop committed WAL pages. **Fix:** when `walContent` is non-empty, the browser connection opens **read-only** (`readOnlyMode = forceReadOnly || hasActiveWal`) — viewable, not silently corruptible. Chose the conservative guard over attempting an unsafe in-memory merge.\n\n### ✅ P1-B — undo/redo/revert/hot-exit were no-ops\nThe in-process facade wired `applyModifications`/`undoModification`/`redoModification`/`flushChanges`/`discardModifications` as `async () => {}`. **Fix:** `createWorkerEndpoint()` now exposes these, and the facade delegates to the already-implemented `WasmDatabaseEngine` methods (no reimplementation).\n\n### ✅ P1-C — checkpoint raced an in-flight save\n`createCheckpoint()` ran after the async `writeFile`, marking clean any edit that arrived during the write. **Fix:** `ModificationTracker` gains `getCurrentPosition()` / `createCheckpointAt(pos)`; `save()` snapshots the position right after `serializeDatabase()` and commits only that snapshot after a successful write. The position is absolute (accounts for front-eviction during the write).\n\n### Tests + verification\n+3 tests, each **revert-proof-verified** (fails when its fix is undone): WAL-read-only, undo-delegation, save-race-stays-dirty. `tsc --noEmit` clean · `npm test` **341/341** · build worker-free, exports `activate`. Desktop path unchanged.\n\n⚠️ Still pending: a real edit→save→reload round-trip in published vscode.dev before this is called done.",[3426,3427],[],{"_1114":1115,"_45":1116,"_1117":1118},{"_1088":3417},{"_331":3416},{"_331":2936},{"_299":300,"_291":301,"_302":303,"_304":15,"_305":57,"_306":15,"_307":308,"_309":310,"_311":263,"_312":125,"_313":314,"_315":127,"_316":317,"_318":-5,"_319":-5,"_320":2935,"_322":323,"_324":325,"_326":327,"_328":329},{"_41":121,"_191":192,"_193":194,"_195":15,"_196":197,"_198":199,"_200":2924,"_202":-5,"_203":-5,"_204":2925,"_206":197,"_207":197,"_208":2926,"_210":2927,"_212":2928,"_214":-5,"_215":216,"_217":218,"_219":220,"_221":2929,"_53":-5,"_117":223,"_224":2930,"_226":2931,"_228":229,"_230":15,"_231":15},{"_131":2917},[2911,2912,2913,2914,2915,2916],{"_146":169,"_148":163,"_150":164,"_152":161,"_154":170,"_156":157,"_158":31,"_159":-5},{"_146":168,"_148":163,"_150":164,"_152":161,"_154":165,"_156":157,"_158":31,"_159":-5},{"_146":166,"_148":163,"_150":164,"_152":161,"_154":167,"_156":157,"_158":31,"_159":-5},{"_146":162,"_148":163,"_150":164,"_152":161,"_154":165,"_156":157,"_158":31,"_159":-5},{"_146":160,"_148":149,"_150":151,"_152":161,"_154":155,"_156":157,"_158":31,"_159":-5},{"_146":147,"_148":149,"_150":151,"_152":153,"_154":155,"_156":157,"_158":31,"_159":-5},[2918,2919,2920],{"_175":2923,"_177":188},{"_175":2922,"_177":184},{"_175":2921,"_177":178},{"_179":180,"_90":181,"_117":182},{"_179":185,"_90":181,"_117":186},{"_179":189,"_90":181,"_117":190},{"_293":294,"_295":-5,"_296":-5,"_297":-5,"_298":-5},[253],{"_253":2932},{"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252},{},[],{"_234":57},{"_232":57,"_233":197},{"_41":255,"_179":256,"_257":2933,"_259":194,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":62,"_271":-5,"_272":-5,"_273":-5,"_274":-5,"_275":-5,"_276":-5,"_277":-5,"_158":278,"_279":-5,"_53":2934},{"_285":286,"_41":287,"_90":288,"_289":290,"_291":292},{"_281":15,"_282":15,"_283":15,"_284":15},{"_285":286,"_179":286,"_330":-5,"_289":290,"_41":287},[2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2987,2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056],{"_152":1067,"_454":3412},{"_152":469,"_454":3409},{"_152":1057,"_454":3406},{"_152":473,"_454":3401},{"_152":473,"_454":3397},{"_152":473,"_454":3393},{"_152":487,"_454":3388},{"_152":487,"_454":3384},{"_152":473,"_454":3381},{"_152":473,"_454":3379},{"_152":487,"_454":3375},{"_152":473,"_454":3373},{"_152":487,"_454":3369},{"_152":473,"_454":3366},{"_152":473,"_454":3364},{"_152":487,"_454":3360},{"_152":473,"_454":3358},{"_152":487,"_454":3354},{"_152":473,"_454":3351},{"_152":473,"_454":3349},{"_152":487,"_454":3343},{"_152":473,"_454":3341},{"_152":473,"_454":3339},{"_152":487,"_454":3333},{"_152":473,"_454":3331},{"_152":473,"_454":3329},{"_152":487,"_454":3322},{"_152":473,"_454":3320},{"_152":487,"_454":3316},{"_152":473,"_454":3313},{"_152":473,"_454":3311},{"_152":487,"_454":3306},{"_152":473,"_454":3304},{"_152":487,"_454":3300},{"_152":473,"_454":3297},{"_152":473,"_454":3295},{"_152":487,"_454":3289},{"_152":473,"_454":3287},{"_152":487,"_454":3283},{"_152":473,"_454":3280},{"_152":473,"_454":3278},{"_152":487,"_454":3274},{"_152":473,"_454":3272},{"_152":487,"_454":3268},{"_152":473,"_454":3265},{"_152":473,"_454":3263},{"_152":473,"_454":3261},{"_152":473,"_454":3259},{"_152":473,"_454":3257},{"_152":473,"_454":3255},{"_152":473,"_454":3253},{"_152":473,"_454":3251},{"_152":473,"_454":3249},{"_152":473,"_454":3247},{"_152":473,"_454":3245},{"_152":473,"_454":3243},{"_152":473,"_454":3241},{"_152":473,"_454":3239},{"_152":473,"_454":3237},{"_152":473,"_454":3235},{"_152":473,"_454":3233},{"_152":487,"_454":3229},{"_152":473,"_454":3226},{"_152":473,"_454":3224},{"_152":473,"_454":3222},{"_152":487,"_454":3218},{"_152":473,"_454":3215},{"_152":473,"_454":3213},{"_152":473,"_454":3211},{"_152":487,"_454":3207},{"_152":487,"_454":3203},{"_152":473,"_454":3200},{"_152":473,"_454":3198},{"_152":473,"_454":3196},{"_152":473,"_454":3194},{"_152":473,"_454":3192},{"_152":473,"_454":3190},{"_152":473,"_454":3188},{"_152":487,"_454":3184},{"_152":487,"_454":3180},{"_152":473,"_454":3177},{"_152":473,"_454":3175},{"_152":473,"_454":3173},{"_152":487,"_454":3169},{"_152":473,"_454":3167},{"_152":473,"_454":3165},{"_152":473,"_454":3163},{"_152":473,"_454":3161},{"_152":487,"_454":3157},{"_152":487,"_454":3153},{"_152":473,"_454":3150},{"_152":473,"_454":3148},{"_152":487,"_454":3144},{"_152":473,"_454":3142},{"_152":487,"_454":3138},{"_152":473,"_454":3135},{"_152":473,"_454":3133},{"_152":473,"_454":3131},{"_152":487,"_454":3127},{"_152":487,"_454":3123},{"_152":473,"_454":3120},{"_152":473,"_454":3118},{"_152":487,"_454":3109},{"_152":473,"_454":3107},{"_152":487,"_454":3103},{"_152":473,"_454":3100},{"_152":473,"_454":3098},{"_152":487,"_454":3092},{"_152":473,"_454":3090},{"_152":487,"_454":3086},{"_152":473,"_454":3083},{"_152":473,"_454":3081},{"_152":487,"_454":3077},{"_152":473,"_454":3075},{"_152":487,"_454":3071},{"_152":473,"_454":3068},{"_152":487,"_454":3066},{"_152":473,"_454":3062},{"_152":469,"_454":3060},{"_152":453,"_454":3057},{"_456":457,"_85":3058},{"_459":460,"_461":462,"_101":-5,"_41":463,"_464":3059,"_466":467,"_468":111},[],{"_468":3061,"_456":457},{"_90":472},{"_475":3063,"_456":457,"_477":463},{"_478":3064,"_480":-5,"_41":-5,"_481":482,"_94":91,"_90":483},[3065],{"_45":485,"_90":486},{"_475":3067,"_456":457,"_477":463},{"_41":490,"_481":482,"_45":485,"_90":491},{"_475":3069,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3070,"_90":497},[],{"_475":3072,"_456":457,"_477":463},{"_478":3073,"_41":501,"_495":3074,"_90":497},[],[],{"_475":3076,"_456":457,"_477":463},{"_505":506,"_507":508,"_90":509},{"_475":3078,"_456":457,"_477":463},{"_512":513,"_514":515,"_516":3079,"_518":519,"_461":31,"_520":31,"_41":506,"_521":522,"_523":524,"_468":111,"_90":525},[3080],{"_514":527,"_90":528},{"_475":3082,"_456":457,"_477":463},{"_531":532,"_505":506,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3084,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3085,"_90":497},[],{"_475":3087,"_456":457,"_477":463},{"_478":3088,"_41":542,"_495":3089,"_90":497},[],[],{"_475":3091,"_456":457,"_477":463},{"_505":546,"_507":547,"_90":509},{"_475":3093,"_456":457,"_477":463},{"_512":550,"_514":551,"_516":3094,"_518":519,"_461":31,"_520":31,"_41":546,"_521":553,"_523":524,"_468":111,"_90":525},[3095,3096,3097],{"_514":557,"_179":558,"_159":559,"_90":560},{"_514":561,"_179":562,"_159":563,"_90":560},{"_514":557,"_179":558,"_159":559,"_90":560},{"_475":3099,"_456":457,"_477":463},{"_531":566,"_505":546,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3101,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3102,"_90":497},[],{"_475":3104,"_456":457,"_477":463},{"_478":3105,"_41":573,"_495":3106,"_90":497},[],[],{"_475":3108,"_456":457,"_477":463},{"_505":577,"_507":578,"_90":509},{"_475":3110,"_456":457,"_477":463},{"_512":581,"_514":582,"_516":3111,"_518":519,"_461":31,"_520":31,"_41":577,"_521":584,"_523":524,"_468":111,"_90":525},[3112,3113,3114,3115,3116,3117],{"_514":600,"_179":601,"_159":602,"_90":560},{"_514":597,"_179":598,"_159":599,"_90":560},{"_514":594,"_179":595,"_159":596,"_90":560},{"_514":591,"_179":592,"_159":593,"_90":560},{"_514":557,"_179":558,"_159":559,"_90":560},{"_514":561,"_179":562,"_159":563,"_90":560},{"_475":3119,"_456":457,"_477":463},{"_531":605,"_505":577,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3121,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3122,"_90":497},[],{"_475":3124,"_456":457,"_477":463},{"_478":3125,"_41":612,"_495":3126,"_90":497},[],[],{"_475":3128,"_456":457,"_477":463},{"_512":616,"_514":617,"_516":3129,"_518":519,"_461":619,"_520":31,"_41":620,"_521":621,"_523":524,"_468":111,"_90":525},[3130],{"_514":623,"_90":528},{"_475":3132,"_456":457,"_477":463},{"_505":620,"_507":626,"_90":509},{"_475":3134,"_456":457,"_477":463},{"_531":629,"_505":620,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3136,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3137,"_90":497},[],{"_475":3139,"_456":457,"_477":463},{"_478":3140,"_41":636,"_495":3141,"_90":497},[],[],{"_475":3143,"_456":457,"_477":463},{"_505":640,"_507":641,"_90":509},{"_475":3145,"_456":457,"_477":463},{"_512":-5,"_514":644,"_516":3146,"_518":519,"_461":31,"_520":31,"_41":640,"_521":646,"_523":524,"_468":111,"_90":525},[3147],{"_514":648,"_90":528},{"_475":3149,"_456":457,"_477":463},{"_531":651,"_505":640,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3151,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3152,"_90":497},[],{"_475":3154,"_456":457,"_477":463},{"_478":3155,"_41":658,"_495":3156,"_90":497},[],[],{"_475":3158,"_456":457,"_477":463},{"_512":662,"_514":663,"_516":3159,"_518":519,"_461":665,"_520":31,"_41":666,"_521":667,"_523":524,"_468":111,"_90":525},[3160],{"_514":669,"_90":528},{"_475":3162,"_456":457,"_477":463},{"_505":672,"_507":673,"_90":509},{"_475":3164,"_456":457,"_477":463},{"_531":676,"_505":672,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3166,"_456":457,"_477":463},{"_505":666,"_507":680,"_90":509},{"_475":3168,"_456":457,"_477":463},{"_531":683,"_505":666,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3170,"_456":457,"_477":463},{"_512":686,"_514":687,"_516":3171,"_518":519,"_461":689,"_520":31,"_41":690,"_521":691,"_523":524,"_468":111,"_90":525},[3172],{"_514":693,"_90":528},{"_475":3174,"_456":457,"_477":463},{"_505":690,"_507":696,"_90":509},{"_475":3176,"_456":457,"_477":463},{"_531":699,"_505":690,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3178,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3179,"_90":497},[],{"_475":3181,"_456":457,"_477":463},{"_478":3182,"_41":706,"_495":3183,"_90":497},[],[],{"_475":3185,"_456":457,"_477":463},{"_512":710,"_514":711,"_516":3186,"_518":519,"_461":713,"_520":31,"_41":714,"_521":715,"_523":524,"_468":111,"_90":525},[3187],{"_514":717,"_90":528},{"_475":3189,"_456":457,"_477":463},{"_505":720,"_507":721,"_90":509},{"_475":3191,"_456":457,"_477":463},{"_531":724,"_505":720,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3193,"_456":457,"_477":463},{"_505":727,"_507":728,"_90":509},{"_475":3195,"_456":457,"_477":463},{"_531":724,"_505":727,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3197,"_456":457,"_477":463},{"_505":714,"_507":733,"_90":509},{"_475":3199,"_456":457,"_477":463},{"_531":736,"_505":714,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3201,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3202,"_90":497},[],{"_475":3204,"_456":457,"_477":463},{"_478":3205,"_41":743,"_495":3206,"_90":497},[],[],{"_475":3208,"_456":457,"_477":463},{"_512":747,"_514":748,"_516":3209,"_518":519,"_461":750,"_520":31,"_41":751,"_521":752,"_523":524,"_468":111,"_90":525},[3210],{"_514":754,"_90":528},{"_475":3212,"_456":457,"_477":463},{"_505":757,"_507":758,"_90":509},{"_475":3214,"_456":457,"_477":463},{"_531":761,"_505":757,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3216,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3217,"_90":497},[],{"_475":3219,"_456":457,"_477":463},{"_478":3220,"_41":768,"_495":3221,"_90":497},[],[],{"_475":3223,"_456":457,"_477":463},{"_505":772,"_507":773,"_90":509},{"_475":3225,"_456":457,"_477":463},{"_531":761,"_505":772,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3227,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3228,"_90":497},[],{"_475":3230,"_456":457,"_477":463},{"_478":3231,"_41":782,"_495":3232,"_90":497},[],[],{"_475":3234,"_456":457,"_477":463},{"_505":786,"_507":787,"_90":509},{"_475":3236,"_456":457,"_477":463},{"_531":790,"_505":786,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3238,"_456":457,"_477":463},{"_505":793,"_507":794,"_90":509},{"_475":3240,"_456":457,"_477":463},{"_531":790,"_505":793,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3242,"_456":457,"_477":463},{"_505":799,"_507":800,"_90":509},{"_475":3244,"_456":457,"_477":463},{"_531":790,"_505":799,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3246,"_456":457,"_477":463},{"_505":805,"_507":806,"_90":509},{"_475":3248,"_456":457,"_477":463},{"_531":790,"_505":805,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3250,"_456":457,"_477":463},{"_505":811,"_507":812,"_90":509},{"_475":3252,"_456":457,"_477":463},{"_531":790,"_505":811,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3254,"_456":457,"_477":463},{"_505":817,"_507":818,"_90":509},{"_475":3256,"_456":457,"_477":463},{"_531":790,"_505":817,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3258,"_456":457,"_477":463},{"_505":823,"_507":824,"_90":509},{"_475":3260,"_456":457,"_477":463},{"_531":790,"_505":823,"_41":-5,"_179":677,"_534":-5,"_90":535},{"_475":3262,"_456":457,"_477":463},{"_505":751,"_507":829,"_90":509},{"_475":3264,"_456":457,"_477":463},{"_531":832,"_505":751,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3266,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3267,"_90":497},[],{"_475":3269,"_456":457,"_477":463},{"_478":3270,"_41":839,"_495":3271,"_90":497},[],[],{"_475":3273,"_456":457,"_477":463},{"_505":843,"_507":844,"_90":509},{"_475":3275,"_456":457,"_477":463},{"_512":847,"_514":848,"_516":3276,"_518":519,"_461":31,"_520":31,"_41":843,"_521":850,"_523":524,"_468":111,"_90":525},[3277],{"_514":852,"_159":853,"_854":855,"_90":856},{"_475":3279,"_456":457,"_477":463},{"_531":859,"_505":843,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3281,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3282,"_90":497},[],{"_475":3284,"_456":457,"_477":463},{"_478":3285,"_41":866,"_495":3286,"_90":497},[],[],{"_475":3288,"_456":457,"_477":463},{"_505":870,"_507":871,"_90":509},{"_475":3290,"_456":457,"_477":463},{"_512":874,"_514":875,"_516":3291,"_518":519,"_461":31,"_520":31,"_41":870,"_521":877,"_523":524,"_468":111,"_90":525},[3292,3293,3294],{"_514":591,"_179":592,"_159":593,"_90":560},{"_514":557,"_179":558,"_159":559,"_90":560},{"_514":561,"_179":562,"_159":563,"_90":560},{"_475":3296,"_456":457,"_477":463},{"_531":883,"_505":870,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3298,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3299,"_90":497},[],{"_475":3301,"_456":457,"_477":463},{"_478":3302,"_41":890,"_495":3303,"_90":497},[],[],{"_475":3305,"_456":457,"_477":463},{"_505":894,"_507":895,"_90":509},{"_475":3307,"_456":457,"_477":463},{"_512":898,"_514":899,"_516":3308,"_518":519,"_461":31,"_520":31,"_41":894,"_521":901,"_523":524,"_468":111,"_90":525},[3309,3310],{"_514":600,"_179":601,"_159":602,"_90":560},{"_514":904,"_159":905,"_854":906,"_90":856},{"_475":3312,"_456":457,"_477":463},{"_531":909,"_505":894,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3314,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3315,"_90":497},[],{"_475":3317,"_456":457,"_477":463},{"_478":3318,"_41":916,"_495":3319,"_90":497},[],[],{"_475":3321,"_456":457,"_477":463},{"_505":920,"_507":921,"_90":509},{"_475":3323,"_456":457,"_477":463},{"_512":924,"_514":925,"_516":3324,"_518":519,"_461":31,"_520":31,"_41":920,"_521":927,"_523":524,"_468":111,"_90":525},[3325,3326,3327,3328],{"_514":932,"_179":595,"_159":596,"_90":560},{"_514":597,"_179":598,"_159":599,"_90":560},{"_514":600,"_179":601,"_159":602,"_90":560},{"_514":594,"_179":595,"_159":596,"_90":560},{"_475":3330,"_456":457,"_477":463},{"_531":935,"_505":920,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3332,"_456":457,"_477":463},{"_505":938,"_507":939,"_90":509},{"_475":3334,"_456":457,"_477":463},{"_512":942,"_514":943,"_516":3335,"_518":519,"_461":31,"_520":31,"_41":938,"_521":945,"_523":524,"_468":111,"_90":525},[3336,3337,3338],{"_514":951,"_179":601,"_159":602,"_90":560},{"_514":950,"_179":598,"_159":599,"_90":560},{"_514":949,"_179":595,"_159":596,"_90":560},{"_475":3340,"_456":457,"_477":463},{"_531":954,"_505":938,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3342,"_456":457,"_477":463},{"_505":957,"_507":958,"_90":509},{"_475":3344,"_456":457,"_477":463},{"_512":961,"_514":962,"_516":3345,"_518":519,"_461":31,"_520":31,"_41":957,"_521":964,"_523":524,"_468":111,"_90":525},[3346,3347,3348],{"_514":970,"_179":595,"_159":596,"_90":560},{"_514":969,"_179":598,"_159":599,"_90":560},{"_514":968,"_179":601,"_159":602,"_90":560},{"_475":3350,"_456":457,"_477":463},{"_531":973,"_505":957,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3352,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3353,"_90":497},[],{"_475":3355,"_456":457,"_477":463},{"_478":3356,"_41":980,"_495":3357,"_90":497},[],[],{"_475":3359,"_456":457,"_477":463},{"_505":984,"_507":985,"_90":509},{"_475":3361,"_456":457,"_477":463},{"_512":988,"_514":989,"_516":3362,"_518":519,"_461":31,"_520":31,"_41":984,"_521":991,"_523":524,"_468":111,"_90":525},[3363],{"_514":993,"_90":528},{"_475":3365,"_456":457,"_477":463},{"_531":996,"_505":984,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3367,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3368,"_90":497},[],{"_475":3370,"_456":457,"_477":463},{"_478":3371,"_41":1003,"_495":3372,"_90":497},[],[],{"_475":3374,"_456":457,"_477":463},{"_505":1007,"_507":1008,"_90":509},{"_475":3376,"_456":457,"_477":463},{"_512":1011,"_514":1012,"_516":3377,"_518":519,"_461":31,"_520":1014,"_41":1007,"_521":1015,"_523":524,"_468":1016,"_90":525},[3378],{"_514":1018,"_90":528},{"_475":3380,"_456":457,"_477":463},{"_531":1021,"_505":1007,"_41":-5,"_179":533,"_534":-5,"_90":535},{"_475":3382,"_456":457,"_477":463},{"_478":-5,"_494":-5,"_41":-5,"_495":3383,"_90":497},[],{"_475":3385,"_456":457,"_477":463},{"_478":3386,"_41":1028,"_495":3387,"_90":497},[],[],{"_475":3389,"_456":457,"_477":463},{"_478":3390,"_41":1033,"_90":1034},[3391],{"_45":1036,"_1037":3392,"_90":45},[],{"_475":3394,"_456":457,"_477":463},{"_478":3395,"_480":-5,"_41":-5,"_481":-5,"_94":320,"_90":483},[3396],{"_45":1036,"_90":1043},{"_475":3398,"_456":457,"_477":463},{"_478":3399,"_480":-5,"_41":-5,"_481":-5,"_94":320,"_90":483},[3400],{"_45":1048,"_90":1043},{"_475":3402,"_456":457,"_477":463},{"_478":3403,"_480":-5,"_41":-5,"_481":-5,"_94":1052,"_90":483},[3404,3405],{"_45":1056,"_90":1043},{"_45":1055,"_90":1043},{"_456":457,"_85":3407},{"_101":-5,"_41":463,"_464":3408,"_466":467,"_468":1061},[],{"_468":3410,"_456":457},{"_1064":3411,"_90":1066},[],{"_1069":3413},{"_1071":-5,"_1072":-5,"_1073":1074,"_1075":467,"_518":519,"_1076":15,"_1077":-5,"_1078":-5,"_41":457,"_1079":1080,"_179":-5,"_159":1081,"_1082":197,"_523":1083,"_468":3414,"_75":3415,"_1086":467},{"_90":472},[],[],[3418],{"_41":1091,"_1092":3419,"_1094":1095,"_1096":1095,"_478":3420,"_468":1098,"_480":-5,"_1099":31,"_1100":3421,"_1102":1103,"_1104":-5},{"_94":320,"_179":-5,"_1100":3425},{"_1109":45,"_1110":3424},{"_1105":3422},{"_1107":3423},[],[1112],{},{"_90":483,"_94":91,"_478":3453},{"_90":1121,"_1122":3428},[3429,3430,3431,3432,3433,3434],{"_159":2436,"_1131":-5,"_1132":3450,"_1134":-5},{"_159":2259,"_1131":-5,"_1132":3447,"_1134":-5},{"_159":1942,"_1131":-5,"_1132":3444,"_1134":-5},{"_159":1704,"_1131":-5,"_1132":3441,"_1134":-5},{"_159":1534,"_1131":-5,"_1132":3438,"_1134":-5},{"_159":1130,"_1131":-5,"_1132":3435,"_1134":-5},[3436],{"_1136":1014,"_1137":1138,"_478":3437,"_1140":57},[1141,1142,1143,1144,1145,1146,1147,1148,1149,197,1150,1151,197,1152,1153,1154,1155,1156,1157,1158,1159,197,1160,1161,1162,1163,197,1164,1165,1166,1167,1168,1158,1169,1170,1158,1171,1172,197,1173,1174,1175,1176,1177,1178,197,1179,1180,197,1181,1182,1183,1184,1185,1186,197,1187,1188,1189,1190,1191,197,1192,1193,1194,1195,1196,1197,1198,1194,1195,1196,1199,1200,1194,1195,1196,197,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1207,1208,1209,1212,1213,1207,1208,1209,1158,1214,1215,197,1216,1217,1218,1219,1220,197,1221,1222,1223,1224,197,1225,1226,1227,1228,1196,197,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1214,197,1240,1241,1242,1243,1158,1244,1214,197,1245,1246,1226,1227,1228,1196,1214,197,1247,1248,1249,1250,1251,1252,1253,1254,197,1255,1256,1257,1258,1259,1238,1239,197,1260,1261,1158,197,1262,1263,1264,1265,1266,1238,1196,197,1267,1268,1269,1172,197,1270,1271,1272,1214,197,1273,1274,1275,1214,197,1276,1277,1278,1214,197,1279,1280,1281,1282,1283,1214,197,1284,1285,1286,1287,1214,1215,197,197,197,197,1288,1289,197,1245,1290,1230,1291,1292,1293,1238,1196,197,1231,1232,1233,1234,1235,1236,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1238,1239,197,1308,1309,1214,197,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1239,1321,1172,197,1322,1323,1324,1313,1314,1315,1316,1325,1326,1320,1239,1172,197,1327,1328,1329,1330,1331,1332,1333,1239,197,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1172,197,1344,1345,1346,1347,1348,1349,1350,1351,1238,1239,197,1352,197,1353,197,1354,1355,197,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1362,1366,1367,197,1368,1369,1370,1371,1372,1373,1374,1238,1239,197,1201,1375,197,1376,1377,1378,1379,1204,1380,1381,1158,1214,197,1382,1345,1346,1347,1348,1349,1350,1351,1238,1239,197,1352,197,1355,197,1356,1357,1358,1359,1383,1362,1363,1364,1365,1362,1366,1367,197,1368,1369,1370,1371,1372,1373,1374,1238,1239,197,1201,1384,197,1376,1378,1379,1204,1380,1381,1158,1214,197,1385,1386,1387,1355,197,1346,1347,1388,1389,1390,1391,1238,1239,197,1392,197,1356,1357,1358,1363,1364,1393,1394,1362,1366,1367,197,1201,1384,197,1395,1379,1204,1380,1158,1214,197,1396,1386,1397,197,1346,1347,1398,1239,197,1392,1399,1400,1401,1402,1403,1404,1405,1406,1407,1196,197,1356,1357,1358,1363,1408,1409,1410,1411,1362,1366,1367,197,1201,1412,1413,1414,1415,197,1416,197,1417,1418,1419,1420,1421,1204,1380,1158,1214,197,1422,1386,1423,1424,1425,1426,1196,1427,1428,1196,197,1429,1430,1431,1432,1403,1404,1405,1433,1434,1239,1435,1436,1437,1432,1403,1438,1405,1439,1440,1239,1441,197,1346,1347,1442,1443,1444,1238,1239,197,1392,1445,197,1356,1357,1358,1363,1393,1446,1447,1448,1362,1366,1367,197,1201,1449,1450,197,1451,1452,1453,197,1454,197,1455,1204,1380,1158,1214,1215,197,197,1456,1457,1458,1459,1460,197,1245,1461,1462,197,1463,1464,1465,1466,1209,1467,1239,197,1468,1469,1330,1470,1471,1239,197,1472,1473,1239,197,1230,1231,1232,1233,1234,1235,1236,1474,1475,1476,1477,1478,1301,1479,1296,1480,1481,1482,1483,1484,1485,1486,1410,1238,1239,197,1214,197,1487,1488,1489,1214,197,1490,1491,1492,1493,1494,1238,1239,197,1495,1496,1497,197,1498,1499,197,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1410,1510,1158,197,1511,1512,1513,1196,197,1399,1514,1515,1516,1517,1196,197,1518,197,1519,197,1520,1214,197,1521,1491,1492,1522,1494,1238,1239,197,1497,1498,1499,197,1523,1501,1502,1524,1504,1525,1507,1526,1527,1410,1510,1158,197,1528,1511,1512,1513,1529,1196,197,1399,1514,1515,1516,1517,1196,197,1530,197,1531,1532,197,1533,1214,1215],[3439],{"_1136":1014,"_1137":1537,"_478":3440,"_1140":57},[1141,197,1539,1143,1144,1145,1146,1147,1148,1540,197,1541,1542,197,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1180,197,1556,1557,1558,1559,1560,1561,1178,1562,197,1563,1564,1565,1566,197,1567,1568,1569,1570,1571,1572,1573,1178,1574,1571,1575,1576,1577,1578,1579,1158,1573,1178,1580,1571,1581,1582,1583,1584,1158,1573,1178,1585,1571,1586,1587,1573,1178,1588,1589,1178,1590,1591,197,1592,1593,1594,1595,1596,1597,197,1598,1599,1591,1180,197,1600,1601,1602,1603,197,1604,1605,1606,1607,1608,1609,1610,1584,1611,1612,1584,1613,1158,1614,1615,1616,1214,1617,197,1618,1619,1620,1621,1622,197,1623,1624,1625,1626,1614,1627,1628,1629,1630,1614,1631,1632,1633,1614,1634,1635,1614,1636,1172,197,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,197,1649,1650,197,1651,1652,1653,1654,197,1655,1656,1657,1658,197,1659,1660,1661,1617,197,1662,1602,1663,1603,1619,197,1604,1605,1606,1607,1608,1609,1664,1584,1611,1612,1584,1613,1158,1614,1615,1616,1214,197,1623,1624,1625,1665,1614,1627,1628,1666,1667,1668,1636,1172,197,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,197,1649,1650,197,1669,1670,1671,1617,197,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1172,1683,197,1623,1684,1627,1628,1685,1686,1687,1688,1614,1689,1690,1691,1614,1692,1690,1693,1614,1694,1687,1695,1614,1696,1686,1687,1697,1614,1666,1667,1668,1636,1172,197,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,197,1649,1650,197,1698,1699,1700,1701,1702,197,1703,1617,1215],[3442],{"_1136":1014,"_1137":1707,"_478":3443,"_1140":57},[1709,1710,1711,1712,1713,1714,197,1715,197,1716,1717,1716,197,1709,1718,1719,1711,1720,1721,1722,1714,1723,1724,1725,1726,1727,1728,1729,1730,1597,1731,1180,197,1709,1732,1733,1714,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1158,1746,1747,1178,1597,1731,1180,197,1709,1748,1711,1749,1750,1714,1751,1752,1753,1754,197,1755,1756,197,1757,1758,1178,197,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1747,1770,197,1771,1762,197,1772,1773,1774,1158,1741,1775,1776,1777,1778,1779,1584,1158,1747,1178,1597,1780,1180,197,1716,1781,1716,197,1709,1782,1714,1783,1784,1785,1786,1787,1788,1789,1790,1791,1180,197,1716,1792,1716,197,1709,1793,1711,1794,1795,1796,1711,1797,1714,1798,1799,1800,1801,1802,197,1803,1804,197,1805,1806,1807,1808,197,1809,1810,1811,1812,1813,1814,1815,1816,1817,1597,197,1809,1818,1811,1819,1820,1811,1821,1814,1822,1823,1824,197,1825,1826,1827,197,1828,1829,1830,197,1831,1832,1833,1834,197,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1747,197,1845,1846,197,1847,1848,1747,197,1849,1850,1851,1178,1597,197,1809,1852,1811,1853,1814,1854,1855,1856,197,1857,1858,1859,1860,1178,1861,1597,197,1809,1862,1811,1863,1814,1864,1865,1866,197,1857,1867,1868,1869,1178,1861,1597,197,1809,1870,1811,1871,1814,1872,1873,1597,197,1809,1874,1814,1875,1876,1597,197,1809,1877,1811,1878,1879,1814,1880,1881,1597,197,1809,1882,1811,1883,1884,1814,1885,1886,1887,1597,197,1809,1888,1811,1889,1814,1890,1891,1597,197,1809,1892,1893,1814,1894,1895,1896,1897,1898,197,1899,1900,1178,1597,197,1809,1901,1902,1811,1903,1814,1904,1905,1906,1907,1172,1908,1909,1910,1597,197,1809,1911,1912,1811,1913,1914,1915,1916,1814,1917,1918,1919,1920,1921,1922,1923,1924,197,1925,1926,1927,197,1928,1929,1930,197,1931,1597,197,1809,1932,1814,1933,1934,1597,197,1809,1935,1814,1936,1937,1597,197,1809,1938,1814,1939,1940,1597,1180,197,1716,1941,1716],[3445],{"_1136":1014,"_1137":1945,"_478":3446,"_1140":57},[1709,1947,1711,1948,1949,1714,197,1950,1951,197,1952,197,1953,1954,1955,1956,1957,1958,197,1959,1960,1961,197,1962,1963,1964,197,1716,1965,1716,197,1709,1966,1714,1967,197,1716,1968,1716,197,1969,1970,197,1971,1972,197,1973,1974,197,1975,1976,1977,1978,197,1979,1980,197,1716,1981,1716,197,1982,1983,197,1984,1985,197,1709,1986,1714,1987,1988,1989,1990,1180,197,1709,1991,1714,1992,1988,1993,1180,197,1716,1994,1716,197,1709,1995,1711,1996,1997,1998,1999,2000,2001,1714,2002,2003,2004,197,1809,2005,1814,2006,2007,2008,2009,2010,2011,2012,2013,197,2014,2015,197,2016,2017,197,2018,2019,197,2020,2021,2022,2023,2024,2025,2026,2027,2028,197,2029,2030,2031,2032,2033,2034,2035,1178,197,2036,2037,2038,2039,2040,2041,2042,2043,2035,197,2044,2045,2046,2047,2048,1343,2049,2050,2051,2052,2053,2054,2055,2056,2057,1584,1343,2058,1747,1178,197,2059,2060,2022,2061,2062,2063,2064,2065,2066,2026,1597,197,2067,2068,2069,1597,197,2070,2071,2072,197,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,1597,197,2088,2089,2090,2091,197,2092,2093,2092,197,2094,2095,197,2096,2097,197,2098,2099,2100,2101,2102,2103,2104,2105,197,2092,2106,2092,197,2107,2108,2109,2110,2111,2112,1597,197,2092,2113,2092,197,1809,2114,1814,2115,2116,2117,197,2118,2119,197,2120,2121,2122,2123,2124,2125,2126,1158,1201,2127,2128,2129,2130,2131,2132,1158,1614,2133,2134,2135,2136,2126,1158,1201,2137,2128,2129,2130,2138,2139,1158,1747,1214,197,2140,1597,197,1809,2141,1814,2142,2143,2144,1597,197,2092,2145,2092,197,2146,2147,2148,2149,1178,1591,197,1809,2150,1811,2151,2152,1811,2153,1814,2154,2155,197,2156,2157,2158,2159,2160,2044,2161,2049,2162,2163,2164,1747,2165,2166,1178,197,2167,2168,2169,1201,2170,2171,2126,2130,2172,2173,1158,1178,197,2174,2175,2176,2177,2178,2179,1173,2180,2181,2182,2183,1178,2184,2185,2186,2187,2188,1597,197,1809,2189,1814,2190,2155,197,2191,1201,2192,2193,2126,2130,2194,1158,1178,197,2195,2196,2197,1178,197,2174,2175,2198,1597,197,1809,2199,1814,2200,2155,2201,2202,2203,2204,2205,2026,2144,2140,1597,197,2092,2206,2092,197,2207,1173,2208,2209,2210,1504,2211,1158,1747,2181,2212,2213,2214,2215,1178,1597,197,2216,2217,2218,1597,197,2219,2220,2221,1597,197,2222,2223,2224,1597,197,2092,2225,2092,197,2226,2227,1597,197,2228,2229,1597,197,2230,2231,2232,1597,197,1809,2233,1814,2234,2235,197,2236,2237,2238,2239,2035,2240,2241,2242,1573,2243,1178,197,2244,1597,197,2092,2245,2092,197,2246,2247,2248,2249,2250,2251,197,2252,2253,2254,1201,2255,2256,2257,2258,1158,1747,1172,1597,1180],[3448],{"_1136":1014,"_1137":2262,"_478":3449,"_1140":57},[1709,2264,1711,2265,2266,2267,2268,1711,2269,2270,1714,197,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,197,2291,2292,197,1716,2293,1716,197,1709,2294,1711,2295,2296,1714,2297,2298,2299,2300,2301,197,2302,2303,2304,2305,2306,2307,1597,197,2308,197,2309,2310,2311,197,2312,2313,2044,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,1584,2324,2325,1747,1597,197,2326,2327,2328,197,2329,2330,2331,197,2332,197,2333,2334,2335,2336,2337,2338,1597,197,2339,197,2340,2341,2342,1591,1180,197,1716,2343,1716,197,1709,2344,1711,2345,2346,1714,2347,2348,197,2349,2350,2351,1597,197,2340,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,1747,197,2366,2367,197,2368,2369,1571,2242,1573,2370,197,2352,2371,2354,2372,2373,2374,2358,2375,2376,2370,197,2352,2377,2354,2378,2379,2358,2380,2381,2370,197,2382,2383,2384,2385,2370,197,2386,2387,2370,197,2388,2389,2370,197,2390,2391,2370,197,2392,2393,2370,197,2394,2395,2370,197,2396,2397,2370,197,2398,2399,2370,197,2400,2401,2370,197,2402,2403,2370,197,2404,2405,2370,197,2406,2407,2370,197,2408,2409,2370,197,2410,2411,2370,197,2412,2413,2370,197,2414,2415,2370,197,2416,2417,2370,197,2418,2419,2370,197,2420,2421,2370,197,2422,2423,2370,197,2424,2425,2426,2370,197,2427,2428,2370,197,2352,2429,2354,2430,2431,2432,2433,2358,2434,2364,2365,2435,1747,1178,1591,1180],[3451],{"_1136":1014,"_1137":2439,"_478":3452,"_1140":57},[1709,2441,1711,2442,2443,1711,2444,2445,2446,1714,197,1950,197,1952,2447,197,2448,1961,2271,2272,2274,2449,2450,2275,2276,2277,2282,2278,2279,2280,2451,2452,197,2453,2454,2455,2456,197,2457,2458,2459,2460,2461,197,2462,2463,1592,2464,2465,2466,2467,1597,1180,197,1716,2468,1716,197,1709,2469,1714,2470,2471,2472,2473,2474,2475,1546,1552,1553,2476,2477,2478,2479,2480,1554,2481,2482,2483,2484,2485,2486,2487,1555,2488,1180,197,1716,2489,1716,197,1709,2490,1711,2491,2492,1711,2493,2494,2495,2496,1711,2497,2498,2499,1714,2500,2501,2502,2503,2504,2505,2506,2507,2044,2508,2509,197,2510,2511,2512,2513,2514,197,1323,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2322,2525,1238,1584,1239,2049,2526,1747,1178,1597,197,2527,2528,2529,1180,197,1709,2530,1711,2531,2532,2533,1711,2497,2498,2499,1714,2534,2501,2502,2503,2535,2536,1597,197,2537,1180,197,1709,2538,1711,2539,2540,2541,2542,2543,2544,2545,2546,1714,2547,2548,2503,2549,197,2340,2550,2551,2552,2553,2554,2555,2556,2370,197,2352,2557,2354,2558,2559,2358,2560,2561,2562,2563,2564,1840,2565,2566,2567,2568,2569,2570,2571,2572,2573,197,2574,2575,2576,2577,197,2578,2579,2580,2581,2582,2583,2584,2585,1573,197,2586,197,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,1573,197,1571,2636,2637,1573,1178,1591,1180,197,1709,2638,1711,2639,2640,1714,2641,2548,2503,2642,2643,2644,197,2645,2646,2647,2648,2649,2650,2651,2652,2653,1178,1591,197,2654,2655,2656,2657,2658,1504,2659,1158,1614,2660,2661,2662,2663,1747,2370,2664,2665,2104,197,2666,2667,2668,1591,197,2340,2550,2669,2670,2370,197,2352,2671,2354,2672,2673,2674,2675,2357,2358,2560,2561,2562,2563,2564,1840,2044,2676,2677,2678,2679,2680,197,2681,2682,2683,197,2684,2685,2686,2687,2688,2689,1373,2690,1238,1504,2691,1158,197,2692,2693,2694,197,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,1239,197,2705,2706,2707,2708,2709,1158,2710,2711,1158,2712,2713,1158,197,2714,2715,2716,1343,197,2717,2718,2719,2720,2721,2722,1584,2723,1239,197,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,1238,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2742,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,1239,197,1323,2778,2779,1239,2049,2780,2781,2782,1747,1178,1591,1180,197,1716,2783,1716,197,1709,2784,1711,2785,2786,1714,2787,2788,2789,2790,2791,2792,1597,197,2793,197,2794,2795,2796,2797,1597,197,2798,2799,197,2800,2801,2802,2803,2804,1180],[3454,3455,3456,3457,3458,3459,3460,3461,3462,3463,3464,3465,3466,3467,3468,3469,3470],{"_1109":45,"_45":2846},{"_1109":2824,"_159":2436,"_1136":2844,"_1137":2845},{"_1109":45,"_45":2843},{"_1109":2824,"_159":2436,"_1136":2841,"_1137":2842},{"_1109":45,"_45":2827},{"_1109":2824,"_159":2259,"_1136":2839,"_1137":2840},{"_1109":45,"_45":2838},{"_1109":2824,"_159":1942,"_1136":2836,"_1137":2837},{"_1109":45,"_45":2835},{"_1109":2824,"_159":1704,"_1136":2833,"_1137":2834},{"_1109":45,"_45":2832},{"_1109":2824,"_159":1534,"_1136":2830,"_1137":2831},{"_1109":45,"_45":2827},{"_1109":2824,"_159":1534,"_1136":2828,"_1137":2829},{"_1109":45,"_45":2827},{"_1109":2824,"_159":1130,"_1136":2825,"_1137":2826},{"_1109":45,"_45":2823},[3473,3474,3475,3476,3477,3478,3479,3480,3481],{"_2856":2857,"_259":194,"_2858":300,"_270":-5,"_2859":253,"_2860":-5,"_2861":2862,"_2863":2864,"_2865":-5,"_2866":-5,"_2867":2868,"_2869":15,"_2870":57,"_2871":52,"_2872":15},{"_90":483,"_94":320,"_478":3482},{"_307":308,"_309":310,"_2895":314,"_2896":127,"_316":-5,"_90":2897},{"_90":2882,"_309":2894,"_159":-5,"_2884":-5,"_2885":-5},{"_90":2882,"_309":2893,"_159":-5,"_2884":-5,"_2885":-5},{"_90":2882,"_309":2892,"_159":-5,"_2884":-5,"_2885":-5},{"_90":2882,"_309":2890,"_159":1942,"_2884":2887,"_2885":2891},{"_90":2882,"_309":2888,"_159":1942,"_2884":2887,"_2885":2889},{"_90":2882,"_309":2886,"_159":1942,"_2884":2887,"_2885":-5},{"_90":2882,"_309":2883,"_159":-5,"_2884":-5,"_2885":-5},[3483],{"_1109":45,"_45":2900},"task_e_6a1d5ba659e88327912cc431e76589f5",1780308902.351284,"Github Mention: feat(web): enable database editing in VS Code for Web (1.5.0)","has_generated_title","has_unread_turn","denormalized_metadata",{"_3515":31,"_3516":3517,"_3518":-5,"_3519":-5,"_3510":3520,"_3521":-5,"_3522":-5,"_3523":-5,"_3524":-5},"task_status_display",{"_3503":3504,"_3505":194,"_128":125,"_3506":-5,"_3507":3508},"creator_workspace","external_pull_requests",[3496],{"_41":3497,"_3498":81,"_3499":3500,"_3501":127},"github-1138503946-424","assistant_turn_id","pull_request",{"_299":300,"_291":301,"_302":303,"_304":15,"_305":57,"_306":15,"_307":308,"_309":310,"_311":263,"_312":125,"_313":314,"_315":127,"_316":317,"_318":-5,"_319":-5,"_320":3502,"_322":323,"_324":325,"_326":327,"_328":329},"codex_updated_sha",{"_285":286,"_179":286,"_330":-5,"_289":290,"_41":287},"latest_turn_status_display",{"_3509":81,"_110":111,"_3510":-5,"_92":3511,"_3512":-5,"_3513":-5,"_3514":3508,"_112":-5},"environment_label","fix_task_id","initial_intent","pr","turn_id","diff_stats",[],"image_asset_pointer_citations","issue_counts","intent","num_follow_ups","repo_name_map",{},"last_user_turn_created_at","last_turn_status",{"_3525":-5,"_3526":-5,"_3527":-5},"last_pushed_turn_id","start_branch_name","pushed_branch_name","cached_pull_request_data","files_modified","lines_added","lines_removed","dd",{"_3539":3540,"_3541":3542},"disablePrefetch","shouldPrefetchAccount","shouldPrefetchUser","shouldPrefetchSystemHints","promoteCss","disableSSR","stripModulepreloadImports","statsigGateEvaluationsPromise",["P",3538],"traceId","10156626246040296772","traceTime",1780915142983]