def test__cast__long_varbinary_with_arg(self): q = Q.from_(self.t).select( fn.Cast(self.t.foo, SqlTypes.LONG_VARBINARY(24))) self.assertEqual( "SELECT CAST(\"foo\" AS LONG VARBINARY(24)) FROM \"abc\"", str(q))
def test__cast__varbinary_with_arg(self): q = Q.from_(self.t).select(fn.Cast(self.t.foo, SqlTypes.VARBINARY(24))) self.assertEqual('SELECT CAST("foo" AS VARBINARY(24)) FROM "abc"', str(q))
def test__cast__varchar_with_arg(self): q = Q.from_(self.t).select(fn.Cast(self.t.foo, SqlTypes.VARCHAR(24))) self.assertEqual("SELECT CAST(\"foo\" AS VARCHAR(24)) FROM \"abc\"", str(q))
def test__cast__long_varchar_with_arg(self): q = Q.from_(self.t).select( fn.Cast(self.t.foo, SqlTypes.LONG_VARCHAR(24))) self.assertEqual('SELECT CAST("foo" AS LONG VARCHAR(24)) FROM "abc"', str(q))