kobotoolbox / kpi / 23614526029

82%

master: 76%

push

github

fix(userReports): prevent infinite loop in MV background job (#6876)

### 💭 Notes

- Root cause: when `SKIP_HEAVY_MIGRATIONS=True`, `manage_user_reports_mv
--create` resets `LongRunningMigration.status` back to `'created'`,
which re-triggers `0019_recreate_user_reports_mv` indefinitely.
- Fix: a new `--force` flag bypasses `SKIP_HEAVY_MIGRATIONS` and runs
the migration immediately. The background job always passes `--force`.
- `--force` also creates indexes with `CONCURRENTLY` to avoid locking
the materialized view during index creation.
- No behavior change when `--force` is not passed.

7437 of 11551 branches covered (64.38%)

0 of 1 new or added line in 1 file covered. (0.0%)

28552 of 34928 relevant lines covered (81.75%)

5.81 hits per line