How insert bulk upload in postgresql using Sequelize?

Question

I use Sequelize to write ORM queries in nodejs, but now i want to insert data in bulk format from Data.js file which contains data , But i getting error in my console error: ......... Executing (default): SELECT 1+1 AS result not inserted...ReferenceError: myusers is not defined so tell me how to solve this?

const restify=require('restify')
const server=restify.createServer()
const Data=require('./Data')
//connection with database
const Sequelize=require('sequelize')
const connection = new Sequelize('emadb', 'postgres', 'Groot@2498', {
    host: 'localhost',
    dialect:  'postgres' 
  });
connection
.sync({
    logging:console.log('.........')
})
.then(()=>{
    myusers.bulkCreate(Data)
    server.listen(8080,function(){
        console.log('insert info server started')
    })
})
.catch(err=>{
    console.log('not inserted...'+err)
})

Adrian Klaver · Accepted Answer · 2020-07-25 15:06:50Z

0

The error:

ReferenceError: myusers is not defined

is pretty specified You have:

myusers.bulkCreate(Data)

but I (nor the program) don't see anywhere you define myusers before you use it.

answered Jul 25, 2020 at 15:06

Adrian Klaver

20.3k3 gold badges24 silver badges40 bronze badges

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

2 Comments

Prathamesh Jadhav Over a year ago

myusers is table in my postgresql database

Adrian Klaver Over a year ago

That may be so, but the program has to know about it. I'm not that familiar with Sequelize, but it uses models to map database tables: Models. Usage. So you need to make the program aware of the model you are using in order to get at the bulkCreate() on the model.

Collectives™ on Stack Overflow

How insert bulk upload in postgresql using Sequelize?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related