Data Management - kkemple/awesome-enterprise-web-service GitHub Wiki

This project is set to use mysql but that could easily be replaced by Postgres or MongoDB. Sequelize is used for migrations/seeds and as an ORM internally (see DB plugin for more info). There is a default migration in db/migrations and a corresponding seeder file in db/seeders. To run them:

npm run db:migrate
npm run db:seed:all

Sequelize cli uses NODE_ENV environment variable to determine what config to use. The cli looks at db/config.js for configuration options.

All available migration and seed NPM commands...

{
  "db:migrate": "sequelize db:migrate",
  "db:migration:create": "sequelize migration:create",
  "db:migrate:undo": "sequelize db:migrate:undo",
  "db:migrate:undo:all": "sequelize db:migrate:undo:all",
  "db:seed": "sequelize db:seed",
  "db:seed:all": "sequelize db:seed:all",
  "db:seed:create": "sequelize seed:create",
  "db:seed:undo": "sequelize db:seed:undo",
  "db:seed:undo:all": "sequelize db:seed:undo:all"
}

See sequelize docs for more info.