single-postgres-windows.yml

name: Run pytest tests on Windows

on:
  workflow_call:
    inputs:
      python-versions:
        description: 'Supported python versions'
        default: '["3.10", "3.11", "3.12", "3.13", "3.14"]'
        required: false
        type: string
      postgresql:
        description: 'PostgreSQL version'
        required: true
        type: number
    secrets:
      codecov_token:
        description: 'Codecov token'
        required: false

jobs:
  postgres:
    runs-on: windows-latest
    strategy:
      fail-fast: false
      matrix:
        python-version: ${{ fromJSON(inputs.python-versions) }}
    env:
      OS: windows-latest
      PYTHON: ${{ matrix.python-version }}
      POSTGRES: ${{ inputs.postgresql }}
    steps:
      - uses: actions/checkout@v6
      - name: Set up Pipenv on python ${{ matrix.python-version }}
        uses: fizyk/actions-reuse/.github/actions/pipenv-setup@v4.4.7
        with:
          python-version: ${{ matrix.python-version }}
          allow-prereleases: true
      - uses: ankane/setup-postgres@v1
        with:
          postgres-version: ${{ inputs.postgresql }}
      - name: Detect PostgreSQL path on Windows
        shell: pwsh
        run: |
          $pgPath = "C:\Program Files\PostgreSQL\${{ inputs.postgresql }}\bin\pg_ctl.exe"
          if (Test-Path $pgPath) {
            echo "POSTGRESQL_EXEC=$pgPath" >> $env:GITHUB_ENV
          } else {
            $pgPath = (Get-Command pg_ctl -ErrorAction SilentlyContinue).Source
            if ($pgPath) {
              echo "POSTGRESQL_EXEC=$pgPath" >> $env:GITHUB_ENV
            }
          }

          # Verify that PostgreSQL was found
          if (-not $pgPath) {
            Write-Error "Error: pg_ctl not found in expected locations. Checked hardcoded path and system PATH."
            exit 1
          }
      - name: Run test
        id: run_serial_tests
        uses: fizyk/actions-reuse/.github/actions/pipenv-run@v4.4.7
        with:
          command: python -m coverage run --data-file=.coverage.serial -m pytest -svv -p no:xdist --postgresql-exec="${{ env.POSTGRESQL_EXEC }}" -k "not docker" --basetemp="${{ runner.temp }}/pytest-basetemp"
          env: '{"COVERAGE_PROCESS_START": ".coveragerc", "COVERAGE_FILE": ".coverage.serial"}'
      - name: Combine and export serial coverage
        if: ${{ always() && (steps.run_serial_tests.conclusion == 'success' || steps.run_serial_tests.conclusion == 'failure') }}
        uses: fizyk/actions-reuse/.github/actions/coverage-combine-export@v4.4.7
        with:
          data-file: .coverage.serial
          output-file: coverage-serial.xml
      - name: Run xdist test
        id: run_xdist_tests
        uses: fizyk/actions-reuse/.github/actions/pipenv-run@v4.4.7
        with:
          command: python -m coverage run --data-file=.coverage.xdist -m pytest -n auto --dist loadgroup --max-worker-restart 0 --postgresql-exec="${{ env.POSTGRESQL_EXEC }}" -k "not docker" --basetemp="${{ runner.temp }}/pytest-basetemp"
          env: '{"COVERAGE_PROCESS_START": ".coveragerc", "COVERAGE_FILE": ".coverage.xdist"}'
      - name: Combine and export xdist coverage
        if: ${{ always() && (steps.run_xdist_tests.conclusion == 'success' || steps.run_xdist_tests.conclusion == 'failure') }}
        uses: fizyk/actions-reuse/.github/actions/coverage-combine-export@v4.4.7
        with:
          data-file: .coverage.xdist
          output-file: coverage-xdist.xml
      - uses: actions/upload-artifact@v7
        if: failure()
        with:
          name: postgresql-windows-${{ matrix.python-version }}-${{ inputs.postgresql }}
          path: ${{ runner.temp }}/pytest-basetemp/**
      - name: Upload coverage to Codecov
        if: always()
        uses: codecov/codecov-action@v6.0.1
        with:
          token: ${{ secrets.codecov_token }}
          flags: unittests
          env_vars: OS,PYTHON
          fail_ci_if_error: false
          files: coverage-serial.xml,coverage-xdist.xml