A complex model query in django concerning related objects

Question

Suppose I have the following two models:

class A(models.Model):
    name = models.CharField(max_length = 20)
    type = models.CharField(max_length = 20)
class B(models.Model):
    name = models.CharField(max_length = 20)
    type = models.CharField(max_length = 20)
    a = models.ForeinKey(A)

I want such A instances:

Its name is 'name_a' and its type is 'type_a'
It has at least one B objects related to it whose name is 'name_b' and whose type is 'type_b'

Is there a way to get such A instances at one time?

falsetru · Accepted Answer · 2014-08-10 02:44:23Z

2

You can use filter as follow:

A.objects.filter(name='name_a', type='type_a',
                 b__name='name_b', b__type='type_b').distinct()

UPDATE Added distinct to prevent duplicate objects.

answered Aug 10, 2014 at 2:44

falsetru

371k69 gold badges769 silver badges659 bronze badges

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

2 Comments

Kevin Christopher Henry Over a year ago

Add distinct() to prevent duplicate objects.

falsetru Over a year ago

@KevinChristopherHenry, Thank you for advice. I updated the answer to include that.

Collectives™ on Stack Overflow

A complex model query in django concerning related objects

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related