flask 数据库操作python3.8

from random import choice
from flask import Flask, request, jsonify
from flask import render_template
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql

app = Flask(__name__)
# 相关配置
app.config['SQLALCHEMY_DATAbase_URI'] = 'mysql://xxxxx:3306/stock_and_bond'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_ECHO'] = True

# 创建组件对象
pymysql.install_as_MySQLdb()
db = SQLAlchemy(app)

class BondData(db.Model):
    __tablename__ = "bond_table"
    id = db.Column(db.Integer, primary_key=True)
    bond_code = db.Column(db.String(100))


@app.route("/")
def login():
    bonddata = BondData(bond_code="000002")
    db.session.add(bonddata)
    db.session.commit()
    return render_template("table.html")
if __name__ == '__main__':
    app.run(debug=True)

flask_sqlalchemy依赖于pymysql所以需要单独安装，具体如下：
 

pip install flask-sqlalchemy
pip install pymysql

这样就可以正常使用了不会报错