I'm currently running a nodeJS server using the express framework.
When sending a request to the server, it should respond with data in an array format. However, instead of receiving the expected data, I am getting ''.
The specific test I'm attempting to pass is:
it('should send postgres data to the server', function(done) {
request(app)
.post('/chart')
.send({min:"1",max:"100",arrayLength:"12"})
.expect(200, sqlData)
.end(function(err, res){
if(err) {
done(err);
} else {
done();
}
});
});
Note that the response should match the value of sqlData being sent back.
Here's what happens when the router receives a POST request:
router.post('/', function(req, res) {
res.send(randomSqlTableSelector(req.body.min,req.body.max,req.body.arrayLength));
});
I have verified that req.body.min, max, and arrayLength contain the correct values.
The issue likely lies within my function randomSqlTableSelector. Whenever this function is called inside the router, it only returns empty quotes ''.
This is how the function looks like:
function randomSqlTableSelector(min,max,arrayLength) {
var filledArray = [];
pg.connect(conString, function(err, client, done) {
if(err) {
return console.error('error fetching client from pool', err);
}
client.query('SELECT cell1 FROM random AS retrievedNumber;', function(err, result) {
var psqlData = result.rows;
for (i in psqlData) {
filledArray.push(psqlData[i]["cell1"])
}
return filledArray
});
});
}