python操作mongodb

安装

pip install pymongo

插入单条

#!/usr/bin/python3
 
import pymongo

myclient = pymongo.MongoClient('mongodb://账号:密码@ip:27017/')
mydb = myclient["dbname"]
coll = mydb["collectName"]
record={
    'name':'hello',
    'age':22
}
id=coll.insert_one(record)
print(id.inserted_id)#返回保存后的对象

插入多条

#!/usr/bin/python3
 
import pymongo

myclient = pymongo.MongoClient('mongodb://账号:密码@ip:27017/')
mydb = myclient["dbname"]
coll = mydb["collectName"]
records=[
{
    'name':'hello',
    'age':21
},
{
    'name':'world',
    'age':22
}
]
id=coll.insert_many(records)
print(id.inserted_ids)#返回保存后的对象

查询

#!/usr/bin/python3
 
import pymongo

myclient = pymongo.MongoClient('mongodb://账号:密码@ip:27017/')
mydb = myclient["dbname"]
coll = mydb["collectName"]
myquery = { "age": { "$gt": 21 } }
mydoc = coll.find(myquery)
 
for x in mydoc:
  print(x)

修改

#!/usr/bin/python3
 
import pymongo

myclient = pymongo.MongoClient('mongodb://账号:密码@ip:27017/')
mydb = myclient["dbname"]
coll = mydb["collectName"]

myquery = { "name": "hello" }
newvalues = { "$set": { "age": "99" } }
 
x = coll.update_many(myquery, newvalues)
 
print(x.modified_count, "文档已修改")

删除

#!/usr/bin/python3
 
import pymongo

myclient = pymongo.MongoClient('mongodb://账号:密码@ip:27017/')
mydb = myclient["dbname"]
coll = mydb["collectName"]

myquery = { "name": "hello" }
 
x = coll.delete_many(myquery)
 
print(x.deleted_count, "个文档已删除")