1.安装pymongo
(1)打开python环境shell,执行
pip install pymongo
2.创建客户端
import pymongo
client = pymongo.MongoClient(host = 'localhost', port = 27017, username = 'root', password = '123456')
printf(client)
host:数据库名称
port:对应编号
连接成功则放回一个数据库Client对象(含connect=True)
3.打开数据库
db = client.collection
print(db)
4.显示所有数据库
for name in client.list_database_names():
print(name)
5.插入单条文档数据
def test_insert():
users = client.panyipei.p1
r = users.insert_one({"name":"zs", "age":200, 'sex':'女'})
print(r'\n')
print(r.acknowledged, r.inserted_id)
if __name__=='_main_':
test_insert()
sh删除
import pymongo
client = pymongo.MongoClient(host = 'localhost', port = 27017, username = 'root', password = '123456')
db=client.panyipei
def test_delete():
users = client.panyipei.p1
r = users.delete_one({"name":"zs", "age":200, 'sex':'女'})
print(r.acknowledged, r.deleted_count)
if __name__=='_main_':
test_insert()
修改
def test_update():
users = client.panyipei.p1
r = users.update_one(filter={'name':"zs"}, update = {'$set':{'age':100, 'sex':'女'}})
print(r.acknowledged, r.matched_count, r.modified_count, r.raw_result, r.upserted_id)
if __name__=='_main_':
test_update()
错误发生