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 lib_update_branch(self):
int_choice = int(self.choice) - 1
branches = (fetchProcedures.fetchBranchs())
str_branch = (''.join(branches[int_choice]))
self.id = fetchProcedures.fetchBranchIdByName(str_branch)
self.choice = input(
"Press 1) Update the details of the Library\nPress 2) Add copies of Book to the Branch\nPress 3) To Quit to Previous\n: "
)
if self.choice == "1":
print(
f'You have chosen to update the Branch with Branch Id: {self.id} and Branch Name: {str_branch}.'
)
new_branch_name = input(
f"Please Enter New Branch Name for {str_branch}\n or enter N/A for no change:"
)
if len(new_branch_name) > 0:
updateProcedures.updateBranchName(f"{self.id[0]}", f"{str_branch}",
new_branch_name)
else:
print('No Changes for Branch Name')
pass
new_address = input(
f'Please enter new branch address for {new_branch_name} or enter N/A for no change:\n'
)
if len(new_address) > 0:
updateProcedures.updateBranchAddress(f"{self.id[0]}", new_address)
self.home()
else:
print('No Changes for Branch Address')
elif self.choice == "2":
self.next()
else:
self.choice == "3"
self.prev()
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()
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':
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")