环境准备
先安装连接 mysql 驱动包 pymysql
pip install pymysql
安装Flask-SQLAlchemy 应用插件
pip install flask-sqlalchemy
代码示例
from flask import Flask, url_for, request, redirect, render_template
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy.sql import text
app = Flask(__name__)
# 设置数据库连接地址
DB_URI = 'mysql+pymysql://root:613724@127.0.0.1:3306/web'
app.config['SQLALCHEMY_DATABASE_URI'] = DB_URI
# 是否追踪数据库修改,一般不开启, 会影响性能
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
# 是否显示底层执行的SQL语句
app.config['SQLALCHEMY_ECHO'] = True
# 初始化db,关联flask 项目
db = SQLAlchemy(app)
with app.test_request_context():
# 执行原生SQL语句, 测试下能不能查询到结果
result = db.session.execute(text('select * from Student'))
print(result.fetchall())
if __name__ == '__main__':
app.run()
查询结果
[(1, '王珊', 18, '男'), (2, '王二', 17, '女'), (3, '李珊', 19, '女'), (4, '张三', 18, '男')]