From 772374735da27df1ddb907f4a0f5085b46dbe82b Mon Sep 17 00:00:00 2001 From: Khairi Hafsham Date: Thu, 2 Feb 2017 13:02:21 -0500 Subject: Make all tests to be PEP8 compliant tested using pycodestyle version 2.2.0 Fixes: #3885 Change-Id: I5df43adc3aefe318f9eeab72a078247a548ec566 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/343 --- test/dialect/postgresql/test_compiler.py | 35 ++++++++++++++++++++------------ 1 file changed, 22 insertions(+), 13 deletions(-) (limited to 'test/dialect/postgresql/test_compiler.py') diff --git a/test/dialect/postgresql/test_compiler.py b/test/dialect/postgresql/test_compiler.py index 160641855..eddf20877 100644 --- a/test/dialect/postgresql/test_compiler.py +++ b/test/dialect/postgresql/test_compiler.py @@ -17,6 +17,7 @@ from sqlalchemy.sql import util as sql_util from sqlalchemy.util import u, OrderedDict from sqlalchemy.dialects.postgresql import aggregate_order_by, insert + class SequenceTest(fixtures.TestBase, AssertsCompiledSQL): __prefer__ = 'postgresql' @@ -414,9 +415,14 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): m = MetaData() tbl = Table('testtbl', m, Column('data', String)) - idx1 = Index('test_idx1', tbl.c.data) - idx2 = Index('test_idx2', tbl.c.data, postgresql_tablespace='sometablespace') - idx3 = Index('test_idx3', tbl.c.data, postgresql_tablespace='another table space') + idx1 = Index('test_idx1', + tbl.c.data) + idx2 = Index('test_idx2', + tbl.c.data, + postgresql_tablespace='sometablespace') + idx3 = Index('test_idx3', + tbl.c.data, + postgresql_tablespace='another table space') self.assert_compile(schema.CreateIndex(idx1), 'CREATE INDEX test_idx1 ON testtbl ' @@ -437,13 +443,12 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): m = MetaData() tbl = Table('testtbl', m, Column('data', String)) - idx1 = Index( - 'test_idx1', - tbl.c.data, - postgresql_using='btree', - postgresql_tablespace='atablespace', - postgresql_with={"fillfactor": 60}, - postgresql_where=and_(tbl.c.data > 5, tbl.c.data < 10)) + idx1 = Index('test_idx1', + tbl.c.data, + postgresql_using='btree', + postgresql_tablespace='atablespace', + postgresql_with={"fillfactor": 60}, + postgresql_where=and_(tbl.c.data > 5, tbl.c.data < 10)) self.assert_compile(schema.CreateIndex(idx1), 'CREATE INDEX test_idx1 ON testtbl ' @@ -928,8 +933,11 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): postgresql.array([1, 2]) == [3, 4, 5], "ARRAY[%(param_1)s, %(param_2)s] = " "ARRAY[%(param_3)s, %(param_4)s, %(param_5)s]", - checkparams={'param_5': 5, 'param_4': 4, 'param_1': 1, - 'param_3': 3, 'param_2': 2} + checkparams={'param_5': 5, + 'param_4': 4, + 'param_1': 1, + 'param_3': 3, + 'param_2': 2} ) @@ -1053,7 +1061,8 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): stmt2 = sql_util.ClauseAdapter(a1).traverse(stmt) self.assert_compile( stmt2, - "SELECT array_agg(foo.a ORDER BY foo.b DESC) AS array_agg_1 FROM table1 AS foo" + "SELECT array_agg(foo.a ORDER BY foo.b DESC) AS array_agg_1 " + "FROM table1 AS foo" ) -- cgit v1.2.1