def post(self): """ Creates a measurement """ data = self.reqparse.parse_args() measurement = Measurement(**data) user = User.objects(email='*****@*****.**').first() measurement.user = user measurement.save() return measurement.to_dict(), 201
def post(self): try: data = self.reqparse.parse_args() measurement = Measurement(**data) user = User.objects(email="*****@*****.**").first() measurement.user = user measurement.save() return measurement.to_dict(), 201 except BadRequest as e: abort(400, message=e.data.get("message")) except (NotUniqueError, ValidationError) as e: abort(400, message=str(e)) except Exception as e: abort(500, message=str(e))
def post(self): """ Creates a measurement """ data = self.reqparse.parse_args() measurement = Measurement(**data) user = User.objects(email='*****@*****.**').modify( upsert=True, new=True, set__email='*****@*****.**', set__name='Jorge', set__surname='Galvis') measurement.user = user measurement.save() return measurement.to_dict(), 201
def test__one_by_one_import_all(): mock_measurement = Measurement() mock_measurement.save = MagicMock(return_value=1) measurements = [mock_measurement, mock_measurement] inserted_count = Importer._one_by_one_import_all(measurements) assert inserted_count == 2
def post(self): try: data = self.reqparse.parse_args() measurement = Measurement(**data) user = User.objects(email='*****@*****.**').first() measurement.user = user measurement.save() return measurement.to_dict(), 201 except BadRequest as e: app.logger.error(e) abort(400, message=e.data.get('message')) except (NotUniqueError, ValidationError) as e: app.logger.error(e) abort(400, message=str(e)) except Exception as e: app.logger.error(e) abort(500, message=str(e))
def test_bulk_import_new_measurements(client): measurement = Measurement(timestamp=datetime.datetime( 2017, 1, 1, 1, tzinfo=pendulum.timezone("Europe/Berlin")), nodeId='test_node') measurement.save() # One entry is older than the latest entry so it should not be imported import_measurements = [ Measurement(timestamp=datetime.datetime( 2017, 1, 1, 0, tzinfo=pendulum.timezone("Europe/Berlin")), nodeId='test_node'), Measurement(timestamp=datetime.datetime( 2017, 1, 1, 2, tzinfo=pendulum.timezone("Europe/Berlin")), nodeId='test_node') ] insert_count = Importer._bulk_import_new_measurements(import_measurements) assert insert_count == 1 assert db.session.query(Measurement).count() == 2
import serial import json from models import Measurement # open serial connection to our Arduino ser = serial.Serial('/dev/ttyUSB0', 9600) # read values from serial connection and write them to our db while 1: line = ser.readline() data = json.loads(line.decode("utf-8")) print(data) temp = data["sensors"]["temp"]["value"] hum = data["sensors"]["rel_hum"]["value"] # vcc = data["sensors"]["vcc"]["value"] new_measurement = Measurement( temperature=temp, relative_humidity=hum, # vcc = vcc, ) new_measurement.save(force_insert=True)