使用Scrapy在管道内的MYSQL数据库中的2个表上添加项

import pymysql

class MySQLPipeline(object):
    def __init__(self, host, port, username, password, database):
        self.host = host
        self.port = port
        self.username = username
        self.password = password
        self.database = database

    @classmethod
    def from_crawler(cls, crawler):
        return cls(
            host=crawler.settings.get('MYSQL_HOST'),
            port=crawler.settings.get('MYSQL_PORT'),
            username=crawler.settings.get('MYSQL_USERNAME'),
            password=crawler.settings.get('MYSQL_PASSWORD'),
            database=crawler.settings.get('MYSQL_DATABASE')
        )

    def open_spider(self, spider):
        self.conn = pymysql.connect(
            host=self.host,
            port=self.port,
            user=self.username,
            password=self.password,
            db=self.database,
            charset='utf8mb4'
        )
        self.cursor = self.conn.cursor()

    def close_spider(self, spider):
        self.conn.close()

    def process_item(self, item, spider):
        # 将item中的数据插入到表1
        sql1 = "INSERT INTO table1 (field1, field2) VALUES (%s, %s)"
        self.cursor.execute(sql1, (item['field1'], item['field2']))
        self.conn.commit()

        # 将item中的数据插入到表2
        sql2 = "INSERT INTO table2 (field3, field4) VALUES (%s, %s)"
        self.cursor.execute(sql2, (item['field3'], item['field4']))
        self.conn.commit()

        return item