pymongo操作MongoDB的基本用法[数据库教程]

Z时代
2024-01-10
分类：综合

database

import pymongo
# 连接MongoDB
client = pymongo.MongoClient(host=‘localhost‘, port=27017)
# client = MongoClient(‘mongodb://localhost:27017/‘)
# 指定数据库
db = client[‘test‘]  # db = client.test
# 指定集合
collection = db[‘students‘]  # collection = db.students
# 插入数据 insert_one()、insert_many()
student1 = {
    ‘id‘: ‘20170101‘,
    ‘name‘: ‘Jordan‘,
    ‘age‘: 20,
    ‘gender‘: ‘male‘
}
student2 = {
    ‘id‘: ‘20170202‘,
    ‘name‘: ‘Mike‘,
    ‘age‘: 21,
    ‘gender‘: ‘male‘
}
result = collection.insert_many([student1, student2])
# result = collection.insert_one(student1)
# 查询数据 find_one()、find()
result = collection.find_one({‘name‘: ‘Mike‘})
results = collection.find({‘age‘: {‘$gt‘: 20}})
results = collection.find({‘name‘: {‘$regex‘: ‘^M.*‘}})  # 正则匹配 $regex
# 更新数据 update()
result = collection.update_one({‘name‘: ‘Kevin‘}, {‘$set‘: {‘age‘: 26}})
# condition = {‘name‘: ‘Kevin‘}
# student = collection.find_one(condition)
# student[‘age‘] = 26
# result = collection.update_one(condition, {‘$set‘: student})
# 删除数据 remove()、delete_one()和delete_many()
result = collection.remove({‘name‘: ‘Kevin‘})
result = collection.delete_one({‘name‘: ‘Kevin‘})
result = collection.delete_many({‘age‘: {‘$lt‘: 25}})
# 计数 count()
count = collection.find().count()
# 排序 sort()
results = collection.find().sort(‘name‘, pymongo.ASCENDING)