How to extract duplicate key name from a MongoError (E11000) in Javascript?

Question

I have a collection with a field 'email' in MongoDB and a unique index on this field. If I try to insert a document with an existing 'email' I get the following error

error:  name=MongoError, message=E11000 duplicate key error index: testDB.users.$email_1 dup key: { : "[email protected]" }, index=0, code=11000, errmsg=E11000 duplicate key error index: testDB.users.$email_1 dup key: { : "[email protected]" }

Is there a proper way to get the exact key name from the error message to help identify the exact key that caused the duplicate key error i.e how to extract the 'email' from the error message above?

Possible duplicate of Mongoose / Mongodb update return value and error handling — Rubén S. García
– Rubén S. García, Commented Jun 21, 2017 at 4:15

Masoud Karimi · Accepted Answer · 2022-07-20 14:00:32Z

0

Extract filed key

let field = (error.errmsg.match(/[index: ]\w+[_1]/)[0].split('_1')[0]).replace(' ', ''); // return 'email'

or

let field = error.message.split('.$')[1]; // return 'email_1 dup key: { : "[email protected]" }'
field = field.split(' dup key')[0]; // return 'email_1'
field = field.substring(0, field.lastIndexOf('_')); // return 'email'

Extract filed value

let value = (error.errmsg.match(/(["'])(\\?.)*?\1/)[0]).replaceAll('"', ''); // return '[email protected]'

edited Jul 20, 2022 at 14:00

answered Jul 20, 2022 at 13:47

Masoud Karimi

12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to extract duplicate key name from a MongoError (E11000) in Javascript?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related