def before_request(): g.db = connect_db() Slot_Conf.set_db(g.db) Job.set_db(g.db) TimeInfo.set_db(g.db) slotStartEnd.set_db(g.db) Projects.set_db(g.db) Results.set_db(g.db) ProjNames.set_db(g.db) SlotTimes.set_db(g.db) ProjectTimes.set_db(g.db)
def slotTimeInfo(slot_name): #today = time.strftime("%Y-%m-%d") yesterday = '2014-08-14' preyesterday = '2014-08-13' #yesterday = (date.today()-timedelta(1)).strftime('%Y-%m-%d') #preyesterday = (date.today()-timedelta(2)).strftime('%Y-%m-%d') slotsendtimes = SlotTimes.view('statistics/slotTimeInfo', key=[today, slot_name, "job-end"]) slotsstarttimes = SlotTimes.view('statistics/slotTimeInfo', key=[today, slot_name, "job-start"]) data = {} slots = Slot_Conf.view('statistics/Slots', key=today) for s in slots: if s.slot == slot_name: data[s.slot] = {} for p in s.platforms: data[s.slot][p] = {} data[s.slot][p]['start'] = "" data[s.slot][p]['end'] = "" data[s.slot][p]['avgcompletion'] = 0 for s in slotsendtimes: data[s.slot][s.platform]['end'] = s.time for s in slotsstarttimes: data[s.slot][s.platform]['start'] = s.time slotendtimes = SlotTimes.view('statistics/slotTimeInfo', key=[yesterday, slot_name, "job-end"]) for s in slotendtimes: data[s.slot][s.platform]['avgcompletion'] += getSec(s.time) slotstarttimes = SlotTimes.view('statistics/slotTimeInfo', key=[yesterday, slot_name, "job-start"]) for s in slotstarttimes: data[s.slot][s.platform]['avgcompletion'] -= getSec(s.time) slotendtimes = SlotTimes.view('statistics/slotTimeInfo', key=[preyesterday, slot_name, "job-end"]) for s in slotendtimes: data[s.slot][s.platform]['avgcompletion'] += getSec(s.time) slotstarttimes = SlotTimes.view('statistics/slotTimeInfo', key=[preyesterday, slot_name, "job-start"]) for s in slotstarttimes: data[s.slot][s.platform]['avgcompletion'] -= getSec(s.time) data[s.slot][s.platform]['avgcompletion'] /= 2 data = json.dumps(data) return data
def slotTimeInfo(slot_name): #today = time.strftime("%Y-%m-%d") yesterday = '2014-08-14' preyesterday = '2014-08-13' #yesterday = (date.today()-timedelta(1)).strftime('%Y-%m-%d') #preyesterday = (date.today()-timedelta(2)).strftime('%Y-%m-%d') slotsendtimes = SlotTimes.view('statistics/slotTimeInfo',key = [today,slot_name,"job-end"]) slotsstarttimes = SlotTimes.view('statistics/slotTimeInfo',key = [today,slot_name,"job-start"]) data = {} slots = Slot_Conf.view('statistics/Slots',key=today) for s in slots: if s.slot == slot_name: data[s.slot]={} for p in s.platforms: data[s.slot][p]={} data[s.slot][p]['start'] = "" data[s.slot][p]['end'] = "" data[s.slot][p]['avgcompletion'] = 0 for s in slotsendtimes: data[s.slot][s.platform]['end'] = s.time for s in slotsstarttimes: data[s.slot][s.platform]['start'] = s.time slotendtimes = SlotTimes.view('statistics/slotTimeInfo',key = [yesterday,slot_name,"job-end"]) for s in slotendtimes: data[s.slot][s.platform]['avgcompletion']+=getSec(s.time) slotstarttimes = SlotTimes.view('statistics/slotTimeInfo',key = [yesterday,slot_name,"job-start"]) for s in slotstarttimes: data[s.slot][s.platform]['avgcompletion']-=getSec(s.time) slotendtimes = SlotTimes.view('statistics/slotTimeInfo',key = [preyesterday,slot_name,"job-end"]) for s in slotendtimes: data[s.slot][s.platform]['avgcompletion']+=getSec(s.time) slotstarttimes = SlotTimes.view('statistics/slotTimeInfo',key = [preyesterday,slot_name,"job-start"]) for s in slotstarttimes: data[s.slot][s.platform]['avgcompletion']-=getSec(s.time) data[s.slot][s.platform]['avgcompletion']/=2 data = json.dumps(data); return data