def summary_table_read(file, fieldnames, rows):
with open(file, "rb") as csvfile:
reader = unicodecsv.DictReader(csvfile, fieldnames)
for row in reader:
registration_number_handler(row)
period_handler(row)
row.pop(None, None)
rows.append(row)
def students_table_write(file, fieldnames, rows, db, exclusions):
with open(file, 'w') as csvfile:
writer = unicodecsv.DictWriter(
csvfile, fieldnames)
writer.writeheader()
for row in rows:
registration_number_handler(row)
if row['registration_number'] in exclusions[db]['STUDENTS']:
continue
if row['registration_number'] in exclusions['DUPLICATES']['STUDENTS']:
continue
#or else
writer.writerow(row)
def _assign_advisors(self):
files = ['academic_advisors1.csv', 'academic_advisors2.csv']
for file in files:
with open(self.FILES_LOCATION + file, 'rb') as csvfile:
reader = unicodecsv.DictReader(
csvfile, fieldnames=['registration_number',
'student_name', 'advisor'])
for row in reader:
registration_number_handler(row)
if self.verbosity > 1:
print("I'll now process {}, {}"
.format(row['registration_number'],
row['student_name']))
student = Student.objects.get(
registration_number=row['registration_number']
)
student.advisor = row['advisor']
student.save()