def list(self, request, *args, **kwargs): fields = request.GET.get("fields") query = request.GET.get("query", {}) sort = request.GET.get("sort") start = parse_int(request.GET.get("start")) limit = parse_int(request.GET.get("limit")) export_type = kwargs.get('format', request.GET.get("format")) lookup_field = self.lookup_field lookup = self.kwargs.get(lookup_field) is_public_request = lookup == self.public_data_endpoint if lookup_field not in list(kwargs): self.object_list = self.filter_queryset(self.get_queryset()) serializer = self.get_serializer(self.object_list, many=True) return Response(serializer.data) if is_public_request: self.object_list = self._get_public_forms_queryset() elif lookup: qs = self.filter_queryset(self.get_queryset()).values_list( 'pk', 'is_merged_dataset') xform_id, is_merged_dataset = qs[0] if qs else (lookup, False) pks = [xform_id] if is_merged_dataset: merged_form = MergedXForm.objects.get(pk=xform_id) qs = merged_form.xforms.filter( deleted_at__isnull=True).values_list( 'id', 'num_of_submissions') try: pks, num_of_submissions = [ list(value) for value in zip(*qs) ] num_of_submissions = sum(num_of_submissions) except ValueError: pks, num_of_submissions = [], 0 else: num_of_submissions = XForm.objects.get( id=xform_id).num_of_submissions self.object_list = Instance.objects.filter( xform_id__in=pks, deleted_at=None).only('json') # Enable ordering for XForms with Submissions that are less # than the SUBMISSION_RETRIEVAL_THRESHOLD if num_of_submissions < SUBMISSION_RETRIEVAL_THRESHOLD: self.object_list = self.object_list.order_by('id') xform = self.get_object() self.object_list = \ filter_queryset_xform_meta_perms(xform, request.user, self.object_list) tags = self.request.query_params.get('tags') not_tagged = self.request.query_params.get('not_tagged') self.object_list = filters.InstanceFilter( self.request.query_params, queryset=self.object_list, request=request).qs if tags and isinstance(tags, six.string_types): tags = tags.split(',') self.object_list = self.object_list.filter(tags__name__in=tags) if not_tagged and isinstance(not_tagged, six.string_types): not_tagged = not_tagged.split(',') self.object_list = \ self.object_list.exclude(tags__name__in=not_tagged) if ( export_type is None or export_type in ['json', 'jsonp', 'debug', 'xml']) \ and hasattr(self, 'object_list'): return self._get_data(query, fields, sort, start, limit, is_public_request) xform = self.get_object() kwargs = {'instance__xform': xform} if export_type == Attachment.OSM: if request.GET: self.set_object_list(query, fields, sort, start, limit, is_public_request) kwargs = {'instance__in': self.object_list} osm_list = OsmData.objects.filter(**kwargs).order_by('instance') page = self.paginate_queryset(osm_list) serializer = self.get_serializer(page) return Response(serializer.data) elif export_type is None or export_type in ['json']: # perform default viewset retrieve, no data export return super(DataViewSet, self).list(request, *args, **kwargs) elif export_type == 'geojson': serializer = self.get_serializer(self.object_list, many=True) return Response(serializer.data) return custom_response_handler(request, xform, query, export_type)
def list(self, request, *args, **kwargs): fields = request.GET.get("fields") query = request.GET.get("query", {}) sort = request.GET.get("sort") start = parse_int(request.GET.get("start")) limit = parse_int(request.GET.get("limit")) export_type = kwargs.get('format', request.GET.get("format")) lookup_field = self.lookup_field lookup = self.kwargs.get(lookup_field) is_public_request = lookup == self.public_data_endpoint if lookup_field not in kwargs.keys(): self.object_list = self.filter_queryset(self.get_queryset()) serializer = self.get_serializer(self.object_list, many=True) return Response(serializer.data) if is_public_request: self.object_list = self._get_public_forms_queryset() elif lookup: qs = self.filter_queryset(self.get_queryset()).values_list( 'pk', 'is_merged_dataset') xform_id, is_merged_dataset = qs[0] if qs else (lookup, False) pks = [xform_id] if is_merged_dataset: xforms = MergedXForm.objects.filter( pk=xform_id, xforms__deleted_at__isnull=True)\ .values_list('xforms', flat=True) pks = [pk for pk in xforms if pk] or [xform_id] self.object_list = Instance.objects.filter( xform_id__in=pks, deleted_at=None).only('json').order_by('id') xform = self.get_object() self.object_list = \ filter_queryset_xform_meta_perms(xform, request.user, self.object_list) tags = self.request.query_params.get('tags') not_tagged = self.request.query_params.get('not_tagged') self.object_list = filters.InstanceFilter( self.request.query_params, queryset=self.object_list, request=request).qs if tags and isinstance(tags, six.string_types): tags = tags.split(',') self.object_list = self.object_list.filter(tags__name__in=tags) if not_tagged and isinstance(not_tagged, six.string_types): not_tagged = not_tagged.split(',') self.object_list = \ self.object_list.exclude(tags__name__in=not_tagged) if (export_type is None or export_type in ['json', 'jsonp', 'debug']) \ and hasattr(self, 'object_list'): return self._get_data(query, fields, sort, start, limit, is_public_request) xform = self.get_object() kwargs = {'instance__xform': xform} if export_type == Attachment.OSM: if request.GET: self.set_object_list_and_total_count(query, fields, sort, start, limit, is_public_request) kwargs = {'instance__in': self.object_list} osm_list = OsmData.objects.filter(**kwargs) page = self.paginate_queryset(osm_list) serializer = self.get_serializer(page) return Response(serializer.data) elif export_type is None or export_type in ['json']: # perform default viewset retrieve, no data export return super(DataViewSet, self).list(request, *args, **kwargs) elif export_type == 'geojson': serializer = self.get_serializer(self.object_list, many=True) return Response(serializer.data) return custom_response_handler(request, xform, query, export_type)