Query Problem

#What can make any(regex) works?
#How to write the query for a list using regex?

For example:
'apple' in {'tags': ['apple','melon','banana']}

db.insert({'tags': ['apple', 'banana', 'melon']})

I tried

db.search(where('tags').any('^apple'))

#output:

[{'tags': ['apple', 'banana', 'melon']}]

when I tried

db.search(where('tags').any('^app'))

#output:

[]

Finally I tried:

db.search(where('tags').any(re.compile('app')))

It failed.

TypeError: argument of type '_sre.SRE_Pattern' is not iterable

Thanks!

sorry for the delayed response! I didn't get around to check the TinyDB forum recently and didn't see this new thread.

Right now there's no direct way to do this in TinyDB besids using a custom test function like this:

db.search(where('tags').any(lambda doc: re.match('^app', doc)))

Feel free to open an issue on GitHub on this, maybe we can add a better API for this ?

Cheers!