X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=tests%2Ftest_process_mysql.py;h=c8b3b8cd48f3557abb6c2b6832a13aa550b2a654;hb=d830f4bcd21deb078a89d59e4d98a6406ce5661d;hp=45e5020de20fdc91f8b80f1fad67cd1e57f02939;hpb=d37aa4171740015b0e1f65b4678ccb02be9d8330;p=sqlconvert.git

diff --git a/tests/test_process_mysql.py b/tests/test_process_mysql.py
index 45e5020..c8b3b8c 100644
--- a/tests/test_process_mysql.py
+++ b/tests/test_process_mysql.py
@@ -57,11 +57,42 @@ def test_is_insert():
     parsed = parse("select /*! test */ * from /* test */ `T`")[0]
     statement = next(process_statement(parsed))
     assert not is_insert(statement)
+
     parsed = parse("insert into test values ('\"te\\'st\\\"\\n')")[0]
     statement = next(process_statement(parsed))
     assert is_insert(statement)
 
 
+def test_split_ext_insert():
+    parsed = parse("insert into test values (1, 2)")[0]
+    statement = next(process_statement(parsed))
+    query = tlist2str(statement)
+    assert query == u"INSERT INTO test VALUES (1, 2)"
+
+    parsed = parse("insert into test (age, salary) values (1, 2);")[0]
+    statement = next(process_statement(parsed))
+    query = tlist2str(statement)
+    assert query == u"INSERT INTO test (age, salary) VALUES (1, 2);"
+
+    parsed = parse("insert into test values (1, 2), (3, 4);")[0]
+    stiter = process_statement(parsed)
+    statement = next(stiter)
+    query = tlist2str(statement)
+    assert query == u"INSERT INTO test VALUES  (1, 2);"
+    statement = next(stiter)
+    query = tlist2str(statement)
+    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)"
+    statement = next(stiter)
+    query = tlist2str(statement)
+    assert query == u"INSERT INTO test (age, salary) VALUES  (3, 4)"
+
+
 def test_process():
     parsed = parse("select /*! test */ * from /* test */ `T`")[0]
     statement = next(process_statement(parsed))