pymongo 索引的创建，查询，删除

Asimov__

于 2021-02-23 20:58:42 发布

阅读量1.7k

点赞数

分类专栏： mongodb

本文链接：https://blog.csdn.net/qq_41661056/article/details/114002915

版权

mongodb 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

mongo_host="mongodb://"
from pymongo import mongo_client
mc = mongo_client.MongoClient(mongo_host)
auditor = mc.auditor
# find index
hourly_1 = auditor.stat_daily_overall.index_information()
hourly_2=[index for index in auditor.table.list_indexes()]
print(hourly_1)
# {'_id_': {'v': 2, 'key': [('_id', 1)], 'ns': 'auditor.stat_daily_overall'},.........,key:{index,表}}
print(hourly_2)
# [SON([('v', 2), ('key', SON([('_id', 1)])), ('name', '_id_'), ('ns', 'auditor.stat_daily_overall')]),.....,SON()]

# create  index   
create_index= auditor.table.create_index([("timestamp", 1), ('module_name', 1)])

# delete  index
del_index = auditor.table.drop_index('key')