def issue_book(mem_name, book_acn): issue = setu.cursor() print("@issue book:") print(book_acn) print() status = is_book_available(book_acn) print(status) if status: mem_id = get_memid(mem_name) print(mem_id) if mem_id == -1: print('member dont exists') return -1 # wrong member id else: query = "insert into borrows (issue_date, issue_time, issuers_member_id, book_accession_number) values(CURDATE(), CURTIME(), %s, %s)" query2 = "update books set is_available = 0 where accession_number=\'" + book_acn + "\';" val = (mem_id, book_acn) #exceptions issue.execute(query, val) setu.commit() issue.execute(query2) setu.commit() print("Book issued") else: return -2
def return_book(mem_id, acn, return_date, remark): tray = setu.cursor() #validation of parameters mem_status = does_member_exist(mem_id) book_issued = is_book_issued(acn) query = "UPDATE borrows SET return_date = %s, remarks = %s where issuers_id = %s and accession_number = %s;" values = (return_date, remark, mem_id, acn) query1 = "UPDATE books SET is_available = 1 where accession_number = \'" + acn + "\'" if mem_status and book_issued: try: tray.execute(query, values) tray.execute(query1) except ms.IntegrityError as err: print("Intergrity Error: " + str(err)) except ms.Error as err: print("Other Error: " + str(err)) if (tray.rowcount == 1): setu.commit() print(str(tray.rowcount) + " Book Returned") return True elif (tray.rowcount == -1): print("Error ala re") else: print("Jast books returned zhale wattat " + str(tray.rowcount)) else: if mem_status == False: return -1 elif book_issued == False: return -2
def add_new_member(m_type, m_mno, email_id, m_fullname): add = setu.cursor() query = "INSERT into members(member_type,mobile_number,email_id,full_name) values(%s,%s,%s,%s)" val = (m_type, m_mno, email_id, m_fullname) add.execute(query, val) setu.commit() print(add.rowcount, " Member record inserted")
def return_book(mem_id, book_acn, remarks=""): wapas = setu.cursor() query = "update borrows set return_date = CURDATE(), return_time=CURTIME(), remarks=%s where issuers_member_id=%s and book_accession_number=%s;" val = (remarks, mem_id, book_acn) wapas.execute(query, val) setu.commit() print(wapas) print(wapas.fetchall) print("Book returned")
def add_new_member(mtype, mmno, emailid, fname): add = setu.cursor() query = "insert into members(member_type, mobile_number ,email_id, full_name ) values(%s,%s,%s,%s)" val = (mtype.upper(), mmno, emailid, fname.upper()) try: add.execute(query, val) setu.commit() except ms.IntegrityError as err: return err print(add.rowcount, " Members added into Database") return 1
def add_new_member(m_type, m_mno, email_id, m_fullname): add = setu.cursor() query = "INSERT into members(member_type,mobile_number,email_id,full_name) values(%s,%s,%s,%s)" val = (m_type, m_mno, email_id, m_fullname) try: add.execute(query, val) setu.commit() except ms.IntegrityError as er: return er print(add.rowcount, " Member record inserted") return 1
def add_new_book(acn, title, price, author, publisher): add = setu.cursor() query = "INSERT INTO books(accession_number, title, price, author, publisher) values(%s,%s,%s,%s,%s)" val = (acn, title, price, author, publisher) try: add.execute(query, val) except ms.IntegrityError as err: err_msg = "Error: {}".format(err) return err_msg setu.commit() print(str(add.rowcount) + " Book added Successfully") return 0
def delete_member_by_id(mid): nsht = setu.cursor() query = "delete from members where member_id = " + str(mid) + ";" try: nsht.execute(query) setu.commit() except db.Error as err: print(err) print(str(nsht.rowcount) + " member deleted Successfully") if nsht.rowcount == 0: return -1 elif nsht.rowcount == 1: return 1 else: return nsht.rowcount
def delete_book(acn): delete = setu.cursor() query = "delete from books where accession_number = \'" + str(acn) + "\'" try: delete.execute(query) except db.Error as err: print(err) return err setu.commit() print(str(delete.rowcount) + " Books Deleted Successfully") if delete.rowcount == 0: return -1 elif delete.rowcount == 1: return 1 else: return delete.rowcount
def insert_new_book(acn, title, shelf_no, price, author, publisher): add = setu.cursor() query = "INSERT INTO books(accession_number, title, shelf_no, price, authors, publisher, is_available) values(%s,%s,%s,%s,%s,%s,%s)" val = (acn, title, shelf_no, price, author, publisher, '1') try: add.execute(query, val) except db.Error as err: print(format(err)) return err except db.IntegrityError as err: err = "Error: {}".format(err) return err setu.commit() print(str(add.rowcount) + " Book added Successfully") return True
def issue_book(mem_id, acn, issue_date): tray = setu.cursor() #validation of parameters mem_status = does_member_exist(mem_id) # book_status = is_book_available( acn ) # if returns -1 pop error " wrong accession no." (book exists check is implicit) if mem_status and book_status: #print(acn + " " + mem_id) #print(issue_date) query = "INSERT into borrows(issue_date, issuers_id, accession_number) values(%s, %s, %s)" query1 = "UPDATE books set is_available = 0 where accession_number=\'" + str( acn) + "\'" values = (issue_date, mem_id, acn) try: tray.execute(query, values) tray.execute(query1) except ms.IntegrityError as err: print("Intergrity Error: " + str(err)) except ms.Error as err: print("Other Error: " + str(err)) print(str(tray.statement)) if (tray.rowcount == 1): setu.commit() print(str(tray.rowcount) + " Book issues") return True elif (tray.rowcount == -1): print("Error ala re") return False else: print("Jast books issue zhale wattat " + str(tray.rowcount)) return False else: if mem_status == False: return -1 elif book_status == False: return -2
def delete_book(accn_no): delete = setu.cursor() query = "DELETE from books where accession_number=\'"+accn_no+"\'" print(query) delete.execute(query) setu.commit()