def normalizeall (self,input,output,rangeb,rangea):# Currently disabled #VERIFICAR WHILE DEBIDO A QUE LOS QUIERIES SON < y no <= config=Config() INCREMENT=config.getCronTime() start=rangeb end=rangea join = [[0 for i in range(7)] for j in range(((end-start)/300)-1)] c1=c2=x=0 start =( start - start%INCREMENT) + INCREMENT # CHANGE TO INCREMENT while start <end : if c1<len(input) and input[c1][3]==start : join[x][0]=input[c1][0] join[x][2]=input[c1][1] join[x][4]=input[c1][2] c1=c1+1 else: join[x][0]=0 join[x][2]=0 join[x][4]=0 if c2<len(output) and output[c2][3]==start : join[x][1]=output[c2][0] join[x][3]=output[c2][1] join[x][5]=output[c2][2] c2=c2+1 else: join[x][1]=0 join[x][3]=0 join[x][5]=0 join[x][6]=start start=start+INCREMENT x=x+1 t=tuple(tuple(x) for x in join) return t
#!/usr/bin/python import time import MySQLdb from Config import Config import os config=Config() DB_NAME=config.getDBName(); DB_HOST='localhost' DB_USER=config.getUser(); DB_PASS=config.getPassword(); INCREMENT=config.getCronTime() LOGSPATH=config.getLogsPath() db = MySQLdb.connect(user=DB_USER, passwd=DB_PASS, db=DB_NAME, host=DB_HOST) c = db.cursor() #check if logs path exists, if not create it if not os.path.exists(LOGSPATH): os.makedirs(LOGSPATH) logs=open(LOGSPATH+'/cleanup_log','a+') #maxtime=31536000 year=31536000 #year in seconds maxtime=int(config.getOldesttime())*year