typescript - 如何使用 typescript 和 bcrypt 在 sequelize 模型中添加方法？

Question

我正在用 typescript 创建一个项目，但在使用 bcrypt 和 sequelize 时遇到了麻烦。
为了加密密码，我输入了以下代码:

import Sequelize from "sequelize";
import { sequelize } from "../dbpostgredatabase";
import bcrypt from "bcrypt";

export const User = sequelize.define(
  "User",
  {
    id: {
      type: Sequelize.INTEGER,
      primaryKey: true,
      autoIncrement: true,
    },
    name: {
      type: Sequelize.STRING,
      allowNull: false,
    },

    password: {
      type: Sequelize.STRING,
      allowNull: false,
      set(value: string) {
        const hash = bcrypt.hashSync(value, 8);
        this.setDataValue("password", hash);
      },
    },

    lastname: {
      type: Sequelize.STRING,
      allowNull: false,
    },
    email: {
      type: Sequelize.STRING,
      allowNull: false,
      unique: true,
    },
    date: {
      type: Sequelize.DATE,
      allowNull: false,
    },
    admin: {
      type: Sequelize.BOOLEAN,
      defaultValue: false,
    },
  },

  {
    timestamps: false,
    createdAt: false,
    updatedAt: false,
  }
);

export default User;

我需要那个哈希值，但我现在不知道如何获取它，我只需要一种方法来比较密码

Answer 1

import Sequelize from "sequelize";
import { sequelize } from "../dbpostgredatabase";
import bcrypt from "bcrypt";

export const User = sequelize.define(
  "User",
  {
    id: {
      type: Sequelize.INTEGER,
      primaryKey: true,
      autoIncrement: true,
    },
    name: {
      type: Sequelize.STRING,
      allowNull: false,
    },

    password: {
      type: Sequelize.STRING,
      allowNull: false,
      set(value: string) {
        const hash = bcrypt.hashSync(value, 8);
        this.setDataValue("password", hash);
      },
    },

    lastname: {
      type: Sequelize.STRING,
      allowNull: false,
    },
    email: {
      type: Sequelize.STRING,
      allowNull: false,
      unique: true,
    },
    date: {
      type: Sequelize.DATE,
      allowNull: false,
    },
    admin: {
      type: Sequelize.BOOLEAN,
      defaultValue: false,
    },
  },

  {
    timestamps: false,
    createdAt: false,
    updatedAt: false,
  }
);

// add static method here
User.hashPassword = function(password) {
    return bcrypt.hashSync(password, bcrypt.genSaltSync(8), null);
}

User.isValidPassword = function(password, hash) {
    return bcrypt.compareSync(hash, password);
}

export default User;