__all__ = ["Status"] import enum from sqlalchemy import Column, Integer, String, DateTime, Enum from sqlalchemy.orm import relationship from sqlalchemy import ForeignKey from ._base import Base, engine class StatusValues(enum.Enum): unstarted = 1 proceeding = 2 completed = 3 deferred = 4 waiting = 5 canceled = 6 class Status(Base): __tablename__ = 'event' id = Column(Integer, primary_key=True) comment = Column(String) value = Column(Enum(StatusValues)) timestamp = Column(DateTime) job_id = Column(Integer, ForeignKey("jobs.id")) job = relationship("Job", back_populates="status_updates") def __repr__(self): return "" % (self.value)