Generate a django queryset based on dict keys

Question

I have a dict like:

{
    'key1' : val1,
    'key2' : val2
}

And I need a queryset like

Q(key1__icontains = val1) | Q(key2__icontains = val2)

Thanks

score 8 · Accepted Answer · answered Mar 18 '11 at 10:51

8

reduce(operator.or_, Q(**{key + '__icontains': val}) for (key, val) in D.iteritems())

answered Mar 18 '11 at 10:51

Ignacio Vazquez-Abrams

776,304
153
1,341
1,358

What do the double asterisks mean? – Alexander Bird Jul 29 '11 at 14:53
@Thr4wn: [Keyword expansion.](http://docs.python.org/tutorial/controlflow.html#unpacking-argument-lists) – Ignacio Vazquez-Abrams Jul 29 '11 at 20:07

vmassuchetto · Answer 2 · 2011-03-18T12:06:36.530

1

There's a more pragmatic approach, as I need to generate various keys from one.

query = None
for key, value in d.iteritems():
    if query is None:
        query = Q(**{key + "__icontains" : value})
    else:
        query |= Q(**{key + "__icontains" : value})

edited Mar 18 '11 at 12:06

answered Mar 18 '11 at 11:04

vmassuchetto

1,529
1
20
44

Generate a django queryset based on dict keys

2 Answers2

Linked