def get_by_search(start, end):
# init
foundPressure = []
foundHumidities = []
foundCo2 = []
foundTemperatures = []
# Execution (4 connection, could be more effecient but query time is hardly an issue)
foundPressure = PressureModel.get_by_search(start, end)
foundHumidities = HumidityModel.get_by_search(start, end)
foundCo2 = CO2Model.get_by_search(start, end)
foundTemperatures = TemperatureModel.get_by_search(start, end)
# Build object
returnObj = SensorModel(foundPressure, foundHumidities, foundCo2,
foundTemperatures)
# Clean and return
return returnObj
def pressure_get_by_search():
logging.debug("Received request /pressures/search")
startTime = time.monotonic()
try:
start = req.args.get('start')
if start is None:
start = '2020-01-01T00:00:00'
end = req.args.get('end')
if end is None:
end = datetime.utcnow()
dataArray = []
pressArray = PressureModel.get_by_search(start, end)
for tempModel in pressArray:
dataArray.append(tempModel.to_json())
elapsedTime = time.monotonic() - startTime
logging.debug("temperature get all request time: " +
str(round(elapsedTime, 5)) + " seconds")
return res(200, data=dataArray, timeUTC=datetime.utcnow())
except mariadb.Error as e:
abort(500, str(e))