Django query over multiple tables

Question

I got so much trouble forming the right query to get my result...

from django.db import models
from django.contrib.auth.models import User

class GeoCatch(models.Model):
    user_me = models.ForeignKey(User, null=True, related_name='me')
    user_he = models.ForeignKey(User, null=True, related_name='he')
    permission_he = models.BooleanField(default=False)
    permission_me = models.BooleanField(default=False)

The query I need:

get names in djangos User table of various user_he which have user_me = 1 and have permission_he = True and permission_me= True

This and a couple other querys were not successful...

get_friends =  User.objects.values_list('username').filter(geoCatch__user_me=id)/
.filter(permission_he = True).filter(permission_me= True)

Gives me Error:

django.core.exceptions.FieldError: Cannot resolve keyword 'geoCatch' into field.

Burhan Khalid · Accepted Answer · 2012-02-01 05:45:08Z

2

friends = GeoCatch.objects.filter(user_me=User.objects.get(pk=id)) \
                    .filter(permission_me=True) \
                    .filter(permission_he=True).user_he_set.all()

edited Feb 1, 2012 at 5:45

answered Jan 31, 2012 at 12:03

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

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

1 Comment

Jurudocs Over a year ago

okay sorry: i set id to 1 and now it gives me : AttributeError: 'QuerySet' object has no attribute 'he_set'

guettli · Accepted Answer · 2012-01-31 11:45:37Z

1

# id is an id of a user object
get_friends =  User.objects.values_list('username', flat=True)\
    .filter(me__user_me__id=id, me__permission_he = True, me__permission_me= True)

answered Jan 31, 2012 at 11:45

guettli

27.7k109 gold badges423 silver badges779 bronze badges

2 Comments

Jurudocs Over a year ago

this works! if id is set by the user object...sorry...hard to understand especially the __me stuff...

Jurudocs Over a year ago

hmm it just gives me the username of the id so many times like it has found matching permission_he and permission_me...

Collectives™ on Stack Overflow

Django query over multiple tables

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related