sails-mysql2

    0.9.32 • Public • Published

    Installation

    Install from NPM.

    # In your app: 
    $ npm install sails-mysql2

    Sails Configuration

    Add the mysql config to the config/connections.js file. Basic options:

    module.exports.connections = {
      mysql: {
        adapter   : 'sails-mysql2',
        host      : 'localhost',
        port      : 3306,
        user      : 'username',
        password  : 'password',
        database  : 'MySQL Database Name'
     
        // OR (explicit sets take precedence)
        adapter   : 'sails-mysql',
        url       : 'mysql2://USER:PASSWORD@HOST:PORT/DATABASENAME'
     
        // Optional
        charset   : 'utf8',
        collation : 'utf8_swedish_ci'
      }
    };

    And then change default model configuration to the config/models.js:

    module.exports.models = {
      connection: 'mysql'
    };

    Run tests

    You can set environment variables to override the default database config for the tests, e.g.:

    $ WATERLINE_ADAPTER_TESTS_PASSWORD=yourpass npm test

    Default settings are:

    {
      host: process.env.WATERLINE_ADAPTER_TESTS_HOST || 'localhost',
      port: process.env.WATERLINE_ADAPTER_TESTS_PORT || 3306,
      user: process.env.WATERLINE_ADAPTER_TESTS_USER || 'root',
      password: process.env.WATERLINE_ADAPTER_TESTS_PASSWORD || '',
      database: process.env.WATERLINE_ADAPTER_TESTS_DATABASE || 'sails_mysql',
      pool: true,
      connectionLimit: 10,
      waitForConnections: true
    }
    ``

    Install

    npm i sails-mysql2

    DownloadsWeekly Downloads

    1

    Version

    0.9.32

    License

    MIT

    Last publish

    Collaborators

    • pawanpawar