實驗一 新建mogodb的庫

import pymongo
from pymongo import MongoClient
# client=MongoClient("localhost",27017) #和下面一行二選一
client = MongoClient("mongodb://localhost:27017/")
for i in range(2,30):#操作數(shù)據(jù)庫
    db=client["ccf1"]#新建集合
    db["ccf23"].insert({"KEasYS":2874435})#集合中建立關(guān)系表
dblist = client.list_database_names()#數(shù)據(jù)集合名字
if "ccf1" in dblist:
  print("數(shù)據(jù)庫已存在！")
client.close

實驗二 插入集合
2.1插入一個數(shù)據(jù)

#!/usr/bin/python3
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mydict = { "name": "WV", "AREA": "嘉定"}#支持中文
x = mycol.insert_one(mydict) #返回這個數(shù)據(jù)的id，id是全局唯一變量
print(x)

2.2插入多個數(shù)據(jù)

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mylist = [
    { "name": "WV", "AREA": "中國"},
    { "name": "WV", "AREA": "SH"},
    { "name": "WV", "AREA": "安亭"},
    { "_id":"12345","name": "WV", "AREA": "待定","投資":"1000W"}#指定id，可以是字符串也可以是數(shù)字；存儲的數(shù)據(jù)可以結(jié)構(gòu)不一樣
]
x = mycol.insert_many(mylist)
print(x.inserted_ids)

實驗三 數(shù)據(jù)檢索
3.1檢索單個數(shù)據(jù)

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mylist = [
    { "name": "WV", "AREA": "中國"},
    { "name": "WV", "AREA": "SH"},
    { "name": "WV", "AREA": "安亭"},
    { "name": "WV","part":"榮威 RX5", "AREA": "待定","投資":"1000W"}
]
x = mycol.insert_many(mylist)
print(x.inserted_ids)
print(mycol.find_one())#本數(shù)據(jù)庫的第一個數(shù)據(jù)

3.2檢索所有數(shù)據(jù)

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mylist = [
    { "name": "WV", "AREA": "中國"},
    { "name": "WV", "AREA": "SH"},
    { "name": "WV", "AREA": "安亭"},
    { "name": "WV","part":"榮威 RX5", "AREA": "待定","投資":"1000W"}
]
x = mycol.insert_many(mylist)
print(x.inserted_ids)
for i in mycol.find():#打出所有數(shù)據(jù)
  print(i)
  print(i["name"])#用關(guān)鍵字打出對應(yīng)的鍵值

3.3檢索指定字段的數(shù)據(jù)

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mylist = [
    { "name": "WV", "AREA": "中國"},
    { "name": "WV", "AREA": "SH"},
    { "name": "WV", "AREA": "安亭"},
    { "name": "WVg","part":"榮威 W5", "AREA": "待定","投資":"1000W"}
]
x = mycol.insert_many(mylist)
for x in mycol.find({"part":{"$regex": "R"}}):#加入正則表達式
  print(x)

for x in mycol.find({"part":"榮威"}):#加入限定條件，只要part中包括榮威就會被列出
  print(x)

for x in mycol.find({},{ "_id": 0, "part": 1, "投資": 1 }):#檢測關(guān)鍵字存在
  print(x)

myresult = mycol.find().limit(3)#反饋前三條
for x in myresult:
    print(x)

實驗四 改數(shù)據(jù)
4.1修改所有匹配到的記錄

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
myquery = { "name": "WV","part":"榮威 RX5" }#檢索篩選條件
newvalues = { "$set": { "AREA": "嘉定" } }#替換的數(shù)據(jù)
x = mycol.update_many(myquery, newvalues)#替換觸發(fā)

4.2修改單條記錄

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
myquery = { "name": "WV","part":"榮威 RX5" }#檢索篩選條件
newvalues = { "$set": { "AREA": "揚州" } }#替換的數(shù)據(jù)
mycol.update_one(myquery, newvalues)#替換觸發(fā)，只修改遇到的第一條數(shù)據(jù)
# 輸出修改后的  "sites"  集合
for x in mycol.find():
  print(x)

實驗五 排序
5.1

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mydoc = mycol.find().sort("part",-1)#按照part的值倒敘排序，值相同的比較_id
for x in mydoc:
  print(x)

實驗六 刪除數(shù)據(jù)
6.1刪除單個字段

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
myquery = { "AREA": "anting" }
mycol.delete_one(myquery)
for x in mycol.find():
  print(x)

6.2刪除所有字段

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
myquery = { "AREA": "anting" }
mycol.delete_many(myquery)
for x in mycol.find():
  print(x)

6.3刪除集合

#!/usr/bin/python3 
import pymongo
myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["saic"]
mycol = mydb["sites"]
mycol.drop()