def convert(self):
student = Student()
student.user_name = self.USER_NAME
student.first_name = self.FIRST_NAME
student.last_name = self.LAST_NAME
student.email = self.EMAIL
student.create_time = self.CREATE_TIME
semester = session.query(Semester).filter_by(id=self.SEMESTER_ID).first()
if semester == None:
print 'Semester Not found for:'
print self.USER_NAME
enrollment = Enrollment(student=student, semester=semester)
if enrollment == None:
print 'Enrollment Not populated for:'
print self.USER_NAME
return student, enrollment
elif requested_operation == 'update':
for row in reader:
year = row[0].strip()
season = row[1].strip()
course_no = row[2].strip()
user_name = row[3].strip()
first_name = row[4].strip()
last_name = row[5].strip()
email = row[6].strip()
alias_name = row[7].strip()
semester = session.query(Semester).filter_by(year=year, season=season, course_no=course_no).first()
if semester == None:
print 'One or more semester configuration not found.'
sys.exit(11)
is_student_exists = session.query(Student).filter_by(user_name=user_name).count()
is_student_enrolled = session.query(Enrollment).filter_by(student_id=user_name, semester=semester).count()
if is_student_exists > 0:
student = session.query(Student).filter_by(user_name=user_name).first()
student.first_name = first_name
student.last_name = last_name
student.email = email
student.alias_name = alias_name
session.commit()
print "Student configuration tables successfully populated."
except Exception as e:
print "Error populating student configuration tables.", str(e)
