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 <antialia...@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
> >
>
signature.asc
Description: PGP signature
