Skip to content

Add CI pipeline

Add CI pipeline #17

Workflow file for this run

name: Run Test Suite
on:
pull_request:
branches:
- main
push:
branches:
- main
- add-ci-tests
jobs:
export_variables:
runs-on: ubuntu-latest
outputs:
primary_image: ${{ steps.compute_container_registry_name.outputs.CR_NAME }}/${{ steps.calculate_primary_sha.outputs.PRIMARY_SHA }}
replica_image: ${{ steps.compute_container_registry_name.outputs.CR_NAME }}/${{ steps.calculate_replica_sha.outputs.REPLICA_SHA }}
steps:
- name: Checkout repository
uses: actions/checkout@v2
- 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:
needs: export_variables
runs-on: ubuntu-latest
steps:
- name: Checkout repository
uses: actions/checkout@v2
- 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: Build and tag replica Docker image
run: docker build -f postgres_replica.dockerfile -t ${{ needs.export_variables.outputs.replica_image }} .
- name: Push primary Docker image
run: docker push ${{ needs.export_variables.outputs.primary_image }}
- name: Push replica Docker image
run: docker push ${{ needs.export_variables.outputs.replica_image }}
rspec:
needs: [export_variables, prebuild]
runs-on: ubuntu-latest
strategy:
matrix:
ruby: [3.1.6, 3.2.5, 3.3.5]
rails: ['~> 7.0.0', '7.1.0', '8.0.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"
postgres_replica:
image: ${{ needs.export_variables.outputs.replica_image }}
ports:
- 5433:5432
env:
PGUSER: replicator
PGPASSWORD: replicator
PGPORT: 5433
PRIMARY_DATABASE_HOST: postgres_primary
steps:
- name: Checkout repository
uses: actions/checkout@v2
- name: Set up Ruby
uses: ruby/setup-ruby@v1
with:
ruby: ${{ matrix.ruby }}
- name: Install dependencies
env:
RAILS_VERSION: ${{ matrix.rails }}
run: |
gem install bundler -v 2.5.13
bundle install
- name: Run RSpec tests
env:
PGHOST: postgres_primary
PG_PRIMARY_USER: postgres_primary_test
PG_PRIMARY_PASSWORD: postgres_primary_test
PG_PRIMARY_HOST: postgres_primary
PG_PRIMARY_PORT: 5432
PG_REPLICA_USER: postgres_primary_test
PG_REPLICA_PASSWORD: postgres_primary_test
PG_REPLICA_HOST: postgres-replica
PG_REPLICA_PORT: 5433
run: bundle exec rspec --format progress