def question_three(self):
books = fetchProcedures.fetchBooksByBranchId(self.store["branchId"])
books = string_utils.build_input_options(self, books)
self.choice = input("Which book would you like to check out?\n" + books)
self.store["bookId"] = self.grabId()
# INSERT NEW BOOK_LOAN (cardNo, bookId)
self.next()
def update_book(self):
books = fetchProcedures.fetchBooks()
books = string_utils.build_input_options(self, books)
self.choice = input("Which book do you want to update?\n" + books)
self.store["bookId"] = self.grabId()
self.store["new_title"] = input("What do you want the new title to be?\n")
publishers = fetchProcedures.fetchPublishers()
publishers = string_utils.build_input_options(self, publishers)
self.choice = input("Who should the new publisher be?\n")
self.store["new_pub_id"] = self.grabId()
# UPDATE BOOK BY ID (bookId, new_title, new_pub_id)
updateProcedures.updateBookInfo(self.store["bookId"],
self.store["new_title"],
self.store["new_pub_id"])
def question_two(self):
branches=fetchProcedures.fetchBranchs()
branches = string_utils.build_input_options(self, branches)
branch = input("Which branch do you want to check out from?\n" + branches)
self.choice = branch
self.store["branchId"] = self.grabId()
self.next()
def delete_book(self):
books = fetchProcedures.fetchBooks()
books = string_utils.build_input_options(self, books)
self.choice = input("Which book do you want to delete?\n" + books)
self.store["bookId"] = self.grabId()
# DELETE BOOK BY ID
deleteProcedures.deleteBook(self.store["bookId"])
def delete_author(self):
authors = fetchProcedures.fetchAuthors()
authors = string_utils.build_input_options(self, authors)
self.choice = input("Which author would you like to delete?\n" + authors)
self.store["authorId"] = self.grabId()
# DELETE AUTHOR BY ID (authorId)
deleteProcedures.deleteAuthor(self.store["authorId"])
def question_one(self):
books = fetchProcedures.fetchBooksByBorrowerId(self.store['cardNo'])
books = string_utils.build_input_options(self, books)
self.choice = input("Which book would you like to return?\n" + books)
self.store["bookId"] = self.grabId()
# DELETE BOOK_LOAN (cardNo, bookId)
self.next()
def lib_question_one(self):
res = (fetchProcedures.fetchBranchs())
out = string_utils.build_input_options(res)
self.choice = input("Select Branch Number or q to quit to previous:\n" +
out)
if self.choice == "q":
self.home()
else:
self.next()
def delete_publisher(self):
publishers = fetchProcedures.fetchPublishers()
publishers = string_utils.build_input_options(self, publishers)
self.choice = input("Which publisher would you like to delete?\n" + publishers)
self.store["pubId"] = self.grabId()
# DELETE PUBLISHER BY ID HERE
deleteProcedures.deletePublisher(self.store["pubId"])
print("Deleted publisher")
def update_library(self):
libraries = fetchProcedures.fetchLibraries()
libraries = string_utils.build_input_options(self, libraries)
self.choice = input("Which library would you like to update?\n" +
libraries)
self.store["branchId"] = self.grabId()
self.store["branchName"] = input("What is the new name of your borrower\n")
self.store["branchAddress"] = input(
"What's the new address of your borrower\n")
def update_borrower(self):
borrowers = fetchProcedures.fetchBorrowers()
borrowers = string_utils.build_input_options(self, borrowers)
self.choice = input("Which borrower would you like to update?\n" +
borrowers)
self.store["borrowerId"] = self.grabId()
self.store["name"] = input("What is the new name of your borrower\n")
self.store["address"] = input("What's the new address of your borrower\n")
self.store["phone"] = input(
"Lastly, what is the new phone number of your borrower\n")
def add_book(self):
self.store["title"] = input(
"What is the title of the book you want to add?\n")
publishers = fetchProcedures.fetchPublishers()
publishers = string_utils.build_input_options(self, publishers)
self.choice = input("And who published this book?\n" + publishers)
self.store["publisherId"] = self.grabId()
# CREATE NEW BOOK WITH PUBLISHER
addProcedures.addBook(self.store["title"], self.store["publisherId"])
def update_author(self):
authors = fetchProcedures.fetchAuthors()
authors = string_utils.build_input_options(self, authors)
self.choice = input("Which author would you like to update?\n" + authors)
self.store["authorId"] = self.grabId()
self.store["authorName"] = input(
"What would you like to change the author's name to?\n")
# UPDATE AUTHOR BY ID (authorId, authorName)
updateProcedures.updateAuthorInfo(self.store["authorId"],
self.store["authorName"])
def start(self):
self.store["cardNo"] = input(
"Enter the borrower Card Number you want to update the due date for?\n"
)
books = fetchProcedures.fetchBooksByBorrowerId(self.store["cardNo"])
books = string_utils.build_input_options(self, books)
self.choice = input(
"Which book do you want to update the due date for?\n" + books)
self.store["bookId"] = self.grabId()
self.store["dueDate"] = input(
"Input the desired dueDate (In DATETIME format)\n")
def update_publisher(self):
publishers = fetchProcedures.fetchPublishers()
publishers = string_utils.build_input_options(self, publishers)
self.choice = input("Which publisher would you like to update?\n" + publishers)
self.store["pubId"] = self.grabId()
self.store["name"] = input("What is the name of the publisher you wish to add?\n")
self.store["address"] = input("What is the address of this publisher?")
self.store["phone"] = input("What is the phone number of this publisher?")
# UPDATE PUBLISHER (name, address, phone)
updateProcedures.updatePublisherInfo(self.store["pubId"],self.store["name"],self.store["address"],self.store["phone"])
print("Updated publisher")
def delete_borrower(self):
borrowers = fetchProcedures.fetchBorrowers()
borrowers = string_utils.build_input_options(self, borrowers)
self.choice = input("Which borrower would you like to delete?\n" +
borrowers)
self.store["borrowerId"] = self.grabId()
ans = input(
"1) Add/Update/Delete Book\n2) Add/Update/Delete Author\n")
if ans == "quit":
break
elif int(ans) == 1:
while True:
ans = input(
"1) Add Book\n2) Update Book\n3) Delete Book\n")
if ans == "quit":
break
elif int(ans) == 1:
bookName = input("Enter the book name\n")
if bookName == 'quit':
break
pubList = fetchProcedures.w_fetchPublishers()
pubs = string_utils.build_input_options(pubList)
pubChoice = input(
pubs +
"Which publisher do you want to add to the book? \n"
)
if pubChoice == 'quit':
break
pubChoiceName = (''.join(pubList[int(pubChoice) - 1]))
pubId = fetchProcedures.fetchPubIdByName(pubChoiceName)
addProcedures.addBook(bookName, pubId[0])
print("Added book")
break
elif int(ans) == 2:
bookList = fetchProcedures.w_fetchBooks()
books = string_utils.build_input_options(bookList)
bookChoice = input(
def delete_library(self):
libraries = fetchProcedures.fetchLibraries()
libraries = string_utils.build_input_options(self, libraries)
self.choice = input("Which library would you like to delete?\n" +
libraries)
self.store["branchId"] = self.grabId()
def main():
while True:
updateProcedures.mydb.commit()
fetchProcedures.mydb.commit()
deleteProcedures.mydb.commit()
ans = input(
"1) Add/Update/Delete Book and Author\n2) Add/Update/Delete Publishers\n3) Add/Update/Delete Library Branches\n4) Add/Update/Delete Borrowers\n5) Over-ride Due Date for a Book loan\n"
)
if ans == "quit":
print("end")
break
#Author and book DONE
elif int(ans) == 1:
#Book and author loop
while True:
fetchProcedures.mydb.commit()
deleteProcedures.mydb.commit()
updateProcedures.mydb.commit()
ans = input(
"1) Add/Update/Delete Book\n2) Add/Update/Delete Author\n")
if ans == "quit":
break
elif int(ans) == 1:
while True:
ans = input(
"1) Add Book\n2) Update Book\n3) Delete Book\n")
if ans == "quit":
break
elif int(ans) == 1:
bookName = input("Enter the book name\n")
if bookName == 'quit':
break
pubList = fetchProcedures.w_fetchPublishers()
pubs = string_utils.build_input_options(pubList)
pubChoice = input(
pubs +
"Which publisher do you want to add to the book? \n"
)
if pubChoice == 'quit':
break
pubChoiceName = (''.join(pubList[int(pubChoice) -
1]))
pubId = fetchProcedures.fetchPubIdByName(
pubChoiceName)
addProcedures.addBook(bookName, pubId[0])
print("Added book")
break
elif int(ans) == 2:
bookList = fetchProcedures.w_fetchBooks()
books = string_utils.build_input_options(bookList)
bookChoice = input(
books + "Which book do you want to update?\n")
if bookChoice == 'quit':
break
bookChoiceName = (''.join(
bookList[int(bookChoice) - 1]))
bookId = fetchProcedures.fetchBookIdByBookName(
bookChoiceName)
newBookName = input(
"Enter the new book name for " +
bookChoiceName + "\n")
if newBookName == 'quit':
break
pubList = fetchProcedures.w_fetchPublishers()
pubs = string_utils.build_input_options(pubList)
pubChoice = input(
pubs +
"Which publisher do you want to add to the book? \n"
)
if pubChoice == 'quit':
break
pubChoiceName = (''.join(pubList[int(pubChoice) -
1]))
pubId = fetchProcedures.fetchPubIdByName(
pubChoiceName)
updateProcedures.updateBookInfo(
bookId[0], newBookName, pubId[0])
print("Updated book")
break
elif int(ans) == 3:
bookList = fetchProcedures.w_fetchBooks()
books = string_utils.build_input_options(bookList)
bookChoice = input(
books + "Which book do you want to delete?\n")
if bookChoice == 'quit':
break
bookChoiceName = (''.join(
bookList[int(bookChoice) - 1]))
bookId = fetchProcedures.fetchBookIdByBookName(
bookChoiceName)
deleteProcedures.deleteBook(bookId[0])
print("Book deleted")
break
else:
print("Invalid input type 'quit' to go back")
elif int(ans) == 2:
while True:
ans = input(
"1) Add Author\n2) Update Author\n3) Delete Author\n"
)
if ans == "quit":
break
elif int(ans) == 1:
authorName = input(
"Enter the name of the author?\n")
if authorName == 'quit':
break
addProcedures.addAuthor(authorName)
print("Added Author")
break
elif int(ans) == 2:
authorList = fetchProcedures.w_fetchAuthors()
authors = string_utils.build_input_options(
authorList)
authorChoice = input(
authors +
"Which author do you want to update?\n")
if authorChoice == 'quit':
break
authorChoiceName = (''.join(
authorList[int(authorChoice) - 1]))
print(authorChoiceName)
authorId = fetchProcedures.fetchAuthorIdByName(
authorChoiceName)
newName = input("What is the author's new name?\n")
if newName == 'quit':
break
updateProcedures.updateAuthorInfo(
authorId[0], newName)
print("Updated Author")
break
elif int(ans) == 3:
authorList = fetchProcedures.w_fetchAuthors()
authors = string_utils.build_input_options(
authorList)
authorChoice = input(
authors +
"Which author do you want to delete?\n")
if authorChoice == 'quit':
break
authorChoiceName = (''.join(
authorList[int(authorChoice) - 1]))
print(authorChoiceName)
authorId = fetchProcedures.fetchAuthorIdByName(
authorChoiceName)
deleteProcedures.deleteAuthor(authorId[0])
print("Author deleted")
break
else:
print("Invalid Input type 'quit' to go back")
else:
print("Invalid input type 'quit' to go back")
#publisher DONE
elif int(ans) == 2:
while True:
ans = input(
"1) Add publisher\n2) Update Publisher\n3) Delete Publisher\n"
)
if ans == "quit":
break
elif int(ans) == 1:
pubName = input("Enter the new publishers name?\n")
if pubName == 'quit':
break
pubAddress = input("Enter the new publisher: " + pubName +
" address\n")
if pubAddress == 'quit':
break
pubPhoneNumber = input("Enter " + pubName +
"'s phone number\n")
if pubPhoneNumber == 'quit':
break
addProcedures.addPublisher(pubName, pubAddress,
pubPhoneNumber)
print("Added publisher")
break
elif int(ans) == 2:
pubList = fetchProcedures.w_fetchPublishers()
pubs = string_utils.build_input_options(pubList)
pubChoice = input(
pubs + "Which publisher do you want to update? \n")
if pubChoice == 'quit':
break
newPubName = input("Enter new publisher name\n")
if newPubName == 'quit':
break
newPubAddress = input("Enter the new address for " +
newPubName + ":\n")
if newPubAddress == 'quit':
break
newPubPhone = input("Enter the new phone number for " +
newPubName + ":\n")
if newPubPhone == 'quit':
break
pubChoiceName = (''.join(pubList[int(pubChoice) - 1]))
pubId = fetchProcedures.fetchPubIdByName(pubChoiceName)
updateProcedures.updatePublisherInfo(
pubId[0], newPubName, newPubAddress, newPubPhone)
print("Updated publisher")
break
elif int(ans) == 3:
pubList = fetchProcedures.w_fetchPublishers()
pubs = string_utils.build_input_options(pubList)
pubChoice = input(
pubs + "Which publisher do you want to delete? \n")
if pubChoice == 'quit':
break
pubChoiceName = (''.join(pubList[int(pubChoice) - 1]))
pubId = fetchProcedures.fetchPubIdByName(pubChoiceName)
deleteProcedures.deletePublisher(pubId[0])
print("Publisher deleted")
break
else:
print("Invalid input type 'quit' to go back")
#library branch DONE
elif int(ans) == 3:
while True:
ans = input(
"1) Add Library Branch\n2) Update Library Branch\n3) Delete Library Branch\n"
)
if ans == "quit":
break
elif int(ans) == 1:
newBranchName = input(
"What do you want to call this new branch?\n")
if newBranchName == 'quit':
break
newBranchAddress = input(
"What is the address for the new branch " +
newBranchName + "?\n")
if newBranchAddress == 'quit':
break
addProcedures.addBranch(newBranchName, newBranchAddress)
print("Adding Library Branch")
break
elif int(ans) == 2:
branchList = fetchProcedures.fetchBranchs()
branches = string_utils.build_input_options(branchList)
branchChoice = input(
branches + "Which branch do you want to update?\n")
if branchChoice == 'quit':
break
branchChoiceName = (''.join(branchList[int(branchChoice) -
1]))
branchId = fetchProcedures.fetchBranchIdByName(
branchChoiceName)
newBranchName = input("What is the new branch name?\n")
if newBranchName == 'quit':
break
else:
newBranchAddress = input(
"What is the new address for " + newBranchName +
"?\n")
if newBranchAddress == 'quit':
break
else:
updateProcedures.updateBranchInfo(
newBranchName, newBranchAddress, branchId[0])
print("library branch updated")
break
elif int(ans) == 3:
branchList = fetchProcedures.fetchBranchs()
branches = string_utils.build_input_options(branchList)
branchChoice = input(
branches + "Which branch do you want to delete?\n")
if branchChoice == 'quit':
break
branchChoiceName = (''.join(branchList[int(branchChoice) -
1]))
branchId = fetchProcedures.fetchBranchIdByName(
branchChoiceName)
deleteProcedures.deleteBranch(branchId[0])
print("Deleting Library Branch")
break
else:
print("Invalid input type 'quit' to go back")
#borrowers DONE
elif int(ans) == 4:
while True:
ans = input(
"1) Add Borrower\n2) Update Borrower\n3) Delete Borrower\n"
)
if ans == "quit":
break
elif int(ans) == 1:
borrowerName = input("Enter borrowers name.\n")
borrowerAddress = input("enter " + borrowerName +
" address.\n")
borrowerPhone = input("enter " + borrowerName +
" phone numbner.\n")
addProcedures.addBorrower(borrowerName, borrowerAddress,
borrowerPhone)
print("Adding Borrower")
break
elif int(ans) == 2:
borrowerList = fetchProcedures.fetchBorrowers()
borrowers = string_utils.build_input_options(borrowerList)
borrowerChoice = input(
borrowers +
" Enter borrower card # you want to update?\n")
bNewName = input("Enter the borrowers new name.\n")
if bNewName == 'quit':
break
bNewAddress = input("Enter " + bNewName +
" new address.\n")
if bNewAddress == 'quit':
break
bNewPhone = input("Enter " + bNewName +
" new phone number. \n")
if bNewPhone == 'quit':
break
updateProcedures.updateBorrowerInfo(
borrowerChoice, bNewName, bNewAddress, bNewPhone)
print("Updating Borrower")
break
elif int(ans) == 3:
borrowerList = fetchProcedures.fetchBorrowers()
borrowers = string_utils.build_input_options(borrowerList)
borrowerChoice = input(
borrowers +
" Enter borrower card # you want to delete?\n")
deleteProcedures.deleteBorrower(borrowerChoice)
print("Deleting Borrower")
break
else:
print("Invalid input type 'quit' to go back")
#override due date for a boook
elif int(ans) == 5:
while True:
cardNumList = fetchProcedures.fetchBorrowers()
cardNums = string_utils.build_input_options(cardNumList)
cardNumChoice = input(
cardNums +
"Enter the borrower Card Number you want to update the due date for?\n"
)
if cardNumChoice == 'quit':
break
else:
#Insert fetching all borrowed book from the card number
bookList = fetchProcedures.fetchBorrowerBooks(
cardNumChoice)
books = string_utils.build_input_options(bookList)
bookChoice = input(
books +
"Which book do you want to update the due date for?\n")
if bookChoice == 'quit':
break
#choices
dueMonth = input("Enter the new due date month.\n")
dueDay = input("Enter the new day for due date.\n")
dueYear = input("Enter the new year for the due date.\n")
#insert update due date procedure here.
break
print("Updating due date")
break
else:
print("Invalid input type 'quit' to go back")
