[Sqlalchemy-tickets] [sqlalchemy] #2919: schematype support for typedecorator / PG ENUM
Brought to you by:
zzzeek
|
From: sqlalchemy <mi...@zz...> - 2014-01-24 17:57:19
|
#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
|