#ifndef VSSUPPERSVRTBL_MANAGER_H
#define VSSUPPERSVRTBL_MANAGER_H

#include "../model/VssUpperSvrTbl.h"
#include "BaseDao.h"

#define VSSUpperSvrTbl_TABLE_NAME "VSSUpperSvrTbl"

/**
 * 创建上级平台服务器表管理类
 */
class VssUpperSvrTblDao : public BaseDao {
private:
	/** 创建上级平台服务器表构造函数 */
	VssUpperSvrTblDao() {}
public:
	/** 创建上级平台服务器表单例模式 */
    static VssUpperSvrTblDao* instance() {
        static VssUpperSvrTblDao instance;
        return &instance;
    }
    
    /** 添加创建上级平台服务器表 keyValuesToAdd 需要添加的列名和列值对map*/
    mysqlpp::SimpleResult addVssUpperSvrTbl(std::map<std::string, std::string>& keyValuesToAdd) {
        return add(keyValuesToAdd, VSSUpperSvrTbl_TABLE_NAME);
    }
    
    /** 删除创建上级平台服务器表 whereKey 列名；whereValue 列值 */
    bool deleteByColumn(string whereKey, string whereValue) {
        std::map<std::string, std::string> whereKeyValues;
        whereKeyValues[whereKey] = whereValue;
        return deleteVssUpperSvrTbl(whereKeyValues);
    }

    /** 删除创建上级平台服务器表 whereColumnNameValues 列名和列值对条件 */
    bool deleteVssUpperSvrTbl(std::map<std::string, std::string>& whereKeyValues) {
        return del(VSSUpperSvrTbl_TABLE_NAME, whereKeyValues);
    }
    
    /** 更新创建上级平台服务器表 keyValuesToUpdate 需要更新的列名和列值对； whereKeyValues 列名和列值条件 */
	bool updateVssUpperSvrTbl(std::map<std::string, std::string>& keyValuesToUpdate, 
									std::map<std::string, std::string>& whereKeyValues) {
		return update(keyValuesToUpdate, VSSUpperSvrTbl_TABLE_NAME, whereKeyValues);
	}
	
    /** 更新创建二级设备表 keyValuesToUpdate 需要更新的列名和列值对； whereKeyValues 列名和列值条件 */
    bool updateVssUpperSvrTbl(std::map<std::string, std::string>& keyValuesToUpdate,
                             string whereKey,
                             string whereValue) {
        std::map<std::string, std::string> whereKeyValues;
        whereKeyValues[whereKey] = whereValue;
        return update(keyValuesToUpdate, VSSUpperSvrTbl_TABLE_NAME, whereKeyValues);
    }
	
	/** 查询创建上级平台服务器表列表  querySql 要查询的sql语句 */
	vector<VssUpperSvrTbl> findVssUpperSvrTblList(string querySql) {
        vector<VssUpperSvrTbl> vssUpperSvrTblVec;
        vector<map<string, string>> rowDatList = findList(querySql);
        vssUpperSvrTblVec.reserve(rowDatList.size());
        for (auto rowData : rowDatList) {
            vssUpperSvrTblVec.emplace_back(mapToModel(rowData));
        }
        return vssUpperSvrTblVec;
	}
	
    /**查询创建上级平台服务器表列表 whereKeyValues 列名和列值对条件 */
    vector<VssUpperSvrTbl> findVssUpperSvrTblList(std::map<std::string, std::string>& whereKeyValues) {
        return findVssUpperSvrTblList(string("select * from ") + VSSUpperSvrTbl_TABLE_NAME + " where 1=1 " + getWhereColumnNameValuePair(whereKeyValues));
    }
    
    /**查询所有创建上级平台服务器表列表 */
    vector<VssUpperSvrTbl> findAllVssUpperSvrTblList() {
        return findVssUpperSvrTblList(string("select * from ") + VSSUpperSvrTbl_TABLE_NAME + " where 1=1 ");
    }
	
	/** 查询map列表 querySql 要查询的sql语句 */
	vector<map<string, string>> findMapList(string querySql) {
		return findList(querySql);
	}
    
    /** 执行sql语句 */
    bool execute(string sql) {
        return exec(move(sql));
    }
    
