我已经在本地托管了一个数据库。现在我想在 Heroku 中运行我的应用程序。一切顺利,但我不知道如何在 Heroku 上创建数据库并迁移我的所有模型。
在本地主机上,我有一个配置文件:
{
"development": {
"username": "postgres",
"password": "admin",
"database": "",
"host": "127.0.0.1",
"dialect": "postgres"
},
"test": {
"username": "postgres",
"password": null,
"database": "",
"host": "",
"dialect": ""
},
"production": {
"username": "postgres",
"password": "admin",
"database": "",
"host": "127.0.0.1",
"dialect": "postgres"
}
}
我在模型中的索引:
'use strict';
const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(module.filename);
const env = process.env.NODE_ENV || "development";
const config = require(__dirname + '/../../config/config.json')[env];
const db = {};
let sequelize;
if (config.use_env_variable) {
sequelize = new Sequelize(process.env[config.use_env_variable]);
} else {
sequelize = new Sequelize(
config.database,
config.username,
config.password,
config
);
}
fs
.readdirSync(__dirname)
.filter(
file =>
file.indexOf('.') !== 0 && file !== basename && file.slice(-3) ===
'.js'
)
.forEach(file => {
const model = sequelize['import'](path.join(__dirname, file));
db[model.name] = model;
});
db.sequelize = sequelize;
db.Sequelize = Sequelize;
// FOREIGN KEY SETTING FOR USER
module.exports = db;
我有这样运行的脚本:
"setupDev": "createdb -U postgres shc-dev; NODE_ENV=development sequelize -U postgres db:migrate",
"setupProd": "createdb -U postgres humansocialcomputation; NODE_ENV=production sequelize -U postgres db:migrate",
"resetDev": "dropdb -U postgres shc-dev",
"resetProd": "dropdb -U postgres humansocialcomputation",
"start": "node app.js",
我的目标是在 heroku 上也使用此脚本,我如何实现这个目标?另外,我已经有一个数据库和来自 Heroku 的db_url,但这个数据库不为空。我怎么也可以重写它
参见 pg:restore 的文档
例如:
heroku pg:backups:restore 'https://s3.amazonaws.com/me/items/3H0q/mydb.dump' DATABASE_URL