向sqlalchemy添加方便的enumdict列
SQLAlchemy-Enum-Dict的Python项目详细描述
易于使用
DeclarativeBase=declarative_base()DeclarativeBase.query=dbsession.query_property()classItem(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))@classmethoddefcondition_status_active(cls):returncls.status==cls.STATUS.active# or cls.STATUS.active.dbitem=Item.query.filter(Item.condition_status_active()).first()item.status==Item.STATUS.active# Trueprintitem.status.db,item.status.title# 0, 'active'
易于安装
$ pip install Sqlalchemy-Enum-Dict