How to update a field using another field value in MongoDB/Mongoose and node.js

Asked Mar 02 '19 at 13:14

Active Mar 02 '19 at 21:12

Viewed 719 times

I have a collection named Price in MongoDB database, with the fields price, shopLng,shopLat and geoDist. I want, for all the documents of this collection, to update the geoDist field, depending on the shopLat and shopLng fields. The variables geoLat and geoLng are known. I tried that:

await Price.find().snapshot().forEach(function(doc) {
      latmy = doc.shopLat; //tou ekastote shop
      lngmy = doc.shopLng;
      doc.geoDist = latmy + lngmy +geoLat + geoLng;
      doc.save(); 
  });

But if run the code showed above, that is supposed to do the job for all the documents, there must be a problem, because I get this error: TypeError: Price.find(...).forEach is not a function

edited Mar 02 '19 at 13:20

asked Mar 02 '19 at 13:14

nas11

`find()` is asynchronous, that's why you get the error. Move the `forEach` in the callback or use `.then()` – mexo Mar 02 '19 at 13:50
how should I use then? – nas11 Mar 02 '19 at 13:57
`Model.find().then((result) => { result.forEach(...) })` – mexo Mar 02 '19 at 14:01

How to update a field using another field value in MongoDB/Mongoose and node.js

0 Answers0