deleteMany method in MongoDB - Mini Project: Build & Apply

Using the deleteMany Method in MongoDB

📖 Scenario: You manage a small online bookstore database. Over time, some books become outdated or irrelevant. You want to clean up your database by removing all books from a specific author.

🎯 Goal: Learn how to use the deleteMany method in MongoDB to remove multiple documents that match a condition.

📋 What You'll Learn

Create a collection called books with specific book entries

Define a filter to select books by a certain author

Use the deleteMany method with the filter to remove those books

Verify the final state of the books collection after deletion

💡 Why This Matters

🌍 Real World

Cleaning up outdated or irrelevant data in a database is common in real-world applications to keep data accurate and storage efficient.

💼 Career

Database administrators and backend developers often use deleteMany to manage large datasets by removing multiple records at once based on conditions.

1

Create the books collection with sample data

Create a variable called books that is an array of documents. Include these exact entries: { title: "Learn MongoDB", author: "John Doe", year: 2018 }, { title: "Advanced MongoDB", author: "Jane Smith", year: 2020 }, { title: "MongoDB Basics", author: "John Doe", year: 2017 }, { title: "Node.js Guide", author: "Alice Brown", year: 2019 }.

MongoDB

// Create the books array with the specified documents
// Your code here

Hint

Use const books = [ ... ] and include all four book objects exactly as shown.

2

Define a filter to select books by author "John Doe"

Create a variable called filter and set it to an object that matches documents where the author field is exactly "John Doe".

MongoDB

const books = [
  { title: "Learn MongoDB", author: "John Doe", year: 2018 },
  { title: "Advanced MongoDB", author: "Jane Smith", year: 2020 },
  { title: "MongoDB Basics", author: "John Doe", year: 2017 },
  { title: "Node.js Guide", author: "Alice Brown", year: 2019 }
];

// Define the filter to select books by John Doe
const filter = { author: "John Doe" };

Hint

Use const filter = { author: "John Doe" }; to create the filter object.

3

Use deleteMany to remove books by "John Doe"

Assuming you have a MongoDB collection object called booksCollection, write a line that calls deleteMany on booksCollection using the filter variable to delete all books by "John Doe".

MongoDB

const books = [
  { title: "Learn MongoDB", author: "John Doe", year: 2018 },
  { title: "Advanced MongoDB", author: "Jane Smith", year: 2020 },
  { title: "MongoDB Basics", author: "John Doe", year: 2017 },
  { title: "Node.js Guide", author: "Alice Brown", year: 2019 }
];

const filter = { author: "John Doe" };

// Use deleteMany on booksCollection with filter
booksCollection.deleteMany(filter);

Hint

Call booksCollection.deleteMany(filter); to delete matching documents.

4

Verify the remaining books after deletion

Write a line that calls find() on booksCollection without any filter to get all remaining books.

MongoDB

const books = [
  { title: "Learn MongoDB", author: "John Doe", year: 2018 },
  { title: "Advanced MongoDB", author: "Jane Smith", year: 2020 },
  { title: "MongoDB Basics", author: "John Doe", year: 2017 },
  { title: "Node.js Guide", author: "Alice Brown", year: 2019 }
];

const filter = { author: "John Doe" };

booksCollection.deleteMany(filter);

// Get all remaining books
booksCollection.find();

Hint

Use booksCollection.find(); to retrieve all remaining documents.

Practice

1. What does the deleteMany method do in MongoDB?

easy

A. Inserts multiple documents into a collection.

B. Deletes only one document regardless of the filter.

C. Removes all documents that match a given filter.

D. Updates multiple documents based on a filter.

Solution

1. Step 1: Understand the purpose of deleteMany

   The deleteMany method is designed to remove multiple documents that match a specified filter in a collection.

2. Step 2: Compare with other methods

   Unlike deleteOne which deletes a single document, deleteMany deletes all matching documents. It does not update or insert documents.

3. Final Answer:

   Removes all documents that match a given filter. -> Option C

4. Quick Check:

   deleteMany removes multiple matching documents = D [OK]

Hint: deleteMany deletes all matching documents, not just one [OK]

Common Mistakes:

• Confusing deleteMany with deleteOne
• Thinking deleteMany updates documents
• Assuming deleteMany inserts documents

