sails-mssql

This is a fork of swelham/sails-mssql that aims to bring sails/waterline .0.10x support to mssql.

This module is a Waterline/Sails adapter, an early implementation of a rapidly-developing, tool-agnostic data standard. Its goal is to provide a set of declarative interfaces, conventions, and best-practices for integrating with all sorts of data sources. Not just databases-- external APIs, proprietary web services, or even hardware.

Strict adherence to an adapter specification enables the (re)use of built-in generic test suites, standardized documentation, reasonable expectations around the API for your users, and overall, a more pleasant development experience for everyone.

Interfaces

queryable semantic associations TODO: migrations

Running the tests

Add test database configuration in ./test/integration/runner.js

npm install npm test

The exposed interfaces are generally passing unit tests. There are few exceptions resulting from the TODOs below:

TODO: Associations suite is complaining about "keyAt" although this same problem exists when running the unit tests in sails-mysqlv.10.0-rc7. This is causing database tables to not be cleaned up. Subsequent test runs will need to have these tables dropped before testing again.

TODO: Support "skip" for >SqlServer2012 via OFFSET. Currently supported with an inner query.