Re: Adding Objects to Query Set

I will try this out also. Thanks!

On Tue, Dec 17, 2013 at 1:57 PM, Arnold Krille <arnold@arnoldarts.de> wrote:

Hi,

define related names in ProjectMember:

class ProjectMember(models.Model):
    project = models.ForeignKey(Project, related_name='members')

    member = models.ForeignKey(User)
    added_on = models.DateTimeField()

The full query to get all Projects the User is either member or leader:

Projects.objects.filter(
    Q(owner=user) | Q(members__member=user)
)

Don't merge in python what you can merge in the database. One
query in the database is (almost) always faster then two queries and
merging in python.

Have fun,

Arnold

Am Mon, 16 Dec 2013 09:56:27 -0800 (PST)
schrieb antialiasis <antialiasis@gmail.com>:

> Rather than fetching
> ProjectMember.objects.filter(member=request.user), you want to fetch
> Project.objects.filter(projectmember_set__member=request.user). That
> will get you Project objects rather than ProjectMember objects.
>
> On Monday, December 16, 2013 1:47:13 PM UTC, Vibhu Rishi wrote:
> >
> > Hi
> >
> > I am not able to figure this out. I want to add objects to a query
> > set.
> >
> > I have 2 models :
> > 1. Projects which is basically a list of projects. I have a field
> > which defines the owner of the project. e.g. :
> >
> > class Project(models.Model):
> >     ...
> >     owner = models.ForeignKey(User)
> >
> > 2. ProjectMember - This is a table where I add any user ( other
> > than owner ) if they are member of the project.
> >
> > class ProjectMember(models.Model):
> >     project = models.ForeignKey(Project)
> >     member = models.ForeignKey(User)
> >     added_on = models.DateTimeField()
> >
> > What I am trying to do is get a list of projects which the current
> > user is either owner or member of. So, I have this in my view :
> >
> > def mylist(request):
> >     projects = Project.objects.filter(owner=request.user)
> >     member_of = ProjectMember.objects.filter(member = request.user)
> >     # Now find all projects the user is a member of and add to the
> > projects list
> >     all_projects = projects
> >     for m in member_of:
> >         all_projects |= m.project
> >     return render (request, "project/projects_mine.html",
> > {'projects':projects})
> >
> >
> > I am doing something wrong here as the line all_projects |=
> > m.project is not working. I tried with a += also.
> >
> > How can I achieve what I am trying to do ?
> >
> > Vibhu
> >
> > --
> > Simplicity is the ultimate sophistication. - Leonardo da Vinci
> > Life is really simple, but we insist on making it complicated. -
> > Confucius
> >
>

--
Simplicity is the ultimate sophistication. - Leonardo da Vinci
Life is really simple, but we insist on making it complicated. - Confucius

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPiONwkrt35x43uEcdZkrsdm3N1FiA%3DEFww9rkGEB2G-P5RqoA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.