Sails-MSsqlserver
Microsoft SQL Server adapter for sails.js. Tested on SQL Server 2012 and 2014, but should support any SQL Server 2005 and newer. CI tests are run against SQL Server Express. Originally published by c*nect.
The development and acceptance of pull request have stalled on the original project. Therefore I am publishing this project with some enhancements.
Getting Started
1. Install
$ npm install sails-mssqlserver --save
2. Configure
config/models.js
connection: 'sqlserver'
config/connections.js
sqlserver: adapter: 'sails-mssqlserver' user: 'sa' password: 'secureP@ssword' host: 'abc123.database.windows.net' // azure database database: 'mydb' options: encrypt: true // use this for Azure databases
Query Examples
Select with certain columns
Plugins
For further examples check out Sail's Waterline ORM page
License
MIT
Credits
This project was originally forked from cnect/sails-sqlserver in 2016. That repo was itself forked from swelham/sails-mssql in early 2015. The code in both of those repositories is also available under the MIT license.