scrapy 连接mysql

# 示例代码：自定义 Scrapy 中间件连接 MySQL

import mysql.connector
from scrapy.exceptions import DropItem

class MySQLPipeline(object):
    def __init__(self, db_host, db_user, db_password, db_name):
        self.db_host = db_host
        self.db_user = db_user
        self.db_password = db_password
        self.db_name = db_name

    @classmethod
    def from_crawler(cls, crawler):
        return cls(
            db_host=crawler.settings.get('MYSQL_HOST'),
            db_user=crawler.settings.get('MYSQL_USER'),
            db_password=crawler.settings.get('MYSQL_PASSWORD'),
            db_name=crawler.settings.get('MYSQL_DB')
        )

    def open_spider(self, spider):
        self.connection = mysql.connector.connect(
            host=self.db_host,
            user=self.db_user,
            password=self.db_password,
            database=self.db_name
        )
        self.cursor = self.connection.cursor()

    def close_spider(self, spider):
        self.cursor.close()
        self.connection.close()

    def process_item(self, item, spider):
        query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
        self.cursor.execute(query, (item['value1'], item['value2']))
        self.connection.commit()
        return item