from sqlparse import parse
from sqlconvert.print_tokens import tlist2str
-from sqlconvert.process_mysql import requote_names, remove_directives, \
+from sqlconvert.process_mysql import remove_directive_tokens, \
+ is_directive_statement, requote_names, unescape_strings, \
process_statement
from tests import main
query = tlist2str(parsed)
self.assertEqual(query, u"INSERT INTO test (1, 'ัะตัั')")
+ def test_directive(self):
+ parsed = parse("select /*! test */ * from /* test */ `T`")[0]
+ remove_directive_tokens(parsed)
+ query = tlist2str(parsed)
+ self.assertEqual(query, u'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_requote(self):
parsed = parse("select * from `T`")[0]
requote_names(parsed)
query = tlist2str(parsed)
- self.assertEqual(query, 'SELECT * FROM "T"')
+ self.assertEqual(query, u'SELECT * FROM "T"')
- def test_directives(self):
- parsed = parse("select /*! test */ * from /* test */ `T`")[0]
- remove_directives(parsed)
+ def test_string(self):
+ parsed = parse("insert into test values ('\"test\\\"')")[0]
+ unescape_strings(parsed)
query = tlist2str(parsed)
- self.assertEqual(query, 'SELECT * FROM /* test */ `T`')
+ self.assertEqual(query, u"INSERT INTO test VALUES ('\"test\"')")
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"')
+ self.assertEqual(query, u'SELECT * FROM /* test */ "T"')
if __name__ == "__main__":