Django: Model Get Related Object

Question

I asked a similar question earlier today:
I have the following, table / class:

 Class UserFriend(model.Model):
      user = models.ForeignKey(User, related_name='friend_users' )
      friend = models.ForeignKey(User, related_name='friend_friends')
      active = models.BooleanField()

where User is the built-in auth_user class, I want to get only the friends, not the userfriends object where user is a specific user.

I'm looking to do the following SQL:

 select u.* from auth_user u, user_friend uf where u.user_id = 5 
    and u.id = uf.friend_id  
    and active=1 --- where user_id = the user being queried..

PauliusZ · Accepted Answer · 2014-03-06 11:03:12Z

1

If user is the one you want friends for:

user.friend_users.filter(active=True).values_list('friend', flat=True)

answered Mar 6, 2014 at 11:03

PauliusZ

4135 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django: Model Get Related Object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related