var app=require('express')();
var bodyParser=require("body-parser");
var mysql=require('mysql');
var http=require('http');
http.createServer(function (request, response) {
    response.writeHead(200, {'Content-Type': 'text/plain'});
    response.end();
}).listen(8081);
console.log('Server running at http://127.0.0.1:8081/');
var connection=mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: "",
    database: 'books'
});
connection.connect(function(err) {
    if ( !err ) {
        console.log("Connected to MySQL");
    } else if ( err ) {
        console.log(err);
    }
});
app.use(bodyParser.urlencoded({extended: false}));
app.use(bodyParser.json());
app.get('/book', function(req, res){
    var data={
        'error': 1,
        'Books': ""
    };
    connection.query("SELECT * FROM book", function(err, rows, fields){
        if(rows.length!=0){
            data['error']=0;
            data['Books']=rows;
            res.json(data);
        }else{
            data['Books']='No books found';
            res.json(data);
        }
    });
});