Django查询写入

Question

如何以Django查询的形式编写下面的SQL查询

SELECT time 
FROM dispatcher_booking_timeline 
WHERE status = "completed" AND bookingId_id =
    (SELECT bookingId_id 
     FROM dispatcher_dispatch
     WHERE status = 0)

提前谢谢。你知道吗

Answer 1

假设您有与SQL查询1-1对应的模型：

status_zeros = Dispatch.objects.filter(status=0).values_list('pk', flat=True)
BookingTimeline.objects.filter(status="completed", pk__in=status_zeros)

Answer 2

而不是应该的

booking_timelines = BookingTimeline.objects.filter(status="completed",pk__in=status_zeros)
times_set = set( booking_timelines.values_list('time', flat=True) )