Nocturnal Pajama Mutants

    sails-sqlserver-adapter

    2.1.0 • Public • Published

    Sails Sqlserver Adapter

    Build Status

    A Waterline adapter for working with the Microsoft SqlServer database.

    This version works with Sails 1.x. All Waterline Adapter Interfaces and methods are implemented based on the postgres implementation.

    This is largely a port of sails-postgresql

    Install

    $ npm install sails-sqlserver-adapter

    Usage

    An example configuration below.

    Check MsSql Driver Options and Tarn Pool Options for more details. The options are passed verbatim to downstream driver.

    module.exports.datastores = {
        default: {
            adapter: 'sails-sqlserver-adapter',
            host: process.env.DB_HOST,
            port: process.env.DB_PORT,
            user: process.env.DB_USER,
            password: process.env.DB_PASS,
            database: process.env.DB_NAME,
            schemaName: 'dbo',  //note: schema specified in model takes precedence
            requestTimeout: 15000,
            options: {
                encrypt: false,
                appName: 'myapp'
            },
            pool: {
                max: 25,
                min: 5,
                idleTimeoutMillis: 30000
            } 
        }
    };

    Running Test

    The repo is configured to run all the tests in Docker containers. The composition uses two container

    1. sql server 2017 container spec published by Microsoft
    2. A container for testing the package based on official Node 10 release

    To run the tests in docker env

    $ docker-compose up

    The github repo is configure to run the tests in Travis-CI on code push. The status of the build can be seen at the top of the repo

    Help

    If you have further questions or are having trouble, click here.

    License

    The Sails framework is free and open-source under the MIT License.

    Install

    npm i sails-sqlserver-adapter

    DownloadsWeekly Downloads

    0

    Version

    2.1.0

    License

    MIT

    Unpacked Size

    29.4 MB

    Total Files

    107

    Last publish

    Collaborators

    • vijaykonnackal