def course_delete(userid, id): course = Course.query.filter_by(id=id, admin_id=userid).first() if not course: return Resp.error(message="这个课程不是你创建的,你没有权限删除它") else: db.session.delete(course) db.session.commit() return Resp.success()
def user_love_course(userid, course_id): user = User.query.get(userid) course = Course.query.get(course_id) if not course in user.courses: user.courses.append(course) course.collect_num = len(course.users) db.session.commit() return Resp.success() else: return Resp.error()
def give_course_score(userid, course_id, score): score_all = Scores.query.filter_by(course_id=course_id).all() has_score = Scores.query.filter_by(user_id=userid, course_id=course_id).first() course = Course.query.get(course_id) if not has_score: score_new = Scores(user_id=userid, course_id=course_id, score=score) score_time = len(score_all) if score_time == 0: course.score = score else: course.score = (course.score + score) / (score_time + 1) db.session.add(score_new) db.session.commit() return Resp.success() else: return Resp.error(message="已经打过分了")
def get_course_score(userid, course_id): score = Scores.query.filter_by(user_id=userid, course_id=course_id).first() if score: return Resp.success(data=score.score) else: return Resp.error()