Mongo嵌套对象数组更新

Question

I'm trying to update a value in a document and i haven't seen an example that shows me what i need to do. Here is how my document looks:

{
    "_id" : ObjectId("5429e8a53150d03d541c7a53"),
    "foo" : {
        "bar" : {
            "0" : {
                "email" : {
                    "0" : "[e-mail]"
                }
            }
        }
    }
}

This is of course not my real object but represents the structure. how do i update [e-mail] to be [e-mail] ?

Also how would i remove this same element?

Also (for bunus points) how would i update this using the php Mongo class?

Answer 1

Ok i figured it out. This is how you do it in the console:

db.test.update({"foo.bar.0.email" : {"0":"[e-mail]"} },{$set:{"foo.bar.0.email.0":"[e-mail]"}});

And this is how you do it in PHP using the Mongo class

$db = new Mongo("connection stuff");

$condition = array('foo.bar.0.email' => array('0' => '[e-mail]'));
$data = array('$set' => array('foo.bar.0.email.0' => '[e-mail]'));

$db->test->update($condition, $data);

I hope this helps someone because it took me several hours to figure this out.