pymongo操作MongoDB的基本用法

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)

pymongo操作MongoDB的基本用法

上一篇:各平台下oracle-instant-client安装部署


下一篇:Oracle SQL Developer