Issue with enum data type in create function

Question

I have created "blogs" table with id(primary key), title ,created at ,updated at , status (with enum type having values "active,inactive,hidden" with default value "active")

create function on Blog Model is working fine when giving status value from above mentioned set of values and empty value

const Blog = sequelize.define('blog', { id: { type: 
Sequelize.INTEGER, 
primaryKey: true, autoIncrement: true }, text: Sequelize.STRING, 
status : { type : Sequelize.ENUM, allowNull : false, values : 
['Inactive','Active','Hidden'], defaultValue : 'Active' } }); 
Blog.create({"title" :"hello","status":"abc"}).then(result => {
console.log(result);
});

The above code inserted a new record in blogs table with status of empty value.but result object having status of "abc".How can I get newly inserted record ?

Blog = sequelize.define('blog', { id: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true }, text: Sequelize.STRING, status : { type : Sequelize.ENUM, allowNull : false, values : ['Inactive','Active','Hidden'], defaultValue : 'Active' } }); — Person Dev
– Person Dev, Commented Aug 29, 2019 at 11:27
Please update the question to keep model definition as part of it. — rkm
– rkm, Commented Aug 29, 2019 at 11:30

rkm · Accepted Answer · 2019-08-29 11:53:07Z

3

You should define ENUM like this:

status : { 
  type : Sequelize.ENUM('Inactive','Active','Hidden'), 
  allowNull : false, 
  defaultValue : 'Active',
  validate: {
    isIn: { 
      args: [['Inactive','Active','Hidden']],
      msg: "Wrong status"
    }
  }
}

In order to validate enum values you can use per attribute validation

edited Aug 29, 2019 at 11:53

answered Aug 29, 2019 at 11:34

rkm

3,1611 gold badge24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Person Dev Over a year ago

I don't need to validate.Create function output object is not same as database inserted record.When I try to insert a new record with status value of "abc" , it inserted in blogs table with empty value but output object contain "abc".

rkm Over a year ago

It's not the same, because database does "validation" and does not allow other values to be inserted. Also by default INSERT query does not return newly inserted record, so Sequelize can't return it back to you either.

rkm Over a year ago

If you don't want to validate, but still want to be able to insert invalid data, then you can implement custom getter that will cut out all values except defined list. But I'm not sure if it's good practice.

Collectives™ on Stack Overflow

Issue with enum data type in create function

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related