输入值时返回“无”的PythonFlask窗体

Question

这是我的第一个python应用程序，我将学习本教程https://scotch.io/tutorials/build-a-crud-web-app-with-python-and-flask-part-one

我似乎对我在表格中输入的信息有问题，网页上显示，除“课程”和“讲师”外，所有字段都可以正常工作。 我已尝试更改表/模型，但未成功。 这是我的views.py页面的一部分

@admin.route('/tasterdays/add', methods=['GET', 'POST'])
@login_required
def add_tasterdays():
"""
Add a Tasterday to the database
"""
check_admin()

add_tasterdays = True

form = TasterDayForm()
if form.validate_on_submit():
    tasterdays = TasterDay(name=form.name.data,
                            description=form.description.data,
                           date=form.date.data,
                           course=form.course.data,
                           lecturer=form.lecturer.data)

 try:
        # add tasterday to the database
        db.session.add(tasterdays)
        db.session.commit()
        flash('You have successfully added a new Taster Day.')
 except:
        # in case tasterday  already exists
        flash('Error: Taster Day already exists.')

 # redirect to tasterdays page
    return redirect(url_for('admin.list_tasterdays'))

   # load tasterdays template
   return render_template('admin/tasterdays/tasterday.html', action="Add",
                       add_tasterdays=add_tasterdays, form=form,
                       title="Add Taster Day")

当我从if form.validate_on_submit():中删除course=form.course.data, lecturer=form.lecturer.data时，表单会提交，但是表会用“无”填充这些部分。当我保存这些时，表格上说这个品尝日已经存在了，尽管它并不存在。 以下是我的3/4表格/模型：

class Course(db.Model):
"""
Create a courses table
"""

__tablename__ = 'courses'

id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(60), unique=True)
description = db.Column(db.String(200))
students = db.relationship('Student', backref='Course',
                            lazy='dynamic')

def __repr__(self):
    return '<Course: {}>'.format(self.name)

class TasterDay(db.Model):
"""
Create a tasterdays table
"""

__tablename__ = 'tasterdays'

id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(60), unique=True)
description = db.Column(db.String(200))
date = db.Column(db.Date, index=True)
course = db.Column(db.String(60), index=True)
lecturer = db.Column(db.String(60), index=True)
students = db.relationship('Student', backref='tasterdays',
                            lazy='dynamic')

def __repr__(self):
    return '<tasterdays: {}>'.format(self.name)

class Lecturer(db.Model):
"""
Create a lecturer table
"""

__tablename__ = 'lecturers'

id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(60), unique=True)
course_id = db.Column(db.Integer, db.ForeignKey('courses.id'))
taster_day_id = db.Column(db.Integer, db.ForeignKey('tasterdays.id'))

def __repr__(self):
    return '<Lecturer: {}>'.format(self.name)

这是正在填写的表格：

class TasterDayForm(FlaskForm):
"""
Form for admin to add or edit a taster day
"""
name = StringField('Name', validators=[DataRequired()])
date = DateField('Date (DD-MM-YYYY)', format='%d-%m-%Y')
course = StringField('Course', validators=[DataRequired()])
lecturer = StringField('Lecturer', validators=[DataRequired()])
description = StringField('Description', validators=[DataRequired()])
submit = SubmitField('Submit')

以下是表单的html：

            <div class="center">
        <table class="table table-striped table-bordered">
          <thead>
            <tr>
              <th width="15%"> Name </th>
              <th width="40%"> Description </th>
                <th width="40%"> Date </th>
                <th width="40%"> Course </th>
                <th width="40%"> Lecturer </th>
              <th width="15%"> Student Count </th>
              <th width="15%"> Edit </th>
              <th width="15%"> Delete </th>
            </tr>
          </thead>
          <tbody>
          {% for tasterdays in tasterdays %}
            <tr>

                 <td> {{ tasterdays.name }} </td>
                 <td> {{ tasterdays.description }} </td>
                 <td> {{ tasterdays.date }} </td>
                 <td> {{ tasterdays.course }} </td>
                 <td> {{ tasterdays.lecturer }} </td>
              <td>
               {% if tasterdays.students %}
                  {{ tasterdays.students.count() }}
                {% else %}
                  0
                {% endif %}
              </td>
              <td>
                <a href="{{ url_for('admin.edit_tasterdays', id=tasterdays.id) }}">
                  <i class="fa fa-pencil"></i> Edit
                </a>
              </td>
              <td>
                <a href="{{ url_for('admin.delete_tasterdays', id=tasterdays.id) }}">
                  <i class="fa fa-trash"></i> Delete
                </a>
              </td>
            </tr>
          {% endfor %}
          </tbody>
        </table>
      </div>

我希望能够填充讲师和课程字段，并在按下submit键后将其显示出来

如果需要更多信息，请告诉我

Answer 1

我自己设法解决了这个问题

从tasterdays表中的课程和讲师中删除“index=True”，并成功填充字段