python pymongo找到KeyE

Question

代码如下：

select_sql = 'select url from baidu_v_tbl'
results = cur_oracle.execute(select_sql)
`enter code here`urls = results.fetchall()

  logging.info('start........... ')

  for con in urls:
      url = con[0]
      url_v = ''.join(['https://www.baidu.com/s?wd=', url, '@v'])     mongo_records = db_mongo.keywords.find({'url': url_v},{'url': 1, 'keyword': 1}, no_cursor_timeout=True)

     mongo_keywords = [key['keyword'] for key in mongo_records if key['keyword']]

这是错误：

Traceback (most recent call last):
  File "from_keywords_into_oracle.py", line 44, in <module>
  mongo_keywords = [key['keyword'] for key in mongo_records]
KeyError: 'keyword'

Answer 1

例外是明确的：“keyrerror'keyword'”。在

变量mongo_records是dict对象（或dict-like）的集合，并且至少得到一个没有关键字“keyword”的项。在

可以替换为：

mongo_keywords = [key['keyword'] for key in mongo_records if 'keyword' in key]