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))
