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_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