/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 vote255 views1 answer
Pprint(ASingleReview) TypeError: 'module' object is not callable
Python
1 vote236 views1 answer
Decision tree classifier python code for visualization
Python
1 vote255 views1 answer
Import CSV Files into R Using read.csv() method
Python
0 vote223 views1 answer
Add up all the numbers in each row and output that number output the grand total of all rows
Python
0 vote222 views3 answers
Join list with comma python
Python
4 votes245 views2 answers
Python replace by dictionary
Python
0 vote238 views2 answers
Avoid bad request django
Python
0 vote251 views1 answer
Repalce na with mean per group
Python
0 vote236 views1 answer
Python [:-1]
Python
0 vote312 views1 answer
Find-squares-and-odd-numbers-in-the-given-list
Python