Changeset 16827 for main/waeup.kofa/trunk/src/waeup/kofa/students/tests

Timestamp:

22 Feb 2022, 12:48:36 (3 years ago)

Author:

Henrik Bettermann

Message:

Add exporters for previous study course data.

Location:

main/waeup.kofa/trunk/src/waeup/kofa/students/tests

Files:

• test_export.py (modified) (3 diffs)
• test_student.py (modified) (4 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_export.py

@@ -21 +21 @@
 import datetime
 from cStringIO import StringIO
-from zope.component import queryUtility, getUtility
+from zope.component import queryUtility, getUtility, createObject
 from zope.event import notify
 from zope.interface.verify import verifyObject, verifyClass
@@ -30 +30 @@
 from waeup.kofa.university.certificate import CertificateCourse
 from waeup.kofa.students.export import (
-    StudentExporter, StudentStudyCourseExporter, StudentStudyLevelExporter,
-    CourseTicketExporter, StudentPaymentExporter, BedTicketExporter,
+    StudentExporter,
+    StudentStudyCourseExporter,
+    FirstStudentStudyCourseExporter,
+    SecondStudentStudyCourseExporter,
+    StudentStudyLevelExporter,
+    FirstStudentStudyLevelExporter,
+    SecondStudentStudyLevelExporter,
+    CourseTicketExporter,
+    FirstCourseTicketExporter,
+    SecondCourseTicketExporter,
+    StudentPaymentExporter, BedTicketExporter,
     SchoolFeePaymentsOverviewExporter, StudyLevelsOverviewExporter,
     ComboCardDataExporter, DataForBursaryExporter,
@@ -516 +525 @@
         return
 
+class PreviousStudyCourseExporterTests(StudentImportExportSetup):
+
+    layer = FunctionalLayer
+
+    def setUp(self):
+        super(PreviousStudyCourseExporterTests, self).setUp()
+        self.setup_for_export()
+        self.certificate2 = createObject('waeup.Certificate')
+        self.certificate2.code = 'CERT2'
+        self.certificate2.application_category = 'basic'
+        self.certificate2.start_level = 200
+        self.certificate2.end_level = 500
+        self.app['faculties']['fac1']['dep1'].certificates.addCertificate(
+            self.certificate2)
+        return
+
+    def test_export_studycourses(self):
+        self.setup_student(self.student)
+        exporter = FirstStudentStudyCourseExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'certificate,current_level,current_session,current_verdict,'
+            'entry_mode,entry_session,previous_verdict,student_id\r\n'
+            )
+        error = self.student.transfer(self.certificate2, current_session=2013)
+        self.assertTrue(error == None)
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'certificate,current_level,current_session,current_verdict,'
+            'entry_mode,entry_session,previous_verdict,student_id\r\n'
+            'CERT1,200,2012,0,ug_ft,2010,0,A111111\r\n')
+        error = self.student.transfer(self.certificate,
+                                      current_session=2014,
+                                      current_level=300)
+        self.assertTrue(error == None)
+        exporter = SecondStudentStudyCourseExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'certificate,current_level,current_session,current_verdict,'
+            'entry_mode,entry_session,previous_verdict,student_id\r\n'
+            'CERT2,,2013,,transfer,2010,,A111111\r\n')
+        exporter = StudentStudyCourseExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'certificate,current_level,current_session,current_verdict,'
+            'entry_mode,entry_session,previous_verdict,student_id\r\n'
+            'CERT1,300,2014,,transfer,2010,,A111111\r\n')
+        return
+
+    def test_export_studylevels(self):
+        self.setup_student(self.student)
+        exporter = FirstStudentStudyLevelExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'gpa,level,level_session,level_verdict,total_credits,'
+            'transcript_remark,validated_by,validation_date,student_id,'
+            'number_of_tickets,certcode\r\n'
+            )
+        error = self.student.transfer(self.certificate2, current_session=2013)
+        self.assertTrue(error == None)
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'gpa,level,level_session,level_verdict,total_credits,'
+            'transcript_remark,validated_by,validation_date,student_id,'
+            'number_of_tickets,certcode\r\n'
+            '0.00,100,2012,A,100,,,,A111111,1,CERT1\r\n' )
+        study_level = StudentStudyLevel()
+        study_level.level_session = 2015
+        study_level.level_verdict = "C"
+        study_level.level = 400
+        self.student['studycourse'].addStudentStudyLevel(
+            self.certificate2, study_level)
+        error = self.student.transfer(self.certificate,
+                                      current_session=2014,
+                                      current_level=300)
+        self.assertTrue(error == None)
+        exporter = SecondStudentStudyLevelExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'gpa,level,level_session,level_verdict,total_credits,'
+            'transcript_remark,validated_by,validation_date,student_id,'
+            'number_of_tickets,certcode\r\n'
+            '0.00,400,2015,C,0,,,,A111111,0,CERT2\r\n')
+        exporter = StudentStudyLevelExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'gpa,level,level_session,level_verdict,total_credits,'
+            'transcript_remark,validated_by,validation_date,student_id,'
+            'number_of_tickets,certcode\r\n')
+        return
+
+    def test_export_coursetickets(self):
+        self.setup_student(self.student)
+        exporter = FirstCourseTicketExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'automatic,carry_over,code,course_category,credits,dcode,'
+            'fcode,level,level_session,mandatory,outstanding,passmark,'
+            'score,semester,ticket_session,title,student_id,certcode,'
+            'display_fullname\r\n'
+            )
+        error = self.student.transfer(self.certificate2, current_session=2013)
+        self.assertTrue(error == None)
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'automatic,carry_over,code,course_category,credits,dcode,'
+            'fcode,level,level_session,mandatory,outstanding,passmark,'
+            'score,semester,ticket_session,title,student_id,certcode,'
+            'display_fullname\r\n'
+            '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,'
+            'A111111,CERT1,Anna M. Tester\r\n')
+        study_level = StudentStudyLevel()
+        study_level.level_session = 2015
+        study_level.level_verdict = "C"
+        study_level.level = 400
+        self.student['studycourse'].addStudentStudyLevel(
+            self.certificate2, study_level)
+        ticket = CourseTicket()
+        ticket.automatic = True
+        ticket.carry_over = True
+        ticket.code = u'CRS9'
+        ticket.title = u'Course 9'
+        ticket.fcode = u'FAC9'
+        ticket.dcode = u'DEP9'
+        ticket.credits = 150
+        ticket.passmark = 100
+        ticket.semester = 2
+        study_level[ticket.code] = ticket
+        error = self.student.transfer(self.certificate,
+                                      current_session=2014,
+                                      current_level=300)
+        self.assertTrue(error == None)
+        exporter = SecondCourseTicketExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'automatic,carry_over,code,course_category,credits,dcode,'
+            'fcode,level,level_session,mandatory,outstanding,passmark,'
+            'score,semester,ticket_session,title,student_id,certcode,'
+            'display_fullname\r\n1,1,CRS9,,150,DEP9,FAC9,400,2015,0,0,'
+            '100,,2,,Course 9,A111111,CERT2,Anna M. Tester\r\n')
+        exporter = CourseTicketExporter()
+        exporter.export_all(self.app, self.outfile)
+        result = open(self.outfile, 'rb').read()
+        self.assertEqual(
+            result,
+            'automatic,carry_over,code,course_category,credits,dcode,'
+            'fcode,level,level_session,mandatory,outstanding,passmark,'
+            'score,semester,ticket_session,title,student_id,certcode,'
+            'display_fullname\r\n'
+            )
+        return
 
 class StudentStudyLevelExporterTest(StudentImportExportSetup):

