从0开始玩转MySQL

每个项目都离不开数据库，所以要是打算用Flask写一个程序，自然也离不开flask-sqlalchemy。作为一个MySQL DBA，当然会首选MySQL作为程序的数据库，毕竟我擅长于此。那么就来总结下，怎么用flask-sqlalchemy来玩转MySQL吧。安装命令pip install mysql-python pip install flask-sqlalchemy相关示例Python代码# 文件名hello.pyfrom flask import Flaskfrom flask_sqlalchemy import SQLAlchemyapp = Flask(__name__)app.config['SECRET_KEY'] = 'Fianna'app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://user:password@host:port/dbname'app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = Truedb = SQLAlchemy(app)class Role(db.Model):    __tablename__ = 'roles'    id = db.Column(db.Integer, nullable=False, primary_key=True, autoincrement=True)    name = db.Column(db.String(16), nullable=False, server_default='', unique=True)    def __re ………………………………