python3 获取mongodb表的索引

说明：此处脚本考虑到mongodb里面数据存储的时区转换，mongodb里面的数据使用的是 "格林威治"时间

#!/usr/bin/python3

import pytz
from pymongo import MongoClient

"""
/usr/bin/pip3 install -Iv pytz -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com;
/usr/bin/pip3 install -Iv pymongo -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com;
"""

tzinfo = pytz.timezone('Asia/Shanghai')
client = MongoClient(
    host="x.x.x.x",
    port=27017,
    tz_aware=True,
    tzinfo=tzinfo
)

for database in client.list_database_names():
    if database == 'admin' or database == 'config' or database == 'local':
        continue
    else:
        db = client[database]
        for doc in db.list_collection_names():
            collection = db[doc]
            print("{0}.{1} index: {2}".format(database, doc, collection.index_information()))