app.js

// pridanie serveru express
// @link: http://expressjs.com/
var express = require('express');
var bodyParser = require('body-parser');
// pridanie template enginu handlebars
// @link: https://github.com/ericf/express-handlebars
var express_handlebars = require('express-handlebars');
var session = require('express-session');

// pridanie a nastavenie knex databázového wrapperu
// @link: http://knexjs.org/
var knex = require('knex')({
    client: 'mysql',
    connection: {
        host: '127.0.0.1',
        user: 'root',
        password: 'root',
        database: 'node'
    }
});

// vytvorenie express inštancie
var app = express();

// pridanie handlebars ako view enginu pre express
app.engine('handlebars', express_handlebars({defaultLayout: 'main'}));

// nastavenie defaultného view enginu na handlebars
app.set('view engine', 'handlebars');

app.use(bodyParser.urlencoded({extended: false}));

app.use(session({
    secret: 'some secret!', // important to stay secret!
    resave: false,
    saveUninitialized: true
}));

app.use(function (req, res, next) {
    console.log(req.session);

    req.isAuthentificated = function () {
        return !!req.session.user;
    };

    req.session.user = {
        name: 'Test Testerson'
    };

    next();
});

// pridanie middleware, vždy sa vykoná predtým než sa vykoná nasledujúce
app.use(function (req, res, next) {
    console.log(req.url);

    // spustí vykonanie nasledujúceho
    next();
});

// routa na /, teda hlavnú stránku
app.get('/', function (req, res) {
    knex.select('*').from('books').then(function (results) {
        res.render('pages/home', {
            books: results
        });
        //res.json(results);
    }).catch(function (error) {
        console.log(error);
    });
});

app.post('/login', function (req, res) {
    if (
        req.body.name === 'test' &&
        req.body.password === 'password'
    ) {
        req.session.user = {
            name: 'Test Testerson'
        };
        res.redirect('/');
    } else {
        res.send('Wrong username/password.');
    }
});

app.get('/login', function (req, res) {
    res.render('pages/login');
});

// routa na book/:id
app.post('/book/add', function (req, res) {

    var title = req.body.title;
    var description = req.body.description;

    knex('books').insert({title: title, description: description}).then(function (result) {
        res.redirect("/");
    }).catch(function (error) {
        console.log(error);
    });

});

// routa na book/:id
app.get('/book/:id', function (req, res) {
    var id = req.params.id;

    knex.select('*').from('books').where('id', id).then(function (results) {
        res.render('pages/book', {
            books: results
        });
        //res.json(results);
    }).catch(function (error) {
        console.log(error);
    });
});


// routa na book/:id/delete
app.get('/book/:id/delete', function (req, res) {
    var id = req.params.id;

    knex.delete().from('books').where('id', id).then(function (results) {
        res.redirect('/');
    }).catch(function (error) {
        console.log(error);
    });
});

// všetky predtým nehachytené routy, vhodné pre 404
app.get('*', function (req, res) {
    res.json(req.url);
});

// spustenie serveru na danom porte
var port = 8000;
app.listen(port, function () {
    console.log('App is listening on port ' + port + '!');
});

// v konzoli zapnúť pomocou node 'app.js', alebo 'nodemon app.js'