Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ### Add dotenv
- ```shell
- npm install --save dotenv
- touch .env
- ```
- ```env
- # .env
- MY_DB_USERNAME="root"
- MY_DB_PASSWORD="myDBp@ssw0rd"
- ```
- ### Add .sequelizerc file at the root of project
- ```shell
- touch .sequelizerc
- ```
- ```javascript
- // .sequelizerc
- const path = require('path');
- module.exports = {
- 'config': path.resolve('config', 'config.js')
- }
- ```
- ### Add config.js in config folder
- ```shell
- touch config/config.js
- ```
- ```javascript
- // config.js
- const fs = require('fs');
- require('dotenv').config();
- module.exports = {
- development: {
- username: process.env.MY_DB_USERNAME,
- password: process.env.MY_DB_PASSWORD,
- database: 'db_name_development',
- host: '127.0.0.1',
- dialect: 'mysql'
- },
- test: {
- username: process.env.MY_DB_USERNAME,
- password: process.env.MY_DB_PASSWORD,
- database: 'db_name_test',
- host: '127.0.0.1',
- dialect: 'mysql'
- },
- production: {
- username: process.env.MY_DB_USERNAME,
- password: process.env.MY_DB_PASSWORD,
- database: process.env.MY_DB_NAME,
- host: process.env.MY_DB_HOSTNAME,
- dialect: 'mysql'
- }
- };
- ```
- ### Configure models file
- In `models/index.js` replace `const config = require(__dirname + '/../config/config.json')[env];` by `const config = require(__dirname + '/../config/config.js')[env];`
Add Comment
Please, Sign In to add comment