Implements the ability to correct multiple surveys at once.
Adds a 'Correct Job Surveys' button to the Job screen
Add missing unvalidate columns to the corrections sheet so that the UI matches ingest
Use batching for inserting observations and survey methods
Refactor the MeasureType conversion from an inline switch to a static method
Refactor the Application Error into a seperate component
Update existing tests
Also rewrites the correction rows query which was not summing the observations when performing the row aggregate. So for identical rows with observations in the same size class only the first count was being returned instead of summing all the counts.
After merging this PR requires the script db/schema-update/17-alter-seq-increment.sql to be run on the DB otherwise ingest and corrections will fail with pkey error.
Implements the ability to correct multiple surveys at once.
Also rewrites the correction rows query which was not summing the observations when performing the row aggregate. So for identical rows with observations in the same size class only the first count was being returned instead of summing all the counts.
After merging this PR requires the script
db/schema-update/17-alter-seq-increment.sql
to be run on the DB otherwise ingest and corrections will fail with pkey error.