    /** map转model类 */
    VssUpperSvrTbl mapToModel(map<string, string>& rowData) {
        VssUpperSvrTbl vssUpperSvrTbl;
        string IDValue = rowData[VssUpperSvrTbl_ID];
        if (IDValue.length() != 0 && IDValue != "NULL") {
            vssUpperSvrTbl.ID = std::stoi(IDValue);
        }
        string NameValue = rowData[VssUpperSvrTbl_Name];
        if (NameValue.length() != 0 && NameValue != "NULL") {
            vssUpperSvrTbl.Name = NameValue;
        }
        string PublicIDValue = rowData[VssUpperSvrTbl_PublicID];
        if (PublicIDValue.length() != 0 && PublicIDValue != "NULL") {
            vssUpperSvrTbl.PublicID = PublicIDValue;
        }
        string AuthUsernameValue = rowData[VssUpperSvrTbl_AuthUsername];
        if (AuthUsernameValue.length() != 0 && AuthUsernameValue != "NULL") {
            vssUpperSvrTbl.AuthUsername = AuthUsernameValue;
        }
        string AuthPasswdValue = rowData[VssUpperSvrTbl_AuthPasswd];
        if (AuthPasswdValue.length() != 0 && AuthPasswdValue != "NULL") {
            vssUpperSvrTbl.AuthPasswd = AuthPasswdValue;
        }
        string DomainValue = rowData[VssUpperSvrTbl_Domain];
        if (DomainValue.length() != 0 && DomainValue != "NULL") {
            vssUpperSvrTbl.Domain = DomainValue;
        }
        string IPValue = rowData[VssUpperSvrTbl_IP];
        if (IPValue.length() != 0 && IPValue != "NULL") {
            vssUpperSvrTbl.IP = IPValue;
        }
        string PortValue = rowData[VssUpperSvrTbl_Port];
        if (PortValue.length() != 0 && PortValue != "NULL") {
            vssUpperSvrTbl.Port = std::stoi(PortValue);
        }
        string RegisterTimeValue = rowData[VssUpperSvrTbl_RegisterTime];
        if (RegisterTimeValue.length() != 0 && RegisterTimeValue != "NULL") {
            vssUpperSvrTbl.RegisterTime = std::stoi(RegisterTimeValue);
        }
        string KeepAliveTimeValue = rowData[VssUpperSvrTbl_KeepAliveTime];
        if (KeepAliveTimeValue.length() != 0 && KeepAliveTimeValue != "NULL") {
            vssUpperSvrTbl.KeepAliveTime = std::stoi(KeepAliveTimeValue);
        }
        string AliveValue = rowData[VssUpperSvrTbl_Alive];
        if (AliveValue.length() != 0 && AliveValue != "NULL") {
            vssUpperSvrTbl.Alive = std::stoi(AliveValue);
        }
        string IsSyncTimeValue = rowData[VssUpperSvrTbl_IsSyncTime];
        if (IsSyncTimeValue.length() != 0 && IsSyncTimeValue != "NULL") {
            vssUpperSvrTbl.IsSyncTime = std::stoi(IsSyncTimeValue);
        }
        string PushProtocolValue = rowData[VssUpperSvrTbl_PushProtocol];
        if (PushProtocolValue.length() != 0 && PushProtocolValue != "NULL") {
            vssUpperSvrTbl.PushProtocol = std::stoi(PushProtocolValue);
        }
        string PlatformInfoValue = rowData[VssUpperSvrTbl_PlatformInfo];
        if (PlatformInfoValue.length() != 0 && PlatformInfoValue != "NULL") {
            vssUpperSvrTbl.PlatformInfo = std::stoi(PlatformInfoValue);
        }
        string IsEnableValue = rowData[VssUpperSvrTbl_IsEnable];
        if (IsEnableValue.length() != 0 && IsEnableValue != "NULL") {
            vssUpperSvrTbl.IsEnable = std::stoi(IsEnableValue);
        }
        string UpdateTimeValue = rowData[VssUpperSvrTbl_UpdateTime];
        if (UpdateTimeValue.length() != 0 && UpdateTimeValue != "NULL") {
            vssUpperSvrTbl.UpdateTime = UpdateTimeValue;
        }
        return vssUpperSvrTbl;
    }
   
};


#endif //VSSUPPERSVRTBL_MANAGER_H