package com.wgcloud.entity;

import com.wgcloud.util.DateUtil;
import org.apache.commons.lang3.StringUtils;

import java.util.Date;

/**
 * @version v3.3
 * @ClassName:DbTable.java
 * @author: http://www.wgstart.com
 * @date: 2021年1月16日
 * @Description: 检查系统入侵信息
 * @Copyright: 2019-2021 wgcloud. All rights reserved.
 */
public class DbTable extends BaseEntity {

    /**
     *
     */
    private static final long serialVersionUID = 1L;


    /**
     * 数据源
     */
    private String dbInfoId;


    /**
     * 从查询结果取值的列名
     */
    private String tableName;

    /**
     * 统计sql语句
     */
    private String whereVal;

    /**
     * 表别名
     */
    private String remark;

    /**
     * 数据量
     */
    private Long tableCount;

    /**
     * 告警表达式，为true告警，false不告警
     */
    private String resultExp;

    /**
     * 暂没有用
     */
    private Long value;

    /**
     * 暂没有用
     */
    private String dateStr;

    /**
     * 1启用监控2停止监控
     */
    private String active;

    /**
     * 数据表监控状态，1正常，2失败
     */
    private String state;

    /**
     * 创建时间
     */
    private Date createTime;

    //所属用户账号，页面显示用，数据库无此字段
    private String account;

    //数据库图标，数据库无此字段
    private String image;

    public String getTableName() {
        return tableName;
    }

    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

    public String getWhereVal() {
        return whereVal;
    }

    public void setWhereVal(String whereVal) {
        this.whereVal = whereVal;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public Long getTableCount() {
        return tableCount;
    }

    public void setTableCount(Long tableCount) {
        this.tableCount = tableCount;
    }

    public String getDateStr() {
        String s = DateUtil.getDateTimeString(this.getCreateTime());
        if (!StringUtils.isEmpty(s) && s.length() > 16) {
            return s.substring(5);
        }
        return dateStr;
    }

    public void setDateStr(String dateStr) {
        this.dateStr = dateStr;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Long getValue() {
        return tableCount;
    }

    public void setValue(Long value) {
        this.value = value;
    }

    public String getDbInfoId() {
        return dbInfoId;
    }

    public void setDbInfoId(String dbInfoId) {
        this.dbInfoId = dbInfoId;
    }

    public String getActive() {
        return active;
    }

    public void setActive(String active) {
        this.active = active;
    }

    public String getResultExp() {
        return resultExp;
    }

    public void setResultExp(String resultExp) {
        this.resultExp = resultExp;
    }

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account;
    }

    public String getImage() {
        return image;
    }

    public void setImage(String image) {
        this.image = image;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }
}