# coding=utf-8
# author:        4N
#createtime:    2021/6/11
#email:         nheweijun@sina.com


from datetime import datetime
from time import time
from sqlalchemy import Column, Integer, String, ForeignKey, Text, DateTime, Time, Float, Binary
from sqlalchemy.orm import relationship
from sqlalchemy.sql.expression import column
from app.models import db


class MonitorLog(db.Model):
    '''
    '''
    __tablename__ = "dmap_monitor_log"
    guid = Column(String(256), primary_key=True)
    server = Column(String(256))
    date_stamp = Column(Text)
    hour_stamp = Column(Integer)
    minu_stamp = Column(Integer)
    d_minu_stamp = Column(Integer)  # 10min粒度  1-6
    f_minu_stamp = Column(Integer)  # 5min粒度 1~12
    time_stamp = Column(DateTime)  # 创建时间戳
    cpu_usage = Column(Float)
    total_mem = Column(Float)
    available_mem = Column(Float)
    used_mem = Column(Float)
    disk = Column(Float)
    disk_usage = Column(Float)
    net_recv = Column(Float)
    net_send = Column(Float)


class MonitorHost(db.Model):
    '''
    监控服务器配置
    '''
    __tablename__ = "dmap_monitor_host"
    srcid = Column(String(256), primary_key=True)
    host = Column(String(256))
    user = Column(String(256))
    password = Column(String(256))
    type = Column(String(256))
    host_name=Column(String(256))