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 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)