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)