pymongo : find query with regex

Question

I am working on a python script to connect to mongodb and query a collection.

I want to find the values for key hp that start with cdl. This query successfully runs when I try through mongo shell but through my python script I see the error.

Do I need to have any escape characters ?

./pymongoconn.py

File "./pymongoconn.py", line 20

for response in conn.collection.find({"hp": /^cdl/},{"n":1 ,"hp":1 , "_id":0 , "rsid" :1, "v":1}):                                         

^   

SyntaxError: invalid syntax

Below is my query :

for response in conn.collection.find(
    {"hp": /^cdl/},
    {"n":1 ,"hp":1 , "_id":0 ,"rsid" :1, "v":1}
):
    print (response)

Dmitrii Sidenko · Accepted Answer · 2019-06-26 09:15:11Z

2

Use re.compile:

import re
cdl= re.compile("^cdl", re.IGNORECASE)
for response in conn.collection.find(
  {"hp": cdl},
  {"n":1 ,"hp":1 , "_id":0 ,"rsid" :1, "v":1}
):
  print (response)

edited Jun 26, 2019 at 9:15

Dmitrii Sidenko

6686 silver badges20 bronze badges

answered Feb 8, 2018 at 2:44

anhlc

14.6k4 gold badges38 silver badges42 bronze badges

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

Comments

Dmitrii Sidenko · Accepted Answer · 2019-06-26 09:15:30Z

1

I think your syntax is slightly wrong for a $regex in pymongo.

Try:

 conn.collection.find(
   {"hp": {"$regex": "^cdl"}}, 
   {"n":1 ,"hp":1 , "_id":0 ,"rsid" :1, "v":1}
 )

You could also add in $option into the $regex. If you wanted case insensitive;

conn.collection.find({"hp": {"$regex": "^cdl", "$options": "i"}}))

You have all the options available as per mongo $regex, here

edited Jun 26, 2019 at 9:15

Dmitrii Sidenko

6686 silver badges20 bronze badges

answered Feb 8, 2018 at 19:36

user9251303

Collectives™ on Stack Overflow

pymongo : find query with regex

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related