def all(self):
statement = f'SELECT * from {self.tablename}'
self.cursor.execute(statement)
result = []
for item in self.cursor.fetchall():
id, name, category = item
course = Course(name, category)
course.id = id
result.append(course)
return result
def add_course():
form = addCourse()
banji = Banji.query.all()
teacher = Teacher.query.all()
form.teacher.choices = [(th.id, th.name) for th in teacher]
form.banji.choices = [(bj.id, bj.name) for bj in banji]
if form.validate_on_submit():
new_course = Course()
new_course.id = form.id.data
new_course.name = form.name.data
new_course.place = form.place.data
new_course.start_time = form.start_time.data
new_course.end_time = form.end_time.data
new_course.teacher = Teacher.query.filter_by(
id=form.teacher.data).first()
new_course.banji = Banji.query.filter_by(id=form.banji.data).first()
db.session.add(new_course)
db.session.commit()
flash('添加成功', 'success')
return redirect(url_for('index_admin.manage_course'))
return render_template('admin/add_course.html', form=form)
