Python操作MongoDb數(shù)據(jù)庫流程詳解

>zhangsan = {‘name': ‘Zhangsan', ‘a(chǎn)ge': 18, ‘gender': ‘male'}
>db.students.insert(zhangsan)
>lisi = {‘name': ‘Lisi', ‘a(chǎn)ge': 19, ‘gender': ‘male'}
>db.students.insert(lisi)

#! /usr/bin/env python3
# -*- coding:utf-8 -*-

# Author : MaYi
# Blog  : http://www.cnblogs.com/mayi0312/
# Date  : 2019-12-25
# Name  : test01
# Software : PyCharm
# Note  : 應(yīng)用pymongo模塊操作MongoDB數(shù)據(jù)庫
# 導(dǎo)入模塊
import pymongo

# 連接數(shù)據(jù)庫，27017是默認(rèn)端口
client = pymongo.MongoClient("localhost", 27017)
# 獲取數(shù)據(jù)庫
db = client.students

# 打印數(shù)據(jù)集合名稱列表
print(db.collection_names)

# 獲取數(shù)據(jù)集合
res = db.students.find()
print(res)
for item in res:
 # 遍歷數(shù)據(jù)
 print(item)

wangwu = {"name": "Wangwu", "age": 20, "sex": "male"}
# 插入一條記錄
db.students.insert(wangwu)

for item in db.students.find({"name": "Wangwu"}):
 # 指定查詢條件
 print(item)

# 獲取一條記錄
print(db.students.find_one())
print(db.students.find_one({"name": "Wangwu"}))

# 記錄總數(shù)
print(db.students.find().count())

# 刪除一條記錄
db.students.remove({"name": "Wangwu"})

# 創(chuàng)建索引
db.students.create_index([("name", pymongo.ASCENDING)])

# 更新數(shù)據(jù)庫
db.students.update({"name": "Zhangsan"}, {"$set": {"age": 25}})

# 清空數(shù)據(jù)庫
db.students.remove()

# 插入多條數(shù)據(jù)
zhangsan = {"name": "Zhangsan", "age": 20, "gender": "male"}
lisi = {"name": "Lisi", "age": 21, "gender": "male"}
wangwu = {"name": "Wangwu", "age": 22, "gender": "female"}
db.students.insert_many([zhangsan, lisi, wangwu])

# 對(duì)查詢結(jié)果排序
for item in db.students.find().sort("name", pymongo.ASCENDING):
 print(item)

# 入口函數(shù)
if __name__ == '__main__':
 pass