Adding Multiple Items to an Express Endpoint

Question

Adding Multiple Items to an Express Endpoint

I have a requirement to store multiple objects in my mongo database within an express route. Currently, the process is smooth when I post individual objects (such as ONE casino), as shown below. Instead of repeating this numerous times, I am seeking assistance to do it as a single data dump so I can upload ALL my casinos at once.

Below is the functioning route for posting a single object:

router.post('/post', async (req, res) => {
console.log(req.body);
const casinoData = new Casino({
    casino: req.body.casino,
    table_and_other: req.body.table_and_other,
    poker: req.body.poker,
    slot_machines: req.body.slot_machines,
    total_gaming_win: req.body.total_gaming_win,
    year: req.body.year,
    month: req.body.month,
    combined_date: req.body.combined_date
})

try {
    const newCasino = await casinoData.save()
    res.status(201).json(newCasino)
} catch (err) {
    res.status(400).json({ message: err.message})
}
})

I am aware that using mongoimport could be a more efficient way to handle this, but it also comes with its own set of challenges.

Thank you

javascript database mongodb express mongoose

Answer 1

Answer №1

In agreement with @JDunken's suggestion, one can traverse through the POST body as an array and perform bulk insertion. For efficient processing, utilizing insertMany is recommended. When dealing with a large volume of data, it is advisable to establish a reasonable limit for the number of records per request and execute API calls in batches. Validation can be included, but Mongoose will handle validation based on the defined schema. The approach to handling validation errors is subjective. It is essential to familiarize yourself with the options such as ordered and rawResult.

router.post('/post', async (req, res) => {
  // Precautionary check to ensure req.body is an array, depending on error handling requirements
  const casinos = req.body.filter(input => isValid(input));

  try {
      const insertedCasinos = await CasinoModel.insertMany(casinos, { ordered: false });
      res.status(201).json(insertedCasinos)
  } catch (err) {
      res.status(400).json({ message: err.message})
  }
})

const isValid(input) {
    let valid = true;
    // Implement input validation logic here
    return valid;
}

Answer 2

In agreement with @JDunken's suggestion, one can traverse through the POST body as an array and perform bulk insertion. For efficient processing, utilizing insertMany is recommended. When dealing with a large volume of data, it is advisable to establish a reasonable limit for the number of records per request and execute API calls in batches. Validation can be included, but Mongoose will handle validation based on the defined schema. The approach to handling validation errors is subjective. It is essential to familiarize yourself with the options such as ordered and rawResult.

router.post('/post', async (req, res) => {
  // Precautionary check to ensure req.body is an array, depending on error handling requirements
  const casinos = req.body.filter(input => isValid(input));

  try {
      const insertedCasinos = await CasinoModel.insertMany(casinos, { ordered: false });
      res.status(201).json(insertedCasinos)
  } catch (err) {
      res.status(400).json({ message: err.message})
  }
})

const isValid(input) {
    let valid = true;
    // Implement input validation logic here
    return valid;
}

Adding Multiple Items to an Express Endpoint

Answer №1

Similar questions

Using Angularjs to dynamically generate and submit tables

What is the best way to split an array into smaller chunks?

Showing content based on the route - Angular

Creating a TypeScript generic type for the "pick" function to define the types of values in the resulting object

Unearthing the worth of the closest button that was clicked

What could be causing the Logical Or to fail in my function?

Access a file from a specified route within Express

Setting the default selection in AngularJS based on the URL entered

I managed to pass an array of data to the client using EJS, but I encountered an issue trying to access the array on the client side after adding an index value

Is there a way to verify the presence of a selector in Puppeteer?

``Is there a way to effectively assess the Angular UI-Grid cellTemplate function in the attribute value only when it is displayed

Combining all elements of my application into a single HTML, JS, and CSS file

What are the steps to turn off response data compression in an Express server?

The Interactive Menu Toggler: A jQuery Solution

Utilizing react js computed property to retrieve a state value: A guide

deleting an object from an array in JavaScript

The clearfix feature is ineffective when using AngularJS

I have to convert a JSON string that I received from a server into a particular JavaScript object

JavaScript Navigation Bar Error: The value of 'undefined' is not recognized as an object

Pinchin opts for alternative methods over utilizing the Hammer library for calls