flask_mysqldb删除FROM变量表 [英] flask_mysqldb Delete FROM variable table
本文介绍了flask_mysqldb删除FROM变量表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
所以我在Flask(Python网站)中使用flask_mysqldb
So i use flask_mysqldb in a Flask(Python website)
我正在尝试编写一个函数来删除任何表中的行. 当我对表名进行硬编码时,它可以完美地工作,但是我需要做些什么才能能够使用变量呢?
I'm trying to write a function to delete a row in any table. It works perfectly when I hardcode the tablename, but what do I need to do to be able to use a variable instead?
@app.route('/delete/<string:table>/<string:id>', methods=['POST'])
@is_logged_in
def delete(table, id):
# Create Cursor
cur = mysql.connection.cursor()
# Execute
cur.execute("DELETE FROM %s WHERE id = %s", (table, id))
mysql.connection.commit()
cur.close()
flash('%s deleted'(table), 'success')
return redirect(url_for('dashboard'))
推荐答案
cur.execute("DELETE FROM %s WHERE id = %s", (table, id))
应该是
cur.execute("DELETE FROM %s WHERE id = %s" % (table, id))
这篇关于flask_mysqldb删除FROM变量表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文