run_unit_tests_on_docker.yml

name: Docker tests
run-name: ${{ github.actor }} is running the test schedules.
on:
  push:
    
  pull_request:
    

jobs:
  run-scripts:
    strategy:
      fail-fast: false
      matrix:
        os: [ubuntu-22.04]
        pgver: [14, 15, 16, 17]

    runs-on: ${{ matrix.os }}

    steps:
    - name: Checkout cli
      uses: actions/checkout@v4
      with:
        ref: ${{ github.ref }}

    - name: Set up Docker
      uses: docker/setup-buildx-action@v2

    - name: Build Docker Image
      run: |
        docker build --build-arg PGVER=${{ matrix.pgver }} -t cli .
   
    - name: Run Docker Container
      run: |
        docker run -d --name cli -e POSTGRES_HOST_AUTH_METHOD=trust -p 5432:5432 cli
        

    - name: Wait for PostgreSQL to be ready
      run: |
        echo "Waiting for Postgres to be ready..."
        for i in {1..30}; do
          if pg_isready -h localhost -p 5432 -U postgres; then
            echo "PostgreSQL is ready!"
              exit 0
          fi
          echo "PostgreSQL is not ready yet. Retrying in 5 seconds..."
          sleep 5
          done
          echo "PostgreSQL did not become ready in time. Exiting."
          exit 1

    - name: Set up Python
      uses: actions/setup-python@v4
      with:
        python-version: '3.10'

    - name: Install dependencies
      run: |
        sudo apt -y update
        sudo apt install -y postgresql-client \
            libpq-dev \
            python3-dev \
            python3-psycopg2 \
            python3-dotenv

    - name: Run Test Harness (runner.py)
      run: |
        python test/runner.py -c test/t/lib/${{ matrix.pgver }}config.env -s test/schedule_files/script_file -k
        cat latest.log

    - name: Upload Log File as Artifact
      uses: actions/upload-artifact@v4
      with:
        name: latest-log-${{ matrix.pgver }}
        path: latest.log