class teacherDAO:
def __init__(self):
self.db_object = DataBaseUtil()
def insert_teacher_details(self, studentDTO):
print("teacher DAO invoked")
print(studentDTO.stu_id, studentDTO.stu_name, studentDTO.stu_gender,
studentDTO.stu_dept, studentDTO.stu_contact,
studentDTO.stu_lib_id)
try:
sql_query = queries.insert_into_teacher % (
studentDTO.stu_id, studentDTO.stu_name, studentDTO.stu_gender,
studentDTO.stu_dept, studentDTO.stu_contact,
studentDTO.stu_lib_id)
self.db_object.execute_command(sql_query)
except Exception as e:
raise e
def show_teachers(self):
try:
sql_query = queries.show_all_teachers
rows = self.db_object.execute_command(sql_query)
except Exception as e:
print(e)
return rows
def __init__(self):
self.db_object = DataBaseUtil()
class BookDAO:
def __init__(self):
self.db_object = DataBaseUtil()
def insert_book_details(self, bookDTO):
db_connection = self.db_object.get_data_base_connection()
try:
sql_query = queries.insert_into_book % (
bookDTO.b_id, bookDTO.b_title, bookDTO.b_author,
bookDTO.b_type, bookDTO.b_dept)
print(sql_query)
cursor = db_connection.cursor()
cursor.execute(sql_query)
db_connection.commit()
except Exception as e:
raise e
finally:
self.db_object.close_data_base_connection(db_connection)
def delete_book_id(self, id):
try:
sql_query = queries.delete_book_record % id
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def show_books(self):
try:
sql_query = queries.show_all_books
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def show_book_id_stu(self, id):
try:
sql_query = queries.show_book_id_stu % (id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def show_book_id_teach(self, id):
try:
sql_query = queries.show_book_id_teach % (id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def book_check(self, id):
try:
sql_query = queries.get_book_id % (id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
class borrowDAO:
def __init__(self):
self.db_object = DataBaseUtil()
def insert_student__borrow_details(self, borrowDTO):
try:
sql_query = queries.insert_into_teacher_borrow % (
borrowDTO.sb_id, borrowDTO.sb_bid, borrowDTO.sb_date,
borrowDTO.sb_return)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
def insert_teacher__borrow_details(self, borrowDTO):
try:
sql_query = queries.insert_into_teacher_borrow % (
borrowDTO.sb_id, borrowDTO.sb_bid, borrowDTO.sb_date,
borrowDTO.sb_return)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
def stu_return_book(self, stu_id, id):
try:
sql_query = queries.return_book_stu % (stu_id, id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
def teach_return_book(self, stu_id, id):
try:
sql_query = queries.return_book_teach % (stu_id, id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
def stu_show_records(self, student_id):
try:
sql_query = queries.show_student_record % student_id
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def teach_show_records(self, student_id):
try:
sql_query = queries.show_teacher_record % student_id
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def get_book_status_stu(self, b_id):
try:
sql_query = queries.borrow_book_status_stu % (b_id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def get_book_type(self, b_id):
try:
sql_query = queries.borrow_book_type % (b_id)
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def get_book_status_teach(self, b_id):
try:
sql_query = queries.borrow_book_status_teach % b_id
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def get_stu_borrow_count(self, id):
try:
sql_query = queries.borrow_student_limit % id
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data
def get_teach_borrow_count(self, id):
try:
sql_query = queries.borrow_teacher_limit % id
data = self.db_object.execute_command(sql_query)
except Exception as e:
raise e
return data