django query accessing foreign key data

Question

Apology if this is a duplicate but I could not find any satisfying answer for this case. Maybe I am doing something fundamentally wrong, like need to define models in a different way.I am also very new to django.So suggestions will be really helpful.

Suppose I have my models like this:

from django.contrib.auth.models import Group
class Team(Group):
    description = models.CharField(max_length=30)

class Players(models.Model):
    name = models.CharField(max_length=60)
    team = models.ForeignKey(Team, on_delete=models.CASCADE)

Now if I for example, want a queryset of all players by the Team model what can I do? I have the foreign key in the Players model and not in Team model. So something like Team.objects.filter(logic) is needed to get all players. But exactly what logic will work here?

Any help will be much appreciated.

Naqib Hakimi · Accepted Answer · 2020-01-18 19:20:57Z

3

Django ORM also can filter by relation. these kind of filtering is valid for all kind of relations.

 players = Players.objects.filter(team__id = 1)

in case you have the team object.

players = Players.objects.filter(team = team)

answered Jan 18, 2020 at 19:20

Naqib Hakimi

9224 silver badges16 bronze badges

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

Comments

neverwalkaloner · Accepted Answer · 2020-01-18 17:27:09Z

2

Django allows you get access to related objects in reverse way. It calling reverse relation. And related manager objects using for it. You can find more details here and here. In your specifc case you can get players using players_set team's attribute:

team = Team.objects.get(pk=1)
players = team.players_set.all()

answered Jan 18, 2020 at 17:27

neverwalkaloner

47.6k7 gold badges101 silver badges103 bronze badges

Collectives™ on Stack Overflow

django query accessing foreign key data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related