def log_email_sent(to_list):
logging.debug(to_list)
conn, cur = db_controller.db_access().open_connection()
cur.execute(
'INSERT INTO email_log (time_stamp, to_address) VALUES (%s, %s)',
(datetime.now(), str(to_list)))
db_controller.db_access.close_connection(conn, cur)
def failures_in_x_minutes_ago(last_x_minutes_of_failures):
""" Returns list of failures from variable"""
conn, cur = db_controller.db_access().open_connection()
query = '''SELECT * FROM server_stats WHERE time_stamp >= (now() - '{0} minute'::INTERVAL) ORDER BY time_stamp DESC;'''
cur.execute(query.format(last_x_minutes_of_failures))
data = cur.fetchall()
return data
def get_server_list():
""" Gets the entire monitor_list from db """
conn, cur = db_controller.db_access().open_connection()
get_all_query = '''SELECT * FROM monitor_list'''
cur.execute(get_all_query)
db_fetch = cur.fetchall()
db_controller.db_access.close_connection(conn, cur)
return db_fetch
def log_service_down(server_logger_obj):
""" Takes error and logs list to db with timestamp """
if server_logger_obj.sl_service_type == 'tcp': # Combine ip and port for logging
server_logger_obj.sl_host = server_logger_obj.sl_host + ':' + str(server_logger_obj.sl_port)
logging.info(server_logger_obj.sl_host + ' - ' + server_logger_obj.sl_service_type + ' is DOWN')
conn, cur = db_controller.db_access().open_connection()
cur.execute(
'INSERT INTO server_stats (time_stamp, ip_hostname, service_type) VALUES (%s, %s, %s)',
(datetime.now(), server_logger_obj.sl_host, server_logger_obj.sl_service_type))
db_controller.db_access.close_connection(conn, cur)
def get_time_from_last_failure():
""" Returns how many minutes ago there was a failure logged """
conn, cur = db_controller.db_access().open_connection()
cur.execute(
'SELECT time_stamp FROM server_stats ORDER BY time_stamp DESC LIMIT 1')
then = cur.fetchone()[0]
db_controller.db_access.close_connection(conn, cur)
now = datetime.now()
diff = (now - then)
day_seconds = diff.days * 24 * 60 * 60 # Converts diff.days into seconds
return float(day_seconds + diff.seconds) / 60 # Returns total diff in minutes
def email_sent_x_minutes_ago():
try:
conn, cur = db_controller.db_access().open_connection()
cur.execute(
'SELECT time_stamp FROM email_log ORDER BY time_stamp DESC LIMIT 1')
then = cur.fetchone()[0]
db_controller.db_access.close_connection(conn, cur)
now = datetime.now()
diff = (now - then)
day_seconds = diff.days * 24 * 60 * 60 # Converts diff.days into seconds
return float(day_seconds + diff.seconds) / 60 # Returns total diff in minutes
except TypeError:
return 9999
def remove_server_from_monitor_list(index_to_remove):
conn, cur = db_controller.db_access().open_connection()
cur.execute('DELETE FROM monitor_list WHERE index =' + index_to_remove)
db_controller.db_access.close_connection(conn, cur)
def create_server(web_url, note=None):
conn, cur = db_controller.db_access().open_connection()
cur.execute('INSERT INTO monitor_list (hostname, service_type, note) VALUES (%s, %s, %s)',
(web_url, 'url', note))
db_controller.db_access.close_connection(conn, cur)
def create_server(ip_address, port, note=None):
conn, cur = db_controller.db_access().open_connection()
cur.execute('INSERT INTO monitor_list (hostname, port, service_type, note) VALUES (%s, %s, %s, %s)',
(ip_address, port, 'tcp', note))
db_controller.db_access.close_connection(conn, cur)