Does Mongoose support the Mongodb `findAndModify` method?

Question

I would like to use findAndModify to atomically increment a field, using Mongoose.

However, the code below throws the error "TypeError: Object # has no method 'findAndModify'":

// defining schema for the "counters" table var tableSchema = new Schema({     _id: String,     next: Number         });  // creating table object for the counters table var counters_table = mongoose.model('counters', tableSchema); var tableObj = new counters_table();      // increment the "next" field on the table object var query = {_id: 'messagetransaction'}; var update = {'$inc': {next: 1}}; var ret = tableObj.findAndModify(query, [], update, true, true, function(err) {      if (err) {           throw err;      }      else {           console.log("updated!");      } }); 

Answer 1

The feature is not well (read: at all) documented, but after reading through the source code, I came up with the following solution.

Create your collection schema.

var Counters = new Schema({   _id: String,   next: Number      }); 

Create a static method on the schema which will expose the findAndModify method of the model's collection.

Counters.statics.findAndModify = function (query, sort, doc, options, callback) {   return this.collection.findAndModify(query, sort, doc, options, callback); }; 

Create your model.

var Counter = mongoose.model('counters', Counters); 

Find and modify!

Counter.findAndModify({ _id: 'messagetransaction' }, [], { $inc: { next: 1 } }, {}, function (err, counter) {   if (err) throw err;   console.log('updated, counter is ' + counter.next); }); 

Bonus

Counters.statics.increment = function (counter, callback) {   return this.collection.findAndModify({ _id: counter }, [], { $inc: { next: 1 } }, callback); };  Counter.increment('messagetransaction', callback); 

Answer 2

This is fully supported in Mongoose 3.x now, though the name is slightly different.

http://mongoosejs.com/docs/api.html#model_Model.findOneAndUpdate

http://mongoosejs.com/docs/api.html#model_Model.findByIdAndUpdate

http://mongoosejs.com/docs/api.html#model_Model.findOneAndRemove

http://mongoosejs.com/docs/api.html#model_Model.findByIdAndRemove