Incrementing a value with mongoose?

Question

I have a mongoose model in my node.js application, representing invoices. I have figured most of it out already, but I really need to ensure that my invoices are numerated/incremented to be able to provide a proper reference to my customer.

Using an SQL database, I would have created an AUTO-INCREMENT column holding this value, but this obviosly isn't built into MongoDB. So how would I accomplish this with mongoose?

Here's how my model looks right now:

var InvoiceSchema = new Schema({
    reference: {type: Number, default: 0}, // The property I want to auto-incr.

    dates: {
        created:  {type: Date, default: Date.now},
        expire: {type: Date, default: expiryDate()}
    },

    amount: {type: Number, default: 0}
    // And so on
});

score 27 · Answer 1 · edited Jan 10 '17 at 04:12

27

Controller.findByIdAndUpdate(ID_HERE, {$inc: {next:1}}, function (err, data) {


});

// next is the field , type: Number

edited Jan 10 '17 at 04:12

JoeTidee

24,754
25
104
149

answered Apr 01 '14 at 04:02

keithics

8,576
2
48
35

1

For the title of the question, this is the answer most people will be looking for. – tbh__ Jan 15 '17 at 03:06
If you need to increment a document field, you can use `your_doc.update({$inc: {next:1}})` directly. [Doc here](http://mongoosejs.com/docs/api.html#document_Document-update) – lifeisfoo Jul 25 '17 at 15:33

score 4 · Accepted Answer · answered Jan 24 '12 at 13:31

Generally in MongoDB, one does not use an auto-increment pattern for _id's (or other fields), as this does not scale up well on large database clusters. Instead one typically uses Object IDs.

For more info checkout this link: http://www.mongodb.org/display/DOCS/How+to+Make+an+Auto+Incrementing+Field

So bottom line you can just use Object IDs, those are unique.

score 1 · Answer 3 · answered Jan 24 '12 at 13:28

Is this what you looking for?

Let's say UserSchema and InvoiceSchema looks like this:

var UserSchema = new Schema({
    email: String,
    // other fields
    invoices: [{ type: Schema.Objectid, ref: 'Invoice' }]
});

var InvoiceSchema = new Schema({
    reference: { type: Schema.Objectid, ref: 'User' },

    dates: {
        created:  {type: Date, default: Date.now},
        expire: {type: Date, default: expiryDate()},
    },

    amount: {type: Number, default: 0}
    // And so on
});

score 0 · Answer 4 · answered Aug 11 '17 at 23:03

Riffing on keithic's answer:

You can add an additional object to make sure to receive the document AFTER it's been incremented, as such, I am using lean() and exec() to make sure the document is a plain Javascript object:

Controller.findByIdAndUpdate(ID_HERE, {$inc: {next:1}}, { $new: true})
   .lean().exec(function (err, data) {


});

Incrementing a value with mongoose?

4 Answers4

Linked