def get_by_search(start, end):
# Init
returnValue = []
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute(
'Select * from tbl_historic_pressure where fld_start_time>=? and fld_end_time<=?',
(
start,
end,
))
# Formatting of return data
logging.debug("Formatting query data to objects")
for id, start, end, value in cur:
temp = HistoricPressureModel(id, start, end, value)
returnValue.append(temp)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_average_by_range(start, end):
# Init
returnValue = None
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute(
'Select AVG(fld_average) from tbl_historic_pressure where fld_start_time>=? and fld_end_time<=?',
(
start,
end,
))
# Formatting of return data
logging.debug("Formatting query data to objects")
for c in cur:
returnValue = c[0] # Average
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def delete_all():
# Init
returnValue = True
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting delete")
cur.execute("Delete from tbl_historic_pressure")
logging.debug("Committing changes")
conn.commit()
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def delete_by_range(start,end):
# Init
returnValue = True
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting delete")
cur.execute('Delete from tbl_historic_humidity where fld_start_time>=? and fld_end_time<=?', (start,end,))
logging.debug("Committing changes")
conn.commit()
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_by_id(id):
# Init
returnValue = None
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select * from tbl_historic_humidity where fld_pk_id=?', (id,))
# Formatting of return data
logging.debug("Formatting query data to objects")
for id,start, end, value in cur:
returnValue = HistoricHumidityModel(id, start, end, value)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_newest():
# Init
returnValue = None
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select * from tbl_historic_humidity order by fld_end_time desc limit 1')
# Formatting of return data
logging.debug("Formatting query data to objects")
for id,start, end, value in cur:
returnValue = HistoricHumidityModel(id,start, end, value)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_average():
# Init
returnValue = None
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select AVG(fld_average) from tbl_historic_humidity')
# Formatting of return data
logging.debug("Formatting query data to objects")
for c in cur:
returnValue = c[0] #Average
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_newest():
# Init
returnValue = None
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select * from tbl_recent_pressure order by fld_time desc limit 1')
# Formatting of return data
logging.debug("Formatting query data to objects")
for id, time, value in cur:
returnValue = RecentPressureModel(id, time, value)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_by_id(id):
# Init
returnValue = None
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select * from tbl_recent_pressure where fld_pk_id=?', (id,))
# Formatting of return data
logging.debug("Formatting query data to objects")
for id, time, value in cur:
returnValue = RecentPressureModel(id, time, value)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_all():
# Init
returnValue = []
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select * from tbl_historic_humidity')
# Formatting of return data
logging.debug("Formatting query data to objects")
for id, start, end, value in cur:
temp = HistoricHumidityModel(id,start, end, value)
returnValue.append(temp)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def get_all():
# Init
returnValue = []
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting select")
cur.execute('Select * from tbl_recent_temperature')
# Formatting of return data
logging.debug("Formatting query data to objects")
for id, time, value in cur:
temp = RecentTemperatureModel(id, time, value)
returnValue.append(temp)
# Clean and return
logging.debug("Closing connection")
conn.close()
return returnValue
def post(self):
# Init
conn = ConnectionService.get_connection()
cur = conn.cursor()
# Execution
logging.debug("Starting insert")
cur.execute(
'Insert into tbl_recent_pressure(fld_time,fld_value) values (UTC_TIMESTAMP(),?)', (self.value,))
logging.debug("Committing changes")
conn.commit()
# Update this Object with
self.id = cur.lastrowid
self.time = RecentPressureModel.get_by_id(self.id).time
logging.debug("Generated item has id: " + str(self.id))
# Clean and return
logging.debug("Closing connection")
conn.close()
return self.id
