mysql-stored-procedures

Installation

First you need to export the database credentials as environment variables

export MYSQL_HOST=localhost
export MYSQL_USER=eenewbsauce
export MYSQL_PASSWORD=secret

then install the module

npm i mysql-stored-procedures

Usage

Creating Stored Procedures

const StoredProcedures = require('mysql-stored-procedures');
const sps = new StoredProcedures();
 
sps.create('stored-procedure.sql', cb);

Calling Stored Procedures

const StoredProcedures = require('mysql-stored-procedures');
const sps = new StoredProcedures();
 
sps.callWithParams({
  clientId: 123
}, (err, data) => {
  console.dir(data);
  // [{
  //   123, 'brad', 'pitt'
  // }]
})

TODO

Add support for OUT values