search

OpenFn / wcs-wildmeat

Wildlife Conservation Society ConSocSci Project
1 stars 0 forks source link

Create timer job that resets database #29

Closed daissatou2 closed 2 years ago

daissatou2 commented 2 years ago

Background, context, and business value

Create a job that will remove all rows from tables to reset the database for testing. Connect to this job: https://www.openfn.org/projects/p5yaxp/jobs/jyk5pa

Tables to reset: tbl_site tbl_sample tbl_study swm_transaction tbl_individual tbl_individual_char tbl_household tbl_household_char tbl_wildmeat tbl_market tbl_wildmeat_market tbl_sample_market tbl_hunter_monitoring tbl_wildmeat_hunter bl_sample_hunter tbl_wildmeat_urban tbl_individual_urban tbl_sample_urban

state.json

Postgres DB: See LP Wildmeat Postgres Transitional DB (WCS)

adaptor

Postgresql

lakhassane commented 2 years ago

@daissatou2 I pushed the job and linked on prod.