Adds convinient EnumDict column to sqlalchemy
Project description
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
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.
Source Distribution
Close
Hashes for SQLAlchemy-Enum-Dict-0.1.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | a0dd46c03739fbda1d71971cb9a2af061236280c28881278e6796937c468b0fe |
|
MD5 | 800b411c5d6ae2f5c1576f2ca06197a9 |
|
BLAKE2b-256 | 0e4f560d949b81a20ee41b1e472377f343c8e7ba4022cb3b17727c7b283cf1cb |