# 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,TIMESTAMP
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))


class MonitorCpu(db.Model):
    '''
    '''
    __tablename__ = "dmap_monitor_cpu"
    guid = Column(String(256), primary_key=True)
    server = Column(String(256))
    date_stamp = Column(Text)
    time_stamp = Column(TIMESTAMP)  # 创建时间戳
    stamp = Column(Text)  # P0,P50,P90,P95,P99,P100
    value = Column(Float)
    
class MonitorInfo(db.Model):
    '''
    '''
    __tablename__ = "dmap_monitor_info"
    guid = Column(String(256), primary_key=True)
    metrics=Column(String(256))
    server = Column(String(256))
    date_stamp = Column(Text)
    time_stamp = Column(TIMESTAMP)  # 创建时间戳
    stamp = Column(Text)  # P0,P50,P90,P95,P99,P100
    value = Column(Float)