main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_student.py

@@ -160 +160 @@
         super(StudentRemovalTests, self).setUp()
         self.setup_for_export()
+        self.certificate2 = createObject('waeup.Certificate')
+        self.certificate2.code = 'CERT2'
+        self.certificate2.application_category = 'basic'
+        self.certificate2.start_level = 200
+        self.certificate2.end_level = 500
+        self.app['faculties']['fac1']['dep1'].certificates.addCertificate(
+            self.certificate2)
         return
 
@@ -190 +197 @@
             IStudentsUtils).STUDENT_BACKUP_EXPORTER_NAMES
         for name in STUDENT_BACKUP_EXPORTER_NAMES:
+            if name[-2:-1] == '_':
+                continue
             csv_path = os.path.join(del_dir, '%s.csv' % name)
             self.assertTrue(os.path.isfile(csv_path))
@@ -218 +227 @@
             IStudentsUtils).STUDENT_BACKUP_EXPORTER_NAMES
         for name in STUDENT_BACKUP_EXPORTER_NAMES:
+            if name[-2:-1] == '_':
+                continue
             csv_path = os.path.join(del_dir, '%s.csv' % name)
             self.assertTrue(os.path.isfile(csv_path))
@@ -223 +234 @@
             # We expect 3 lines output including a linebreak at end of file.
             self.assertEqual(len(contents), 3)
+        return
+
+    def test_backup_single_graduated_transferred_data(self):
+        del_dir = self.app['datacenter'].graduated_path
+        # when a single graduated student is removed, the data is backed up
+        # somewhere else including previous study courses
+        self.setup_student(self.student)
+        error = self.student.transfer(self.certificate2, current_session=2013)
+        self.assertTrue(error == None)
+        IWorkflowState(self.student).setState('graduated')
+        handle_student_removed(self.student, None)
+        # The previous study course data were put into CSV files
+        name = 'studentstudycourses_1'
+        csv_path = os.path.join(del_dir, '%s.csv' % name)
+        self.assertTrue(os.path.isfile(csv_path))
+        contents = open(csv_path, 'rb').read().split('\r\n')
+        # We expect 3 lines output including a linebreak at end of file.
+        self.assertEqual(len(contents), 3)
+        name = 'studentstudycourses_2'
+        csv_path = os.path.join(del_dir, '%s.csv' % name)
+        self.assertTrue(os.path.isfile(csv_path))
+        contents = open(csv_path, 'rb').read().split('\r\n')
+        # We expect only 2 lines output including a linebreak at end of file.
+        self.assertEqual(len(contents), 2)
+        name = 'studentstudylevels_1'
+        csv_path = os.path.join(del_dir, '%s.csv' % name)
+        self.assertTrue(os.path.isfile(csv_path))
+        contents = open(csv_path, 'rb').read().split('\r\n')
+        # We expect 3 lines output including a linebreak at end of file.
+        self.assertEqual(len(contents), 3)
+        name = 'coursetickets_1'
+        csv_path = os.path.join(del_dir, '%s.csv' % name)
+        self.assertTrue(os.path.isfile(csv_path))
+        contents = open(csv_path, 'rb').read().split('\r\n')
+        # We expect 3 lines output including a linebreak at end of file.
+        self.assertEqual(len(contents), 3)
         return