Database and Migrations

Migrations

All migrations in this folder are embedded directly in the reacher_backend binary, so you don't need to run the migrations manually.

The migrations come from 2 sources:

• sqlxmq migrations
• Reacher's own migrations

sqlxmq migrations

The following migration files have been copied from the sqlxmq repo as per the given instructions:

• 20210316025847_setup.{up,down}.sql
• 20210921115907_clear.{up,down}.sql
• 20211013151757_fix_mq_latest_message.{up,down}.sql
• 20220208120856_fix_concurrent_poll.{up,down}.sql
• 20220713122907_fix-clear_all-keep-nil-message.{up,down}.sql

Reacher migrations

The following migrations are specific to Reacher:

• 20220117025847_email_data.{up,down}.sql: set up the bulk_jobs and email_results tables
• 20220810141100_result_created_at.{up,down}.sql: add a created_at column on email_result

Advanced Usage

For more advanced usage (such as reverting to an old state), please use the sqlx CLI command.

See https://github.com/launchbadge/sqlx/blob/main/sqlx-cli/README.md