akvo / iwsims / #51

88%

main: 88%

Pull #22

coveralls-python

[#20] Replace FormData with MVLatestMonitoring in handle_progress

When no date_filters are set, use mv_latest_monitoring as the primary
queryset instead of FormData + correlated subquery annotation:

MV path (not date_filters):
- MVLatestMonitoring.filter(form_id=...) replaces
  FormData.filter(...).annotate(latest_id=subquery)
- parent_id, parent_name, latest_data_id come directly from the MV
- apply_administration_filter_mv on parent_administration_id (no FK)
- narrow_data_ids_by_criteria called directly with adapted field names
  (latest_data_id instead of latest_id, parent_id instead of id)
- Eliminates the FormData outer query + subquery join entirely
- Works in tests: mixin setUp always refreshes MVs before test runs

FormData fallback (date_filters set):
- mv_latest_monitoring stores absolute latest, not latest within range
- Correlated subquery still needed for correct date-range semantics
- apply_criteria/apply_parent_criteria used as before

Output unified to parent_id/parent_name/latest_data_id dict for both
paths — removes the .only('id','name') FormData instance iteration.

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

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

5091 of 5951 branches covered (85.55%)

Branch coverage included in aggregate %.

9845 of 11036 relevant lines covered (89.21%)

0.89 hits per line