From e6779d84376e32941be36a97c75ecd4ab6d480d8 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 11 Oct 2015 12:08:53 -0400 Subject: [PATCH] - repair flake8 issues --- test/dialect/postgresql/test_query.py | 93 ++++++++++++++------------- 1 file changed, 49 insertions(+), 44 deletions(-) diff --git a/test/dialect/postgresql/test_query.py b/test/dialect/postgresql/test_query.py index b71cdedebd..cd61bdb0d1 100644 --- a/test/dialect/postgresql/test_query.py +++ b/test/dialect/postgresql/test_query.py @@ -49,8 +49,9 @@ class InsertTest(fixtures.TestBase, AssertsExecutionResults): ) def test_foreignkey_missing_insert(self): - t1 = Table('t1', metadata, Column('id', Integer, - primary_key=True)) + Table( + 't1', metadata, + Column('id', Integer, primary_key=True)) t2 = Table( 't2', metadata, @@ -78,7 +79,6 @@ class InsertTest(fixtures.TestBase, AssertsExecutionResults): eng.execute, t2.insert() ) - def test_sequence_insert(self): table = Table( 'testtable', @@ -327,17 +327,17 @@ class InsertTest(fixtures.TestBase, AssertsExecutionResults): asserter.assert_( DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - {'id': 30, 'data': 'd1'}), + {'id': 30, 'data': 'd1'}), DialectSQL('INSERT INTO testtable (data) VALUES (:data) RETURNING ' - 'testtable.id', {'data': 'd2'}), + 'testtable.id', {'data': 'd2'}), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), + [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), DialectSQL('INSERT INTO testtable (data) VALUES (:data)', - [{'data': 'd5'}, {'data': 'd6'}]), + [{'data': 'd5'}, {'data': 'd6'}]), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 33, 'data': 'd7'}]), + [{'id': 33, 'data': 'd7'}]), DialectSQL('INSERT INTO testtable (data) VALUES (:data)', - [{'data': 'd8'}]), + [{'data': 'd8'}]), ) eq_( @@ -373,16 +373,18 @@ class InsertTest(fixtures.TestBase, AssertsExecutionResults): asserter.assert_( DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - {'id': 30, 'data': 'd1'}), + {'id': 30, 'data': 'd1'}), DialectSQL('INSERT INTO testtable (data) VALUES (:data) RETURNING ' - 'testtable.id', {'data': 'd2'}), + 'testtable.id', {'data': 'd2'}), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), + [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), DialectSQL('INSERT INTO testtable (data) VALUES (:data)', - [{'data': 'd5'}, {'data': 'd6'}]), + [{'data': 'd5'}, {'data': 'd6'}]), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 33, 'data': 'd7'}]), - DialectSQL('INSERT INTO testtable (data) VALUES (:data)', [{'data': 'd8'}]), + [{'id': 33, 'data': 'd7'}]), + DialectSQL( + 'INSERT INTO testtable (data) VALUES (:data)', + [{'data': 'd8'}]), ) eq_( table.select().execute().fetchall(), @@ -415,18 +417,20 @@ class InsertTest(fixtures.TestBase, AssertsExecutionResults): asserter.assert_( DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - {'id': 30, 'data': 'd1'}), + {'id': 30, 'data': 'd1'}), CursorSQL("select nextval('my_seq')"), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - {'id': 1, 'data': 'd2'}), + {'id': 1, 'data': 'd2'}), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), - DialectSQL("INSERT INTO testtable (id, data) VALUES (nextval('%s'), " - ":data)" % seqname, [{'data': 'd5'}, {'data': 'd6'}]), + [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), + DialectSQL( + "INSERT INTO testtable (id, data) VALUES (nextval('%s'), " + ":data)" % seqname, [{'data': 'd5'}, {'data': 'd6'}]), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 33, 'data': 'd7'}]), - DialectSQL("INSERT INTO testtable (id, data) VALUES (nextval('%s'), " - ":data)" % seqname, [{'data': 'd8'}]), + [{'id': 33, 'data': 'd7'}]), + DialectSQL( + "INSERT INTO testtable (id, data) VALUES (nextval('%s'), " + ":data)" % seqname, [{'data': 'd8'}]), ) eq_( table.select().execute().fetchall(), @@ -461,18 +465,20 @@ class InsertTest(fixtures.TestBase, AssertsExecutionResults): asserter.assert_( DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - {'id': 30, 'data': 'd1'}), + {'id': 30, 'data': 'd1'}), DialectSQL("INSERT INTO testtable (id, data) VALUES " - "(nextval('my_seq'), :data) RETURNING testtable.id", - {'data': 'd2'}), + "(nextval('my_seq'), :data) RETURNING testtable.id", + {'data': 'd2'}), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), - DialectSQL("INSERT INTO testtable (id, data) VALUES (nextval('%s'), " - ":data)" % seqname, [{'data': 'd5'}, {'data': 'd6'}]), + [{'id': 31, 'data': 'd3'}, {'id': 32, 'data': 'd4'}]), + DialectSQL( + "INSERT INTO testtable (id, data) VALUES (nextval('%s'), " + ":data)" % seqname, [{'data': 'd5'}, {'data': 'd6'}]), DialectSQL('INSERT INTO testtable (id, data) VALUES (:id, :data)', - [{'id': 33, 'data': 'd7'}]), - DialectSQL("INSERT INTO testtable (id, data) VALUES (nextval('%s'), " - ":data)" % seqname, [{'data': 'd8'}]), + [{'id': 33, 'data': 'd7'}]), + DialectSQL( + "INSERT INTO testtable (id, data) VALUES (nextval('%s'), " + ":data)" % seqname, [{'data': 'd8'}]), ) eq_( @@ -875,17 +881,16 @@ class ExtractTest(fixtures.TablesTest): return datetime.timedelta(hours=4) cls.bind.execute( - cls.tables.t.insert(), - { - 'dtme': datetime.datetime(2012, 5, 10, 12, 15, 25), - 'dt': datetime.date(2012, 5, 10), - 'tm': datetime.time(12, 15, 25), - 'intv': datetime.timedelta(seconds=570), - 'dttz': - datetime.datetime(2012, 5, 10, 12, 15, 25, - tzinfo=TZ()) - }, - ) + cls.tables.t.insert(), + { + 'dtme': datetime.datetime(2012, 5, 10, 12, 15, 25), + 'dt': datetime.date(2012, 5, 10), + 'tm': datetime.time(12, 15, 25), + 'intv': datetime.timedelta(seconds=570), + 'dttz': datetime.datetime(2012, 5, 10, 12, 15, 25, + tzinfo=TZ()) + }, + ) def _test(self, expr, field="all", overrides=None): t = self.tables.t @@ -925,7 +930,7 @@ class ExtractTest(fixtures.TablesTest): overrides={"epoch": 1336652695.0, "minute": 24}) def test_three(self): - t = self.tables.t + self.tables.t actual_ts = self.bind.scalar(func.current_timestamp()) - \ datetime.timedelta(days=5) -- 2.47.2