def reset_offices_by_events(cls, cursor, event_ids: list): """Reset offices to what they were before the given event ids.""" # get address ids of offices that will be deleted addrs_to_delete = Address.get_addresses_by_event(cursor=cursor, event_ids=event_ids, table='office') # delete offices created on these events delete_from_table_by_event_ids(cursor=cursor, event_ids=event_ids, table='office') # delete addresses associated with directors that were deleted Address.delete(cursor=cursor, address_ids=addrs_to_delete) # reset offices ended on these events try: cursor.execute(f""" UPDATE office SET end_event_id = null WHERE end_event_id in ({stringify_list(event_ids)}) """) except Exception as err: current_app.logger.error( f'Error in Office: Failed reset ended offices for events {event_ids}' ) raise err
def reset_dirs_by_events(cls, cursor, event_ids: list): """Delete all parties created with given events and make all parties ended on given events active.""" # get address ids of parties that will be deleted addrs_to_delete = Address.get_addresses_by_event(cursor=cursor, event_ids=event_ids, table='corp_party') # delete parties created on these events delete_from_table_by_event_ids(cursor=cursor, event_ids=event_ids, table='corp_party') # delete parties created on these events delete_from_table_by_event_ids(cursor=cursor, event_ids=event_ids, table='completing_party', column='event_id') # delete addresses associated with parties that were deleted Address.delete(cursor=cursor, address_ids=addrs_to_delete) # reset parties ended on these events try: cursor.execute(f""" UPDATE corp_party SET end_event_id = null, cessation_dt = null WHERE end_event_id in ({stringify_list(event_ids)}) """) except Exception as err: current_app.logger.error( f'Error in corp_party: Failed to reset ended parties for events {event_ids}' ) raise err