Reset to specific value or decrement method about mongoose-sequence HOT 6 CLOSED

What if the document that gets deleted is not the last one. i.e. if the last document inserted has the counter to 10 and you remove the document 5 what should happen? You cannot reset the counter to 9 or 4. This library mimic the SQL index where the index is not really bound to the entries in the DB but is more like an internal counter.

I would say this is not a feature I'd implement but maybe I'm missing some use case, so let's discuss further if you think it's worth it.

from mongoose-sequence.

But even in that case, you should not reset the counter or decrease. When you delete documents, the counter must be always the highest possible, not the first available. In SQL world it's how it works. If you delete last row which has an index of 5, next insertion will have index of 6, not 5.

from mongoose-sequence.

Maybe a function like resetCounter, but to change the value of counter to a specific value?

I new to mongoose and your package is super useful.

from mongoose-sequence.

What is the use case? I always have the feeling that the use case may be wrong, so let me understand better yours

from mongoose-sequence.

I can imagine a use case of deleting the last batch of documents, e.g. a bunch of spam users or spam comments. But it's got to be the very last, and I'm not sure re-setting the counter is worth the risk that you'll later overwrite a legit document.

There are already risks with not using the native ObjectID.

from mongoose-sequence.

Product.counterReset('idProduct', function(err) {
// Now the counter is 0
});

from mongoose-sequence.