def user_by_id():
user_id = request.args.get("id")
if not user_id:
abort(400, "Некорректный запрос!")
session = Session()
current_users = session.query(User).filter_by(id=user_id).all()
result = build_users_page(current_users)
session.close()
return render_template('user.html', table=result)
def save_sensor_data(sensor_data):
session = Session()
new_data = Sensors_data(sensor_id=int(sensor_data['sensor_id']),
timestamp=sensor_data['timestamp'],
co=float(sensor_data['co']),
o3=float(sensor_data['o3']),
no2=float(sensor_data['no2']),
so2=float(sensor_data['so2']),
co2=float(sensor_data['co2']),
temperature=float(sensor_data['temp']),
humidity=float(sensor_data['hum']),
uv=float(sensor_data['uv']),
luminosity=float(sensor_data['lum']),
pm1=float(sensor_data['pm1']),
pm25=float(sensor_data['pm25']),
pm10=float(sensor_data['pm10']),
noise=float(sensor_data['sonido']))
session.add(new_data)
session.commit()
session.close()
def send_saved_data():
session = Session()
saved_data_entries = session.query(Sensors_data).all()
response = 'success'
for eachRow in saved_data_entries:
sensor_data = dict()
sensor_data['username'] = "******"
sensor_data['pwd'] = "passw0rd"
sensor_data['sensor_id'] = eachRow.sensor_id
sensor_data['timestamp'] = eachRow.timestamp
sensor_data['co'] = eachRow.co
sensor_data['o3'] = eachRow.o3
sensor_data['no2'] = eachRow.no2
sensor_data['so2'] = eachRow.so2
sensor_data['co2'] = eachRow.co2
sensor_data['temp'] = eachRow.temp
sensor_data['hum'] = eachRow.hum
sensor_data['uv'] = eachRow.uv
sensor_data['lum'] = eachRow.lum
sensor_data['pm1'] = eachRow.pm1
sensor_data['pm25'] = eachRow.pm25
sensor_data['pm10'] = eachRow.pm10
sensor_data['sonido'] = eachRow.sonido
current_response = server.Send_to_server(sensor_data)
if (current_response == 'success'):
session.delete(eachRow)
else:
break
session.commit()
session.close()
def users():
session = Session()
active_users = session.query(User).filter_by(status=True).all()
result = build_users_page(active_users)
session.close()
return render_template('user.html', table=result)
