def compareKey(releation, result, key, M_ID, errType, errMsg, t_scn, m_interval, startTimeStr, endTime, dbconncr, dbconn, provinceCode, startTime): try: if releation == '1': if result > int(key): errFlag = 1 else: errFlag = 0 if errType == 1: startTime = "'||" + startTime + "||'" endTimeStr = "'|| to_char(" + endTime + ", 'yyyy-mm-dd hh24:mi:Ss')" sendErrMsg = re.sub("province_result", str(provinceCode), errMsg) sendErrMsg = re.sub("count_result", str(result), sendErrMsg) sendErrMsg = re.sub("start_time_conds", startTime, sendErrMsg) sendErrMsg = re.sub("end_time_conds", endTimeStr, sendErrMsg) else: sendErrMsg = errMsg #告警信息有4个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTimeStr, endTime, dbconncr, dbconn, provinceCode) elif releation == '2': if result >= int(key): errFlag = 1 else: errFlag = 0 if errType == 1: startTime = "'||" + startTime + "||'" endTimeStr = "'|| to_char(" + endTime + ", 'yyyy-mm-dd hh24:mi:Ss')" sendErrMsg = re.sub("province_result", str(provinceCode), errMsg) sendErrMsg = re.sub("count_result", str(result), sendErrMsg) sendErrMsg = re.sub("start_time_conds", startTime, sendErrMsg) sendErrMsg = re.sub("end_time_conds", endTimeStr, sendErrMsg) else: sendErrMsg = errMsg #告警信息有4个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTimeStr, endTime, dbconncr, dbconn, provinceCode) elif releation == '3': if result < int(key): errFlag = 1 else: errFlag = 0 if errType == 1: startTime = "'||" + startTime + "||'" endTimeStr = "'|| to_char(" + endTime + ", 'yyyy-mm-dd hh24:mi:Ss')" sendErrMsg = re.sub("province_result", str(provinceCode), errMsg) sendErrMsg = re.sub("count_result", str(result), sendErrMsg) sendErrMsg = re.sub("start_time_conds", startTime, sendErrMsg) sendErrMsg = re.sub("end_time_conds", endTimeStr, sendErrMsg) else: sendErrMsg = errMsg #告警信息有4个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTimeStr, endTime, dbconncr, dbconn, provinceCode) elif releation == '4': if result <= int(key): errFlag = 1 else: errFlag = 0 if errType == 1: startTime = "'||" + startTime + "||'" endTimeStr = "'|| to_char(" + endTime + ", 'yyyy-mm-dd hh24:mi:Ss')" sendErrMsg = re.sub("province_result", str(provinceCode), errMsg) sendErrMsg = re.sub("count_result", str(result), sendErrMsg) sendErrMsg = re.sub("start_time_conds", startTime, sendErrMsg) sendErrMsg = re.sub("end_time_conds", endTimeStr, sendErrMsg) else: sendErrMsg = errMsg #告警信息有4个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTimeStr, endTime, dbconncr, dbconn, provinceCode) elif releation == '5': if result == int(key): errFlag = 1 else: errFlag = 0 if errType == 1: startTime = "'||" + startTime + "||'" endTimeStr = "'|| to_char(" + endTime + ", 'yyyy-mm-dd hh24:mi:Ss')" sendErrMsg = re.sub("province_result", str(provinceCode), errMsg) sendErrMsg = re.sub("count_result", str(result), sendErrMsg) sendErrMsg = re.sub("start_time_conds", startTime, sendErrMsg) sendErrMsg = re.sub("end_time_conds", endTimeStr, sendErrMsg) else: sendErrMsg = errMsg #告警信息有4个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTimeStr, endTime, dbconncr, dbconn, provinceCode) elif releation == '6': if result > int(key): errFlag = 1 else: errFlag = 0 if errType == 1: startTime = "'||" + startTime + "||'" endTimeStr = "'|| to_char(" + endTime + ", 'yyyy-mm-dd hh24:mi:Ss')" sendErrMsg = re.sub("province_result", str(provinceCode), errMsg) sendErrMsg = re.sub("count_result", str(result), sendErrMsg) sendErrMsg = re.sub("start_time_conds", startTime, sendErrMsg) sendErrMsg = re.sub("end_time_conds", endTimeStr, sendErrMsg) else: sendErrMsg = errMsg #告警信息有4个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTimeStr, endTime, dbconncr, dbconn, provinceCode) else: with open(r'error.log','a') as error_log: print >> error_log,('%s %s $s' % (time.ctime(), "'M_ID:'" + M_ID, 'RELEATION Tpye Error:')) except Exception,e: with open(r'error.log','a') as error_log: print >> error_log,('%s %s %s' % (time.ctime(),'COMPARE RELEATION Faild:',e))
def compareKey(releation, result, key, M_ID, errType, errMsg, t_scn, m_interval, startTime, endTime, dbconncr, dbconn): try: if releation == '1': if result > int(key): errFlag = 1 else: errFlag = 0 if errType == 1: sendErrMsg = re.sub("count_result", str(result), errMsg) else: sendErrMsg = errMsg #告警信息只有一个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTime, endTime, dbconncr, dbconn) elif releation == '2': if result >= int(key): errFlag = 1 else: errFlag = 0 if errType == 1: sendErrMsg = re.sub("count_result", str(result), errMsg) else: sendErrMsg = errMsg #告警信息只有一个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTime, endTime, dbconncr, dbconn) elif releation == '3': if result < int(key): errFlag = 1 else: errFlag = 0 if errType == 1: sendErrMsg = re.sub("count_result", str(result), errMsg) else: sendErrMsg = errMsg #告警信息只有一个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTime, endTime, dbconncr, dbconn) elif releation == '4': if result <= int(key): errFlag = 1 else: errFlag = 0 if errType == 1: sendErrMsg = re.sub("count_result", str(result), errMsg) else: sendErrMsg = errMsg #告警信息只有一个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTime, endTime, dbconncr) elif releation == '5': if result == int(key): errFlag = 1 else: errFlag = 0 if errType == 1: sendErrMsg = re.sub("count_result", str(result), errMsg) else: sendErrMsg = errMsg #告警信息只有一个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTime, endTime, dbconncr, dbconn) elif releation == '6': if result > int(key): errFlag = 1 else: errFlag = 0 if errType == 1: sendErrMsg = re.sub("count_result", str(result), errMsg) else: sendErrMsg = errMsg #告警信息只有一个参数 #调用insert方法 dealResult.insertResult(M_ID, t_scn, m_interval, result, sendErrMsg, errFlag, startTime, endTime, dbconncr, dbconn) else: with open(r'error.log','a') as error_log: print >> error_log,('%s %s $s' % (time.ctime(), "'M_ID:'" + M_ID, 'RELEATION Tpye Error:')) except Exception,e: with open(r'error.log','a') as error_log: print >> error_log,('%s %s %s' % (time.ctime(),'COMPARE RELEATION Faild:',e))