def editcourse(course_id): if current_user.tof == 1: return redirect(url_for('index')) else: form = CourseForm() course = Course.query.filter_by(id=course_id).first() if form.validate_on_submit(): course.subject = form.subject.data course.number = form.number.data course.title = form.title.data course.gpareq = form.gpareq.data course.prevgrade = form.prevgrade.data course.numslots = form.numslots.data course.addinfo = form.addinfo.data db.session.commit() flash("You have updated your course!") return redirect(url_for('managecourses')) elif request.method == 'GET': form.subject.data = course.subject form.number.data = course.number form.title.data = course.title form.gpareq.data = course.gpareq form.prevgrade.data = course.prevgrade form.numslots.data = course.numslots form.addinfo.data = course.addinfo return render_template('editcourse.html', title='Edit Course', form=form, course=course)
def editCourse(courseId): form = CourseForm() course = db.session.query(Course).filter_by(id=courseId).first_or_404() if form.validate_on_submit(): course.name = form.name.data course.description = form.description.data formElToAppendLessons(form.lessonsIncluded, course) if request.files['imgFile']: if stopFileUpload(request, 'Image'): return render_template(url_for('editCourse'), courseId=courseId, title='Edit Course', form=form) course.imgFileLoc = changeFileReturnFileName(request, 'Image', course.imgFileLoc) db.session.commit() flash('Your changes were saved') return redirect(url_for('editCourse', courseId=courseId)) elif request.method == 'GET': lessonGroups = findLessonsGroups(course) lessonIDsInCourse = set([lesson.id for lesson in lessonGroups['lessonsInCourse']]) form.name.data = course.name form.description.data = course.description form.lessonsIncluded.data = ''.join(str(lessonID) + ',' for lessonID in lessonIDsInCourse ) return render_template('editCourse.html', title='Edit Course', course=course, form=form, lessonsInCourse=lessonGroups['lessonsInCourse'], lessonsUserCreated=lessonGroups['lessonsUserCreated'], lessonsOthersCreated=lessonGroups['lessonsOthersCreated'], lessonIDsInCourse=lessonIDsInCourse)
def saveEditCourse(course_id, teacher_id): """process course edit form""" form = CourseForm(request.form) course = {} if request.method == 'POST' and form.validate(): course['title'] = request.form['title'] course['section'] = request.form['section'] course['department'] = request.form['department'] course['description'] = request.form['description'] course['units'] = request.form['units'] db_conn = db_pool.getconn() cursor = db_conn.cursor() cursor.execute( f"UPDATE course SET title = %s, section = %s, department = %s, " f"description = %s, units = %s WHERE course_id = %s;", (course['title'], course['section'], course["department"], course["description"], course["units"], course_id)) db_conn.commit() cursor.close() db_pool.putconn(db_conn) return redirect(url_for('renderTeachers', teacher_id=teacher_id))
def update(): form = CourseForm() if form.validate_on_submit(): q.enqueue(main_function, form.class_name.data, current_user.email, form.url.data, int(form.seats.data)) flash('Congratulations course has been tracked!') return redirect(url_for('index')) return render_template('update.html', title='update', form=form)
def addcourse(): form = CourseForm() form.ic_id.choices = [(str(i[0]), i[1]) for i in Faculty.get_all_faculty()] if form.validate_on_submit(): Course.create_course(form.course_id.data, form.course_name.data, int(form.ic_id.data)) flash('The course has been added successfully') return redirect(url_for('index')) return render_template('courseForm.html', title='Add Course', form=form)
def add_course(): form = CourseForm() course = Course() if request.method == 'POST' and form.validate_on_submit(): course.course_title = form.course_title.data course.course_name = form.course_name.data course.add_course() flash(f'Successfully Added course of title "{form.course_title.data}"', category='success') return redirect(url_for('courses')) else: return render_template('add_course.html', form=form)
def create_course(): form = CourseForm() if form.validate_on_submit(): course = Courses(title=form.title.data, startdate=form.startdate.data, enddate=form.enddate.data, semester=form.semester.data, professor_id=current_user._get_current_object().id) db.session.add(course) db.session.commit() flash("Your course is created!") return redirect(url_for('show_courses')) return render_template('create_course.html', form=form)
def addCourse(teacher_id): """display add course form""" addCourseForm = CourseForm() return render_template( 'addcourse.html', addCourseForm=addCourseForm, teacher_id=teacher_id)
def addcourse(): form = CourseForm() if form.validate_on_submit(): course = Course(subject=form.subject.data, number=form.number.data, title=form.title.data, gpareq=form.gpareq.data, prevgrade=form.prevgrade.data, numslots=form.numslots.data, addinfo=form.addinfo.data, professor=current_user) db.session.add(course) db.session.commit() flash("You have created a new course!") return redirect(url_for('Facindex')) return render_template('addcourse.html', title='Create Course', form=form)
def post(self,request): data=request.body dict_data = json.loads(data) print(dict_data) CourseForm() #CourseModel(name=dict_data['name'],fee=dict_data['fee']).save() json_response=json.dumps({"message":"data saved sucessfully"}) return HttpResponse(json_response, content_type="application/json")
def createCourse(): form = CourseForm() lessonGroups = findLessonsGroups(course=None) if form.validate_on_submit(): user = current_user if stopFileUpload(request, 'Image'): return render_template('createCourse.html', title='Create Course', form=form) imgFilename = saveFileReturnFileName(request, 'Image') course = Course(name=form.name.data, description=form.description.data, imgFileLoc=imgFilename, createdBy=user.id ) formElToAppendLessons(form.lessonsIncluded, course) db.session.add(course) db.session.commit() flash('Course created successfully.') return redirect(url_for('admin', username=current_user.username)) return render_template('createCourse.html', title='Create Course', form=form, lessonsInCourse=lessonGroups['lessonsInCourse'], lessonsUserCreated=lessonGroups['lessonsUserCreated'], lessonsOthersCreated=lessonGroups['lessonsOthersCreated'])
def edit_course(course_id=None): if course_id: course = Course.query.get(course_id) else: course = Course() if not course: abort(404) latest_term = course.latest_term if not latest_term: abort(404) course_form = CourseForm(formdata=request.form, obj=course) if course_form.validate_on_submit(): course_form.introduction.data = sanitize(course_form.introduction.data) course_form.populate_obj(latest_term) if not latest_term.homepage.startswith('http'): latest_term.homepage = 'http://' + course.homepage latest_term.save() db.session.commit() return redirect(url_for('course.view_course', course_id=course.id)) return render_template('course-edit.html', form=course_form, course=course)
def index(): form = CourseForm() update_course = User.query.filter_by(id=current_user.id).first() update_course.student_courses = form.student_courses.data flash('Looking for students with the same course') found_buddy = User.query.filter_by( student_courses=update_course.student_courses) return render_template('index.html', title='User_Home', form=form, found_buddy=found_buddy)
def add_course(): r = request.args.get('redir') if r in REDIR_PAGES: session['origin'] = url_for(REDIR_PAGES[r]) elif r == 'edit' and 'examination_edit_id' in session: session['origin'] = '/examination/edit/{}'.format( session['examination_edit_id']) if not ModuleAPI.can_write('examination', True): session['prev'] = 'examination.add_course' return abort(403) form = CourseForm(request.form) if request.method == 'POST': if form.validate_on_submit(): title = form.title.data course = Course.query.filter(Course.name == title).first() if not course: description = form.description.data new_course = Course(title, description) db.session.add(new_course) db.session.commit() flash("'%s': " % title + _('Course succesfully added.'), 'success') else: flash("'%s': " % title + _('Already exists in the database'), 'danger') return render_template('course/edit.htm', new=True, form=form) if 'origin' in session: redir = session['origin'] else: redir = url_for('examination.add') return redirect(redir) else: flash_form_errors(form) return render_template('course/edit.htm', new=True, form=form)
def edit_course(course_id=None): if not current_user.is_admin: abort(403) if course_id: course = Course.query.get(course_id) else: course = Course() if not course: abort(404) latest_term = course.latest_term if not latest_term: abort(404) course_form = CourseForm(request.form, course) if course_form.validate_on_submit(): course_form.introduction.data = sanitize(course_form.introduction.data) course_form.populate_obj(latest_term) if not latest_term.homepage.startswith("http"): latest_term.homepage = "http://" + course.homepage latest_term.save() db.session.commit() return redirect(url_for("course.view_course", course_id=course.id)) return render_template("course-edit.html", form=course_form, course=course)
def createcourse(request): if request.method == "GET": form = CourseForm() return render(request, 'createCourses.html', {'form': form}) if request.method == "POST": form = CourseForm(request.POST) form.save() return HttpResponseRedirect('/courses')
def course(courseId): course = Course.query.get(courseId) coursename = course.name description = course.description cform = CourseForm() # if (course) : # #enrolledcourses = Enrollment.query.filter_by(and_(Enrollment.related_user==current_user ,Enrollment.state==True)) if (request.method == 'POST'): if 'enroll' in request.form: en = Enrollment.query.filter( and_(Enrollment.related_course == course, Enrollment.related_user == current_user)).first() if en is None: enrollment = Enrollment(course_id=course.id, user_id=current_user.id, state=True) db.session.add(enrollment) db.session.commit() flash('You are successfully enrolled in %s course!' % coursename) return redirect(url_for('viewCourse', courseId=course.id)) else: if en.state == False: en.state = True db.session.add(en) db.session.commit() return redirect(url_for('viewCourse', courseId=course.id)) if 'remind' in request.form: en = Enrollment.query.filter( and_(Enrollment.related_course == course, Enrollment.related_user == current_user)).first() if en is None: remind = Enrollment(course_id=course.id, user_id=current_user.id, state=False) db.session.add(remind) db.session.commit() flash('You have added %s course to your goals.' % coursename) return redirect(url_for('my_courses')) else: return redirect(url_for('my_courses')) return render_template('landing_page/course-details.html', title='%s' % coursename, course=course)
def editCourse(course_id): """display edit course form""" db_conn = db_pool.getconn() dict_cur = db_conn.cursor(cursor_factory=extras.DictCursor) dict_cur.execute(f'SELECT * FROM course ' f'WHERE course_id = {course_id}') course = dict_cur.fetchone() dict_cur.close() db_pool.putconn(db_conn) editCourseForm = CourseForm() return render_template( 'editcourse.html', editCourseForm=editCourseForm, course=course)
def index(): form = CourseForm() grades = [10, 20, 30, 5] if request.method == 'POST': department = request.form['DepartmentInput'] course_subject = str(request.form['CourseSubjectInput']).upper() catalog_number = request.form['CatalogNumberInput'] gd_urls = link(department, course_subject, catalog_number) class_name = make_course_name(department, course_subject, catalog_number) gd_dataframe = table_data(gd_urls, class_name) avg_gpa = round(gd_dataframe['CLS GPA'].mean(), 2) flash("Avg Grade Distribution: {}, {}, {}, {}".format( round(gd_dataframe['A%'].mean(), 2), round(gd_dataframe['B%'].mean(), 2), round(gd_dataframe['C%'].mean(), 2), round(gd_dataframe['D%'].mean(), 2))) flash("Avg Class GPA: {}".format(avg_gpa)) grades = [ round(gd_dataframe['A%'].mean(), 2), round(gd_dataframe['B%'].mean(), 2), round(gd_dataframe['C%'].mean(), 2), round(gd_dataframe['D%'].mean(), 2) ] course = "{}-{} {}".format(department, course_subject, catalog_number) list_of_teachers = gd_dataframe['Instructor'].unique() teacher_ratings = [] for teacher in list_of_teachers: teacher_rating = find_teachergrade(teacher) teacher_ratings.append(teacher_rating) return render_template('index.html', form=form, grades=grades, course=course, teachers=teacher_ratings) return render_template('index.html', form=form, grades=grades)
def edit_course(course_id): r = request.args.get('redir') if r in REDIR_PAGES: session['origin'] = url_for(REDIR_PAGES[r]) elif r == 'edit' and 'examination_edit_id' in session: session['origin'] = '/examination/edit/{}'.format( session['examination_edit_id']) if not ModuleAPI.can_write('examination', True): session['prev'] = 'examination.edit_course' return abort(403) course = Course.query.get(course_id) if not course: flash(_('Course could not be found.'), 'danger') return redirect(url_for('examination.view_courses')) exam_count = Examination.query.filter(Examination.course == course).count() if 'delete' in request.args: if exam_count > 0: flash(_('Course still has examinations in the database.'), 'danger') form = CourseForm(title=course.name, description=course.description) return render_template('course/edit.htm', new=False, form=form, course=course, redir=r, exam_count=exam_count) Course.query.filter_by(id=course_id).delete() db.session.commit() flash(_('Course succesfully deleted.'), 'success') if 'origin' in session: redir = session['origin'] else: redir = url_for('examination.add') return redirect(redir) if request.method == 'POST': form = CourseForm(request.form) if form.validate_on_submit(): title = form.title.data if title != course.name and Course.query.filter( Course.name == title).count() >= 1: flash("'%s': " % title + _('Already exists in the database'), 'danger') return render_template('course/edit.htm', new=False, form=form, redir=r, course=course, exam_count=exam_count) else: description = form.description.data course.name = title course.description = description db.session.commit() flash(_('Course succesfully saved.'), 'success') if 'origin' in session: redir = session['origin'] else: redir = url_for('examination.add') return redirect(redir) else: flash_form_errors(form) else: form = CourseForm(title=course.name, description=course.description) return render_template('course/edit.htm', new=False, form=form, redir=r, course=course, exam_count=exam_count)
def edit_education(education_id): r = request.args.get('redir') if r in REDIR_PAGES: session['origin'] = url_for(REDIR_PAGES[r]) elif r == 'edit' and 'examination_edit_id' in session: session['origin'] = '/examination/edit/{}'.format( session['examination_edit_id']) if not ModuleAPI.can_write('examination', True): session['prev'] = 'examination.edit_education' return abort(403) education = Education.query.get(education_id) if not education: flash(_('Education could not be found.'), 'danger') return redirect(url_for('examination.view_educations')) exam_count = Examination.query.filter( Examination.education == education).count() if 'delete' in request.args: if exam_count > 0: flash(_('Education still has examinations in the database.'), 'danger') form = CourseForm(title=education.name) return render_template('education/edit.htm', new=False, form=form, education=education, redir=r, exam_count=exam_count) Education.query.filter_by(id=education_id).delete() db.session.commit() flash(_('Education succesfully deleted.'), 'success') if 'origin' in session: redir = session['origin'] else: redir = url_for('examination.add') return redirect(redir) if request.method == 'POST': form = EducationForm(request.form) if form.validate_on_submit(): name = form.title.data if name != education.name and Education.query.filter( Education.name == name).count() >= 1: flash("'%s': " % name + _('Already exists in the database'), 'danger') return render_template('education/edit.htm', new=False, form=form, redir=r, exam_count=exam_count, education=education) else: education.name = name db.session.commit() flash("'%s': " % name + _('Education succesfully saved.'), 'success') if 'origin' in session: redir = session['origin'] else: redir = url_for('examination.view_educations') return redirect(redir) else: flash_form_errors(form) else: form = CourseForm(title=education.name) return render_template('education/edit.htm', new=False, form=form, redir=r, exam_count=exam_count, education=education)