var session = require('express-session');
var FileStore = require('session-file-store')(session);

var sess_options = {
  path: "./tmp/sessions/",
  useAsync: true,
  reapInterval: 5000,
  maxAge: 1000*60*60*24*30*12
};

app.use(session({
  store: new FileStore(sess_options),
  secret: 'secret_key',
  name: 'connect.sid',
  resave : true,
  saveUninitialized : false,
  cookie: {
    domain   : 'example.com',
    maxAge   : 1000*60*60*24*30*12
  }
}));

router.post('/login', function(req,res,next){
var sess = req.session;

var username =  req.body.username;
var password = req.body.password;
var hash = crypto.createHash('sha256').update(password).digest('hex');
console.log("Password Hash ", hash);
connection.query('SELECT * FROM users WHERE username=? AND password=?',[username,hash], function (error,results,fields){
    console.log("Results: "+results);
    if(results.length > 0)
    {
        req.session.username = results[0].username;
        req.session.profile = results[0].profile;
        req.session.organization = results[0].organization;
        req.session.branch = results[0].branch;
        req.session.name = results[0].name;

        res.send("1");
    } else
    {
        res.send("No match");
    }
});

});

router.get('/logout', function(req,res,next){
res.clearCookie('connect.sid');

req.session.destroy(function(err) {

    });


res.send("1");
});

[0mOPTIONS /account/login [32m200 [0m43.349 ms - 4[0m
Results: [object Object]
[0mPOST /account/login [32m200 [0m135.829 ms - 1[0m
error: restarting script because add changed
error: Forever detected script was killed by signal: SIGKILL
error: Script restart attempt #11
connected as id 427
error: restarting script because add changed
error: Forever detected script was killed by signal: SIGKILL
error: Script restart attempt #12
connected as id 428
[0mGET /account/logout [32m200 [0m79.119 ms - 1[0m
error: restarting script because unlink changed
error: Forever detected script was killed by signal: SIGKILL
error: Script restart attempt #13
connected as id 429
[0mOPTIONS /account/login [32m200 [0m40.363 ms - 4[0m
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
Results: [object Object]
error: restarting script because add changed
error: Forever detected script was killed by signal: SIGKILL
error: Script restart attempt #14
connected as id 430
[0mOPTIONS /account/login [32m200 [0m31.751 ms - 4[0m
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
[session-file-store] will retry, error on last attempt: Error: ENOENT: no such file or directory, open 'tmp/sessions/LVjEYmzL3nARlBgqM6Sqy_q0dUYmYAYK.json'
Results: [object Object]
error: restarting script because add changed
error: Forever detected script was killed by signal: SIGKILL
error: Script restart attempt #15
connected as id 431