一,通过pymongodb连接数据库
import pymongo
settings = {
"ip":"127.0.0.1",
"port":27017,
"user":"root",
"password":"123456",
"db_name":"admin@CPA_RF",
"table_name":"testCollection",
}
if __name__ == '__main__':
client = pymongo.MongoClient(settings.get("ip"),settings.get("port"))
client[settings.get("db_name").split("@")[0]].authenticate(settings.get("user"),settings.get("password"))
myset = client['CPA_RF']['testCollection']
data = myset.find(filter={'name':'python'})
print(data)
for cur in data:
print(cur)
pipelines = [{'$group':{'_id':'$name','price':{'$last':'$price'}}}]
data = myset.aggregate(pipelines)
for cur in data:
print(cur)
client.close()
print("ok")
二,通过django里的mongoengine
import mongoengine
class ReportData(mongoengine.Document): #代表collection
name = mongoengine.StringField(max_length=32)
conn = mongoengine.connect(db='CPA_RF',username='root',password='123456',authentication_source='admin')
ReportData.objects.create(name='java')
print("ok")