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.
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.
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.