def historic_pressures_reset_in_range(): logging.debug("Received request /historic/pressures/reset/range") startTime = time.monotonic() try: # Requires a simple pw pw = req.args.get("pw") logging.debug("pw arg is: " + str(pw)) if pw != "A7G2V9": abort(403) 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)) HistoricPressureModel.delete_by_range(start, end) elapsedTime = time.monotonic() - startTime logging.debug("Pressure reset in range request time: " + str(round(elapsedTime, 5)) + " seconds") return res(204, timeUTC=datetime.utcnow()) except mariadb.Error as e: abort(500, str(e))
def delete_by_range(start, end): # Init returnValue = True # Execution HistoricPressureModel.delete_by_range(start, end) HistoricHumidityModel.delete_by_range(start, end) HistoricCO2Model.delete_by_range(start, end) HistoricTemperatureModel.delete_by_range(start, end) # Clean and return return returnValue
def historic_pressures_get_average(): logging.debug("Received request /historic/pressures/average") startTime = time.monotonic() try: returnValue = HistoricPressureModel.get_average() data = HistoricPressureModel.average_json(returnValue) elapsedTime = time.monotonic() - startTime logging.debug("pressure get average request time: " + str(round(elapsedTime, 5)) + " seconds") return res(200, data=data, timeUTC=datetime.utcnow()) except mariadb.Error as e: abort(500, str(e))
def delete_all(): # Init returnValue = True # Execution HistoricPressureModel.delete_all() HistoricHumidityModel.delete_all() HistoricCO2Model.delete_all() HistoricTemperatureModel.delete_all() # Clean and return return returnValue
def historic_pressure_get_by_search(): logging.debug("Received request /historic/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 = HistoricPressureModel.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 historic_pressures_reset(): logging.debug("Received request /historic/pressures/reset") startTime = time.monotonic() try: # Requires a simple pw pw = req.args.get("pw") logging.debug("pw arg is: " + str(pw)) if pw != "A7G2V9": abort(403) HistoricPressureModel.delete_all() elapsedTime = time.monotonic() - startTime logging.debug("Pressure reset request time: " + str(round(elapsedTime, 5)) + " seconds") return res(204, timeUTC=datetime.utcnow()) except mariadb.Error as e: abort(500, str(e))
def to_average_json(self): logging.debug("Formatting SensorModel to average json") json = { 'type': 'All historic sensor average', 'attributes': { 'pressure': HistoricPressureModel.average_json(self.pressures), 'humidity': HistoricHumidityModel.average_json(self.humidities), 'co2': HistoricCO2Model.average_json(self.co2), 'temperature': HistoricTemperatureModel.average_json(self.temperatures) } } return json
def historic_pressure_get_average_in_range(): logging.debug("Received request /historic/pressures/average/range") 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)) returnValue = HistoricPressureModel.get_average_by_range(start, end) data = HistoricPressureModel.average_json(returnValue) elapsedTime = time.monotonic() - startTime logging.debug("pressure get average by range all request time: " + str(round(elapsedTime, 5)) + " seconds") return res(200, data=data, timeUTC=datetime.utcnow()) except mariadb.Error as e: abort(500, str(e))
def historic_pressure_get_newest(): logging.debug("Received request /historic/pressures/newest") startTime = time.monotonic() try: returnValue = HistoricPressureModel.get_newest() if returnValue is None: abort(404) data = returnValue.to_json() elapsedTime = time.monotonic() - startTime logging.debug("pressure get newest all request time: " + str(round(elapsedTime, 5)) + " seconds") return res(200, data=data, timeUTC=datetime.utcnow()) except mariadb.Error as e: abort(500, str(e))
def historic_pressure_get_all(): logging.debug("Received request /pressures") startTime = time.monotonic() try: dataArray = [] pressArray = HistoricPressureModel.get_all() for tempModel in pressArray: dataArray.append(tempModel.to_json()) elapsedTime = time.monotonic() - startTime logging.debug("pressure 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))
def get_all(): # init foundPressure = [] foundHumidities = [] foundCo2 = [] foundTemperatures = [] # Execution (4 connection, could be more efficient but query time is hardly an issue) foundPressure = HistoricPressureModel.get_all() foundHumidities = HistoricHumidityModel.get_all() foundCo2 = HistoricCO2Model.get_all() foundTemperatures = HistoricTemperatureModel.get_all() # Build object returnObj = HistoricSensorModel( foundPressure, foundHumidities, foundCo2, foundTemperatures) # Clean and return return returnObj
def get_average_by_range(start, end): # init foundPressure = None foundHumidities = None foundCo2 = None foundTemperatures = None # Execution (4 connection, could be more efficient but query time is hardly an issue) foundPressure = HistoricPressureModel.get_average_by_range(start, end) foundHumidities = HistoricHumidityModel.get_average_by_range(start, end) foundCo2 = HistoricCO2Model.get_average_by_range(start, end) foundTemperatures = HistoricTemperatureModel.get_average_by_range(start, end) # Build object returnObj = HistoricSensorModel( foundPressure, foundHumidities, foundCo2, foundTemperatures) # Clean and return return returnObj