Geo Admin Area: Batch operations
Problem to solve
There is functionality on the UI to trigger a recheck / resync operation on the entire instance. You can only do that per project.
Further details
Depending on how big the instance is you also want to take extra care with the database updates to avoiding the update on the entire table which would double it's size on disk because of the MVCC mechanism, until it's fully vacuumed.
Proposal
Add a Resync all and Recheck all buttons.
When clicking in any of them, they will schedule a long running sidekiq job that will update Geo::ProjectRegistry in batches to flag them either for resync or for recheck.
What does success look like, and how can we measure that?
When acessing Admin > Geo > Projects there will be a UI component that can be clicked to trigger Resync all or Recheck all across the database.
Links / references
Edited by Gabriel Mazetto