def get_data_timespan_db_date_query(dev_id,start_date,end_date,celc):
return_list=[]
connection = Connection()
db = connection.lws
collection = db.tempData
start_date = parse_date(start_date)
end_date = parse_date(end_date)
#import time
#start = time.time()
#db.tempData.find({"h":{$gte:1,$lte:10},"min":{$gte:0,$lte:1},"s":{$gte:0,$lte:10}}).count()
start_date = datetime.datetime(start_date['year'],start_date['month'],start_date['day'],start_date['hour'],start_date['min'],start_date['second'])
end_date = datetime.datetime(end_date['year'],end_date['month'],end_date['day'],end_date['hour'],end_date['min'],end_date['second'])
print start_date
print end_date
import lws_server_sensor_config
db_data = collection.find({"phid":dev_id,"datetime":{"$gte":start_date,"$lt":end_date}})
return_list=[]
#print time.time() - start
if db_data.count()==0:
print 'no data'
return 0
else:
for thing in db_data:
thing = json.loads(mongo_dumps(thing))
thing['sensor_data'] = lws_server_sensor_config.transpose_to_strings(thing['sensor_data'])
thing['sensor_data'] = lws_server_sensor_config.convert_to_real_values(thing['sensor_data'],celc,True)
return_list.append(thing)
#print thing
print db_data.count()
#return
return json.dumps(return_list)
def show_device():
if 'devid' in request.args:
devid = request.args['devid']
#day_records = get_day_dev_info(devid)
now_record = get_current_stats(devid,0)
dev_info = now_record['dev_info']
#print dev_info
now_record = now_record['data_list']
#print now_record
now_sense_data = now_record['sensor_data']
#now_sense_data ={'test':'test'}
#for thing in now_sense_data:
#now_sense_data[str(thing)] = now_sense_data[thing]
#del now_sense_data[thing]
#now_sense_data = dict((k.encode('ascii'), str(v)) for (k, v) in now_sense_data.items())
now_sense_data = transpose_to_strings(now_sense_data)
#print now_sense_data
now_sense_data = convert_to_real_values(now_sense_data,False,True)
#print now_sense_data
#now_sense_data= {'help':0}
return render_template('device.html', dev_info = dev_info,current_record = now_record,sensor_data = now_sense_data)
#return render_template('device.html')
else:
return 0
