var express = require('express');
var router = express.Router();
var session = require('express-session');

var app = express();

//init connection
var conn = require('./cfg');
conn = conn.connection;


app.use(session({ secret: 'keyboard cat',resave: false, saveUninitialized: true, cookie: { id: 0 }}))

//page request TODO POST  at the moment put 'real' username and password
router.get('/', function(req, res) {
    //setCookie();
    if (req.session.cookie.id) {
    conn.query('SELECT * FROM users WHERE username=? AND password=?',["admin", "123"], function(err, rows, fields) {
    if (err) { throw err; }
    if(rows.length){
        var id = rows[0].password;
        sess.id = id;
    }
    });
    if(sess.id){
        res.write('Hello User! ');
    }
    } else {
        sess.views = 1
        res.end('welcome to the session demo. refresh!')
    }
  res.send('HomePage');
});

module.exports = router;