node.js - Sequelize V5 - 创建模型时不支持 BOOLEAN 数据类型

Question

我最近在我的新 Node 项目中安装了 "sequelize": "^5.21.3"。此外，我正在使用“sequelize-auto-migrations”来同步数据库。( https://www.npmjs.com/package/sequelize-auto-migrations )

然后我使用 bool 类型字段创建我的第一个模型 [User]。

module.exports = function (sequelize, DataTypes) {
    var User = sequelize.define('user', {
        EpfNo: {
            type: Sequelize.INTEGER,
            autoIncrement: false,
            allowNull: false,
            primaryKey: true
        },
        Title: {
            type: Sequelize.STRING(10)
        },
        EmailAddress: {
            type: Sequelize.STRING(100)
        },
        ContactNo: {
            type: Sequelize.STRING(20)
        },
        IsValidUser:{
            type:Sequelize.BOOLEAN
        },
        IsActive: {
            type:Sequelize.BOOLEAN
        }
    })

但是当我尝试运行迁移时，它显示以下错误消息。

[#0] execute: createTable (node:16296) [SEQUELIZE0004] DeprecationWarning: A boolean value was passed to options.operatorsAliases. This is a no-op with v5 and should be removed.

请帮忙!

Answer 1

我认为您需要在 Sequelize 连接中将“operatorsAliases”作为 false 传递，如下所示 -

const Sequelize = require('sequelize')
const sequelize = new Sequelize(
  DB_NAME,
  USERNAME, 
  PASSWORD,
  {
    host: HOSTNAME,
    dialect: 'mysql',
    logging: false,
    freezeTableName: true,
    operatorsAliases: false
  }
)

也根据你的代码 -

module.exports = function (sequelize, DataTypes) {

您使用了后者的小 Sequelize ，但在您使用的归档定义中
首都

type:Sequelize.BOOLEAN

跳这有帮助。