node.js - Node 的 Sequelize 不允许在主键上自动生成 UUID *除非*字段名称是 'id'

Question

这Sequelize commit似乎确认命名主键“id”使其变得特别。根据我对以下代码片段的测试，将字段名更改为“id”以外的名称就足以不设置默认值，因此插入失败。


id: { type: DataTypes.UUID, primaryKey: true, defaultValue: DataTypes.UUIDV4, allowNull: false }


那么有没有办法保持命名主键字段的灵 active 并将其默认为 UUID？

Answer 1

Question is bit too old and at that time I think that was not possible , but in 2018 it is possible :) , here we go :

定义自己的主键:

sequelize.define('collection', {
  uid: {
    type: Sequelize.INTEGER,
    primaryKey: true,
    autoIncrement: true // Automatically gets converted to SERIAL for postgres
  }
});

sequelize.define('collection', {
  uuid: {
    type: Sequelize.UUID,
    primaryKey: true
  }
});

READ MORE