akvo / iwsims / #49

88%

main: 88%

Pull #22

coveralls-python

[#20] Replace all Answers queries with MVAnswerDenormalized across visualization

values_functions.py:
- Replace all 23 Answers.objects queries with MVAnswerDenormalized
  (answer_options GIN index, answer_value numeric index, parent_id direct)
- _number_group_by_parent: 2-query approach (MV for aggregates, FormData
  for parent names) instead of single JOIN — same queries, no Subquery needed
- _option_group_by_option: tracking_field data__parent_id → parent_id (no join)
- Remove Answers import entirely
- Add TruncDate import for _number_group_by_date
- Add MVAnswerDenormalized import

progress_functions.py:
- build_progress_answers_map: MVAnswerDenormalized with field name mapping
  (answer_options/answer_value → options/value for formula handlers)
- handle_progress filter_qid and scope_qid queries: use MVAnswerDenormalized
- Remove Answers import, add MVAnswerDenormalized import

escalation_functions.py:
- build_column_caches: MVAnswerDenormalized for both monitoring and parent
  answer caches with field name normalization
- Remove Answers import entirely

tests/mixins.py:
- Add refresh_all_mvs() at end of VisualizationValuesTestMixin.setUp()
  so all test classes using this mixin automatically have populated MVs
- Extract shared refresh_all_mvs() function and MVRefreshMixin
- Remove MVRefreshMixin from EscalationTestCases (covered by mixin)

Test body fixes (refresh after in-test data creation):
- tests_values_option: test_include_unanswered_works_on_registration_form
- tests_values_criteria: 2 cross-form criteria tests
- tests_values_stack: registration form stack test
- tests_formula_values: setUp override + test_criteria_composes

Shared refresh helpers moved to mixins.py:
- tests_mv_models, tests_mv_helpers, tests_operational_criteria: use
  refresh_all_mvs from mixins instead of local definitions

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

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

5087 of 5937 branches covered (85.68%)

Branch coverage included in aggregate %.

9840 of 11018 relevant lines covered (89.31%)

0.89 hits per line