amiceli
amiceli

Reputation: 445

MongoAlchemy regex return nothing

I'm testing MongoAlchemy for a project and I've to search user by name.

I'm trying to make a regex but query result is always empty.

I tried two methods :

import re
users = User.query.filter({"name":re.compile("/a/", re.IGNORECASE)}).all()

And :

users = User.query.filter(User.name.regex('/a/', ignore_case=True)).all()

Even if I use a very general regex like /.*/, the result is always empty.

Thank you.

Upvotes: 0

Views: 91

Answers (1)

tobspr
tobspr

Reputation: 8376

In python regular expressions are not defined using /regexp/, this is javascript syntax.

The proper way to initialize regular expressions would be:

re.compile(r".*", re.IGNORECASE)

So you should use:

users = User.query.filter({"name": re.compile(r".*", re.IGNORECASE)}).all()

Upvotes: 1

Related Questions