使用mongoose分页填充

lc8prwob 于 2023-10-19 发布在 Go

关注(0)|答案(3)|浏览(115)

我尝试使用npmmongoose-paginate获取数据，但填充不工作
我的UsersSchema.js

var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var usersSchema = new Schema({
    name : String,
    created_at : { type : Date, default : Date.now }
});

module.exports = mongoose.model('users',usersSchema);

这里是post schema

var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var mongoosePaginate = require('mongoose-paginate');

var postsSchema = new Schema({
    user : { type: Schema.Types.ObjectId, ref: 'users' },
    post : String,
    created_at : { type : Date, default : Date.now }
});
postsSchema.plugin(mongoosePaginate);
module.exports = mongoose.model('posts',postsSchema);

这是我的问题

var options = {
    sort:     { created_at: -1 },
    lean:     true,
    offset:   offset,
    populate : 'users',
    limit:    10
};
postsSchema.paginate({user:user},options,function(err,posts){
    if(err){
        console.log(err)
        return false;
    }
    console.log(posts)
});

用户提供的objectID不是用户数据。即

[{
   user : objectID(987654ff11aa),
   post : 'post'
}]

mongoose

来源：https://stackoverflow.com/questions/48114129/populate-with-mongoose-pagination

3条答案

按热度按时间

puruo6ea1#

如果你想使用mongoose-paginate，你可以做以下事情

var query = {};
var options = {
  sort: { date: -1 },
  populate: 'users',
  lean: true,
  offset: offset, 
  limit: 10
};

Post.paginate({}, options, (err, result) => {
 //....
})

赞(0）回复(0）举报 2023-10-19

1wnzp6jl2#

一个族群有以下几样东西

Post.find({})
.populate([
    // here array is for our memory. 
    // because may need to populate multiple things
    {
        path: 'user',
        select: 'name',
        model:'User',
        options: {
            sort:{ },
            skip: 5,
            limit : 10
        },
        match:{
            // filter result in case of multiple result in populate
            // may not useful in this case
        }
    }
])
.exec((err, results)=>{
   console.log(err, results)
})

赞(0）回复(0）举报 2023-10-19

aiqt4smr3#

//* Here are my option that i will use to paginate
var options = {
    sort : { created_at: -1 } ,
    lean : true ,
    populate : 'category_id' ,
    page : req.query.page  ,
    limit : 10 ,
};

//* Paginate with populate
const subcategories = await subcategoryModel.paginate( {} , options ) ;

//* Send all subcategories with the name of the category
if ( subcategories ) {
    return res.status(200).json(subcategories) ;
}

赞(0）回复(0）举报 2023-10-19

我来回答

使用mongoose分页填充

3条答案

相关问题

热门标签

最新问答