[Sqlalchemy-tickets] [sqlalchemy] #2919: schematype support for typedecorator / PG ENUM

[sqlalchemy <mi...@zz...>]

#2919: schematype support for typedecorator / PG ENUM
--------------------+------------------------------------
 Reporter:  zzzeek  |           Owner:  zzzeek
     Type:  defect  |          Status:  new
 Priority:  medium  |       Milestone:  0.9.xx
Component:  sql     |        Severity:  major - 1-3 hours
 Keywords:          |  Progress State:  in queue
--------------------+------------------------------------
 figure out how users would know to follow this pattern, or how this can be
 transparent:

 {{{
 #!python
 import sqlalchemy as sa
 from sqlalchemy.ext.declarative import declarative_base
 from sqlalchemy.dialects import postgresql


 Base = declarative_base()

 class MyEnum(sa.types.TypeDecorator, sa.types.SchemaType):
     impl = postgresql.ENUM

     def _set_parent(self, column):
         self.impl._set_parent(column)

 class Test(Base):
     __tablename__ = 'test'

     id = sa.Column(sa.Integer, primary_key=True)
     enum_column = sa.Column(MyEnum('1', '2', '3', name='my_enum_type'))

 engine = sa.create_engine('postgresql://scott:tiger@localhost/test',
 echo=True)
 Base.metadata.create_all(engine)
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2919>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python