def retrieve_metrics_data_by_staff_id(cls, rqst_staff_id, list_of_ids, search_params, rqst_errors, fields=None): staff_instances = filter_db_queryset_by_id(picmodels.models.Navigators.objects.all(), rqst_staff_id, list_of_ids) response_list = create_metrics_response_list_from_filtered_staff_objects_and_secondary_params(staff_instances, search_params, fields) def check_response_data_for_requested_data(): missing_parameter_list = [] if not response_list: rqst_errors.append("No metrics entries found in database for given staff id(s).") if rqst_staff_id == 'all': missing_parameter_list = ['all'] else: missing_parameter_list = list_of_ids else: if list_of_ids: for db_id in list_of_ids: tuple_of_bools_if_id_in_data = (metrics_data_entry["Staff Information"]['id'] == db_id for metrics_data_entry in response_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append('Metrics for staff Member with id: {} not found in database'.format(db_id)) missing_parameter_list.append(db_id) return missing_parameter_list missing_primary_parameters = check_response_data_for_requested_data() return response_list, missing_primary_parameters
def retrieve_nav_hub_location_data_by_id(cls, validated_params, rqst_nav_hub_location_id, list_of_ids, rqst_errors): nav_hub_location_qset = prefetch_related_rows(cls.objects.all()) nav_hub_location_qset = filter_db_objects_by_secondary_params( nav_hub_location_qset, validated_params) nav_hub_location_qset = filter_db_queryset_by_id(nav_hub_location_qset, rqst_nav_hub_location_id, list_of_ids) response_list = create_response_list_from_db_objects(nav_hub_location_qset) def check_response_data_for_requested_data(): if not response_list: rqst_errors.append("No location entries found in database.") else: if list_of_ids: for db_id in list_of_ids: tuple_of_bools_if_id_in_data = ( instance_data['Database ID'] == db_id for instance_data in response_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append( 'Location entry with id: {} not found in database'. format(db_id)) check_response_data_for_requested_data() return response_list
def get_serialized_rows_by_id(cls, validated_params, rqst_errors): rqst_id = validated_params['id'] if rqst_id != 'all': list_of_ids = validated_params['id_list'] else: list_of_ids = None provider_network_qset = filter_db_queryset_by_id(cls.objects.all(), rqst_id, list_of_ids) response_list = create_response_list_from_db_objects(provider_network_qset) def check_response_data_for_requested_data(): if not response_list: rqst_errors.append( "No provider network instances in db for given ids.") else: if list_of_ids: for db_id in list_of_ids: tuple_of_bools_if_id_in_data = ( instance_data['Database ID'] == db_id for instance_data in response_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append( 'Provider network instance with id: {} not found in database.' .format(db_id)) check_response_data_for_requested_data() return response_list
def get_serialized_rows_by_id(cls, validated_params, rqst_errors): rqst_id = validated_params['id'] if rqst_id != 'all': list_of_ids = validated_params['id_list'] else: list_of_ids = None db_qset = prefetch_related_rows(cls.objects.all()) db_qset = filter_db_queryset_by_id(db_qset, rqst_id, list_of_ids) response_list = create_response_list_from_db_objects(db_qset) def check_response_data_for_requested_data(): if not response_list: rqst_errors.append("No rows found in database.") else: if list_of_ids: for db_id in list_of_ids: tuple_of_bools_if_id_in_data = ( instance_data['id'] == db_id for instance_data in response_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append( 'db row with id: {} not found in database'.format( db_id)) check_response_data_for_requested_data() return response_list
def retrieve_healthcare_subsidy_eligibility_data_by_id( cls, rqst_healthcare_subsidy_eligibility_data_id, list_of_ids, rqst_errors): healthcare_subsidy_eligibility_data_objs = filter_db_queryset_by_id( cls.objects.all(), rqst_healthcare_subsidy_eligibility_data_id, list_of_ids) response_list = create_response_list_from_db_objects( healthcare_subsidy_eligibility_data_objs) def check_response_data_for_requested_data(): if not response_list: rqst_errors.append( "No healthcare subsidy eligibility data instances in db for given ids" ) else: if list_of_ids: for healthcare_subsidy_eligibility_data_id in list_of_ids: tuple_of_bools_if_id_in_data = ( instance_data['Database ID'] == healthcare_subsidy_eligibility_data_id for instance_data in response_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append( 'Healthcare subsidy eligibility data instance with id: {} not found in database' .format(healthcare_subsidy_eligibility_data_id)) check_response_data_for_requested_data() return response_list
def get_serialized_rows_by_id(cls, validated_params, rqst_errors): rqst_id = validated_params['id'] if rqst_id != 'all': list_of_ids = validated_params['id_list'] else: list_of_ids = None filtered_qset = prefetch_related_rows(cls.objects.all()) filtered_qset = filter_db_queryset_by_id(filtered_qset, rqst_id, list_of_ids) table_data_list = create_table_data_list_from_qset(filtered_qset) def check_response_data_for_requested_data(): if not table_data_list: rqst_errors.append( "No rows in NavOrgsFromOnlineForm table were found for given ids" ) else: if list_of_ids: for db_id in list_of_ids: tuple_of_bools_if_id_in_data = ( instance_data['id'] == db_id for instance_data in table_data_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append( 'No row in cNavOrgsFromOnlineForm table was found with id: {}' .format(db_id)) check_response_data_for_requested_data() return table_data_list
def retrieve_general_concerns_by_id(cls, rqst_general_concerns_id, list_of_ids, rqst_errors): general_concerns = filter_db_queryset_by_id(cls.objects.all(), rqst_general_concerns_id, list_of_ids) response_list = create_response_list_from_db_objects(general_concerns) def check_response_data_for_requested_data(): if not response_list: rqst_errors.append( "No general concern instances in db for given ids") else: if list_of_ids: for db_id in list_of_ids: tuple_of_bools_if_id_in_data = ( instance_data['Database ID'] == db_id for instance_data in response_list) if not any(tuple_of_bools_if_id_in_data): rqst_errors.append( 'General concern instance with id: {} not found in database' .format(db_id)) check_response_data_for_requested_data() return response_list