How to delete items from database using a Flask framework?

Question

I'm working with a Flask framework, and am trying to delete an entry from the database. The code below gives this error: "The method is not allowed for the requested URL."

In the html:

<form action="{{ url_for('delete_entry', id=entry.id) }}" method="POST">
     <input type="hidden" name="_method" value="DELETE" />
     <input type="submit" value="Delete entry" />
</form>

In the py:

@app.route('/delete', methods=['DELETE'])
def delete_entry(postID):
    if not session.get('logged_in'):
        abort(401)
    g.db.execute('delete from entries WHERE id = ?', [postID])
    flash('Entry was deleted')
    return redirect(url_for('show_entries'))

How do I then get the correct postID from the html to the py?

The method referenced in your route decorator should be POST and not DELETE. — b10n
– b10n, Commented Sep 19, 2014 at 1:40
@b10n thanks, and what about getting the postID to the function? How do I do that? — Hayley van Waas
– Hayley van Waas, Commented Sep 19, 2014 at 1:58
Several good responses here: http://stackoverflow.com/questions/25947251/deleting-rows-from-database-with-python-flask/ — fundatillus
– fundatillus, Commented May 15, 2016 at 18:52

Wilberto · Accepted Answer · 2014-09-19 11:18:35Z

4

If you are going to use a POST request the variable will be available under flask's request.form. If you stay with DELETE I think you need to change your uri. For example:

@app.route('/delete/<int:postID>', methods=['DELETE'])

answered Sep 19, 2014 at 11:18

Wilberto

5401 gold badge4 silver badges10 bronze badges

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

Comments

Kane Lin · Accepted Answer · 2018-04-07 12:45:13Z

2

To get the postID use this {{ loop.revindex }}

This is my code,it works!!

In the .py:

@app.route('/delete', methods=['POST'])
def delete_entry():
    if not session.get('logged_in'):
        abort(401)
    db = get_db()
    db.execute('delete from entries where id = ?'[request.form['entry_id']])
    db.commit()
    flash('Entry deleted')
    return redirect(url_for('show_entries'))

In the HTML:

<form action="{{ url_for('delete_entry') }}" method=post class=delete-entry>
          <input type="hidden" name="entry_id" value="{{ loop.revindex }}">
          <input type="submit" value="Delete" />
</form>

edited Apr 7, 2018 at 12:45

answered Apr 7, 2018 at 11:53

Kane Lin

411 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to delete items from database using a Flask framework?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related