Python SqlTypes.VARCHAR示例

示例#1

文件： test_functions.py 项目： zoliszeredi/pypika

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

示例#2

文件： test_functions.py 项目： moorecode/pypika

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