mongo

导入导出

mongodb导出

./mongoexport --db ***db  -c dingdianbookcoll -o ***coll.json

mongodb导入

mongoimport   -d ***db  -c ***coll --file ***coll.json   --type json

新增字段

from utils.config import MONG_CONN

testdb = MONG_CONN['test']
peoplecol = testdb["people"]

icount=0
for item in peoplecol.find():
    icount+=1
    print(item)
    peoplecol.update({"_id":item['_id']},{"$set":{"last_chapter":str(icount)+item['name']}})

是否存在

db.users.find({age: {$exists: true}});

修改列名

db.getCollection('***col').update({},{$rename:{"Id":'Uid'}},false,true)

db.tickets.renameCollection(“tickets_bak20130510”);

service mongod stop
checkconfig mongod on

db.***rcol.aggregate([{'$group':{
                                    '_id':{'Bid' :'$Bid','Cid' :'$Cid'},
                                    'uniqueIds':{'$addToSet':'$_id'},
                                    'count':{'$sum':1}
                            }},
                            {'$match':{'count':{'$gt':1} 
                            }}],
                           {allowDiskUse:true}
                        )

db.***col.aggregate([
    {
        $group: { _id: {Bid: '$Bid',Cid: '$Cid'},count: {$sum: 1},dups: {$addToSet: '$_id'}}
    },
    {
        $match: {count: {$gt: 1}}
    }
],{ allowDiskUse: true }).forEach(function(doc){
    doc.dups.shift();
    db.***rcol.remove({_id: {$in: doc.dups}});
})

修改数据库的collection名

db.adminCommand({renameCollection: "db.collection1", to: "db.collection2"})

mod批量更新

db.jiastonbooklistcol29.update({Uid:{$mod:[8,0]}},{$set:{"hostname":"***08"}},false,true)