From 84e813aee4b47edb5220bc76083525d1ac4e45ba Mon Sep 17 00:00:00 2001 From: Sebastian Bank Date: Fri, 19 Jun 2015 17:37:21 +0200 Subject: [PATCH] add ClauseElement.cast() shortcut-method --- lib/sqlalchemy/sql/elements.py | 7 +++++++ test/sql/test_type_expressions.py | 7 +++++++ 2 files changed, 14 insertions(+) diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py index 27ecce2b0b..5df736ac7c 100644 --- a/lib/sqlalchemy/sql/elements.py +++ b/lib/sqlalchemy/sql/elements.py @@ -837,6 +837,13 @@ class ColumnElement(operators.ColumnOperators, ClauseElement): else: return False + def cast(self, type_): + """Produce a type cast, i.e. ``CAST( AS )``. + + This is a shortcut to the :func:`.cast` function. + """ + return Cast(self, type_) + def label(self, name): """Produce a column label, i.e. `` AS ``. diff --git a/test/sql/test_type_expressions.py b/test/sql/test_type_expressions.py index 574edfe9e8..c35e9ff538 100644 --- a/test/sql/test_type_expressions.py +++ b/test/sql/test_type_expressions.py @@ -40,6 +40,13 @@ class SelectTest(_ExprFixture, fixtures.TestBase, AssertsCompiledSQL): "SELECT CAST(test_table.y AS VARCHAR) AS anon_1 FROM test_table" ) + def test_cast_method(self): + table = self._fixture() + self.assert_compile( + select([table.c.y.cast(String)]), + "SELECT CAST(test_table.y AS VARCHAR) AS anon_1 FROM test_table" + ) + def test_select_cols_use_labels(self): table = self._fixture() -- 2.47.3