如何通过代码操作数据库,需要了解这些知识
1.连接mongodb的服务,创建mongodb的连接对象.
import pymongo
client = pymongo.MongoClient(host='localhost',port=27017')
或者 client = MongoClient('mongodb://localhost:27017/')
2.指定数据库
db=client['test']
3.指定集合
collection = db['student']
4.插入数据
test = {"name":"张三","age":"10"}
result = collection.insert(test)
如果插入多条数据
lis = [ {"name":"张三","age":"10"}, {"name":"zhangsan","age":"10"}]
result = collection.insert_many(lis)
5.查询数据
result = collection.find_one({"name":"张三"});
6.进行正则匹配查询
result = collection.find({"name":{"$regex":"^M.*}});
7.插入数据的时候可能报错,解决MongoDB中出现E11000 duplicate key error collection: blog.users index问题
重写_id,并保证不重复
import time
import hashlib
def create_id():
m = hashlib.md5()
m.update(bytes(str(time.clock()), encoding="utf-8"))
return m.hexdigest()
write_db_result["_id"] = create_id()
查看的网址的有https://blog.csdn.net/sinat_36188088/article/details/108476565