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

var pool = mysql.createPool({
    connectionLimit: 100,
    host: 'localhost',
    user: '',
    password: '',
    database: '',
    debug: false,
});

function handle_database(req, res) {

    pool.getConnection(function(err, connection) {
        if(err) {
            connection.release();
            res.json({"code": 100, "status": "Error in database connection"});
            return;
        }

        console.log('Connected as id: ', connection.threadId);

        connection.query('SELECT Varenavn FROM drikker LIMIT 1', function(err, rows) {
            connection.release();
            if(!err) {
                res.json(rows);
            }
        });

        connection.on('error', function(err) {
            res.json({"code": 100, "status": "Error in database connection"});
            return;
        });
    });
}

app.get("/", function(req, res) {
    handle_database(req, res);
});

app.listen(3000);