Modify deployment steps to wait for new migrations to finish before deploying new app versions

[exalate-issue-sync]

Original spike ticket: https://fecgov.atlassian.net/browse/FECFILE-1773

Diagram: https://docs.google.com/drawings/d/1HNd2piLJSSuYqqNbh_yGCTRyQFbEwOU2PSU4yX0QM_I/edit


1. Migrations could be run by an app without a route
2. Migrations should completely finish before new application versions are deployed
3. Should probably modify the deploy task itself in (tasks.py). See https://github.com/fecgov/openFEC/blob/99b62ee48ac31fc352aaa287cc4304533c8328b2/tasks.py#L185-L212 for an example (flask/flyway but some of the basic principles are the same)
4. Could possibly reuse deployer instance with no routes as a non-deployer instance after migrations (add route to the application instance afterwards)
5. Take manage.py migrate out of the existing run-api.sh
6. Test partially failed migrations / rollback

QA Notes

null

DEV Notes

null

Design

null

See full ticket and images here: FECFILE-1865

Pull Request: #1273

[exalate-issue-sync]

Elaine Krauss commented: For QA: unit tests are [here|https://circleci.com/gh/fecgov/fecfile-web-api/13624]

[exalate-issue-sync]

Todd Lees commented: migrator spins up:

!image-20250117-194844.png|width=256,height=105,alt="image-20250117-194844.png"!

migrator is deleted after use:

!image-20250117-194931.png|width=256,height=47,alt="image-20250117-194931.png"!

[exalate-issue-sync]

Todd Lees commented: Migrations are run

!image-20250117-200005.png|width=552,height=274,alt="image-20250117-200005.png"!

Then the migrator is deleted. After, the api is deployed:

!image-20250117-200103.png|width=379,height=134,alt="image-20250117-200103.png"!

[exalate-issue-sync]

Todd Lees commented: Passes CR see comments for tests showing the migrator working as expected

[exalate-issue-sync]

Shelly Wise commented: QA review per DEV Verification of Migrations are run; migrator is deleted after, the api is deployed; migrator spins up and is deleted after use as depicted by DEV.

Verified unit tests passing for this ticket.

!image-20250120-170219.png|width=1266,height=565,alt="image-20250120-170219.png"!

QA Review Completed. Moved to Stage Ready.

[exalate-issue-sync]

Automation for Jira commented: Sprint accepted by Paul Clark during sprint review on the date of this comment.