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))
