Querying is failing on v1 site

[nichhk]

The v1 code was previously deployed from release/v1.5.0 branch. When I was working on updating the v1 site to make the "Contact Us" functionality work, I made my fixes on dev and pushed a new API image from dev. From release/v1.5.0 to dev, the API code changed enough to make queries to the existing prod database fail. Specifically, the error is: UndefinedColumnError: column request_types.agency_id does not exist (Sentry).

Ideally, we would be able to run "alembic,upgrade,head" using this config (modified to target the prod DB) with this command: aws ecs run-task --cli-input-json file://alembic_task.json; in order to bring the DB up-to-date with the changes in the API code. However, the alembic upgrade scripts were changed after they were already applied on the prod database. Alembic doesn't know to reapply upgrades that have changed, and the following upgrades relied on the previous upgrades having that change, so the upgrades failed.

I think the only option is to drop the database, recreate it, and then run "alembic,upgrade,head". I will need access to an SSH key from a former team member in order to do this since the DB is not publicly accessible.

[nichhk]

This is obsolete since we are focusing on v2 now.