def info(inData): from user import User from sensor import Sensor from station import Station pureData = Auth.select(inData) userInfo = {} sensorInfo = {} stationInfo = {} #print(pureData) for tmp in pureData['data']: t = tmp['sensorId'] if (not (t in sensorInfo)): curSensor = Sensor.select({'id': t}) sensorInfo[t] = curSensor tmp['sensorName'] = sensorInfo[t]['data'][0]['name'] t = sensorInfo[t]['data'][0]['stationId'] if (not (t in stationInfo)): curStation = Station.select({id: t}) stationInfo[t] = curStation tmp['stationName'] = stationInfo[t]['data'][0]['name'] t = tmp['userId'] if (not (t in userInfo)): curUser = User.select({'id': t}) userInfo[t] = curUser tmp['userName'] = userInfo[t]['data'][0]['username'] return pureData
def delete_station2(inData): ''' :param inData: :return:{ 2:'there is no id in inData', 3:'there is no such id' } ''' ret = 0 if('id' not in inData): ret = 2 return ret query = session.query(Station) tmpStation = query.filter(Station.id == inData['id']).first() if(tmpStation is None): ret = 3 return ret else: from sensor import Sensor tmpAllSensor = Sensor.select({'stationId': tmpStation.id}) for tmpSensor in tmpAllSensor['pureData']: tmpSensor.stationId = 0 session.delete(tmpStation) session.commit() ret = 1 return ret
def delete_station2(inData): ''' :param inData: :return:{ 2:'there is no id in inData', 3:'there is no such id' } ''' ret=0 if(not inData.has_key('id')): ret=2 return ret query=session.query(Station) tmpStation=query.filter(Station.id==inData['id']).first() if(tmpStation==None): ret=3 return ret else: from sensor import Sensor tmpAllSensor=Sensor.select({'stationId': tmpStation.id}) for tmpSensor in tmpAllSensor['pureData']: tmpSensor.stationId=0 session.delete(tmpStation) session.commit() ret=1 return ret
def info(inData): from user import User from sensor import Sensor from station import Station pureData=Auth.select(inData) userInfo={} sensorInfo={} stationInfo={} #print(pureData) for tmp in pureData['data']: t=tmp['sensorId'] if(not(t in sensorInfo)): curSensor=Sensor.select({'id': t}) sensorInfo[t]=curSensor tmp['sensorName']=sensorInfo[t]['data'][0]['name'] t=sensorInfo[t]['data'][0]['stationId'] if(not(t in stationInfo)): curStation=Station.select({id: t}) stationInfo[t]=curStation tmp['stationName']=stationInfo[t]['data'][0]['name'] t=tmp['userId'] if(not(t in userInfo)): curUser=User.select({'id':t}) userInfo[t]=curUser tmp['userName']=userInfo[t]['data'][0]['username'] return pureData
def info(inData): from user import User from sensor import Sensor from station import Station from auth import Auth allEqpData=Eqp.select(inData) userInfo={} sensorInfo={} stationInfo={} authInfo={} #print(allEqpData) for tmp in allEqpData['data']: t=tmp['number'] tmpAllSensor=Sensor.select({'number': t}) if(len(tmpAllSensor['data'])==0): tmp['sensorName']='not find' tmp['stationName']='not find' tmp['username']='******' else: curSensor=tmpAllSensor['pureData'][0] tmp['sensorName']=curSensor.name tmpAllStation=Station.select({'id': curSensor.stationId}) if(len(tmpAllStation['data'])==0): tmp['stationName']='not find' else: curStation=tmpAllStation['pureData'][0] tmp['stationName']=curStation.name tmp['userName']=curStation.supervisor tmpAllAuth=Auth.select({'sensorId': curSensor.id}) # if(len(tmpAllAuth['data'])==0): # tmp['username']='******' # else: # tmpAllUser=User.select({'id': tmpAllAuth['pureData'][0].userId}) # if(len(tmpAllUser['data'])==0): # tmp['username']='******' # else: # tmp['username']=tmpAllUser['data'][0]['username'] return allEqpData
def info(inData): from user import User from sensor import Sensor from station import Station from auth import Auth allEqpData = Eqp.select(inData) userInfo = {} sensorInfo = {} stationInfo = {} authInfo = {} #print(allEqpData) for tmp in allEqpData['data']: t = tmp['number'] tmpAllSensor = Sensor.select({'number': t}) if (len(tmpAllSensor['data']) == 0): tmp['sensorName'] = 'not find' tmp['stationName'] = 'not find' tmp['username'] = '******' else: curSensor = tmpAllSensor['pureData'][0] tmp['sensorName'] = curSensor.name tmpAllStation = Station.select({'id': curSensor.stationId}) if (len(tmpAllStation['data']) == 0): tmp['stationName'] = 'not find' else: curStation = tmpAllStation['pureData'][0] tmp['stationName'] = curStation.name tmp['userName'] = curStation.supervisor tmpAllAuth = Auth.select({'sensorId': curSensor.id}) # if(len(tmpAllAuth['data'])==0): # tmp['username']='******' # else: # tmpAllUser=User.select({'id': tmpAllAuth['pureData'][0].userId}) # if(len(tmpAllUser['data'])==0): # tmp['username']='******' # else: # tmp['username']=tmpAllUser['data'][0]['username'] return allEqpData