class SAMHandler(WebHandler):
AUTH_PROPS = "all"
def web_getData(self):
self.DB = SAMDB()
states = self.DB.getState()['Value']
result=[]
for st in states:
temp = {}
temp['site'] = st[0]
temp['test'] = st[1]
temp['result'] = st[2]
temp['received'] = st[3]
temp['description'] = st[4]
result.append(temp)
self.write({"result":result})
def selectFromDB(self, site, test):
selectSQL = "SELECT R.last_update, R.state, R.description FROM Results R, Sites S, Tests T WHERE R.last_update > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND R.site_id=S.Site_id AND R.test_id=T.test_id AND S.name='%s' AND T.name='%s'"%(site, test)
result = self.DB._query( selectSQL )
return result
def web_getSiteMonthAvailability(self):
self.DB = SAMDB()
site = self.request.arguments['site'][0]
test = self.request.arguments['test'][0]
result = self.selectFromDB(site, test)
if result['OK']:
toSend = []
for st in result['Value']:
if st[1] in STATE_MAP:
temp = {}
temp['time'] = str(st[0])
temp['state'] = getStateNumber(st[1])
temp['description'] = st[2]
toSend.append(temp)
self.write({"result":toSend})
else:
print 'Error during selecting from DB'
