Mongodb更新嵌套文档

[小豪]

RT，弄了很久都没搞出来！！这样格式的数据，怎样可以把idx，inAddr，retAddr都删掉

/* 0 */
{
  "_id" : ObjectId("5108993fd9800a0c708cebc0"),
  "id" : 1,
  "stacks" : [{
      "idx" : 1,
      "inAddr" : 1,
      "retAddr" : 1,
      "module" : 1
    }, {
      "idx" : 2,
      "inAddr" : 2,
      "retAddr" : 2,
      "module" : 2
    }]
}

/* 1 */
{
  "_id" : ObjectId("51089944d9800a0c708cebc1"),
  "id" : 2,
  "stacks" : [{
      "idx" : 1,
      "inAddr" : 1,
      "retAddr" : 1,
      "module" : 1
    }, {
      "idx" : 2,
      "inAddr" : 2,
      "retAddr" : 2,
      "module" : 2
    }, {
      "idx" : 3,
      "inAddr" : 3,
      "retAddr" : 3,
      "module" : 3
    }]
}

/* 2 */
{
  "_id" : ObjectId("5108994ad9800a0c708cebc2"),
  "id" : 3,
  "stacks" : [{
      "idx" : 1,
      "inAddr" : 1,
      "retAddr" : 1,
      "module" : 1
    }, {
      "idx" : 2,
      "inAddr" : 2,
      "retAddr" : 2,
      "module" : 2
    }, {
      "idx" : 3,
      "inAddr" : 3,
      "retAddr" : 3,
      "module" : 3
    }]
}

/* 3 */
{
  "_id" : ObjectId("51089953d9800a0c708cebc3"),
  "id" : 4,
  "stacks" : [{
      "idx" : 1,
      "inAddr" : 1,
      "retAddr" : 1,
      "module" : 1
    }, {
      "idx" : 2,
      "inAddr" : 2,
      "retAddr" : 2,
      "module" : 2
    }, {
      "idx" : 3,
      "inAddr" : 3,
      "retAddr" : 3,
      "module" : 3
    }]
}

/* 4 */
{
  "_id" : ObjectId("5108995cd9800a0c708cebc4"),
  "id" : 5,
  "stacks" : [{
      "idx" : 1,
      "inAddr" : 1,
      "retAddr" : 1,
      "module" : 1
    }, {
      "idx" : 2,
      "inAddr" : 2,
      "retAddr" : 2,
      "module" : 2
    }, {
      "idx" : 3,
      "inAddr" : 3,
      "retAddr" : 3,
      "module" : 3
    }]
}

[strike2368168]

没有找到专门的语法支持这种操作，估计只能检索出来再更新了

[strike2368168]

给你个比较笨的方法，主要看你的数组有多长了，{'$unset':{'stacks.0.idx':1}}这个改变中间的数字，直到把所有的都删完，后面的字段名也要改

[ai_li7758521]

var cursor=db.myCollection.find();

while(cursor.hasNext()){

    var y=cursor.next();  
    for(var i=0;i<y.stacks.length;i++){
    
        delete y.stacks[i].idx;
        delete y.stacks[i].inAddr;
        delete y.stacks[i].retAddr;
    }
    
    db.stacks.save(y);
 }
 
 db.myCollection.find()