import csv
from pymongo import MongoClient
# 建立mongo连接
client = MongoClient('192.11.11.11', 27017)
# client.数据库名
db = client.Flight
# 用户名密码认证
db.authenticate('11', '1@1')
#表名字
collection = db['test']
#子查询前10项
# results = collection.find().limit(10)
results=collection.find()
# <class 'pymongo.cursor.Cursor'> results
print(type(results))
with open('result.csv','w',encoding='utf-8',newline='') as csvfile:
fieldname = ['website','if_mobile']
write = csv.DictWriter(csvfile,fieldnames=fieldname)
write.writeheader()
for result in results:
# result是一个字典类型,依次取出我们的每一个值
website = result['website']
if_moblie = result['if_mobile']
write.writerow(
{'website':website,'if_mobile':if_moblie
})
client.close()
read_from_mongo_to_csv
最新推荐文章于 2022-03-05 16:48:34 发布