class DateTimeTest(MODEL) : __tablename__ = DATE_TIME_TEST id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True) beginAtDatetime = sap.Column(sap.DateTime) endAtDatetime = sap.Column(sap.DateTime) beginAtDate = sap.Column(sap.Date) endAtDate = sap.Column(sap.Date) beginAtTime = sap.Column(sap.Time) endAtTime = sap.Column(sap.Time) intervalTime = sap.Column(sap.Interval) def __init__(self, id = None, beginAtDatetime = None, endAtDatetime = None, beginAtDate = None, endAtDate = None, beginAtTime = None, endAtTime = None, intervalTime = None, timedelta = None ): self.id = id self.beginAtDatetime = forcedlyGetDateTime(beginAtDatetime) self.endAtDatetime = forcedlyGetDateTime(endAtDatetime) self.beginAtDate = forcedlyGetDate(beginAtDate) self.endAtDate = forcedlyGetDate(endAtDate) self.beginAtTime = forcedlyGetTime(beginAtTime) self.endAtTime = forcedlyGetTime(endAtTime) self.intervalTime = forcedlyGetInterval(intervalTime) self.timedelta = forcedlyGetInterval(timedelta)
class TestContact(MODEL): __tablename__ = 'TestContact' id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True) key = sap.Column(sap.String(128), nullable=False) def __init__(self, id = None, key = None ): self.id = id self.key = key def __repr__(self): return f'{self.__tablename__}(id: {self.id}, key: {self.key})'
class ErrorLog(MODEL): __tablename__ = ERROR_LOG status = sap.Column(sap.Integer()) verb = sap.Column(sap.String(MAX_VERB_SIZE)) url = sap.Column(sap.String(MAX_URL_SIZE)) message = sap.Column(sap.String(MAX_MESSAGE_SIZE)) logMessage = sap.Column(sap.String(MAX_MESSAGE_SIZE)) logPayload = sap.Column(sap.String(MAX_HTTP_ERROR_LOG_PAYLOAD_SIZE)) logResource = sap.Column(sap.String(MAX_RESOURCE_NAME_SIZE)) logResourceMethod = sap.Column(sap.String(MAX_RESOURCE_METHOD_NAME_SIZE)) timeStamp = sap.Column(sap.DateTime(), default=datetime.datetime.utcnow) id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True) def __init__(self, status = None, verb = None, url = None, message = None, logMessage = None, logPayload = None, logResource = None, logResourceMethod = None, timeStamp = None, id = None ): self.status = status self.verb = str(verb)[:MAX_VERB_SIZE-1] self.url = str(url)[:MAX_URL_SIZE-1] self.message = str(message)[:MAX_MESSAGE_SIZE-1] self.logMessage = str(logMessage)[:MAX_MESSAGE_SIZE-1] self.logPayload = str(logPayload)[:MAX_HTTP_ERROR_LOG_PAYLOAD_SIZE-1] self.logResource = str(logResource)[:MAX_RESOURCE_NAME_SIZE-1] self.logResourceMethod = str(logResourceMethod)[:MAX_RESOURCE_METHOD_NAME_SIZE-1] self.timeStamp = timeStamp self.id = id def override(self, globalException): self.status = globalException.status self.verb = str(globalException.verb)[:MAX_VERB_SIZE-1] self.url = str(globalException.url)[:MAX_URL_SIZE-1] self.message = str(globalException.message)[:MAX_MESSAGE_SIZE-1] self.logMessage = str(globalException.logMessage)[:MAX_MESSAGE_SIZE-1] self.logPayload = str(globalException.logPayload)[:MAX_HTTP_ERROR_LOG_PAYLOAD_SIZE-1] self.logResource = str(globalException.logResource)[:MAX_RESOURCE_NAME_SIZE-1] self.logResourceMethod = str(globalException.logResourceMethod)[:MAX_RESOURCE_METHOD_NAME_SIZE-1] self.timeStamp = globalException.timeStamp def __repr__(self): return f'{self.__tablename__}(verb={self.verb}, url={self.url}, status={self.status}, message={self.message}, id={self.id})'
class ActuatorHealth(MODEL): __tablename__ = ACTUATOR_HEALTH laskCheck = sap.Column(sap.DateTime(), default=datetime.datetime.utcnow) status = sap.Column(sap.String(MAX_STATUS_SIZE), default=ActuatorHealthStatus.DOWN) id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True) def __init__(self, status=ActuatorHealthStatus.DOWN, laskCheck=None, id=None): self.status = status self.laskCheck = laskCheck self.id = id def __repr__(self): return f'{self.__tablename__}(id={self.id}, laskCheck={self.laskCheck}, status={self.status})'
class Child(MODEL) : __tablename__ = SELF_REFERENCE_CHILD_NAME id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True) father, fatherId = sap.getManyToOne(__tablename__, SELF_REFERENCE_FATHER_NAME, MODEL) brother, brotherId = sap.getOneToOneChild(__tablename__, BROTHER_NAME, MODEL)
class Father(MODEL) : __tablename__ = SELF_REFERENCE_FATHER_NAME id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True) childList = sap.getOneToMany(__tablename__, SELF_REFERENCE_CHILD_NAME, MODEL) brotherList = sap.getOneToMany(__tablename__, BROTHER_NAME, MODEL)
class MyEntityClass(MODEL) : __tablename__ = 'MyEntityClass' id = sap.Column(sap.Integer(), sap.Sequence(f'{__tablename__}{sap.ID}{sap.SEQ}'), primary_key=True)