在执行python models.py 中报错

Question

Traceback (most recent call last):

  File "models.py", line 183, in <module>

    db.create_all()

  File "C:\Users\Administrator\movie_venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 1007, in create_all

    self._execute_for_all_tables(app, bind, 'create_all')

  File "C:\Users\Administrator\movie_venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 999, in _execute_for_all_tables

    op(bind=self.get_engine(app, bind), **extra)

  File "C:\Users\Administrator\movie_venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 941, in get_engine

    return connector.get_engine()

  File "C:\Users\Administrator\movie_venv\lib\site-packages\flask_sqlalchemy\__init__.py", line 543, in get_engine

    self._engine = rv = sqlalchemy.create_engine(info, **options)

  File "C:\Users\Administrator\movie_venv\lib\site-packages\sqlalchemy\engine\__init__.py", line 387, in create_engine

    return strategy.create(*args, **kwargs)

  File "C:\Users\Administrator\movie_venv\lib\site-packages\sqlalchemy\engine\strategies.py", line 80, in create

    dbapi = dialect_cls.dbapi(**dbapi_args)

  File "C:\Users\Administrator\movie_venv\lib\site-packages\sqlalchemy\dialects\mysql\mysqldb.py", line 110, in dbapi

    return __import__('MySQLdb')

ModuleNotFoundError: No module named 'MySQLdb'

老师如果需要更多代码,请提示我需要给出哪段代码,感谢!

Answer 1

rustgopy 2017-08-19 08:02:35

同学你好，默认的mysqldb不存在，使用pymysql模块，在头部这样引入：

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql


app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "mysql+pymysql://root:root@127.0.0.1:8889/movie"
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = True
db = SQLAlchemy(app)

• 提问者 JoannaMua #1

  非常感谢！

• 提问者 JoannaMua #2

  老师你好,这个pymysql也需要安装的对吧....为何您的课程里,您不需要安装即可运行呢?

• 提问者 JoannaMua #3

  老师你好, 我按照您的说法使用pymysql模块, "import pymysql" 在pycharm编辑里面是灰色的, 我安装了pymysql的包,"import pymysql"仍然是灰色的

点开查看后面1条评论