def add_course(user_email, course_name): """ Link a user and a course """ from lib.UserCourse import UserCourse user_ref = User.get_by_key_name(user_email) course_ref = Course.get_by_key_name(course_name) new_user_course = UserCourse(user=user_ref, course=course_ref) new_user_course.put()
def remove_course(university_name, course_name): """ Unlink a university and a course """ university_ref = University.get_by_key_name(university_name) course_ref = Course.get_by_key_name(course_name) uni_course_ref = db.GqlQuery( "SELECT * FROM UniversityCourse WHERE " + "university = :1 AND " + "course = :2", university_ref, course_ref ) db.delete(uni_course_ref)
def add_course(university_name, course_name): """ Link a university and a course """ from lib.UniversityCourse import UniversityCourse university_ref = University.get_by_key_name(university_name) course_ref = Course.get_by_key_name(course_name) new_university_course = UniversityCourse(university=university_ref, course=course_ref) new_university_course.put()
def list_courses(university_name): """ List all courses associated with a university """ courses = [] university_ref = University.get_by_key_name(university_name) university_course_ref = db.GqlQuery("SELECT * FROM UniversityCourse WHERE " + "university = :1", university_ref) for course_ref in university_course_ref.run(): course_key = UniversityCourse.course.get_value_for_datastore(course_ref) course_res = Course.get(course_key) courses.append(course_res) return courses
def remove_course(user_email, course_name): """ Unlink a user and a course """ user_ref = User.get_by_key_name(user_email) course_ref = Course.get_by_key_name(course_name) user_course_ref = db.GqlQuery("SELECT * FROM UserCourse WHERE " +\ "user = :1 AND " +\ "course = :2", user_ref, course_ref) db.delete(user_course_ref)
def remove_course(university_name, course_name): """ Unlink a university and a course """ university_ref = University.get_by_key_name(university_name) course_ref = Course.get_by_key_name(course_name) uni_course_ref = db.GqlQuery("SELECT * FROM UniversityCourse WHERE " +\ "university = :1 AND " +\ "course = :2", university_ref, course_ref) db.delete(uni_course_ref)
def list_courses(user_email): """ List all courses associated with a user """ from lib.UserCourse import UserCourse courses = [] user_ref = User.get_by_key_name(user_email) user_course_ref = db.GqlQuery("SELECT * FROM UserCourse WHERE " +\ "user = :1", user_ref) for course_ref in user_course_ref.run(): course_key = UserCourse.course.get_value_for_datastore(course_ref) course_res = Course.get(course_key) courses.append(course_res) return courses
def list_courses(university_name): """ List all courses associated with a university """ courses = [] university_ref = University.get_by_key_name(university_name) university_course_ref = db.GqlQuery("SELECT * FROM UniversityCourse WHERE " +\ "university = :1", university_ref) for course_ref in university_course_ref.run(): course_key = UniversityCourse.course.get_value_for_datastore( course_ref) course_res = Course.get(course_key) courses.append(course_res) return courses
def create_course_interface(school_name): from lib.Course import Course new_course = Course.create() return common.add_course_interface(school_name, new_course)