const { check, validationResult } = require('express-validator/check');
var express = require('express');
var router = express.Router();
var db = require('../db');




router.post('/', function (req , res , next) {
    check('username').isLength({ min: 1 }).withMessage('username can\'t be empty')
    check('password').isLength({ min: 6 }).withMessage('password minimum length is 6')

    var username = req.body.username
    var password = req.body.password

    var query = `SELECT * FROM User WHERE username = "${username}" AND password = "${password}"`
    if (username && password) {
        database.query(query , function (err , rows , fields) {
            var errors = validationResult(req);
            if (!errors.isEmpty()) {
                return res.status(403).json({ errors: errors.mapped() });
            }
            else if(rows.length === 0) console.log("Wrong Username or Password");
            else{
                if (err) res.send(422)
                // TODO: redirect to departments
                // res.redirect('../departments')
            }
        });
    }
    else{
        res.send(401);
    }
});

module.exports = router;