def recent_pressure_get_by_search(): logging.debug("Received request /recent/pressures/search") startTime = time.monotonic() try: start = req.args.get('start') if start is None: start = '2020-01-01T00:00:00' logging.debug("Start arg is: " + str(start)) end = req.args.get('end') if end is None: end = datetime.utcnow() logging.debug("End arg is: " + str(end)) dataArray = [] pressArray = RecentPressureModel.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: logging.exception(e) abort(500, str(e))
def get_by_search(start, end): # init foundPressure = [] foundHumidities = [] foundCo2 = [] foundTemperatures = [] # Execution (4 connection, could be more efficient but query time is hardly an issue) foundPressure = RecentPressureModel.get_by_search(start, end) foundHumidities = RecentHumidityModel.get_by_search(start, end) foundCo2 = RecentCO2Model.get_by_search(start, end) foundTemperatures = RecentTemperatureModel.get_by_search(start, end) # Build object returnObj = RecentSensorModel(foundPressure, foundHumidities, foundCo2, foundTemperatures) # Clean and return return returnObj