我试图删除带有Flask的文章，但出现KeyError

Question

嗨，我正在用Flask编写评论页面，但正在努力创建删除按钮。根据我的代码，当单击delete按钮时，会出现KeyError。审阅表中只有两行是Writer和Content。我粘贴了显示和删除ReviewAPI代码，还带有服务器端删除功能。

我的方法可以通过从客户端发送标题和评论到服务器来删除代码，然后删除数据库中与客户端发送的标题和评论相匹配的对象吗？我想知道为什么出现键盘错误。我乞求你的帮助！感谢阅读。

  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/flask/app.py", line 2088, in __call__
    return self.wsgi_app(environ, start_response)
  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/flask/app.py", line 2073, in wsgi_app
    response = self.handle_exception(e)
  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
    response = self.full_dispatch_request()
  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
    rv = self.dispatch_request()
  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
  File "/Users/min05099/sparta/projects/detailPage/app.py", line 19, in write_review
    review_receive = request.form['review_give']
  File "/Users/min05099/sparta/projects/detailPage/venv/lib/python3.8/site-packages/werkzeug/datastructures.py", line 377, in __getitem__
    raise exceptions.BadRequestKeyError(key)
werkzeug.exceptions.BadRequestKeyError: 400 Bad Request: The browser (or proxy) sent a request that this server could not understand.
KeyError: 'review_give' ```



```function showReview() {
                $.ajax({
                    type: "GET",
                    url: "/review",
                    data: {},
                    success: function (response) {
                        let reviews = response['all_reviews']
                        for (let i = 0; i < reviews.length; i++) {
                            let title = reviews[i]['title']
                            let review = reviews[i]['review']

                            let temp_html = `<tr>
                                               <td>${title}</td>
                                               <td>${review}</td>
                                               <td><button onclick="deleteReview('${title, review}')">delete</button></td>
                                           </tr>`
                            $('#reviews-box').append(temp_html)
                        }
                    }
                    }
                )
            }


            function deleteReview(title, review) {
                            $.ajax({
                                type: 'POST',
                                url: '/review',
                                data: {title_give:title, review_give:review},
                                success: function (response) {
                                    alert(response['msg']);
                                    window.location.reload()
                                }
                            });
                        } ```

```@app.route('/review', methods=['POST'])
def delete_review():
    title_receive  = request.form['title_give']
    review_receive = request.form['review_give']
    db.miniProject.delete_one({'title': title_receive, 'review': review_receive})
    return jsonify({'msg': 'Successfully Delete!'})```

Answer 1

问题源于生成按钮时的字符串插值。

${title，review}仅注入review的值。由于您的deleteReview只接收一个参数，因此ajax调用数据中的review\u give字段留空，导致flask应用程序中相应的键丢失。

这是如何正确地进行字符串插值：

let temp_html = `<tr>
        <td>${title}</td>
        <td>${review}</td>
        <td><button onclick="deleteReview('${title}, ${review}')">delete</button></td>
    </tr>`

此外，与其按标题和评论正文删除评论，不如在服务器端为每个评论分配一个ID。然后，您可以基于此ID删除评论。