def checkErrFlag(M_ID, START_TIME, dbconncr, dbconn): try: sql = "select err_flag, err_msg from monitor.t_mot_conf_log a where a.M_ID = '" + M_ID + "' and a.start_time = " + START_TIME dbconncr.prepare(sql) dbconncr.execute(sql) result = dbconncr.fetchall() if len(result) != 0: if result[0][0] == '1': #调短信接口 sendResult = getMessage.getMessageInterface(dbconncr, result[0][1]) if sendResult == 1: #更新日志表记录err_flag updateErrFlag(M_ID, START_TIME, dbconncr, dbconn) except Exception,e: with open(r'error.log','a') as error_log: print >> error_log,('%s %s %s' % (time.ctime(),'Check Flag Faild:',e))
def checkExecErrFlag(M_ID, dbconncr, dbconn): try: sql = ( "select err_flag, err_msg, exec_time from monitor.t_mot_conf_log a where a.M_ID = '" + M_ID + "' order by exec_time desc" ) dbconncr.prepare(sql) dbconncr.execute(sql) result = dbconncr.fetchall() if result[0][0] == "1": # 调短信接口 sendResult = getMessage.getMessageInterface(dbconncr, result[0][1]) if sendResult == 1: # 更新日志表记录err_flag updateExecErrFlag(M_ID, result[0][2], dbconncr, dbconn) except Exception, e: with open(r"error.log", "a") as error_log: print >> error_log, ("%s %s %s" % (time.ctime(), "Check Flag Faild:", e))