How to insert initial data using sequelize migrations/seeds?

Question

I'm trying to create my initial migration to populate the test database but I can't get it working. This is what I have in my migration:

'use strict';  module.exports = {   up: function (queryInterface, Sequelize) {     return [       queryInterface.bulkInsert('Users', [         { username: "user1" },         { username: "user2" }     ])];   },    down: function (queryInterface, Sequelize) {     return queryInterface.dropTable('Users');   } }; 

And I get this error:

== 20151024144833-create-conjugation: migrating ======= { [SequelizeUniqueConstraintError: Validation error]   name: 'SequelizeUniqueConstraintError',   message: 'Validation error',   errors: [],   fields: [] } 

There must be an easier way to do this. I've checked other SO questions, but the syntax has changed in the current version of sequelize.

UPDATE

Ok, I realized my mistake: I was assuming that sequelize would take care of the timestamps. This fixes the problem:

up: function (queryInterface, Sequelize) {   console.log(User);   return [     queryInterface.bulkInsert('Users', [       { username: "user1", createdAt: Date.now(), updatedAt: Date.now() },       { username: "user2", createdAt: Date.now(), updatedAt: Date.now() }     ])   ]; } 

But I'm still wondering if this is the right way to seed my database. Is there a way to do it using User.create({})?

Answer 1

You can use next:

const City = sequelize.define('city', {   name: { type: Sequelize.STRING },   order_: { type: Sequelize.INTEGER } }); City.sync().then(() => {   City.create({     name: 'Neuquen',     order_: 0   });   City.create({     name: 'General Roca',     order_: 1   }); }); 

Or read about "migrations" at http://docs.sequelizejs.com/en/latest/docs/migrations/