const mysql = require( 'mysql' );
  class Database {
   constructor( config ) {
    this.connection = mysql.createConnection( config );
    }
   query( sql, args ) {
    return new Promise( ( resolve, reject ) => {
        this.connection.query( sql, args, ( err, rows ) => {
            if ( err )
                return reject( err );
            resolve( rows );
        } );
     } );
    }
   close() {
    return new Promise( ( resolve, reject ) => {
        this.connection.end( err => {
            if ( err )
                return reject( err );
            resolve();
        } );
    } );
    }
    }

function experianEntireSuccess() {

  var sqlQuery = `select * from TRANSACTION_PAYLOAD where INTERFACE_NAME =
   'Experian' AND (STATUS ='SUCCESS_RESPONSE')`



   var deferred = Q.defer();
   console.log("INSIDE NODE JS SERVICE OF experian Entire Success");


   var host = config.host;
   var user = config.user;
   var password = config.password;
   var database = config.database;


    var con = mysql.createConnection({
    host: host,
    user: user,
    password: password,
    database: database
      });


      con.connect(function (err) {
       if (err) deferred.reject(err.name + ': ' + err.message);

       con.query(sqlQuery,
           function (err, result, fields) {
            if (err) deferred.reject(err.name + ': ' + err.message);

            console.log("my result => ",result);

            deferred.resolve(result);

        });


       })

     console.log(" deferred.promise; ");
    return deferred.promise;

    console.log("EXPERIAN 2 RELEASE CON");

  }