DjangoのO/Rマッパー備忘録

# より大きい：＞　(greater than)
Sample.objects.filter(field__gt='条件')

# 以上：≧　(greater than or equal)
Sample.objects.filter(field__gte='条件')

# より小さい：＜　(less than)
Sample.objects.filter(field__lt='条件')

# 以下：≦　(less than or equal)
Sample.objects.filter(field__lte='条件')

# BETWEEN句検索
Sample.objects.filter(field__range=(start, end))

日付の厳密一致

# 年
Sample.objects.filter(field__year=sample_year)
# 月
Sample.objects.filter(field__month=sample_month)
# 日
Sample.objects.filter(field__day=sample_day)