读崔庆才之小白进阶之Scrapy第一篇遇到的问题

你的名字 2022-05-10 03:50 117阅读 0赞

第一个问题：No module named 'win32api'错误

解决方法：直接在命令行：pip install pypiwin32。

第二个问题：No module named 'mysql'错误

解决方法：

因为在python3里mysql-python不再兼容，我们这里改用pymysql。

so我们pip install pymysql

之前在博主的事情sql.py的代码为：

import mysql.connector
    from dingdian import settings
    
    MYSQL_HOSTS = settings.MYSQL_HOSTS
    MYSQL_USER = settings.MYSQL_USER
    MYSQL_PASSWORD = settings.MYSQL_PASSWORD
    MYSQL_PORT = settings.MYSQL_PORT
    MYSQL_DB = settings.MYSQL_DB
    
    cnx = mysql.connector.connect(user=MYSQL_USER, password=MYSQL_PASSWORD, host=MYSQL_HOSTS, database=MYSQL_DB)
    cur = cnx.cursor(buffered=True)

下面为改正后的的代码

import pymysql                     #这里修改了
    from dingdian import settings
    
    MYSQL_HOSTS = settings.MYSQL_HOSTS
    MYSQL_USER = settings.MYSQL_USER
    MYSQL_PASSWORD = settings.MYSQL_PASSWORD
    MYSQL_PORT = settings.MYSQL_PORT
    MYSQL_DB = settings.MYSQL_DB
    
    cnx = pymysql.connect(user=MYSQL_USER, password=MYSQL_PASSWORD, host=MYSQL_HOSTS, database=MYSQL_DB)
    cur = cnx.cursor()                      #这里修改了

修改后的源码下载：[https://github.com/aaaazhi/dingdian][https_github.com_aaaazhi_dingdian]

小白进阶scrapy第一篇链接：[https://cuiqingcai.com/3472.html/1][https_cuiqingcai.com_3472.html_1]

pymysql数据库的连接用法：[http://www.runoob.com/python3/python3-mysql.html][http_www.runoob.com_python3_python3-mysql.html]

[https_github.com_aaaazhi_dingdian]: https://github.com/aaaazhi/dingdian
[https_cuiqingcai.com_3472.html_1]: https://cuiqingcai.com/3472.html/1
[http_www.runoob.com_python3_python3-mysql.html]: http://www.runoob.com/python3/python3-mysql.html