目录
1.Pymongo 安装
安装pymongo:
pip install pymongo
- PyMongo是驱动程序,使python程序能够使用Mongodb数据库,使用python编写而成;
2.Pymongo 方法
insert_one()
:插入一条记录;insert()
:插入多条记录;find_one()
:查询一条记录,不带任何参数返回第一条记录,带参数则按条件查找返回;find()
:查询多条记录,不带参数返回所有记录,带参数按条件查找返回;count()
:查看记录总数;create_index()
:创建索引;update_one()
:更新匹配到的第一条数据;update()
:更新匹配到的所有数据;remove()
:删除记录,不带参表示删除全部记录,带参则表示按条件删除;delete_one()
:删除单条记录;delete_many()
:删除多条记录;
3.Pymongo 中的操作
查看数据库
from pymongo import MongoClient
connect = MongoClient(host='localhost', port=27017, username="root", password="123456")
connect = MongoClient('mongodb://localhost:27017/', username="root", password="123456")
print(connect.list_database_names())
获取数据库实例
test_db = connect['test']
获取collection实例
collection = test_db['students']
插入一行document, 查询一行document,取出一行document的值
from pymongo import MongoClient
from datetime import datetime
connect = MongoClient(host='localhost', port=27017, username="root", password="123456",)
# 获取db
test_db = connect['test']
# 获取collection
collection = test_db['students']
# 构建document
document = {"author": "Mike", "text": "My first blog post!", "tags": ["mongodb", "python", "pymongo"], "date": datetime.now()}
# 插入document
one_insert = collection.insert_one(document=document)
print(one_insert.inserted_id)
# 通过条件过滤出一条document
one_result = collection.find_one({"author": "Mike"})
# 解析document字段
print(one_result, type(one_result))
print(one_result['_id'])
print(one_result['author'])
注意:如果需要通过id查询一行document,需要将id包装为ObjectId类的实例对象
from bson.objectid import ObjectId
collection.find_one({'_id': ObjectId('5c2b18dedea5818bbd73b94c')})
插入多行documents, 查询多行document, 查看collections有多少行document
from pymongo import MongoClient
from da