python - 由于类型错误 : not enough arguments for format string，无法创建索引

Question

我正在尝试使用 pymongo 创建索引，但因错误而失败

File "D:/Users/Dims/Design/EnergentGroup/Python GIS Developer/worker/Approach03\sentinel\mongo.py", line 46, in get_results_collection
    results_collection.create_index(["uwi", "date_part"], name=index_name, unique=True)
  File "C:\Anaconda3\lib\site-packages\pymongo\collection.py", line 1386, in create_index
    name = kwargs.setdefault("name", helpers._gen_index_name(keys))
  File "C:\Anaconda3\lib\site-packages\pymongo\helpers.py", line 49, in _gen_index_name
    return _UUNDER.join(["%s_%s" % item for item in keys])
  File "C:\Anaconda3\lib\site-packages\pymongo\helpers.py", line 49, in <listcomp>
    return _UUNDER.join(["%s_%s" % item for item in keys])
TypeError: not enough arguments for format string

显然，在创建默认索引名称的代码中库内部发生了错误，即

def _gen_index_name(keys):
    """Generate an index name from the set of fields it is over."""
    return _UUNDER.join(["%s_%s" % item for item in keys])

显然不正确。

我的代码如下:

index_name = 'uwi_date_part'
if index_name not in index_information:
    print("Creating index '%s'..." % index_name)
    results_collection.create_index(["uwi", "date_part"], name=index_name, unique=True)

index_name = 'uwi'
if index_name not in index_information:
    print("Creating index '%s'..." % index_name)
    results_collection.create_index("uwi", name=index_name, unique=False)

如何克服？

Answer 1

此语法不是 PyMongo 所需要的:

results_collection.create_index(["uwi", "date_part"], name=index_name, unique=True)

您想要“uwi”和“date_part”这两个字段的索引吗？仔细选择字段索引的顺序(请参阅 Optimizing MongoDB Compound Indexes )以及是否按升序或降序对它们进行索引。

如果您想按升序索引“uwi”和“date_part”，请执行以下操作:

results_collection.create_index([("uwi", 1), ("date_part", 1)], name=index_name, unique=True)

For more info on creating indexes with PyMongo, see the documentation .