PostgreSQL specific form fields and widgets

All of these fields and widgets are available from the django.contrib.postgres.forms module.

Fields

SimpleArrayField

class SimpleArrayField(base_field, delimiter=’,’, max_length=None, min_length=None)

A field which maps to an array. It is represented by an HTML <input>.

  • base_field

    This is a required argument.

    It specifies the underlying form field for the array. This is not used to render any HTML, but it is used to process the submitted data and validate it. For example:

    1. >>> from django import forms
    2. >>> from django.contrib.postgres.forms import SimpleArrayField
    3. >>> class NumberListForm(forms.Form):
    4. ... numbers = SimpleArrayField(forms.IntegerField())
    5. ...
    6. >>> form = NumberListForm({"numbers": "1,2,3"})
    7. >>> form.is_valid()
    8. True
    9. >>> form.cleaned_data
    10. {'numbers': [1, 2, 3]}
    11. >>> form = NumberListForm({"numbers": "1,2,a"})
    12. >>> form.is_valid()
    13. False
  • delimiter

    This is an optional argument which defaults to a comma: ,. This value is used to split the submitted data. It allows you to chain SimpleArrayField for multidimensional data:

    1. >>> from django import forms
    2. >>> from django.contrib.postgres.forms import SimpleArrayField
    3. >>> class GridForm(forms.Form):
    4. ... places = SimpleArrayField(SimpleArrayField(IntegerField()), delimiter="|")
    5. ...
    6. >>> form = GridForm({"places": "1,2|2,1|4,3"})
    7. >>> form.is_valid()
    8. True
    9. >>> form.cleaned_data
    10. {'places': [[1, 2], [2, 1], [4, 3]]}

    Note

    The field does not support escaping of the delimiter, so be careful in cases where the delimiter is a valid character in the underlying field. The delimiter does not need to be only one character.

  • max_length

    This is an optional argument which validates that the array does not exceed the stated length.

  • min_length

    This is an optional argument which validates that the array reaches at least the stated length.

User friendly forms

SimpleArrayField is not particularly user friendly in most cases, however it is a useful way to format data from a client-side widget for submission to the server.

SplitArrayField

class SplitArrayField(base_field, size, remove_trailing_nulls=False)

This field handles arrays by reproducing the underlying field a fixed number of times.

  • base_field

    This is a required argument. It specifies the form field to be repeated.

  • size

    This is the fixed number of times the underlying field will be used.

  • remove_trailing_nulls

    By default, this is set to False. When False, each value from the repeated fields is stored. When set to True, any trailing values which are blank will be stripped from the result. If the underlying field has required=True, but remove_trailing_nulls is True, then null values are only allowed at the end, and will be stripped.

    Some examples:

    1. SplitArrayField(IntegerField(required=True), size=3, remove_trailing_nulls=False)
    2. ["1", "2", "3"] # -> [1, 2, 3]
    3. ["1", "2", ""] # -> ValidationError - third entry required.
    4. ["1", "", "3"] # -> ValidationError - second entry required.
    5. ["", "2", ""] # -> ValidationError - first and third entries required.
    6. SplitArrayField(IntegerField(required=False), size=3, remove_trailing_nulls=False)
    7. ["1", "2", "3"] # -> [1, 2, 3]
    8. ["1", "2", ""] # -> [1, 2, None]
    9. ["1", "", "3"] # -> [1, None, 3]
    10. ["", "2", ""] # -> [None, 2, None]
    11. SplitArrayField(IntegerField(required=True), size=3, remove_trailing_nulls=True)
    12. ["1", "2", "3"] # -> [1, 2, 3]
    13. ["1", "2", ""] # -> [1, 2]
    14. ["1", "", "3"] # -> ValidationError - second entry required.
    15. ["", "2", ""] # -> ValidationError - first entry required.
    16. SplitArrayField(IntegerField(required=False), size=3, remove_trailing_nulls=True)
    17. ["1", "2", "3"] # -> [1, 2, 3]
    18. ["1", "2", ""] # -> [1, 2]
    19. ["1", "", "3"] # -> [1, None, 3]
    20. ["", "2", ""] # -> [None, 2]

HStoreField

class HStoreField

A field which accepts JSON encoded data for an HStoreField. It casts all values (except nulls) to strings. It is represented by an HTML <textarea>.

User friendly forms

HStoreField is not particularly user friendly in most cases, however it is a useful way to format data from a client-side widget for submission to the server.

Note

On occasions it may be useful to require or restrict the keys which are valid for a given field. This can be done using the KeysValidator.

Range Fields

This group of fields all share similar functionality for accepting range data. They are based on MultiValueField. They treat one omitted value as an unbounded range. They also validate that the lower bound is not greater than the upper bound. All of these fields use RangeWidget.

IntegerRangeField

class IntegerRangeField

Based on IntegerField and translates its input into django.db.backends.postgresql.psycopg_any.NumericRange. Default for IntegerRangeField and BigIntegerRangeField.

DecimalRangeField

class DecimalRangeField

Based on DecimalField and translates its input into django.db.backends.postgresql.psycopg_any.NumericRange. Default for DecimalRangeField.

DateTimeRangeField

class DateTimeRangeField

Based on DateTimeField and translates its input into django.db.backends.postgresql.psycopg_any.DateTimeTZRange. Default for DateTimeRangeField.

DateRangeField

class DateRangeField

Based on DateField and translates its input into django.db.backends.postgresql.psycopg_any.DateRange. Default for DateRangeField.

Widgets

RangeWidget

class RangeWidget(base_widget, attrs=None)

Widget used by all of the range fields. Based on MultiWidget.

RangeWidget has one required argument:

  • base_widget

    A RangeWidget comprises a 2-tuple of base_widget.

  • decompress(value)

    Takes a single “compressed” value of a field, for example a DateRangeField, and returns a tuple representing a lower and upper bound.