3 envlist = py27,py3{4,5,6,7,8,9}{,-sqlite},py{27,39}-flake8
5 # Base test environment settings
8 py27: {env:TOXPYTHON:python2.7}
9 py34: {env:TOXPYTHON:python3.4}
10 py35: {env:TOXPYTHON:python3.5}
11 py36: {env:TOXPYTHON:python3.6}
12 py37: {env:TOXPYTHON:python3.7}
13 py38: {env:TOXPYTHON:python3.8}
14 py39: {env:TOXPYTHON:python3.9}
17 {envpython} -c "import struct; print(struct.calcsize('P') * 8)"
19 -rdevscripts/requirements/requirements_tests.txt
20 postgres: psycopg2-binary
23 # Don't fail or warn on uninstalled commands
31 {envpython} -m pytest --cov=sqlconvert
32 {envpython} {envbindir}/mysql2sql -P demo/demo.sql test.out
33 cmp.py -i tests/mysql2sql/test.out test.out
37 platform = linux|win32
38 commands = {[general]commands}
41 platform = linux|win32
42 commands = {[general]commands}
45 platform = linux|win32
46 commands = {[general]commands}
49 platform = linux|win32
50 commands = {[general]commands}
53 platform = linux|win32
54 commands = {[general]commands}
57 platform = linux|win32
58 commands = {[general]commands}
61 platform = linux|win32
62 commands = {[general]commands}
64 # PostgreSQL test environments
68 -dropdb -U postgres -w test
69 createdb -U postgres -w test
70 {envpython} -m pytest --cov=sqlconvert -D postgres://postgres:@localhost/test
71 dropdb -U postgres -w test
73 [testenv:py27-postgres]
74 commands = {[postgresql]commands}
76 [testenv:py34-postgres]
77 commands = {[postgresql]commands}
79 [testenv:py35-postgres]
80 commands = {[postgresql]commands}
82 [testenv:py36-postgres]
83 commands = {[postgresql]commands}
85 [testenv:py37-postgres]
86 commands = {[postgresql]commands}
88 [testenv:py38-postgres]
89 commands = {[postgresql]commands}
91 [testenv:py39-postgres]
92 commands = {[postgresql]commands}
98 -dropdb -U postgres -w test
99 createdb -U postgres -w test
100 pytest --cov=sqlconvert -D "postgres://postgres:Password12!@localhost/test"
101 dropdb -U postgres -w test
103 [testenv:py27-postgres-w32]
105 commands = {[postgres-w32]commands}
107 [testenv:py34-postgres-w32]
109 commands = {[postgres-w32]commands}
111 [testenv:py35-postgres-w32]
113 commands = {[postgres-w32]commands}
115 [testenv:py36-postgres-w32]
117 commands = {[postgres-w32]commands}
119 [testenv:py37-postgres-w32]
122 {[postgres-w32]commands}
124 [testenv:py38-postgres-w32]
127 {[postgres-w32]commands}
129 [testenv:py39-postgres-w32]
132 {[postgres-w32]commands}
134 # SQLite test environments
138 -rm.py -f /tmp/test.sqdb
139 {envpython} -m pytest --cov=sqlconvert -D sqlite:///tmp/test.sqdb
140 rm.py -f /tmp/test.sqdb
142 [testenv:py27-sqlite]
143 commands = {[sqlite]commands}
145 [testenv:py34-sqlite]
146 commands = {[sqlite]commands}
148 [testenv:py35-sqlite]
149 commands = {[sqlite]commands}
151 [testenv:py36-sqlite]
152 commands = {[sqlite]commands}
154 [testenv:py37-sqlite]
155 commands = {[sqlite]commands}
157 [testenv:py38-sqlite]
158 commands = {[sqlite]commands}
160 [testenv:py39-sqlite]
161 commands = {[sqlite]commands}
167 -rm.py -f C:/projects/sqlconvert/test.sqdb
168 pytest --cov=sqlconvert -D sqlite:/C:/projects/sqlconvert/test.sqdb?debug=1
169 rm.py -f C:/projects/sqlconvert/test.sqdb
171 [testenv:py27-sqlite-w32]
173 commands = {[sqlite-w32]commands}
175 [testenv:py34-sqlite-w32]
177 commands = {[sqlite-w32]commands}
179 [testenv:py35-sqlite-w32]
181 commands = {[sqlite-w32]commands}
183 [testenv:py36-sqlite-w32]
185 commands = {[sqlite-w32]commands}
187 [testenv:py37-sqlite-w32]
190 {[sqlite-w32]commands}
192 [testenv:py38-sqlite-w32]
195 {[sqlite-w32]commands}
197 [testenv:py39-sqlite-w32]
200 {[sqlite-w32]commands}
203 [testenv:py27-flake8]
204 platform = linux|win32
211 [testenv:py39-flake8]
212 platform = linux|win32