Django Queryset Design: Filtering out soft-deleted users?

user_5509839 0
Viewed 40

I have a soft-delete user model in Django, where we set is_active to False.

But one problem I'm running into is needing to filter out is_active users on every type of content:

  • Item.objects.filter(user__is_active=False, ...)
  • Comment.objects.filter(user__is_active=False, ...)
  • User.objects.filter(is_active=False, ...)

And so-on. Is there some type of Django / Pythonic design pattern I can use here to avoid needing to manually filter out all users every time I query something made by a user, or a current list of users?

django python
2 Answers
user_119342280

You can use ModelManager.

For example:


class ItemManager(models.Manager):
    def get_queryset(self):
        return super().get_queryset().filter(is_active=True)

class Item(models.Model):
    .....
    objects = ItemManager() # your custom manager
    all_objects = models.Manager() # default manager

Now with Item.objects.all() you will get objects having is_active=True only.

If you want all the objects then you can use Item.all_objects.all()

user_120616530
Related