Unique fields that allow nulls in Django

by

Django has not considered NULL to be equal to NULL for the purpose of uniqueness checks since ticket #9039 was fixed, see:

http://code.djangoproject.com/ticket/9039

The issue here is that the normalized “blank” value for a form CharField is an empty string, not None. So if you leave the field blank, you get an empty string, not NULL, stored in the DB. Empty strings are equal to empty strings for uniqueness checks, under both Django and database rules.

You can force the admin interface to store NULL for an empty string by providing your own customized model form for Foo with a clean_bar method that turns the empty string into None:

class FooForm(forms.ModelForm):
    class Meta:
        model = Foo

    def clean_bar(self):
        return self.cleaned_data['bar'] or None

class FooAdmin(admin.ModelAdmin):
    form = FooForm

More Related Contents:

  1. What does on_delete do on Django models?
  2. Dynamic File Path in Django
  3. Django: Get list of model fields?
  4. Django: Populate user ID when saving a model
  5. How do I get Django Admin to delete files when I remove an object from the database/model?
  6. Get model’s fields in Django
  7. Can django’s auth_user.username be varchar(75)? How could that be done?
  8. How to ‘bulk update’ with Django?
  9. Using a UUID as a primary key in Django models (generic relations impact)
  10. Django ManyToMany filter()
  11. Django delete FileField
  12. Why does django’s prefetch_related() only work with all() and not filter()?
  13. ImageField overwrite image file with same name
  14. Django “xxxxxx Object” display customization in admin action sidebar
  15. How to limit queryset/the records to view in Django admin site?
  16. How to assign currently logged in user as default value for a model field?
  17. How to register users in Django REST framework?
  18. Using Django auth UserAdmin for a custom user model
  19. Django ManyToMany model validation
  20. Django – Overriding the Model.create() method?
  21. Multiple images per Model
  22. Accelerate bulk insert using Django’s ORM?
  23. Django : Unable to import model from another App
  24. django.db.utils.IntegrityError: UNIQUE constraint failed: rango_category__new.slug
  25. How to select a record and update it, with a single queryset in Django?
  26. Django query datetime for objects older than 5 hours
  27. Django: Does prefetch_related() follow reverse relationship lookup?
  28. How to add Check Constraints for Django Model fields?
  29. How to store a dictionary on a Django Model?
  30. Django Migrations Add Field with Default as Function of Model

Leave a Comment