如何使用Sequelize.js ORM正确迁移sqlite3数据库

Question

似乎sequelize没有连接/打开我在项目根目录中的sqlite3数据库文件。sequelize -m命令的输出表明，一切都迁移得很好，但是sqlite3数据库文件仍然是空的。

<标题> json h1> 0140814210910-createUsersTable.js(迁移文件)

'use strict';
module.exports = {
  up: function (migration, DataTypes, done) {
    migration.createTable('users', {
      id: {
        type: DataTypes.INTEGER,
        primaryKey: true,
        autoIncrement: true
      },
      createdAt: {
        type: DataTypes.DATE
      },
      updatedAt: {
        type: DataTypes.DATE
      },
      email: {
        type: DataTypes.STRING
      },
      password: {
        type: DataTypes.STRING
      }
    }).complete(done);
  },
  down: function (migration, DataTypes, done) {
    migration.dropTable('users').complete(done);
  }
};

<标题> 终端输出

$ sequelize -m
Loaded configuration file "config/config.json".
Using environment "development".
Loaded configuration file "config/config.json".
Using environment "development".
Running migrations...
20140814210910-createUsersTable.js
Completed in 18ms

<标题> 文件夹结构

|-.
   |-bin
   |-config
   |--config.json
   |-migrations
   |--20140814210910-createUsersTable.js
   |-node_modules
   |-server
   |-tests
   |-data.sqlite3

Answer 1

错误为storage在config.json中的路径值

将config.json编辑为:

{
  "development": {
    "dialect": "sqlite",
    "storage": "data.sqlite3"
  }
}