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)