Esempio n. 1
0
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))
Esempio n. 2
0
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))
Esempio n. 3
0
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))