描述:格式如下所示,其中每個對象有_id,name,和一個數組scores,其中可以看到修改前的數組中,每個document有兩個type為"homework"的對象。*提問*:問題是如何操縱mongo數據庫,批量修改db.students,讓每個document中,刪除score較小的homework,而保留score較大的homework。修改前:{"_id":100,"name":"DemarcusAudette","scores":[{"score":47.42608580155614,"type":"exam"},{"score":44.83416623719906,"type":"quiz"},{"score":19.01726616178844,"type":"homework"},{"score":39.01726616178844,"type":"homework"}]}修改后:{"_id":100,"name":"DemarcusAudette","scores":[{"score":47.42608580155614,"type":"exam"},{"score":44.83416623719906,"type":"quiz"},{"score":39.01726616178844,"type":"homework"}]}下面附上一段nodejs上跑的代碼(自己寫的,有問題跑不通,作為參考):varMongoClient=require('mongodb').MongoClient;MongoClient.connect('mongodb://localhost:27017/school',function(err,db){if(err)throwerr;varquery={};varcursor=db.collection('students').find(query);cursor.each(function(err,doc){if(err)throwerr;if(doc==null){returndb.close();}/*TODO*/vartarget1=doc.scores[2];vartarget2=doc.scores[3];if(target1
mongodb高級修改問題
眼眸繁星
2019-04-08 11:19:00