First of all, I'm a node.js newbie and I'm struggling with how to transform JSON data from postgres to match what I need to return from my API. Here is the code:
function readUsers(req, res, next) {
console.log('database string is ' + process.env.DB_CONNECTION_STRING);
var client = new database.Client(process.env.DB_CONNECTION_STRING);
client.connect();
console.log(req.body);
var queryString = `SELECT * from readusersbynamejson(${req.query.user_id}, '${req.query.username}', ` +
`${req.query.limit_count}, ${req.query.offset})`;
console.log("Executing: ", queryString);
client.query(queryString, function(err, result) {
console.log("query complete");
client.end();
if (err) {
console.log("error = ", err);
return next(err);
} else {
console.log("RowCount ", result.rowCount);
var rowData = [];
result.rows.map(function(row) {
try {
console.log ("Row Data: ");
console.log(row);
console.log(row.readusersbynamejson);
//console.log("Trying to parse");
//row.data = JSON.parse(row.data);
console.log("Trying to set to subnode");
return row["readusersbynamejson"];
rowData[''].push(r)
//row.
//console.log("Result: " + row);
} catch (e) {
console.log("Exception thrown");
console.log(e);
row.data = null;
return row;
}
//return newRow;
});
console.log(result.rows);
res.status(200).json({
status: 'success',
//data: result.rows[0].readusersbynamejson,
data: result.rows,
message: 'Retrieved all data'
});
}
});
}
This is what the postgres function returns:
{
"status": "success",
"data": [
{
"readusersbynamejson": {
"user_id": 3,
"auth_type": 1,
"status": 1,
"user_identity": "user3",
"username": "mgarcia",
"email_address": "[email protected]",
"phone_number": "11234567890",
"timestamp": 1537846141,
"image_reference": "",
"name": null,
"bio": null,
"friend_status": 0,
"friend_status_initiated": 0,
"post_count": 0
}
},
{
"readusersbynamejson": {
"user_id": 2,
"auth_type": 1,
"status": 1,
"user_identity": "user2",
"username": "jdoe",
"email_address": "[email protected]",
"phone_number": "11234567890",
"timestamp": 1537846110,
"image_reference": "",
"name": null,
"bio": null,
"friend_status": 0,
"friend_status_initiated": 0,
"post_count": 0
}
}
],
"message": "Retrieved all data"
}
I really want to remove the postgres function name from JSON but I might need to modify other portions of it. Can someone give me a small code snippet on how to transform JSON? I've wrestled with this for several hours and clearly I'm missing something fundamental here.
