gpt4 book ai didi

django 外键包含查询

转载 作者:行者123 更新时间:2023-12-04 03:18:11 26 4
gpt4 key购买 nike

我有以下型号

class Command(models.Model):
server = models.ForeignKey(Server)
user_login = models.CharField(max_length=100)
user_run = models.CharField(max_length=100)
host = models.CharField(max_length=100)
ip = models.CharField(max_length=100)
session = models.CharField(max_length=100)
command = models.TextField()
ts = models.DateTimeField(auto_now_add=True)
version = models.CharField(max_length=100)
type = models.CharField(max_length=100)

我有以下搜索查询
cmds = Command.objects.filter(Q(user_login__contains=form.cleaned_data['loguser']),
Q(user_run__contains=form.cleaned_data['runuser']),
Q(host__contains=form.cleaned_data['loghost']),
Q(command__contains=form.cleaned_data['command']),
Q(server__contains=form.cleaned_data['host']),
Q(session__contains=form.cleaned_data['session'])) \
.order_by('-id')[:100]

我需要通过以下字符串搜索 server.host

如果我尝试添加以下内容,则会出现错误
Q(server__contains=form.cleaned_data['host']),

Exception Type: TypeError
Exception Value:

Related Field has invalid lookup: contains

Exception Location: /usr/lib/python2.5/site-packages/django/db/models/fields/related.py in get_db_prep_lookup, line 156

form.cleaned_data['host'] 将包含主机名的文本字符串。

最佳答案

server__searchfieldname__contains

您没有指定应该查找服务器表中的哪个字段。

关于django 外键包含查询,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/773262/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com