Django Mongo Regex query

Question

I'm using django and I need to get some info from my MongoDB using a regular expression.

Running this directly into the mongo shell I get the results that I want:

db.recipe.find({"title.spanish": {"$regex" : /s[aáAÁ]lm[oóOÓ]n/i}})

Im trying to do the same query in django using raw but it is giving me a syntax error that I can't figure out.

recipes = Recipe.objects(__raw__={'title.spanish' : {'$regex' : /s[aáAÁ]lm[oóOÓ]n/i}})

Any suggestions of how can I do this query in django?

Try `recipes = Recipe.objects(__raw__={'title.spanish' : {'$in' : [/s[aáAÁ]lm[oóOÓ]n/i]}})`. — Wiktor Stribiżew, Aug 20 '15 at 20:47
no @stribizhev, everything still the same using $in, any other ideas?? — alex, Aug 20 '15 at 21:31

imarban · Accepted Answer · 2015-08-29T02:35:27.060

You should try the following:

regx = re.compile('s[aáAÁ]lm[oóOÓ]n', re.IGNORECASE)

recipes = Recipe.objects(__raw__={'title.spanish': {'$regex': regx.pattern}})

And verify if objects queryset manager is not adding a filter previously. I usually add all method to model classes (this method returns all the existent documents in the mongo collection) so you could try with that instead objects and verify your results.

Please, let me know if this works for you.

Django Mongo Regex query

1 Answers1

Linked