-def select_sensordata(sensor_id, sensor_type, begin, end):
- query = Sensors.query
- if sensor_id is not None:
- query = query.filter(Sensors.sensor_id == sensor_id)
- if sensor_type is not None:
- query = query.filter(Sensors.value_type == sensor_type)
- if begin is not None:
- query = query.filter(Sensors.timestamp >= begin)
- if end is not None:
- query = query.filter(Sensors.timestamp <= end)
- return query.all()
-
-