CODEWITHSUNDEEP
javascriptnode.jssequelize.js
Muzammil Naseer
Muzammil Naseer

Reputation: 1141

Nodejs sequelize how to get last insert id

I am using Sequelize with nodejs to insert a row in a table,now i want that last inserted id,i want some thing like "mysql_insert_id()", here is my code:

function registerAgent(agent_data,request_key,res,next)
{
  models.agent.create({creator_id: agent_data.userid },  { fields: [ 'creator_id'] }).then(function(user) {
      console.log(user);
    }); 
};

Upvotes: 14

Views: 6125

Answers (1)

WeiYuan
WeiYuan

Reputation: 5992

The create() return the last insert element, so the last id is user.id. Is this for your problem?

function registerAgent(agent_data,request_key,res,next)
{
  models.agent.create({creator_id: agent_data.userid },  { fields: [ 'creator_id'] }).then(function(user) {
      console.log(user.id);
    }); 
};

Upvotes: 7

Related Questions