Home Reference Source

oracledb-with

A simple resource management utility for working with node-oracledb.

Installation

npm install --save oracledb-with
# or
yarn add oracledb-with

Usage

Hint: view the API documentation.

import witho from 'oracle-with'

//
// Connections will automatically be cleaned up (closed) for you
//
await witho.conn({connectString: '...', ...}, async conn => {
  await conn.execute(...)
})

//
// ResultSets are automatically cleaned up as well:
//
witho.resultSet(conn, 'SELECT * FROM ...', [], {outFormat: oracledb.OBJECT}, async (resultSet, results) => {
  await resultSet.getRow()
  // use: results.metaData
})

//
// ...or if you already have a connection created with oracledb-with:
//
await witho.conn({connectString: '...', ...}, async conn => {
  await conn.resultSet(sql, bind, opts, async resultSet => {
    // ...
  })
})

//
// Easy selects:
//
witho.select(conn, 'SELECT * FROM ...')
// => Promise<OracleResult {
//      ...
//      metaData: ...,
//      rows: [...],
//      ...
//    }>

//
// Or:
//
await witho.conn({connectString: '...', ...}, async conn => {
  await conn.select(sql, bind, opts, async results => {
    // ...
  })
})