1.mongodb安装
-
下载和安装
下载地址：https://www.mongodb.com/download-center#community
新建目录：c:\data\db>。（用来存储数据）
从MongoDB目录的bin目录中执行mongod.exe文件。
mongod.exe --dbpath c:\data\db
mongodb成功开启：
默认配置：
host:127.0.0.1
port:27017
- 修改配置
- mongobooster
链接：http://pan.baidu.com/s/1jHHG5zK 密码：3pbi
2.{ read: 'secondaryPreferred' , bufferCommands: false}
//API调用记录
var mongoose = require('mongoose');
mongoose.Promise = require('bluebird');
//API旧库
var conn = mongoose.createConnection("mongodb://");
var apicallhistorySchema = mongoose.Schema({
user_id: { type: String, index: true },
product_name: { type: String },
}, { read: 'secondaryPreferred' , bufferCommands: false});
module.exports = conn.model('apicallhistories', apicallhistorySchema);
secondaryPreferred:读写分离；
bufferCommands：等待太久，没有then，也没有catch，false，等待太久，强制结束，throw err。
3.aggregate管道聚合
var date = new Date('2017-2-22');
var time = new Date('2017-2-1');
db.apicallhistories.aggregate(
[
{ $match : { created_date : { $gt :time ,$lte : date} } },
{$group:{_id :{user_id:"$user_id",method_name:"$method_name",status:"$status"},count:{$sum:1},
totalcost:{$sum:"$cost"},avg_timespent:{$avg:"$time_spent"},max_timespent:{$max:"$time_spent"},min_timespent:{$min:"$time_spent"}
}}
]
)
4.find
- licenses_alls字段存在
db.enterprises.find({licenses_alls:{$elemMatch:{$ne:null}}})
db.enterprises.find({licenses_alls:{$ne:null}})
- licenses_alls字段不存在
db.enterprises.find({judicial_freezes_alls:null})
- licenses_alls字段存在，但是为空数组
db.enterprises.find({judicial_freezes_alls:{"$size":0}})
- 包括null和没有这个字段
db.C.find({"c":null})
- 仅仅null
db.C.find({"c":{"$in":[null],"$exists":true}})
5.update
- 更新满足条件的多条记录
db.batchjobhistories.updateMany({name:"apiHistoriesToOts(test)"},{$set:{milestone:""}},{ multi: true,upsert: false});
-
更新满足条件的一条记录
db.batchjobhistories.update({name:"apiHistoriesToOts(test)"},{$set:{milestone:""}},{ multi: true,upsert: false});
- **更新满足多个件的记录**
var arr = ["56dd8ea15288f730bda692a2",
"56dd8ea15288f730bda692a7",
"56dd8f735288f730bda692a8",
"56dd8f954c6880c8b99787c7"]
db.apiwritefailedhistories.update( { "id" : {$in: arr}} , { $set : { "condition" : "true"} }, {upsert: true} )
#####5.$and、$or
db.enterprises.find({}，{$or: [{resolveStatus: "待处理"}, {resolveStatus: "已完成"}], $and: [{zentao_task_id: {$ne: null}}, {zentao_task_id: {$ne: ""}}]})
