Sequelize defaultValue: DataTypes.UUIDV4 return null

Viewed 26

I upgrade version of Sequelize to 6.21.4 (from 6.5.0) my code have id determine with migration file:

id: { type: DataTypes.UUID, primaryKey: true, defaultValue: fn("uuid_generate_v4") },

failed to work with error message: Invalid value Fn { fn: 'uuid_generate_v4', args: [] } I try to update to:

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

it seems return null and not creating uuid as expected when no sending id. I don't want to demine it manually.

1 Answers

I always use this successfully:

defaultValue: Sequelize.literal('uuid_generate_v4()')

which I suppose is an equivalent of

defaultValue: Sequelize.fn("uuid_generate_v4") }
Related