def sql1(sql, dbconncr, startTime, m_interval, M_ID, t_scn, dbconn): try: compareTimeResult = getTimeInterval.compareTime(m_interval, startTime) if compareTimeResult: startTime = "'" + time.strftime("%Y-%m-%d", time.localtime(time.time())) + " " + startTime + "'" startTimeStr = "to_date(" + startTime + ", 'yyyy-mm-dd hh24:mi:ss')" sql = re.sub("start_time_conds", startTimeStr, sql) EndTime = "monitor.F_Enddate(" + startTime + ",'" + m_interval + "')" sql = re.sub("end_time_conds", EndTime, sql) viewLogResult = viewResult.viewResult(M_ID, startTimeStr, dbconncr) if viewLogResult == 0: dbconncr.prepare(sql) dbconncr.execute(sql) resultList = dbconncr.fetchall() for result in resultList: # 插入值 if len(result) == 1: insertResult1(M_ID, t_scn, m_interval, result[0], startTimeStr, EndTime, dbconncr, dbconn) elif len(result) == 2: insertResult2( M_ID, t_scn, m_interval, result[1], startTimeStr, EndTime, dbconncr, dbconn, result[0] ) except Exception, e: with open(r"error.log", "a") as error_log: print >> error_log, ("%s %s %s" % (time.ctime(), "Execute Collect Faild:", e))
def sql1(sql, dbconncr, startTime, m_interval, releation, M_ID, key, errStatus, errMsg, t_scn, dbconn): try: if errStatus == "SQL10": errType = 0 else: errType = 1 #当前时间和取到的时间片间隔比较 compareTimeResult = getTimeInterval.compareTime(m_interval, startTime) if compareTimeResult: startTime = "'" + time.strftime('%Y-%m-%d',time.localtime(time.time())) + ' ' + startTime + "'" startTimeStr = 'to_date(' + startTime + ", 'yyyy-mm-dd hh24:mi:ss')" sql = re.sub("start_time_conds", startTimeStr, sql) EndTime = 'monitor.F_Enddate(' + startTime + ',\'' + m_interval + '\')' sql = re.sub("end_time_conds", EndTime, sql) viewLogResult = viewResult.viewResult(M_ID, startTimeStr, dbconncr) if viewLogResult == 0: dbconncr.prepare(sql) dbconncr.execute(sql) resultList = dbconncr.fetchall() if len(resultList) != 0: for result in resultList: #查询结果每行有两个值 compareKey(releation, result[1], key, M_ID, errType, errMsg, t_scn, m_interval, startTimeStr, EndTime, dbconncr, dbconn, result[0], startTime) #dealResult.checkErrFlag(M_ID, startTimeStr, dbconncr, dbconn) except Exception,e: with open(r'error.log','a') as error_log: print >> error_log,('%s %s %s' % (time.ctime(),'Excute Monitor SQL Faild:',e))
def sql1(sql, dbconncr, startTime, m_interval, M_ID, t_scn, dbconn): try: compareTimeResult = getTimeInterval.compareTime(m_interval, startTime) if compareTimeResult: startTime = "'" + time.strftime('%Y-%m-%d',time.localtime(time.time())) + ' ' + startTime + "'" startTimeStr = 'to_date(' + startTime + ", 'yyyy-mm-dd hh24:mi:ss')" sql = re.sub("start_time_conds", startTimeStr, sql) EndTime = 'monitor.F_Enddate(' + startTime + ',\'' + m_interval + '\')' sql = re.sub("end_time_conds", EndTime, sql) viewLogResult = viewResult.viewResult(M_ID, startTimeStr, dbconncr) if viewLogResult == 0: dbconncr.prepare(sql) dbconncr.execute(sql) resultList = dbconncr.fetchall() for result in resultList: #插入值 if len(result) == 1: insertResult(M_ID, t_scn, m_interval, result[0], startTimeStr, EndTime, dbconncr, dbconn) except Exception,e: with open(r'error.log','a') as error_log: print >> error_log,('%s %s %s' % (time.ctime(),'Execute Collect Faild:',e))