class SupportedVendorTech(db.Model):
"""
Supported vendor technologies model
"""
__tablename__ = 'supported_vendor_tech'
pk = db.Column(db.Integer,
db.Sequence('seq_supported_vendor_tech_pk', ),
primary_key=True,
nullable=False)
vendor_pk = db.Column(db.Integer, nullable=False)
tech_pk = db.Column(db.Integer, nullable=False)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
__table_args__ = (db.UniqueConstraint('vendor_pk',
'tech_pk',
name='unq_supported_vendor_tech'), )
def init(self, vendor_pk, tech_pk):
self.tech_pk = tech_pk
self.vendor_pk = vendor_pk
class ManagedObjectSchema(db.Model):
"""Managed objects schemas table"""
__tablename__ = 'managedobjects_schemas'
pk = db.Column(db.Integer, db.Sequence('seq_managedobjects_schemas_pk', ), primary_key=True, nullable=False)
name = db.Column(db.String(255), nullable=False)
notes = db.Column(db.Text)
tech_pk = db.Column(db.Integer, nullable=False)
vendor_pk = db.Column(db.Integer, nullable=False)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow, onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
class AuditCategory(db.Model):
"""Audit category"""
__tablename__ = 'audit_categories'
# __table_args__ = {'schema': 'network_audit'}
pk = db.Column(db.Integer, db.Sequence('seq_audit_categories_pk', ), primary_key=True, nullable=False)
name = db.Column(db.String(255), nullable=False)
notes = db.Column(db.Text)
parent_pk = db.Column(db.Integer, nullable=False, default=0)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow, onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
in_built = db.Column(db.Boolean)
class ReportCategory(db.Model):
__tablename__ = 'report_categories'
__table_args__ = {'schema': 'reports'}
pk = db.Column(db.Integer,
db.Sequence('seq_report_categories_pk', schema='reports'),
primary_key=True,
nullable=False)
name = db.Column('name', db.String(100), nullable=False)
notes = db.Column('notes', db.Text)
parent_pk = db.Column('parent_pk', db.Integer)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
class Setting(db.Model):
"""Settings model"""
__tablename__ = 'settings'
pk = db.Column(db.Integer,
db.Sequence('seq_settings_pk', ),
primary_key=True,
nullable=False)
name = db.Column(db.String(200), unique=True, nullable=False)
data_type = db.Column(db.String(200), nullable=False)
integer_value = db.Column(db.Integer)
float_value = db.Column(db.Float)
string_value = db.Column(db.String(200))
text_value = db.Column(db.Text)
timestamp_value = db.Column(db.TIMESTAMP)
label = db.Column(db.String(200))
category_id = db.Column(db.String(200))
class ReportsTaskLog(db.Model):
__tablename__ = 'reports_task_log'
__table_args__ = {'schema': 'reports'}
pk = db.Column(db.Integer,
db.Sequence('seq_reports_task_log_pk', schema='reports'),
primary_key=True,
nullable=False)
action = db.Column('action', db.String(200),
nullable=False) # reports.generate
log = db.Column('log', db.Text)
options = db.Column('options', postgresql.JSON)
status = db.Column(
'status', db.String(200)) # FAILED,RUNNING,PENDING,STARTED,FINISHED
modified_by = db.Column(db.Integer, default=0)
added_by = db.Column(db.Integer, default=0)
date_added = db.Column(db.TIMESTAMP,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
class CMFileFormats(db.Model):
"""
CM file formats model
"""
__tablename__ = 'cm_file_formats'
pk = db.Column(db.Integer,
db.Sequence('seq_cm_file_formats_pk', ),
primary_key=True,
nullable=False)
name = db.Column(db.String(100), unique=True, nullable=False)
label = db.Column(db.String(100), nullable=False)
vendor_pk = db.Column(db.Integer, nullable=False)
tech_pk = db.Column(db.Integer, nullable=False)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
class Report(db.Model):
# __table__ = Table('reports', metadata, autoload=True, autoload_with=db.engine, schema='public')
__tablename__ = 'reports'
__table_args__ = {'schema': 'reports'}
pk = db.Column(db.Integer,
db.Sequence('seq_reports_pk', schema='reports'),
primary_key=True,
nullable=False)
name = db.Column('name', db.String(100), nullable=False)
notes = db.Column('notes', db.Text)
query = db.Column(db.Text)
db_connector_pk = db.Column('db_connector_pk', db.Integer)
options = db.Column('options', postgresql.JSON) # JSON
category_pk = db.Column('category_pk', db.Integer)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
class VendorCMFileFormatsMap(db.Model):
"""
CM File format map
"""
__tablename__ = 'vendors_cm_file_format_map'
pk = db.Column(db.Integer,
db.Sequence('seq_vendors_cm_file_format_map_pk', ),
primary_key=True,
nullable=False)
vendor_tech_pk = db.Column(db.Integer, nullable=False)
format_pk = db.Column(db.Integer, nullable=False)
notes = db.Column(db.Text)
modified_by = db.Column(db.Integer)
added_by = db.Column(db.Integer)
date_added = db.Column(db.TIMESTAMP,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
date_modified = db.Column(db.TIMESTAMP, default=datetime.datetime.utcnow)
def __init__(self, vendor_tech_pk, format_pk):
self.vendor_tech_pk = vendor_tech_pk
self.format_pk = format_pk
class DummyTable(db.Model):
__tablename__ = 'dummy_table'
dummy_pk = db.Column(db.Integer,
db.Sequence('seq_dummy_table_pk', ),
primary_key=True,
nullable=False)
