How to implement Mongoose-paginate in Node Express?

Question

I am trying to implement in my project Node Express paging in a menu list, and I found this documentation right below;

MONGOOSE-PAGINATE

According to the instructions I first installed lib with that command;

npm install mongoose-paginate

Then I set up my menu model including that line of code;

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

And this one too;

schema.plugin(mongoosePaginate);

As shown below;

'use strict'

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

const schema = new Schema({
    id: {
        type: String,
        trim: true
    },
    name: {
        type: String,
        trim: true

    },
    description: {
        type: String,
        trim: true
    },
    restaurantId: {
        type: String,
        trim: true
    },
    price: {
        type: Number,
        trim: true
    },

})

schema.plugin(mongoosePaginate);
module.exports = mongoose.model('Menu', schema);

Then I created the method that will make the pagination this way below;

function getMenusPage (req, res) {
    Menus
    .find({ }, { page: 3, limit: 5 }, function(err, menu)  {
        if(err){
            res.status(500).send({
                message: 'Error na solicitação'
            });
        }else{
            if(!menu){
                res.status(404).send({
                    message: 'Não existe nenhum menu nesse registro'
                });
            }else{
                res.status(200).send({
                    menu
                });
            }
        }
    })
}

There is no error in the code or console, what I would like to know is how I will test in Postman to know if the implementation is correct?

I tried to do it that way

router.get('/menuspage', controller.getMenusPage);

With that URL;

http://localhost:3000/menuspage

But I made the mistake 404

Answer 1

Good morning wladyband I would advise you to make the pagination with the module api-query-params It is very easy to use and you can easily adapt to the project. In addition to paging you can still make filters. Ex: do you mind the module

var aqp = require('api-query-params');

then imagine you want to list a complete collection. Ex: //List All Providers

exports.list_all_dataProviders = async (req, res) => {

  const { filter, skip, limit, sort, projection } = aqp(req.query);
  Provider
    .find(filter)
    .skip(skip)
    .limit(limit)
    .sort(sort)
    .select(projection)
    .exec(async (err, result) => {

      if (err) {
        return res.status(500).jsonp({message:"There was an internal error listing all the providers " + err});
      }

      let count = await Provider.find().count()


      res.status(200).jsonp({
        limit: limit,
        skip: skip,
        total: count,
        data: result
      });
    });

};

for paging use Skip and limit. However I think what you are missing if you want to keep Mongoose paginate is to call the method so.

var Menu= mongoose.model('Menu',  schema);
Menu.paginate();

and there you must have access to the available methods.

Mongoose-paginate-npm I hope it has helped , some doubt disposes