python - 如何在 Flask 框架中允许为空

Question

我创建了一个具有以下属性的表：

def complaint():
    if request.method == "GET":
        return render_template("complaint.html")
    if request.method == "POST":
        data = request.form
        data = {
            "name": data.get('name'),
            "number": data.get('number'),
            "address": data.get('address'),
            "content": data.get('content'),
        }
        c = Contact(username=data['name'], number=data['number'], address=data['address'], issues=data['content'])
        db.session.add(c)
        db.session.commit()
        return render_template("complaint.html", error="Success")

但是html显示错误

sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1048, "Column 'address' cannot be null")

我怎样才能实现它？

标签： pythonflaskflask-sqlalchemy

Answer 1

您可以nullable=True在模型中定义地址列时进行设置。