test.yml

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 }}/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@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_primary:
    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: 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@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 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 }}

  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']
        ruby: [3.2.5]
        rails: ['~> 7.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"
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

      postgres_replica:
        image: ${{ needs.export_variables.outputs.primary_image }}
        # image: ${{ needs.export_variables.outputs.replica_image }}
        ports:
          - 5433:5432
        env:
          # PGUSER: replicator
          # PGPASSWORD: replicator
          # PGPORT: 5433
          # PRIMARY_DATABASE_HOST: postgres_primary
          # PRIMARY_DATABASE_PORT: 5432
          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

    steps:
      - name: Checkout repository
        uses: actions/checkout@v2

      - 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 -v 2.5.13
          bundle install

      - name: Run RSpec tests
        env:
          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