akvo / iwsims / #54

88%

main: 88%

Pull #22

coveralls-python

[#20] Replace FormData/Answers queries with MVs in values_functions

- _count_group_by_month (no date_qid): use MVAnswerDenormalized.data_created
  instead of FormData.created, with Count(data_id, distinct=True)
- _count_group_by_date (no date_qid): same pattern with TruncDate
- _option_value_group_by_month (no date_qid): same
- _number_group_by_parent: parent names from MVLatestMonitoring.parent_name
  instead of FormData join
- _stack_option_by_parent: form_id resolved via MVAnswerDenormalized
  instead of FormData
- _stack_option_by_parent_legacy: parent IDs/names/data_ids from
  MVAnswerDenormalized + MVLatestMonitoring instead of FormData
- handle_stack_by_parent (is_latest=False): same
- _stack_parent_by_date (no date_qid): data_created from MVAnswerDenormalized

FormData kept for: _total_parents_in_scope and handle_count_mode
percentage denominators — MVs only contain parents with monitoring data,
so counting ALL registered parents requires the live FormData table.

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

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

5097 of 5957 branches covered (85.56%)

Branch coverage included in aggregate %.

9850 of 11042 relevant lines covered (89.2%)

0.89 hits per line