Can someone help me understand how to use instance methods in Sequelize? I've reviewed the documentation but have found it to be sparse. At present, I am trying to use setPassword and verifyPassword instance methods on my user model. When I try to call the code in the REPL, after having imported the user model and synced the DB, I get the following:
> models.User.setPassword('test');
TypeError: Object [object Object] has no method 'setPassword'
Here is the code for the user model:
var bcrypt = require('bcrypt');
module.exports = function(sequelize, DataTypes) {
return sequelize.define('User', {
email: { type: DataTypes.STRING, unique: true, allowNull: false, validate: { isEmail: true } },
password: { type: DataTypes.STRING, allowNull: false},
firstName: {type: DataTypes.STRING},
lastName: {type: DataTypes.STRING},
companyName: {type: DataTypes.STRING},
admin: {type: DataTypes.BOOLEAN, allowNull: false, defaultValue: false,},
forgotUrl: {type: DataTypes.STRING, unique: true},
forgotDate: {type: DataTypes.STRING},
lastLogin: {
type: DataTypes.DATE,
defaultValue: DataTypes.NOW
}
}, {
paranoid: true,
instanceMethods: {
setPassword: function(password, done) {
return bcrypt.genSalt(10, function(err, salt) {
return bcrypt.hash(password, salt, function(error, encrypted) {
this.password = encrypted;
this.salt = salt;
return done();
});
});
},
verifyPassword: function(password, done) {
return bcrypt.compare(password, this.password, function(err, res) {
return done(err, res);
});
}
}
});
};
Sequelize allows you to add class-level methods to any defined models in your JavaScript code. Usually, class-level methods are reserved for code that modifies the table, while instance methods are used for code that modifies your table rows.
upsert() returns a boolean indicating whether the row was created or updated.
The create() method is used to insert a single row into your SQL table. When you need to insert multiple rows at once, you need to use the bulkCreate() method instead. Finally, you can also write and execute a raw SQL statement using the sequelize. raw() method.
You can use JSON datatype of field in Sequelize (this corresponds to JSON datatype in PostgreSQL). const User = sequelize. define('User', { name: { type: DataTypes. STRING, allowNull: false }, age: { type: DataTypes.
Instance method can be used on specific element instances eg.
models.User.find(123).success( function( user ) {
user.setPassword('test');
});
You define the function as:
function(password, done)
Yet you don't supply the done parameter. Thus, the function leaves done as undefined and calling done() is executing an undefined function.
You could fix this in 3 ways:
function () {}
done()
if done is definedThe alternative is to refactor it to return a promise which it resolves on completion.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With