Learn about our RFC process, Open RFC meetings & more.Join in the discussion! »

sprocit

0.2.2 • Public • Published

log 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 = require('sprocit').create()
const params = [{name: 'id', value: 1}]
 
// just 'connect' then => 'execute'
sp.connect(config)
  .then(db => {
    db.exec('getItem', params)
      .then(console.log) // logs results
  })

Run a Query

sp.connect(config)
  .then(db => {
    db.query('select * from items')
      .then(console.log) // logs results
  })

See tests for advanced usage

TODO:

  • Mocha tests with Chai assertions
  • PostgreSQL support

Install

npm i sprocit

DownloadsWeekly Downloads

1

Version

0.2.2

License

MIT

Unpacked Size

5.4 kB

Total Files

8

Last publish

Collaborators

  • avatar