def parse_course_list(request): if not request.user.is_authenticated(): return HttpResponse("Not authenticated.") session = HTMLSession() course_list_r = session.request(url='https://ocw.mit.edu/courses/', method='get') courses = course_list_r.html.find('.course_title') # Clear out old courses Course.objects.all().delete() sequence_sql = connection.ops.sequence_reset_sql(no_style(), [Course]) with connection.cursor() as cursor: for sql in sequence_sql: cursor.execute(sql) for course in courses: course_db_obj = Course(url=course.absolute_links.pop()) course_db_obj.save() return HttpResponse("Successfully added all ")
from server.models import Course from server.models import University from datetime import datetime u = University.objects.get(name="University of Victoria") c = Course(name="CSc 111", start_date=datetime(2014, 5, 1), end_date=datetime(2014, 8, 31), university=u) c.save()