/Python/How to send data to scrapy pipeline to mongodb

How to send data to scrapy pipeline to mongodb

# In your pipeline

class EPGD_pipeline(object):
    def __init__(self):
        self.collections = {
            spider_name: self.setup_db_connection(dj_mongo_database_url.parse(url))
            for spider_name, url in settings['MONGODB_PIPELINE_SETTINGS'].iterItems()
        )
    }

    def process_item(self, item, spider):
        collection = self.collections[spider.name]
        ...


# In settings.py

MONGODB_PIPELINE_SETTINGS = {
    "GenDis": "mongodb://myhost:29297/test_db/collection",
    "EPGD": "mongodb://myhost:29297/test_db/collection2",
}

Source: stackoverflow.com

How to send data to scrapy pipeline to mongodb

    BOT_NAME = 'capstone'

    SPIDER_MODULES = ['capstone.spiders']
    NEWSPIDER_MODULE = 'capstone.spiders'

    ITEM_PIPLINES = {'capstone.pipelines.MongoDBPipeline': 300,}
    MONGO_URI = 'mongodb://localhost:27017'
    MONGO_DATABASE = 'congress'
    ROBOTSTXT_OBEY = True
    DOWNLOAD_DELAY = 10

Source: stackoverflow.com

How to send data to scrapy pipeline to mongodb

    from pymongo import MongoClient
    from scrapy.conf import settings
    from scrapy.exceptions import DropItem
    from scrapy import log

    class MongoDBPipeline(object):
        collection_name= 'members'
        def __init__(self, mongo_uri, mongo_db):
            self.mongo_uri = mongo_uri
            self.mongo_db = mongo_db
        @classmethod
        def from_crawler(cls, crawler):
            return cls(
                mongo_uri=crawler.settings.get('MONGO_URI')
                mongo_db=crawler.settings.get('MONGO_DATABASE', 'items')
            )
        def open_spider(self,spider):
            self.client = pymongo.MongoClient(self.mongo_uri)
            self.db = self.client[self.mongo_db]
        def close_spider(self, spider):
            self.client.close()
        def process_item(self, item, spider):
            self.db[self.collection_name].insert(dict(item))
            return item

Source: stackoverflow.com

Similar codes

1 vote240 views1 answer
Concatenate dataframes pandas without duplicates
Python
10 votes256 views1 answer
Panda select rows where column value inferior to
Python
11 votes263 views3 answers
Create virtualenv python3 mac
Python
22 votes254 views6 answers
Python palindrome program
Python
117 votes289 views6 answers
Python how to get user input
Python
1 vote238 views1 answer
Python subtract lists
Python
0 vote264 views1 answer
Opencv set window size
Python
20 votes303 views3 answers
Accommodation
Python
0 vote283 views1 answer
Matplotlib bar chart from dictionary
Python
0 vote278 views1 answer
Python how to turn a word into a list
Python