About Many-to-many Relationships to Self

1
2
3

class Location(models.Model):
    name = models.CharField(max_length=200)
    related_locations = models.ManyToManyField("self", blank=True)

1
2

location1.related_locations.filter(pk=location2.pk).exists()
location2.related_locations.filter(pk=location1.pk).exists()

1
2
3

locations_with_related_locations = Location.objects.annotate(
    related_locations_count=models.Count("related_locations"),
).filter(related_locations_count__gt=0)

Tips and Tricks Programming Architecture Django 5.x Django 4.2 Django 3.2 PostgreSQL MySQL SQLite

• Share
  on X
• Share
  on Facebook
• Share
  on LinkedIn