How can I connect multiple databases to a sequelize app?

Question

I want to build an app that has three connections.. One for mysql, postgreSQL and SQLite?? 
So far I have a connection for a postgreSQL I am finding it difficult to add a MySQL connection as well. 
Any help would be great... Here is what I have so far.. 
config.json: 
{
  "development": {
    "url": "postgres://dabladmin:dabldem@localhost:5432/dablpatient",
    "dialect": "postgres"
  }
}
database.js: 
var Sequelize = require('sequelize');
var connection = 'postgres://dabladmin:dabldem@localhost:5432/dablpatient';
var connection2 = 'mysql://root:weak@localhost:3306/dablpatient2';
var postgresDB = new Sequelize(connection);
var mysqlDB = new Sequelize(connection2);
module.exports = postgresDB;
module.exports = mysqlDB;
app.js: 
var express = require('express');
var path = require('path');
var consolidate = require('consolidate');
var bodyParser = require('body-parser');
var database = require('./database/database');
var Patient = require('./models/models').Patient;
var morgan = require('morgan');
var routes = require('./routes');
var app = express();
app.engine('html', consolidate.nunjucks);
app.set('view engine', 'html');
app.set('views', './views');
app.use(morgan('dev'));
app.use(routes);
app.use(bodyParser.urlencoded({ extended: false }));
app.listen(3055);
module.exports = app;

Dane Parchment · Accepted Answer

I don't have time to post the complete solution I will however, link to a Stack Overflow that somewhat answers it. Generally what you should do is create a new instance of Sequalize for each database.
Here (https://stackoverflow.com/questions/37078970/sequelize-using-multiple-databases) is a link to a Stack Overflow answer that tackles somewhat the same problem as you.  I am unsure however, if this will work for multiple databases if they are each different (SQLite, Postgres, MySQL), as a question though. Why are you using SQLite, Postgres, and MySQL in the same project (not accusing, just really curious), I am unsure as to why you would want to use them all at the same time...

Welcome to the Treehouse Community

Looking to learn something new?

Donal Lane

Donal Lane

How can I connect multiple databases to a sequelize app?

1 Answer

Dane Parchment

Dane Parchment

Donal Lane

Donal Lane