def measurements(deveui): ''' Returns all measurements of a sensor node ''' return jsonify(list_to_dict((Sensor.select(Sensor, Measurement) .join(Measurement) .where(Sensor.deveuid == deveui) .get()) ))
def graph_data(deveui): ''' Get simple csv data for a grap ''' data = (Sensor.select(Sensor, Measurement) .join(Measurement) .where( Sensor.deveuid == deveui & Measurement.type == 'temparature') .get()) measurements = [] for messung in data.measurements: measurements.append({ 'timestamp': messung.timestamp, 'type': messung.type, 'value': dafuqnumber(messung.value) }) return jsonify({'data': measurements})