name: Run tests

on: [push, pull_request]

jobs:
  run-tests:

    strategy:
      matrix:
        python-version: [2.7, 3.5, 3.6, 3.7, 3.8, 3.9]

    name: Python ${{ matrix.python-version }}
    runs-on: ubuntu-latest

    steps:

      # Use preinstalled PostgreSQL
      - name: Start PostgreSQL on Ubuntu
        run: |
          sudo systemctl start postgresql
          pg_isready
      - name: Create user
        run: |
          echo 'localhost:*:test:runner:test' > ~/.pgpass
          chmod u=rw,go= ~/.pgpass
          sudo -u postgres psql --command="CREATE USER runner CREATEDB ENCRYPTED PASSWORD 'test'"

      - uses: actions/checkout@v2
      - uses: actions/setup-python@v2
        with:
          python-version: ${{ matrix.python-version }}
      - name: Cache pip
        uses: actions/cache@v2
        with:
          # This path is specific to Linux/Unix
          path: ~/.cache/pip
          key: ${{ runner.os }}-pip
      - name: Install dependencies
        run: |
          python --version
          python -m pip install --upgrade "pip<21.0" "setuptools<45" wheel
          pip --version
          pip install --upgrade virtualenv tox
      - name: Set TOXENV
        run: |
          import os, sys
          pyver = '%d%d' % tuple(sys.version_info[:2])
          toxenv = 'py%s' % pyver
          toxenv += ',py%s-sqlite' % pyver
          toxenv += ',py%s-postgres' % pyver
          toxenv += ',py%s-flake8' % pyver
          with open(os.environ['GITHUB_ENV'], 'a') as f:
            f.write('TOXENV=' + toxenv + '\n')
        shell: python
      - name: Run tox
        run: |
          python -c "import os; print(os.environ['TOXENV'])"
          tox