Sails.js multiple databases in multiple environments

Question

I have been going round in circles trying to get this to work how I think it should in sails v 0.11.0

I have my development.js as follows

module.exports = {

connections: {
    conn1: {
        adapter: 'sails-sqlserver',
        user: 'user',
        password: 'pass',
        server: 'server1',
        database: 'db1',

        options: {
            encrypt: true
        }
    },


    conn2: {
        adapter: 'sails-sqlserver',
        user: 'user',
        password: 'pass',
        server: 'server1',
        database: 'db2',

        options: {
            encrypt: true
        }
    }
},

    models:
    {
        firstconn: 'conn1',
        secondconn: 'conn2'
    }

};

My connection.js is empty

In my controller I am trying to echo the connection and user it to get a list of users:

UsersController:

var sql = require('mssql');

    module.exports = {
        hi: function (req, res) {

            console.log(sails.config.firstconn);

            var connection = new sql.Connection(sails.config.firstconn, function (err) {
                var request = new sql.Request(connection);
                request.query('SELECT * FROM [dbo].[Perms_Users]', function (err, recordsets) {
                    res.send(recordsets)
                });
            });
        }
    };

However my connection is always null?

I am running in development, can someone point out what I have missed?

jemiloii · Accepted Answer · 2015-06-15 15:39:24Z

1

You should be able to add connection: 'dbname' to your model to access the database. The models block in development should be the default db connection and and configuration to use.

For model settings http://sailsjs.org/#!/documentation/concepts/ORM/model-settings.html

In depth models: http://sailsjs.org/#!/documentation/concepts/ORM/Models.html

answered Jun 15, 2015 at 15:39

jemiloii

25.9k9 gold badges58 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dave · Accepted Answer · 2015-06-15 15:46:36Z

1

Actually it was very easy!

sails.config.connections.conn1 gives access to the modal

answered Jun 15, 2015 at 15:46

dave

1,4301 gold badge16 silver badges43 bronze badges

2 Comments

Yann Bertrand Over a year ago

You should validate your answer then.

dave Over a year ago

I have another 20 hours before I can :-)

Collectives™ on Stack Overflow

Sails.js multiple databases in multiple environments

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related