akvo / iwsims / #38

88%

main: 88%

Pull #21

coveralls-python

[#20] Add migration for optimized materialized views

- Add mv_latest_monitoring: pre-computes latest monitoring per parent
  with indexes on form_id, administration_id, parent_administration_id
- Add mv_answer_denormalized: pre-joins answers with data/question tables
  with GIN index on answer_options for fast option filtering
- Add mv_cross_form_latest: aggregates latest answer per parent/question_name
  across all monitoring forms using ROW_NUMBER window function
- Add mv_parent_aggregates: pre-aggregated option counts and numeric stats
  per parent/form/question using DISTINCT ON + jsonb_agg
- Set atomic = False (required for non-transactional index creation)
- All reverse SQL uses CASCADE to handle dependencies

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Sonnet 4.6 (1M context) <noreply@anthropic.com>

5040 of 5872 branches covered (85.83%)

Branch coverage included in aggregate %.

9717 of 10873 relevant lines covered (89.37%)

0.89 hits per line