mongodb和python交互
一、安装pymongo包
sudo pip install pymongo
二、新增数据:
增加一条:
from pymongo import MongoClient
client = MongoClient(host = '127.0.0.1', port = 27017)
collection = client['test1']['t1']
ret = collection.insert({'name': 'zs', 'age': 30})
print(ret)
批量增加:
from pymongo import MongoClient
client = MongoClient(host = '127.0.0.1', port = 27017)
collection = client['test1']['t1']
item_list = [{'_id': '101{}'.format(i)} for i in range(10)]
t = collection.insert_many(item_list)
for j in t.inserted_ids:
print(j)
三、查询数据
查询一条:
from pymongo import MongoClient
client = MongoClient(host = '127.0.0.1', port = 27017)
collection = client['test1']['t1']
t = collection.find_one({'_id': '1001'})
#t = collection.find_one()
print(t)
查询所有:
from pymongo import MongoClient
client = MongoClient(host = '127.0.0.1', port = 27017)
collection = client['test1']['t1']
t = collection.find()
for i in t: (t是游标,只能遍历一遍)
print(i)
for i in t: //这里不会输出任何数据
print(i) //这里不会输出任何数据
四、更新数据
更新一条:
collection.update_one({'name':'upoo'}, {"$set":{'name':'yyuu'}})
更新全部:
collection.update_many({'name':'upoo'}, {'$set':{'name':'yyuu'}})
五、删除数据
删除一条:
collection.delete_one({'name': 'yyuu'})
删除多条:
collection.delete_many({'name': 'yyuu'})