Support __contained_by lookup for AutoFields and BigAutoFields.

[Bolay Michael]

AutoField can't use the __contained_by relation on postgres Range fields.

To support it, RangeContainedBy lookup class needs to add a map for serial data type and AutoField must register this lookup.

Example of unsupported feature

from django.contrib.postgres.fields import IntegerRangeField
from psycopg2.extras import NumericRange

class Model(models.Model):
    pass

class ModelBundle(models.Model):
   id_range = IntegerRangeField()

# this query is invalid
Model.objects.filter(id__contained_by=NumericRange(0, 10))

# and thus this one neither is
bundle = ModelBundle.object.get(...)
Model.objects.filter(id__contained_by=bundle.id_range)

Here is how I fix the missing feature

from django.contrib.postgres.fields.ranges import RangeContainedBy

class ExtendedRangeContainedBy(RangeContainedBy):
    type_mapping = {
        'serial': 'int4range',   # <---- add serial type mapping
        'integer': 'int4range',
        'bigint': 'int8range',
        'double precision': 'numrange',
        'date': 'daterange',
        'timestamp with time zone': 'tstzrange',
    }


AutoField.register_lookup(ExtendedRangeContainedBy)   # <---- register the lookup for AutoField

[Mariusz Felisiak]

Agreed, we should support __contained_by lookup for AutoField's and BigAutoField's.

[Mariusz Felisiak <felisiak.mariusz@…>]

In 664521c5:

Refs #31039 -- Removed unnecessary registration of contained_by lookup for BigIntegerField.

It's already registered for IntegerField.

[Mariusz Felisiak <felisiak.mariusz@…>]

In 5d674eac:

Fixed #31039 -- Added support for contained_by lookup with AutoFields, SmallIntegerField, and DecimalField.