获取类型错误：在将数据插入 postgres 时，列表索引必须是整数或切片，而不是字符串

问题描述

我正在尝试使用列表理解和 morgify 将数据推送到 postgres 中，但是我收到了错误。

实际上，排序是以下格式的字典：

sort = {'forecast': [{'name': some_value, 'search_volume': some_int_value, 
'competition': some_float_value}]}

data_text = ','.join(c.mogrify(
    "(%(k)s,%(l['name'])s,l['search_volume'],l['competition'])",
    l) for l in [v for k,v in sort.items()])

错误：

Traceback (most recent call last):
  File "/Users/lonewolf/PycharmProjects/seo_keyword_research_tools-master/keyword_expansion_tool.py", line 137, in get_lsi
    expand(current_word)
  File "/Users/lonewolf/PycharmProjects/seo_keyword_research_tools-master/keyword_expansion_tool.py", line 121, in expand
    sorted_data = write_to_file(current_results, current_word)
  File "/Users/lonewolf/PycharmProjects/seo_keyword_research_tools-master/keyword_expansion_tool.py", line 107, in write_to_file
    l) for l in [v for k,v in sort.items()])
  File "/Users/lonewolf/PycharmProjects/seo_keyword_research_tools-master/keyword_expansion_tool.py", line 107, in <genexpr>
    l) for l in [v for k,v in sort.items()])
TypeError: list indices must be integers or slices, not str