Sproc it
Sproc it is a Promise-based API for executing SQL stored procedures (for Nodejs)
Work it, Sproc it, Do it, Make us
🎼 ...
Harder, Better, Faster, Stronger
Install
npm i sprocit
Create your config
const config = provider: 'mssql' // only provider, for now user: 'dbuser' password: '---' server: 'localhost' database: 'master' options: encrypt: false // true, for using Azure
Execute a Stored procedure
const sp = const params = name: 'id' value: 1 // just 'connect' then => 'execute'sp
Run a Query
sp
See tests for advanced usage
TODO:
- Mocha tests with Chai assertions
- PostgreSQL support