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
