class auditLogLookup(db.Model, Serializer):
# table audit_log_lookups : table modal
__tablename__ = 'audit_log_lookups'
# rec-id
id = db.Column('id', db.Integer(), primary_key=True, autoincrement=True)
# code-id
code_id = db.Column('code_id', db.VARCHAR(length=45))
# status code
status = db.Column('status', db.VARCHAR(length=45))
# status description
description = db.Column('description', db.VARCHAR(length=45))
# log type
type = db.Column('type', db.VARCHAR(length=45))
# severity level
severity = db.Column('severity', db.VARCHAR(length=45))
# initrialization
def __init__(self, code_id, status, description, type, severity):
self.code_id = code_id
self.status = status
self.description = description
self.type = type
self.severity = severity
# serialize db object to json
def serialize(self):
d = Serializer.serialize(self)
return d
class unoLookup(db.Model, Serializer):
# view table Event-logs-live-v
__tablename__ = 'uno_lookups'
# rec_id
id = db.Column('id', db.Integer(), primary_key=True, autoincrement=True)
# unit_name / uno_id
uno_id = db.Column('uno_id', db.VARCHAR(length=45))
# unit_name / uno_name
uno_name = db.Column('description', db.VARCHAR(length=45))
# serialize db object to json
def serialize(self):
d = Serializer.serialize(self)
return d
class vAlertLiveLog(db.Model, Serializer):
# view table audit-logs-live-v
__tablename__ = 'alert_logs_live_v'
# unit_name / uno_id
uno_id = db.Column('uno_id', db.VARCHAR(length=45))
# unit_name / uno_name
uno_name = db.Column('uno_name', db.VARCHAR(length=45))
# code_id
code_id = db.Column('code_id', db.VARCHAR(length=45))
# status
status = db.Column('status', db.VARCHAR(length=45))
# loging time
timestamp = db.Column('timestamp', db.TIMESTAMP(), primary_key=True)
# status description
display = db.Column('display', db.VARCHAR(length=45))
# severity level
severity = db.Column('severity', db.VARCHAR(length=45))
# serialize db object to json
def serialize(self):
d = Serializer.serialize(self)
try:
d['timestamp'] = d['timestamp'].strftime('%Y-%m-%d %H:%M:%S.%f')
except BaseException:
d['timestamp'] = str(d['timestamp'])
return d
class auditLog(db.Model, Serializer):
# table audit_log : table modal
__tablename__ = 'audit_logs'
# log id
id = db.Column('id', db.Integer(), primary_key=True, autoincrement=True)
# unit_id / uno_id
uno_id = db.Column('uno_id', db.VARCHAR(length=45))
# audit log lookup to code
code_id = db.Column('code_id', db.VARCHAR(length=45))
# loging time
timestamp = db.Column('timestamp', db.TIMESTAMP(), nullable=False)
# logging status
status = db.Column('status', db.VARCHAR(length=45))
# extra-info
user_id = db.Column('user_id', db.VARCHAR(length=45))
mission_id = db.Column('mission_id', db.VARCHAR(length=45))
waypoint_id = db.Column('waypoint_id', db.String(255))
# initrialization
def __init__(self, uno_id, code_id,
status, audit_time, user_id,
mission_id, waypoint_id
):
self.uno_id = uno_id
self.code_id = code_id
self.status = status
self.audit_time = audit_time
self.user_id = user_id
self.mission_id = mission_id
self.waypoint_id = waypoint_id
# serialize db object to json
def serialize(self):
d = Serializer.serialize(self)
try:
d['timestamp'] = d['timestamp'].strftime('%Y-%m-%d %H:%M:%S.%f')
except BaseException:
d['timestamp'] = str(d['timestamp'])
return d