Geek asks and answers

Complex query in Django ORM

I have a model Follow:

class Follow(BaseModel):

    follower = django.db.models.ForeignKey(
        'User',
        related_name='_follows_we_are_follower'
    )
    followee = django.db.models.ForeignKey(
        'User',
        related_name='_follows_we_are_followee'
    )
    datetime_canceled = django.db.models.DateTimeField(null=True, blank=True)

When I process a user, how can I get all the users he is following? I suppose that I need something like "Give me all the users for which the Follow object exists with datetime_canceledof None, and followerthat is that user, and then for all subsequent users it should be the users who are in the field followee." How to write this in Django?

+3
source share
2 answers
my_user._follows_we_are_follower.filter(datetime_canceled=None)

Edit

User.objects.filter(_follows_we_are_followee__follower=my_user, _follows_we_are_followee__datetime_canceled=None)
0
source

Now I'm not at all in django. So the syntax would be wrong. But I think you want something like this:

User.objects.filter(Follow_related_name__in = ['_follows_we_are_follower', ,'_follows_we_are_followee'], datetime_canceled__is_null =True)
+1
source

More articles:


All Articles