SQLAlchemy-Enum-Dict 0.1.2

Adds convinient EnumDict column to sqlalchemy

Easy to Use

DeclarativeBase = declarative_base()
DeclarativeBase.query = dbsession.query_property()

class Item(DeclarativeBase):
    STATUS = EnumDictForInt.Enum(
        ('active', {
            'db': 0,
            'title': 'active',
            'other_useful_info': 'Info about active status',
        }),
        ('draft', {
            'db': 1,
            'title': 'draft',
            'other_useful_info': 'Info about draft status',
        }),
        ('deleted', {
            'db': 2,
            'title': 'deleted',
            'other_useful_info': 'Info about deleted status',
        }),
    )

    id = Column(Integer, primary_key=True)
    status = Column(EnumDictForInt(STATUS))

    @classmethod
    def condition_status_active(cls):
        return cls.status == cls.STATUS.active  # or cls.STATUS.active.db


item = Item.query.filter(Item.condition_status_active()).first()
item.status == Item.STATUS.active  # True
print item.status.db, item.status.title  # 0, 'active'

Easy to Install

$ pip install Sqlalchemy-Enum-Dict

Links

• source