Building a query optimization

Question

I'm doing this in my code:

programmes2 = [int(l) for l in g.getlist('programmes2')]
if len(programmes2):
    q = q & Q(personne__programmes2__in=programmes2)

activites2 = [int(l) for l in g.getlist('activites2')]
if len(activites2):
    q = q & Q(personne__activites2__in=activites2)

hobbies2 = [int(l) for l in g.getlist('hobbies2')]
if len(hobbies2):
    q = q & Q(personne__hobbies2__in=hobbies2)

types_permis2 = [int(l) for l in g.getlist('types_permis2')]
if len(types_permis2):
    q = q & Q(personne__types_permis2__in=types_permis2)

personnalites2 = [int(l) for l in g.getlist('personnalites2')]
if len(personnalites2):
    q = q & Q(personne__personnalites2__in=personnalites2)

langues2 = [int(l) for l in g.getlist('langues2')]
if len(langues2):
    q = q & Q(personne__langues2__in=langues2)

I was wondering if it was possible to transform this into something like:

for i in ['hobbies2', 'types_permis2', 'and so on']:
    q = q & Q(personne__i__in=i)  # obviously wrong, not working

Kevin Christopher Henry · Accepted Answer · 2016-06-10 04:11:02Z

1

Sure:

q = Q()
for field in ["hobbies2", "types_permis2", "and so on"]:
    values = [int(l) for l in g.getlist(field)]

    if values:        
        field_query = "personne__{}__in".format(field)
        q = q & Q(field_query=values)

Here's another approach:

fields = ["hobbies2", "types_permis2", "and so on"]
params = {"personne__{}__in".format(field): [int(l) for l in g.getlist(field)]
          for field in fields
          if g.getlist(field)}

result = MyModel.objects.filter(**params)

edited Jun 10, 2016 at 4:11

answered Jun 9, 2016 at 17:03

Kevin Christopher Henry

49.7k8 gold badges125 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Olivier Pons Over a year ago

Perfect! You made my day!

Collectives™ on Stack Overflow

Building a query optimization

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related