Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- module.exports = {
- user : "user",
- password : "password",
- connectString : "*connstring*" ,
- deliveredQuery: " SELECT COUNT (DISTINCT order_num) AS Cnt from orders where department = 'HR'
- };
- module.exports = function(callback) {//pass callback function and return with this
- var oracledb = require('oracledb');
- var dbConfig = require('./config.js');
- this.queryDB = function(query,callback) {
- oracledb.getConnection({
- user: dbConfig.user,
- password: dbConfig.password,
- connectString: dbConfig.connectString,
- deliveredQuery: dbConfig.deliveredQuery
- }, function(err, connection) {
- if (err) {
- console.error(err.message);
- return callback(err);
- }
- connection.execute(query, function(err, result) {
- if (err) {
- console.error(err.message);
- doRelease(connection);
- return;
- }
- //console.log(result.metaData);
- //console.log(JSON.parse(result.rows[0][0]));
- doRelease(connection);
- return callback(null, JSON.parse(result.rows[0][0]))
- });
- });
- function doRelease(connection) {
- connection.release(function(err) {
- if (err) {
- console.error(err.message);
- return callback(err);
- }
- });
- }
- };
- };
- var dbConfig = require('./config.js');
- var res = require('./query2.js')();
- var onTime_query = dbConfig.onTime_query;
- module.export = queryDB(onTime_query, function(err, callback){ });
- var res = require('./serv_ontime.js');
- console.log("The result is= "+ res);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement