mysql - Python 在 Bottle 中返回一个列表

Question

我有一个来自 mysql 查询的列表，我正试图在我的 bottle 网站上返回它。这可能吗？这是我拥有的:

def create_new_location():

    kitchen_locations = select_location()

    return template('''
        % for kitchen_location in {{kitchen_locations}}:
            <a href="/{{kitchen_location}}/">{{kitchen_location}} Kitchen</a>
            <br/>
        % end''',kitchen_locations=kitchen_locations)

这是我得到的错误。

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/site-packages/bottle.py", line 862, in _handle
return route.call(**args)
  File "/usr/local/lib/python2.7/site-packages/bottle.py", line 1732, in wrapper
rv = callback(*a, **ka)
  File "index.py", line 32, in create_new_location
</form>''',kitchen_locations=kitchen_locations)
  File "/usr/local/lib/python2.7/site-packages/bottle.py", line 3609, in template
return TEMPLATES[tplid].render(kwargs)
  File "/usr/local/lib/python2.7/site-packages/bottle.py", line 3399, in render
self.execute(stdout, env)
  File "/usr/local/lib/python2.7/site-packages/bottle.py", line 3386, in execute
eval(self.co, env)
  File "<string>", line 6, in <module>
TypeError: unhashable type: 'set'

Answer 1

明白了(花了我一段时间......)

 % for kitchen_location in {{kitchen_locations}}:

应该是

 % for kitchen_location in kitchen_locations:

在开头使用 % 时，您不需要 {{}}。

这个错误:

TypeError: unhashable type: 'set'

正在尝试使用集合文字 {{kitchen_locations}} ==>

kitchen_locations 在一个集合中的另一个集合中。因为 set 不可散列，所以你得到了错误