# coding=utf-8
# author:        resioR
#createtime:    2021/12/1
#email:         qianyingz@chinadci.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 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 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)