How does autoIncrement work in NodeJs's Sequelize?

Question

Sequelize's document doesn't say a whole lot about autoIncrement. It only includes the following example:

// autoIncrement can be used to create auto_incrementing integer columns incrementMe: { type: Sequelize.INTEGER, autoIncrement: true } 

Based off of this example I have the following code:

db.define('Entries', {     id: {         type: Seq.INTEGER,         autoIncrement: true,         primaryKey: true     },     title: {         type: Seq.STRING,         allowNull: false     },     entry: {         type: Seq.TEXT,         allowNull: false     } } 

Now when I want to create an entry I want to do something like this:

models.Entry.create({title:'first entry', entry:'yada yada yada'}) 

However, when I execute that code I get a database error:

Null value in column "id" violates not null constraint

I would assume Sequelize would put the integer in for me or define the database table to do that itself. Apparently not? What am I missing here to ensure that the id is automatically incremented and filled?

Thanks much.

Answer 1

Normally Sequelize.js adapt itself with the database. So the autoincrement attribute corresponds to a serial type in PostgreSQL.

I already worked with Sequelize and what I remember is that you don't need to specify an id as a primary key. Sequelize will do it for you.

Try to not add an id attribute and see if Sequelize will not add it for you or not.

Answer 2

omitNull config option by default is false. Set it to true, and the id will be taken care of by Postgres:

sequelize = new Sequelize('mydb', 'postgres', null, {   host: 'localhost',   port: 5432,   dialect: 'postgres',   omitNull: true })  Visitor = sequelize.define('visitor', {   email: Sequelize.STRING })  Visitor.create({email: '[email protected]'})