Adds convinient EnumDict column to sqlalchemy
Project description
Easy to Use
class Item(declarative_base()):
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.