python - Django REST framework - filtering against query param with date Outside Views.py file

Question

I created my "API" using REST framework, now trying to do filtering for it. That's how my models.py look for BookingStatement model.

class BookingStatement(BaseModel):
    ticket_number = models.PositiveIntegerField(unique=True)
    booking = models.OneToOneField(Booking, on_delete=models.PROTECT)
    user_rate = AmountField()
    agent_rate = AmountField()
    total_amount = AmountField()

    class Meta:
        default_permissions = ()

    def __str__(self):
        return str(self.id)

Booking is One to One Key so the booking model has following Attributes.

class Booking(BaseModel):
    bus_seat = models.ManyToManyField(Seat)
    schedule = models.ForeignKey(Schedule, on_delete=models.PROTECT)
    boarding_point = models.ForeignKey(
        BoardingPoint,
        on_delete=models.PROTECT,
        null=True
    )
    remarks = models.JSONField(null=True, blank=True)
    contact = PhoneNumberField(null=True)
    booking_date_time = models.DateTimeField(auto_now_add=True)

    class Meta:
        default_permissions = ()
        verbose_name = 'Booking'
        verbose_name_plural = 'Bookings'

    def __str__(self):
        return '{}-{}'.format(self.user, self.customer_name)

I used generic ListAPIView in my views.py as following.

class BusCompanyTicketDetailView(generics.ListAPIView, BusCompanyMixin):
    serializer_class = serializers.TicketDetailResponseSerializer
    def get_queryset(self):
        travel_date = (int(self.request.query_params.get('booking_date')))
        print(booking_date)

        return usecases.ListBusCompanyTicketUseCase(date=#'what should i pass?'#).execute()

I use usecases.py to filter booking_date_time with url as following.

http://127.0.0.1:8000/api/v1/ticket/list?booking_date=2021-1-29

So my usecase file to filter the Booking time is as following.

class ListBusCompanyTicketUseCase(BaseUseCase):
    def __init__(self, date:datetime):
        self._date = datetime

    def execute(self):
        self._factory()
        return self._booking_statements

    def _factory(self):
        self._booking_statements = BookingStatement.objects.filter(booking__booking_date_time=?? need to get date from views.)

Problem is I don't know to how to get query params from url in my usecases to filter with booking date any help will be very helpful.

Answer 1

you should use django-filter to implement filtering on the viewsets. It's a bit of knowledge you have to build up, but once you understand it, you can do a lot of complex filtering logic with it. Trying to implement a filtering system yourself is always more difficult in the long run. For starting point, check out the official documentation: https://www.django-rest-framework.org/api-guide/filtering/. For the filter, check out the documentation on DRF integration: https://django-filter.readthedocs.io/en/stable/guide/rest_framework.html.