Optimal Method for Inserting Lengthy Data using Sequelize

Question

Optimal Method for Inserting Lengthy Data using Sequelize

I have a table containing 20 elements.

Is there a more concise way to input data into Sequelize without listing each element individually like this:

Sequelize.create({
  elem1: req.body.eleme1,
  elem2: req.body.eleme2,
  elem3: req.body.eleme3,
  elem4: req.body.eleme4,
  elem5: req.body.eleme5,
  ..... 
  elem20: req.body.eleme20,
});

Instead, is there a way to simply pass the entire req.body object like so:

Sequelize.create({
  req.body
});

Thank you! :)

mysql angular sequelize.js

Answer 1

Answer №1

When it comes to handling tables with unrelated columns, dividing them into multiple tables and using normalization can be a good approach. Creating associations or using transactions can also help in organizing the data effectively.
If you need to insert 20 records at a time, a more efficient way is to sanitize your data first and then create a separate wrapper for insertion. You can loop through the req.body object and push the data to the wrapper as shown below.

 const data = {}
    Object.keys(req.body).forEach(function(key, index) {
        data[key] = req.body[key]
    //you can perform any other operation on a particular property here
    })
Sequelize.create(data);

Answer 2

When it comes to handling tables with unrelated columns, dividing them into multiple tables and using normalization can be a good approach. Creating associations or using transactions can also help in organizing the data effectively.
If you need to insert 20 records at a time, a more efficient way is to sanitize your data first and then create a separate wrapper for insertion. You can loop through the req.body object and push the data to the wrapper as shown below.

 const data = {}
    Object.keys(req.body).forEach(function(key, index) {
        data[key] = req.body[key]
    //you can perform any other operation on a particular property here
    })
Sequelize.create(data);

Answer 3

Answer №2

Using Sequelize.create({...req.body}) should be effective, but if this is the only thing you are doing, why not just stick with Sequelize.create(req.body) instead?

Answer 4

Using Sequelize.create({...req.body}) should be effective, but if this is the only thing you are doing, why not just stick with Sequelize.create(req.body) instead?

Optimal Method for Inserting Lengthy Data using Sequelize

Answer №1

Answer №2

Similar questions

I wonder what the response would be to this particular inquiry

Running a SQL query using PHP

How can I load a separate component.html file using a component.ts file?

Creating a canvas that adjusts proportionally to different screen sizes

Protected HTTP Live Streaming 128-bit AES encryption key location

Retrieving multiple records from a subquery in MySQL and storing them as an array of objects in a

Is it possible to execute an HTTP request using a functional resolver?

Ensuring type safety at runtime in TypeScript

Guide to making a Material Design Radial effect animation

What is causing the "unable to resolve dependency tree" error when using ng new newApp?

Concealed URL - Navigation with Angular 2 Routing

Is the use of a Backend-for-Frontend necessary when working with a framework such as Angular?

What is the best way to showcase the chosen information?

AngularDart's runtimeType object

Form for creating and updating users with a variety of input options, powered by Angular 2+

Encountering a CORS issue when utilizing passport-facebook for Facebook authentication in my MEAN application

Having issues with autocompletion in the input element of Angular 7 Material Design

Tips for associating an id with PrimeNg menu command

Retrieving the innerHTML or innerText of a structural DOM element generated by *ngFor in Selenium

How can I establish default values for 2 to 3 options in a Dropdownlist?