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