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, 70 insertions, 66 deletions

diff --git a/lib/sqlalchemy/testing/suite/test_sequence.py b/lib/sqlalchemy/testing/suite/test_sequence.py
index f1c00de6b..15a850fe9 100644
--- a/lib/sqlalchemy/testing/suite/test_sequence.py
+++ b/lib/sqlalchemy/testing/suite/test_sequence.py
@@ -9,140 +9,144 @@ from ..schema import Table, Column
 
 
 class SequenceTest(fixtures.TablesTest):
-    __requires__ = ('sequences',)
+    __requires__ = ("sequences",)
     __backend__ = True
 
-    run_create_tables = 'each'
+    run_create_tables = "each"
 
     @classmethod
     def define_tables(cls, metadata):
-        Table('seq_pk', metadata,
-              Column('id', Integer, Sequence('tab_id_seq'), primary_key=True),
-              Column('data', String(50))
-              )
+        Table(
+            "seq_pk",
+            metadata,
+            Column("id", Integer, Sequence("tab_id_seq"), primary_key=True),
+            Column("data", String(50)),
+        )
 
-        Table('seq_opt_pk', metadata,
-              Column('id', Integer, Sequence('tab_id_seq', optional=True),
-                     primary_key=True),
-              Column('data', String(50))
-              )
+        Table(
+            "seq_opt_pk",
+            metadata,
+            Column(
+                "id",
+                Integer,
+                Sequence("tab_id_seq", optional=True),
+                primary_key=True,
+            ),
+            Column("data", String(50)),
+        )
 
     def test_insert_roundtrip(self):
-        config.db.execute(
-            self.tables.seq_pk.insert(),
-            data="some data"
-        )
+        config.db.execute(self.tables.seq_pk.insert(), data="some data")
         self._assert_round_trip(self.tables.seq_pk, config.db)
 
     def test_insert_lastrowid(self):
-        r = config.db.execute(
-            self.tables.seq_pk.insert(),
-            data="some data"
-        )
-        eq_(
-            r.inserted_primary_key,
-            [1]
-        )
+        r = config.db.execute(self.tables.seq_pk.insert(), data="some data")
+        eq_(r.inserted_primary_key, [1])
 
     def test_nextval_direct(self):
-        r = config.db.execute(
-            self.tables.seq_pk.c.id.default
-        )
-        eq_(
-            r, 1
-        )
+        r = config.db.execute(self.tables.seq_pk.c.id.default)
+        eq_(r, 1)
 
     @requirements.sequences_optional
     def test_optional_seq(self):
         r = config.db.execute(
-            self.tables.seq_opt_pk.insert(),
-            data="some data"
-        )
-        eq_(
-            r.inserted_primary_key,
-            [1]
+            self.tables.seq_opt_pk.insert(), data="some data"
         )
+        eq_(r.inserted_primary_key, [1])
 
     def _assert_round_trip(self, table, conn):
         row = conn.execute(table.select()).first()
-        eq_(
-            row,
-            (1, "some data")
-        )
+        eq_(row, (1, "some data"))
 
 
 class SequenceCompilerTest(testing.AssertsCompiledSQL, fixtures.TestBase):
-    __requires__ = ('sequences',)
+    __requires__ = ("sequences",)
     __backend__ = True
 
     def test_literal_binds_inline_compile(self):
         table = Table(
-            'x', MetaData(),
-            Column('y', Integer, Sequence('y_seq')),
-            Column('q', Integer))
+            "x",
+            MetaData(),
+            Column("y", Integer, Sequence("y_seq")),
+            Column("q", Integer),
+        )
 
         stmt = table.insert().values(q=5)
 
         seq_nextval = testing.db.dialect.statement_compiler(
-            statement=None, dialect=testing.db.dialect).visit_sequence(
-            Sequence("y_seq"))
+            statement=None, dialect=testing.db.dialect
+        ).visit_sequence(Sequence("y_seq"))
         self.assert_compile(
             stmt,
-            "INSERT INTO x (y, q) VALUES (%s, 5)" % (seq_nextval, ),
+            "INSERT INTO x (y, q) VALUES (%s, 5)" % (seq_nextval,),
             literal_binds=True,
-            dialect=testing.db.dialect)
+            dialect=testing.db.dialect,
+        )
 
 
 class HasSequenceTest(fixtures.TestBase):
-    __requires__ = 'sequences',
+    __requires__ = ("sequences",)
     __backend__ = True
 
     def test_has_sequence(self):
-        s1 = Sequence('user_id_seq')
+        s1 = Sequence("user_id_seq")
         testing.db.execute(schema.CreateSequence(s1))
         try:
-            eq_(testing.db.dialect.has_sequence(testing.db,
-                                                'user_id_seq'), True)
+            eq_(
+                testing.db.dialect.has_sequence(testing.db, "user_id_seq"),
+                True,
+            )
         finally:
             testing.db.execute(schema.DropSequence(s1))
 
     @testing.requires.schemas
     def test_has_sequence_schema(self):
-        s1 = Sequence('user_id_seq', schema=config.test_schema)
+        s1 = Sequence("user_id_seq", schema=config.test_schema)
         testing.db.execute(schema.CreateSequence(s1))
         try:
-            eq_(testing.db.dialect.has_sequence(
-                testing.db, 'user_id_seq', schema=config.test_schema), True)
+            eq_(
+                testing.db.dialect.has_sequence(
+                    testing.db, "user_id_seq", schema=config.test_schema
+                ),
+                True,
+            )
         finally:
             testing.db.execute(schema.DropSequence(s1))
 
     def test_has_sequence_neg(self):
-        eq_(testing.db.dialect.has_sequence(testing.db, 'user_id_seq'),
-            False)
+        eq_(testing.db.dialect.has_sequence(testing.db, "user_id_seq"), False)
 
     @testing.requires.schemas
     def test_has_sequence_schemas_neg(self):
-        eq_(testing.db.dialect.has_sequence(testing.db, 'user_id_seq',
-                                            schema=config.test_schema),
-            False)
+        eq_(
+            testing.db.dialect.has_sequence(
+                testing.db, "user_id_seq", schema=config.test_schema
+            ),
+            False,
+        )
 
     @testing.requires.schemas
     def test_has_sequence_default_not_in_remote(self):
-        s1 = Sequence('user_id_seq')
+        s1 = Sequence("user_id_seq")
         testing.db.execute(schema.CreateSequence(s1))
         try:
-            eq_(testing.db.dialect.has_sequence(testing.db, 'user_id_seq',
-                                                schema=config.test_schema),
-                False)
+            eq_(
+                testing.db.dialect.has_sequence(
+                    testing.db, "user_id_seq", schema=config.test_schema
+                ),
+                False,
+            )
         finally:
             testing.db.execute(schema.DropSequence(s1))
 
     @testing.requires.schemas
     def test_has_sequence_remote_not_in_default(self):
-        s1 = Sequence('user_id_seq', schema=config.test_schema)
+        s1 = Sequence("user_id_seq", schema=config.test_schema)
         testing.db.execute(schema.CreateSequence(s1))
         try:
-            eq_(testing.db.dialect.has_sequence(testing.db, 'user_id_seq'),
-                False)
+            eq_(
+                testing.db.dialect.has_sequence(testing.db, "user_id_seq"),
+                False,
+            )
         finally:
             testing.db.execute(schema.DropSequence(s1))