如何使用相关方法在书架内获取计数

Question

我正在尝试获取类似的计数值。它返回一个数组，我只想知道是否有办法获取数组的计数

router.get('/uploads', (req, res) => {
Image.query((image) => {
image.orderBy('img_url', 'DESC');
image.limit(10);
// if you want to include the user with the image, you would use the withRelated
// comments.user gets the user within the comments array
})
.fetchAll({
withRelated: [
'user',
{
comments: (qb) => {
qb.orderBy('created_at', 'ASC');
},
},
'comments.user',
{
likes: (qb) => {
// how to get count for likes model its returning an array, i just want
// count value
}
}
],
})
.then(images => res.status(200).json(images.toJSON()));
});

Answer 1

通过添加书架口才解决了这个问题，并添加了withCount

现在路由器看起来像这样

router.get('/uploads', (req, res) => {
Image.query((image) => {
image.orderBy('img_url', 'DESC');
image.limit(10);
// if you want to include the user with the image, you would use the withRelated
// comments.user gets the user within the comments array
})
.withCount('likes as likeCount')
.fetchAll({
withRelated: [
'user',
{
comments: (qb) => {
qb.orderBy('created_at', 'ASC');
},
},
'comments.user',
],
})
.then(images => res.status(200).json(images.toJSON()));
});