def import_course(filename):
with open(filename, 'rt', encoding='utf-8') as csvfile:
reader = csv.reader(csvfile, delimiter=',')
course_list = list(reader)
for i in course_list[1:]:
try:
c = Course(code=i[0],
title=i[1],
topic=i[2],
type=i[3],
opening=i[4],
duration=i[5],
venue=i[6],
fee=i[7],
grant=i[8],
wsa=i[9],
remark=i[10],
overview=i[11],
outline=i[12],
testimonial=i[13],
upcoming=i[14],
hyperlink=i[15])
c.save()
print('Added: {}'.format(i[0]))
except IntegrityError as e:
if 'UNIQUE constraint failed: core_course.code' in e.args:
c = Course.objects.get(code=i[0])
c.title = i[1]
c.topic = i[2]
c.type = i[3]
c.opening = i[4]
c.duration = i[5]
c.venue = i[6]
c.fee = i[7]
c.grant = i[8]
c.wsa = i[9]
c.remark = i[10]
c.overview = i[11]
c.outline = i[12]
c.testimonial = i[13]
c.upcoming = i[14]
c.hyperlink = i[15]
c.save()
print('Updated: {}'.format(i[0]))
