Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

275
Views
How to drop a collection with pymongo?

I use scarpy to crawl data and save it to cloud hosting mLab successfully with MongoDB.

My collection name is recently and data's count is 5. enter image description here

I want to crawl data again and update my collection recently, so i try to drop the collection and then insert.

Here is my code pipelines.py:

from pymongo import MongoClient
from scrapy.conf import settings

class MongoDBPipeline(object):

    def __init__(self):
        connection = MongoClient(
            settings['MONGODB_SERVER'],
            settings['MONGODB_PORT'])
        db = connection[settings['MONGODB_DB']]
        # here is my collection name recently setting
        self.collection = db[settings['MONGODB_COLLECTION']]

    def process_item(self, item, spider):
        # try to drop my collection recently
        self.collection.drop()
        self.collection.insert(dict(item))
        return item

But when I run my spider, I see my collection recently count is 10 (It should be 5 that is what I want) enter image description here

I looking for some code that how to drop collection. It's just say db.[collection Name].drop()

But its no working in my case when i try self.collection.drop() before self.collection.insert(dict(item))

Anyone can give me some suggestions what is wrong with my code ?

That would be appreciated. Thanks in advance.

over 4 years ago · Santiago Trujillo
1 answers
Answer question

0

You need to use drop. Suppose foo is a collection

db.foo.drop()

Or you can use drop_collection

db.drop_collection(collection_name)
over 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!