name: Run tests

on: [push, pull_request]

jobs:
  run-tests:
    env:
      not_in_conda: "[]"

    strategy:
      matrix:
        os: [ubuntu-latest, windows-latest]
        python-version: ["2.7", "3.5", "3.6", "3.7", "3.8", "3.9", "3.10", "3.11", "3.12"]
        include:
        - os: ubuntu-latest
          os-name: Linux
          pip-cache-path: ~/.cache/pip
        - os: windows-latest
          os-name: w32
          pip-cache-path: ~\AppData\Local\pip\Cache

    name: Python ${{ matrix.python-version }} @ ${{ matrix.os-name }}
    runs-on: ${{ matrix.os }}

    steps:

      # Setup PostgreSQL
      - uses: ankane/setup-postgres@v1
      - name: Setup Postgres user @ Linux
        run: |
          sudo -u postgres psql --command="ALTER USER runner CREATEDB PASSWORD 'test'"
        if: ${{ runner.os == 'Linux' }}
      - name: Setup Postgres user @ w32
        run: |
          psql --command="CREATE USER runner CREATEDB PASSWORD 'test'"
        if: ${{ runner.os == 'Windows' }}

      # Setup Python/pip
      - uses: actions/checkout@v4
      - uses: s-weigand/setup-conda@v1
        with:
          conda-channels: conda-forge
          python-version: ${{ matrix.python-version }}
        if: ${{ !contains(fromJSON(env.not_in_conda), matrix.python-version) }}
      - uses: actions/setup-python@v4
        with:
          python-version: ${{ matrix.python-version }}
        if: ${{ contains(fromJSON(env.not_in_conda), matrix.python-version) }}
      - name: Cache pip
        uses: actions/cache@v3
        with:
          path: ${{ matrix.pip-cache-path }}
          key: ${{ runner.os }}-pip

      # Setup tox
      - name: Install dependencies
        run: |
          python --version
          python -m pip || python -m ensurepip --default-pip --upgrade
          python -m pip install --upgrade pip setuptools wheel
          pip --version
          pip install --upgrade virtualenv "tox >= 3.15, < 4"
      - name: Set TOXENV
        run: |
          import os, sys
          ld_library_path = None
          pyver = '%d%d' % tuple(sys.version_info[:2])
          toxenv = 'py%s' % pyver
          toxenv += ',py%s-sqlite' % pyver
          if os.name == 'nt':
            toxenv += '-w32'
          toxenv += ',py%s-postgres' % pyver
          if os.name == 'posix':
            if pyver == '27':  # Python 2.7 on Linux requires `$LD_LIBRARY_PATH`
              ld_library_path = os.path.join(
                os.path.dirname(os.path.dirname(sys.executable)), 'lib')
            toxenv += ',py%s-flake8' % pyver
          elif os.name == 'nt':
            toxenv += '-w32'
          with open(os.environ['GITHUB_ENV'], 'a') as f:
            if ld_library_path:
              f.write('LD_LIBRARY_PATH=' + ld_library_path + '\n')
            f.write('TOXENV=' + toxenv + '\n')
            f.write('PGPASSWORD=test\n')
        shell: python

      - name: Run tox
        run: |
          python -c "import os; print(os.environ['TOXENV'])"
          tox --version
          tox