def get_students(csv_file):
"""
:param csv_file: csv file with list of students.\
Each row contains: first_name, last_name, email
:type csv_file: str
:rtype: 2 lists existing_students and new_students [[username, email], ..]
"""
with open(csv_file) as ff:
reader = csv.reader(ff, delimiter=',')
existing_students = []
new_students = []
for i, row in enumerate(reader):
row = [unidecode(x.strip()) for x in row[:3]]
username = "_".join(row[:2])
username = username.replace(" ", "_")
email = row[2]
try:
u = User.objects.get(username=username)
Student.objects.get(user=u)
existing_students.append([u.username, u.email])
except ObjectDoesNotExist:
new_students.append([username, email])
return existing_students, new_students
评论列表
文章目录