def recent_pressures_reset_in_range():
logging.debug("Received request /recent/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))
RecentPressureModel.delete_by_range(start,end)
elapsedTime = time.monotonic() - startTime
logging.debug("pressures 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 historic_co2_get_by_search():
logging.debug("Received request /historic/co2/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 = []
co2Array = HistoricCO2Model.get_by_search(start, end)
for tempModel in co2Array:
dataArray.append(tempModel.to_json())
elapsedTime = time.monotonic() - startTime
logging.debug("co2 get by search 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 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 recent_pressures_get_average():
logging.debug("Received request /recent/pressures/average")
startTime = time.monotonic()
try:
returnValue = RecentPressureModel.get_average()
data = RecentPressureModel.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 historic_sensors_get_average():
logging.debug("Received request /historic/sensors/average")
startTime = time.monotonic()
try:
returnValue = HistoricSensorModel.get_average()
data = returnValue.to_average_json()
elapsedTime = time.monotonic() - startTime
logging.debug("sensors get average all request time: " +
str(round(elapsedTime, 5)) + " seconds")
return res(200, data=data, time=datetime.utcnow())
except mariadb.Error as e:
abort(500, str(e))
def historic_co2_get_average():
logging.debug("Received request /historic/co2/average")
startTime = time.monotonic()
try:
returnValue = HistoricCO2Model.get_average()
data = HistoricCO2Model.average_json(returnValue)
elapsedTime = time.monotonic() - startTime
logging.debug("co 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 sensors_get_newest():
logging.debug("Received request /sensors/newest")
startTime = time.monotonic()
try:
returnValue = SensorModel.get_newest()
data = returnValue.to_single_json()
elapsedTime = time.monotonic() - startTime
logging.debug("sensor get newest 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 recent_pressure_get_all():
logging.debug("Received request /recent/pressures")
startTime = time.monotonic()
try:
dataArray = []
pressArray = RecentPressureModel.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 humidity_get_oldest():
logging.debug("Received request /humidities/oldest")
startTime = time.monotonic()
try:
returnValue = HumidityModel.get_oldest()
if returnValue is None:
abort(404)
data = returnValue.to_json()
elapsedTime = time.monotonic() - startTime
logging.debug("humidity get oldest 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 humidity_get_all():
logging.debug("Received request /humidities")
startTime = time.monotonic()
try:
dataArray = []
humArray = HumidityModel.get_all()
for tempModel in humArray:
dataArray.append(tempModel.to_json())
elapsedTime = time.monotonic() - startTime
logging.debug("humidity get all request time: " + str(round(elapsedTime,5))+ " seconds")
return res(200, data=dataArray, timeUTC=datetime.isoformat())
except mariadb.Error as e:
abort(500, str(e))
def recent_pressure_get_newest():
logging.debug("Received request /recent/pressures/newest")
startTime = time.monotonic()
try:
returnValue = RecentPressureModel.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 recent_co2_get_by_id(id):
logging.debug("Received request /recent/co2/<id>")
startTime = time.monotonic()
try:
returnValue = RecentCO2Model.get_by_id(id)
if returnValue is None:
abort(404)
data = returnValue.to_json()
elapsedTime = time.monotonic() - startTime
logging.debug("co2 get by id 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_sensors_get_all():
logging.debug("Received request /historic/sensors")
startTime = time.monotonic()
try:
dataArray = []
sensor = HistoricSensorModel.get_all()
data = sensor.to_json_array()
elapsedTime = time.monotonic() - startTime
logging.debug("sensors get 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_co2_get_all():
logging.debug("Received request /historic/co2")
startTime = time.monotonic()
try:
dataArray = []
co2Array = HistoricCO2Model.get_all()
for tempModel in co2Array:
dataArray.append(tempModel.to_json())
elapsedTime = time.monotonic() - startTime
logging.debug("co2 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 historic_temperatures_get_by_id(id):
logging.debug("Received request /historic/temperatures/<id>")
startTime = time.monotonic()
try:
returnValue = HistoricTemperatureModel.get_by_id(id)
if returnValue is None:
abort(404)
data = returnValue.to_json()
elapsedTime = time.monotonic() - startTime
logging.debug("temperature get by id 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_co2_get_newest():
logging.debug("Received request /historic/co2/newest")
startTime = time.monotonic()
try:
returnValue = HistoricCO2Model.get_newest()
if returnValue is None:
abort(404)
data = returnValue.to_json()
elapsedTime = time.monotonic() - startTime
logging.debug("co2 get newest 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 recent_temperatures_get_oldest():
logging.debug("Received request /recent/temperatures/oldest")
startTime = time.monotonic()
try:
returnValue = RecentTemperatureModel.get_oldest()
if returnValue is None:
abort(404)
data = returnValue.to_json()
elapsedTime = time.monotonic() - startTime
logging.debug("temperature get oldest request time: " +
str(round(elapsedTime, 5)) + " seconds")
return res(200, data=data, timeUTC=datetime.utcnow())
except mariadb.Error as e:
logging.exception(e)
abort(500, str(e))
def recent_pressures_reset():
logging.debug("Received request /recent/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)
RecentPressureModel.delete_all()
elapsedTime = time.monotonic() - startTime
logging.debug("pressures reset request time: " + str(round(elapsedTime,5))+ " seconds")
return res(204, timeUTC=datetime.utcnow())
except mariadb.Error as e:
abort(500, str(e))
def historic_sensors_reset():
logging.debug("Received request /historic/sensors/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)
HistoricSensorModel.delete_all()
elapsedTime = time.monotonic() - startTime
logging.debug("temperature reset request time: " +
str(round(elapsedTime, 5)) + " seconds")
return res(204, timeUTC=datetime.utcnow())
except mariadb.Error as e:
abort(500, str(e))
def humidity_get_average_in_range():
logging.debug("Received request /humidities/average/range")
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()
returnValue = HumidityModel.get_average_by_range(start,end)
data = HumidityModel.average_json(returnValue)
elapsedTime = time.monotonic() - startTime
logging.debug("humidity get average in range 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 sensors_get_by_search():
logging.debug("Received request /sensors/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()
sensor = SensorModel.get_by_search(start, end)
data = sensor.to_json_array()
elapsedTime = time.monotonic() - startTime
logging.debug("sensors get by id 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 humidity_get_by_search():
logging.debug("Received request /humidities/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 = []
humArray = HumidityModel.get_by_search(start,end)
for tempModel in humArray:
dataArray.append(tempModel.to_json())
elapsedTime = time.monotonic() - startTime
logging.debug("humidity get by search 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 pressure_get_average_in_range():
logging.debug("Received request /recent/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 = RecentPressureModel.get_average_by_range(start,end)
data = RecentPressureModel.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_sensors_get_average_in_range():
logging.debug("Received request /historic/sensors/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))
sensor = HistoricSensorModel.get_average_by_range(start, end)
data = sensor.to_average_json()
elapsedTime = time.monotonic() - startTime
logging.debug("sensors get by average range 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 handler_501(e):
logging.exception(e)
return res(501, error=str(e), time=datetime.utcnow())
def handler_405(e): return res(405, error=str(e), time=datetime.utcnow())
def handler_501(e): return res(501, error=str(e), time=datetime.utcnow())
def handler_default(e): traceback.print_exc() return res(500, error=str(e), time=datetime.utcnow())
def base_identity():
logging.debug("Received request /identity")
return res(200,
identifier="HelloSensorBox785179218796217896319",
timeUTC=datetime.utcnow())
def handler_default(e):
logging.exception(e)
traceback.print_exc()
return res(500, error=str(e), time=datetime.utcnow())
