Run black -l 79 against all source files

This is a straight reformat run using black as is, with no edits
applied at all.

The black run will format code consistently, however in
some cases that are prevalent in SQLAlchemy code it produces
too-long lines.   The too-long lines will be resolved in the
following commit that will resolve all remaining flake8 issues
including shadowed builtins, long lines, import order, unused
imports, duplicate imports, and docstring issues.

Change-Id: I7eda77fed3d8e73df84b3651fd6cfcfe858d4dc9

1 files changed, 74 insertions, 58 deletions

diff --git a/lib/sqlalchemy/testing/suite/test_cte.py b/lib/sqlalchemy/testing/suite/test_cte.py
index cc72278e6..d2f35933b 100644
--- a/lib/sqlalchemy/testing/suite/test_cte.py
+++ b/lib/sqlalchemy/testing/suite/test_cte.py
@@ -10,22 +10,28 @@ from ..schema import Table, Column
 
 class CTETest(fixtures.TablesTest):
     __backend__ = True
-    __requires__ = 'ctes',
+    __requires__ = ("ctes",)
 
-    run_inserts = 'each'
-    run_deletes = 'each'
+    run_inserts = "each"
+    run_deletes = "each"
 
     @classmethod
     def define_tables(cls, metadata):
-        Table("some_table", metadata,
-              Column('id', Integer, primary_key=True),
-              Column('data', String(50)),
-              Column("parent_id", ForeignKey("some_table.id")))
+        Table(
+            "some_table",
+            metadata,
+            Column("id", Integer, primary_key=True),
+            Column("data", String(50)),
+            Column("parent_id", ForeignKey("some_table.id")),
+        )
 
-        Table("some_other_table", metadata,
-              Column('id', Integer, primary_key=True),
-              Column('data', String(50)),
-              Column("parent_id", Integer))
+        Table(
+            "some_other_table",
+            metadata,
+            Column("id", Integer, primary_key=True),
+            Column("data", String(50)),
+            Column("parent_id", Integer),
+        )
 
     @classmethod
     def insert_data(cls):
@@ -36,28 +42,33 @@ class CTETest(fixtures.TablesTest):
                 {"id": 2, "data": "d2", "parent_id": 1},
                 {"id": 3, "data": "d3", "parent_id": 1},
                 {"id": 4, "data": "d4", "parent_id": 3},
-                {"id": 5, "data": "d5", "parent_id": 3}
-            ]
+                {"id": 5, "data": "d5", "parent_id": 3},
+            ],
         )
 
     def test_select_nonrecursive_round_trip(self):
         some_table = self.tables.some_table
 
         with config.db.connect() as conn:
-            cte = select([some_table]).where(
-                some_table.c.data.in_(["d2", "d3", "d4"])).cte("some_cte")
+            cte = (
+                select([some_table])
+                .where(some_table.c.data.in_(["d2", "d3", "d4"]))
+                .cte("some_cte")
+            )
             result = conn.execute(
                 select([cte.c.data]).where(cte.c.data.in_(["d4", "d5"]))
             )
-            eq_(result.fetchall(), [("d4", )])
+            eq_(result.fetchall(), [("d4",)])
 
     def test_select_recursive_round_trip(self):
         some_table = self.tables.some_table
 
         with config.db.connect() as conn:
-            cte = select([some_table]).where(
-                some_table.c.data.in_(["d2", "d3", "d4"])).cte(
-                "some_cte", recursive=True)
+            cte = (
+                select([some_table])
+                .where(some_table.c.data.in_(["d2", "d3", "d4"]))
+                .cte("some_cte", recursive=True)
+            )
 
             cte_alias = cte.alias("c1")
             st1 = some_table.alias()
@@ -67,12 +78,13 @@ class CTETest(fixtures.TablesTest):
                 select([st1]).where(st1.c.id == cte_alias.c.parent_id)
             )
             result = conn.execute(
-                select([cte.c.data]).where(
-                    cte.c.data != "d2").order_by(cte.c.data.desc())
+                select([cte.c.data])
+                .where(cte.c.data != "d2")
+                .order_by(cte.c.data.desc())
             )
             eq_(
                 result.fetchall(),
-                [('d4',), ('d3',), ('d3',), ('d1',), ('d1',), ('d1',)]
+                [("d4",), ("d3",), ("d3",), ("d1",), ("d1",), ("d1",)],
             )
 
     def test_insert_from_select_round_trip(self):
@@ -80,20 +92,21 @@ class CTETest(fixtures.TablesTest):
         some_other_table = self.tables.some_other_table
 
         with config.db.connect() as conn:
