While trying to save data from server side into MySql database, throws UnhandledPromiseRejectionWarning: TypeError:

Question

Using Express in server side and Axios to send res calls. While trying to save data into MySql database, I am getting below error in console: Using sequelize.js for model/schema creation.

Error:

(node:23364) UnhandledPromiseRejectionWarning: TypeError: this.build(...).save is not a function
    at Function.create (C:\Main\Work\devchoice\node_modules\sequelize\lib\model.js:2228:8)
    at CsvParser.<anonymous> (C:\Main\Work\devchoice\src\server.js:289:60)
    at CsvParser.emit (events.js:315:20)
    at endReadableNT (_stream_readable.js:1220:12)
    at processTicksAndRejections (internal/process/task_queues.js:84:21)
(node:23364) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function
without a catch block, or by rejecting a promise which was not handled with .catch()

server.js

const manageNomineesSchema = require('./server/models/managenominees');
const ManageNomineesModel  = manageNomineesSchema(sequelize, DataTypes);

    app.post('/service/managenominees', upload.single('file'), async (req, res, next) => {
      try {
        if(req.file){
          let filePath = req.file.path;
          fs.createReadStream(filePath)
              .pipe(csv())
              .on('data', (data) => results.push(data))
              .on('end', async () => {
                console.log(results);
                let manageNominees = await ManageNomineesModel.create(results);
                //res.status(200).send(manageNominees);
                res.status(200).json({ message: "Nominees inserted successfully !"});
              });
          }
    
      } catch (e) {
        res.status(500).json({ fail: e.message });
      }
    });

Emma · Accepted Answer · 2021-08-06 00:19:23Z

1

.create takes an object as an argument to create 1 instance, however, you are passing an array of objects.

If you would like to insert everything in the array, use .bulkCreate.

ref: https://sequelize.org/master/class/lib/model.js~Model.html#static-method-bulkCreate

answered Aug 6, 2021 at 0:19

Emma

9,5781 gold badge22 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

soccerway Over a year ago

Thank you very much Emma, it worked out well, upvoted and accepted!

Emma Over a year ago

bulkCreate can be also used to update. stackoverflow.com/a/54900639/2956135

soccerway Over a year ago

I have tried the same way, but no luck yet, it’s inserting the same records again.

Emma Over a year ago

Have you added PK value to the object in array and use updateOnDuplicate?

soccerway Over a year ago

I have tried as per the example:’ await ManageNomineesModel.bulkCreate(allNominees,{ updateOnDuplicate: ["name"] })’

|

Collectives™ on Stack Overflow

While trying to save data from server side into MySql database, throws UnhandledPromiseRejectionWarning: TypeError:

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related