I need assistance implementing the following SQL code in knex.js:
select c.id,c.parent_id,c.comment,u.username,c.postid from comments as
c join post_details as p on (p.id = c.postid and c.postid=15)join
users as u on (u.id = c.userid);
I attempted to do this using the following JavaScript code:
db('comments AS c')
.join('post_details AS p', function () {
this.on('p.id', '=', 'c.postid').on('c.postid', '=', db.raw('?', [postid]));
})
.join('users AS u', 'u.id', '=', 'c.userid')
.select(['c.id', 'c.parent_id', 'c.comment', 'u.username', 'c.postid', 'c.userid'])
.then((data) => {
console.log(data);
res.json(data);
})
.catch((err) => res.status(400).json('unable to fetch'));
However, I am encountering issues with fetching the data when calling the URL.
Your help with resolving this matter would be greatly appreciated. Thank you in advance.