在续集ENUM类型上设置默认值

Question

我目前正在尝试在类型为ENUM的列上设置默认值，但是如果我将defaultValue设置为"employee"这是枚举的值之一，我会收到以下错误消息：

$ npx sequelize db:migrate
Sequelize CLI [Node: 10.16.0, CLI: 5.5.0, ORM: 5.15.1]
Loaded configuration file "srcconfigconfig.js".
Using environment "development".
== 20190824180419-create-user: migrating =======
ERROR: invalid input value for enum "enum_Users_role": "employee"

查找下面的我的用户迁移文件定义

20190824180419-create-user.js

export default {
up: (queryInterface, Sequelize) => queryInterface.createTable('Users', {
uuid: {
allowNull: false,
primaryKey: true,
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
},
email: {
type: Sequelize.STRING
},
password: {
type: Sequelize.STRING
},
name: {
type: Sequelize.STRING
},
role: {
type: Sequelize.ENUM,
values: ['employee', 'super_admin', 'travel_admin', 'travel_team_manager', 'manager', 'supplier'],
defaultValue: 'employee'
}
}),
down: queryInterface => queryInterface.dropTable('Users')

};

在下面查找我的用户模型文件定义：

user.js
export default (sequelize, DataTypes) => {
const User = sequelize.define('User', {
uuid: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true
},
email: DataTypes.STRING,
password: DataTypes.STRING,
name: DataTypes.STRING,
role: {
type: DataTypes.ENUM('employee', 'super_admin', 'travel_admin', 'travel_team_manager', 'manager', 'supplier'),
defaultValue: 'employee'
}
}, {});
User.associate = () => {
// associations can be defined here
};
return User;
};

软件包版本：

node: v10.16.0
npm: 6.9.0
sequelize: 5.15.1
sequelize-cli: 5.5.0

Answer 1

您设置了错误的枚举值。它应该就像您通过构造函数在模型定义中所做的那样ENUM：

{
type: Sequelize.DataTypes.ENUM('employee', 'super_admin', 'travel_admin', 'travel_team_manager', 'manager', 'supplier'),
defaultValue: 'employee',
}

Answer 2

您能否删除模型中的defaultValue并更改格式，如@rkm所述。所以你有这样的东西：

role: DataTypes.ENUM('employee', 'super_admin', 'travel_admin', 'travel_team_manager', 'manager', 'supplier'),

并在迁移文件中显示为：

role: {
type: Sequelize.ENUM('employee', 'super_admin', 'travel_admin', 'travel_team_manager', 'manager', 'supplier'),
defaultValue: 'employee'
}

Answer 3

在迁移文件中使用这些应该可以工作

role: {
type: Sequelize.ENUM('employee', 'super_admin', 'travel_admin', 'travel_team_manager', 
'manager', 'supplier'),
defaultValue: 'employee'
}