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()