Adding constraints to sqlite from sequelize model 'define'

Question

I am using SequelizeJS to create models for my nodejs application. I have my model definitions defined in a startup file and will sequelize.sync() upon application launch. My question is, I have many constraints in the data that is being added into the fields Eg: I have a field called 'source' which is of type Sequelize.ENUM and its values should only be one of these ['pod', 'must', 'cap']. In sqlite I have option to put these contraints in the DB directly. How do I do the same from sequelize? can it be done during sync()?

Community · Accepted Answer · 2017-05-23 11:59:42Z

3

sequelize.define('model', {
    source1: Sequelize.ENUM('pod', 'must', 'cap'),
    source2: {
        type: Sequelize.ENUM,
        values: ['pod', 'must', 'cap']
    }

The code above will create an enum type in sequelize, that is restricted to the values you gave. However, sqlite does not natively support enums, which means the field will just be created as text:

..., `status` TEXT, ...

BUT, the values will still be validated in javascript, before they are inserted.

In mysql / pg an actual enum, limited to the values will be created:

... `status` ENUM('pod', 'must', 'cap'), ...

Examples of using the enum type can also be found in the documentation at http://sequelizejs.com/documentation

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Sep 3, 2013 at 12:24

Jan Aagaard Meier

28.9k8 gold badges99 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Adding constraints to sqlite from sequelize model 'define'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related