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 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 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)