如何用flask在数据库添加数据

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

db.init_app(app)

params = dict(email=data["email"], rid=data["rid"])

role = models.A(**params)

db.session.add(role)

db.session.commit()
复制代码

A 是models文件中的类

class A(db.Model):
    """
    A表的各个字段
    """
    __tablename__ = 'A'
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(255), unique=True, index=True)
    rid = db.Column(db.Integer, unique=True, index=True)
    pbi_rid = db.Column(db.Integer)
    dinfo = db.Column(db.TEXT)
    option = db.Column(db.String(255))
    time = db.Column(db.DateTime())

复制代码