From 435e119bbcacb950de8e9d459e88de9b653d8918 Mon Sep 17 00:00:00 2001 From: Leonel Atencio Date: Sat, 27 Jul 2019 13:53:53 -0500 Subject: [PATCH] Lowercase! --- lib/sqlalchemy/dialects/mssql/base.py | 4 ++-- test/dialect/mssql/test_query.py | 5 +++-- 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 03027a0c84..36881c2b67 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -1173,7 +1173,7 @@ class SQL_VARIANT(sqltypes.TypeEngine): __visit_name__ = "SQL_VARIANT" -class TRY_CAST(elements.Cast): +class try_cast(elements.Cast): pass @@ -1591,7 +1591,7 @@ class MSSQLCompiler(compiler.SQLCompiler): return "" def _try_cast(self, element, **kw): - return "TRY CAST (%s AS %s)" % ( + return "TRY_CAST (%s AS %s)" % ( compiler.SQLCompiler.process(element.clause, **kw), compiler.SQLCompiler.process(element.typeclause, **kw), ) diff --git a/test/dialect/mssql/test_query.py b/test/dialect/mssql/test_query.py index 083f853d20..92b2ac21c6 100644 --- a/test/dialect/mssql/test_query.py +++ b/test/dialect/mssql/test_query.py @@ -17,7 +17,7 @@ from sqlalchemy import Table from sqlalchemy import testing from sqlalchemy import util from sqlalchemy.databases import mssql -from sqlalchemy.dialects.mssql.base import Try_Cast +from sqlalchemy.dialects.mssql.base import try_cast from sqlalchemy.sql import column from sqlalchemy.sql import table from sqlalchemy.testing import AssertsCompiledSQL @@ -29,6 +29,7 @@ from sqlalchemy.testing.assertsql import DialectSQL from sqlalchemy.util import ue + metadata = None cattable = None matchtable = None @@ -427,7 +428,7 @@ class QueryTest(testing.AssertsExecutionResults, fixtures.TestBase): metadata.create_all(engine) with self.sql_execution_asserter(engine) as asserter: - engine.execute(t1.select([Try_Cast(t1.id, Integer)])) + engine.execute(t1.select([try_cast(t1.id, Integer)])) asserter.assert_( CursorSQL("SELECT TRY_CAST(id AS Integer) FROM t1"), -- 2.47.3