Trying to do a simple todo app with flask and sqlalchemy and since I have never worked with checkboxes in flask before, i have the following problem.
App is
class Todo(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.String(200)) complete = db.Column(db.Boolean) @app.route('/update', methods=['POST']) def update(): print(request.form) return redirect(url_for('index')) HTML IS:
<ul> {% for todo in incomplete %} <li><input id="checkbx" name="{{ todo.id }}" type="checkbox"> {{ todo.text }} </li> {% endfor %} </ul> when I,
print(request.form) after selecting the checkbox to complete the todo task and clicking the update button, console prints out:
ImmutableMultiDict([('11', u'on')]) how can i update the DB to change the complete value from '0' to '1'?
print(request.form['checkbx']) gives a 400 Bad Request
request.form.get('checkbx') returns None
todo = request.form.getlist('checkbx') returns []
I'm guessing i need to do something like:
todo = Todo.query.filter_by(int(id)).first() so then I can
todo.complete = True db.session.commit() how can i get the id from that ImmutableMultiDict (in this case it's '11') ???
