如何将Mysql日期范围查询转换为Django查询

Question

python新手以及django

问题：

我需要用Django编写一个日期范围查询

我知道mysql查询

SELECT * 
FROM productreport 
WHERE start_date BETWEEN '2014-10-12 00:00:00' and '2014-11-12 00:00:00' 
OR end_date BETWEEN '2014-10-12 00:00:00' and '2014-11-12 00:00:00';

我需要使用filter(**kwargs)动态更改上述查询

已编辑：

^{pr2}$

Answer 1

看看Q objects：

from django.db.models import Q

date_filter = Q(start_date__range = [str(daterangestart), str(datereangeend)] )
date_filter |= Q(end_date__range = [str(daterangestart), str(datereangeend)] )
reportDetails = productreport.objects.filter(date_filter)