mysql-stored-procedures
v1.0.1
Published
A Node.js module that can create and call stored procedures
Downloads
11
Readme
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