From 49f89cd8745e0c0cb1cb428e1e475fa15ad45234 Mon Sep 17 00:00:00 2001 From: John Lennox Date: Wed, 3 Aug 2022 20:22:05 -0400 Subject: [PATCH] Fixes Issue #8288 Correcting Flake8 formatting issues --- lib/sqlalchemy/dialects/mssql/base.py | 8 ++++++-- test/dialect/mssql/test_reflection.py | 4 ++-- 2 files changed, 8 insertions(+), 4 deletions(-) diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 628f388cf0..ad2aa7fc0e 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -3143,7 +3143,9 @@ class MSDialect(default.DefaultDialect): rp = connection.execution_options(future_result=True).execute( sql.text( "select ind.index_id, ind.is_unique, ind.name, " - "case when ind.index_id = 1 then cast(1 as bit) else cast(0 as bit) end as is_clustered, " + "case when ind.index_id = 1 " + "then cast(1 as bit) " + "else cast(0 as bit) end as is_clustered, " f"{filter_definition} " "from sys.indexes as ind join sys.tables as tab on " "ind.object_id=tab.object_id " @@ -3454,7 +3456,9 @@ class MSDialect(default.DefaultDialect): TC.c.constraint_type, C.c.constraint_name, text( - "objectproperty(object_id(c.table_schema+'.'+c.constraint_name), 'CnstIsClustKey') as is_clustered" + "objectproperty(" + "object_id(c.table_schema+'.'+c.constraint_name)," + "'CnstIsClustKey') as is_clustered" ), ) .where( diff --git a/test/dialect/mssql/test_reflection.py b/test/dialect/mssql/test_reflection.py index 973acf19fd..b42debeff1 100644 --- a/test/dialect/mssql/test_reflection.py +++ b/test/dialect/mssql/test_reflection.py @@ -608,8 +608,8 @@ class ReflectionTest(fixtures.TestBase, ComparesTables, AssertsCompiledSQL): self, metadata, connection ): """ - table with one filtered index and one clustered index so each index will have different - dialect_options keys + table with one filtered index and one clustered index so each index + will have different dialect_options keys """ t1 = Table( "t", -- 2.47.3