Build(GHActions): Use `checkout@v4` instead of outdated `v2`

[sqlconvert.git] / .github / workflows / run-tests.yaml

diff --git a/.github/workflows/run-tests.yaml b/.github/workflows/run-tests.yaml
index 22d05e6d8ccf0fa8602c97959863d1774363fa80..25c08a0219e4193f755c36bb8320baf4a34309eb 100644 (file)
--- a/.github/workflows/run-tests.yaml
+++ b/.github/workflows/run-tests.yaml
@@ -4,11 +4,13 @@ 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]
+        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
@@ -22,34 +24,46 @@ jobs:
 
     steps:
 
+      # Setup PostgreSQL
       - uses: ankane/setup-postgres@v1
-      - name: Setup Postgres user
+      - 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
+      - name: Setup Postgres user @ w32
         run: |
           psql --command="CREATE USER runner CREATEDB PASSWORD 'test'"
         if: ${{ runner.os == 'Windows' }}
 
-      - uses: actions/checkout@v2
-      - uses: actions/setup-python@v2
+      # 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@v2
+        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 install --upgrade "pip<21.0" "setuptools<45" wheel
+          python -m pip || python -m ensurepip --default-pip --upgrade
+          python -m pip install --upgrade pip setuptools wheel
           pip --version
-          pip install --upgrade virtualenv tox
+          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
@@ -57,14 +71,21 @@ jobs:
             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