X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=tests%2Ftest_stgrouper.py;h=88d0fcf2eefce1b6cc74821e9c92f0181028e657;hb=d6d2d76d2b29e8384169c5b86e19e494fab1a464;hp=0e72ced759e47ecad9130d1012c05d84a53ba1e4;hpb=031cc0d6a41717d4c5d7c4659290e05810202eb9;p=sqlconvert.git

diff --git a/tests/test_stgrouper.py b/tests/test_stgrouper.py
old mode 100755
new mode 100644
index 0e72ced..88d0fcf
--- a/tests/test_stgrouper.py
+++ b/tests/test_stgrouper.py
@@ -1,37 +1,26 @@
-#! /usr/bin/env python
 
+from pytest import raises
+from sqlconvert.print_tokens import tlist2str
+from sqlconvert.process_mysql import requote_names
+from sqlconvert.process_tokens import StatementGrouper
 
-import unittest
-from sqlparse import parse
 
-from mysql2sql.print_tokens import tlist2str
-from mysql2sql.process_tokens import requote_names, StatementGrouper
-from tests import main
-
-
-class TestStGrouper(unittest.TestCase):
+class TestStGrouper(object):
     def test_incomplete(self):
         grouper = StatementGrouper()
-        parsed = parse("select * from `T`")[0]
-        grouper.process(parsed)
-        self.assertFalse(grouper.statements)
-        self.assertEqual(len(grouper.statements), 0)
-        self.assertRaises(ValueError, grouper.close)
+        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()
-        parsed = parse("select * from `T`;")[0]
-        grouper.process(parsed)
-        self.assertTrue(grouper.statements)
-        self.assertEqual(len(grouper.statements), 1)
-        g = grouper.get_statements()
-        statement = next(g)
-        requote_names(statement)
-        query = tlist2str(parsed)
-        self.assertEqual(query, 'SELECT * FROM "T";')
-        self.assertRaises(StopIteration, next, g)
-        self.assertEqual(len(grouper.statements), 0)
-        self.assertIsNone(grouper.close())
-
-if __name__ == "__main__":
-    main()
+        grouper.process_line("select * from `T`;")
+        assert grouper.statements
+        assert len(grouper.statements) == 1
+        for statement in grouper.get_statements():
+            requote_names(statement)
+            query = tlist2str(statement)
+            assert query == 'SELECT * FROM "T";'
+        assert len(grouper.statements) == 0
+        assert grouper.close() is None