How to use Django models in for loop?

Question

Query = 'com pu'
Query = Query.split()
busi = ""
for data in Query:
    busi += Business.objects.filter(Keywords__icontains=data)

When I use '+' symbol after busi variable for add all data according to filter that give error

Exception Type: TypeError

Exception Value:Can't convert 'QuerySet' object to str implicitly

How can I achieve that different Query part which split by that all give different-2 data and and both data in single busi object

Amit · Accepted Answer · 2016-05-16 15:50:33Z

2

from django.db.models import Q
Query = Query.split()
query = Q()
for data in Query:
    query |= Q(keyword_name__icontains=data)
Business= Business.objects.filter(query)

answered May 16, 2016 at 15:50

Amit

1291 silver badge9 bronze badges

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

Comments

sprksh · Accepted Answer · 2016-05-15 12:48:53Z

0

Instead use &:

busi = None

q = Business.objects.filter(Keywords__icontains=data)

if busi is None:
    busi = q
else:
    busi = busi & q

answered May 15, 2016 at 12:48

sprksh

2,4593 gold badges33 silver badges49 bronze badges

2 Comments

Amit Over a year ago

Here what is data and what will you get in q ?What you want try? if busi is None: ?

sprksh Over a year ago

q is the small chunk that you will get for each i (the way you were trying). It is just adding the querrysets. initially busi is naone as you have put empty string. The error you are getting is because of that as you cannot add an string to a queryset (busi).

Collectives™ on Stack Overflow

How to use Django models in for loop?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related