From eb9763febe58655ca0f61fa758925c56b94ece9b Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 25 Oct 2009 21:27:08 +0000 Subject: - generalized Enum to issue a CHECK constraint + VARCHAR on default platform - added native_enum=False flag to do the same on MySQL, PG, if desired --- test/dialect/test_postgresql.py | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'test/dialect/test_postgresql.py') diff --git a/test/dialect/test_postgresql.py b/test/dialect/test_postgresql.py index 4e9a324d4..626d54677 100644 --- a/test/dialect/test_postgresql.py +++ b/test/dialect/test_postgresql.py @@ -132,6 +132,25 @@ class EnumTest(TestBase, AssertsExecutionResults, AssertsCompiledSQL): postgresql.DropEnumType(e2), "DROP TYPE someschema.somename" ) + + t1 = Table('sometable', MetaData(), Column('somecolumn', e1)) + self.assert_compile( + schema.CreateTable(t1), + "CREATE TABLE sometable (" + "somecolumn somename" + ")" + ) + t1 = Table('sometable', MetaData(), + Column('somecolumn', Enum('x', 'y', 'z', native_enum=False)) + ) + self.assert_compile( + schema.CreateTable(t1), + "CREATE TABLE sometable (" + "somecolumn VARCHAR(1), " + " CHECK (somecolumn IN ('x','y','z'))" + ")" + ) + @testing.fails_on('postgresql+zxjdbc', 'zxjdbc fails on ENUM: column "XXX" is of type XXX ' -- cgit v1.2.1