mysql-task-lib

Synopsis

Simple mysql helper function that abstracts the side-effects of the asynchronis mysql node library, and wraps it in task. This helper function has simple catches to detect if you have a reader/writer portion of your configuration in the case you have a read replica. Otherwise, it will use the configuration as you give it.

Code Example

Simple Configuration

const mysql = require ('mysql-task-lib'),
      logI  = function (x) { console.log (x); return x; },
      
      conf = { host     : 'database.com'
             , user     : 'username'
             , database : 'database'
             , password : 'password01'
             },
  
      query       = "SELECT * FROM testtable.testdata",
      mysql_query = mysql.query (conf, query, []);

mysql_query.fork(logI, logI)

Read-Replica Configuration

const mysql = require ('mysql-task-lib'),
      logI  = function (x) { console.log (x); return x; },
      
  conf = { writer: { host:        'database.com',
                     user:        'username',
                     database:    'database',
                     dateStrings:  true,
                     password:    'password01'
                   }
         , reader: { host:        'database-reader.com',
                     user:        'username',
                     database:    'database',
                     dateStrings:  true,
                     password:    'password01'
                   }
         };
  
      query       = "SELECT * FROM testtable.testdata",
      mysql_query = mysql.query (conf, query, []);

mysql_query.fork(logI, logI)

Installation

npm install mysql-task-lib