def new_bug(): available_projects=db.session.query(Project).all() projects_list=[(i.id, i.name) for i in available_projects] form = BugForm() form.pr_name.choices = projects_list if form.validate_on_submit(): bug = Bug(name=form.name.data, prid=form.pr_name.data, frmEmail=form.frmEmail.data, toEmail=form.toEmail.data, status=form.status.data, desc=form.desc.data, prio=form.prio.data) db.session.add(bug) db.session.commit() flash('A bug has been created!', 'success') return redirect(url_for('homepage')) return render_template('new_bug.html', title='New Bug', form=form, legend='New Bug')