Update black flak8 and zimports

Change-Id: I488c9557eda390e4a88319affd4c8813ee274f80

6 files changed, 5 insertions, 7 deletions

diff --git a/test/sql/test_cte.py b/test/sql/test_cte.py
index 25d7e33ba..59358aadf 100644
--- a/test/sql/test_cte.py
+++ b/test/sql/test_cte.py
@@ -265,8 +265,6 @@ class CTETest(fixtures.TestBase, AssertsCompiledSQL):
         )
 
     def test_recursive_union_alias_two(self):
-        """"""
-
         # I know, this is the PG VALUES keyword,
         # we're cheating here.  also yes we need the SELECT,
         # sorry PG.
diff --git a/test/sql/test_deprecations.py b/test/sql/test_deprecations.py
index 8dba8cb83..7b2b6c57e 100644
--- a/test/sql/test_deprecations.py
+++ b/test/sql/test_deprecations.py
@@ -2618,7 +2618,7 @@ class LegacySequenceExecTest(fixtures.TestBase):
             self._assert_seq_result(testing.db.scalar(s.next_value()))
 
     def test_func_implicit_connectionless_scalar(self):
-        """test func.next_value().execute()/.scalar() works. """
+        """test func.next_value().execute()/.scalar() works."""
 
         with testing.expect_deprecated_20(
             r"The MetaData.bind argument is deprecated"
diff --git a/test/sql/test_operators.py b/test/sql/test_operators.py
index 984379c6b..43d9133a7 100644
--- a/test/sql/test_operators.py
+++ b/test/sql/test_operators.py
@@ -2107,7 +2107,7 @@ class InTest(fixtures.TestBase, testing.AssertsCompiledSQL):
         )
 
     def test_scalar_subquery_wo_type(self):
-        """ test for :ticket:`6181` """
+        """test for :ticket:`6181`"""
 
         m = MetaData()
         t = Table("t", m, Column("a", Integer))
diff --git a/test/sql/test_query.py b/test/sql/test_query.py
index a22cf1098..14dc397f6 100644
--- a/test/sql/test_query.py
+++ b/test/sql/test_query.py
@@ -780,7 +780,7 @@ class QueryTest(fixtures.TablesTest):
         )
 
     def test_expanding_in_dont_alter_compiled(self, connection):
-        """test for issue #5048 """
+        """test for issue #5048"""
 
         class NameWithProcess(TypeDecorator):
             impl = String
diff --git a/test/sql/test_roles.py b/test/sql/test_roles.py
index 37f75594b..ff4f10f1a 100644
--- a/test/sql/test_roles.py
+++ b/test/sql/test_roles.py
@@ -147,7 +147,7 @@ class RoleTest(fixtures.TestBase):
         )
 
     def test_untyped_scalar_subquery(self):
-        """test for :ticket:`6181` """
+        """test for :ticket:`6181`"""
 
         c = column("q")
         subq = select(c).scalar_subquery()
diff --git a/test/sql/test_update.py b/test/sql/test_update.py
index 26b0f6217..8004e6a4c 100644
--- a/test/sql/test_update.py
+++ b/test/sql/test_update.py
@@ -369,7 +369,7 @@ class UpdateTest(_UpdateFromTestBase, fixtures.TablesTest, AssertsCompiledSQL):
         )
 
     def test_labels_no_collision_index(self):
-        """test for [ticket:4911] """
+        """test for [ticket:4911]"""
 
         t = Table(
             "foo",