Changeset 8210

Timestamp:

19 Apr 2012, 06:02:16 (12 years ago)

Author:

Henrik Bettermann

Message:

Add first test to ensure that attributes are not cleared if cells are empty and that attributes are cleared if cells contain the deletion marker 'XXX'.

Location:

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

Files:

• sample_student_data.csv (modified) (1 diff)
• sample_student_data_update2.csv (modified) (1 diff)
• test_batching.py (modified) (1 diff)

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

@@ -1 +1 @@
 student_id,firstname,lastname,reg_number,date_of_birth,matric_number,email,phone,sex,reg_state
 X666666,Aaren,Pieri,1,1990-01-02,100000,aa@aa.ng,1234,m,courses validated
-,Aaren,Finau,2,1990-01-03,100001,aa@aa.ng,1234,m,courses validated
-,Aaren,Berson,3,1990-01-04,100002,aa@aa.ng,1234,m,courses validated
+,Claus,Finau,2,1990-01-03,100001,aa@aa.ng,1234,m,courses validated
+,Susann,Berson,3,1990-01-04,100002,aa@aa.ng,1234,f,courses validated
 ,Else,Mueller,4,1990-01-05,100003,aa@aa.ng,1234,f,courses registered

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

@@ -1 @@
-date_of_birth,matric_number
-1970-01-02,100000
-1970-01-03,100001
-1970-01-04,100002
+date_of_birth,matric_number,phone
+1970-01-02,100000,
+1970-01-03,100001,XXX
+1970-01-04,100002,

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

@@ -261 +261 @@
             self.csv_file_update2, STUDENT_HEADER_FIELDS_UPDATE2, 'update')
         self.assertEqual(num_warns,0)
+        # The phone import value of Pieri was None.
+        # Confirm that phone has not been cleared.
+        container = self.app['students']
+        for key in container.keys():
+            if container[key].firstname == 'Aaren':
+                aaren = container[key]
+                break
+        self.assertEqual(aaren.phone, '--1234')
+        # The phone import value of Claus was a deletion marker.
+        # Confirm that phone has been cleared.
+        for key in container.keys():
+            if container[key].firstname == 'Claus':
+                claus = container[key]
+                break
+        assert claus.phone is None
         shutil.rmtree(os.path.dirname(fin_file))