X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=.github%2Fworkflows%2Frun-tests.yaml;h=cd07729bc905d93f81a07150ec5ce6204d1d160e;hp=6fb882ef91079b36a83cd0e033a4e282a90d50e6;hb=9f20981eecb43833c38fe20ece52d1a3130f94d7;hpb=6af904215c40152c1f345e1a2fdb28b9d33d0cf9

diff --git a/.github/workflows/run-tests.yaml b/.github/workflows/run-tests.yaml
index 6fb882e..cd07729 100644
--- a/.github/workflows/run-tests.yaml
+++ b/.github/workflows/run-tests.yaml
@@ -13,6 +13,18 @@ jobs:
     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:
@@ -35,8 +47,8 @@ jobs:
           pyver = '%d%d' % tuple(sys.version_info[:2])
           toxenv = 'py%s' % pyver
           toxenv += ',py%s-sqlite' % pyver
-          if os.name == 'posix':
-            toxenv += ',py%s-flake8' % 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