正如标题所说,我需要一种方法来执行此查询。我尝试了以下方法:
user_list_ids = []
user_lists = []
user_entries = OwnerEntry.objects.filter(name=request.user)
for user in user_entries:
user_list_ids.append(user.list_id)
user_lists = ListEntry.objects.filter(id__in=user_list_ids)
for user in user_entries:
user_list_ids.append(user.list_id)
user_lists = ListEntry.objects.filter(id__in=user_list_ids)
但是,我在最后一行收到错误消息:int() 参数必须是字符串或数字,而不是“ListEntry”
以下是相关模型:
class OwnerEntry(models.Model):
name = models.CharField(max_length=32)
list_id = models.ForeignKey(ListEntry)
class Meta:
ordering = ('name',)
class ListEntry(models.Model):
name = models.CharField(max_length=64)
# active_date = models.DateTimeField('date of last list activity')
expire_date = models.DateField('date of expiration')
create_date = models.DateField('date created')
请您参考如下方法:
要直接回答您的问题,请注意您有一个 list_id 而不是 list 作为外键名称(OwnerEntry 模型)。为了实际提取 fk 值,您应该改用 list_id_id(或将 list_id 重命名为 list ;))
另请注意,django 支持对象引用,如下所示:
someowner = OwnerEntry.objects.get( ... ) ownerslist = someowner.listentry_set.all()
干杯!
