MongoDB returns no results in python

Question

Why does mongodb return results in shell but not in python.

Shell:

> db.posts.find({ Body: /html/ }).count()
5524

Python code:

query = {"Body": '/html/'}
r = mo_db.posts.find(query)
print r.count()
> 0

All other queries work fine, just find() works fine. Is there another way to handle slashes?!
I also tested r'/html/' and u'/html/'.

mpobrien · Accepted Answer · 2013-02-11 23:18:14Z

2

You're querying for the value as a string, not an actual regular expression object. The /.../ syntax is javascript syntax sugar for constructing the regex, but in python you need to do it with the re module.

Try this:

import re
pattern = re.compile("html")
query = {"Body": pattern}
r = mo_db.posts.find(query)
print r.count()

answered Feb 11, 2013 at 23:18

mpobrien

4,9621 gold badge35 silver badges36 bronze badges

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

1 Comment

hcorreia Over a year ago

Worked. Thanks man. I thought the /.../ was handled by mongo.

Collectives™ on Stack Overflow

MongoDB returns no results in python

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