sequelize seed unable to insert the data in SQLite

Question

I am trying to insert the dummy data using sequelize-cli command

sequelize db:seed --seed seeders/20170212081140-subject_tags.js

here is my config file

{
  "development": {
    "username": "root",
    "password": null,
    "database": "database_development",
    "host": "127.0.0.1",
    "dialect": "sqlite",
    "seederStorage": "sequelize",
    "storage": "./test"
  }
}

and here my seeder file

use strict';

module.exports = {
  up: function(queryInterface, Sequelize) {

    return 
      queryInterface.bulkUpdate('subject_tags', [

      {
        tag: 'agricultural-sciences',
        tag_description: '',
        subject_category: 'biological_&_medical_sciences',
        createdAt: new Date(),
        updatedAt: new Date()
      }, {
        tag: 'biochemistry',
        tag_description: '',
        subject_category: 'biological_&_medical_sciences',
        createdAt: new Date(),
        updatedAt: new Date()
      }, {
        tag: 'bioinformatics',
        tag_description: '',
        subject_category: 'biological_&_medical_sciences',
        createdAt: new Date(),
        updatedAt: new Date()
      }
    ] , {});
  },

  down: function(queryInterface, Sequelize) {
     return 
      queryInterface.bulkDelete('subject_tags', null, {});

  }
};

Though I am getting the status

Using environment "development".
== 20170212081140-subject_tags: migrating =======
== 20170212081140-subject_tags: migrated (0.053s)

I tried bulkCreate and bulkInsert in the seed file , all of them run successful, but data does not get inserted into the table the data does not get inserted. Is I am doing something wrong?

Are you sure you want to use `bulkUpdate` instead `bulkCreate` method in the `up` seed function? — piotrbienias, Feb 19 '17 at 11:13
@piotrbienias : tried `bulkCreate` and `bulkInsert`, every thing shows successful migration but data is not available in SQLite — made_in_india, Feb 19 '17 at 20:32

score 1 · Accepted Answer · answered Mar 13 '17 at 05:50

It seems to be issue with sequlizer, after return statement it unable to handle space with newline character

module.exports = {
  up: function(queryInterface, Sequelize) {
    //old code
    //return 
    //  queryInterface.bulkUpdate('subject_tags', [

    //new code
    return queryInterface.bulkUpdate('subject_tags', [
    //.........

score 0 · Answer 2 · answered Jun 19 '19 at 03:08

0

Javascript will automatically add a semi-colon after a dangling return statement. It doesn't reach the bulkUpdate code.

answered Jun 19 '19 at 03:08

Maki

890
1
7
13

sequelize seed unable to insert the data in SQLite

2 Answers2