CODEWITHSUNDEEP
regexmongodbpymongo
Sam
Sam

Reputation: 259

MongoDB/PyMongo: how to 'escape' parameters in regex search?

I'm using pymongo and want to do a search for items starting with a certain sequence of characters. I might implement that like this:

items = collection.find({ 'key': '/^text/' })

This should work, but what if text is a variable? I could do something like:

items = collection.find({ 'key': '/^' + variable + '/' })

But now if the text in variable contains any characters with special regex meaning (such as $), the query no longer behaves as expected. Is there a way to do some sort of parameter binding? Do I have to sanitize variable myself? Is that even reliably possible?

Thanks!

Upvotes: 9

Views: 6003

Answers (2)

Salvador Dali
Salvador Dali

Reputation: 222491

Here is the concept: you have to use regex 

items = collection.find({
     'key' : {
         $regex : yourRegex
     }
})

Upvotes: -3

JohnnyHK
JohnnyHK

Reputation: 311855

You have to assemble the regex programmatically. So either:

import re
regex = re.compile('^' + re.escape(variable))
items = collection.find({ 'key': regex })

OR

items = collection.find({'key': { '$regex': '^' + re.escape(variable) }})

Note that the code uses re.escape to escape the string in case it contains special characters.

Upvotes: 13

Related Questions