Error with any() and all() Queries

karibul

When I try to make a query with more than one parameter as suggested on the documentation I get the following error:

Traceback (most recent call last):
  File "<pyshell#30>", line 1, in <module>
    db.search(Recipe.ingredients.any(['rice','pork']))
  File "C:\Python27\lib\site-packages\tinydb\database.py", line 382, in search
    if cond in self._query_cache:
  File "C:\Python27\lib\site-packages\tinydb\queries.py", line 48, in __hash__
    return hash(self.hashval)
TypeError: unhashable type: 'list'

That's all I have on the db for this test:
{"name": "test", "servings": "6", "ingredients": ["rice", "pork"]}

PS: As you can see I'm using windows, I don't know if this has something to do with the issue.

msiemens

Hey karibul,

that's definitely unexpected behaviour. A workaround would be to use a tuple in the search query:

 db.search(Recipe.ingredients.any(('rice', 'pork')))

I think I'll have a fix uploaded to GitHub shortly. If no new bug reports come up, I'll release a new version including the fix by the end of this week.

Cheers!

aldrinjohn

The hash() is a built-in python method, used to return a unique number . This can be applied to any user-defined object which won’t get changed once initialized. This property is used mainly in dictionary keys .

TypeError: unhashable type: 'list' usually means that you are trying to use a list as an hash argument. For ex. when you use a list as a key in the dictionary , this cannot be done because lists can't be hashed. The standard way to solve this issue is to cast a list to a tuple .

http://net-informations.com/python/iq/unhashable.htm