Creating Partial Indexes with Django 1.7

by

Django 2.2 and later

As of version 2.2 Django supports declarative partial unique indexes on databases that support them (PostgreSQL and SQLite). So you could do something like:

from django.db.models import Model, Q, UniqueConstraint

class Post(Model):
    ...
    class Meta:
        constraints = [
            UniqueConstraint(
                fields=["title", "blog", "category"],
                name="idx1",
                condition=Q(category__isnull=False)),
            UniqueConstraint(
                fields=["title", "blog"], 
                name="idx2",                    
                condition=Q(category__isnull=True)),
        ]

Django 2.1 and earlier

In older versions you need to do this with migrations. First create a new, empty migration file:

python manage.py makemigrations --empty yourappname

Then, for each index add an appropriate RunSQL line:

operations = [
    migrations.RunSQL("CREATE UNIQUE INDEX..."),
    migrations.RunSQL("CREATE UNIQUE INDEX..."),
]

Finally, run migrate.

More Related Contents:

  1. How to view corresponding SQL query of the Django ORM’s queryset?
  2. Django migrate –fake and –fake-initial explained
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. django 1.7 migrate gets error “table already exists”
  6. Django data migration when changing a field to ManyToMany
  7. Django: implementing JOIN using Django ORM?
  8. How to query Case-insensitive data in Django ORM?
  9. Django Migrations Add Field with Default as Function of Model
  10. How to simplify migrations in Django 1.7?
  11. What does on_delete do on Django models?
  12. Django Aggregation: Summation of Multiplication of two fields
  13. Issue with ManyToMany Relationships not updating immediately after save
  14. Django: Populate user ID when saving a model
  15. How to revert the last migration?
  16. Get model’s fields in Django
  17. Can django’s auth_user.username be varchar(75)? How could that be done?
  18. Custom QuerySet and Manager without breaking DRY?
  19. Django: Query using contains each value in a list
  20. How do you serialize a model instance in Django?
  21. How to make email field unique in model User from contrib.auth in Django
  22. Django ModelForm override widget
  23. Django – filtering on foreign key properties
  24. Django unique_together with nullable ForeignKey
  25. Default image for ImageField in Django’s ORM
  26. Django: ManyToMany filter matching on ALL items in a list
  27. Django query datetime for objects older than 5 hours
  28. How to add Check Constraints for Django Model fields?
  29. Django queryset get exact manytomany lookup [duplicate]
  30. Django Programming error column does not exist even after running migrations

Leave a Comment