Sequelize instance methods not working

Question

I am trying to use Sequelize's instance method to validate a password on login attempt. I have defined the User model as :

var User = sequelize.define('User',{     id:{           type:DataTypes.BIGINT,           autoIncrement: true,           allowNull: false,           primaryKey:true         },     username:{           type:DataTypes.STRING,           unique:true         },     password:{           type: DataTypes.STRING         },     ...   },   {     classMethods:{         associate:function(models){         ...         }       }   },   {     instanceMethods:{         validatePassword:function(password){           return bcrypt.compareSync(password, this.password);         }       }   } );   return User; } 

In my login route I do the following :

• 1) Retrieve username & password from request body
• 2) Check if username exists in database
• 3) If user exists, get user object and compare sent password with hashed password in database using validatePassword method.

Here is the relevant code

var username = req.body.username || ""; var password = req.body.password || ""; models.User.findOne({ where: {username: username} }). then(     function(user) {      if(user){       console.log(user.validatePassword(password));      }  .... 

Each time I try to login I get the following error

[TypeError: user.validatePassword is not a function] 

What am I doing wrong?

Answer 1

I think you are using the sequelize model definition api incorrectly. http://docs.sequelizejs.com/en/latest/docs/models-definition/#expansion-of-models

This is the correct way:

var User = sequelize.define('User',{}, {   classMethods: {     method1: ...   },   instanceMethods: {     method2: ...   } }); 

not like this:

var User = sequelize.define('User',{}, {   classMethods: {     method1: ...   } },{   instanceMethods: {     method2: ...   } }); 

Answer 2

For anyone who's having a similar problem, I ran into the same issue but using Sequelize 5.21.5. According to this article, Sequelize Instance Methods, starting with Sequelize 4.0 and above, you have to use the prototype methodology in order to define instance methods like so:

    // Adding an instance level methods.     User.prototype.validPassword = function(password) {       return bcrypt.compareSync(password, this.password); };