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
