Esempio n. 1
0
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))
Esempio n. 2
0
    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