python - flask/sqlalchemy - OperationalError : (sqlite3. OperationalError) 没有这样的表

Question

我收到以下错误:

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: s_amodel [SQL: 'INSERT INTO s_amodel

我的文件表单.py

from flask_wtf import Form
class SAForm(Form):

---

模型.py

from app.app_and_db import db 

class SAmodel(db.Model):
    id = db.Column(db.Integer(), primary_key=True)

View .py

from app.app_and_db import app, db
from app.sa.forms import SAForm
from app.sa.models import SAmodel

@sa_blueprint.route('/sa/new', methods=['GET','POST'])
def new_sa():

        form = SAForm(request.form, SAmodel)

        if request.method=='POST' and form.validate():
            model = SAmodel()
            form.populate_obj(model)
            db.session.add(model)
            db.session.commit()
            return redirect(url_for("sa.home_page"))
        return render_template("new_sa.html", form=form)

配置.py

SQLALCHEMY_DATABASE_URI = os.getenv('DATABASE_URL', 'sqlite:///app.sqlite')

这是我的。 app.sqlite 已创建，但它是 0 字节。当我使用 new_sa() 函数提交内容时，出现上述错误。还有它是如何获得表名“s_amodel”的？

如有任何帮助，我们将不胜感激。非常感谢!

Answer 1

您应该首先初始化/创建表格。请阅读Creating the Database article in the official Flask documentation :

Such systems need a schema that tells them how to store that information. So before starting the server for the first time it’s important to create that schema.

下面是 Flask 使用模式 SQL 脚本创建数据库、表等的示例:

sqlite3 /tmp/flaskr.db < schema.sql

推荐的方法是在您的应用中使用 db.create_all()。例如，参见:https://github.com/lily-mayfield/staticfuzz/blob/d2e54186f5639a06a5a796f0499a984ca8919ed7/staticfuzz.py#L403