mongoose pagination

[Lazar Gubezkis]

I'm trying to use the mongoose-paginate plugin: https://www.npmjs.com/package/mongoose-paginate

This is my code, but I'm getting an error: undefined is not a function

 

    var mongoose = require('mongoose'),

        mongoosePaginate = require('mongoose-paginate'),

        db = mongoose.connection;

/*********************************************************************************/

/* Connect to DB */

/*********************************************************************************/

mongoose.connect('mongodb://localhost/users');

db.on('error', console.error.bind(console, 'Connection error:'));

db.once('open', function (callback) {

    console.log('Connected to MongoDB!');

    var userSchema = mongoose.Schema({

        firstName: String,

        lastName: String,

        userName: String,

        password: String

    });

    

    

    userSchema.plugin(mongoosePaginate);

    userSchema.paginate({}, { // this is what's causing the error

        page: 2, limit: 1

    }, function(err, results, pageCount, itemCount) {

    console.log(results);

    });

});

[Daniel Alberto Martinez]

Pagination docs with mongodb driver:

http://docs.mongodb.org/manual/reference/method/cursor.skip/#cursor.skip

[Paolo Nicorelli]

Uhm... it seem the `paginate()` method apply to the model, not the schema:

    var mongoose = require('mongoose'),
        mongoosePaginate = require('mongoose-paginate'),
        db = mongoose.connection;


/*********************************************************************************/
/* Connect to DB */
/*********************************************************************************/

mongoose.connect('mongodb://localhost/mpaginate');

db.on('error', console.error.bind(console, 'Connection error:'));
db.once('open', function (callback) {
    console.log('Connected to MongoDB!');
    var userSchema = mongoose.Schema({
        firstName: String,
        lastName: String,
        userName: String,
        password: String
    });
    userSchema.plugin(mongoosePaginate);

    var User = mongoose.model('users', userSchema);
    var u = new User({
        firstName: "p",
        lastName: "p",
        userName: "p",
        password: "p"
    });
    u.save();


    User.paginate({}, { page: 1, limit: 1 }, function(err, results, pageCount, itemCount) {
        if(err){
        console.log("error");
        console.log(err);
    } else {
        console.log(results);
    }
    });

});

This chunck is working on my local