/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

0 vote315 views2 answers
Run all jupyter notebooks in project folder
Python
3 votes302 views1 answer
Py change background
Python
0 vote271 views6 answers
Schedule a function python inside tkinter loop
Python
10 votes337 views4 answers
File path current directory python
Python
17 votes391 views3 answers
ModuleNotFoundError: No module named 'rest_api_framework'
Python
2 votes326 views3 answers
Pandas count occurrences of certain value in row
Python
30 votes284 views6 answers
Try and except in python
Python
0 vote377 views1 answer
What does eval function do in python stack overflow
Python
6 votes308 views2 answers
How to add mouse button in pygame
Python
0 vote322 views1 answer
Import sys locate python = sys.exec_prefix print(locate python)
Python