class Phonebook: def __init__(self): self.database = Database("phonebook_database.db") self.database.create_table("phonebook", "(first_name, last_name, phone_number)") def print(self): self.database.print_table("phonebook") print() def add_entry(self): print("please enter your first name") first_name = input() print() print("please enter your last name") last_name = input() print() print("please enter your phone number") phone_number = input() print() self.database.add_record("phonebook", 3, [(first_name, last_name, phone_number)]) print("successfully created \n") def delete_entry(self): while True: print("Please enter the first name of the entry that you want to delete. Type exit to leave.\n") entry_to_delete = input() if self.database.check_exists("phonebook", entry_to_delete): self.database.delete_record("phonebook", "first_name", entry_to_delete) print("successfully deleted \n") break elif entry_to_delete == "exit": print() break else: print("that entry does not exist \n") def close(self): self.database.close()
user_info = user_login_database.check_exists("user_data_table", input()) print(user_info) if user_info: print("Please enter your password.") if input() == user_info[1]: print("Success!") else: print("incorrect password") else: print( "This username does not exist. Would you like to create a new account? [yes, no]" ) while True: create = input() if create in ["yes", "Yes"]: print("Please enter a new username.") new_username = input() print("Please enter a new password.") new_password = input() user_login_database.add_record("user_data_table", 2, [(new_username, new_password)]) break elif create in ["no", "No"]: break else: print("please type yes or no") user_login_database.close()