def guest_removed(member_of_parliament, guest_to_remove, date): if guest_to_remove is not None: print("\n-- Parlamentarier_in '{}' hat die Zutrittsberechtigung von Gast '{}' mit Funktion '{}' beendet.".format( name_logic.fullname(member_of_parliament), name_logic.fullname(guest_to_remove), guest_to_remove["function"])) print(create_queries.end_zutrittsberechtigung(guest_to_remove["zutrittsberechtigung_id"], date))
def guest_removed(member_of_parliament, guest_to_remove, date): if guest_to_remove is not None: print("\n-- Parlamentarier_in '{}' hat die Zutrittsberechtigung von Gast '{}' mit Funktion '{}' beendet.".format( name_logic.fullname(member_of_parliament), name_logic.fullname(guest_to_remove), guest_to_remove["function"])) print(sql_statement_generator.end_zutrittsberechtigung(guest_to_remove["zutrittsberechtigung_id"], date))
def guest_remained(member_of_parliament, existing_guest, new_guest, date): funktion_equal = funktion_logic.are_functions_equal(existing_guest["function"], new_guest["function"]) if not funktion_equal: print("\n-- Parlamentarier_in '{}' hat beim Gast '{}' die Funktion von '{}' auf '{}' geändert.".format( name_logic.fullname(member_of_parliament), name_logic.fullname(existing_guest), existing_guest["function"], new_guest["function"])) print(create_queries.update_function_of_zutrittsberechtigung(existing_guest["zutrittsberechtigung_id"], new_guest["function"], date)) return funktion_equal
def guest_remained(member_of_parliament, existing_guest, new_guest, date): funktion_equal = funktion_logic.are_functions_equal(existing_guest["function"], new_guest["function"]) if not funktion_equal: print("\n-- Parlamentarier_in '{}' hat beim Gast '{}' die Funktion von '{}' auf '{}' geändert.".format( name_logic.fullname(member_of_parliament), name_logic.fullname(existing_guest), existing_guest["function"], new_guest["function"])) print(sql_statement_generator.update_function_of_zutrittsberechtigung(existing_guest["zutrittsberechtigung_id"], new_guest["function"], date)) return funktion_equal
def guest_added(conn, member_of_parliament, guest_to_add, date): if guest_to_add is not None: print("\n-- Parlamentarier_in '{}' hat einen neuen Gast '{}' mit Funktion '{}'.".format( name_logic.fullname(member_of_parliament), name_logic.fullname(guest_to_add), guest_to_add["function"])) # check if the new guest is already a person in the database, if not create them person_id = db.get_person_id(conn, guest_to_add["names"]) if not person_id: print("-- Diese_r muss neu in der Datenbank erzeugt werden") print(create_queries.insert_person(guest_to_add, date)) else: guest_to_add["id"] = person_id print(create_queries.insert_zutrittsberechtigung(member_of_parliament["id"], person_id, guest_to_add["function"], date))
def guest_added(conn, member_of_parliament, guest_to_add, date): if guest_to_add is not None: print("\n-- Parlamentarier_in '{}' hat einen neuen Gast '{}' mit Funktion '{}'.".format( name_logic.fullname(member_of_parliament), name_logic.fullname(guest_to_add), guest_to_add["function"])) # check if the new guest is already a person in the database, if not create them person_id = db.get_person_id(conn, guest_to_add["names"]) if not person_id: print("-- Diese_r muss neu in der Datenbank erzeugt werden") print(sql_statement_generator.insert_person(guest_to_add, date)) else: guest_to_add["id"] = person_id print(sql_statement_generator.insert_zutrittsberechtigung(member_of_parliament["id"], person_id, guest_to_add["function"], date))