router.post('/login', function(req, res){
    let username = req.body.username;
    let password = req.body.password;
    User.findUser(username, function(err, user){
        if(err) return res.status(500).send('Error on the server');
        if(!user) return res.status(404).send('No user found');

        var passIsValid = bcrypt.compareSync(password, user[0].password);
        if(!passIsValid) return res.status(401).send({auth: false, token: null});

        var token = jwt.sign({id: username}, config.secret, {
            expiresIn: 86400

        });

        res.status(200).send({auth: true, token: token});
    });
});

findUser: function(username, callback){
        let data = db.query("SELECT * FROM user WHERE username=?",[username], callback, function(error, results, fields){
            if(error) throw err
            return results;
        });

    }

findUser: (username, callback) => {
  let data = db.query("SELECT * FROM user WHERE username=?", [username], function (error, results, fields) {
    if (error) return callback(error, undefined)
    return callback(undefined, results)
  })
}