1.0 Flask-SQLAlchemy插件
Flask-SQLAlchemy是对SQLAlchemy进行了一个简单封装,使得在falsk中使用sqlalchemy更加简单,可以通过下面的命令安装:
pip install flask-sqlalchemy
1.1 数据库初始化:数据库初始化不再是通过create_engine
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
USERNAME = 'root'
PASSWORD = 'root'
HOSTNAME = '127.0.0.1'
PORT = '3306'
DATABASE = 'tables'
DB_URL = 'mysql+pymysql://{}:{}@{}:{}/{}'.format(USERNAME, PASSWORD, HOSTNAME, PORT