在我的FollowingPageView函数中,我试图根据登录用户的列表过滤帖子。
您将看到配置文件模型有一个" following“字段,该字段捕获配置文件所有者正在跟踪的用户的名称。在我的视图中,我要做的是在"following“中捕获这些用户的名称,然后将它们传递给Post.objects.filter(created_by=user_list),但在本例中,我将只获取该列表中的最后一个用户。我如何迭代"user_list“查询集并将其传递给Post.objects.filter,以便返回该列表中每个用户的帖子?在本例中,我应该在查询集, )中有两个用户。
models.py
class Profile(models.Model):
user = models.OneToOneField(User, null=True, on_delete=models.CASCADE)
bio = models.TextField(null=True, blank=True)
website = models.CharField(max_length=225, null=True, blank=True)
follower = models.ManyToManyField(User, blank=True, related_name="followed_user") # user following this profile
following = models.ManyToManyField(User, blank=True, related_name="following_user") # profile user that follows this profile
def __str__(self):
return f"{self.user}'s' profile id is {self.id}"
def following_users(self):
for username in self.following:
return username
def get_absolute_url(self):
return reverse("network:profile-detail", args=[str(self.id)])
class Post(models.Model):
created_by = models.ForeignKey(User, on_delete=models.CASCADE)
subject = models.CharField(max_length=50)
body = models.TextField(max_length=1000)
timestamp = models.DateTimeField(auto_now_add=True)
likes = models.ManyToManyField(User, blank=True, related_name="posts")
def __str__(self):
return f"{self.created_by} posted {self.body}"views.py
# Following Users
def FollowingPageView(request, pk):
profile = get_object_or_404(Profile, id=pk)
user_list = []
for user in profile.following.all():
user_list.append(user)
posts = Post.objects.filter(created_by=user_list[0])
print(user_list)
paginator = Paginator(posts, 10)
page_number = request.GET.get("page")
page_obj = paginator.get_page(page_number)
try:
if request.method == "GET":
return render(request, "network/follow-posts.html", { "profile": profile, "page_obj": page_obj })
except ValueError:
return render(request, "network:index.html", {"error": ValueError})发布于 2021-02-10 05:46:21
一种方法是使用__in查询。在这里,因为您没有使用user_list做任何其他事情,所以使用内部查询可能会得到最好的结果:
posts = Post.objects.filter(created_by__in=profile.following.all())但请注意链接文档中的性能建议-在您的实际设置上测试它并查看。
可能由于需要distinct()调用,我记不清是什么触发了具有多对多字段的重复记录的可能性。
还有其他方法可以使用字段引用来表达它,例如:
posts = Post.objects.filter(created_by__profile__followed_user=profile.user).distinct() 备份数据库倾向于使用连接而不是子查询来实现这一点,因此它可以具有不同的性能特征。
https://stackoverflow.com/questions/66127086
复制相似问题