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 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
