Django: how to set pagination in resfulapi?

Asked Mar 05 '20 at 08:06

Active Mar 05 '20 at 09:53

Viewed 51 times

here i tried django default pagination in my views, query works perfectly but pagination does not work for me. what should i do? i guess i have to make a custom pagination as per my code. it would be great if anybody could help me where i made mistake in my code.

from rest_framework.pagination import PageNumberPagination
class DefaultResultsSetPagination(PageNumberPagination):
    page_size = 2
    page_size_query_param = 'page_size'
    max_page_size = 100000

class Order_ListAPIView(APIView):
    pagination_class = DefaultResultsSetPagination
    def get(self,request,format=None):

        if request.method == 'GET':
            cur,conn = connection()
            order_query = ''' SELECT * FROM orders'''
            order_detail_query = ''' SELECT * FROM order_details'''


            ...
             ... #rest_code
              ...


            return Response({"order_data":order_data},status=status.HTTP_200_OK)
        else:
            return Response(status=status.HTTP_400_BAD_REQUEST)

settings:

REST_FRAMEWORK = {
    'DEFAULT_PAGINATION_CLASS': 'rest_framework.pagination.PageNumberPagination',
    'PAGE_SIZE': 2
}

edited Mar 05 '20 at 09:53

asked Mar 05 '20 at 08:06

anonymoususer

describe what `not working` for you, any errors ? – Linh Nguyen Mar 05 '20 at 08:10
i set djangorestapi default pagination in my code but pagination doesn't work for me. – anonymoususer Mar 05 '20 at 08:12
in your url if you add extra ?page=1 what s happen? – Florin Mar 05 '20 at 08:25
nothing happen, it's still remain same. @Florin – anonymoususer Mar 05 '20 at 08:28
but your query its working? – Florin Mar 05 '20 at 08:33
yes it's working perfect! do you have other solution how to set pagination in query as per page? @Florin – anonymoususer Mar 05 '20 at 08:39
paginator = DefaultResultsSetPagination() result = paginator.paginate_queryset(order_query, request) I couldn't check whether this is a workaround. – vijay Mar 05 '20 at 09:51

Django: how to set pagination in resfulapi?

0 Answers0

Linked