Query filtering in Django with sqlite

Question

I've tried the following query with Django,

def search(search_text):
    q  = Info.objects.filter(title__contains=str(search_text))
    print q.query

The query that get printed is

SELECT "d"."id", "d"."foo" FROM "d_info" WHERE "d_info"."title" LIKE %hello% ESCAPE '\'

The query fails because the text after LIKE doesn't have quotes around it. The query succeeds when I run the query on the sql prompt with quotes around the text after LIKE like below

SELECT "d"."id", "d"."foo" FROM "d_info" WHERE "d_info"."title" LIKE '%hello%' ESCAPE '\'

How do I get Django to add the quotes around the search_text so that the query succeeds ?

I'm using Djanog with sqlite3

Manoj Govindan · Accepted Answer · 2010-09-04 09:26:06Z

1

I tried this out with Postgresql 8.3. The query is generated without quotes. However executing the filter returns a valid queryset with expected instances. Can you try executing

q = Info.objects.filter(title__contains=str(search_text))
print q.count()

and see if it works?

answered Sep 4, 2010 at 9:26

Manoj Govindan

75.2k21 gold badges138 silver badges142 bronze badges

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

3 Comments

rampr Over a year ago

It isn't different from what I have. Did you mean something else ?

Manoj Govindan Over a year ago

I meant to ask, did you execute the query behind the (lazy) queryset? Print q.count() will tell you if the query fired OK.

rampr Over a year ago

Sorry I missed the 2nd statement, it so turns out the query works within Django, but when asked to print the query and if I execute the same query in a mysql shell or sqlite shell, it doesn't work. Django is probably printing the query wrong.

rampr · Accepted Answer · 2012-06-06 18:56:02Z

0

Posting my comment above as the answer

It so turns out the query works within Django, but when asked to print the query and if I copy the query printed and execute it in a mysql shell or sqlite shell, it doesn't work. Django is probably printing the query wrong

answered Jun 6, 2012 at 18:56

community wiki

rampr

Collectives™ on Stack Overflow

Query filtering in Django with sqlite

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related