basic_scriptJS.txt

const express = require('express');
const mysql = require('mysql');

require('dotenv').config();

const app = express();
const port = process.env.PORT || 1337;

let connection = mysql.createPool({
    connectionLimit : 100,
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASS,
    database: process.env.DB_NAME
});


app.get('/', function(req,res){
    connection.getConnection(function(error, tempCont){
            if(!!error){
                tempCont.release();
                console.log("error ");
            }
            else{
                console.log("ok");
                tempCont.query("SELECT * FROM test_table", function(error, rows, fields){
                    tempCont.release();
                    if(!!error){
                        console.log("error query");
                    }else{
                        res.json(rows);
                        console.log("end");
                    }
                });
            }
    });
})

app.listen(port);