flask_mysqldb Delete FROM variable table [duplicate]

Question

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'))

Your code snippet seems to use a variable for the table name. Are you getting an error when executing the delete function? — F Rowe
– F Rowe, Commented Dec 29, 2017 at 15:41

rubayeet · Accepted Answer · 2017-12-29 15:33:04Z

0

cur.execute("DELETE FROM %s WHERE id = %s", (table, id))

should be

cur.execute("DELETE FROM %s WHERE id = %s" % (table, id))

answered Dec 29, 2017 at 15:33

rubayeet

9,4009 gold badges48 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

flask_mysqldb Delete FROM variable table [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related