Custom ordering in Django

by

As far as I’m aware, there’s no way to specify database-side ordering in this way as it would be too backend-specific. You may wish to resort to good old-fashioned Python sorting:

class Foo(models.Model):
    name = models.CharField(max_length=128)

Foo.objects.create(name="a10")
Foo.objects.create(name="a1")
Foo.objects.create(name="a2")

ordered = sorted(Foo.objects.all(), key=lambda n: (n[0], int(n[1:])))
print ordered # yields a1, a2, 10

If you find yourself needing this kind of sorting a lot, I’d recommend making a custom models.Manager subclass for your model that performs the ordering. Something like:

class FooManager(models.Manager):
    def in_a_number_order(self, *args, **kwargs):
        qs = self.get_query_set().filter(*args, **kwargs)
        return sorted(qs, key=lambda n: (n[0], int(n[1:])))

class Foo(models.Model):
    ... as before ...
    objects = FooManager()

print Foo.objects.in_a_number_order()
print Foo.objects.in_a_number_order(id__in=[5, 4, 3]) # or any filtering expression

More Related Contents:

  1. django.core.exceptions.ImproperlyConfigured: Requested setting INSTALLED_APPS, but settings are not configured. plz help me out plz
  2. What is the difference between null=True and blank=True in Django?
  3. Django dynamic model fields
  4. Django set default form values
  5. What’s the difference between select_related and prefetch_related in Django ORM?
  6. Can “list_display” in a Django ModelAdmin display attributes of ForeignKey fields?
  7. How to pull a random record using Django’s ORM?
  8. Django – No such table: main.auth_user__old
  9. Django rest framework serializing many to many field
  10. Django Unique Together (with foreign keys)
  11. django template system, calling a function inside a model
  12. Django : Table doesn’t exist
  13. Django Rest Framework and JSONField
  14. How to filter objects for count annotation in Django?
  15. How do I separate my models out in django?
  16. Writing a __init__ function to be used in django model
  17. How to change the file name of an uploaded file in Django?
  18. Difference between AbstractUser and AbstractBaseUser in Django?
  19. Customize/remove Django select box blank option
  20. Duplicating model instances and their related objects in Django / Algorithm for recusrively duplicating an object
  21. Override a form in Django admin
  22. Good ways to sort a queryset? – Django
  23. Resize fields in Django Admin
  24. Identify the changed fields in django post_save signal
  25. How can I set two primary key fields for my models in Django?
  26. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  27. Django foreign key relation in template
  28. Django get_profile() method not working on extended User model
  29. How to delete a record in Django models?
  30. How to properly use the “choices” field option in Django

Leave a Comment