def use_sql_databases(self):
"""
Ensure the necessary SQL database connections are alive and well
"""
if not utils.sql_conn_is_alive(self.sql_pc_conn):
self.sql_pc_conn = self.connect_to_sql(self.sql_pc_conn, "Person_Course", True)
if not utils.sql_conn_is_alive(self.sql_course_conn):
self.sql_course_conn = self.connect_to_sql(self.sql_course_conn, "", True)
def use_ecrm_database(self):
"""
Ensure the necessary SQL database connections are alive and well
"""
if not utils.sql_conn_is_alive(self.sql_ecrm_conn):
self.sql_ecrm_conn = self.connect_to_sql(self.sql_ecrm_conn, self.ecrm_db, True)
