MongoDB python操作mongodb

àì夳堔傛蜴生んèń 2023-03-01 13:54 35阅读 0赞

### 安装 `PyMongo` ###

pip install pymongo

### 连接数据库 ###

from pymongo import MongoClient
    client = MongoClient()

参数

mongodb://用户名:密码@服务器ip:端口

如指定本地地址

client = MongoClient("mongodb://127.0.0.1:27017")

### 简单使用 ###

from pymongo import MongoClient
    
    client = MongoClient("mongodb://127.0.0.1:27017")
    
    database = client.study
    collection = database.students
    # 也可以这样取
    # database = client['study']
    # collection = database['students']
    
    # 查询所有数据
    data = collection.find()
    
    # 将数据打印输出,类型都是字典dict
    for raw in data:
        print(raw,type(raw))

**对比**

<table> 
 <thead> 
  <tr> 
   <th>mongodb</th> 
   <th>python</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>insertOne</td> 
   <td>insert_one</td> 
  </tr> 
  <tr> 
   <td>insertMany</td> 
   <td>insert_many</td> 
  </tr> 
  <tr> 
   <td>find</td> 
   <td>find</td> 
  </tr> 
  <tr> 
   <td>updateONe</td> 
   <td>update_one</td> 
  </tr> 
  <tr> 
   <td>updateMany</td> 
   <td>update_many</td> 
  </tr> 
  <tr> 
   <td>deleteOne</td> 
   <td>delete_one</td> 
  </tr> 
  <tr> 
   <td>daleteMany</td> 
   <td>delete_many</td> 
  </tr> 
 </tbody> 
</table>

from pymongo import MongoClient
    
    client = MongoClient("mongodb://127.0.0.1:27017")
    
    database = client.study
    collection = database.students
    # 也可以这样取
    # database = client['study']
    # collection = database['students']
    
    # 操作和mongdb差不多
    # mongodb 操作
    # https://blog.csdn.net/sunt2018/article/details/107606374
    data = collection.find(
    	{ "age":{ "$gt":"23"}},
    	)
    
    # 将数据打印输出,类型都是字典dict
    for raw in data:
        print(raw,type(raw))

### 细微不同之处 ###

*  `空值` mongodb 是 null , python 是 None
 *  `布尔值` mongodb 是小写，python True首字母大写
 *  `排序` mongodb 是find().sort(\{“字段”:-1\}),python是 find().sort(字段,-1)
 *  `_id` python 需要使用 bson.ObjectId Object(“54b2fa4x…”)