Nomad Packaging Mechanism

    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

    0

    Version

    0.2.2

    License

    MIT

    Unpacked Size

    5.4 kB

    Total Files

    8

    Last publish

    Collaborators

    • bradoyler