本人使用的python和pip版本都是3.6,以下例子基于此版本。
本人编写的manager.py文件
<span>#</span><span> coding:utf-8</span> <span>from</span> flask_script <span>import</span><span> Manager </span><span>from</span> flask_<a href="https://www.gaodaima.com/tag/migrate" title="查看更多关于migrate的文章" target="_blank">migrate</a> <span>import</span><span> Migrate, MigrateCommand </span><span>from</span> ihome <span>import</span><span> create_<a href="https://www.gaodaima.com/tag/app" title="查看更多关于app的文章" target="_blank">app</a>, db app </span>= create_app(<span>"</span><span>development</span><span>"</span><span>) manager </span>=<span> Manager(app) </span><span>#</span><span> 集成数据库的迁移</span> <span>Migrate(app, db) manager.add_command(</span><span>"</span><span>db</span><span>"</span><span>, MigrateCommand) </span><span>if</span> <span>__name__</span> == <span>"</span><span>__main__</span><span>"</span><span>: manager.run()</span>
www#gaodaima.com来源gao.dai.ma.com搞@代*码网搞代码
数据库迁移步骤如下:
1. python3.6 manager.py db init
2. python3.6 manager.py db migrate
步骤2遇到如下问题:
ModuleNotFoundError: No module named “MySQLdb”
解决方法:
pip3 install mysqlclient
安装mysqlclient过程中遇到如下问题:
问题1:
OSError: mysql_config not found
解决方法:
yum install mysql-devel
问题2:
fatal error: Python.h: No such file or directory
解决方法:
yum install python36-devel
3. python3.6 manager.py db upgrade
至此,数据库迁移完成。