def delete_donor(cursor): while True: try: cursor.execute("SELECT UniqueId FROM Donor;") data = cursor.fetchall() ids = [i[0] for i in data] print(ids, "(0) Cancel") user_input = input("Enter donor's ID or passport number: ").upper() if user_input == '0': clear() break elif not Validate.validate_id(user_input): print("\n\tWrong ID or Passport number, enter a real value") time.sleep(2) clear() continue elif user_input not in ids: print("\n\tID is valid, but there is no entry with this ID yet.") time.sleep(2) clear() continue else: print("Deleting entry...") cursor.execute("DELETE FROM Donor WHERE UniqueId = '{}';".format(user_input)) time.sleep(1) print("Done!") input() clear() break except Exception as e: print(e) print("\n\t! ! ! Belso Error ! ! ! ") input() clear()
def delete_donor(): while True: try: with open("Data/donors.csv", "r") as f: content = [] for line in f: content.append(line.strip()) ids = [ content[i].split(',')[6] for i in range(len(content)) if i != 0 ] print(ids, "(0) Cancel") user_input = input( "Enter donor's ID or passport number: ").upper() if user_input == '0': clear() break elif not Validate.validate_id(user_input): print( "\n\tWrong ID or Passport number, enter a real value") time.sleep(2) clear() continue elif user_input not in ids: print( "\n\tID is valid, but there is no entry with this ID yet." ) time.sleep(2) clear() continue else: print("Deleting entry...") with open("Data/donors.csv", "w") as f: for line in content: if user_input != line.split(",")[6]: f.write(line + "\n") time.sleep(1) print("Done!") input() clear() break except Exception as e: print(e) print("\n\t! ! ! Belso Error ! ! ! ") input() clear()
def delete_donor(cursor): while True: try: cursor.execute("SELECT UniqueId FROM Donor;") data = cursor.fetchall() ids = [i[0] for i in data] print(ids, "(0) Cancel") user_input = input( "Enter donor's ID or passport number: ").upper() if user_input == '0': clear() break elif not Validate.validate_id(user_input): print( "\n\tWrong ID or Passport number, enter a real value") time.sleep(2) clear() continue elif user_input not in ids: print( "\n\tID is valid, but there is no entry with this ID yet." ) time.sleep(2) clear() continue else: print("Deleting entry...") cursor.execute( "DELETE FROM Donor WHERE UniqueId = '{}';".format( user_input)) time.sleep(1) print("Done!") input() clear() break except Exception as e: print(e) print("\n\t! ! ! Belso Error ! ! ! ") input() clear()
def delete_donor(): while True: try: with open("Data/donors.csv", "r") as f: content = [] for line in f: content.append(line.strip()) ids = [content[i].split(",")[6] for i in range(len(content)) if i != 0] print(ids, "(0) Cancel") user_input = input("Enter donor's ID or passport number: ").upper() if user_input == "0": clear() break elif not Validate.validate_id(user_input): print("\n\tWrong ID or Passport number, enter a real value") time.sleep(2) clear() continue elif user_input not in ids: print("\n\tID is valid, but there is no entry with this ID yet.") time.sleep(2) clear() continue else: print("Deleting entry...") with open("Data/donors.csv", "w") as f: for line in content: if user_input != line.split(",")[6]: f.write(line + "\n") time.sleep(1) print("Done!") input() clear() break except Exception as e: print(e) print("\n\t! ! ! Belso Error ! ! ! ") input() clear()
elif user_input == MENU_ITEM_7: user_input = "" while user_input == "": user_input = input("(0) Cancel\nType ID number: ") user_input = user_input.upper() clear() if user_input == '0': break elif user_input.isdigit(): if connect_decider: EventManagerDB.change_event(user_input, cursor) connection.commit() else: EventManagerCSV.change_event(user_input) actv_selection = 0 elif Validate.validate_id(user_input): if connect_decider: DonorManagerDB.change_donor_data(user_input,cursor) connection.commit() else: DonorManager.change_donor_data(user_input) actv_selection = 0 else: print(ID_ERR + "\n\t\t\t\tor\n" + POSINT_ERR) time.sleep(3) clear() user_input = "" # # EXIT # elif user_input == MENU_ITEM_8:
def test_nothing(self): self.assertFalse(Validate.validate_id(""))