Django 模型翻译查询回退

问题描述

我正在为多语言网站使用 django 模型翻译.

语言后备在直接读取属性时效果很好.例如，如果当前语言是德语并且我打印 object.title，如果没有定义德语标题，我将看到英文标题.

我希望回退也适用于查询，但事实并非如此.事实上，如果我做类似的事情

results = MyModel.objects.filter(title = 'hello')

如果未设置德语标题，这将不会得到任何结果，而我希望它返回带有英文标题hello"的对象.

我怎样才能做到这一点?

提前致谢.

解决方案

不幸的是，上面的答案是错误的.正确处理这种情况的方法是

<上一页>查询集 = 查询集.filter(Q(Q(Q(title_fr_fr__icontains=search) & ~Q(title_fr_fr=""))|Q(Q(title_en_gb__icontains=search) & Q(title_fr_fr=""))))

其中 fr-fr - 是我们现在使用的语言，而 en-gb - 是我们的默认语言.这意味着让我们获得目标语言标题包含可搜索字符串且目标语言标题为填充(非空)或默认语言标题包含可搜索字符串且目标语言标题为空的那些行.

所以整个示例将如下所示:

from django.db.models import Q###default_lang = settings.LANGUAGE_CODE.replace("-", "_")current_lang = get_language().replace("-", "_")查询集 = 查询集.filter(Q(Q(Q(**{f'title_{current_lang}__icontains': search}) & ~Q(**{f'title_{current_lang}': ""}))|Q(Q(**{f'title_{default_lang}__icontains': search}) & Q(**{f'title_{current_lang}': ""}))))

azuax 答案在某些情况下会给出错误的结果.假设 title_de = 'ABC'，title_en = 'DEF' 和当前语言 de.对于搜索字符串DEF"；我们得到这一行但不应该因为用户看到ABC"

I'm using django modeltranslation for a multi-language site.

Language fallback works good when reading attributes directly. For example, if current language is German and I print object.title, if the German title is not defined I'll see the english title.

I would expect fallback to work also on queries, but that's not true. In fact, if i do something like

results = MyModel.objects.filter(title = 'hello')

this will get no results if the German title is not set, while I would like it to return the object with english title "hello".

How can I make this work?

Thanks in advance.

解决方案

Unfortunately answers above are wrong. The way to handle this case correct is

    queryset = queryset.filter(
        Q(
            Q(Q(title_fr_fr__icontains=search) & ~Q(title_fr_fr=""))
            |
            Q(Q(title_en_gb__icontains=search) & Q(title_fr_fr=""))
        )        
    )

Where fr-fr - is language we are working with now and en-gb - is our default language. This means get us those rows where title on target language contains searchable string AND title on target language is FILLED (not empty) OR where title on default language contains searchable string AND title on target language is empty.

So whole example will be looks like this:

from django.db.models import Q
###
default_lang = settings.LANGUAGE_CODE.replace("-", "_")
current_lang = get_language().replace("-", "_")

queryset = queryset.filter(
    Q(
        Q(Q(**{f'title_{current_lang}__icontains': search}) & ~Q(**{f'title_{current_lang}': ""}))
        |
        Q(Q(**{f'title_{default_lang}__icontains': search}) & Q(**{f'title_{current_lang}': ""}))
        )
    )

azuax answer gives wrong results in some cases. Suppose title_de = 'ABC', title_en = 'DEF' and current language de. And for search string "DEF" we get this row but shouldn't because user see "ABC"