def __update_alarm_status(self, serverId, typee, status): params = ( status, serverId, typee, 1, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AlarmSend._update_sql, params) pass
def update_info(self, id, ip, dt, info): ''' 更新服务器总内存 ''' if None == info or len(info) <= 0: return total = info['total'] params = ( total, id, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AnalysisMem.__update_sql, params)
def update_info(self, id, ip, dt, info): ''' 更新服务器cpu核数 ''' if None == info or len(info) <= 0: return cpuCount = info['cpucore'] params = ( cpuCount, id, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AnalysisLoad.__update_sql, params)
def add_repair_alarm(self, id, ip, level, typee, limitValue=0, nowValue=0, msg='', mobiles=''): sql = AlarmSend.__add_alarm_sql params = (id, ip, level, typee, limitValue, nowValue, msg, 6, mobiles) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( sql, params) pass
def add_info(self, id, ip, dt, info): ''' 保存服务器负载情况 ''' if None == info: return min1 = info['min1'] min5 = info['min5'] min15 = info['min15'] params = ( id, min1, min5, min15, dt, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AnalysisLoad.__add_sql, params)
def __query_alarm_by_monitorTime(self, monitorTime): ''' 获取需要所有采集的服务器 ''' sql = AlarmSend._query_alarm_sql + ' WHERE a.`monitorTime` >= %s order by a.`type` desc, a.`id` asc ' params = (monitorTime, ) alarms = mysql_helper.get_mysql_helper(**config.db).find_all( sql, params, AlarmSend._query_alarm_col) return alarms
def add_info(self, id, ip, dt, info): if None == info or len(info) <= 0: return for i in info: params = ( id, i[i['key']], i['tx'], i['cumulative_tx'], i['rx'], i['cumulative_rx'], i['cx'], i['cumulative_cx'], dt, ) mysql_helper.get_mysql_helper( **config.db).insert_or_update_or_delete( AnalysisNetwork.__add_sql, params)
def add_info(self, id, ip, dt, info): ''' 保存服务器内存情况 ''' if None == info: return params = ( id, info['available'], info['used'], info['cached'], info['percent'], info['free'], info['inactive'], info['active'], info['total'], info['buffers'], dt, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AnalysisMem.__add_sql, params)
def add_info(self, id, ip, dt, info): if None == info: return params = ( id, info['softirq'], info['iowait'], info['system'], info['guest'], info['idle'], info['user'], info['irq'], info['total'], info['steal'], info['nice'], dt, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AnalysisCpu.__add_sql, params)
def update_info(self, id, ip, dt, info): if None == info or len(info) <= 0: return osName = info['os_name'] osVersion = info['os_version'] linux_distro = info['linux_distro'] hostname = info['hostname'] platform = info['platform'] hr_name = info['hr_name'] params = ( linux_distro, osVersion, hostname, id, ) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete( AnalysisSystem.__update_sql, params)
def add_info(self, id, ip, dt, info): ''' 保存服务器负载情况 ''' if None == info or len(info) <= 0: return for i in info: diskName = i[i['key']] readBytes = i['read_bytes'] writeBytes = i['write_bytes'] params = ( id, diskName, readBytes, writeBytes, dt, ) mysql_helper.get_mysql_helper( **config.db).insert_or_update_or_delete( AnalysisDiskio.__add_sql, params)
def query_collect_server_all(): ''' 获取需要所有采集的服务器 ''' global _query_sql global _query_col sql = _query_sql + ' WHERE a.`status` = %s AND a.`isDelete` = %s order by a.`id` asc ' params = ( 1, 2, ) servers = mysql_helper.get_mysql_helper(**config.db).find_all( sql, params, _query_col) return servers
def __get_server_alarm_user(self, userIds): ''' 根据服务器报警编号查询报警用户 ''' users = [] if None == userIds or '' == userIds: return users uids = userIds.split(',') us = [] for ui in uids: if '' == ui: continue us.append(ui) sql = AnalysisBase.__query_users_sql + ' WHERE a.`status` = %s AND a.`isDelete` = %s AND a.`id` in ('+','.join(us)+') order by a.`id` asc ' params = ( 1, 2, ) users = mysql_helper.get_mysql_helper(**config.db).find_all(sql, params, AnalysisBase.__query_users_col) return users
def __query_collect_server_by_id(self, id): ''' 根据ID获取采集的服务器 ''' sql = AnalysisBase._query_server_sql + ' WHERE a.`id` = %s AND a.`status` = %s AND a.`isDelete` = %s order by a.`id` asc ' params = ( id, 1, 2, ) server = mysql_helper.get_mysql_helper(**config.db).find_one(sql, params, AnalysisBase._query_server_col) return server
def query_collect_server_all(self): ''' 获取需要所有采集的服务器 ''' sql = AnalysisBase._query_server_sql + ' WHERE a.`status` = %s AND a.`isDelete` = %s order by a.`id` asc ' params = ( 1, 2, ) servers = mysql_helper.get_mysql_helper(**config.db).find_all(sql, params, AnalysisBase._query_server_col) return servers
def add_alarm(self, id, ip, level, limitValue = 0, nowValue = 0, msg = '', dt = '', mobiles = ''): sql = AnalysisBase.__add_alarm_sql params = (id, ip, level, self.mqName, limitValue, nowValue, msg, dt, 1, mobiles) mysql_helper.get_mysql_helper(**config.db).insert_or_update_or_delete(sql, params) pass