CODEWITHSUNDEEP
javascriptnode.jsmongodbmongoosemongodb-query
zr0gravity7
zr0gravity7

Reputation: 3194

How to delete all documents of all collections in Mongoose

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.

Upvotes: 3

Views: 5047

Answers (1)

zr0gravity7
zr0gravity7

Reputation: 3194

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((collection) =>
    collection.deleteMany({}) // an empty mongodb selector object ({}) must be passed as the filter argument
  ));
}

Upvotes: 7

Related Questions