⚠️ Definition of Done: this issue must be completed in full, in a single PR. Do not split this
work across multiple PRs, and do not defer any Deliverable below to a follow-up issue. A PR that
satisfies only some of the Deliverables, stubs a required test, or leaves a checkbox
partially-done does NOT resolve this issue and will be closed.
Context
packages/loopover-miner/lib/contribution-profile-cache.ts:36-43 and packages/loopover-miner/lib/ranked-candidates.ts:26-29 are real, actively-used SQLite stores (contribution-profile-cache.sqlite3 / ranked-candidates.sqlite3, each with its own LOOPOVER_MINER_*_DB env override). Both are correctly wired into migrate-cli.ts and status.ts's doctor sweep, but neither appears in packages/loopover-miner/README.md:106-129's "Local storage" table, its hardcoded regression test test/unit/miner-local-store-readme.test.ts:9-25, or packages/loopover-miner/DEPLOYMENT.md:49-80's file listing (which claims "all eighteen" at line 73 but only enumerates 16). deployment-docs-audit.ts:128-134 explicitly excludes the _DB env-var family from its reverse-drift check, which is exactly why this slipped past CI.
Requirements
Add both contribution-profile-cache.sqlite3 and ranked-candidates.sqlite3 as rows to README.md's "Local storage" table (matching the existing row shape: filename, purpose, env override), update the hardcoded array in test/unit/miner-local-store-readme.test.ts to include both, and add their two lines to DEPLOYMENT.md's file listing (correcting "all eighteen" to the real count).
Deliverables
All of the above Deliverables are required in the same PR unless the deliverable text itself states otherwise.
Test Coverage Requirements
Docs-only change; the existing miner-local-store-readme.test.ts regression test is the enforcement mechanism -- it must pass with both new entries added, and must fail if either is removed again.
Expected Outcome
An operator reading README.md or DEPLOYMENT.md sees a complete, accurate list of every local SQLite store the miner creates, matching what migrate-cli.ts and status.ts's doctor sweep actually manage.
Links & Resources
packages/loopover-miner/lib/contribution-profile-cache.ts:36-43
packages/loopover-miner/lib/ranked-candidates.ts:26-29
packages/loopover-miner/README.md:106-129
packages/loopover-miner/DEPLOYMENT.md:49-80
test/unit/miner-local-store-readme.test.ts:9-25
Context
packages/loopover-miner/lib/contribution-profile-cache.ts:36-43andpackages/loopover-miner/lib/ranked-candidates.ts:26-29are real, actively-used SQLite stores (contribution-profile-cache.sqlite3/ranked-candidates.sqlite3, each with its ownLOOPOVER_MINER_*_DBenv override). Both are correctly wired intomigrate-cli.tsandstatus.ts's doctor sweep, but neither appears inpackages/loopover-miner/README.md:106-129's "Local storage" table, its hardcoded regression testtest/unit/miner-local-store-readme.test.ts:9-25, orpackages/loopover-miner/DEPLOYMENT.md:49-80's file listing (which claims "all eighteen" at line 73 but only enumerates 16).deployment-docs-audit.ts:128-134explicitly excludes the_DBenv-var family from its reverse-drift check, which is exactly why this slipped past CI.Requirements
Add both
contribution-profile-cache.sqlite3andranked-candidates.sqlite3as rows to README.md's "Local storage" table (matching the existing row shape: filename, purpose, env override), update the hardcoded array intest/unit/miner-local-store-readme.test.tsto include both, and add their two lines toDEPLOYMENT.md's file listing (correcting "all eighteen" to the real count).Deliverables
contribution-profile-cache.sqlite3andranked-candidates.sqlite3with purpose + env override columns filled intest/unit/miner-local-store-readme.test.ts's hardcoded array includes both filenames and the test passesAll of the above Deliverables are required in the same PR unless the deliverable text itself states otherwise.
Test Coverage Requirements
Docs-only change; the existing
miner-local-store-readme.test.tsregression test is the enforcement mechanism -- it must pass with both new entries added, and must fail if either is removed again.Expected Outcome
An operator reading README.md or DEPLOYMENT.md sees a complete, accurate list of every local SQLite store the miner creates, matching what
migrate-cli.tsandstatus.ts's doctor sweep actually manage.Links & Resources
packages/loopover-miner/lib/contribution-profile-cache.ts:36-43packages/loopover-miner/lib/ranked-candidates.ts:26-29packages/loopover-miner/README.md:106-129packages/loopover-miner/DEPLOYMENT.md:49-80test/unit/miner-local-store-readme.test.ts:9-25