X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=tests%2Ftest_process_mysql.py;h=656292b2f646ce1a70d9e8f3ecd1552ce6f9bbf8;hb=d73e4faa556e337eba2ffece77ae3d114bfc3da0;hp=df60a647d5de00a997bbc7248303af33b2ff0b55;hpb=95103778dd6d6d279d9b3c9f83ff49ea5920c6e5;p=sqlconvert.git diff --git a/tests/test_process_mysql.py b/tests/test_process_mysql.py index df60a64..656292b 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():