flask-sqlalchemy mysql_Flask用Flask-SQLAlchemy连接MySQL

pip3 install Flask-SQLAlchemy

测试环境目录结构

配置

settings.py

DIALECT = 'mysql'

DRIVER = 'pymysql'

USERNAME = 'root'

PASSWORD = '808069'

HOST = '127.0.0.1'

PORT = '3306'

DATABASE = 'cms'

SQLALCHEMY_DATABASE_URI = '{}+{}://{}:{}@{}:{}/{}?charset=utf8'.format(

DIALECT,DRIVER,USERNAME,PASSWORD,HOST,PORT,DATABASE

)

SQLALCHEMY_COMMIT_ON_TEARDOWN = True

SQLALCHEMY_TRACK_MODIFICATIONS = True

连接

manage.py

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy(app)

建表

models.py

from manage import db</