-            cte = select([some_table]).where(
-                some_table.c.data.in_(["d2", "d3", "d4"])
-            ).cte("some_cte")
+            cte = (
+                select([some_table])
+                .where(some_table.c.data.in_(["d2", "d3", "d4"]))
+                .cte("some_cte")
+            )
             conn.execute(
                 some_other_table.insert().from_select(
-                    ["id", "data", "parent_id"],
-                    select([cte])
+                    ["id", "data", "parent_id"], select([cte])
                 )
             )
             eq_(
                 conn.execute(
                     select([some_other_table]).order_by(some_other_table.c.id)
                 ).fetchall(),
-                [(2, "d2", 1), (3, "d3", 1), (4, "d4", 3)]
+                [(2, "d2", 1), (3, "d3", 1), (4, "d4", 3)],
             )
 
     @testing.requires.ctes_with_update_delete
@@ -105,27 +118,31 @@ class CTETest(fixtures.TablesTest):
         with config.db.connect() as conn:
             conn.execute(
                 some_other_table.insert().from_select(
-                    ['id', 'data', 'parent_id'],
-                    select([some_table])
+                    ["id", "data", "parent_id"], select([some_table])
                 )
             )
 
-            cte = select([some_table]).where(
-                some_table.c.data.in_(["d2", "d3", "d4"])
-            ).cte("some_cte")
+            cte = (
+                select([some_table])
+                .where(some_table.c.data.in_(["d2", "d3", "d4"]))
+                .cte("some_cte")
+            )
             conn.execute(
-                some_other_table.update().values(parent_id=5).where(
-                    some_other_table.c.data == cte.c.data
-                )
+                some_other_table.update()
+                .values(parent_id=5)
+                .where(some_other_table.c.data == cte.c.data)
             )
             eq_(
                 conn.execute(
                     select([some_other_table]).order_by(some_other_table.c.id)
                 ).fetchall(),
                 [
-                    (1, "d1", None), (2, "d2", 5),
-                    (3, "d3", 5), (4, "d4", 5), (5, "d5", 3)
-                ]
+                    (1, "d1", None),
+                    (2, "d2", 5),
+                    (3, "d3", 5),
+                    (4, "d4", 5),
+                    (5, "d5", 3),
+                ],
             )
 
     @testing.requires.ctes_with_update_delete
@@ -137,14 +154,15 @@ class CTETest(fixtures.TablesTest):
         with config.db.connect() as conn:
             conn.execute(
                 some_other_table.insert().from_select(
-                    ['id', 'data', 'parent_id'],
-                    select([some_table])
+                    ["id", "data", "parent_id"], select([some_table])
                 )
             )
 
-            cte = select([some_table]).where(
-                some_table.c.data.in_(["d2", "d3", "d4"])
-            ).cte("some_cte")
+            cte = (
+                select([some_table])
+                .where(some_table.c.data.in_(["d2", "d3", "d4"]))
+                .cte("some_cte")
+            )
             conn.execute(
                 some_other_table.delete().where(
                     some_other_table.c.data == cte.c.data
@@ -154,9 +172,7 @@ class CTETest(fixtures.TablesTest):
                 conn.execute(
                     select([some_other_table]).order_by(some_other_table.c.id)
                 ).fetchall(),
-                [
-                    (1, "d1", None), (5, "d5", 3)
-                ]
+                [(1, "d1", None), (5, "d5", 3)],
             )
 
     @testing.requires.ctes_with_update_delete
@@ -168,26 +184,26 @@ class CTETest(fixtures.TablesTest):
         with config.db.connect() as conn:
             conn.execute(
                 some_other_table.insert().from_select(
-                    ['id', 'data', 'parent_id'],
-                    select([some_table])
+                    ["id", "data", "parent_id"], select([some_table])
                 )
             )
 
-            cte = select([some_table]).where(
-                some_table.c.data.in_(["d2", "d3", "d4"])
-            ).cte("some_cte")
+            cte = (
+                select([some_table])
+                .where(some_table.c.data.in_(["d2", "d3", "d4"]))
+                .cte("some_cte")
+            )
             conn.execute(
                 some_other_table.delete().where(
-                    some_other_table.c.data ==
-                    select([cte.c.data]).where(
-                        cte.c.id == some_other_table.c.id)
+                    some_other_table.c.data
+                    == select([cte.c.data]).where(
+                        cte.c.id == some_other_table.c.id
+                    )
                 )
             )
             eq_(
                 conn.execute(
                     select([some_other_table]).order_by(some_other_table.c.id)
                 ).fetchall(),
-                [
-                    (1, "d1", None), (5, "d5", 3)
-                ]
+                [(1, "d1", None), (5, "d5", 3)],
             )