Python Flask: 实现删除笔记功能

代码

# 删除笔记
@app.route('/delete_article/<string:id>', methods=['POST'])
@is_logged_in
def delete_article(id):
    db = MysqlUtil() # 实例化数据库操作类
    sql = "DELETE FROM articles WHERE id = '%s' and author = '%s'" % (id,session['username']) # 执行删除笔记的SQL语句
    db.delete(sql) # 删除数据库
    flash('删除成功', 'success') # 闪存信息
    return redirect(url_for('dashboard')) # 跳转到控制台

效果图

600px