Terralego/django-geostore

import operator
try:
    from django.db.models import JSONField
except ImportError:  # TODO Remove when dropping Django releases < 3.1
    from django.contrib.postgres.fields import JSONField
from django.core.exceptions import FieldDoesNotExist
from django.db.models import Q
from rest_framework.filters import BaseFilterBackend, OrderingFilter, SearchFilter
from functools import reduce


class JSONFieldFilterBackend(BaseFilterBackend):
    def filter_queryset(self, request, queryset, view):
        query = Q()
        for param_name, param_value in request.query_params.items():
            try:
                field = (queryset.model
                                 ._meta
                                 .get_field(param_name.split('__')[0]))
            except FieldDoesNotExist:
                pass
            else:
                if isinstance(field, JSONField):
                    sub_query = Q(**{param_name: param_value})
                    try:
                        sub_query |= Q(**{param_name: int(param_value)})
                    except ValueError:
                        pass
                    query &= sub_query
        return queryset.filter(query)


class JSONFieldOrderingFilter(OrderingFilter):
    def get_valid_fields(self, queryset, view, context={}):
        fields = super().get_valid_fields(queryset, view, context=context)
        layer = view.get_layer()
        if layer and layer.schema:
            # allow ordering by property name ONLY if schema specified.
            # This prevents big queries on all layer's feature to find them
            for prop in layer.layer_properties:
                fields.append((f'properties__{prop}', layer.get_property_title(prop)))
        return fields


class JSONSearchField(SearchFilter):
    def get_search_fields(self, view, request):
        fields = []
        layer = view.get_layer()
        if layer and layer.schema:
            # allow search by property name ONLY if schema specified.
            # This prevents big queries on all layer's feature to find them
            for prop in layer.layer_properties:
                fields.append(f'properties__{prop}')
        return fields

    def filter_queryset(self, request, queryset, view):
        search_fields = self.get_search_fields(view, request)
        search_terms = self.get_search_terms(request)
        if search_terms:
            filters = list()
            for field in search_fields:
                filters.append(Q(**{f'{field}__icontains': search_terms[0]}))

            return queryset.filter(reduce(operator.or_, filters))
        else:
            return queryset