Flask 学习-连接mysql数据库

SQLALCHEMY_DATABASE_URI ='mysql+pymysql://root:xxx@localhost:3306/test?charset=utf8'
# SQLALCHEMY_ON_TEARDOWN在flask-sqlalchemy 2.0之后已经被删除了，需要用SQLALCHEMY_TRACK_MODIFICATIONS替代
SQLALCHEMY_TRACK_MODIFICATIONS =True# 设置这一项是每次请求结束后都会自动提交数据库中的变动

fromappimportdb

classUser(db.Model):
__tablename__ ='user'
id = db.Column(db.Integer,primary_key=True)
nick_name = db.Column(db.String(64),index=True,unique=True)
email = db.Column(db.String(120),index=True,unique=True)

def__repr__(self):
return'<User {}>'.format(self.nick_name)

fromflaskimportFlask
fromflask_sqlalchemyimportSQLAlchemy

app = Flask(__name__)
app.config.from_object('config')
db = SQLAlchemy(app)

fromappimportviews,models
if__name__ =='__main__':
app.run(debug=True)

fromappimportdb

db.create_all()