Flask应用程序:无法为终结点“post\u to \u db”生成url

2024-06-13 20:23:48 发布

您现在位置:Python中文网/ 问答频道 /正文

我是一个新的烧瓶应用程序,所以我可能会错过一些明显的。我要做的是从一个滑块中获取一个值,然后将postgresql表中的一个值按滑块值递增,然后将postgresql表中的另一个值按1递增。我得到错误:

werkzeug.routing.BuildError: Could not build url for endpoint 'post_to_db'. Did you mean 'static' instead?

这是我的html:

<form method="POST" action="{{ url_for('post_to_db') }}">
    <input class='slider'id="mydata" name="mydata" type="range" min="0" max="10" value="5" step='1'>
    <div id='button-dock'>
        <button type='submit'>"Show Me Another"</button>
    </div>
</form>

这是我的Python:

class Dataentry(db.Model):
    __tablename__ = "shoe-ratings"

    id = db.Column(db.Integer, primary_key=True)
    total_score = db.Column(db.Integer)
    num_ratings = db.Column(db.Integer)

    def __init__(self, total_score, num_ratings):
        self.total_score = total_score
        self.num_ratings = num_ratings

    def __repr__(self):
        return '<id {}>'.format(self.id)

    def serialize(self):
        return {
            'id': self.id,
            'total_score': self.total_score,
            'num_ratings': self.num_ratings
        }

@app.route("/virgil_io/submit/", methods=["POST"])
def post_to_db():

    score = request.form['mydata']

    shoe = Dataentry.query.first()
    shoe.total_score = shoe.c.total_score + score
    shoe.num_ratings = shoe.c.num_ratings + 1

    try:
        db.session.add(shoe)
        db.session.commit()
    except Exception as e:
        print("\n FAILED entry\n")
        print(e)
        sys.stdout.flush()
    return "Success"

@APP.route('/virgil_io/')
def index():
    return flask.render_template('index.html')

这是我的目录:

enter image description here

我尝试过的事情:

  • 在我的目录中创建/提交文件夹
  • 取出methods=["POST"]

有什么想法吗?谢谢


Tags: toselfformiddbreturndefpost