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