Feat(CI): Run tests with sqlite and flake8

[sqlconvert.git] / tox.ini

diff --git a/tox.ini b/tox.ini
index 7d25d514217d7001ada11703fea505d486d3d1f9..324f4d135eeeb812427a4c65ec5e282656377932 100644 (file)
--- a/tox.ini
+++ b/tox.ini
@@ -1,18 +1,19 @@
 [tox]
 minversion = 1.8
-envlist = {py26,py27,py34,py35,py36},{py26,py27,py34,py35,py36}-{postgres,sqlite},{py27,py34}-flake8
+envlist = {py27,py34,py35,py36},{py27,py34,py35,py36}-{postgres,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
-    py2{6,7}: SQLObject>=2.2.1
-    py3{4,5,6}: SQLObject>=3.0.0
-    m_lib>=3.1
-    m_lib.defenc>=1.0
+    -rdevscripts/requirements/requirements_tests.txt
     postgres: psycopg2
 sitepackages = True
 # Don't fail or warn on uninstalled commands
@@ -20,18 +21,14 @@ whitelist_externals =
     flake8
     createdb
     dropdb
-    cmp
-    rm
 
 [general]
 commands =
+    {[testenv]commands}
     {envpython} -m pytest --cov=sqlconvert
-    mysql2sql demo/demo.sql test.out
-    cmp -s tests/mysql2sql/test.out test.out
-    rm test.out
-
-[testenv:py26]
-commands = {[general]commands}
+    {envpython} {envbindir}/mysql2sql -P demo/demo.sql test.out
+    {envpython} {envbindir}/cmp.py -i tests/mysql2sql/test.out test.out
+    {envpython} {envbindir}/rm.py test.out
 
 [testenv:py27]
 commands = {[general]commands}
@@ -48,14 +45,12 @@ commands = {[general]commands}
 # PostgreSQL test environments
 [postgresql]
 commands =
+    {[testenv]commands}
     -dropdb test
     createdb test
     {envpython} -m pytest --cov=sqlconvert -D postgres:///test
     dropdb test
 
-[testenv:py26-postgres]
-commands = {[postgresql]commands}
-
 [testenv:py27-postgres]
 commands = {[postgresql]commands}
 
@@ -71,11 +66,10 @@ commands = {[postgresql]commands}
 # SQLite test environments
 [sqlite]
 commands =
+    {[testenv]commands}
+    -{envpython} {envbindir}/rm.py /tmp/test.sqdb
     {envpython} -m pytest --cov=sqlconvert -D sqlite:///tmp/test.sqdb
-    rm -f /tmp/test.sqdb
-
-[testenv:py26-sqlite]
-commands = {[sqlite]commands}
+    {envpython} {envbindir}/rm.py /tmp/test.sqdb
 
 [testenv:py27-sqlite]
 commands = {[sqlite]commands}
@@ -89,13 +83,33 @@ commands = {[sqlite]commands}
 [testenv:py36-sqlite]
 commands = {[sqlite]commands}
 
+[sqlite-w32]
+commands =
+    {[testenv]commands}
+    -{envpython} {envbindir}/rm.py C:/projects/sqlconvert/test.sqdb
+    pytest --cov=sqlconvert -D sqlite:/C:/projects/sqlconvert/test.sqdb?debug=1
+    {envpython} {envbindir}/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