美文网首页我爱编程
pyhon操作MongoDB

pyhon操作MongoDB

作者: 不_一 | 来源:发表于2018-03-07 10:10 被阅读0次

引入

from pymongo import MongoClient

1、链接

client=MongoClient('mongodb://root:123@localhost:27017/')
# client = MongoClient('localhost', 27017)

2、use 数据库

db=client['db2'] #等同于:client.db1

3、查看库下所有的集合

print(db.collection_names(include_system_collections=False))

4、创建集合

table_user=db['userinfo'] #等同于:db.user

5、插入文档

import datetime
user0={
    "_id":1,
    "name":"egon",
    "birth":datetime.datetime.now(),
    "age":10,
    'hobbies':['music','read','dancing'],
    'addr':{
        'country':'China',
        'city':'BJ'
    }
}

user1={
    "_id":2,
    "name":"alex",
    "birth":datetime.datetime.now(),
    "age":10,
    'hobbies':['music','read','dancing'],
    'addr':{
        'country':'China',
        'city':'weifang'
    }
}
# res=table_user.insert_many([user0,user1]).inserted_ids
# print(res)
# print(table_user.count())

6、查找

# from pprint import pprint#格式化细
# pprint(table_user.find_one())
# for item in table_user.find():
#     pprint(item)

# print(table_user.find_one({"_id":{"$gte":1},"name":'egon'}))

7、更新

table_user.update({'_id':1},{'name':'EGON'})

8、传入新的文档替换旧的文档

table_user.save(
    {
        "_id":2,
        "name":'egon_xxx'
    }
)

相关文章

网友评论

    本文标题:pyhon操作MongoDB

    本文链接:https://www.haomeiwen.com/subject/txylfftx.html