Home > Enterprise >  How to delete all documents of all collections in Mongoose
How to delete all documents of all collections in Mongoose

Time:01-20

Using the Mongoose ODM with a MongoDB instance, how can one delete all documents in all collections of the database instance, without necessarily destroying the collections themselves or their indexes?

For contrast:

await mongoose.connection.db.dropDatabase();

Deletes the given database, including all collections, documents, and indexes.

according to the Mongoose docs, which is not desired.

CodePudding user response:

Iterate over all collections in the database given by the values of the Connection.prototype.collections hash, and use Query.prototype.deleteMany() to delete every document in the collection.

The deleteMany() query/operation is asynchronous (it returns a Query promise-like object). In order to iteratively perform the operations for all collections, we can map each collection to a promise with an asynchronous callback in which we await the call, and use Promise.all to resolve when all of the queries have resolved.

async function clearCollections() {
  const collections = mongoose.connection.collections;

  await Promise.all(Object.values(collections).map(async (collection) => {
      await collection.deleteMany({}); // an empty mongodb selector object ({}) must be passed as the filter argument
  }));
}
  •  Tags:  
  • Related