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

var fs = require("fs");
var file = __dirname+"/"+"database.db";
var exists = fs.existsSync(file);
if(!exists) {
  fs.openSync(file, "w");
}

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(file);

/* GET home page. */
router.get('/', function(req, res, next) {
  res.render('index', { title: 'Express' });
});

router.get('/info/:id', function(req, res, next) {
  res.render('testmc', {
    title: req.params.id,
    imgSrc: "../images/the%20hitchhiker_s%20guide%20to%20the%20galaxy%20book%20cover.jpg",
    imgAlt: "Cover of the Hitchhiker's Guide to the Galaxy book.",
    bookSummary: "The Hitchhiker's Guide to the Galaxy begins with contractors arriving at Arthur Dent's house, in order to demolish it to make way for a bypass. His friend, Ford Prefect, arrives while Arthur is lying in front of the bulldozers, to stop them from demolishing it. He tries to explain to Arthur that he is actually from a planet somewhere in the vicinity of Betelgeuse and that the Earth is about to be demolished. The Vogons, an alien race, intend to destroy Earth to make way for a hyperspace bypass. The two escape by hitching a lift on one of the Vogons' ships; this is, however, against Vogon regulations and when the pair are discovered, they are tortured with a rendition of Vogon poetry, the third worst in the known Universe, and then thrown into space. They are, very improbably, picked up by the Heart of Gold, a ship powered by an infinite improbability drive, and has been stolen by Ford's semi-cousin and President of the Galaxy, Zaphod Beeblebrox. Zaphod, accompanied by Trillian and the clinically depressed robot Marvin, are searching for the legendary planet of Magrathea.",
    price: "12.50",
    publisher: "Pan Books",
    author: "Douglas Adams",
    genre: "Science Fiction"
  })
});

router.get('/profile/:id', function(req, res, next){
  res.render('profile', {
    title: "Profile" + req.params.id,
    username: req.params.id,
    email: "TwanVisser888@zuigt.hard",
    password: "hunter888"
  })
});


router.get('/database', function(req, res, next){
  db.serialize(function () {
    db.each('SELECT book_id as id, title as name FROM book', function (err, row) {
      if (err) {
        console.log(err);
      }
      console.log(row.id + "\t" + row.name);
    })
  });
});


db.close();
module.exports = router;