[{"id":1,"name":"Rita","cellphone":"93999292","provider":{"name":"AT&T, "code":15}}]

var express = require("express");
var mysql = require("mysql");
var app = express();

var pool = mysql.createPool({
    connetionLimit: 100,
    host: "localhost",
    user: "root",
    password: "toor",
    database: "contacts",
    debug: "false"
});

function handle_database(request, response, query) {
    pool.getConnection(function (err, connection) {
        if (err) {
            response.json({"code": 100, "status": "Error connecting to the database."});
            return;
        }

        connection.query(query, function (err, rows) {
            connection.release();

            if (!err) {
                response.header("Access-Control-Allow-Origin", "*");
                response.json(rows);
            }
        });

        connection.on("error", function (err) {
            response.json({"code": 100, "status": "Error connecting to the database."});
            return;
        });
    });
}

app.get("/", function (request, response) {
    response.send("Default");
});

app.get("/listContacts", function (request, response) {
    var _query = "select * from contact";
    handle_database(request, response, _query);
});

app.listen(3000);