promise-oracledb
Oracledb connect driver using Promises/A+
Installation: -Requires the oracledb nodejs driver. Please see the documentation for how to install that dependency for your system. -For Windows: -Install Python 2.7 -Install Microsoft Visual Studio dev tools -Run npm install promise-oracledb using the visual studio command prompt.
How to use:
/*Create Connection*/
var db = require('promise-oracledb');
db.setConnection({
user: /*username*/,
password: /*password*/,
connectString: /*oracle connection string. please see their documentation*/,
useJSONFormat: /*Optional: This param, if set to true, will output results as json*/,
enableLogging: /*Optional: If true, will show logging in the console*/
});
/*If you would like to use the driver only for getting the connection, you can now
use db.getConnection().then(function(conn){/*callback*/}) */
/*Create a Query */
var query1 = db.createQuery({
query: /*query*/,
params: /*oracle driver allows for parameterized values in the query.*/,
args: /*oracle driver allows some specific arguments to be passed into queries*/
});
/*Execute Query*/
query1.execute().then(
function(results) {
console.log(results);
/* results is an object with:
rows: ['Array with result set. Will be arrays
or objects depending on how
you set it in create connection.'],
metadata: [{'name': 'Tables accessed and other info'}],
time: 'Apporimation in milliseconds of how long the query took to execute. Still useful
for performace metrics'
*/
},
function(err) {
console.log(err);
}
);
/* You can change the params or args then re-execute the queries*/
query1.args = {};
query1.params ={};