var crypto = require('crypto');
var fs = require('fs');
var createHash = crypto.createHash;
var mysql = require('mysql');
var con = mysql.createConnection({
  host: "sql2.freesqldatabase.com",
  user: "sql2230602",
  password: "mV4%tZ3!",
  database: "sql2230602"
});
var user = new Object();
 user = {
  name: 'test',
  password: '123123',
  id: 0
};

var AuthAPI = {
  getHash: function(data, salt, hash_method) {
      if (hash_method === 'method_password') {
          var data = salt + data;
          data = createHash('sha512').update(data).digest('hex');
          return createHash('md5').update(data).digest('hex')
      } else if (hash_method === 'method_login') {
          var data = salt + data;
          data = createHash('sha384').update(data).digest('hex');
          return createHash('md5').update(data).digest('hex')
      } else {
          return 'Error: use arguments => <data>, <salt>, method_<method>;'
      }
  },
 connectToDB: function() {
   con.connect(function(err) {
     if (err) {
       throw err;
     } else {
     console.log('Connected to DataBase;');
   }
   });
 },
 goAuth: function(login, password) {
   let hash_login = this.getHash(login, 2018, 'method_login');
   let hash_password = this.getHash(password, 2018, 'method_password');
   let hash = hash_login + hash_password;
   let database;
     con.query(`SELECT hash FROM users WHERE hash = '${hash}';`, function (err, result) {
       if (err) {
         throw err;
       } else {
         if (hash === result[0].hash) {
           console.log(hash, "==", result[0].hash);
           return 'ok'
         } else {
           console.log(hash, "!==", result[0].hash);
           return 'error'
         }
       }
     });
 }
};

AuthAPI.connectToDB();

if (AuthAPI.goAuth(user.name, user.password, ) === 'ok') {
  console.log('Пароль и логин совпали с базой данных');
} else {
  console.log('Пароль или логин не совпадает с данными в базе данных');
}