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'; moduleexportssqlconnection = 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 = ; var request = sailshookssqlconnection; request;