Disable sequelize column returning

Question

Good afternoon, everyone. I have a database with users' secret information. I want to disable returning of column "password" when I use findOne(). How can I do it without deleting it from the response object?

Answer 1

If you want to return all the fields except one, you can use the exclude attribute like this :

    myTable.findOne({
        attributes: {exclude: ['password']},
        where: { id: userId }
    })

Answer 2

you could do that while defining your schema by using toJson it allows you to edit your returned schema like this

sequelize.define('user', attributes, {
  instanceMethods: {
    toJSON: function () {
      const values = Object.assign({}, this.get());

      delete values.password;
      return values;
    }
  }
});