2. Which of the following is the correct syntax to delete all documents where status is "inactive" using deleteMany?

easy

A. db.collection.deleteMany({status: "inactive"})

B. db.collection.deleteMany("status = 'inactive'")

C. db.collection.deleteMany(status == "inactive")

D. db.collection.deleteMany([status: "inactive"])

Solution

1. Step 1: Identify correct filter syntax

   The filter in deleteMany must be a JSON object with key-value pairs, like {status: "inactive"}.

2. Step 2: Check each option

   db.collection.deleteMany({status: "inactive"}) uses correct JSON object syntax. Options B, C, and D use invalid syntax for MongoDB filters.

3. Final Answer:

   db.collection.deleteMany({status: "inactive"}) -> Option A

4. Quick Check:

   Filter must be JSON object = A [OK]

Hint: Use JSON object for filter in deleteMany [OK]

Common Mistakes:

• Using string instead of object for filter
• Using comparison operators inside filter incorrectly
• Using array syntax for filter

3. Given the collection users with documents:

{"name": "Alice", "age": 25}, {"name": "Bob", "age": 30}, {"name": "Carol", "age": 25}

What will be the result of db.users.deleteMany({age: 25})?

medium

A. Deletes 2 documents where age is 25

B. Deletes 1 document where age is 25

C. Deletes all documents regardless of age

D. No documents deleted

Solution

1. Step 1: Identify matching documents

   Documents with age: 25 are Alice and Carol, so 2 documents match the filter.

2. Step 2: Understand deleteMany behavior

   deleteMany removes all documents matching the filter, so both Alice and Carol will be deleted.

3. Final Answer:

   Deletes 2 documents where age is 25 -> Option A

4. Quick Check:

   deleteMany removes all matching documents = A [OK]

Hint: deleteMany removes all matching, not just one [OK]

Common Mistakes:

• Thinking only one document is deleted
• Assuming deleteMany deletes all documents
• Confusing filter criteria

4. What is wrong with this code snippet?

db.products.deleteMany("{category: 'electronics'}")

medium

A. deleteMany cannot delete documents by category.

B. The collection name is incorrect.

C. Missing semicolon at the end.

D. Filter should be an object, not a string.

Solution

1. Step 1: Check filter argument type

   The filter argument must be a JSON object, but here it is passed as a string.

2. Step 2: Validate other parts

   deleteMany can delete by any filter, semicolon is optional in JS, and collection name is valid.

3. Final Answer:

   Filter should be an object, not a string. -> Option D

4. Quick Check:

   Filter must be object, not string = B [OK]

Hint: Pass filter as object, not string, in deleteMany [OK]

Common Mistakes:

• Passing filter as string instead of object
• Assuming semicolon is mandatory
• Misnaming collection

5. You want to delete all documents from the orders collection where the status is either "cancelled" or "returned". Which deleteMany filter correctly achieves this?

hard

A. db.orders.deleteMany({status: "cancelled" || "returned"})

B. db.orders.deleteMany({status: {$in: ["cancelled", "returned"]}})

C. db.orders.deleteMany({status: {$or: ["cancelled", "returned"]}})

D. db.orders.deleteMany({status: ["cancelled", "returned"]})

Solution

1. Step 1: Understand filter for multiple values

   To match documents where a field equals any value in a list, MongoDB uses the $in operator with an array of values.

2. Step 2: Evaluate each option

   db.orders.deleteMany({status: {$in: ["cancelled", "returned"]}}) correctly uses $in. db.orders.deleteMany({status: "cancelled" || "returned"}) uses JavaScript OR incorrectly inside an object. db.orders.deleteMany({status: {$or: ["cancelled", "returned"]}}) misuses $or inside a field. db.orders.deleteMany({status: ["cancelled", "returned"]}) uses an array directly, which is invalid.

3. Final Answer:

   db.orders.deleteMany({status: {$in: ["cancelled", "returned"]}}) -> Option B

4. Quick Check:

   Use $in for multiple values in filter = C [OK]

Hint: Use $in operator to match multiple values in deleteMany filter [OK]

Common Mistakes:

• Using JavaScript OR inside filter object
• Misusing $or inside a field filter
• Passing array directly as field value