flask访问mysql

requirements.txt

marshmallow>=3
flask
flask-restful
flask-migrate
flask-sqlalchemy
flask-marshmallow
flask-jwt-extended
marshmallow-sqlalchemy
python-dotenv
passlib
apispec[yaml]
apispec-webframeworks
wtforms
Flask-WTF
tox
#uwsgi
flask-mysqldb
pymysql
#bottle
#requests
#xmltodict

运行：

pip3 install --no-cache-dir -r requirements.txt

生成数据对象：

pip3 install flask-sqlacodegen
flask-sqlacodegen --tables edu_user --outfile edu_user.py mysql+pymysql://root:i8Yz#tUnK5@47.99.193.235:3506/education?charset=utf8 --flask