outputs/db_chain_api_final.md

# DB + Chain + API Audit — Final Report

**Iterations run:** 3
**Total checks per iteration:** 140

## Summary (last iteration)

- Passed: **127 / 140**
- Failed: 13
- Critical failures: 0
- Wall time: 38.12s

## Per-iteration totals

| Iter | Passed | Failed | Critical |
|---:|---:|---:|---:|
| 1 | 128 | 12 | 0 |
| 2 | 126 | 14 | 0 |
| 3 | 127 | 13 | 0 |

## Failed checks (last iteration)

- [4] **A:DB :: few_shot D1-D8 +/- distribution** — missing/imbalanced dims: ['D2']
- [7] **A:DB :: backtest_results >= 100** — count=0
- [10] **A:DB :: recent SUBMITTED events have 4 bids** — violating_events=16 (over last 30 SUBMITTED events)
- [11] **A:DB :: recent SUBMITTED events have >=2 distinct bid amounts** — violating_events=12 (over last 30 SUBMITTED events)
- [12] **A:DB :: recent winner (translator) == lowest bidder** — violating_events=1 (over last 30 SUBMITTED events)
- [17] **A:DB :: recent questions.builder_code matches env** — violating=14, expected=0xa93402f8ae6a... (over last 30 events)
- [22] **A:DB :: recent SUBMITTED events have questions.tx_hash** — missing=15 (over last 30 events)
- [29] **A:DB :: corpus_markets framing_pattern populated** — non_null_count=0 (currently all NULL - feature not yet tagged)
- [30] **A:DB :: sources table populated (>=8 RSS sources)** — count=0 (sources table is unused / replaced by inline source JSON)
- [37] **A:DB :: recent bids.agent_address looks like an addr** — violating=12 (over last 30 SUBMITTED events)
- [89] **B:Chain :: event logs present: BuilderFee-like** — addr=0xcE7596d9..., log_count=0
- [90] **B:Chain :: event logs present: ReputationUpdated-like** — addr=0x00267FD2..., log_count=0
- [99] **B:Chain :: historical tx#4 still on chain** — tx=0x7afb4209afe8c88d..., found_on=None

## DB row count snapshot

- corpus_markets: 75885
- events: 111
- events SUBMITTED: 79
- bids: 174
- translations: 94
- quality_scores: 93
- polymarket_submissions: 79
- questions: 79
- builder_fee_events: 79
- agent_reputation: 94

Report generated by `scripts/db_chain_api_runner.py`.