var restify = require('restify');
var server = restify.createServer();
require('./routes.js').setRoutes(server);
server.listen(8081, function () {
    console.log('%s is listening at %s', server.name, server.url);
});

const handlers=require('./handlers.js');
function setRoutes(server) {
    server.get('/get', handlers.getHandler);
    server.put('/update', handlers.putHandler);
    server.post('/post', handlers.postHandler);
    server.del('/delete', handlers.delHandler);
}
exports.setRoutes=setRoutes;

require('./dbconnection.js').connFunc();
module.exports = {
    getHandler(req, res, next){
        connectionPool.getConnection(function (err, connection) {
            if (err) {
                res.send({
                    Error: err,
                    Message: "Can't connect Database."
                });
            } else {
                //queries
                connection.query("SELECT * FROM book", function (err, rows, fields) {
                    res.send("Hello"+rows);
                });
            }
        });
    },
/*...........MORE handlers ........*/
}

function connFunc() {
    var mysql=require('mysql');
    var connectionPool = mysql.createPool({
        host: 'localhost',
        user: 'root',
        password: '',
        database: 'books'
    });
}
exports.connFunc=connFunc;