def course_verify_cancel(request): try: check_capability_course(request, 'admin') course = course_get_by_id(request.matchdict['course_id']) if course.verified: raise Exception("Source mustn't be canceled") db_session.delete(course) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_verify_cancel(request): try: check_capability_course(request, 'admin') course = course_get_by_id(request.matchdict['course_id']) if course.verified: raise Exception("Source mustn't be canceled") db_session.delete(course) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_erase(request): return course_erase_all(request) try: raise Exception("DEPRECATED") course = course_get_by_id(request.matchdict['course_id']) if course_check_owner(course.course_id, int(RequestGetUserId(request))) \ or course_tree_check_owner(course.id, RequestGetUserId(request)): check_capability_course(request, 'teacher') else: check_capability_course(request, 'admin') db_session.delete(course) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_erase(request): return course_erase_all(request) try: raise Exception("DEPRECATED") course = course_get_by_id(request.matchdict['course_id']) if course_check_owner(course.course_id, int(RequestGetUserId(request))) \ or course_tree_check_owner(course.id, RequestGetUserId(request)): check_capability_course(request, 'teacher') else: check_capability_course(request, 'admin') db_session.delete(course) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_verify(request): try: check_capability_course(request, 'admin') full_access = int(request.params.get('full_access', 0)) course = course_get_by_id(request.matchdict['course_id']) course.verified = True if full_access: db_session.add(CourseTreeCap( node_id=course.id, user_id=course.author, )) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_erase_all(request): try: course = course_get_by_id(request.matchdict['course_id']) teacher = False teacher = teacher or (not course.verified \ and course.author == int(RequestGetUserId(request))) teacher = teacher or course_check_owner(course.course_id, int(RequestGetUserId(request))) teacher = teacher or course_tree_check_owner(course.id, RequestGetUserId(request)) check_capability_course(request, 'teacher' if teacher else 'admin') erase_tree(course) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_update(request): try: course = course_get_by_id(request.matchdict['course_id']) if course_check_owner(course.course_id, int(RequestGetUserId(request))) \ or course_tree_check_owner(course.id, RequestGetUserId(request)): check_capability_course(request, 'teacher') else: check_capability_course(request, 'admin') for field in ['parent_id', 'name', 'order', 'verified', 'course_id', 'displayed']: if field in request.params: course.__setattr__(field, request.params[field]) course.author = RequestGetUserId(request) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_erase_all(request): try: course = course_get_by_id(request.matchdict['course_id']) teacher = False teacher = teacher or (not course.verified \ and course.author == int(RequestGetUserId(request))) teacher = teacher or course_check_owner(course.course_id, int(RequestGetUserId(request))) teacher = teacher or course_tree_check_owner(course.id, RequestGetUserId(request)) check_capability_course(request, 'teacher' if teacher else 'admin') erase_tree(course) db_session.commit() course_make_dump(request) return {'result': 'ok'} except Exception as e: return {'result': 'error', 'content': e.__str__()}
def course_all(request): try: check_capability_course(request, 'admin') courses_res = [] courses = db_session.query(CourseRaw).\ filter(CourseRaw.category.in_([24, 34])).all() for course in courses: nodes = db_session.query(Course).filter(Course.course_id == course.id).all() paths = [node.parent.full_name() + ("" if node.verified else " (не разобрано)") \ for node in nodes] courses_res.append({ 'course': course, 'paths': paths, 'authors': course_get_users(course.id), }) return { 'courses': courses_res, } except Exception as e: return Response("Error: " + e.__str__())
def course_add(request): try: add_dict = dict(request.params) names = request.params['name'].split('\n') order = request.params['order'] parent_id = int(request.params['parent_id']) user_id = int(RequestGetUserId(request)) if order == 'end': parent = db_session.query(Course).filter( Course.id == request.params['parent_id']).one() max_order = max(course.order for course in parent.children) \ if list(parent.children) else 0 order = "{0}:{1}".format(max_order, max_order + 10**7) order, order_right = map(int, order.split(':')) order_shift = (order_right - order) / (len(names) + 1) ids = [] for name in names: vals = name.split("+++") title, course_id = name, 0 if len(vals) == 2: title, course_id = vals similar = db_session.query(Course).filter( Course.parent_id == request.params['parent_id'], Course.course_id == course_id, ).all() verified = check_capability_ex_course(request, 'admin') \ or bool(course_tree_check_owner(parent_id, user_id)) if course_id: if similar: continue if course_check_owner(int(course_id), int(RequestGetUserId(request))): check_capability_course(request, 'teacher') else: check_capability_course(request, 'admin') else: check_capability_course(request, 'teacher') order += order_shift add_dict['name'] = title add_dict['order'] = order add_dict['verified'] = verified add_dict['course_id'] = course_id add_dict['author'] = max(0, user_id) node_id = course_add_by_dict(add_dict) ids.append(node_id) db_session.commit() course_make_dump(request) return { "result": "ok", "content": { "new_id": ids, } } except Exception as e: return {"result": "error", "content": e.__str__()}
def course_add(request): try: add_dict = dict(request.params) names = request.params['name'].split('\n') order = request.params['order'] parent_id = int(request.params['parent_id']) user_id = int(RequestGetUserId(request)) if order == 'end': parent = db_session.query(Course).filter( Course.id == request.params['parent_id'] ).one() max_order = max(course.order for course in parent.children) \ if list(parent.children) else 0 order = "{0}:{1}".format(max_order, max_order + 10**7) order, order_right = map(int, order.split(':')) order_shift = (order_right - order) / (len(names) + 1) ids = [] for name in names: vals = name.split("+++") title, course_id = name, 0 if len(vals) == 2: title, course_id = vals similar = db_session.query(Course).filter( Course.parent_id == request.params['parent_id'], Course.course_id == course_id, ).all() verified = check_capability_ex_course(request, 'admin') \ or bool(course_tree_check_owner(parent_id, user_id)) if course_id: if similar: continue if course_check_owner(int(course_id), int(RequestGetUserId(request))): check_capability_course(request, 'teacher') else: check_capability_course(request, 'admin') else: check_capability_course(request, 'teacher') order += order_shift add_dict['name'] = title add_dict['order'] = order add_dict['verified'] = verified add_dict['course_id'] = course_id add_dict['author'] = max(0, user_id) node_id = course_add_by_dict(add_dict) ids.append(node_id) db_session.commit() course_make_dump(request) return {"result": "ok", "content": { "new_id": ids, }} except Exception as e: return {"result": "error", "content": e.__str__()}