Changeset 8289

Timestamp:

26 Apr 2012, 14:30:24 (13 years ago)

Author:

Henrik Bettermann

Message:

Add test for duplicate reg_numbers and matric_numbers.

Location:

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

Files:

• sample_student_data_duplicates.csv (added)
• test_batching.py (modified) (3 diffs)

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

@@ -81 +81 @@
     '\n')[0].split(',')
 
+STUDENT_SAMPLE_DATA_DUPLICATES = open(
+    os.path.join(os.path.dirname(__file__), 'sample_student_data_duplicates.csv'),
+    'rb').read()
+
+STUDENT_HEADER_FIELDS_DUPLICATES = STUDENT_SAMPLE_DATA_DUPLICATES.split(
+    '\n')[0].split(',')
+
 STUDYLEVEL_SAMPLE_DATA = open(
     os.path.join(os.path.dirname(__file__), 'sample_studylevel_data.csv'),
@@ -174 +181 @@
         self.csv_file_migration = os.path.join(
             self.workdir, 'sample_student_data_migration.csv')
+        self.csv_file_duplicates = os.path.join(
+            self.workdir, 'sample_student_data_duplicates.csv')
         open(self.csv_file, 'wb').write(STUDENT_SAMPLE_DATA)
         open(self.csv_file_update, 'wb').write(STUDENT_SAMPLE_DATA_UPDATE)
         open(self.csv_file_update2, 'wb').write(STUDENT_SAMPLE_DATA_UPDATE2)
         open(self.csv_file_migration, 'wb').write(STUDENT_SAMPLE_DATA_MIGRATION)
+        open(self.csv_file_duplicates, 'wb').write(STUDENT_SAMPLE_DATA_DUPLICATES)
 
     def tearDown(self):
@@ -321 +331 @@
         shutil.rmtree(os.path.dirname(fin_file))
 
+    def test_import_duplicate_data(self):
+        num, num_warns, fin_file, fail_file = self.processor.doImport(
+            self.csv_file_duplicates, STUDENT_HEADER_FIELDS_DUPLICATES)
+        content = open(fail_file).read()
+        self.assertEqual(num_warns,3)
+        self.assertEqual(
+            content,
+            'reg_number,firstname,student_id,sex,email,phone,state,date_of_birth,lastname,password,matric_number,--ERRORS--\r\n'
+            '1,Aaren,B123456,m,aa@aa.ng,1234,cleared,1990-01-03,Finau,mypw1,100001,reg_number: reg_number\r\n'
+            '2,Aaren,C123456,m,aa@aa.ng,1234,admitted,1990-01-04,Berson,mypw1,100000,matric_number: matric_number\r\n'
+            '1,Frank,F123456,m,aa@aa.ng,1234,,1990-01-06,Meyer,,100000,reg_number: reg_number; matric_number: matric_number\r\n'
+            )
+        shutil.rmtree(os.path.dirname(fin_file))
 
 class StudentStudyCourseProcessorTest(StudentImportExportSetup):