Merge upstream changes up to 624c024766227255c78d31bd408876c64a8b279f #705
Workflow file for this run
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Historical data migration test | |
on: | |
merge_group: | |
push: | |
branches: | |
- 'main' | |
- 'stable-*' | |
paths: | |
- 'Gemfile*' | |
- '.ruby-version' | |
- '**/*.rb' | |
- '.github/workflows/test-migrations.yml' | |
- 'lib/tasks/tests.rake' | |
- 'lib/tasks/db.rake' | |
pull_request: | |
paths: | |
- 'Gemfile*' | |
- '.ruby-version' | |
- '**/*.rb' | |
- '.github/workflows/test-migrations.yml' | |
- 'lib/tasks/tests.rake' | |
jobs: | |
test: | |
runs-on: ubuntu-latest | |
strategy: | |
fail-fast: false | |
matrix: | |
postgres: | |
- 14-alpine | |
- 15-alpine | |
- 16-alpine | |
- 17-alpine | |
services: | |
postgres: | |
image: postgres:${{ matrix.postgres}} | |
env: | |
POSTGRES_PASSWORD: postgres | |
POSTGRES_USER: postgres | |
options: >- | |
--health-cmd pg_isready | |
--health-interval 10ms | |
--health-timeout 3s | |
--health-retries 50 | |
ports: | |
- 5432:5432 | |
redis: | |
image: redis:7-alpine | |
options: >- | |
--health-cmd "redis-cli ping" | |
--health-interval 10ms | |
--health-timeout 3s | |
--health-retries 50 | |
ports: | |
- 6379:6379 | |
env: | |
DB_HOST: localhost | |
DB_USER: postgres | |
DB_PASS: postgres | |
RAILS_ENV: test | |
BUNDLE_CLEAN: true | |
BUNDLE_FROZEN: true | |
BUNDLE_WITHOUT: 'development:production' | |
BUNDLE_JOBS: 3 | |
BUNDLE_RETRY: 3 | |
steps: | |
- uses: actions/checkout@v4 | |
- name: Set up Ruby environment | |
uses: ./.github/actions/setup-ruby | |
- name: Ensure no errors with `db:prepare` | |
run: | | |
bin/rails db:drop | |
bin/rails db:prepare | |
bin/rails db:migrate | |
- name: Ensure no errors with `db:prepare` and SKIP_POST_DEPLOYMENT_MIGRATIONS | |
run: | | |
bin/rails db:drop | |
SKIP_POST_DEPLOYMENT_MIGRATIONS=true bin/rails db:prepare | |
bin/rails db:migrate | |
- name: Test "one step migration" flow | |
run: | | |
bin/rails db:drop | |
bin/rails db:create | |
bin/rails tests:migrations:prepare_database | |
bin/rails db:migrate | |
bin/rails tests:migrations:check_database | |
- name: Test "two step migration" flow | |
run: | | |
bin/rails db:drop | |
bin/rails db:create | |
SKIP_POST_DEPLOYMENT_MIGRATIONS=true bin/rails tests:migrations:prepare_database | |
# Migrate up to v4.2.0 breakpoint | |
bin/rails db:migrate VERSION=20230907150100 | |
# Migrate the rest | |
SKIP_POST_DEPLOYMENT_MIGRATIONS=true bin/rails db:migrate | |
bin/rails db:migrate | |
bin/rails tests:migrations:check_database |