X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=tests%2Ftest_tokens.py;h=24866548cfa3b9abbbbd77d2ef35803badacb5b8;hb=bc473dfbbebeea2e2f4e0f368408632e047949ac;hp=692121ed321a84613e731b270ba8246997e9e587;hpb=dbc9220a2b29725f94637607f8d8b00c762deb67;p=sqlconvert.git diff --git a/tests/test_tokens.py b/tests/test_tokens.py index 692121e..2486654 100755 --- a/tests/test_tokens.py +++ b/tests/test_tokens.py @@ -5,17 +5,12 @@ import unittest from sqlparse import parse from sqlconvert.print_tokens import tlist2str -from sqlconvert.process_mysql import requote_names +from sqlconvert.process_mysql import remove_directive_tokens, requote_names, \ + is_directive_statement, process_statement from tests import main class TestTokens(unittest.TestCase): - def test_requote(self): - parsed = parse("select * from `T`")[0] - requote_names(parsed) - query = tlist2str(parsed) - self.assertEqual(query, 'SELECT * FROM "T"') - def test_encoding(self): parsed = parse("insert into test (1, 'тест')", 'utf-8')[0] query = tlist2str(parsed).encode('utf-8') @@ -27,6 +22,30 @@ class TestTokens(unittest.TestCase): query = tlist2str(parsed) self.assertEqual(query, u"INSERT INTO test (1, 'тест')") + def test_requote(self): + parsed = parse("select * from `T`")[0] + requote_names(parsed) + query = tlist2str(parsed) + self.assertEqual(query, 'SELECT * FROM "T"') + + def test_directive(self): + parsed = parse("select /*! test */ * from /* test */ `T`")[0] + remove_directive_tokens(parsed) + query = tlist2str(parsed) + self.assertEqual(query, 'SELECT * FROM /* test */ `T`') + + def test_directive_statement(self): + parsed = parse("/*! test */ test ;")[0] + self.assertFalse(is_directive_statement(parsed)) + parsed = parse("/*! test */ ;")[0] + self.assertTrue(is_directive_statement(parsed)) + + def test_process(self): + parsed = parse("select /*! test */ * from /* test */ `T`")[0] + process_statement(parsed) + query = tlist2str(parsed) + self.assertEqual(query, 'SELECT * FROM /* test */ "T"') + if __name__ == "__main__": main()