如何链接Django的“ in”和“ iexact” queryset字段查找？
问题描述：
我有一个名称列表，例如：
I have a list of names, e.g.:
name_list = ['Alpha', 'bEtA', 'omegA']
当前，我有以下查询集：
Currently I have the following queryset:
MyModel.objects.filter(name__in=name_list)
我希望能够以不区分大小写的方式过滤名称。我的第一个想法是使用 iexact 字段查找，但是它似乎不适用于 in 。如何将 iexact 与 in 字段查找一起用于查询集？还是有执行此查询的替代方法？
I would like to be able to filter the names in a case-insensitive fashion. My first thought was to use the iexact field lookup but it doesn't seem to work with in. How can I use the iexact with the in field lookup for my queryset? Or is there an alternate way to perform this query?
答
这是我的解决方案，它使用Q个对象代替：
Here's my solution, which uses Q objects instead:
name_list = ['Alpha', 'bEtA', 'omegA']
q_list = map(lambda n: Q(name__iexact=n), name_list)
q_list = reduce(lambda a, b: a | b, q_list)
MyModel.objects.filter(q_list)