X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=.github%2Fworkflows%2Frun-tests.yaml;h=7d51773842c92f83dd279c51209d69ecabcd234b;hb=2391d24951c354fe6bdfcb70f4e16a75b7346970;hp=baafe4923d2c7badbb4e12f790335f62c8e9ca94;hpb=dc96c20fa2ed56c469d8538c03bc193ce80a7c44;p=sqlconvert.git

diff --git a/.github/workflows/run-tests.yaml b/.github/workflows/run-tests.yaml
index baafe49..7d51773 100644
--- a/.github/workflows/run-tests.yaml
+++ b/.github/workflows/run-tests.yaml
@@ -24,20 +24,25 @@ jobs:
 
       # 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' }}
 
       # Setup Python/pip
       - uses: actions/checkout@v2
+      - uses: s-weigand/setup-conda@v1
+        with:
+          python-version: ${{ matrix.python-version }}
+        if: ${{ runner.os == 'Linux' && matrix.python-version != '3.11' }}
       - uses: actions/setup-python@v4
         with:
           python-version: ${{ matrix.python-version }}
+        if: ${{ runner.os != 'Linux' || matrix.python-version == '3.11' }}
       - name: Cache pip
         uses: actions/cache@v3
         with:
@@ -50,10 +55,11 @@ jobs:
           python --version
           python -m pip install --upgrade pip setuptools wheel
           pip --version
-          pip install --upgrade virtualenv tox
+          pip install --upgrade virtualenv "tox < 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
@@ -61,10 +67,15 @@ 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