var oracledb = require('oracledb');
var gresult = 'new var';

module.exports = {

command: function(mycommand){

  oracledb.getConnection({
        user: "system",
        password: "toor",
        connectString: "localhost/xe"
   },

  function (err, connection) {
      if (err) {
           console.error(err.message);
           return;
      }
      connection.execute( "select * from TERMEKEK where SALE = '1' ORDER BY DBMS_RANDOM.RANDOM",[],
      function (err, result,a) {
           if (err) {
                console.error(err.message);
                doRelease(connection);
                return;
           }

           gresult =  result.rows;


           doRelease(connection);
      });
  });

   function doRelease(connection) {
        connection.release(
             function(err) {
                  if (err) {console.error(err.message);}
             }
        );
   }

   console.log(gresult); // ITT A KEKÉRDEZÉST KELLENE KIÍRNIA, DE 'new var'-t ír
   return 'asd';
}

};