From 24b9f5082344a127147266dd52d5d2dcd1c9cb44 Mon Sep 17 00:00:00 2001 From: Dulmandakh Date: Wed, 6 Nov 2019 18:22:15 +0800 Subject: Fixed #29916 -- Added lower_inc, lower_inf, upper_inc, and upper_inf lookups for RangeFields. Co-Authored-By: Mariusz Felisiak --- docs/ref/contrib/postgres/fields.txt | 56 ++++++++++++++++++++++++++++++++++++ docs/releases/3.1.txt | 4 +++ 2 files changed, 60 insertions(+) (limited to 'docs') diff --git a/docs/ref/contrib/postgres/fields.txt b/docs/ref/contrib/postgres/fields.txt index 27cf6469f1..cd35a33ee6 100644 --- a/docs/ref/contrib/postgres/fields.txt +++ b/docs/ref/contrib/postgres/fields.txt @@ -864,6 +864,62 @@ Returned objects are empty ranges. Can be chained to valid lookups for a >>> Event.objects.filter(ages__isempty=True) +.. fieldlookup:: rangefield.lower_inc + +``lower_inc`` +^^^^^^^^^^^^^ + +.. versionadded:: 3.1 + +Returns objects that have inclusive or exclusive lower bounds, depending on the +boolean value passed. Can be chained to valid lookups for a +:class:`~django.db.models.BooleanField`. + + >>> Event.objects.filter(ages__lower_inc=True) + , ]> + +.. fieldlookup:: rangefield.lower_inf + +``lower_inf`` +^^^^^^^^^^^^^ + +.. versionadded:: 3.1 + +Returns objects that have unbounded (infinite) or bounded lower bound, +depending on the boolean value passed. Can be chained to valid lookups for a +:class:`~django.db.models.BooleanField`. + + >>> Event.objects.filter(ages__lower_inf=True) + + +.. fieldlookup:: rangefield.upper_inc + +``upper_inc`` +^^^^^^^^^^^^^ + +.. versionadded:: 3.1 + +Returns objects that have inclusive or exclusive upper bounds, depending on the +boolean value passed. Can be chained to valid lookups for a +:class:`~django.db.models.BooleanField`. + + >>> Event.objects.filter(ages__upper_inc=True) + + +.. fieldlookup:: rangefield.upper_inf + +``upper_inf`` +^^^^^^^^^^^^^ + +.. versionadded:: 3.1 + +Returns objects that have unbounded (infinite) or bounded upper bound, +depending on the boolean value passed. Can be chained to valid lookups for a +:class:`~django.db.models.BooleanField`. + + >>> Event.objects.filter(ages__upper_inf=True) + ]> + Defining your own range types ----------------------------- diff --git a/docs/releases/3.1.txt b/docs/releases/3.1.txt index f725e4e056..a7c9caa31e 100644 --- a/docs/releases/3.1.txt +++ b/docs/releases/3.1.txt @@ -80,6 +80,10 @@ Minor features :class:`~django.contrib.postgres.fields.ArrayField` and :class:`~django.contrib.postgres.fields.RangeField`. +* The new :lookup:`rangefield.lower_inc`, :lookup:`rangefield.lower_inf`, + :lookup:`rangefield.upper_inc`, and :lookup:`rangefield.upper_inf` allows + querying :class:`~django.contrib.postgres.fields.RangeField` by a bound type. + :mod:`django.contrib.redirects` ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- cgit v1.3