这是一个Django项目,我正在try 创建一个愿望列表(多对多不会有帮助,因为我需要DateTime才能在愿望列表中获得想要的项目).
class Client(models.Model):
name = models.CharField(max_length=100)
user = models.ForeignKey(User, on_delete=models.CASCADE)
class Product(models.Model):
name = models.CharField(max_length=100)
price = models.DecimalField()
class WishItem(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE)
client = models.ForeignKey(Client, related_name="wishlist", on_delete=models.CASCADE)
added_at = models.DateTimeField(auto_now_add=True)
我能做的只是:
wishlist = Client.objects.wishlist.select_related('product').all()
wish_products = [item.product for item in wishlist]
但我需要这样的东西,没有循环,只有一个SQL查询和一行
wishlist = Client.objects.wishlist.product.all()
当我试图运行这段代码时,我得到一个错误AttributeError: 'RelatedManager' object has no attribute 'product'