我的代码是：

@app.route('/projects/create', methods=["POST", "GET"])
def add():
    if request.method == "POST":
        id = request.form["id"]
        name = request.form["name"]
        text = request.form["s_text"]

        try:
            projects.db.executemany("INSERT INTO projects  (?,?,?)", [id], [name], [text])
            projects.db.commit()
            return redirect("/projects")
        except:
            return "Error 404"
    else:
        return render_template("create.html")

我正在尝试插入到数据库中，但没有奏效。