sails-hook-sqlconnection

A Sails JS hook to create global mssql connection pool objects.

Note: requires Sails >= 0.11

This hook will initialize your mssql connection pool objects when Sails lifts and can be used to retrieve the connection for use throughout your Sails project.

Installation

npm install sails-hook-sqlconnection

Usage

sails.hooks.sqlconnection.getConnection(connection)

Parameter	Type	Details
connection	((string))	Name of your mssql connection

Configuration

By default, configuration lives in sails.config.sqlconnection. The configuration key (sqlconnection) can by changed by setting sails.config.hooks['sails-hook-sqlconnection'].configKey.

Parameter	Type	Details
connections	((object))	Object containing mssql connection config objects
connection	((object))	mssql connection config object
server	((string))	mssql host name
user	((string))	mssql username
password	((string))	mssql password
database	((string))	mssql database

Additional config options are available, see the mssql documentation for more details

// [your-sails-app]/config/sqlconnection.js
'use strict';
 
module.exports.sqlconnection = {
  connections: {
    mssqlserver: {
      server: "localhost",
      user: "user",
      password: "password",
      database: "example"
    }
  }
}
 

Example

Use mssql as you noramally would once a connection pool has been initialized:

'use strict';
 
var sql = require('mssql');
 
var request = new sql.Request(sails.hooks.sqlconnection.getConnection('mssqlserver'));
 
request.query('select * from sometable').then(function(recordset) {
  console.dir(recordset);
}).catch(function(err) {
  // ... query error handling
});