premium导入后缀为db_Python 导入txt文件到mongo

先安装pip install mongoengine

参考：python连接mongodb - DachuanZhao的文章 - 知乎 https://zhuanlan.zhihu.com/p/48332798

import mongoengine
import json

MONGODB_HOST = "xxxxxxxxxx"
MONGODB_PORT = 3717
MONGODB_DB = "xxxxxx"
MONGODB_USERNAME = "xxxxxx"
MONGODB_PASSWORD = "xxxxxxx"

conn = mongoengine.connect(
        db = MONGODB_DB,
        host = MONGODB_HOST,
        port = MONGODB_PORT,
        username = MONGODB_USERNAME,
        password = MONGODB_PASSWORD)

db = conn[MONGODB_DB]
db.authenticate(MONGODB_USERNAME,MONGODB_PASSWORD)

coll = db["xxxxxxxxxxxxx"]
print(coll.find_one())

最后可以导入数据

#db = client.test
img = db.img


with open('url.txt','r',encoding='utf-8') as f:
    i =0
    for line in f.readlines():
        #分割数据
        items = line.strip('r').strip('n').split('|')
        print({'img_id':i,'url':items[0],'tyer':items[1]})
        #添加数据
        i +=1
        img.insert({'img_id':i,'url':items[0],'tyer':items[1]})

# 查看 图片id,图片url,图片类型 
# 是否上传成功
for s in img.find():
    print(s)

修改字段名称

比如我想将图片类型tyer 更名为tag

documents_cursor = img.find({})
for document in documents_cursor:
    if 'key' in document.keys():
        _id = document['_id']
        tyer = document['tyer']
        document.pop('tyer')
        document['tag'] = tyer  # 
        ret = img.update_one({'_id': _id}, {"$set": document})
        if ret.modified_count:
            print('rename success')

清空数据库

img.delete_many({})