Skip to content
Run Test Suite

Add CI pipeline #48

Sign in to view logs

Add CI pipeline

Add CI pipeline #48

Workflow file for this run

.github/workflows/test.yml at b58b091
name: Run Test Suite
on:
pull_request:
branches:
- main
jobs:
export_variables:
runs-on: ubuntu-latest
outputs:
primary_image: ${{ steps.compute_container_registry_name.outputs.CR_NAME }}/postgres_primary:${{ steps.calculate_primary_sha.outputs.PRIMARY_SHA }}
replica_image: ${{ steps.compute_container_registry_name.outputs.CR_NAME }}/postgres_replica:${{ steps.calculate_replica_sha.outputs.REPLICA_SHA }}
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Compute container registry name
id: compute_container_registry_name
run: echo "CR_NAME=$(echo ghcr.io/${{ github.repository }} | tr '[:upper:]' '[:lower:]')" >> $GITHUB_OUTPUT
- name: Calculate SHA256 for postgres_primary.dockerfile
id: calculate_primary_sha
run: echo "PRIMARY_SHA=$(sha256sum postgres_primary.dockerfile | awk '{ print substr($1, 1, 12) }')" >> $GITHUB_OUTPUT
- name: Calculate SHA256 for postgres_replica.dockerfile
id: calculate_replica_sha
run: echo "REPLICA_SHA=$(sha256sum postgres_replica.dockerfile | awk '{ print substr($1, 1, 12) }')" >> $GITHUB_OUTPUT
prebuild_primary:
needs: export_variables
runs-on: ubuntu-latest
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Log in to GitHub Container Registry
uses: docker/login-action@v2
with:
registry: ghcr.io
username: ${{ github.actor }}
password: ${{ secrets.GITHUB_TOKEN }}
- name: Build and tag primary Docker image
run: docker build -f postgres_primary.dockerfile -t ${{ needs.export_variables.outputs.primary_image }} .
- name: Push primary Docker image
run: docker push ${{ needs.export_variables.outputs.primary_image }}
prebuild_replica:
needs: export_variables
runs-on: ubuntu-latest
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Log in to GitHub Container Registry
uses: docker/login-action@v2
with:
registry: ghcr.io
username: ${{ github.actor }}
password: ${{ secrets.GITHUB_TOKEN }}
- name: Build and tag replica Docker image
run: docker build -f postgres_replica.dockerfile -t ${{ needs.export_variables.outputs.replica_image }} .
- name: Push replica Docker image
run: docker push ${{ needs.export_variables.outputs.replica_image }}
rubocop:
runs-on: ubuntu-latest
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: 3.1.6
- name: Install dependencies
run: |
gem install bundler
bundle install
- name: Run RuboCop
run: bundle exec rubocop
rspec:
needs: [export_variables, prebuild_primary, prebuild_replica]
runs-on: ubuntu-latest
strategy:
matrix:
ruby:
- 3.2.5
- 3.3.5
rails:
- '~> 7.0.0'
- '~> 7.1.0'
- '~> 8.0.0'
include:
- ruby: 3.1.6
rails: '~> 7.0.0'
- ruby: 3.1.6
rails: '~> 7.1.0'
name: Ruby ${{ matrix.ruby }} / ActiveRecord ${{ matrix.rails }}
services:
postgres_primary:
image: ${{ needs.export_variables.outputs.primary_image }}
ports:
- 5432:5432
env:
POSTGRES_DB: postgres_primary_test
POSTGRES_USER: postgres_primary_test
POSTGRES_PASSWORD: postgres_primary_test
POSTGRES_HOST_AUTH_METHOD: "scram-sha-256\nhost replication all 0.0.0.0/0 md5"
POSTGRES_INITDB_ARGS: "--auth-host=scram-sha-256"
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
postgres_replica:
image: ${{ needs.export_variables.outputs.replica_image }}
ports:
- 5433:5432
env:
PGUSER: replicator
PGPASSWORD: replicator
PGPORT: 5432
PRIMARY_DATABASE_HOST: postgres_primary
PRIMARY_DATABASE_PORT: 5432
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: ${{ matrix.ruby }}
- name: Check if primary is available
run: pg_isready -h localhost -U postgres_primary_test --dbname=postgres -p 5432
- name: Check if replica is available
# run: pg_isready -h localhost -U replicator --dbname=postgres -p 5433
run: pg_isready -h localhost -U postgres_primary_test --dbname=postgres -p 5433
- name: Install dependencies
env:
RAILS_VERSION: ${{ matrix.rails }}
run: |
gem install bundler
bundle install
- name: Run RSpec tests
env:
PG_PRIMARY_USER: postgres_primary_test
PG_PRIMARY_PASSWORD: postgres_primary_test
PG_PRIMARY_HOST: localhost
PG_PRIMARY_PORT: 5432
PG_REPLICA_USER: postgres_primary_test
PG_REPLICA_PASSWORD: postgres_primary_test
PG_REPLICA_HOST: localhost
PG_REPLICA_PORT: 5433
run: bundle exec rspec --format progress
- name: Upload Coverage Report
uses: actions/upload-artifact@v4
with:
name: coverage
path: coverage/**/.resultset.json
if-no-files-found: error
coverage_report:
needs: [rspec]
runs-on: ubuntu-latest
steps:
- name: Checkout Repository
uses: actions/checkout@v4
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby-version: 3.3.5
- name: Install Dependencies
run: |
gem install bundler
bundle install
- name: Download Partial Coverage Resultsets
uses: actions/download-artifact@v4
with:
name: coverage
path: coverage/**/.resultset.json
- name: Collate Partial Coverage Resultsets
run: bundle exec rake coverate:report