django subquery via orm

Question

I have models:

class Site(models.Model):
    profile = models.ForeignKey(User)

class Profile(models.Model):
    blacklist = models.ManyToManyField(Site)

How can i do equivalent of this query via django orm?

SELECT * FROM site WHERE 2 NOT IN (SELECT site_id FROM profile_blacklist WHERE profile_site.profile_id=site.profile_id)

I need some kind of blacklist filter. Each site has user (profile). This user has black list of sites. I do search for site with id=2 for exapmle. And i need sites witch owners has no site number 2 in blacklist.

Daniel Roseman · Accepted Answer · 2010-08-04 11:49:20Z

1

Don't think in terms of SQL. Think in terms of what result you want.

I don't really understand why you're using a subquery in that SQL anyway. It seems that what you want to do is find all the sites that have a category whose ID is 2. Is that right?

If so, what you want is:

Site.objects.filter(category__id=2)

answered Aug 4, 2010 at 11:49

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

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

1 Comment

Evg Over a year ago

Sorry, my first question description was bad. I edit the topic.

Collectives™ on Stack Overflow

django subquery via orm

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related