How To Change Datatype String To Number of particular field in collection of mongo using nodejs

Question

[{
      "id": 5f6af7bd3f06d50018f28680,
      "image": "https://images-na.ssl-images-amazon.com/images/I/51FQpz-zY1L._SL1024_.jpg",
      "name": "Mac book",
      "price": "150",
      "description": "Apple MacBook Air",
      "rating": 4,
    },
    {
      "id": 5f6af7bd3f06d50018f28682,
      "image": "https://static.acer.com/up/Resource/Acer/Laptops/Swift_7",
      "name": "Dell Laptop",
      "price": "250",
      "description": "Find solace in your love for riding when you cruise",
      "rating": 4,
    }]

In This I want to Change Datatype Of All Object of json Mongodb which is price.

Actually Price is String But i want to convert it to Number dynamically.

It would help if you could provide some code showing how you are getting the JSON object you provided, and what code in node is "dynamically" handling said JSON. Without that it's hard to provide a good solution that fits your use case. — tengen, Sep 23 '20 at 16:04

score 0 · Accepted Answer · answered Sep 23 '20 at 15:19

0

db.my_collection.find({price: {$exists: true}}).forEach(function(obj) {
  obj.price = new NumberInt(obj.price);
  db.my_collection.save(obj);
});

answered Sep 23 '20 at 15:19

Aditya Sawant

193
1
3

refer : https://stackoverflow.com/questions/4973095/how-to-change-the-type-of-a-field – Aditya Sawant Sep 23 '20 at 15:20
db.my_collection.find(...).forEach is not a function – Aawez Khan Sep 24 '20 at 12:27

Mevlüt EFE · Answer 2 · 2021-08-15T15:46:23.403

0

let data = my_schema.find();
data.map((item) => {
    my_schema.findOneAndUpdate({_id: item._id}, {price: Number(item.price)}})
})

edited Aug 15 '21 at 15:46

answered Aug 12 '21 at 20:28

Mevlüt EFE

21
4

3

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes. – Tyler2P Aug 13 '21 at 12:03

score -1 · Answer 3 · answered Sep 23 '20 at 15:22

-1

If i understand you correctly , you retrieve array of object from db where pricing field is string and after it you need convert it to numbers ?

Why just not store it as number ?
You can convert it use .map function just after retrieve or if you use mongoose you can do it in post hook in same way.

answered Sep 23 '20 at 15:22

Pavlo Kostohrys

181
9

simple i want to sort by price but price is string it cant sort properly advice me – Aawez Khan Sep 24 '20 at 12:21
You are getting Can't cast number when execute insert to db ? – Pavlo Kostohrys Sep 24 '20 at 12:23
If it is already stored in db as string and you need do search by it , as solution you can use aggregation framework , and do projection from string to number as first step and after do search. But my main question why you need store as string in db if price it is number – Pavlo Kostohrys Sep 24 '20 at 12:25
about aggregation ? – Pavlo Kostohrys Sep 25 '20 at 10:04

How To Change Datatype String To Number of particular field in collection of mongo using nodejs

3 Answers3