Django. How to get entries that do not have a booking for a given period?

Question

Django

Ay nid yo help!
There is a Booking model with fields:

#Модель Booking
from_date = models.DateTimeField() #Дата начала бронирования
to_date = models.DateTimeField() #Дата конца бронирования
vehicle = models.ForeignKey(Vehicle .... # FK к модели автомобиля
confirmed = models.BooleanField(default=False) #Подвержденный или нет

So I can’t understand how you can get records with a list of vehicles (Vehicle), where there are no confirmed bookings (Booking) in the range "from" and "to"

Answer 1

The algorithm is as follows:
1. Take a sheet of paper
2. Draw your task on it
3. Strain the thing you usually eat in
4. It gives birth to a solution
If point number 4 did not work, change your profession

Answer 2

If I understand you correctly:

free_vehicles = Vehicle.objects.filter(
    booking__confirmed=False, 
    booking__from_date__gte=datetime_from, 
    booking__to_date__lte=datetime_to,
)

Learn materiel .