From 08c003ec000df4db6f1dd03cd45563ac5f8f5957 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 17 Apr 2006 01:15:19 +0000 Subject: [PATCH] added _get_from_obj to TypeClause --- lib/sqlalchemy/sql.py | 3 ++- test/select.py | 3 +++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py index b18b0916e9..02e1619a15 100644 --- a/lib/sqlalchemy/sql.py +++ b/lib/sqlalchemy/sql.py @@ -702,7 +702,8 @@ class TypeClause(ClauseElement): self.type = type def accept_visitor(self, visitor): visitor.visit_typeclause(self) - + def _get_from_objects(self): + return [] class TextClause(ClauseElement): """represents literal a SQL text fragment. public constructor is the text() function. diff --git a/test/select.py b/test/select.py index adaf65ec1a..5038f8f138 100644 --- a/test/select.py +++ b/test/select.py @@ -549,6 +549,9 @@ FROM mytable, myothertable WHERE mytable.myid = myothertable.otherid AND mytable self.assertEqual(str(cast(1234, TEXT, engine=engine)), 'CAST(%s AS %s)' %(literal, expected_results[3])) self.assertEqual(str(cast('test', String(20), engine=engine)), 'CAST(%s AS %s)' %(literal, expected_results[4])) + sel = select([tbl, cast(tbl.c.v1, Numeric)], engine=engine) + self.assertEqual(str(sel), "SELECT casttest.id, casttest.v1, casttest.v2, casttest.ts, CAST(casttest.v1 AS NUMERIC(10, 2)) \nFROM casttest") + # first test with Postgres engine check_results(postgres.engine({}), ['NUMERIC(10, 2)', 'NUMERIC(12, 9)', 'DATE', 'TEXT', 'VARCHAR(20)'], '%(literal)s') -- 2.47.2