"use strict";

var mysql = require('mysql');
var config = require('../config.json').db;
var logger = require('./logger');

var pool = mysql.createPool({
  connectionLimit: 10,
  host: config.host,
  user: config.user,
  password: config.password,
  database: config.name,
  socketPath: '/var/run/mysqld/mysqld.sock'
});

/**
 *
 * @param username
 * @param callback
 */
function getHashedUserPassword(username, callback) {
  logger.info(username);
  pool.getConnection((err, connection) => {
    if (err) {
      logger.error(err.message);
    } else {
      connection.query('SELECT password FROM users WHERE username=?',
        [username],
        (connection, result) => {
          connection.release();
          logger.error(JSON.stringify(result));
        });
    }
  });
}

module.exports.getHashedUserPassword = getHashedUserPassword;