In Python, how do I search a TinyDB database for substrings in the values?

Question

I made a database for a project and I want to be able to search the database for the value but better than just a simple == operation. For example, If someone types in "columbia" for the search, I want the dictionary that has "Columbia University " as the value for the "Affiliation" key for that specific person

tinydb.readthedocs.org/en/latest/usage.html#advanced-queries — user3159253
– user3159253, Commented Dec 27, 2015 at 2:15

msiemens · Accepted Answer · 2019-02-15 15:52:23Z

4

You can search using regular expressions:

>>> db.search(User.name.matches('[aZ]*'))
>>> db.search(User.name.search('b+'))

These correspond to Python's re.match and re.search where the latter searches for an occurenc that may start anywhere in the string.

Alternatively you can use a custom test expression like so:

>>> test_contains = lambda value, search: search in value
>>> db.search(User.name.test(test_contains, 'Columbia'))

For more details, refer to the relevant section of the TinyDB docs.

edited Feb 15, 2019 at 15:52

answered Dec 31, 2015 at 13:41

msiemens

2,3031 gold badge28 silver badges39 bronze badges

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

2 Comments

Aaron Ciuffo Over a year ago

Can you elaborate on the test_contains example? I've tried this as written and I end up with a NameError: name 's' is not defined

msiemens Over a year ago

Thanks for the hint, @AaronCiuffo! The second code example was wrong, it should be fixed now 🙂

Collectives™ on Stack Overflow

In Python, how do I search a TinyDB database for substrings in the values?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related