Guest User

Untitled

a guest
Jan 7th, 2019
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. ### Add dotenv
  2. ```shell
  3. npm install --save dotenv
  4. touch .env
  5. ```
  6. ```env
  7. # .env
  8. MY_DB_USERNAME="root"
  9. MY_DB_PASSWORD="myDBp@ssw0rd"
  10. ```
  11. ### Add .sequelizerc file at the root of project
  12. ```shell
  13. touch .sequelizerc
  14. ```
  15.  
  16. ```javascript
  17. // .sequelizerc
  18. const path = require('path');
  19.  
  20. module.exports = {
  21. 'config': path.resolve('config', 'config.js')
  22. }
  23. ```
  24.  
  25. ### Add config.js in config folder
  26. ```shell
  27. touch config/config.js
  28. ```
  29.  
  30. ```javascript
  31. // config.js
  32. const fs = require('fs');
  33. require('dotenv').config();
  34.  
  35. module.exports = {
  36. development: {
  37. username: process.env.MY_DB_USERNAME,
  38. password: process.env.MY_DB_PASSWORD,
  39. database: 'db_name_development',
  40. host: '127.0.0.1',
  41. dialect: 'mysql'
  42. },
  43. test: {
  44. username: process.env.MY_DB_USERNAME,
  45. password: process.env.MY_DB_PASSWORD,
  46. database: 'db_name_test',
  47. host: '127.0.0.1',
  48. dialect: 'mysql'
  49. },
  50. production: {
  51. username: process.env.MY_DB_USERNAME,
  52. password: process.env.MY_DB_PASSWORD,
  53. database: process.env.MY_DB_NAME,
  54. host: process.env.MY_DB_HOSTNAME,
  55. dialect: 'mysql'
  56. }
  57. };
  58. ```
  59.  
  60. ### Configure models file
  61. 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