class DatabaseHandler:
def __init__(self,database_name):
self.db = Database(database_name)
#function is for debug
def query(self, command):
return self.db.query(command)
def insert_error_msg(self, error_msg):
if error_msg == "":
print("<FAILED> in dbhandler:insert_error_msg() invalid in-parameters")
return "<FAILED>"
print("<OK> dbhandler:insert_error_msg")
return self.db.insert_error_msg(error_msg)
def insert_error_type(self, error_type):
if error_type == "":
print("<FAILED> in dbhandler:insert_error_type() invalid"
"in-parameters")
return "<FAILED>"
print("<OK> dbhandler:insert_error_type")
return self.db.insert_error_type(error_type)
def insert_error(self, msg_id, type_id):
# Implement validation
return self.insert_error(msg_id, type_id)
def get_error_msg_id(self,msg):
return self.db.get_msg_id(msg)
def get_error_type_id(self, type):
return self.db.get_type_id(type)
def insert(self, error_msg, error_type):
"""
insert to sql if not exists.
Connect error_msg and error_type in errors tabel if relation not already
exists
"""
msg_id = self.db.get_msg_id(error_msg)
if msg_id is None:
msg_id = self.db.insert_error_msg(error_msg)
type_id = self.db.get_type_id(error_type)
if type_id is None:
type_id = self.db.insert_error_type(error_type)
if type_id is not None and msg_id is not None:
self.db.insert_error(msg_id, type_id)
def find(self,error_msg):
"""
find error type by error message
"""
return self.db.find(error_msg)
def print_all_tables(self):
print(self.db.print_error_msg_table())
print(self.db.print_error_type_table())
print(self.db.print_error_table())
def print_msg_table(self):
return(self.db.print_error_msg_table())
def print_type_table(self):
return(self.db.print_error_type_table())
def print_error_table(self):
return(self.db.print_error_table())
def __init__(self,database_name):
self.db = Database(database_name)
