PYTHON - PYMONGO - Invalid Syntax with $or

Question

I can't seem to get this to work with pymongo it was working before I added the $or option. Am I missing something obvious with this

dataout = releasescollection.find( { $or: [{"l_title":{"$regex": "i walk the line", "$options": "-i"}}, {"artistJoins.0.artist_name":{"$regex": "Johnny Cash", "$options": "-i"}}]}).sort('id', pymongo.ASCENDING).limit(25)

Traceback (most recent call last): File "<stdin>", line 1, in <module> File "discogs.py", line 51 dataout = releasescollection.find( { $or: [{"l_title":{"$regex": "i walk the line", "$options": "-i"}}, {"artistJoins.0.artist_name":{"$regex": "Johnny Cash", "$options": "-i"}}]}) ^ SyntaxError: invalid syntax

Running the below directly in mongo works but I'm missing something in the switchover to python

db.releases.find( { $or: [{"l_title":{"$regex": "i walk the line", "$options": "-i"}}, {"artistJoins.0.artist_name":{"$regex": "Johnny Cash", "$options": "-i"}}]}).sort({'id':1}).limit(25)

Caaguazu · Accepted Answer · 2018-03-10 01:14:44Z

8

Should've relized this far sooner, once I added the $or it needs to be in quotes. So this works:

dataout = releasescollection.find( { "$or": [{"l_title":{"$regex": "i walk the line", "$options": "-i"}}, {"artistJoins.0.artist_name":{"$regex": "Johnny Cash", "$options": "-i"}}]}).sort('id', pymongo.ASCENDING).limit(25)

answered Mar 10, 2018 at 1:14

Caaguazu

1138 bronze badges

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

1 Comment

Erdem Tuna Over a year ago

You found the solution but, for those who will explore this in the future, quotes must enclose the $orexpression as indicated in the documents.

Collectives™ on Stack Overflow

PYTHON - PYMONGO - Invalid Syntax with $or

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related