python mongodb 连接池 python如何连接mongodb

1. 安装pymongo包

pip install pymongo

2. 连接和增删改查

2.1 pymongo连接mongoDB

import pymongo
from urllib.parse import quote_plus

# 数据库存连接串
mongo_url = 'mongodb://{0}:{1}@{2}:{3}/?authSource={4}&authMechanism=SCRAM-SHA-1'.format(quote_plus('username'),
                                                                                         quote_plus('password'),
                                                                                         "127.0.0.1", 27017, "databasename")
# 获取mongoclient
mongo_client = pymongo.MongoClient(mongo_url)

# 指定数据库
MONGODB = mongo_client["databasename"]

# 指定Collection
collection = MONGODB["student_info"]

2.2 查询

#查看所有数据

res = list(collection.find({}))
print(res)

#查看第一条name=张三的age
res = collection.find_one({"name": "张三"})
print(res.get("age"))

#or

res = list(collection.find({"$or":[{"name":"张三"},{"name":"王五"}]}))
print(res)

2.3 增加

collection.insert_one({"name": "孙七", "age": 21})
#增加多条
collection.insert_many([{"name": "孙七", "age": 21},{"name": "赵八", "age": 21}])

2.4 修改

collection.update_one({"name": "赵八"}, { "$set ": {"age": 23}})
  collection.update_many({"name": "王五"}, {"$set": {"age": 32}})

2.5 删除

res=collection.delete_one({"name": "赵八"})
  print(res,res.deleted_count)

2.6 limit+skip+sort

res = list(collection.find({}).limit(5).skip(5).sort("_id",pymongo.ASCENDING))
print(len(res), res)

3. 简单修改数据

res = collection.find_one({"name": "李四"})
print(res)
res.get("info")["height"] = 210
res.get("info")["weight"] = 180
res.get("info")["long"] = 22.0
res.get("info")["beauty"] = 94
collection.update_one({"_id": res.get("_id")}, {"$set": res})
res = collection.find_one({"name": "李四"})
print(res)