search

NYCPlanning / ae-data-flow

Data pipelines to populate Application Engineering databases
1 stars 0 forks source link

Dump flow db and update zoning db with dump file #33

Closed pratishta closed 3 months ago

pratishta commented 3 months ago

Closes https://github.com/NYCPlanning/ae-data-flow/issues/28

This method 1) Dumps the 6 tables that will update the Zoning API DB to db.dump 2) Updates the Zoning API DB by dropping the tables (--clean) and restoring with db.dump

To test this, you can change the first tax_lot row in your flow DB (e.g. the first address to 'hello world' and save, or something) and then run ./bash/export.sh. Then your local zoning API DB should have those changes. There may be some 'role does not exist' errors in stdout.

pratishta commented 3 months ago

are those Zoning API credentials in the data flow vault?

Not yet, I'll drop them in there soon