Django get_or_create 与 icontains

Question

我在 get_or_create 调用中使用 icontains 得到了意外结果。

举个例子:

>>>team_name = "Bears"
>>>Team.objects.get(name__icontains=team_name) # returns DoesNotExist as expected
>>>team, created = Team.objects.get_or_create(name__icontains=team_name)
>>>print(created) # Prints True as expected
>>>print(team.name) # Prints an empty string!

为什么这会创建一个名称为空而不是“Bears”的团队？我在这里使用 get_or_create 的原因是，如果后续用户发布类似 "BearS" 的内容，我想获得正确的团队，而不是创建一个大写字母不正确的重复团队.

Answer 1

我认为在这里您应该拆分 get() 和 create() 功能而不是使用 get_or_create()，因为 __icontains 查找仅适用于 get()。

尝试做这样的事情:

>>> team_name = 'Bears'

>>> teams = Team.objects.filter(name__icontains=team_name)
# This will filter the teams with this name

>>> team = teams.first() if teams.exists() else Team.objects.create(name=team_name)
# Now your team is the first element of your previous query (it returns a QuerySet with single element) if it exists
# Otherwise, you create a new Team.