Django:在数据库中不存在的两个日期范围之间进行分组

from django.db import models

class Event(models.Model):
    date = models.DateField()
    # 其他字段...

from django.db.models import Q

def get_existing_dates(start_date, end_date):
    existing_dates = Event.objects.filter(date__range=(start_date, end_date))
    return existing_dates

from datetime import datetime, timedelta

def get_date_range(start_date, end_date):
    date_range = []
    current_date = start_date
    while current_date <= end_date:
        date_range.append(current_date)
        current_date += timedelta(days=1)
    return date_range

def get_missing_dates(start_date, end_date):
    existing_dates = get_existing_dates(start_date, end_date)
    date_range = get_date_range(start_date, end_date)
    missing_dates = [date for date in date_range if date not in existing_dates]
    return missing_dates