let express = require("express");
let bodyParser = require("body-parser");
let mysql = require('mysql');

let hostname = 'localhost';
let port = 3000;

let app = express();

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

let connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: ''
});

let rooter = express.Router();

rooter.route('/piscines')
    .post(function(req, res) {

        var pool = mysql.createPool({
            connectionLimit: 10,
            host: '',
            port: 3306,
            user: '',
            password: '',
            database: ''
        });

        pool.getConnection(function(err, connection) {
            if (err) throw err;
            var query = 'SELECT * FROM `users`';

            connection.query(query, function(error, results) {
                if (error) throw error;

                console.log(results);
                res.json({ success: "All ok !" });
                connection.release();
            });
        });
    });

app.use(rooter);

app.listen(port, hostname, function() {
    console.log("Starting server, port :" + port);
});