MongoDB常用NoSQL

1、导出查询JSON数据

查询语句文件dump.js

db.projectInfo.find({
_id:{$in:['9c84ef7d-3469-442a-9ff4-534cca2a9d89']}
}, { projectId:1,clientName:1,approvalId:1 }).forEach( function(cap){
printjson(cap)
});

cmd执行命令

D:\mongodb_master\bin\mongo 127.0.0.1:27017/test -u test -p 123456 D:\dump.js > D:\result.js

2、清理重复数据

db.projectCompanyProperty.aggregate([
 {$project:{'sourceProjectId':1,'projectId':1,'uKey':1,'dataSource':1}},
    {
        $group: { _id: {'sourceProjectId':'$sourceProjectId',projectId:'$projectId',uKey:'$uKey','dataSource':'$dataSource'},
        count: {$sum: 1},dups: {$addToSet: '$_id'}}
    },
    {
 
        $match: {count: {$gt: 1}}
 
    }
 
]).forEach(function(doc){
 
    doc.dups.shift();
 
    db.projectCompanyProperty.remove({_id: {$in: doc.dups}});
 
})

3、执行插入脚本

mongo 127.0.0.1:27017/test -u user -p 123456 2_init_dict_data.json

4、系统参数查询

mongodb查看连接数：　　db.serverStatus().connections;
mongodb查看同步时间：　　db.printSlaveReplicationInfo();  
mongodb查看oplog分磁盘空间：　　db.printReplicationInfo(); 

5、导出

mongodump -h localhost:27017 --authenticationDatabase admin -d test -u backupUser -p 123456 --gzip -o D:\BACKUP\MongoDB\

6、导入

mongorestore -h localhost:27017 --authenticationDatabase admin -d test -u restoreUser -p 123456 --gzip D:\BACKUP\MongoDB\test

7、用户创建与管理

use admin;  
db.createUser(
   {user:"admin",
    pwd:"123456",
    roles:[{role:"userAdminAnyDatabase", db:"admin"}]
    });

db.updateUser("admin",
  {
    pwd: "654321",  
    roles: ["root","userAdminAnyDatabase","clusterAdmin"]  
  })    

db.auth("admin", "654321");

db.changeUserPassword('admin','123456');

db.dropUser("mongoDBmonitor");

8、创建备份还原用户

db.getSiblingDB('admin').createUser({
    user: 'restoreUser',
    pwd: '123456',
    roles: [
        {
            role: "restore",
            db: "admin"
        }
    ]
})

 
db.getSiblingDB('admin').createUser({
    user: 'backupUser',
    pwd: '123456',
    roles: [
        {
            role: "backup",
            db: "admin"
        }
    ]
})