From d2badb1547aaf53057acbd9b02b81e1dc385f8ec Mon Sep 17 00:00:00 2001
From: Oleg Broytman <phd@phdru.name>
Date: Sun, 19 Mar 2017 19:41:33 +0300
Subject: [PATCH] Test mysql2sql with tox

---
 tests/mysql2sql/test.out | 15 +++++++++++++++
 tox.ini                  |  4 ++++
 2 files changed, 19 insertions(+)
 create mode 100644 tests/mysql2sql/test.out

diff --git a/tests/mysql2sql/test.out b/tests/mysql2sql/test.out
new file mode 100644
index 0000000..60d3271
--- /dev/null
+++ b/tests/mysql2sql/test.out
@@ -0,0 +1,15 @@
+SELECT * FROM mytable; -- line-comment"
+
+INSERT INTO /* inline comment */ mytable VALUES (1, 'тест');
+
+
+INSERT INTO "MyTable" ("Id", "Name")
+VALUES (1, 'one');
+
+INSERT INTO mytable VALUES  (1, 'one');
+INSERT INTO mytable VALUES  (2, 'two');
+
+INSERT INTO mytable (id, name) VALUES  (1, 'one');
+INSERT INTO mytable (id, name) VALUES  (2, 'two');
+
+-- The end
diff --git a/tox.ini b/tox.ini
index 0dfe51a..229abb7 100644
--- a/tox.ini
+++ b/tox.ini
@@ -21,11 +21,15 @@ whitelist_externals =
     flake8
     createdb
     dropdb
+    cmp
     rm
 
 [general]
 commands =
     python -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}
-- 
2.39.2