convert type before matching in query about tinydb

[msiemens]

Hey @LeiYangGH,

I think you can use the map() query operator here:

db.search(where('num').map(int) > 0)

This assume that all num fields are numbers or strings that represent numbers. Otherwise, you can cast to a default value like NaN:

db.search(where('num').map(lambda x: int(x) if isinstance(x, int) or x.isnumeric() else float('nan')) > 0)

Does that work for you?

[LeiYangGH]

i think map works, thanks!

[msiemens]

Awesome 🙂