python全栈026-----Flask-SQLAlchemy插件

Flask-SQLAlchemy插件

# 映射数据库
app.config['SQLALCHEMY_DATABASE_URL'] = DB_URL
db = SQLAlchemy(app)

• 我们先安装我们要用的库

• 倒入库

from flask import Flask                                     
from flask_sqlalchemy import SQLAlchemy                     

• 初始代码

HOSTNAME = '127.0.0.1'                                                                     
DATABASE = 'demo'                                                                         
PORT = 3306                                                                                
USERNAME = 'root'                                                                          
PASSWORD = 'root'                                                                          
DB_URL = 'mysql+pymysql://{}:{}@{}:{}/{}'.format(USERNAME,PASSWORD,HOSTNAME,PORT,DATABASE)

app = Flask(__name__)

@app.route('/')
def index():
    return '这是首页'

if __name__ =='__main__':