[tox]
minversion = 1.8
-envlist = {py26,py27,py34},{py26,py27,py34}-{postgres,sqlite},{py27,py34}-flake8
+envlist = {py27,py34,py35,py36},{py27,py34,py35,py36}-{postgres,postgres-w32,sqlite,sqlite-w32},{py27,py34}-flake8
# Base test environment settings
[testenv]
+basepython =
+ py27: {env:TOXPYTHON:python2.7}
+ py34: {env:TOXPYTHON:python3.4}
+ py35: {env:TOXPYTHON:python3.5}
+ py36: {env:TOXPYTHON:python3.6}
+commands =
+ {envpython} --version
+ {envpython} -c "import struct; print(struct.calcsize('P') * 8)"
deps =
- sqlparse
- pytest
- pytest-cov
- py26: argparse
- py26,py27: SQLObject>=2.2.1
- py34: SQLObject>=3.0.0
- py26,py27: m_lib>=2.0
- py34: m_lib>=3.0
+ -rdevscripts/requirements/requirements_tests.txt
postgres: psycopg2
+passenv = PGPASSWORD
sitepackages = True
# Don't fail or warn on uninstalled commands
whitelist_externals =
- flake8
createdb
dropdb
- rm
+ flake8
+ cmp.py
+ rm.py
[general]
commands =
- python -m pytest --cov=sqlconvert
-
-[testenv:py26]
-commands = {[general]commands}
+ {[testenv]commands}
+ {envpython} -m pytest --cov=sqlconvert
+ {envpython} {envbindir}/mysql2sql -P demo/demo.sql test.out
+ cmp.py -i tests/mysql2sql/test.out test.out
+ rm.py test.out
[testenv:py27]
commands = {[general]commands}
[testenv:py34]
commands = {[general]commands}
+[testenv:py35]
+commands = {[general]commands}
+
+[testenv:py36]
+commands = {[general]commands}
+
# PostgreSQL test environments
[postgresql]
commands =
- createdb test
- python -m pytest --cov=sqlconvert -D postgres:///test
- dropdb test
-
-[testenv:py26-postgres]
-commands = {[postgresql]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
[testenv:py27-postgres]
commands = {[postgresql]commands}
[testenv:py34-postgres]
commands = {[postgresql]commands}
+[testenv:py35-postgres]
+commands = {[postgresql]commands}
+
+[testenv:py36-postgres]
+commands = {[postgresql]commands}
+
+[postgres-w32]
+commands =
+ {[testenv]commands}
+ -dropdb -U postgres -w test
+ createdb -U postgres -w test
+ pytest --cov=sqlconvert -D "postgres://postgres:Password12!@localhost/test"
+ dropdb -U postgres -w test
+
+[testenv:py27-postgres-w32]
+commands = {[postgres-w32]commands}
+
+[testenv:py34-postgres-w32]
+commands = {[postgres-w32]commands}
+
+[testenv:py35-postgres-w32]
+commands = {[postgres-w32]commands}
+
+[testenv:py36-postgres-w32]
+commands = {[postgres-w32]commands}
+
# SQLite test environments
[sqlite]
commands =
- python -m pytest --cov=sqlconvert -D sqlite:///tmp/test.sqdb
- rm -f /tmp/test.sqdb
-
-[testenv:py26-sqlite]
-commands = {[sqlite]commands}
+ {[testenv]commands}
+ -rm.py /tmp/test.sqdb
+ {envpython} -m pytest --cov=sqlconvert -D sqlite:///tmp/test.sqdb
+ rm.py /tmp/test.sqdb
[testenv:py27-sqlite]
commands = {[sqlite]commands}
[testenv:py34-sqlite]
commands = {[sqlite]commands}
+[testenv:py35-sqlite]
+commands = {[sqlite]commands}
+
+[testenv:py36-sqlite]
+commands = {[sqlite]commands}
+
+[sqlite-w32]
+commands =
+ {[testenv]commands}
+ -rm.py C:/projects/sqlconvert/test.sqdb
+ pytest --cov=sqlconvert -D sqlite:/C:/projects/sqlconvert/test.sqdb?debug=1
+ rm.py C:/projects/sqlconvert/test.sqdb
+
+[testenv:py27-sqlite-w32]
+commands = {[sqlite-w32]commands}
+
+[testenv:py34-sqlite-w32]
+commands = {[sqlite-w32]commands}
+
+[testenv:py35-sqlite-w32]
+commands = {[sqlite-w32]commands}
+
# flake8
[testenv:py27-flake8]
deps =
flake8
-commands = flake8
+commands =
+ {[testenv]commands}
+ flake8
[testenv:py34-flake8]
deps =
flake8
-commands = flake8
+commands =
+ {[testenv]commands}
+ flake8