def clean_shutdown():
cfuncs.write_to_log(lg, "Cleanly closing the Database")
if Global_db_cursor is not None:
Global_db_cursor.close()
if Global_db_conn is not None:
Global_db_conn.close()
network_status(False)
expected_sensor_count(False)
safe_to_unplug(True)
cfuncs.write_to_log(lg, "Finished....")
sys.exit(0)
def create_temp_readings_table(db_cursor):
cfuncs.write_to_log(lg, " Creating table for temperature readings")
sql = """CREATE TABLE TEMP_READINGS (
temp_id INT NOT NULL AUTO_INCREMENT,
date_added DATETIME NOT NULL,
temp_sensor_db_id INT,
temperature FLOAT NOT NULL,
PRIMARY KEY (temp_id) )"""
if db_cursor.execute(sql):
return None
else:
return 0
def dump_all_db_data_out(db_cursor):
query = "SELECT * FROM temps.TEMP_READINGS"
db_cursor.execute(query)
cfuncs.write_to_log(lg,
"Current database contents for TEMP_READINGS......")
for row in db_cursor.fetchall():
id = str(row[0])
date = str(row[1])
temp_sensor_db_id = str(row[2])
temp_sensor_id = str(row[2])
temp = str(row[4])
write_to_log(id + " " + date + " " + temp_sensor_db_id + " " +
temp_sensor_id + " " + temp)
def create_sensors_table(db_conn, db_cursor):
cfuncs.write_to_log(lg, " Creating table for temperature sensors")
sql = """CREATE TABLE TEMP_SENSORS (
sensor_id INT NOT NULL AUTO_INCREMENT,
date_added DATETIME NOT NULL,
temp_sensor_id CHAR(15) NOT NULL,
temp_sensor_alias VARCHAR(50),
temp_offset FLOAT NOT NULL,
connected BOOLEAN NOT NULL,
PRIMARY KEY (sensor_id) )"""
db_cursor.execute(sql)
sql = """INSERT INTO TEMP_SENSORS (date_added, temp_sensor_id, temp_sensor_alias, temp_offset, connected)
VALUES (NOW(), '28-020691770d70', 'Ambient 0d70', 0, 0),
(NOW(), '28-020b917749e4', 'Monitor 49e4', -0.7, 0),
(NOW(), '28-02069177144d', 'Wired 144d', -0.8, 0),
(NOW(), '28-0118679408ff', 'Bare 08ff', -0.7, 0),
(NOW(), '28-020a9177f3c4', 'Raspberry PI f3c4', -1.1, 0),
(NOW(), '28-020891777a83', 'Wired 7a83', -0.7, 0),
(NOW(), '28-0118677269ff', 'Bare 09ff', -0.9, 0)"""
try:
db_cursor.execute(sql)
db_conn.commit()
cfuncs.write_to_log(lg, " TEMP_SENSORS table created and updated OK")
except:
db_conn.rollback()
cfuncs.write_to_log(lg, " TEMP_SENSORS table update failed!!")
return None
return 0
def reset_sensor_connected_status(db_conn, db_cursor):
cfuncs.write_to_log(lg, ">> reset_sensor_connected_status()")
try:
update_sql = "UPDATE temps.TEMP_SENSORS SET connected = 0 WHERE sensor_id > 0"
db_cursor.execute(update_sql)
db_conn.commit()
cfuncs.write_to_log(lg, " reset sensor connected status for all OK")
except:
db_conn.rollback()
cfuncs.write_to_log(
lg, " reset sensor connected status update failed!!")
# do something else here!?!?!?!
return None
return 0
cfuncs.write_to_log(lg, "<< reset_sensor_connected_status()")
return id, temp_offset
def write_temp_reading_to_db(db_conn, db_cursor, db_sensor_id, temp_reading):
cfuncs.write_to_log(lg, ">> write_temp_reading_to_db()")
temp_reading = round(temp_reading, 1)
sql = "INSERT INTO TEMP_READINGS (date_added, temp_sensor_db_id, temperature) VALUES (NOW(), '" + str(
db_sensor_id) + "', " + str(temp_reading) + ")"
try:
db_cursor.execute(sql)
#print(db_cursor.execute(sql))
db_conn.commit()
cfuncs.write_to_log(
lg,
" Temp including offset - " + str(temp_reading) + " added OK")
except:
db_conn.rollback()
cfuncs.write_to_log(lg, " Temp reading add failed!!")
cfuncs.write_to_log(lg, "<< write_temp_reading_to_db()")
def delete_sensors_table(db_conn, db_cursor):
cfuncs.write_to_log(lg, " Deleting all entries in the sensors table")
sql = "DROP TABLE TEMP_SENSORS"
try:
db_cursor.execute(sql)
db_conn.commit()
cfuncs.write_to_log(lg, " TEMP_SENSORS table deleted OK")
return 0
except:
db_conn.rollback()
cfuncs.write_to_log(lg, " TEMP_SENSORS table delete failed!!")
return None
def check_settings_for_defaults_and_updates(db_conn, db_cursor):
cfuncs.write_to_log(lg, ">> check_settings_for_defaults_and_updates()")
settings = [('sensor_polling_freq', '10'), ('write_to_logfile', 'True'),
('start_up_email_address', 'not_set'),
('start_up_status_email', 'True'),
('webpage_autorefresh_time', '5'),
('first_read_settle_time', '10'),
('temp_reading_max_age', '2'),
('line_chart_line_thickness', '2'),
('user_period_line_chart', '8')]
no_of_settings = len(settings)
settings_added = 0
settings_existing = 0
for setting in settings:
setting, value = setting
query = "SELECT name FROM temps.TEMP_APP_SETTINGS WHERE name = '" + setting + "'"
db_cursor.execute(query)
if db_cursor.rowcount == 0:
insert_sql = "INSERT INTO TEMP_APP_SETTINGS (name, value, last_updated) VALUES ('" + setting + "', '" + value + "', NOW())"
try:
db_cursor.execute(insert_sql)
db_conn.commit()
cfuncs.write_to_log(
lg,
" ADDED: Setting: " + setting + " Value: " + value)
settings_added += 1
except:
db_conn.rollback()
cfuncs.write_to_log(
lg, " TEMP_APP_SETTINGS table update failed!!")
return None, None
else:
settings_existing += 1
#cfuncs.write_to_log(lg, " EXISTS: Setting: " + setting + " Value: " + value)
cfuncs.write_to_log(lg, "<< check_settings_for_defaults_and_updates()")
return settings_existing, settings_added
def create_settings_table(db_conn, db_cursor):
cfuncs.write_to_log(lg, " Creating table for settings")
sql = """CREATE TABLE TEMP_APP_SETTINGS (
settings_id INT NOT NULL AUTO_INCREMENT,
name CHAR(50) NOT NULL,
value CHAR(50) NOT NULL,
last_updated DATETIME NOT NULL,
PRIMARY KEY (settings_id) )"""
try:
db_cursor.execute(sql)
db_conn.commit()
cfuncs.write_to_log(lg, " TEMP_APP_SETTINGS table created OK")
except:
db_conn.rollback()
cfuncs.write_to_log(lg, " TEMP_APP_SETTINGS table creation failed!!")
return None
return 0
def status():
sensor_aliases = None
no_sensors = 0
public_ip = None
record_count = 0
ssid, quality, level = cfuncs.check_wireless_network_connection(lg)
if (level <= -100):
level_perc = 0
elif (level >= -50):
level_perc = 100
else:
level_perc = 2 * (level + 100)
quality_perc = 2 * (quality + 100)
all_sensors_list = cfuncs.find_all_temp_sensors_connected(lg)
if all_sensors_list is not None:
no_sensors = str(len(all_sensors_list))
db_conn = cfuncs.setup_db_connection(lg, "localhost", "temps",
"temps_user", "user")
if db_conn is None:
cfuncs.write_to_log(lg, "ERROR - DB connection failed!")
clean_shutdown()
else:
cfuncs.write_to_log(lg, " DB connection OK")
cursor = db_conn.cursor()
sensor_aliases = []
for sensor_id in all_sensors_list:
db_id, temp_sensor_alias, temp_offset = cfuncs.find_temp_sensor_id_alias_and_offset(
lg, db_conn, cursor, sensor_id, False)
sensor_aliases.append(temp_sensor_alias)
record_count = cfuncs.get_total_temp_reading_records_count_from_db(
lg, cursor)
cursor.close()
db_conn.close()
all_sensor_info = list(zip(all_sensors_list, sensor_aliases))
else:
all_sensor_info = None
now = datetime.datetime.now()
date_and_time = str(now.day) + "/" + str(now.month).zfill(2) + "/" + str(
now.year) + " " + str(now.hour).zfill(2) + ":" + str(
now.minute).zfill(2) + ":" + str(now.second).zfill(2)
ip_address = cfuncs.get_local_ip_address("web")
public_ip = cfuncs.get_public_ip(lg)
vstring = cfuncs.app_version()
os, architecture, oskernel, firmwareversion, uptime = cfuncs.get_system_information(
)
cputemp = cfuncs.get_cpu_temp(lg)
total_capacity, free_space, disk_used = cfuncs.get_filesystem_stats(lg)
logs_directory_size = cfuncs.get_size_of_directory(
lg, '/home/steve/temperature_monitoring/logs')
log_file_size = cfuncs.get_size_of_file(
lg, '/home/steve/temperature_monitoring/log.txt')
return render_template('status.html',
version=vstring,
page_heading='System Information',
title='Sys Info',
os=os,
architecture=architecture,
oskernel=oskernel,
uptime=uptime,
cputemp=cputemp,
firmwareversion=firmwareversion,
hostname=socket.gethostname(),
disk_capacity=total_capacity,
disk_used=disk_used,
disk_free_space=free_space,
logs_size=logs_directory_size,
log_file=log_file_size,
total_records=record_count,
ip=ip_address,
publicip=public_ip,
ssid=ssid,
quality=str(quality),
level_perc=str(level_perc),
level=str(level),
no_sensors=no_sensors,
sensors_list=all_sensor_info)
def signal_handler(sig, frame):
cfuncs.write_to_log(lg, "\n")
cfuncs.write_to_log(
lg, "*********** Received Signal " + str(sig) + " shutting down\n")
clean_shutdown()
def do_main():
global Global_db_conn
global Global_db_cursor
global Global_dict
global send_start_up_status_email
setup_gpio()
os.system('clear')
last_change_string = read_last_change_file_and_remove()
clean_old_log_file()
cfuncs.write_to_log(
lg, "\n\n************ Started - all_temps_to_DB.py ************\n")
safe_to_unplug(True)
all_sensors_list = None
cfuncs.write_to_log(
lg,
"------------------------ Checking Network Connection is OK ------------------------"
)
ssid, quality, level = cfuncs.check_wireless_network_connection(lg)
if ssid != '':
network_status(True)
else:
network_status(False)
ip_address = cfuncs.get_local_ip_address(lg)
cfuncs.write_to_log(
lg,
"------------------------ IS Database Connection OK? -----------------------"
)
db_conn_max_retries = 5
db_conn_count = 0
while True:
db_conn = cfuncs.setup_db_connection(lg, "localhost", database_name,
database_user_name,
database_password)
if db_conn is None:
cfuncs.write_to_log(lg, "ERROR - DB connection failed!")
if db_conn_count < db_conn_max_retries:
db_conn_count += 1
time.sleep(3)
cfuncs.write_to_log(
lg, " Trying the DB connect again(" +
str(db_conn_count) + ")")
continue
else:
clean_shutdown()
else:
cfuncs.write_to_log(lg, " DB connection OK")
break
cursor = db_conn.cursor()
Global_db_conn = db_conn
Global_db_cursor = cursor
#Setup a Query
#query = "SELECT * FROM test.temps WHERE date_of_reading < STR_TO_DATE('24/12/2018 17:00', '%d/%m/%Y %H:%i') "
safe_to_unplug(False)
manage_settings_db_and_dict_stuff(db_conn, cursor)
Global_dict = cfuncs.settings_db_to_dictionary(lg, cursor)
result = cfuncs.check_table_exists(lg, cursor, "TEMP_READINGS")
if result is None:
cfuncs.write_to_log(lg, "*** NO TEMP_READINGS Table")
if create_temp_readings_table(cursor) is None:
clean_shutdown()
else:
cfuncs.write_to_log(lg, " OK - TEMP_READINGS table exists")
result = cfuncs.check_table_exists(lg, cursor, "TEMP_SENSORS")
if result is None:
cfuncs.write_to_log(lg, "*** NO TEMP_SENSORS Table")
if create_sensors_table(db_conn, cursor) is None:
clean_shutdown()
else:
cfuncs.write_to_log(lg, " OK - TEMP_SENSORS table exists")
cfuncs.write_to_log(
lg,
"------------------- Finished DB connection and setup all OK -------------------"
)
safe_to_unplug(True)
result = reset_sensor_connected_status(db_conn, cursor)
if result is None:
cfuncs.write_to_log(lg,
"ERROR - sensor connection status reset failed!")
if create_sensors_table(db_conn, cursor) is None:
clean_shutdown()
while all_sensors_list is None:
all_sensors_list = cfuncs.find_all_temp_sensors_connected(lg)
if all_sensors_list is None:
cfuncs.write_to_log(lg, "***Waiting 5 seconds before trying again")
time.sleep(5)
no_of_sensors = len(all_sensors_list)
if no_of_sensors == 3:
expected_sensor_count(True)
else:
expected_sensor_count(False)
if Global_dict['start_up_email_address'] != "not_set":
email_recipient_addr = Global_dict['start_up_email_address']
cfuncs.write_to_log(
lg, " Startup email address from settings DB: " +
email_recipient_addr)
else:
email_recipient_addr = gbl_email_recipient_addr
cfuncs.write_to_log(
lg, " Startup email address from preset file: " +
email_recipient_addr)
send_start_up_status_email = Global_dict['start_up_status_email']
#Override for start emails!
#send_start_up_status_email = "True"
if email_user is not None and email_passwd is not None and email_recipient_addr is not None:
if send_start_up_status_email == "True":
if last_change_string is None:
last_change_string = "User restart or other unplanned restart"
email_title = "PI Temperature Monitoring System (" + socket.gethostname(
) + "): Reset/Power Up Alert"
send_startup_email(email_user, email_passwd,
gbl_email_recipient_addr,
gbl_email_recipient_addr, email_title,
last_change_string, ssid, quality, level,
all_sensors_list, ip_address)
else:
cfuncs.write_to_log(
lg,
"*************************** Email credentials not all present, check env variable in /etc/environment!"
)
cfuncs.write_to_log(lg, "Email user: "******"Email passwd: " + str(email_passwd))
cfuncs.write_to_log(lg,
"Email recipient: " + str(email_recipient_addr))
settle_time = int(Global_dict['first_read_settle_time'])
cfuncs.write_to_log(
lg, "Waiting %d seconds for the initial readings" % settle_time)
time.sleep(settle_time)
while True:
cfuncs.clear_old_temp_readings(lg, Global_dict['temp_reading_max_age'])
all_sensors_list = cfuncs.find_all_temp_sensors_connected(lg)
no_of_sensors = len(all_sensors_list)
if no_of_sensors == 3:
expected_sensor_count(True)
else:
expected_sensor_count(False)
for sensor_name in all_sensors_list:
db_sensor_id, alias, offset = cfuncs.find_temp_sensor_id_alias_and_offset(
lg, db_conn, cursor, sensor_name, True)
cfuncs.write_to_log(
lg, " DB Sensor ID: " + str(db_sensor_id) +
" Temp Offset: " + str(offset))
safe_to_unplug(False)
if db_sensor_id is not None:
temperature = cfuncs.read_temp(lg, sensor_name)
if temperature is not None:
write_temp_reading_to_db(db_conn, cursor, db_sensor_id,
(temperature + offset))
else:
cfuncs.write_to_log(
lg,
"***Unable to obtain temperature reading! Return from call was None"
)
else:
cfuncs.write_to_log(
lg, "***No info for sensor " + sensor_name +
", ignoring! Temp is " + str(read_temp(sensor_name)))
loop_time = int(Global_dict['sensor_polling_freq'])
cfuncs.write_to_log(
lg,
"The next reading will be taken in " + str(loop_time) + " minutes")
safe_to_unplug(True)
net_checking_count = 10
net_checking_loop_time = ((loop_time * 60) / net_checking_count)
for count in range(0, net_checking_count):
cfuncs.write_to_log(
lg, "In network monitor loop(" + str(count) +
") before resampling temps again")
ssid, quality, level = cfuncs.check_wireless_network_connection(lg)
if ssid != '':
network_status(True)
else:
network_status(False)
Global_dict = cfuncs.settings_db_to_dictionary(lg, cursor)
new_loop_time = int(Global_dict['sensor_polling_freq'])
if loop_time != new_loop_time:
cfuncs.write_to_log(
lg,
"sensor_polling_freq - changed from " + str(loop_time) +
"mins, to " + str(new_loop_time) + "mins.....")
break
time.sleep(net_checking_loop_time) # Time in seconds
cfuncs.write_to_log(lg, "Exited network monitor loop.....")
def send_startup_email(user, pwd, send_to, sent_from, subject,
last_change_string, ssid, quality, level,
all_sensors_list, ip_address):
cfuncs.write_to_log(lg, ">> send_startup_email()")
print("New email sender, to:" + send_to + " from:" + sent_from)
time.sleep(1)
# Create message container - the correct MIME type is multipart/alternative.
msg = MIMEMultipart('mixed')
msg['Subject'] = subject
msg['From'] = sent_from
msg['To'] = send_to
if (level <= -100):
level_perc = 0
elif (level >= -50):
level_perc = 100
else:
level_perc = 2 * (level + 100)
html = """\
<html>
<head>
<style>
table, th, td { border: 1px solid black; border-collapse: collapse; }
th, td { padding: 5px; }
</style>
</head>
<body>
<h2><font color="darkblue">Last reset reason:<font> <font color="green">""" + last_change_string + """<font></h2>
<h2><font color="darkblue">System status<font></h2>
<table>
<tr>
<td><b>Connected WiFi network</b></td>
<td>""" + ssid + """</td>
</tr>
<tr>
<td><b>WiFi signal Quality</b></td>
<td>""" + str(quality) + """%</td>
</tr>
<tr>
<td><b>Strength</td>
<td>""" + str(level_perc) + """% (""" + str(
level) + """dBm)</b></td>
<tr>
<td><b>Initial startup and checking of DB</b></td>
<td>OK</td>
</tr>
<tr>
<td><b>Temperature Sensors detected</td>
<td>""" + str(len(all_sensors_list)) + """</b></td>
</tr>
</table>
<br>
<h3>Pi Temperature Monitoring System home page address: http://""" + ip_address + """/home</h3>
<h3>Bugs and enhancement suggestions can be raised <a href=\"https://github.com/drawevets/temperature_monitoring/issues\">here</a></h3>
</body>
</html>"""
msg.attach(MIMEText(html, 'html'))
# Send the message via local SMTP server.
try:
server = smtplib.SMTP("smtp.gmail.com", 587)
status = server.ehlo()
cfuncs.write_to_log(lg, " ehlo: " + str(status))
status = server.starttls()
cfuncs.write_to_log(lg, " starttls: " + str(status))
status = server.login(user, pwd)
cfuncs.write_to_log(lg, " user login: "******" email sent OK")
except:
cfuncs.write_to_log(lg, "****** failed to send email!!")
cfuncs.write_to_log(lg, "<< send_startup_email()")
def send_email(user, pwd, recipient, subject, body):
cfuncs.write_to_log(lg, ">> send_email()")
FROM = user
TO = recipient if isinstance(recipient, list) else [recipient]
SUBJECT = subject
TEXT = body
# Prepare actual message
message = "From: %s\nTo: %s\nSubject: %s\n\n%s" % (FROM, ", ".join(TO),
SUBJECT, TEXT)
try:
server = smtplib.SMTP("smtp.gmail.com", 587)
status = server.ehlo()
cfuncs.write_to_log(lg, " ehlo: " + str(status))
status = server.starttls()
cfuncs.write_to_log(lg, " starttls: " + str(status))
status = server.login(user, pwd)
cfuncs.write_to_log(lg, " user login: "******" email sent OK")
except:
cfuncs.write_to_log(lg, "****** failed to send email!!")
cfuncs.write_to_log(lg, "<< send_email()")
def SensorDisplayNameUpdate():
form = SensorDisplayNameForm(request.form)
#print(form.errors)
if request.method == 'POST':
new_name1 = request.form['new_name1'].strip()
new_name2 = request.form['new_name2'].strip()
new_name3 = request.form['new_name3'].strip()
if new_name1 != "" or new_name2 != "" or new_name3 != "":
if form.validate():
cfuncs.write_to_log(lg, " Form validated OK")
all_sensors_uid_list = cfuncs.find_all_temp_sensors_connected(
lg)
newnames = [new_name1, new_name2, new_name3]
#print(newnames)
#print(all_sensors_uid_list)
all_sensor_name_info = list(zip(all_sensors_uid_list,
newnames))
#print(all_sensor_name_info)
for sensor_uid, new_name in all_sensor_name_info:
print("looking at: " + sensor_uid + " new_name: " +
new_name)
if new_name != "":
#print("sensor_uid + " " new_name - updating name in DB!")
cfuncs.update_sensor_display_name(
lg, sensor_uid, new_name)
return redirect(url_for('home'))
else:
print("Form NOT validated OK")
return redirect(url_for('SensorDisplayNameUpdate'))
else:
all_sensors_list = cfuncs.find_all_temp_sensors_connected(lg)
if all_sensors_list is not None:
no_sensors = str(len(all_sensors_list))
db_conn = cfuncs.setup_db_connection(lg, "localhost", "temps",
"temps_user", "user")
if db_conn is None:
cfuncs.write_to_log(lg, "ERROR - DB connection failed!")
clean_shutdown()
else:
cfuncs.write_to_log(lg, " DB connection OK")
cursor = db_conn.cursor()
sensor_aliases = []
for sensor_id in all_sensors_list:
db_id, temp_sensor_alias, temp_offset = cfuncs.find_temp_sensor_id_alias_and_offset(
lg, db_conn, cursor, sensor_id, False)
sensor_aliases.append(temp_sensor_alias)
cursor.close()
db_conn.close()
all_sensor_info = list(zip(all_sensors_list, sensor_aliases))
vstring = cfuncs.app_version()
return render_template('sensor_display_name_update.html',
form=form,
version=vstring,
sensors_ids=all_sensors_list,
sensor_aliases=sensor_aliases)
def manage_settings_db_and_dict_stuff(db_conn, db_cursor):
cfuncs.write_to_log(lg, ">> manage_settings_db_stuff()")
result = cfuncs.check_table_exists(lg, db_cursor, "TEMP_APP_SETTINGS")
if result is None:
cfuncs.write_to_log(lg, "*** NO TEMP_APP_SETTINGS Table")
if create_settings_table(db_conn, db_cursor) is None:
clean_shutdown()
else:
cfuncs.write_to_log(lg, " OK - TEMP_APP_SETTINGS table exists")
existing, added = check_settings_for_defaults_and_updates(
db_conn, db_cursor)
if existing is None:
clean_shutdown()
else:
cfuncs.write_to_log(
lg, " " + str(existing) + " settings already existed")
cfuncs.write_to_log(lg, " " + str(added) + " settings added")
#global Global_dict
#Global_dict = cfuncs.settings_db_to_dictionary(lg, db_cursor)
cfuncs.write_to_log(lg, "<< manage_settings_db_stuff()")
return None
def utils():
form = SettingsUpdateForm(request.form)
setting_name = []
setting_value = []
#print(form.errors)
db_conn = cfuncs.setup_db_connection(lg, "localhost", "temps",
"temps_user", "user")
if db_conn is None:
cfuncs.write_to_log(lg, "ERROR - DB connection failed!")
clean_shutdown()
else:
cfuncs.write_to_log(lg, " DB connection OK")
cursor = db_conn.cursor()
settings_dict = cfuncs.settings_db_to_dictionary(lg, cursor)
setting_name.append('sensor_polling_freq')
setting_name.append('write_to_logfile')
setting_name.append('start_up_email_address')
setting_name.append('start_up_status_email')
setting_name.append('webpage_autorefresh_time')
setting_name.append('first_read_settle_time')
setting_name.append('temp_reading_max_age')
setting_name.append('line_chart_line_thickness')
setting_name.append('user_period_line_chart')
setting_value.append(settings_dict['sensor_polling_freq'])
setting_value.append(settings_dict['write_to_logfile'])
if settings_dict['start_up_email_address'] == 'not_set':
setting_value.append("Internal Default")
else:
setting_value.append(settings_dict['start_up_email_address'])
setting_value.append(settings_dict['start_up_status_email'])
setting_value.append(settings_dict['webpage_autorefresh_time'])
setting_value.append(settings_dict['first_read_settle_time'])
setting_value.append(settings_dict['temp_reading_max_age'])
setting_value.append(settings_dict['line_chart_line_thickness'])
setting_value.append(settings_dict['user_period_line_chart'])
cursor.close()
db_conn.close()
if request.method == 'POST':
sensor_polling_freq = request.form['new_value0']
write_to_logfile = str(form.new_value1.data)
start_up_email_address = str(form.new_value2.data).strip()
start_up_status_email = str(form.new_value3.data)
webpage_autorefresh_time = request.form['new_value4'].strip()
first_read_settle_time = request.form['new_value5']
temp_reading_max_age = request.form['new_value6']
line_chart_line_thickness = request.form['new_value7']
user_period_line_chart = request.form['new_value8']
if form.validate():
cfuncs.write_to_log(lg, " Form validated OK")
if sensor_polling_freq != '':
cfuncs.update_setting(lg, 'sensor_polling_freq',
sensor_polling_freq)
if write_to_logfile != settings_dict['write_to_logfile']:
cfuncs.update_setting(lg, 'write_to_logfile', write_to_logfile)
if start_up_email_address != '':
cfuncs.update_setting(lg, 'start_up_email_address',
start_up_email_address)
if start_up_status_email != settings_dict['start_up_status_email']:
cfuncs.update_setting(lg, 'start_up_status_email',
start_up_status_email)
if webpage_autorefresh_time != '':
cfuncs.update_setting(lg, 'webpage_autorefresh_time',
webpage_autorefresh_time)
if first_read_settle_time != '':
cfuncs.update_setting(lg, 'first_read_settle_time',
first_read_settle_time)
if temp_reading_max_age != '':
cfuncs.update_setting(lg, 'temp_reading_max_age',
temp_reading_max_age)
if line_chart_line_thickness != '':
cfuncs.update_setting(lg, 'line_chart_line_thickness',
line_chart_line_thickness)
if user_period_line_chart != '':
cfuncs.update_setting(lg, 'user_period_line_chart',
user_period_line_chart)
else:
print("Form NOT validated OK")
return redirect(url_for('utils'))
else:
if setting_value[1] == "True":
temp1 = True
else:
temp1 = False
if setting_value[3] == "True":
temp3 = True
else:
temp3 = False
vstring = cfuncs.app_version()
return render_template('utils.html',
form=form,
page_heading='System Utils',
version=vstring,
title="Utils",
setting_name=setting_name,
setting_value=setting_value,
tmp1=temp1,
tmp3=temp3)
