Heroku Deploys

How to reset (wipe) staging (develop) and start over with new schema

# wipe the database
heroku pg:reset <postgresql-instance-name> --app norfolkdrains-develop --confirm norfolkdrains-develop
# load the db schema (first time only). No data is included
heroku run bundle exec rake db:schema:load --app norfolkdrains-develop
# load the norfolk.csv in the root of the repo
heroku run bundle exec rake data:load_things --app norfolkdrains-develop

1. replace/edit the norfolk.csv with new data (OBJECTID is key and must match to prevent dupes)
2. commit to develop/master branches, herkou will deploy new docker image within minutes
3. assuming your logged into heroku cli:
4. heroku run bundle exec rake data:load_things --app norfolkdrains-develop for develop, and remove -develop for prod project name. The app correctly merges any csv data.

https://norfolkdrains.code4hr.org/admin

• first admin must signup, then manually edit db to mark their user admin