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)