X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=tests%2Ftest_process_mysql.py;h=420a219d22efb26004a657df56f48f15c71aa181;hp=df60a647d5de00a997bbc7248303af33b2ff0b55;hb=9bfd0fb291e1ca197ece43bb728f65830289d826;hpb=95103778dd6d6d279d9b3c9f83ff49ea5920c6e5

diff --git a/tests/test_process_mysql.py b/tests/test_process_mysql.py
index df60a64..420a219 100644
--- a/tests/test_process_mysql.py
+++ b/tests/test_process_mysql.py
@@ -1,11 +1,12 @@
 # -*- coding: utf-8 -*-
 
+import pytest
 from sqlparse import parse
 
 from sqlconvert.print_tokens import tlist2str
 from sqlconvert.process_mysql import remove_directive_tokens, \
         is_directive_statement, requote_names, unescape_strings, \
-        is_insert, process_statement
+        get_DML_type, process_statement
 from sqlconvert.process_tokens import escape_strings
 
 
@@ -53,14 +54,19 @@ def test_escape_string_sqlite():
     assert query == u"INSERT INTO test VALUES ('\"te''st\"\n')"
 
 
-def test_is_insert():
+def test_DML_type():
+    parsed = parse("create table test ();")[0]
+    statement = next(process_statement(parsed))
+    with pytest.raises(ValueError):
+        get_DML_type(statement)
+
     parsed = parse("select /*! test */ * from /* test */ `T`")[0]
     statement = next(process_statement(parsed))
-    assert not is_insert(statement)
+    assert get_DML_type(statement) == "SELECT"
 
     parsed = parse("insert into test values ('\"te\\'st\\\"\\n')")[0]
     statement = next(process_statement(parsed))
-    assert is_insert(statement)
+    assert get_DML_type(statement) == "INSERT"
 
 
 def test_split_ext_insert():
@@ -78,19 +84,19 @@ def test_split_ext_insert():
     stiter = process_statement(parsed)
     statement = next(stiter)
     query = tlist2str(statement)
-    assert query == u"INSERT INTO test VALUES  (1, 2);\n"
+    assert query == u"INSERT INTO test VALUES (1, 2);\n"
     statement = next(stiter)
     query = tlist2str(statement)
-    assert query == u"INSERT INTO test VALUES  (3, 4);"
+    assert query == u"INSERT INTO test VALUES (3, 4);"
 
     parsed = parse("insert into test (age, salary) values (1, 2), (3, 4)")[0]
     stiter = process_statement(parsed)
     statement = next(stiter)
     query = tlist2str(statement)
-    assert query == u"INSERT INTO test (age, salary) VALUES  (1, 2)\n"
+    assert query == u"INSERT INTO test (age, salary) VALUES (1, 2)\n"
     statement = next(stiter)
     query = tlist2str(statement)
-    assert query == u"INSERT INTO test (age, salary) VALUES  (3, 4)"
+    assert query == u"INSERT INTO test (age, salary) VALUES (3, 4)"
 
 
 def test_process():