使用环境变量进行本地序列化配置 [英] using an enviroment variable for local sequelize configuration

问题描述

我希望通过sequelize在我的项目的config.json文件中使用一个环境变量.我正在使用dotenv在本地设置环境变量.我的config.json文件看起来像这样

I'm looking to use an environment variable inside of the config.json file of my project using sequelize. I'm using dotenv to set environment variables locally. My config.json file looks like this

{
  "development": {
    "username": process.env.DB_USER,
    "password": process.env.DB_PASS,
    "database": process.env.DB_DATABASE,
    "host": process.env.DB_HOST,
    "dialect": "mysql"
  },
  "test": {
    "username": "root",
    "password": null,
    "database": "database_test",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  "production": {
    "use_env_variable": "JAWSDB_URL",
    "dialect": "mysql"
  }
}

我遇到的问题是我无法在config.json文件中使用变量.在生产环境中，我可以使用"use_env_varable"键，并在连接字符串中使用env变量.所以我想我要么需要一种方法来找出本地mysql数据库的组合连接字符串，要么需要一种使用config.json内部变量的方法.有解决方案吗?

The issue I'm having is that I can't use variables inside the config.json file. It looks like for production I can use the "use_env_varable" key and use the env variable for my connection string. So I guess I either need a way to figure out the combined connection string for my local mysql db or a way to use variables inside the config.json. Any solutions?

推荐答案

您应将config.json文件更改为config.js模块，并确保将require dotenv放在最顶部.

you should change config.json file to a config.js module and make sure to require the dotenv at the very top.

require('dotenv').config(); // this is important!
module.exports = {
"development": {
    "username": process.env.DB_USERNAME,
    "password": process.env.DB_PASSWORD,
    "database": process.env.DB_DATABASE,
    "host": process.env.DB_HOST,
    "dialect": "mysql"
},
"test": {
    "username": "root",
    "password": null,
    "database": "database_test",
    "host": "127.0.0.1",
    "dialect": "mysql"
},
"production": {
    "username": "root",
    "password": null,
    "database": "database_production",
    "host": "127.0.0.1",
    "dialect": "mysql"
}
};

注意:更新您的.sequelizerc文件以匹配新的配置文件.

NOTE: update your .sequelizerc file to match the new config file.

"config": path.resolve('./config', 'config.js'),

这篇关于使用环境变量进行本地序列化配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！