Scrapy第八篇：数据存储（scrapy融合peewee）

约定不等于承诺〃 2024-04-08 08:41 80阅读 0赞

**目录**

1.安装依赖

2.构建模型：编辑items.py

3.传入数据：编辑Spider.py

4.保存数据：修改pipelines.py

5.开启管道：修改settings.py

6.Sql日志

--------------------

#### 1.安装依赖 ####

pip install peewee -i https://pypi.tuna.tsinghua.edu.cn/simple
    pip install pymysql -i https://pypi.tuna.tsinghua.edu.cn/simple

#### 2.构建模型：编辑items.py ####

# Define here the models for your scraped items
    #
    # See documentation in:
    # https://docs.scrapy.org/en/latest/topics/items.html
    import dataclasses
    from dataclasses import dataclass
    
    from peewee import MySQLDatabase, TextField, Model
    
    db_mysql = MySQLDatabase('fast_generator', user='root', password='123456', host='localhost', port=3306)
    
    
    @dataclass
    class NoticeItem(Model):
        def __init__(self, *args, **kwargs):
            super().__init__(*args, **kwargs)
    
        # 标题
        title = TextField()
        # 内容
        content = TextField()
    
        class Meta:
            database = db_mysql
            # 如果类名和表名驼峰相同，则此行可略；
            table_name = "notice"

#### 3.传入数据：编辑Spider.py ####

import scrapy
    from scrapy.http import HtmlResponse
    
    from testproject.items import NoticeItem
    
    
    class TestspiderSpider(scrapy.Spider):
        name = 'testspider'
        allowed_domains = ['ssr1.scrape.center']
        start_urls = ['https://ssr1.scrape.center/']
    
        def start_requests(self):
            for url in self.start_urls:
                yield scrapy.Request(url, callback=self.parse)
    
        def parse(self, response: HtmlResponse, **kwargs):
            yield NoticeItem(title='测试标题', content='测试内容')

#### 4.保存数据：修改pipelines.py ####

from testproject.items import NoticeItem
    
    
    class TestprojectPipeline:
        def process_item(self, item, spider):
            if isinstance(item, NoticeItem):
                item.save()
                return item

#### 5.开启管道：修改settings.py ####

ITEM_PIPELINES = {
       'testproject.pipelines.TestprojectPipeline': 300,
    }

#### 6.Sql日志 ####

![a443bd91a50a40dd8977cf7acbfcfde0.png][]

[a443bd91a50a40dd8977cf7acbfcfde0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/c9653662e3b840159bf714a337220b3c.png