CI(GHActions): Setup PostgreSQL, run postgres tests

[sqlconvert.git] / tox.ini

diff --git a/tox.ini b/tox.ini
index 460460d07604aa9ada9706c009fd6773ccfbf53e..376fae5ab86b8521e458a7fe7780d3c25e6b6178 100644 (file)
--- a/tox.ini
+++ b/tox.ini
@@ -16,9 +16,13 @@ commands =
     {envpython} --version
     {envpython} -c "import struct; print(struct.calcsize('P') * 8)"
 deps =
+    pip < 19.2
+    setuptools < 44
     -rdevscripts/requirements/requirements_tests.txt
     postgres: psycopg2-binary
 passenv = PGPASSWORD
+setenv =
+    VIRTUALENV_PIP = 19.1.1
 platform = linux
 # Don't fail or warn on uninstalled commands
 whitelist_externals =
@@ -52,19 +56,19 @@ commands =
 [testenv:{py27,py34,py35,py36,py37,py38,py39}-postgres]
 commands =
     {[testenv]commands}
-    -dropdb -U postgres -w test
-    createdb -U postgres -w test
-    {envpython} -m pytest --cov=sqlconvert -D postgres://postgres:@localhost/test
-    dropdb -U postgres -w test
+    -dropdb --username=runner test
+    createdb --username=runner test
+    {envpython} -m pytest --cov=sqlconvert -D postgres://runner:test@localhost/test
+    dropdb --username=runner test
 
 [testenv:{py27,py34,py35,py36,py37,py38,py39}-postgres-w32]
 platform = win32
 commands =
     {[testenv]commands}
-    -dropdb -U postgres -w test
-    createdb -U postgres -w test
+    -dropdb --username=postgres --no-password test
+    createdb --username=postgres --no-password test
     pytest --cov=sqlconvert -D "postgres://postgres:Password12!@localhost/test"
-    dropdb -U postgres -w test
+    dropdb --username=postgres --no-password test
 
 # flake8
 [testenv:{py27,py34,py35,py36,py37,py38,py39}-flake8]