def check_ip_alert_accord_inst_and_busi(inst=None, busi=None):
'''
:param inst:
:param busi:
:return:如果该业务或实例涉及的ip有报警，则返回False，否则返回True
'''
ips = []
if inst is None and busi is not None:
ips = model_redis.get_ips_accord_busi(busi)
if len(ips) == 0:
try:
ips = model_ora.get_ip_accord_business(busi)
except:
traceback.print_exc()
if busi is None and inst is not None:
ips = model_redis.get_ips_accord_instance(inst)
if len(ips) == 0:
ips = model_ora.get_ips_accord_instance(inst)
if len(ips) == 0:
return False
ips_str = utils.convert_ips_to_str(ips)
date_str = get_check_date()
sql = config_reporter.GET_ALERT_NUM.format(
date_str, ips_str)
data = db.cursor.execute(sql).fetchone()[0]
print data
if data > 0:
return True # False为有报警
else:
return False
def get_current_alert_info(center_instance, center_ips):
if center_ips is None or center_ips == '' or len(center_ips) == 0:
center_ips = model_redis.get_ips_accord_instance(center_instance)
ips_str = utils.convert_ips_to_str(center_ips)
print ips_str
date_str = get_check_date()
sql = config_reporter.GET_ALERT_INFO.format(date_str, ips_str)
print 'alert:', sql
data = [dict(zip(config_reporter.ALERT_INFO, item)) for item in db.cursor.execute(sql).fetchall()]
return data
def get_detail_alert_info_accord_instance(oop_name=None, business_name=None):
date_str = get_check_date()
ip_seq = []
if oop_name is not None:
ip_seq = model_redis.get_ips_accord_instance(oop_name)
elif business_name is not None:
ip_seq = model_redis.get_ips_accord_busi(business_name)
ip_str = utils.convert_ips_to_str(ip_seq)
sql = config_reporter.GET_ALERT_DETAIL_INFO_ACCORD_INST.format(date_str, ip_str)
result = list(db.cursor.execute(sql).fetchall())
if len(result) == 0:
return None
return result
