// login returns 401 Unauthorized

function login(email, password, callback) {
  const mysql = require('mysql');
  const bcrypt = require('bcrypt');

  const connection = mysql.createConnection({
    host: configuration.staging_host,
    user: configuration.staging_user,
    password: configuration.staging_password,
    database: configuration.staging_db
  });

  connection.connect();

  const query = 'SELECT id, email, encrypted_password FROM admins WHERE email = ?';

  connection.query(query, [ email ], function(err, results) {
    if (err) return callback(err);
    if (results.length === 0) return callback(new WrongUsernameOrPasswordError(email));
    const user = results[0];

    bcrypt.compare(password, user.encrypted_password, function(err, isValid) {
      if (err || !isValid) return callback(err || new WrongUsernameOrPasswordError(email));

      callback(null, {
        user_id: user.id.toString(),
        //   nickname: user.nickname,
        email: user.email
      });
    });
  });
}


// get by email, returns my email and id from the db

function getByEmail(email, callback) {
  const mysql = require('mysql');

  const connection = mysql.createConnection({
    host: configuration.staging_host,
    user: configuration.staging_user,
    password: configuration.staging_password,
    database: configuration.staging_db
  });

  connection.connect();

  const query = 'SELECT id, email FROM admins WHERE email = ?';

  connection.query(query, [ email ], function(err, results) {
    if (err || results.length === 0) return callback(err || null);

    const user = results[0];
    callback(null, {
      user_id: user.id.toString(),
     // nickname: user.nickname,
      email: user.email
    });
  });
}