Mongodb-操纵数组

1、插入元素

> db.test.insert({name:"test1", users:[]})
WriteResult({ "nInserted" : 1 })
> db.test.insert({name:"test2", users:[]})
WriteResult({ "nInserted" : 1 })
> db.test.find({})
{ "_id" : ObjectId("5d66565f64518b43bae72d47"), "name" : "test1", "users" : [ ] }
{ "_id" : ObjectId("5d66566464518b43bae72d48"), "name" : "test2", "users" : [ ] }

• 批量插入

> db.test.update({"name":"test1"}, {$addToSet: {"users":{$each: [{"name":"user11", "age":11}, {"name":"user12", "age":12}]}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.test.find({})
{ "_id" : ObjectId("5d66565f64518b43bae72d47"), "name" : "test1", "users" : [ { "name" : "user11", "age" : 11 }, { "name" : "user12", "age" : 12 } ] }
{ "_id" : ObjectId("5d66566464518b43bae72d48"), "name" : "test2", "users" : [ ] }

• 单个插入

> db.test.update({"name":"test2"}, {$addToSet: {"users":{"name":"user21", "age":21}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.test.find({})
{ "_id" : ObjectId("5d66565f64518b43bae72d47"), "name" : "test1", "users" : [ { "name" : "user11", "age" : 11 }, { "name" : "user12", "age" : 12 } ] }
{ "_id" : ObjectId("5d66566464518b43bae72d48"), "name" : "test2", "users" : [ { "name" : "user21", "age" : 21 } ] }

2、修改元素

> db.test.update({"name":"test1","users.name":"user11"}, {$set: {"users.$.age": 99}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.test.find({})
{ "_id" : ObjectId("5d66565f64518b43bae72d47"), "name" : "test1", "users" : [ { "name" : "user11", "age" : 99 }, { "name" : "user12", "age" : 12 } ] }
{ "_id" : ObjectId("5d66566464518b43bae72d48"), "name" : "test2", "users" : [ { "name" : "user21", "age" : 21 } ] }

3、移除元素

• 批量移除

> db.test.update({"name":"test1"}, {$pullAll: {"users":[{"name":"user11", "age":99}]}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.test.find({})
{ "_id" : ObjectId("5d66565f64518b43bae72d47"), "name" : "test1", "users" : [ { "name" : "user12", "age" : 12 } ] }
{ "_id" : ObjectId("5d66566464518b43bae72d48"), "name" : "test2", "users" : [ { "name" : "user21", "age" : 21 } ] }

• 单个移除

> db.test.update({"name":"test1"}, {$pull: {"users":{"name":"user12", "age":12}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.test.find({})
{ "_id" : ObjectId("5d66565f64518b43bae72d47"), "name" : "test1", "users" : [ ] }
{ "_id" : ObjectId("5d66566464518b43bae72d48"), "name" : "test2", "users" : [ { "name" : "user21", "age" : 21 } ] }