postgresqlsequelize.jsrestify

How insert bulk upload in postgresql using Sequelize?


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)
})

Solution

  • 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.