mongoose add a field to a document from another document-CodePudding

The

There is Categories list, each category have number of viewers from VideoSchema (viewers field). If there is no video for that category then should have 0 viewers or if we have video for that category we print number of viewers from 0 to 2^32

Also I have changes in VideoSchema, for now its with ref to Categories

const VideoSchema = new Schema<IVideo>({ videoSource: String, // from CategoriesSchema category: { ref: 'Categories' }, viewers: Number, });

CodePudding user response：

Does this answer your question:

If I understand correctly, you want for each category, to add the sum of viewers from the relevant videos, sort and slice.

On mongoDB you can easily do it all in one query. Since you want to get categories with 0 viewers as well, we will start from the category collection:

$lookup to get all videos per category and sum the number of viewers per each category inside the $lookup pipeline, to minimize data transformation between the collections.

Format the response and handle cases of no video data

$sort by number of viewers, $skip and $limit - for the slicing. Add the _id to the $sort as a second option, in order to keep it sorted even for 0 viewers categories.

db.category.aggregate([ { $lookup: { from: "video", let: {category_id: "$_id"}, pipeline: [ {$match: {$expr: {$eq: ["$category", "$$category_id"]}}}, {$group: {_id: 0, viewers: {$sum: "$viewers"}}} ], as: "viewers" } }, {$set: {viewers: {$ifNull: [{$first: "$viewers.viewers" }, 0]}}}, {$sort: {viewers: -1, _id: 1}}, {$skip: offset}, {$limit: limit} ])

See how it works on the playground example