Changeset 8202 for main/waeup.kofa/trunk/src/waeup/kofa/applicants

Timestamp:

18 Apr 2012, 05:12:32 (12 years ago)

Author:

Henrik Bettermann

Message:

Empty If no value is provided in import files, attributes must not be cleared. Clear attribute only if value == DELETIONMARKER.

Location:

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

Files:

• sample_applicant_data.csv (modified) (1 diff)
• sample_applicant_data_update.csv (modified) (1 diff)
• sample_applicant_data_update2.csv (added)
• sample_faulty_applicant_data.csv (modified) (1 diff)
• test_batching.py (modified) (5 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/applicants/tests/sample_applicant_data.csv

@@ -1 @@
-container_code,reg_number,firstname,lastname,date_of_birth,email,course1,sex
-dp2011,1001,Aaren,Pieri,1990-01-02,xx@yy.zz,CERT1,m
-dp2011,1002,Aaren,Finau,1990-01-03,xx@yy.zz,CERT1,m
-dp2011,1003,Aaren,Berson,1990-01-04,xx@yy.zz,CERT1,m
+container_code,reg_number,firstname,lastname,date_of_birth,email,course1,sex,middlename
+dp2011,1001,Aaren,Pieri,1990-01-02,xx@yy.zz,CERT1,m,Peter
+dp2011,1002,Aaren,Finau,1990-01-03,xx@yy.zz,CERT1,m,Claus
+dp2011,1003,Aaren,Berson,1990-01-04,xx@yy.zz,CERT1,m,Alfons

main/waeup.kofa/trunk/src/waeup/kofa/applicants/tests/sample_applicant_data_update.csv

@@ -1 @@
-container_code,reg_number,firstname
-dp2011,1001,Aaren
-dp2011,1002,Alfons
-dp2011,1003,Abraham
+container_code,reg_number,firstname,middlename
+dp2011,1001,Aaren,
+dp2011,1002,Alfons,
+dp2011,1003,Abraham,

main/waeup.kofa/trunk/src/waeup/kofa/applicants/tests/sample_faulty_applicant_data.csv

@@ -1 @@
-container_code,reg_number,firstname,lastname,date_of_birth,email,course1,sex
-dp2011,1001,Aaren,Pieri,01/02/1990,xx@yy.zz,CERT1,m
+container_code,reg_number,firstname,lastname,date_of_birth,email,course1,sex,middlename
+dp2011,1001,Aaren,Pieri,01/02/1990,xx@yy.zz,CERT1,m,Claus

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

@@ -48 +48 @@
     '\n')[0].split(',')
 
-# The same for students
+# The same for applicants
 APPLICANT_SAMPLE_DATA = open(
     os.path.join(os.path.dirname(__file__), 'sample_applicant_data.csv'),
@@ -56 +56 @@
                  'sample_faulty_applicant_data.csv'), 'rb').read()
 
-
 APPLICANT_HEADER_FIELDS = APPLICANT_SAMPLE_DATA.split(
     '\n')[0].split(',')
@@ -63 +62 @@
     os.path.join(os.path.dirname(__file__),
                  'sample_applicant_data_update.csv'), 'rb').read()
+
+APPLICANT_SAMPLE_DATA_UPDATE2 = open(
+    os.path.join(os.path.dirname(__file__),
+                 'sample_applicant_data_update2.csv'), 'rb').read()
 
 APPLICANT_HEADER_FIELDS_UPDATE = APPLICANT_SAMPLE_DATA_UPDATE.split(
@@ -231 +234 @@
         self.csv_file_update = os.path.join(
             self.workdir, 'sample_applicant_data_update.csv')
+        self.csv_file_update2 = os.path.join(
+            self.workdir, 'sample_applicant_data_update2.csv')
         open(self.csv_file, 'wb').write(APPLICANT_SAMPLE_DATA)
         open(self.csv_file_faulty, 'wb').write(FAULTY_APPLICANT_SAMPLE_DATA)
         open(self.csv_file_update, 'wb').write(APPLICANT_SAMPLE_DATA_UPDATE)
+        open(self.csv_file_update2, 'wb').write(APPLICANT_SAMPLE_DATA_UPDATE2)
 
     def test_interface(self):
@@ -306 +312 @@
             self.csv_file_update, APPLICANT_HEADER_FIELDS_UPDATE, 'update')
         self.assertEqual(num_warns,0)
+        # The middlename import value was None.
+        # Confirm that middlename has not been deleted.
+        container = self.app['applicants']['dp2011']
+        for key in container.keys():
+            if container[key].lastname == 'Pieri':
+                applicant = container[key]
+                break
+        self.assertEqual(applicant.middlename, 'Peter')
+        shutil.rmtree(os.path.dirname(fin_file))
+        # Now we import another file which clears all middlename attributes.
+        num, num_warns, fin_file, fail_file = self.processor.doImport(
+            self.csv_file_update2, APPLICANT_HEADER_FIELDS_UPDATE, 'update')
+        self.assertEqual(num_warns,0)
+        assert applicant.middlename is None
         shutil.rmtree(os.path.dirname(fin_file))