regression-tests.yml

# CI for set_user Pull Requests and pushes to the cicd branch.
# Runs regression tests against all supported versions of postgres.
on:
  push:
    branches:
      - integration
      - '**-ci'
  pull_request:
    branches:
      - master
      - integration

jobs:
  regression-tests:
    runs-on: ubuntu-latest
    env:
      DOCKER_DIR: ${{ github.workspace }}/.github/docker
      RESOURCE_DIR: ${{ github.workspace }}/.github/resources
      SCRIPT_DIR: ${{ github.workspace }}/.github/resources/scripts
      DEVPKG: ${{ matrix.devpkg }}
    strategy:
      fail-fast: false
      matrix:
        pgver: [12, 13, 14, 15, 16, 17beta2]

    steps:
      - name: Checkout set_user repo
        uses: actions/checkout@v4

      - name: Set DEVPKG to pgver if unset
        if: ${{ env.DEVPKG == '' }}
        run: |
          # Cut off label and leave only major version number (17beta2 -> 17)
          DEVPKG=$(echo ${{ matrix.pgver }} | sed 's/^\([0-9]\{2\}\).*/\1/')
          echo "DEVPKG=$DEVPKG" >> $GITHUB_ENV;

      - name: Build set_user
        run: |
          sudo apt-get install -y docker-compose
          docker build -t set_user:latest \
                --build-arg PGVER=${{ matrix.pgver }} \
                --build-arg DEVPKG=${{ env.DEVPKG }} \
                -f ${{ env.DOCKER_DIR }}/Dockerfile .

      - name: Run PG set_user
        run: |
          docker-compose -f ${{ env.RESOURCE_DIR }}/set_user.yml up -d
          /bin/bash ${{ env.SCRIPT_DIR }}/healthcheck.sh set_user 60

      - name: Run tests
        run: |
          docker exec set_user make -C /src/set_user USE_PGXS=1 REGRESS_OPTS='--user=postgres' installcheck

      - name: Show any regression diffs
        if: ${{ failure() }}
        run: |
          docker cp set_user:/src/set_user/regression.diffs ./regression.diffs
          cat ./regression.diffs