从数据库导入复选框值

Question

我正在开发一个Python Flask Web应用程序，它应该可以作为政客们的wikipedia。当我创建一个新的政治家时，它被勾选为一个默认的草案，可以被更高级别的成员接受。因此，当我创建政客页面时，它被选中作为草稿，当管理员接受该草稿时，草稿值变为false。 我想知道如何根据属性draft的列值勾选/取消选中复选框，该属性是布尔值（True/False）。然后我想根据我的表单结果更改它。这是一个编辑功能，如您所见：

这是我的政客表格，我用来编辑的：

class PoliticForm(FlaskForm):
  publicName = StringField('Public Name', validators=[DataRequired("Please enter politician public name.")])
  completeName = StringField('Complete Name', validators=[DataRequired("Please enter politician complete name.")])
  startDate = DateField('Start Date', format='%m-%d-%Y', validators=[DataRequired("Please enter the politician start Date.")])
  endDate = DateField('End Date', format='%m-%d-%Y', validators=(validators.Optional(),))
  draft = RadioField('Draft', choices=[(True,'Yes'),(False,'No')], )
  submit = SubmitField('Add Politician', validators=(validators.Optional(),))

我想检查我的HTMLJinja2视图上的草稿行，它是：

^{pr2}$

我是否需要使用检查的参数？我如何勾选它是真的，如果是假则取消选中，然后将更改发送给我的控制器？在

政客/views.py/edit_政客

@politicians_blueprint.route("/edit_politician/<idPol>", methods=["POST", "GET"])
@login_required
def edit_politician(idPol=1):
  form = PoliticForm()
  politician = Politic.query.filter_by(idPolitician=idPol).first()
  if request.method == "POST":
    politician.publicName = request.form['publicName']
    politician.completeName = request.form['completeName']
    politician.draft = request.form['draft']
    if request.form.get('date') != 'None':
      politician.startDate = datetime.datetime.strptime(request.form.get('date'), '%m/%d/%Y').strftime('%Y-%m-%d')
      print politician.startDate
    if request.form.get('date2') != 'None':
      politician.endDate = datetime.datetime.strptime(request.form.get('date2'), '%m/%d/%Y').strftime('%Y-%m-%d')
      print politician.endDate
    db.session.commit()
    return redirect(url_for('home.home'))
  elif request.method == "GET":
    print politician.startDate
    if politician.startDate is not None:
      dateStart = politician.startDate.strftime("%Y-%m-%d")
      politician.startDate = datetime.datetime.strptime(dateStart, '%Y-%m-%d').strftime('%m/%d/%Y')
    if politician.endDate is not None:
      dateEnd = politician.endDate.strftime("%Y-%m-%d")
      politician.endDate = datetime.datetime.strptime(dateEnd, '%Y-%m-%d').strftime('%m/%d/%Y')

    return render_template("editPolitician.html", politician=politician)

有什么想法吗？我真的很挣扎。。在

问候

Answer 1

你可以试试

<input type="checkbox" name="draft" class="form-control" id="email" {% if politician.draft %}checked="checked"{% endif %}>

或者通过jQuery修改复选框的状态（如果您使用它）

^{pr2}$