def make_test_course(): course = CourseraCourse() course.cid = 'introstats2' course.n_seq = 1 # '001' course.title = 'Introduction to Statistics' course.description = 'Introduction to Statistics is nice course!' course.start_date = datetime.date(2013, 4, 5) course.duration_in_weeks = 8 # course.workload_in_hours_per_day = 3 course.workload_in_hours_per_week = 3 institution = Institution() institution.id = 10 institution.name = 'Harvard Univ.' course.institutions = [institution] professor = Instructor() professor.id = 10 professor.name = 'John Joey' professor.institution = institution course.instructors = [professor] category = Category() category.id = 10 category.name = 'Mathematics & Statistics' course.categories = [category] print 'course', course print 'Instructors', course.instructors.values() return course
def save_courses_subset_to_db(self): for i, course_subset in enumerate(self.courses_subset): #if course_subset.university == None: #continue try: print str(i+1).zfill(3), 'Saving to db', course_subset except UnicodeEncodeError: print str(i+1).zfill(3), 'Saving to db' course = CourseraCourse() course.cid = course_subset.cid course.n_seq = course_subset.get_n_seq() course.title = course_subset.title if course_subset.start_date != None: course.start_date = course_subset.start_date if course_subset.duration_in_weeks != None: course.duration_in_weeks = course_subset.duration_in_weeks #course.save() if course_subset.university != None: university_name = course_subset.university try: institution = Institution.objects.get(name=university_name) except Institution.DoesNotExist: institution = Institution() institution.name = university_name #institution.courseracourse_id = course.cid institution.save() print 'institution id', institution.id #CourseraCourse.objects.create(name=university_name) except AttributeError, e: print 'university_name', university_name print e #sys.exit(0) pass #course.in #course.institutions.add(institution.id) course.save()