What is the best way to transform an array of string values into numeric values for a Mongoose schema that includes several numeric fields?

Question

What is the best way to transform an array of string values into numeric values for a Mongoose schema that includes several numeric fields?

Having an issue with a MongoDB collection named 'sold' that contains both string and numeric fields.

    const soldSchema = new Schema(
  {
    sku: String,
    hsn: String,
    qty: Number,
    article: String,
    mrp: Number,
    disc: Number,
    taxrate: Number,
    tax: Number,
    total: Number,
    orderid: String,
  },
  { collection: "sold", timestamps: true }
);
const Sold = mongoose.model("sold", soldSchema);
module.exports = { Customer, Stock, Sold, Order };

'Customer', 'Stock', and 'Order' are also defined within the same module.

Data for the sold schema is received from the frontend as an array of objects:

[
  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops',
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  },
  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops',
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  },
  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops',
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  }
]

The above array represents req.body when logged using console.log(req.body).

When all fields in the soldSchema are set to type 'String', data gets inserted successfully in one go.

However, having issues when changing certain fields to Numbers in the schema. Seeking assistance on how to resolve this matter.

async function insertManySold(req, res) {
  let items = req.body;
  try {
    let result = await model.Sold.insertMany(items);
    res.json(result);
  } catch (error) {
    res.json(error);
  }
}

Researching online has not provided a solution so far. Your help would be greatly appreciated.

javascript arrays string mongodb loops

Answer 1

Answer №1

Your previous method may not handle strings with alphabets correctly, as converting them to Number will result in NaN. A better approach is shown below:

const object1 =  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops',
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  }

const data = {}

for (const [key, value] of Object.entries(object1)) {
  
  const temp_value = Number(value)

  // Check for NaN and 0
  data[key] =  temp_value ? temp_value : temp_value == 0 ? 0 : value
  
}

console.log(data);

The alternative code snippet below demonstrates issues that can occur with your initial implementation:

let items=
  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops', // This key contains alphabet characters
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  }

    let data = {}
    for ( let key in items ) {
      data[key] = Number(items[key])
    }
console.log(data)

Answer 2

Your previous method may not handle strings with alphabets correctly, as converting them to Number will result in NaN. A better approach is shown below:

const object1 =  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops',
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  }

const data = {}

for (const [key, value] of Object.entries(object1)) {
  
  const temp_value = Number(value)

  // Check for NaN and 0
  data[key] =  temp_value ? temp_value : temp_value == 0 ? 0 : value
  
}

console.log(data);

The alternative code snippet below demonstrates issues that can occur with your initial implementation:

let items=
  {
    sku: '10005',
    hsn: '3652',
    qty: '3',
    article: 'tops', // This key contains alphabet characters
    mrp: '550',
    disc: '0',
    taxrate: '5',
    tax: '82.50',
    total: '1732.50',
    orderid: '1633515982545'
  }

    let data = {}
    for ( let key in items ) {
      data[key] = Number(items[key])
    }
console.log(data)

Answer 3

Answer №2

When I originally posted this question, my knowledge of JavaScript was very limited and I struggled to think like a programmer. However, the solution is actually quite simple. All you need to do is parse the object (req.body) again by creating a new object and inserting all the values through a loop. Here's how you can achieve that:

let items = req.body;
    let data = {};
    for (let key in items ) {
      data[key] = Number(items[key]);
    }

If req.body contains any numerical values, they will be parsed into numbers and stored in the new object 'data'.

This approach worked for me, but if there are alternative methods to achieve the same result, please feel free to share them with me here.

Thanks.

Answer 4

When I originally posted this question, my knowledge of JavaScript was very limited and I struggled to think like a programmer. However, the solution is actually quite simple. All you need to do is parse the object (req.body) again by creating a new object and inserting all the values through a loop. Here's how you can achieve that:

let items = req.body;
    let data = {};
    for (let key in items ) {
      data[key] = Number(items[key]);
    }

If req.body contains any numerical values, they will be parsed into numbers and stored in the new object 'data'.

This approach worked for me, but if there are alternative methods to achieve the same result, please feel free to share them with me here.

Thanks.

Answer 5

Answer №3

The best approach would be to address this issue directly from the front-end. Otherwise, you will need to convert each known Number key individually, as the Number function will only convert strings with numeric values into Numbers and data with characters into NaN.

Furthermore, since you are currently storing sku, hsn, orderId as Strings, they will be converted into numeric values by the Number function. Therefore, it is highly recommended to handle this conversion directly from the frontend.

Answer 6

The best approach would be to address this issue directly from the front-end. Otherwise, you will need to convert each known Number key individually, as the Number function will only convert strings with numeric values into Numbers and data with characters into NaN.

Furthermore, since you are currently storing sku, hsn, orderId as Strings, they will be converted into numeric values by the Number function. Therefore, it is highly recommended to handle this conversion directly from the frontend.

What is the best way to transform an array of string values into numeric values for a Mongoose schema that includes several numeric fields?

Answer №1

Answer №2

Answer №3

Similar questions

Can I employ a PHP script as a "server" for a React application?

Gather information on a webpage

Toggling Legends in D3.js interactivity

Unable to reset the input value to an empty string

Automated image transition

To modify the text within the pagination select box in ANTD, follow these steps:

We're sorry, but there seems to be an issue with locating the module: 'react-scroll-horizontal'

Is searching for duplicate entries in an array using a specific key?

Calculate the total cost for each row in a table by multiplying the quantity and price using jQuery, then display the result

Create a dynamic HTML table in React by leveraging arrays

Positioning a Three.js static CSS2DObject with respect to the camera's perspective

Using JSON parsing to dynamically create classes with preloaded background images

The loading of charts and animations is sluggish on mobile devices

Is it preferable to include in the global scope or the local scope?

Upgrading from V4 to React-Select V5 causes form submission to return undefined value

Effectively implementing an event observer for dynamically loaded content

Displaying multiple div elements when a button is clickedLet multiple divs be

How can I access my API by connecting Node.js to MongoDB remotely?

React Native encountered an issue loading the configuration for your project

What is the best way to implement CSS in this JavaScript Fetch code in order to manipulate the text's position and font style