Fix a bug: assign buffer even if encoding is None

[sqlconvert.git] / tests / test_stgrouper.py

diff --git a/tests/test_stgrouper.py b/tests/test_stgrouper.py
old mode 100755 (executable)
new mode 100644 (file)
index 3354b02..994ef4e
--- a/tests/test_stgrouper.py
+++ b/tests/test_stgrouper.py
@@ -1,32 +1,24 @@
-#! /usr/bin/env python
-
-
-import unittest
 
+from pytest import raises
 from sqlconvert.print_tokens import tlist2str
-from sqlconvert.process_tokens import requote_names, StatementGrouper
-from tests import main
+from sqlconvert.process_tokens import StatementGrouper
 
 
-class TestStGrouper(unittest.TestCase):
-    def test_incomplete(self):
-        grouper = StatementGrouper()
-        grouper.process_line("select * from `T`")
-        self.assertFalse(grouper.statements)
-        self.assertEqual(len(grouper.statements), 0)
-        self.assertRaises(ValueError, grouper.close)
+def test_incomplete():
+    grouper = StatementGrouper()
+    grouper.process_line("select * from `T`")
+    assert not grouper.statements
+    assert len(grouper.statements) == 0
+    raises(ValueError, grouper.close)
 
-    def test_statements(self):
-        grouper = StatementGrouper()
-        grouper.process_line("select * from `T`;")
-        self.assertTrue(grouper.statements)
-        self.assertEqual(len(grouper.statements), 1)
-        for statement in grouper.get_statements():
-            requote_names(statement)
-            query = tlist2str(statement)
-            self.assertEqual(query, 'SELECT * FROM "T";')
-        self.assertEqual(len(grouper.statements), 0)
-        self.assertEqual(grouper.close(), None)
 
-if __name__ == "__main__":
-    main()
+def test_statements():
+    grouper = StatementGrouper()
+    grouper.process_line("select * from T;")
+    assert grouper.statements
+    assert len(grouper.statements) == 1
+    for statement in grouper.get_statements():
+        query = tlist2str(statement)
+        assert query == 'SELECT * FROM T;'
+    assert len(grouper.statements) == 0
+    assert grouper.close() is None