From f5bc1166430a10995e541ab263cb22634c7d9da4 Mon Sep 17 00:00:00 2001
From: Oleg Broytman <phd@phdru.name>
Date: Fri, 9 Jun 2017 22:56:41 +0300
Subject: [PATCH] Feat(CI): Run tests with sqlite and flake8

---
 .travis.yml  |  6 ++++++
 appveyor.yml | 40 ++++++++++++++++++++++++++++++++++++++++
 tox.ini      | 18 +++++++++++++++++-
 3 files changed, 63 insertions(+), 1 deletion(-)

diff --git a/.travis.yml b/.travis.yml
index 5217864..6b5a49e 100644
--- a/.travis.yml
+++ b/.travis.yml
@@ -21,6 +21,12 @@ env:
   - TOXENV=py34
   - TOXENV=py35
   - TOXENV=py36
+  - TOXENV=py27-sqlite
+  - TOXENV=py34-sqlite
+  - TOXENV=py35-sqlite
+  - TOXENV=py36-sqlite
+  - TOXENV=py27-flake8
+  - TOXENV=py34-flake8
 
 install:
   - travis_retry pip install tox
diff --git a/appveyor.yml b/appveyor.yml
index 24320ec..80ba5e1 100644
--- a/appveyor.yml
+++ b/appveyor.yml
@@ -50,6 +50,46 @@ environment:
       PYTHON_VERSION: "3.6"
       PYTHON_ARCH: "64"
       TOX_ENV: "py36"
+    - PYTHON_HOME: "C:\\Python27"
+      PYTHON_VERSION: "2.7"
+      PYTHON_ARCH: "32"
+      TOX_ENV: "py27-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python27-x64"
+      PYTHON_VERSION: "2.7"
+      PYTHON_ARCH: "64"
+      TOX_ENV: "py27-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python34"
+      PYTHON_VERSION: "3.4"
+      PYTHON_ARCH: "32"
+      TOX_ENV: "py34-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python34-x64"
+      PYTHON_VERSION: "3.4"
+      PYTHON_ARCH: "64"
+      TOX_ENV: "py34-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python35"
+      PYTHON_VERSION: "3.5"
+      PYTHON_ARCH: "32"
+      TOX_ENV: "py35-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python35-x64"
+      PYTHON_VERSION: "3.5"
+      PYTHON_ARCH: "64"
+      TOX_ENV: "py35-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python36"
+      PYTHON_VERSION: "3.6"
+      PYTHON_ARCH: "32"
+      TOX_ENV: "py36-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python36-x64"
+      PYTHON_VERSION: "3.6"
+      PYTHON_ARCH: "64"
+      TOX_ENV: "py36-sqlite-w32"
+    - PYTHON_HOME: "C:\\Python27"
+      PYTHON_VERSION: "2.7"
+      PYTHON_ARCH: "32"
+      TOX_ENV: "py27-flake8"
+    - PYTHON_HOME: "C:\\Python34-x64"
+      PYTHON_VERSION: "3.4"
+      PYTHON_ARCH: "64"
+      TOX_ENV: "py34-flake8"
 
 install:
   # Ensure we use the right python version
diff --git a/tox.ini b/tox.ini
index 6feee24..324f4d1 100644
--- a/tox.ini
+++ b/tox.ini
@@ -1,6 +1,6 @@
 [tox]
 minversion = 1.8
-envlist = {py27,py34,py35,py36},{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]
@@ -83,6 +83,22 @@ 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 =
-- 
2.39.2