def test_try_cast(self):
metadata = MetaData()
t1 = Table("t1", metadata, Column("id", Integer, primary_key=True))
self.assert_compile(
select([try_cast(t1.c.id, Integer)]),
"SELECT TRY_CAST (t1.id AS INTEGER) AS id FROM t1",
)
def test_try_cast(self):
engine = engines.testing_engine()
metadata = self.metadata
t1 = Table(
"t1",
metadata,
Column("id", Integer, primary_key=True),
implicit_returning=False,
)
metadata.create_all(engine)
with self.sql_execution_asserter(engine) as asserter:
engine.execute(t1.select([try_cast(t1.id, Integer)]))
asserter.assert_(CursorSQL("SELECT TRY_CAST(id AS Integer) FROM t1"), )