python 操作mongodb

pip install pymongo

 

单行写入

client.school.teacher.insert_one({"name":"李璐"})

多行写入
client.school.teacher.insert_many([
    {"name":"陈刚"},
    {"name":"郭丽丽"}
])

查询多条

teachers = client.school.teacher.find({})
for one in teachers:
    print(one["_id"],one["name"])
print("----------------------------")

查询一条

teacher = client.school.teacher.find_one({"name":"李璐"})
print(teacher["_id"], teacher["name"])

5d63770002712ae609b67e61 Jack
5d64c68516dce5bd516c0de2 李璐
5d64c68516dce5bd516c0de3 陈刚
5d64c68516dce5bd516c0de4 郭丽丽
----------------------------
5d64c68516dce5bd516c0de2 李璐

 

修改

# 修改
# try:
#     # client.school.teacher.update_many({},{"$set":{"role":["班主任"]}})
#     client.school.teacher.update_one({"name":"李璐"},{"$set":{"sex":"女"}})
#     client.school.teacher.update_one({"name": "李璐"},{"$push": {"role": "年级主任"}})
# except Exception as e:
#     print(e)

# 删除
try:
   删除所有
    client.school.teacher.delete_many({})
 删除一条
    client.school.teacher.delete_one({"name":"李璐"})
except Exception as e:
    print(e)

# 分页相关
try:
    teachers = client.school.teacher.find({}).skip(0).limti(10)
    # 过滤重复字段
    teachers = client.school.teacher.distinct("name")
    teachers = client.school.teacher.find({}).sort([("name", -1)])
except Exception as e:
    print(e)