Separate mysql db adapter test with Sails.js

api_models_ModelA.js

module.exports = {
  adapter: 'mysqlDb1',

  attributes: {
    name: 'string'
  }
};

api_models_ModelB.js

module.exports = {
  adapter: 'mysqlDb2',

  attributes: {
    name: 'string'
  }
};

config_adapters.js

module.exports.adapters = {

  'default': 'disk',
  disk: {
    module: 'sails-disk'
  },

  mysqlDb1: {
    module: 'sails-mysql',
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'sailsDb1',
    pool: false
  },
  mysqlDb2: {
    module: 'sails-mysql',
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'sailsDb2',
    pool: false
  }
};

config_boostrap.js

module.exports.bootstrap = function (cb) {
  
  function createMysqlTestData(done) {
    async.parallel([
      function(done) {
        var modelA = [{ "name": "testA" }];
        ModelA.count().exec(function(err, count) {
          if (err) return done(err);
          if (count > 0) return done();
          ModelA.create(modelA).exec(done);
        });
      },
      function(done) {
        var modelB = [{ "name": "testB" }];
        ModelB.count().exec(function(err, count) {
          if (err) return done(err);
          if (count > 0) return done();
          ModelB.create(modelB).exec(done);
        });
      }
    ], done);
  }
  createMysqlTestData(cb);
  
};

This worked for me.

I successfully saw a modela table created in sailsDb1 containing a row with the 'testA' name. Likewise with modelb in sailsDb2 with 'testB' name.

Is there is any particular way to switch amongs different Db's prgramatically?
Im planning to give Separate Db's for each of my Signed up users.

Is there is any particular way to switch amongs different Db's prgramatically?
Im planning to give Separate Db's for each of my Signed up users.

Is there a way to create FK in the different DB using the mySql-adapter?